Subject | Re: moving of firebird 1.5.3 classic server |
---|---|
Author | crizz11 |
Post date | 2008-05-06T02:29:12Z |
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...>
wrote:
firebird group has rw permissions on the file itself. (Actually, I
always chown database files to the firebird user.)
group if you are going to do any local attaches to a database.
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?
wrote:
>a
> At 11:29 AM 6/05/2008, you wrote:
> >I have tried to move our firebird 1.5.3 classic server (linux) to
> >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 ithe
> >cannot connect remotley. Firewall and selinux is currently turned
> >off, i can ssh to the box no worries. From a command prompt on
> >box i can telnet localhost 3050 and that works fine, i can do awhen
> >Netstat -an |grep 3050 and it tells me its listening. It may be a
> >permissions problem somewhere because i get the following errors
> >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!
>
>*********************************************************************
>*
>*********************************************************************
> >for which the firebird group has rwx permissions and make sure the
> >not sure where this permissions problem might be though
>
> It could be. Make sure that your database file is in a directory
firebird group has rw permissions on the file itself. (Actually, I
always chown database files to the firebird user.)
>exist, and besides the firebird user, include you own OS user in the
> Note, you might need to create the firebird group if it doesn't
group if you are going to do any local attaches to a database.
>to work!
> And don't forget that xinetd must be running for remote connections
>Database file is in directory that firebird group has rwx access to
> ./helen
>
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?