> 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.

Your database is in shutdown mode. You have to bring the
database back online with using gfix.exe or any third-
party tool which is capable to do so.

With gfix.exe you can do that by using the -o switch.
For example:

gfix -o db_name



HTH,
Thomas Steinmaurer

The IB LogManager Product Family
Logging/Auditing Suite for InterBase/Firebird
http://www.iblogmanager.com