Menu
I have firebird 1.5 super server installed on my windows 7 machine.
I am unable to use the Gsec utility to change the sysdba password for the default user.
The firebird service is running and I verified this several times.
When running gsec from a command prompt i receive this error unavailable database, unable to open database
The command i am using is the following gsec -user sysdba -pass masterkey -mo sysdba -pw whatever
Using a gui admin tool, i am able to change the password without issue and it apears to only be an issue when I try to run gsec directly.
I appreciate any advice.
978
If you have forgotten your SYSDBA password then you won't be able to update the server database, reset the RISINGSOFTWARE password etc. To resolve this then you can simply uninstall Firebird and reinstall. This is completely safe – it will NOT remove your database so you will NOT lose any data.
If the bin is on your path, you may start it by typing isql regardless of your operating system. Example: C:\Firebird_2_0\bin>isql Use CONNECT or CREATE DATABASE to specify a database SQL> CONNECT "C:\DATABASES\FIREBIRD\MY_EMPLOYEE. FDB" CON> user 'SYSDBA' password 'secret';
My NEW advice is to upgrade to firebird 2.1.4. I was able to solve my problem by running the firebird guardian as administrator. The following GSEC command then works: gsec -database "localhost:E:\tools\firebird2\security2.fdb" -user sysdba -pass masterkey -mo sysdba -pw newpass
My firebird is installed in E:\tools\firebird2 and newpass is the new passowrd.
Maybe running the guardian as administrator will work for 1.5 also.
So Uncle Bill is back in my good books, but I'll never forgive him for the evil that is the "windows registry" :-)
82
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
