On 11/15/13 11:43, Dmitry Yemanov wrote:
> 15.11.2013 11:29, Philippe Makowski wrote:
>> seems that some of lasts commits broke something
>> http://ci.ibphoenix.com/
> Am I right in detecting the reason as:
>
> # Your password can be changed to a more suitable one using the
> # /opt/firebird/bin/gsec utility.
> #
> + awk 'BEGIN { FS = "=" } ; { print $2 }'
> + grep ISC_PASSWD
> + sudo cat /opt/firebird/SYSDBA.password
> + sudo chmod 644 /tmp/temppassfile
> + cat /tmp/temppassfile
> Gd4DgQy+xbBoqALiRsVW
> + /opt/firebird/bin/gsec -user SYSDBA -fetch /tmp/temppassfile -modify
> SYSDBA -pw masterkey
> unable to open database
> Your user name and password are not defined. Ask your database
> administrator to set up a Firebird login.
> Build step 'Ex?cuter un script shell' marked build as failure
>
> ?
>
Seems to be here.
I have a very strong feeling that current password for sysdba is not
'Gd4DgQy+xbBoqALiRsVW'. Look here (server is started):
fbs bin # echo Gd4DgQy+xbBoqALiRsVW >pfl
fbs bin # ./gsec -user SYSDBA -pas masterkey -mod sysdba -pw `cat pfl`
fbs bin # ./gsec -user SYSDBA -pas masterkey -di
unable to open database
Your user name and password are not defined. Ask your database
administrator to set up a Firebird login.
fbs bin # ./gsec -user SYSDBA -fetch pfl -di
user name uid gid admin full name
------------------------------------------------------------------------------------------------
SYSDBA 0 0
QA_USER1 0 0
QA_USER2 0 0
QA_USER3 0 0
QA_USER4 0 0
QA_USER5 0 0
GUEST 0 0
SHUT1 0 0
SHUT2 0 0
QATEST 0 0
fbs bin # ./gsec -user SYSDBA -fetch pfl -mod sysdba -pw masterkey
fbs bin # ./gsec -user SYSDBA -fetch pfl -di
unable to open database
Your user name and password are not defined. Ask your database
administrator to set up a Firebird login.
fbs bin # ./gsec -user SYSDBA -pas masterkey -di
user name uid gid admin full name
------------------------------------------------------------------------------------------------
SYSDBA 0 0
QA_USER1 0 0
QA_USER2 0 0
QA_USER3 0 0
QA_USER4 0 0
QA_USER5 0 0
GUEST 0 0
SHUT1 0 0
SHUT2 0 0
QATEST 0 0
Earlier embedded access to database worked for you, now it fails due to
lingered security database.
If you want to change password to masterkey, the simplest way at install
time is to _stop_ server and run:
/opt/firebird/bin/gsec -user sysdba -pas dummy -mod sysdba -pw masterkey
You need to set dummy password only to make gsec happy - it has a
strange feature making it silently ignore -user if no -pas is specified.
Plan to fix it.
A.
------------------------------------------------------------------------------
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
