Alex,

Many thanks for your suggestion to look at ISC_USER. Yes this was set.
The script was set up with

export ISC_USER=SYSDBA
export ISC_PASSWORD=masterkey

I'm sure that used to be necessary - especially on Windows...

Investigating further, if ISC_USER is set or -user is passed on the
environment then security2.fdb is accessed while no access is made if
neither is set. So  a script that works with Firebird 2.1 does not work
with FIrebird 2.5 for this reason.

However, I was working with a C++ program that uses IBPP. IBPP complains
and gives you a LogicException if no user is given when it tries to
connect to the database. So Firebird 2.5 has broken IBPP if you try and
use it with the embedded server. Looks like a bug report for IBPP.

Tony Whyman
MWA



On 26/03/14 11:40, Alex Peshkoff wrote:
> On 03/26/14 14:41, Tony Whyman wrote:
>> Alex,
>>
>> My point is that isql like any user of libfbembeded must have r/w access
>> to the security database otherwise it will not run. This is independent
>> of whether or not you give the "-user" switch.
>>
> Tony, I checked once again, including check with strace to make sure - 
> there are no attempts to open security database if you do not have -user 
> switch (or set env. variable ISC_USER).
>
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/13534_NeoTech
> Firebird-Devel mailing list, web interface at 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel


------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to