Subject Re: [firebird-support] Password problems
Author Helen Borrie
At 08:48 AM 10/09/2006, you wrote:
>Hello group,
>I installed FB 1.5.3 and used EMS SQL Manager (free version) to create
>a couple of databases with several tables each, and wrote a couple of
>apps for those dbs.
>A week later, EMS wouldn't let me connect to either db, complaining
>that the user/pw was wrong, and I needed to "ask my database
>administrator" for an account. However, I was on my laptop (XP), and
>had no idea what to do.
>So I uninstalled FB and reinstalled. That worked (using, of course,
>sysdba and masterke). Got some more work done. Now, another week
>later (ok, so you've detected that I'm working on these programs only
>on the weekends) and I cannot access either database. EMS says "Your
>user name and password are not defined. Ask your database
>administrator to set up a Firebird login." I get a similar complaint
>if I try to use gsec to connect.
>I'm totally lost. Haven't a clue why sysdba/masterke is no longer
>effective on either DB (I do recall changing the pw on one of them,
>but the first reinstall seemed to wipe that out, as I was again able
>to access it), and why the reinstall of FB no longer works.

The password applies at server level, not at database level. You are
going to get this refusal if

-- the username doesn't exist. (Well, SYSDBA does exist, so
hopefully we can eliminate that!)

-- you are passing the wrong password or no password

So, if you created the databases on Machine A, where the sysdba
password is 'rabbits' and then you copy them to Machine B, where the
sysdba password is 'masterke', then the password 'rabbits' is not
valid on Machine B.

So, first try connecting to one of the databases using
isql. Assuming Windows, open a command window and go to Firebird's
bin directory.

Type the command:

isql "c:\full\path\to\database\mydatabase.fdb" -user sysdba -password masterke

and hit Enter.

The isql shell should start. If you are connected, it will tell you
so, and you should then see the SQL> prompt. If you are not
connected, you'll see a different message:

Statement failed, SQLCODE = -902

Your user name and password are not defined. Ask your database
administrator to set up a Firebird login.
Use CONNECT or CREATE DATABASE to specify a database

What can you do if you have changed the sysdba password on the laptop
and can't remember the new password? Well, you *can* use gbak to
restore the backup of the "plain vanilla" security.fdb, that you will
find in Firebird's root dir.

Of course, if the real case is that you are doing all this stuff on
Linux, then 'masterke' is NOT in the picture at all. A random
password is generated by the installation script and placed in a text
file in /opt/firebird.