I tried it with localhost and got:

ISC ERROR CODE:335544351

ISC ERROR MESSAGE:
unsuccessful metadata update
A node name is not permitted in a table with external file definition
unassigned code

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Rick Debay
Sent: Friday, April 22, 2005 9:53 AM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Firebird external virtual tables on Linux


I'm already connected and manipulating the database, so the server name isn't required, and it's not in the syntax.

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Antonio Galicia
Sent: Thursday, April 21, 2005 4:44 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Firebird external virtual tables on Linux

On 4/21/05, Rick Debay <rdebay@...> wrote:

> Directory /opt/firebird/rxs_log is owned by user firebird and group
> firebird
>
> Firebird.conf:
> ExternalFileAccess = Restrict /opt/firebird/rxs_log
>
> SQL:
> RECREATE TABLE EXCEPTION_LOG
> EXTERNAL FILE '/opt/firebird/rxs_log/EXCEPTION_LOG'

How do you do the connection to firebird database? I mean, are you doing "server:/path/to/file.fbd" or "/path/to/file.fbd"?

With first string is the firebird user who make the connection, with the second is the user who login on the server who tries to make the connection and also that tries to create the file.

> Access to external file "/opt/firebirdSS-1.5.1/rxs_log/EXCEPTION_LOG"
> is denied by server administrator

Try "localhost:/path/to/file.fbd"

--
Saludos,
Toño
----
http://agc.com.mx/antoniogc/blog
http://www.petitiononline.com/obrador/petition.html



Yahoo! Groups Links










Yahoo! Groups Links