-----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 regards, Karol Bieniaszewski ------------------------------------------------------------------------------ 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
