Hi,

I am having trouble using external tables on a red hat linux 9
machine. I am using firebird 1.5 classic final release.

I have edited the firebird.conf to allow external file access:
ExternalFileAccess = Full

I log on as SYSDBA, connect to the database alias, and try to create
the external table:
create table broadext
EXTERNAL FILE '/home/listpi/junk/broad.ext' (
BROADID INTEGER NOT NULL
, ACCOUNTID INTEGER NOT NULL
, SENDDATE TIMESTAMP NOT NULL
, MESSAGEID INTEGER NOT NULL
, SENDCOUNT INTEGER
, BROADSTAT VARCHAR( 10 ) NOT NULL
, BROADTYPE CHAR( 1 ) NOT NULL
, TARGETDOC BLOB( 65535, 1 ) NOT NULL
);


But I get the error:
Statement failed, SQLCODE = -902
I/O error for file "/home/listpi/junk/broad.ext"
-Error while trying to open file
-Permission denied

I have made the /home/listpi/junk directory owned by the firebird
user and for good measure give everyone complete read/write/execute
permissions.

Am I missing something?

- Steve