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
"PLG$USERS"
-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
> SEC$USERS`?

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 - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk