Subject User/Password not working ???
Author Michael Horne
Hello,

Just a few days ago, a program that was working
stopped being able to connect to the test DB on
my computer. With further testing I found that
the only user that could connect to a DB on
my computer was SYSDBA.

It is strange what happens also.

1. Connect with SYSDBA/MASTERKEY - works fine

2. Connect with User1/Pass1x - a invalid pass
response of: "your username and password are
not defined..."

3. Connect with User1/Pass1 - a valid user/pass
response of: "database TestDB shutdown"

-------
Things I have tried:
1. This was working 4 days ago.
2. Uninstalled all firebird, deleted isc4.gdb...
3. reboot
4. Installed newest version of firebird
5. Can connect fine with sysdba
6. Added new users tried to connect - same problem as above
7. Tried using gfix to test this incase it was
a problem with the program I was using to connect:

gfix -validate c:\test\testdb.gdb -user sysdba -password masterkey
---- works fine

gfix -validate c:\test\testdb.gdb -user user1 -password pass1x
---- Your user name and password are not defined.
Ask your database administrator to set up a Firebird login.

gfix -validate c:\test\testdb.gdb -user sysdba -password masterkey
---- database c:\test\testdb.gdb shutdown


I don't know where to go from here, any ideals.

Thanks
Michael L. Horne