This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:32 pm, [email protected] 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, [email protected] 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, [email protected] 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, [email protected] wrote: Thank you,it is a fine solution ! ------ On Mar 07, 2014 @ 03:32 pm, [email protected] 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<[email protected]> > To: [email protected] > 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, [email protected] 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, [email protected] 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, [email protected] 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]
