MYSQL Suddenly Not Working


#1

Hi suddenly one of my websites is down Error establishing a database connection Other website is openning

Also when I try to open phpmyadmin i get

phpMyAdmin - Error

Error during session start; please check your PHP and/or webserver log file and configure your PHP installation properly. Also ensure that cookies are enabled in your browser.

Any idea how to fix?


#2

@wyamout,

Have you tried with restarting MySQL on your server? Also check MySQL logs,

tail -f /var/log/mysql/*.log

Also regarding phpMyAdmin session issue: This thread will help you:


#3

This worked for a while now its back… weird Tried

chmod a+t+w /var/lib/php5
chmod go-r /var/lib/php5

Still same

tail log

2014-11-21 01:09:29 1339 [Note] InnoDB: Waiting for purge to start
2014-11-21 01:09:29 1339 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.21-70.0 started; log sequence number 2646066
2014-11-21 01:09:29 1339 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2014-11-21 01:09:29 1339 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2014-11-21 01:09:29 1339 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2014-11-21 01:09:29 1339 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2014-11-21 01:09:29 1339 [Note] Server socket created on IP: '127.0.0.1'.
2014-11-21 01:09:30 1339 [Note] Event Scheduler: Loaded 0 events
2014-11-21 01:09:30 1339 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.21-70.0'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Percona Server (GPL), Release 70.0, Revision 688

#4

@wyamout,

From log your MySQL looks fine. Are you able to connet to MySQL database using mysql command?


#5

Yes MySQL working fine… its phpmyadmin not working…

Error during session start; please check your PHP and/or webserver log file and configure your PHP installation properly. Also ensure that cookies are enabled in your browser.

Also for adminer i can login but i try to create new database i get "Invalid CSRF token. Send the form again. "


#6

@wyamout, Have you updated PHP packages recently? If so then I think you need to use https://github.com/rtCamp/easyengine/issues/302 workaround again.


#7

No i haven’t and tried that again still no luck…


#9

Hello @wyamout

It’s been a long time, and we haven’t heard from you. It looks like your issue is resolved.

I am closing this support topic for now. Feel free to create a new support topic if you have any queries further. :slight_smile:


#10