On 12/18/14 18:41, [email protected] wrote: > -----Oryginalna wiadomość----- > From: Alex Peshkoff > Sent: Thursday, December 18, 2014 12:19 PM > To: [email protected] > Subject: Re: [Firebird-devel] FB3 initializing security database with legacy > settings is impossible also changing password issue > > On 12/18/14 02:06, [email protected] wrote: >> Hi, >> >> if i set >> AuthClient = Legacy_Auth, Srp, Win_Sspi >> UserManager = Legacy_UserManager >> WireCrypt = Disabled >> >> then initializing security database not work at all >> gsec –user sysdba –password masterkey >> gsec add sysdba –pw xxx admin yes >> run without errors but change nothing >> >> when i try to login with flamerobin i get >> >> --------------------------- >> Unhandled Error in FlameRobin >> --------------------------- >> *** IBPP::SQLException *** >> Context: Database::Connect >> Message: isc_attach_database failed >> >> SQL Message : -902 >> Unsuccessful execution caused by a system error that precludes successful >> execution of subsequent statements >> >> 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 chapter "Initializing security database" >> in Quick Start Guide >> >> --------------------------- >> OK >> --------------------------- >> >> >> when i run gsec display i see: >> C:\Program Files\Firebird\Firebird_3_0>gsec -user sysdba -password >> masterkey >> GSEC> display >> user name uid gid admin full name >> -------------------------------------------------------------------------------- >> ---------------- >> SYSDBA 0 0 Sql Server >> Administrator >> >> >> when i set default config – all work ok – i can initialize sec database >> and after that when i can change config to legacy >> i can connect to database with masterkey pass >> >> but next when i try to change pass this not work at all >> gsec run without errors but change nothing >> i try also by sql “alter user” also run without error but change nothing >> >>> That's expected behavior - you use Legacy_UserManager, but do not change >>> AuthServer, which has default value = Srp. >>> BTW, when you use legacy authentication you need not initialize security >> .database - legacy login/password are present in it. > Hi, > > i used > AuthServer = Legacy_Auth > > without success > > Windowzs 2008R2 64 bit > FB64 bit
Will be more useful if you sent complete firebird.conf that doesn;t work for you. ------------------------------------------------------------------------------ Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
