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?
--
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/
