Subject Problems with TempDirectories in firebird.conf?
Author peterson77
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 ""
Error while trying to open file
null
at
org.firebirdsql.jdbc.AbstractStatement.executeQuery(AbstractStatement.java:167)
at com.frontier.sql.JDBCQuery.refresh(JDBCQuery.java:96)
at com.frontier.sql.JDBCQuery.executeSQL(JDBCQuery.java:66)
at com.frontier.sql.BasicQuery.setExecuteSQL(BasicQuery.java:101)
at com.frontier.sql.BasicQuery.executeSQL(BasicQuery.java:71)
at com.frontier.sql.Security.fetchEntitySet(Security.java:319)
at
com.frontier.sql.AbstractEntityHome.fetchEntitySet(AbstractEntityHome.java:68)
at
com.frontier.cbase.business.BasicSite.loadAllAccounts(BasicSite.java:435)
at com.frontier.cbase.business.BasicSite.initialize(BasicSite.java:646)
at com.frontier.cbase.controller.Startup.init(Startup.java:55)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:935)
at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:823)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3421)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3609)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:738)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347)
at
org.apache.catalina.core.StandardService.start(StandardService.java:497)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:2190)
at org.apache.catalina.startup.Catalina.start(Catalina.java:512)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:400)
at org.apache.catalina.startup.Catalina.process(Catalina.java:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)