|
From: Andrew G. <an...@fe...> - 2003-05-23 13:14:00
|
Volker Rehn wrote: > Hi Andrew, > > Andrew Guts schrieb: > >>> Can you connect as the owner or as sysdba? >> >> >> No. Connection fails with message about database shutdown. >> >>> Did you bring the DB online again? >> >> >> Yes, by running "gfix -online /data/db" locally on server host. > > > This is strange: What I usually do is this: > gfix -online -user <user> -password <password> <host>:<dbfile> > > and I have never had any problems. Normally, if you shutdown a DB, the > user who shuts it down and the sysdba are still able to connect to it. > Shut down here means a DB in single-user mode, not a DB which denies > any access. So if you cannot connect at all, but the server is running > and you are even getting an error msg from it saying the db is shut > down - this is weird. > Because I cannot verify your setup - I am running firebird SS RC2 on > NT4, I can only guess now: > > - gfix needs your user/password but does not compain if it does not > get them. As I know gfix running locally on linux server under root account does not need user/password. gfix works. Problem is establishing a remote connection to database in "shutdown mode". > - can you backup/restore the DB? Yes. This does not require shut down the DB. (restore as another DB) > > - can you connect to other DBs? Yes. And my local Firebird SS 1.5 works as expected under w2k. > > - does it make a difference after you stop and restart the server? I'll not play with production server till Saturday evening. > > - do you perhaps use different versions of gfix? different servers? No, the same, but OSes. gfix is above suspicion. The same happens when I use IBConsole, but I can not make database online with IBConsole because of remote connection. Andrew |