At 05:07 p.m. 7/10/2015, Claudio Valderrama C. wrote:
>> -----Original Message-----
>> From: Helen Borrie [mailto:hele...@tpg.com.au] 
>> Sent: MiƩrcoles, 07 de Octubre de 2015 0:45
>> 
>> I wonder who is the "user" to which Windows is denying access 
>> everywhere except within Firebird's own root structure.  On 
>> my system, I am user 'helen', which is an administrator.  I 
>> seem to recall from some ancient discussion that the Firebird 
>> service runs under user 'localsystem'.  I don't know how that 
>> applies to Fb 2.5, though.
>
>I forgot that most people run FB as a service. :-)
>
>For what I understand the config should read
>DatabaseAccess = Restrict h:\externalfiles
>
>Can you have a peek at the permissions for that directory? Is SYSTEM listed
>among the authorized users? I would be bold and use
>SYSTEM -> Full Access

Not being bold, actually - SYSTEM has cascading full access on all my 
partitions.

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';

I'm certain this worked right in v.2.1.  And probably 2.5 on Linux.  I think 
Linux was the only platform where I had v.2.5 when I was testing the examples 
for TFB2e in 2013.  I might have had it on Windows XP at that time, too, I just 
don't remember.

It's only now, with reviewing the new Language Reference, that we are coming 
across a few "undocumented features".  I'm starting to wonder if this might be 
yet another one. 

Helen


------------------------------------------------------------------------------
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

Reply via email to