Subject Re: [firebird-support] sysdba password
Author Fidel Viegas
On Mon, Dec 29, 2008 at 6:24 PM, Fidel Viegas <fidel.viegas@...> wrote:
> On Mon, Dec 29, 2008 at 6:05 PM, Sergio H. Gonzalez
> <shg_sistemas@...> wrote:
>> Hello, I'm trying to change the sysdba password like this
>>
>> C:> bin\gsec -database security2.fdb -mo sysdba -pw MyNewPass -user sysdba
>> -pass
>> masterkey
>>
>> I'm running this command in a BAT file that is in the
>> C:\Archiv~1\Firebird\Firebird_2_1 folder.
>>
>> This is what I get:
>>
>> Warning - maximun 8 significant bytes of password used
>> I/O error for file "security2.fdb"
>> Error while trying to open file
>> El sistema no puede hallar el archivo especificado
>>
>> The last line, I guess is a messagge from Windows, and reads "System can't
>> find
>> specified file"
>>
>> What I'm doing grong?
>
> To change the password you should get rid of the -database switch. Just do:
>
> c:>bin\gsec -mo sysdba -pw MyNewPassWord -user sysdba -password masterkey
>
> Fidel
>

I forgot to mention that this is if you are changing the password from
your local machine. If you want to change on a remote computer, then
you provide the database but not just the name as you are providing.
here is how:

gsec -user sysdba -password masterkey -database
yourhost/3051:/path/to/security2.fdb" -modify sysdba -pw newpassword

All the best,

Fidel.