Subject RE: [firebird-support] ISQL behaviour different in windows and li nux
Author Helen Borrie
At 11:21 AM 16/12/2004 +1030, you wrote:

>In Linux only this works:
>
>isql localhost:employee -u 'user' -p 'pass' -i 'script'
>
>Without the server prefix, in Linux ISQL assumes that
>the db name is `employee` and the current directory
>is the location.
>
>If I replace the alias with the full path and filename,
>my Ant tasks work fine under both Windows and Linux,
>so I've decided to go down that path. Just following
>this up in case the inconsistency is worth fixing
>(not sure as it's very minor).

I doubt it's a "platform" issue but a matter of how firebird.conf in each
case has the DatabaseAccess parameter configured. If firebird.conf on both
servers is consistent, then both would be expected to respond
similarly. With DatabaseAccess = FULL (which I think is the default on
Windows), the client could access either by alias or by path. If
DatabaseAccess = NONE then access can only be through an alias. In the
middle is DatabaseAccess = RESTRICT followed by a list of paths to
filesystem roots - same as FULL but doesn't allowed db files to be either
created or accessed elsewhere.

If you're using the SS version of Fb 1.5, I would expect the security
options in firebird.conf to be the tightest, since it's our security guru
who is responsible for those builds. I'd put a dollar on his having set the
default to NONE :-)) (Don't have that build on board here to check...)

./hb