On 17/01/2019 18:40, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > On 17/01/2019 16:27, Mark rotteveelm...@lawinegevaar.nl > [firebird-support] wrote: >> On 17-1-2019 11:59, Lester caineles...@lsces.co.uk [firebird-support] >> wrote: >>> On 17/01/2019 10:51, liviusliviusliviusliv...@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 ...
This is getting annoying now ... gbak worked and I've got a new copy of the data ... isql-fb can access it and read the data ... but no request for a password. Access from PHP gives me fbird_connect(): Install incomplete, please read the Compatibility chapter in the release notes for this version So what can I do next to get this to work? -- 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