Detecting MYSQL running status

[Raj Chinna]

Hi,

I have web2py application which talks with MYSQL and i have my db connection strings in db.py module. Sometime the web2py server is running without any issues, but mysql goes offline now and then. So, I am getting the ticket generated saying that "Failure to connect, tried 5 times: Traceback (most recent call last): ".

All I wanted to do is to check if this error comes out (that's mysql is not running) I need to redirect the user to something like 404/database error page. Can someone tell me where and how can I detect this database connectivity failure and show some meaningful error message. 

Thanks, 

Raj Chinna

[Paolo Valleri]

I've the same problem, I don't think DAL has this kind of ability but I leave the word to others in such cases.

Are you interested in showing the 404 page for all tickets or only for those the involve the db connection?

Paolo

[Raj Chinna]

Paolo,

Thanks for the response. 

I just put 404 for as an example, I am may end up showing a page which asks the end user to contact the System Admin to fix the issue. What am doing is an webapp for a enterprise task. So, I may show few details about the issue.