Subject Re: Problems with TempDirectories in firebird.conf?
Author peterson77
Thanks, Helen, it worked. The key was to add a /home/firebird
directory that was owned by firebird, then create the sorting
directory within it.

- Steve Peterson

--- In, Helen Borrie <helebor@t...>
> At 03:01 AM 31/08/2005 +0000, you wrote:
> >I must be forgetting something and hope that someone can point it
> >
> >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)
> 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
> (non-networked) connections to databases (as I think the
Jaybird "embedded"
> model does) then you will also need to have a firebird group, to
> firebird and your local uses must belong. Any permissions - such
as rwx
> permissions on directories - must then be applied to the group.
> ./heLen