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 firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> 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.
>
> ./heLen