Subject Re: [firebird-support] gbak on classic server 1.5.4 (running on linux)
Author Helen Borrie
At 10:59 PM 11/10/2007, Richard Salt wrote:
>I have recently switched from using Firebird 1.5.4 super server to
>classic server in order to take advantage of new hardware with
>multi-core processors.
>
>This is my new setup: Firebird Classic Server 1.5.4 running on Redhat
>Enterprise Linux Server 5 on a quad core HP DL360 with 4GB ram.
>
>All is running fine, apart from one thing: when I try to restore
>databases using the following syntax,
>
>/opt/firebird/bin/gbak -c -r /home/data/mydb.fbk /home/data/mydb.fdb
>
>I get these errors:
>gbak: ERROR: I/O error for file ""
>gbak: ERROR: Error while trying to open file
>gbak: ERROR: no such file or directory
>gbak: ERROR: sort error
>gbak: ERROR: Exiting before completion due to errors
>
>On super server, I used to (sucessfully) use this syntax:
>/opt/firebird/bin/gbak -c -r /home/data/mydb.fbk
>localhost:/home/data/mydb.fdb
>
>I understand that, on classic, gbak will be running under the
>permissions of the user I am logged in as - which is root in my test
>cases. And I have experimented with the file permissions by changing
>from root ownership to firebird user ownership (which is what the
>fb_inet_server process runs as, but I am having no success.

When you use a local connection you don't use fb_inet_server, you use
an instance of the server embedded in the client (libfbembed.so) and
the process runs in the user space. When you connect to
fb_inet_server (via localhost or from a remote node) the process runs
as firebird user.


>Has anyone else come across this? What am I doing wrong?

Add any users that need to connect locally, e.g for backups and
gstat, to the firebird group. And, if root created your fbk file,
the firebird group won't be able to access it, so take care to su to
a member of the firebird group when you're going to create a backup
file. Of course, also make sure the group has rw permissions on the
backup file's directory...

Methinks you haven't found the release notes yet. Firebird's
"release notes" are more than that - they are a cumulative
manual. There's a whole section on installing on Linux, including
tips about getting the permissions right.

./hb