Subject Re: [firebird-support] moving of firebird 1.5.3 classic server
Author Helen Borrie
At 11:29 AM 6/05/2008, you wrote:
>I have tried to move our firebird 1.5.3 classic server (linux) to a
>new box. I have restored all the databases with no problems. From
>the linux box i can connect to the main database using isql but i
>cannot connect remotley. Firewall and selinux is currently turned
>off, i can ssh to the box no worries. From a command prompt on the
>box i can telnet localhost 3050 and that works fine, i can do a
>Netstat -an |grep 3050 and it tells me its listening. It may be a
>permissions problem somewhere because i get the following errors when
>i try to connect from ibexpert on a windwos xp client.
>
>**********************************************************************
>**********************************************************************
>Attempting to connect to:
>192.168.1.21:/ibdata/stock.gdb
>
>Connecting... Failed!
>------------------------------------
>Unsuccessful execution caused by a system error that precludes
>successful execution of subsequent statements.
>operating system directive open failed.
>Permission denied.
>
>Attempting to connect to services manager... Failed!
>------------------------------------
>
>Unsuccessful execution caused by a system error that precludes
>successful execution of subsequent statements.
>cannot attach to password database.
>
>Disconnecting from database... Passed!
>**********************************************************************
>**********************************************************************
>
>not sure where this permissions problem might be though

It could be. Make sure that your database file is in a directory for which the firebird group has rwx permissions and make sure the firebird group has rw permissions on the file itself. (Actually, I always chown database files to the firebird user.)

Note, you might need to create the firebird group if it doesn't exist, and besides the firebird user, include you own OS user in the group if you are going to do any local attaches to a database.

And don't forget that xinetd must be running for remote connections to work!

./helen