concrete5 site running 5.7.5.8 suddenly fails

Permalink
Site running fine until today, not touched anything
Suddenly site fails and the front page gives :
Doctrine \ DBAL \ Driver \ PDOException (2002)
SQLSTATE[HY000] [2002] No such file or directory

Has it auto-upgraded and failed ? Some reference in the lengthy debug info to :
concrete.misc.latest_version 5.7.5.9

I cannot log in with sitename/index.php/login so don't know how to start fixing this

Any help urgently appreciated as live site suddenly not live

timconsidine
 
MrKDilkington replied on at Permalink Reply
MrKDilkington
Hi timconsidine,

Did you install concrete5 using a "one click" installer like Softaculous? If so, is it set to auto-update concrete5?
timconsidine replied on at Permalink Reply
timconsidine
Hi

No, it was installed from c5 website
Running on Amazon EC2 instance

I generally don't do auto-updates. I have performed some updates via control panel. But nothing for months

I think I saw one waiting previously but chose not to perform it as Ibwas not ready

Site is saladseminars.com if you want to see detail of exception error
MrKDilkington replied on at Permalink Reply
MrKDilkington
@timconsidine

I am not familiar with this error.

Just to clarify, no changes were made to the site (front end or back end) or the server before the error was displayed?
timconsidine replied on at Permalink Reply
timconsidine
Hi

Correct - haven't touched the C5 site or the EC2 server in months.

After the error, logged into command line of server and it said OS updates were waiting. Have not applied them as I don't want to break it further.

Seems like it fell over by itself. Have received orders and client help submit forms as recently as couple of hours before the error appeared.
mnakalay replied on at Permalink Reply
mnakalay
Hello,
Just because the error is about a missing file or folder you might want to consider re-uploading the concrete folder for the correct version and see if it fixes the problem.

A change in your php.ini file, if any, could also do that.

Any chance you could do a phpinfo() and check what's happening on the pdo_mysql font?
timconsidine replied on at Permalink Reply
timconsidine
Hi and thank you

Haven't changed php.ini myself in months

phpinfo.php runs fine. Entires for pdo_mysql show :

PDO Driver for MySQL enabled
Client API version mysqlnd 5.0.11-dev - 20120503 - $Id: <redacted> $
Directive Local Value Master Value
pdo_mysql.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock

Just tried to log in to phpmyadmin and says :
#2002 Cannot log in to the MySQL server

Guess I shall have to resolve this first (or may be the cause)
timconsidine replied on at Permalink Best Answer Reply
timconsidine
Grrrrr and FFS - seems like mysql service had stopped

Started it - all working now

Stupid me for assuming it was a C5 issue - must create a basic issues checklist for future !

Thanks for all the input
mnakalay replied on at Permalink Reply
mnakalay
Also, I think I saw something like that once before. My override cache was on and I manually deleted an override and the whole site broke (local test site of course)

If memory serves it was something like that.

Anything you changed or deleted manually on the server?

Try to empty your cache by hand and see if it fixes the problem
timconsidine replied on at Permalink Reply
timconsidine
Hi

Not changed or deleted anything on the server in months

Will investigate clearing cache manually - don't know how to, but shall google

As per last reply, need to resolve logging into phpmyadmin first
mnakalay replied on at Permalink Reply
mnakalay
Great to hear! That you got it working and that C5 is not at fault :)

Concerning the cache, it's easy you delete everything in the folder applications\files\cache

Not a super clean move but I never had a problem doing it and it can solve cache related issues when dashboard is not accessible
timconsidine replied on at Permalink Reply
timconsidine
Thank you !