Log in Register

Login to your account

Username *
Password *
Remember Me

Create an account

Fields marked with an asterisk (*) are required.
Name *
Username *
Password *
Verify password *
Email *
Verify email *
Captcha *

multiuser installation (windows) - Adjusting the default password (Firebird)

Article Index

Adjusting the default password (Firebird)

This is for the experienced user that has knowledge of database management.

This will change the default password in Firebird and FlameRobin. This will not change the Password to Open a Set of Books in TurboCASH multi-user.

To change the standard (default) password of the standard username, i.e. sysdba on the database server, you need to use the gsec program of Firebird (located in C:\Program Files\Firebird\Firebird_2_1\bin folder).

Once you have completed the standard installation of osFinancials / TurboCASH and the Firebird database server is completed, you may launch the gsec application (i.e. C:\Program Files\Firebird\Firebird_2_1\bin\gsec.exe).

You can control the users and their passwords. In the gsec application, you may access the security database, by executing the following task via Windows Menu Start->Run:

"C:\Program Files\Firebird\Firebird_2_1\bin\gsec.exe" -database "C:\Program Files\Firebird\Firebird_2_1\security.fdb" -user sysdba -password masterkey 

Or for the remote database

"C:\Program Files\Firebird\Firebird_2_1\bin\gsec.exe" -database "\Program Files\Firebird\Firebird_2_1\security.fdb" -user sysdba -password masterkey 

(Note you need to enter the correct IP-address of the remote database). If you need to change the standard (default) password (i.e. masterkey), you may enter the command as follows:

modify sysdba -pw mypassword 

This will set or change the master password to mypassword (as in this example).

Firebird can accommodate case sensitive passwords to the maximum of up to 8 characters. The rest of the characters (more than 8) is ignored when enterted (e.g. 10 character password mypassword). As per this 10 character password, you may enter up 8 characters, e.g. mypasswo, the last 2 characters will be ignored.

You may also add other users, and manage the user-rights over the database tables in TurboCASH. This is not covered in this documentation. You may find comprehensive information on the various commands and features at the Firebird website, i.e. http://www.firebirdsql.org/manual/.