Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 14th July 2012, 16:20
Ronniea Ronniea is offline
Junior Member
 
Join Date: Jul 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.
Reply With Quote
Sponsored Links
  #2  
Old 15th July 2012, 04:29
rosehosting rosehosting is offline
Member
 
Join Date: Jun 2012
Posts: 39
Thanks: 0
Thanked 7 Times in 6 Posts
Default

Quote:
Originally Posted by Ronniea View Post
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,
Reply With Quote
  #3  
Old 16th July 2012, 21:01
Ronniea Ronniea is offline
Junior Member
 
Join Date: Jul 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

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.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Relay access denied when using SMTP to external recipients Kamran Shah Installation/Configuration 111 14th May 2014 18:10
ispconfig 3 cant receive emails lishaw1968 Installation/Configuration 25 19th August 2013 10:37
vlogger (problem) cusco General 3 7th May 2012 15:32
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail -Ubuntu 8.04 c4rdinal HOWTO-Related Questions 112 23rd August 2011 10:49
Sending email issue lezelf Installation/Configuration 15 9th August 2011 11:20


All times are GMT +2. The time now is 17:15.


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