HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Server Operation (http://www.howtoforge.com/forums/forumdisplay.php?f=5)
-   -   MySQL problem - Sometimes cann't connect to MySQL (http://www.howtoforge.com/forums/showthread.php?t=57936)

Ronniea 14th July 2012 16:20

MySQL problem - Sometimes cann't connect to MySQL
 
Hello,

I have setup a multiserver setup with Ubuntu 12.04 and the perfect server guide. (Apache and MySQL 5.5)

After the setup it works great but sometimes my websites with a database give my a error. Webserver and Database server are different servers.
Database Error: Unable to connect to the database:Could not connect to MySQL.
Websites without a database running fine.

When i get the error message, i can ping form the webserver to the DB server and from the DB server to webserver. I think it is a problem with MySQL. I have also start al over again with a clean installation but i get the same problem. With older versions (Ubuntu 10.04 perfect server setup) it runs without a problem.

I hope that someone can help my.

rosehosting 15th July 2012 04:29

Quote:

Originally Posted by Ronniea (Post 282084)
Hello,

I have setup a multiserver setup with Ubuntu 12.04 and the perfect server guide. (Apache and MySQL 5.5)

After the setup it works great but sometimes my websites with a database give my a error. Webserver and Database server are different servers.
Database Error: Unable to connect to the database:Could not connect to MySQL.
Websites without a database running fine.

When i get the error message, i can ping form the webserver to the DB server and from the DB server to webserver. I think it is a problem with MySQL. I have also start al over again with a clean installation but i get the same problem. With older versions (Ubuntu 10.04 perfect server setup) it runs without a problem.

I hope that someone can help my.


Yes, it looks like your MySQL is crashing for some reason. Is it running when the crash occurs? Is there something in the logfiles which may indicate what happend and when? Was the server overloaded and out of resources?

If you want to get help please provide us with as much information as possible.

Thanks,

Ronniea 16th July 2012 21:01

Hello, thanks for the reply.

This setup is a test situation for my new hosting.
I don't think it is a resource problem. After a reset the problem wil show up sometimes, not always.

I'm a newby on MySQL but i don't see something strange in the logfiles.
When i have this problem, after a while the problem goes away and everything is running normal. (I have nothing to do)

Question: when a MySQL crasht will it be automaticly come back and run normal or is a restart nessecerly.

I have installed this multiserver setup with the this guide. The Perfect Server - Ubuntu 12.04 LTS (Apache2, BIND, Dovecot, ISPConfig 3).

At this moment i had no further information.


All times are GMT +2. The time now is 06:49.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.