[pkg-firebird-general] Database file ownership in classic server

Damyan Ivanov dam at modsoftsys.com
Mon Mar 12 21:18:57 CET 2007


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi, Aldo,

- -=| Aldo Caruso, 12.03.2007 19:20 |=-
>    While in the super server version the restored database belongs to
> firebird user and group, in the classic server version, the restored
> database belongs to the user who run gbak ( i.e. root ).
> 
>    The obvious solution was to do chown firebird:firebird <database file
> name> after restoring, but should'n gbak take care of that, as in the
> super-server version ?

When using super-server gbak, invoking "gbak db.fbk /path/to/db.fdb"
internally converts this to "gbak db.fbk localhost:/path/to/db.fdb",
meaning that the server process itself creates the database file. This
is not the case when using classic gbak, when the gbak itself creates
the file.

To achieve the same result with classic, explicitly add localhost: in
front of the path. Of course, this removes one of the greatest benefits
of classic - direct access to the database file (instead via tcp socket).

Classic is actually 2-in-1: server, implemented via
inetd/xinetd+fb_inet_server - acting as a "server" in the classical
sense that there are separate server and client processes; and embedded
- - when each "client" has direct access to the database files.

If you mix the two approaches, you have to take care of the caveats. :)


	dam
- --
Damyan Ivanov                           Modular Software Systems
phone +359(2)928-2611, 929-3993              fax +359(2)920-0994
mobile +359(88)856-6067              JID dam at jabber.minus273.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFF9bWwHqjlqpcl9jsRAgTIAKC7nDc2b0xgVj7c3wUMhGz8wb64LgCgjiXp
tH2OvQN7xrA9jZ2bCHoNdbw=
=y8eu
-----END PGP SIGNATURE-----



More information about the pkg-firebird-general mailing list