Subject | Re: [firebird-support] -923 error when connecting to database |
---|---|
Author | Josh Aguilar |
Post date | 2011-07-21T00:08:02Z |
Thanks for the reply Norm.
I checked network traffic using a packet tracer and yes it is using TCP
port 3050. So I modified my iptables to allow traffic in and out that
port. However I'm still getting the same -923 error. After that, I tried
disabling my firewall but still got the same error.
I get the same error when I access the database using a web based GUI
Firebird db manager that I installed on the same machine. This web app
is even installed locally and should be able to access the database no
problem but for some reason it considers the web application as a remote
source???
I'm a bit stumped at the moment.
Cheers
Josh
I checked network traffic using a packet tracer and yes it is using TCP
port 3050. So I modified my iptables to allow traffic in and out that
port. However I'm still getting the same -923 error. After that, I tried
disabling my firewall but still got the same error.
I get the same error when I access the database using a web based GUI
Firebird db manager that I installed on the same machine. This web app
is even installed locally and should be able to access the database no
problem but for some reason it considers the web application as a remote
source???
I'm a bit stumped at the moment.
Cheers
Josh
On 20/07/11 15:41, Norman Dunbar wrote:
>
> Morning Josh,
>
> On 19/07/11 23:40, Josh Aguilar wrote:
> > ...
> > This only happens when I try to access the database remotely but if I
> > ssh into the remote machine and access the database using isql, it can
> > connect fine.
> >
> > I'm using Firebird 2.1 on a CentOS 5.5 machine.
> >
> > Any advice would be appreciated.
>
> Sounds a lot like you may have a firewall between you and the server.
> Ssh and Firebird don't use the same port for communication, so that may
> explain how you can ssh onto the box but not connect remotely.
>
> On the server, check the firebird.conf file
> (/opt/firebird/firebird.conf on my OpenSuse install) for this line:
>
> #RemoteServicePort = 3050
>
> If the line is still commented out as above, then you need to open port
> 3050 in your firewall, otherwise, open whatever port is indicated by the
> above line.
>
> HTH
>
> Cheers,
> Norm.
>
> --
> Norman Dunbar
> Dunbar IT Consultants Ltd
>
> Registered address:
> Thorpe House
> 61 Richardshaw Lane
> Pudsey
> West Yorkshire
> United Kingdom
> LS28 7EL
>
> Company Number: 05132767
>
>
[Non-text portions of this message have been removed]