Subject Re: [firebird-support] Problems with TempDirectories in firebird.conf?
Author Helen Borrie
At 03:01 AM 31/08/2005 +0000, you wrote:
>I must be forgetting something and hope that someone can point it out.
>When I changed the firebird.conf file to have:
> TempDirectories = /home/listpi/fbtemp 2000000000
>Firebird would not process searches anymore. Connections could be
>made, but it would not perform searches. I tried changing the
>permissions on the fbtemp file to root, to firebird, and to opening it
>up to all users, but nothing worked.
>I am running Firebird 1.5.2 classic on a Red Hat Linux box. Has
>anyone seen this before? What am I missing?
>Error message when a search is attempted:
>org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544344. I/O
>error during "open" operation for file ""

This will be a permissions problem. The user firebird (rightly) doesn't
have rw AND x permissions on the /home/listpi directory, but it needs them.

For simplicity, create a /home/firebird directory and make firebird its
owner; or a /tmp/firebird directory; and put your tempdirectories there,
rather than have firebird encroaching on another user's territory.

If you are using Classic and are working in processes that have direct
(non-networked) connections to databases (as I think the Jaybird "embedded"
model does) then you will also need to have a firebird group, to which
firebird and your local uses must belong. Any permissions - such as rwx
permissions on directories - must then be applied to the group.