Subject Re: moving of firebird 1.5.3 classic server
Author crizz11
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...>
wrote:
>
> 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
>
Database file is in directory that firebird group has rwx access to
and has rw permissions on the files inside that directory. Have also
as suggested changed ownership of the database files to firebird user.

Firebird group already exists and root is already a member.

xinetd is running.

Is it ok to just copy the security.fdb file across from the original
server, or should i do a backup and restore of this file?