Subject | Re: [firebird-support] -923 error when connecting to database |
---|---|
Author | Norman Dunbar |
Post date | 2011-07-20T05:41:40Z |
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