ERROR: PleskFatalException

[Jean-ChristopheZ]

Hello!

After a reboot, because I could'nt anymore access to my Plesk manager (after ID and PW entry, I had only the refresh of the ID/PW input page), I get this message.

ERROR: PleskFatalException
Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: MySQL server has gone away
0: common_func.php3:153
psaerror(string 'Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: MySQL server has gone away')
1: auth.php3:112

The solution proposed here : http://forum.parallels.com/showthread.php?t=90680
results only on a help-like answer... :-(

Access via Putty is OK.

Can anybody help me.
Thx.

JCZ

 

[PrzemekM]

Hi,

I have a problem when I log into plesk panel :

ERROR: PleskFatalException
Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: No such file or directory

0: common_func.php3:153
psaerror(string 'Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: No such file or directory')
1: auth.php3:112

and problem when use SSH:

[root@s16605093 ~]# /etc/init.d/psa stop
Stopping psa...
done
[root@s16605093 ~]# /etc/init.d/psa start
Starting xinetd service... done
Starting mysqld service... failed
yum clean all
Trying to connect to MySQL... Failed to connect to MySQL: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Trying to start service mysqld... mysqld is stopped
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
MySQL Daemon failed to start.
Starting mysqld: [FAILED]

WARNING!
Some problems are found during start(see log file: /tmp/plesk_11.0.9_reset_instance_data.log)

Continue...

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

File /tmp/plesk_11.0.9_reset_instance_data.log :

TART Doing reset_instance_data --psa-init AT Wed Jan 30 12:40:17 CET 2013
Trying to start service mysqld... mysqld is stopped
MySQL Daemon failed to start.
Starting mysqld: [FAILED]

WARNING!
Some problems are found during start(see log file: /tmp/plesk_11.0.9_reset_instance_data.log)

Continue...

Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

START Doing reset_instance_data --psa-init AT Wed Jan 30 12:42:01 CET 2013
Trying to start service mysqld... mysqld is stopped
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
MySQL Daemon failed to start.
Starting mysqld: [FAILED]

File /etc/my.cnf :

[mysqld]
bind-address=127.0.0.1
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
old_passwords=1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Command df -h :

[root@s16605093 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/xvda1 4.0G 739M 3.3G 19% /
/dev/mapper/vg00-usr 20G 2.0G 17G 11% /usr
/dev/mapper/vg00-var 37G 6.1G 29G 18% /var
/dev/mapper/vg00-home
4.0G 136M 3.7G 4% /home
none 1000M 16K 1000M 1% /tmp
[root@s16605093 ~]#

1and1 web hosting doesn't want to help me. They just said that I have a problem in the path to the database.
Sorry for poor English.
I can not turn on MySQL Service, status failed.
All my website using MySQL not work.

 

[Jean-ChristopheZ]

Hello PrzemekM !

I am not so skilled, but I can give you my experience with this issue.
It appeared that my main disk was too full :-(
I deleted a couple of unnecessary files (old time backups) and everything worked well again... and is still working.
I hope it helped.
All the best.

JCZ

 

[PrzemekM]

Thank you for your response.

Just as you can see, I used the command df -h disk is not full.
1and1 web hosting said that this could be an attack on sql injection.
I don't know what to do on the server I have a lot of pages.

 

[_Dman_]

Hello PrzemekM !

I am not so skilled, but I can give you my experience with this issue.
It appeared that my main disk was too full :-(
I deleted a couple of unnecessary files (old time backups) and everything worked well again... and is still working.
I hope it helped.
All the best.

JCZ

Thanks so much JCZ - Your post got me up and running in no time. My backups had filled up one of the hard drives.
Hope this may also help others

Using puTTY I connected to the server using SSH and run the command;
df -h

I could see one of the hard drive partitions was at 100%

Then I changed to the root;
cd /

And run the command;
du -cms *| sort -nr

This showed a list of directories with the largest at the top.
I would then change to the largest directory "cd /name-of -large-directory"
and run command "du -cms *| sort -nr" again.

I repeated these steps until I found the offending directory (or user).

Another useful command is 'Find'
you use
find / -size +10000k (to list all files above 10000k (10Mb))
or
find /path/to/large-files -size +10000k (to list all files above 10000k in the directory 'large-files')


To list the files and directories in the current directory
ls -l


Deleting / Removing files and directories
Be Very careful using "rm" command. A typo could easily lose precious data and/or screw your server.

If you prefer you can use SFTP via an app like WinSCP so you can clearly see you files and folders and use delete option in there.


To Delete the file 'DeleteMe.txt' use;
rm DeleteMe.txt

To Delete the Directory 'DeleteMe' and all its contents in the current directory
rm -rf DELETEME !!!NOTE!!! -rf with great care - its recursive deleting (-r) with no prompting (-f)

To Delete all files/folders in the current directory, without deleting the directory itself.
rm -rf *

Hope this helps someone like me that has a very basic understanding of server admin.

Best Wishes
Dman