On 17/01/2019 20:36, Mark Rotteveel [email protected] [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
