could not connect custom error page

[Remitur]

When my server does backup, mysql service is stopped.

So, for few minutes my WHMCS gives a bad

Critical Error
Could not connect to the database.

It lasts just a couple of minutes, and it's deep inthe night... but it's no nice.

A custom page with a message like "We're doing system maintenance, for your security... come back soon" (or something like that) would be much better.

Any idea on how to do it?

 

[WHMCS ChrisD]

Hey @Remitur

As far as I am aware this shouldn't be happening, it could be that your server is hitting its memory limit during the backup do you get any server error logs while the backup is running?

[Remitur]

20 hours ago, WHMCS ChrisD said:

Hey @Remitur

As far as I am aware this shouldn't be happening, 

It's the backup software which stops mysql service to backup it (it's a simple way to do it, otherwise doing backup of mysql db with mysql running is complicated and require specific backup software)

So that, for few minutes, the systems go down with that error message is OK... I would only to get a better error page for my customer.

 

[WHMCS ChrisD]

Hey @Remitur,

Hmm, ok that makes sense out of the box, it's not possible to pop up a Maintenance page but you might be able to find a developer in the Service Requests & Offers Board to solve this for you.

[brian!]

On 9/30/2017 at 11:18 PM, Remitur said:

Any idea on how to do it?

I suppose you'd have to try to connect to the database - if it fails, then output your custom message, or redirect to a specific URL.

I wouldn't particularly have it running all the time though (for performance reasons), but just before the backup begins (which I assume is scheduled?).

[Remitur]

On 2/10/2017 at 4:11 PM, brian! said:

I wouldn't particularly have it running all the time though (for performance reasons), but just before the backup begins (which I assume is scheduled?).

Yes, it could be a way... but maybe would be better a more generic solution, which may be useful also if any system errors occurs.
But I have no idea how to manage it... also because (I guess) "Could not connect to the database." is not an Apache error message, but it's internal to WHMCS... right?

[brian!]

19 minutes ago, Remitur said:

Yes, it could be a way... but maybe would be better a more generic solution, which may be useful also if any system errors occurs.

are you thinking .htaccess redirection?

25 minutes ago, Remitur said:

But I have no idea how to manage it...

nothing's springing to my mind either...

30 minutes ago, Remitur said:

also because (I guess) "Could not connect to the database." is not an Apache error message, but it's internal to WHMCS... right?

yes.