Subject Re: [firebird-support] Very simple question...?
Author Tom Conrad
Is this the linux user 'firebird' or firebird user 'firebird'?

If you mean linux user...
I've got all the databases and executeables set to firebird:firebird
(owner:group) on my machine. 'chown -R firebird:firebird directory'
will change that.

If you mean firebird user...
Could security.fdb gotten overwritten during the upgrade? It is
normally in /opt/firebird. Can you access the database with SYSDBA?

Hope this helps.

Jan Bakuwel wrote:
> Hoi,
>
> I recently upgraded a server running Debian Sarge i386 (FB1.5.1) to
> Debian Testing x86_64 (FB1.5.3). Made a backup of the Firebird 1.5.1
> database with gbak, restored database on FB1.5.3. So far so good. I can
> use isql on the (root) command line to run selects on the database.
>
> However, the user firebird is no longer able to access the database.
> I've checked the file system permissions (obviously) and when I do:
>
> $ hd test.fdb | head
>
> as user firebird, I see a hex dump of the first bit of the database.
> So the user firebird has access to the file...
>
> Am I overlooking something really obvious?
>
> I suspect it has something to do with a (changed?) way of authentication
> between FB1.5.1 and FB1.5.3...
>
> cheers,
> Jan
>