On 17/01/2019 16:27, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > On 17-1-2019 11:59, Lester Caine les...@lsces.co.uk [firebird-support] > wrote: >> On 17/01/2019 10:51, liviuslivius liviusliv...@poczta.onet.pl >> [firebird-support] wrote: >>> I suppose you have missed previous point at >>> https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-compat.html >>> >>> Look for >>> https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-compat-initsec.html >> >> "This initialization is not required and should NOT be performed if you >> have configured the server to use legacy (pre-Firebird 3 style) >> authentication and user management." >> >> So is that not the case? > > On Windows, you will only get that error if SRP authentication is > attempted while SRP has not been initialized in the security database. > > However, if I had to guess, it may be possible that the security > database in your install was not initialized for Legacy_Auth (on > Windows, the security database contains a default Legacy_Auth sysdba). > > It may be possible that you will first need to ensure that a legacy > authentication user is created to initialize the security database properly.
No windows in this equation, but I don't know what the SUSE install actually did. So where do I find out how to check this? It's created the crib for the legacy ... AH that must be an old one! SYSDBA.password is from August :( Right had to add firebird-examples to get employee database, and isql-fb is the right access package, but create user SYSDBA password 'SomethingCryptic'; gives me an add record error, so presumably SYSDBA already exists? At least I've altered the password, but I'm not getting a request to enter it when opening employee again ... Flamerobin knows if FB3 is running or not ... It can see the old databases but of cause they need updating to 12.0. I still remember when I could open old databases. I suppose the next thing to try is to restore one to see what isql-fb says ... except it's been years since I did that from the command line ... -- 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
