Hi Thomas, I understand, I think I've done it 3 times before adding the password at the end, I will try the hole thing again in a new environment and come back with the log so we are sure we got this on nailed down.
Cheers, Fabian ----- Original Message ----- From: 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] To: firebird-support@yahoogroups.com Sent: Tuesday, June 14, 2016 4:17 PM Subject: Re: [firebird-support] FB 3 - Adding anew User Hello Fabian, > Sorted after reading "Initializing the Security Database" from > http://www.firebirdsql.org/file/documentation/release_notes/Firebird-3.0.0-ReleaseNotes.pdf > at page 116. I think there is a small error on the documentation, where it says > " isql -user sysdba employee", the sentence works probably on Linux but on Ms > WIn 2012 Server R2 it requires the password to run. You need to shutdown every running regular Firebird server process, otherwise you won't end up in an Firebird 3.0 Embedded connection, which is needed if you want to initialize your 3.0 security database in SRP mode. -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > > Cheers, > Fabian > > ----- Original Message ----- > From: fabia...@itbizolutions.com.au [firebird-support] > To: firebird-support@yahoogroups.com > Sent: Monday, June 13, 2016 4:34 AM > Subject: [firebird-support] FB 3 - Adding anew User > > > > > > Hi All, > > I have configured the FB 3 server to only accept SRP connections and need to > add a new User to the security DB, I read GSEC is not the way, and I have > tried with isql but for some reason I am not having luck, I am trying the > following: > > > > I created a script into a file as follows: > > SET SQL DIALECT 3; > SET NAMES UTF8; > SET CLIENTLIB 'C:\Temp\FB32Bits\fbclient.dll'; (this dll is 32 bits dll, but > the server is 64 bits, and I use the 32 bits dll because IBexpert is 32 bits) > > CONNECT '127.0.0.1/3050:My_New_DB_Configured_Properly_in_Databases.conf' USER > 'SYSDBA' PASSWORD 'NewPassNotMasterkey'; > > CREATE USER NUCLEUSCRM PASSWORD 'WhateverPassword' ; > > COMMIT work ; > > > The above fails when executed from IBExpert script executive, the error is: > > "Unsuccessful execution caused by a system error that precludes successful > execution of subsequent statements. > Your user name and password are not defined. Ask your database administrator > to set up a Firebird login." > > Its funny because IBexpert is connecting fine to the DB, and the following > config is in place: > > AuthServer = Srp > AuthClient = Srp > UserManager = Srp > > > So the only way to connect is with the new security model, and IBExpert is > connecting when restoring the DB, but when running script into the DB > something does not work. Any ideas? > > > > Cheers, > Fabian > > > > > > > ------------------------------------ Posted by: "Thomas Steinmaurer" <t...@iblogmanager.com> ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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
