On 12/22/14 01:19, [email protected] wrote: > -----Oryginalna wiadomość----- > From: Alex Peshkoff > Sent: Thursday, December 18, 2014 4:48 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 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. > Hi, > > i used zip install of FB3 snapshot > and in config i change only this > > AuthClient = Legacy_Auth, Srp, Win_Sspi > UserManager = Legacy_UserManager > WireCrypt = Disabled > AuthServer = Legacy_Auth > DefaultDbCachePages = 65536 >
Do you connect from this box or another? With such configuration I see no problems when connecting from this box, but I can reproduce an error when connecting from another box with default config. ------------------------------------------------------------------------------ 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
