On 17/01/2019 20:13, Lester Caine [email protected] [firebird-support] wrote: > On 17/01/2019 19:34, Dimitry Sibiryakov [email protected] > [firebird-support] wrote: >> 17.01.2019 20:11, Lester [email protected] [firebird-support] wrote: >>> So what can I do next to get this to work? >> You can read Release Notes for Firebird 3.0, chapter "Compatibility >> Issues" including >> "Embedded Connections" and "Initializing Security Database". >> Also reading text of "an add record error" can provide a clue. >> Remember, that in embedded mode password is not checked, but user name >> is still >> applied, so you must use "-u SYSDBA" when connecting to a database for >> creating SYSDBA >> user (sounds funny, I know). > > Personally I would rather NOT have the Embedded Connection insecurity > but that side of things is working and I have a restored database. > > Given the 'Important' notice on the top of the 'Initializing the > Security Database' I skipped to the next section, and the various > changes have been made. And I think are right. > > Now I'm being told that perhaps the legacy user has not been set, but > now I can run the scripts on 'Initializing the Security Database' > > create user SYSDBA password 'SomethingCryptic'; > gives > 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') > > WHAT am I not reading here?
Just to complete what I CAN do Flamerobin is giving Engine Code : 335544472 Engine Message : Your user name and password are not defined. Ask your database administrator to set up a Firebird login. Install incomplete, please read the Compatibility chapter in the release notes for this version -- 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 ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
