Hoi Tom,

Thanks for your answer.

I was referring to the Linux user 'firebird'. Permissions are all OK.
Meanwhile I've noticed that the lock manager crashes... I guess I may be
better off starting to have a look at FB2. Couldn't compile it though
because there's a broken package ref on Debian Testing for x86_64...

Maybe I need to stick with 32bit for a little longer...

cheers,
Jan

Tom Conrad wrote:

> 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
>>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>

--

'A society of sheep must in time beget a government of wolves.'
-- Bertrand de Jouvenal

----

Electronic Technology Coordinator
Ships Unit
Greenpeace International
Ottho Heldringstraat 5
1066 AZ AMSTERDAM
Netherlands (MET)

direct +31 (0)20 7182084
fax +31 (0)20 5148151
reception +31 (0)20 5148150
email jan.bakuwel&int.greenpeace.org
private jan.bakuwel&hccnet.nl
(replace & by @ in the emailaddress)