Subject | User/Password not working ??? |
---|---|
Author | Michael Horne |
Post date | 2003-10-28T18:33:14Z |
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
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