We're running superserver. Since FB runs as a service, we could do it
as part of the start and stop scripts there. However, I was hoping to
not do that if no one was connected to the database when it closed. I
guess there is no need to over think/optimize it, and just run gfix on
start if the service doesn't close cleanly.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Steve Wiser
Sent: Friday, January 12, 2007 2:42 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Auto gfix on start

If you are using Classic maybe you could modify the xinetd start and
stop scripts. On startup, xinetd could create a file letting the system
know that it started and on stop it could remove the file. If xinetd
tries to start and the file is already there then it could run gfix. I
know it... It is a hack, but it may work in your situation...

-steve

Rick Debay wrote:

>
> We have occasional power outages, and our server UPS is vastly
> undersized (literally seconds of uptime). I've been turned down on
> getting a larger one, so all I can do is try to repair the damage
> after the fact.
>
> I'm trying to figure out how to automatically run gfix to validate a
> database, if it was not closed cleanly. The solution needs to work on
> Linux (Redhat and Suse). Does anyone have any suggestions?
>
> Rick DeBay

Disclaimer: This message (including attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. RxStrategies, Inc. shall not be liable for the improper or incomplete transmission of the information contained in this communication or for any delay in its receipt or damage to your system. RxStrategies, Inc. does not guarantee that the integrity of this communication has been maintained nor that this communication is free from viruses, interceptions or interference.