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. ------------------------------------------------------------------------------ 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
