Subject | Re: [firebird-support] Deploy firebird with another password for sysdba user |
---|---|
Author | Mr. John |
Post date | 2011-11-14T09:05:48Z |
That is working from inside NSIS installer:
ExecWait 'gsec -user sysdba -password masterkey -modify SYSDBA -pw mypassword'
________________________________
From: Mr. John <mr_johnmr@...>
To: "firebird-support@yahoogroups.com" <firebird-support@yahoogroups.com>
Sent: Monday, November 14, 2011 10:59 AM
Subject: Re: [firebird-support] Deploy firebird with another password for sysdba user
Thank you,it is a fine solution !
________________________________
From: Thomas Steinmaurer <ts@...>
To: firebird-support@yahoogroups.com
Sent: Monday, November 14, 2011 10:38 AM
Subject: Re: [firebird-support] Deploy firebird with another password for sysdba user
the installation (in the background). Check out the gsec manual here:
http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gsec.html
--
With regards,
Thomas Steinmaurer
* Upscene Productions - Database Tools for Developers
http://www.upscene.com/
* My Blog
http://blog.upscene.com/thomas/index.php
* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/
[Non-text portions of this message have been removed]
ExecWait 'gsec -user sysdba -password masterkey -modify SYSDBA -pw mypassword'
________________________________
From: Mr. John <mr_johnmr@...>
To: "firebird-support@yahoogroups.com" <firebird-support@yahoogroups.com>
Sent: Monday, November 14, 2011 10:59 AM
Subject: Re: [firebird-support] Deploy firebird with another password for sysdba user
Thank you,it is a fine solution !
________________________________
From: Thomas Steinmaurer <ts@...>
To: firebird-support@yahoogroups.com
Sent: Monday, November 14, 2011 10:38 AM
Subject: Re: [firebird-support] Deploy firebird with another password for sysdba user
> Thanks Helen and Thomas for answers.Yes, automatically in a sense to run Firebird's 'gsec' utility during
> Is it a way to change the password automatically,not manually,that I should do with my application install.
the installation (in the background). Check out the gsec manual here:
http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gsec.html
--
With regards,
Thomas Steinmaurer
* Upscene Productions - Database Tools for Developers
http://www.upscene.com/
* My Blog
http://blog.upscene.com/thomas/index.php
* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/
> Thanks[Non-text portions of this message have been removed]
>
>
>
> ________________________________
> From: Helen Borrie<helebor@...>
> To: firebird-support@yahoogroups.com
> Sent: Monday, November 14, 2011 10:22 AM
> Subject: Re: [firebird-support] Deploy firebird with another password for sysdba user
>
>
>
> At 08:37 PM 14/11/2011, Mr. John wrote:
>> Hi ! We need to deploy firebird server with another password for sysdba user.
>> One solution is replacing security2.fdb during install of our application+server.
>>
>> Is it good solution ?
>
> It's not a solution.
>
> Change the SYSDBA password on the installation of the server at the site where you deploy it. Or, if you have regular users in *your* copy of security2.fdb that have permissions in the database (as you SHOULD have) then back up yours and restore it as sometempname.fdb on the new site.
>
> Then, shut down Firebird, delete the installation copy of security2.fdb, rename the sometempname.fdb version to security2.fdb and then change the SYSDBA password *before* doing anything else.
>
> ./hb
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
[Non-text portions of this message have been removed]