Subject Re: [firebird-support] Falling at second hurdle ...
Author Lester Caine
On 17/01/2019 20:36, Mark Rotteveel mark@...
[firebird-support] wrote:
>> WHAT am I not reading here?
> I'd suggest to explicitly specify the user manager plugin you want to
> use instead of leaving it to the specific configuration (doing this will
> also detect problems if an expected user manager is not installed or not
> the first in the list).
> Eg, use
> create user sysdba password '..' using plugin Legacy_UserManager;
Statement failed, SQLSTATE = 23000
add record error
-violation of PRIMARY or UNIQUE KEY constraint "INTEG_2" on table
-Problematic key value is ("PLG$USER_NAME" = 'SYSDBA')

> Note: this requires that specified plugin is listed in the UserManager
> config in firebird.conf.
WireCrypt = Disabled
AuthServer = Legacy_Auth, Srp, WinSspi
AuthClient = Legacy_Auth, Srp, Win_Sspi
UserManager = Legacy_UserManager

> Also, what is the output of `select SEC$USER_NAME, SEC$PLUGIN from
Got two users currently
SYSDBA Legacy_UserManager
LSCES Legacy_UserManager

AH ... strip the unused modes ...
AuthServer = Legacy_Auth
AuthClient = Legacy_Auth
And I can access it from Flamerobin on the development machine.

But PHP gives
fbird_connect(): Incompatible wire encryption levels requested on client
and server
That is PHP on the same machine as FB3

Lester Caine - G8HFL
Contact -
L.S.Caine Electronic Services -
EnquirySolve -
Model Engineers Digital Workshop -
Rainbow Digital Media -