Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-09 Thread Alex Peshkoff
On 10/09/2015 08:07 PM, Dmitry Yemanov wrote: > 09.10.2015 19:11, Paul Vinkenoog wrote: >> So all in all, it's probably best to keep it as you have it now: 'Use of >> external file at location /path/to/filename.ext is not allowed by server >> configuration' > This gets my vote. +1

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-09 Thread Dmitry Yemanov
09.10.2015 19:11, Paul Vinkenoog wrote: > > So all in all, it's probably best to keep it as you have it now: 'Use of > external file at location /path/to/filename.ext is not allowed by server > configuration' This gets my vote. Dmitry

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-09 Thread Dimitry Sibiryakov
09.10.2015 18:11, Paul Vinkenoog wrote: > So all in all, it's probably best to keep it as you have it now: 'Use of > external file at location /path/to/filename.ext is not allowed by server > configuration' May I suggest message 'Use of external file at this location is not allowed by server

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-09 Thread Paul Vinkenoog
Hi Alex, >> But I would drop the database name from the first message and only mention >> the directory path, a) because that's the location, and b) for consistency >> between DatabaseAccess and ExternalFileAccess. > Sorry, in external file access it's also filename here, I've just typed > it w

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-09 Thread Alex Peshkoff
On 10/09/2015 06:14 PM, Paul Vinkenoog wrote: > Hi Alex, > May it be single text "Use of external table file at specified location is not allowed by server configuration" ? >>> Sure, it's less specific but better than what we have now. >> After changes I get (with private src) the followi

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-09 Thread Paul Vinkenoog
Hi Alex, > >> May it be single text "Use of external table file at specified location > >> is not allowed by server configuration" ? > > Sure, it's less specific but better than what we have now. > > After changes I get (with private src) the following messages: > > Use of database at location /mn

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-09 Thread Alex Peshkoff
On 10/08/2015 07:41 PM, Paul Vinkenoog wrote: > Alex Peshkoff wrote: > >>> Ideally (if it's not too much work), the message should be something like >>> "The use of external tables is not allowed in the current configuration" >>> when EFA is None, and "The specified external table path does not b

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-08 Thread Paul Vinkenoog
Alex Peshkoff wrote: > > Ideally (if it's not too much work), the message should be something like > > "The use of external tables is not allowed in the current configuration" > > when EFA is None, and "The specified external table path does not belong to > > an allowed directory tree" when it

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-08 Thread Alex Peshkoff
On 10/07/2015 10:50 PM, Paul Vinkenoog wrote: > Helen Borrie wrote: > I think the "Access to external file X is denied by server administrator" message could be improved, as it suggests a specific ban on this particular file. And of course the instructions in firebird.conf itself.

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-07 Thread Paul Vinkenoog
Helen Borrie wrote: >>> I think the "Access to external file X is denied by server administrator" >>> message could be improved, as it suggests a specific ban on this particular >>> file. And of course the instructions in firebird.conf itself. > 1. Text for the message: > "Directory path for e

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-07 Thread Helen Borrie
At 01:06 a.m. 8/10/2015, Alex Peshkoff wrote: >On 10/07/2015 02:59 PM, Paul Vinkenoog wrote: >> Helen Borrie wrote: >> ExternalFileAccess = Restrict 'ExternalFiles'; >>> OK, so now I changed this to: >>> >>> ExternalFileAccess = Restrict h:\databases\externalfiles; >>> >>> -- and it works. >>

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-07 Thread Claudio Valderrama C.
> -Original Message- > From: Helen Borrie [mailto:hele...@tpg.com.au] > Sent: Miércoles, 07 de Octubre de 2015 5:29 > > 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

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-07 Thread Paul Vinkenoog
Alex wrote: > > I think the "Access to external file X is denied by server administrator" > > message could be improved, as it suggests a specific ban on this particular > > file. And of course the instructions in firebird.conf itself. > > Paul, taking into an account that it was written by non-

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-07 Thread Dimitry Sibiryakov
07.10.2015 14:06, Alex Peshkoff wrote: > Paul, taking into an account that it was written by non-native english > speaker it's more than possible. Can you suggest a better text? Text is irrelevant. Just remove apostrophes from examples of patch and/or write example with full syntax. -- W

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-07 Thread Alex Peshkoff
On 10/07/2015 02:59 PM, Paul Vinkenoog wrote: > Helen Borrie wrote: > >>> ExternalFileAccess = Restrict 'ExternalFiles'; >> OK, so now I changed this to: >> >> ExternalFileAccess = Restrict h:\databases\externalfiles; >> >> -- and it works. > Ha - sorry I didn't see your original post earlier. I ha

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-07 Thread Paul Vinkenoog
Helen Borrie wrote: > >ExternalFileAccess = Restrict 'ExternalFiles'; > > OK, so now I changed this to: > > ExternalFileAccess = Restrict h:\databases\externalfiles; > > -- and it works. Ha - sorry I didn't see your original post earlier. I had the same problem last week and it drove me half cra

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-07 Thread Alex Peshkoff
On 10/07/2015 11:29 AM, Helen Borrie wrote: > 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), CRL

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-07 Thread Michal Kubecek
On Wed, Oct 07, 2015 at 09:29:12PM +1300, Helen Borrie wrote: > > Does anyone have a 2.5.4 on Linux nearby, to test this: > > ExternalFileAccess = Restrict /whatever/externalfiles > ... Works for me (2.5.4 with few selected post-2.5.4 patches), directive was ExternalFileAccess = Restrict /sr

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-07 Thread Helen Borrie
At 09:10 p.m. 7/10/2015, Paul Reeves wrote: >On Wednesday 07 Oct 2015 14:57:48 Helen Borrie wrote: >> >> ExternalFileAccess = Restrict 'H:\externalfiles'; >> (tried it with and without the semicolon) >> > >Is h: a mapped networked drive or is it local to the host? Local partition. Mapped drives

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-07 Thread Helen Borrie
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

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-07 Thread Paul Reeves
On Wednesday 07 Oct 2015 14:57:48 Helen Borrie wrote: > > ExternalFileAccess = Restrict 'H:\externalfiles'; > (tried it with and without the semicolon) > Is h: a mapped networked drive or is it local to the host? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-07 Thread Helen Borrie
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

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-06 Thread Claudio Valderrama C.
> -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

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-06 Thread Helen Borrie
At 03:25 p.m. 7/10/2015, Claudio Valderrama C. wrote: >> -Original Message- >> From: Helen Borrie [mailto:hele...@tpg.com.au] >> Sent: Martes, 06 de Octubre de 2015 22:58 >> >> Configuring ExternalFileAccess with Restrict in v.2.5.4 SS on >> Win7 doesn't seem to work properly. Full does

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-06 Thread Claudio Valderrama C.
> -Original Message- > From: Helen Borrie [mailto:hele...@tpg.com.au] > Sent: Martes, 06 de Octubre de 2015 22:58 > > Configuring ExternalFileAccess with Restrict in v.2.5.4 SS on > Win7 doesn't seem to work properly. Full does work; None > (the default) works. Restrict seems not to

[Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-06 Thread Helen Borrie
Configuring ExternalFileAccess with Restrict in v.2.5.4 SS on Win7 doesn't seem to work properly. Full does work; None (the default) works. Restrict seems not to work as documented in firebird.conf. RECREATE TABLE EXT_LOG EXTERNAL FILE 'h:\externalfiles\test1.txt' ( STAMP CHAR(24), MES