[SOLVED]Can't connect to local MySQL server through socket '/var/lib/mysql/mysql

[evilhomer]

I'm getting the error shown in the subject intermittently.

At first, I assumed it was the MySql server on my hosting package, it may well still be however I can access it using phpMyAdmin and using SSH.

The function is CONNECT and it has the correct database, username and password.  As I say, it is intermittent.  If I check back in about 5 minutes it will work perfectly well as before.

I'm very very new to this specific CMS so if anyone has any ideas what this might be, or what I can do to fault find it then that help is really appreciated.

When I installed it I had all green ticks to indicate everything was the correct versions/set up.

Regards

Chris.

[Nullig]

Looks like an overburdened MySQL Server. I would contact your hosting provider to see what can be done.

Nullig

[evilhomer]

Hi

Yeah I was guessing it might be that.  I've tried to get in touch but not heard.  Are there any specific technical requirements that CMSMS has for the MySql database?  I may need to check that it is viable to use it with my current hosting company

[Nullig]

No, nothing out of the ordinary. What hosting provider are you using?

Nullig

[evilhomer]

My hosting provider is a fairly small company called pageinabox.  Actually the guy that set it up is a friend of a friend so I've sent a message to him to see if he can take a quick look for me.

I'm also just going to check I haven't got something wrong in the config.php.  I'll post up what the solution was once I get an answer

[evilhomer]

Managed to solve it.... I think.

The issue was that I shouldn't be using localhost and hence a filesystem socket to connect to the database.  I should be using a URL and port instead.  Changed the config.php file and currently it is working nicely.... just in case anyone else hits this might be worth a try.

Regards

Chris