At 08:45 p.m. 7/10/2015, Helen Borrie wrote:
>>For what I understand the config should read
>>DatabaseAccess = Restrict h:\externalfiles
....
>As to the format - copy/pasting from firebird.conf:
>
>"# ----------------------------
># External File Paths/Directories
>#
># ExternalFileAccess may be None, Full or Restrict. If you choose
># Restrict, provide ';'-separated trees list, where external files
># are stored. Relative paths are treated relative to RootDirectory entry
># (see above). Default value 'None' disables any use of external files
># on your site. To specify access to specific trees, enum all required
># paths (for Win32 this may be something like 'C:\ExternalTables',
># for unix - '/db/extern;/mnt/extern').
>#
>Hence the single-quotes. And here is the current configuration, which works:
>#
>ExternalFileAccess = Restrict 'ExternalFiles';
OK, so now I changed this to:
ExternalFileAccess = Restrict h:\databases\externalfiles;
-- and it works.
IOW, in Fb 2.5, you can't use the single-quoting UNLESS you are setting a
directory in Firebird's root. I won't document this as a rule yet as it seems
like a bug (doesn't work as documented; inconsistency).
Does anyone have a 2.5.4 on Linux nearby, to test this:
ExternalFileAccess = Restrict /whatever/externalfiles
-- create external table
recreate table ext_log external file '/whatever/log_me.txt'
(stamp char(24), message char(100), CRLF char(2));
commit;
-- trigger to autofill some fields
recreate trigger bi_ext_log for ext_log
active before insert
as
begin
if (new.stamp is null) then
begin
new.stamp = cast (current_timestamp as char(24));
new.crlf = ascii_char(13) || ascii_char(10);
-- take out the ascii_char(13) || if you want to
end
end
commit;
--insert some data
insert into ext_log (message) values('Shall I compare thee to a summer''s day?
Thou art more lovely and more temperate.')
insert into ext_log (message) values('Rough winds do shake the darling buds of
May And summer''s lease hath all too short a date.')
------------------------------------------------------------------------------
Full-scale, agent-less Infrastructure Monitoring from a single dashboard
Integrate with 40+ ManageEngine ITSM Solutions for complete visibility
Physical-Virtual-Cloud Infrastructure monitoring from one console
Real user monitoring with APM Insights and performance trend reports
Learn More http://pubads.g.doubleclick.net/gampad/clk?id=247754911&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
