This is a notification from the Help Desk.

On Mar 07, 2014 @ 03:32 pm, luc@... wrote:
Am 14.11.2011 10:05, schrieb Mr. John:
> That is working from inside NSIS installer:
>
> ExecWait 'gsec -user sysdba -password masterkey -modify SYSDBA -pw mypassword'
>

Remember to check this with different OS.
Under 2003/2008 you usually also have to add the security database as a
parameter (local protocol won't work).

Something like:
gsec -database localhost:"C:\Program Files\Firebird\security.fdb"


Luc.


==Ticket History==

On Mar 07, 2014 @ 03:32 pm, ts@... wrote:
> That is working from inside NSIS installer:
>
> ExecWait 'gsec -user sysdba -password masterkey -modify SYSDBA -pw mypassword'

Good! ;-)


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

------
On Mar 07, 2014 @ 03:32 pm, mr_johnmr@... wrote:
That is working from inside NSIS  installer:

 ExecWait 'gsec -user sysdba -password masterkey -modify SYSDBA -pw mypassword'

------
On Mar 07, 2014 @ 03:32 pm, mr_johnmr@... wrote:
Thank you,it is a fine solution !

------
On Mar 07, 2014 @ 03:32 pm, ts@... wrote:
> Thanks Helen and Thomas for answers.
> Is it a way to change the password automatically,not manually,that I should do with my application install.

Yes, automatically in a sense to run Firebird's 'gsec' utility during
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
>
>
>
> ________________________________
> 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
>
>
>

------
On Mar 07, 2014 @ 03:32 pm, mr_johnmr@... wrote:
Thanks Helen and Thomas for answers.
Is it a way to change the password automatically,not manually,that I should do with my application install.

Thanks

------
On Mar 07, 2014 @ 03:32 pm, ts@... 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 ?
> Thanks !

In addition what Helen said. Also don't use SYSDBA as owner for
databases, database objects like tables, views etc ... Use your own
Firebird user for that. Makes it much easier when deploying at an
existing server installation with possibly no permission for getting
SYSDBA-like information.


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

------
On Mar 07, 2014 @ 03:32 pm, mr_johnmr@... 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 ?
Thanks !


[Non-text portions of this message have been removed]

------
This is an automated response. Your issue has been noted. We'll be in touch soon.



Please reply to this email or visit the URL below with any additional details.

http://DANTOIN:9675/portal/view-help-request/402




[Non-text portions of this message have been removed]