URGENT! Server down

Hello,

Today when i access my websites, i get 500 internal server error. Then i tried to access the control panel and i get this error message:

Warning: mysql_connect(): Connection refused in /usr/local/cwpsrv/htdocs/admin/index.php(1) : eval()'d code(1) : eval()'d code on line 2
mysqld is stopped

Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: service cwpsrv restart

**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf

Could not connect: Connection refused

What can caused this problem? i have no access to ssh so what can i do because all my data are inside.

The cwp is installed on OVH VPS server, and i have restarted the server many time, still same problem. Ftp working but i get empty directory.

Thank you very much!

Its a VPS so you should have SSH access, otherwise only your host "OVH" can solve the issue for you.

They might charge you since its unmanaged budget VPS's.

Thank you for reply,

I have contacted the support on ovh, and they said it is a cwp issue, all the services on vps working well. So, i have access to ssh, but how can i backup all data so i can reinstall the cwp or how to fix that error.?

Thank you,

Download Winscp and login with root, then transfer all important files to your PC.

Create and download a full backup for all databases using Putty SSH:

Code: [Select]

mysqldump --events --all-databases | gzip > /home/alldatabases.sql.gz
When the backup is ready, you will find it under /home/ directory using Winscp.

Once your done with backups, lets try to upgrade MySQL in hope that it might fix the error. Run the following commands in order:

Code: [Select]

cd /etc/yum.repos.d

wget http://rpms.famillecollet.com/enterprise/remi.repo

yum --enablerepo=remi update mysql-server

sudo mysql_upgrade


Once the upgrade is complete, restart your VPS and try to log into CWP admin area.

The problem is that the ssh is working only when my VPS has booted into rescue mode. The commands you give me i m sure are good but in rescue mode is not working.

I have access now to my backup, i have now all my files but i need to get the mysql database files also. Where are stored the databases files on cwp?

Thank you,

I fund it

same with me, this is bug in version 0.9.8.11

hello.
wen i want to access my root panel i recive
Warning: [obfuscated](): Connection refused in /usr/local/cwpsrv/htdocs/admin/index.php on line 0
mysqld is stopped

Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: service cwpsrv restart

**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf

Could not connect: Connection refused

so ... i try this command

[root@srv1 ~]# yum --enablerepo=remi update mysql-server
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Update Process
Loading mirror speeds from cached hostfile
 * base: mirrors.m247.ro
 * extras: ftp.ines.lug.ro
 * remi: mirrors.netix.net
 * remi-safe: mirrors.netix.net
 * rpmforge: ftp.lug.ro
 * updates: ftp.ines.lug.ro
Resolving Dependencies
--> Running transaction check
---> Package mysql-server.x86_64 0:5.1.73-7.el6 will be updated
---> Package mysql-server.x86_64 0:5.5.50-1.el6.remi will be an update
--> Processing Dependency: real-mysql-libs(x86-64) = 5.5.50-1.el6.remi for packa                                                                                        ge: mysql-server-5.5.50-1.el6.remi.x86_64
--> Processing Dependency: real-mysql(x86-64) = 5.5.50-1.el6.remi for package: m                                                                                        ysql-server-5.5.50-1.el6.remi.x86_64
--> Running transaction check
---> Package mysql.x86_64 0:5.1.73-7.el6 will be updated
--> Processing Dependency: mysql = 5.1.73-7.el6 for package: mysql-devel-5.1.73-                                                                                        7.el6.x86_64
---> Package mysql.x86_64 0:5.5.50-1.el6.remi will be an update
---> Package mysql-libs.x86_64 0:5.1.73-7.el6 will be updated
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: cyrus-sasl                                                                                        -sql-2.1.23-15.el6_6.2.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: 1:dovecot-                                                                                        mysql-2.0.9-22.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: 2:postfix-                                                                                        2.6.6-6.el6_7.1.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: perl-DBD-M                                                                                        ySQL-4.013-3.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: pure-ftpd-                                                                                        1.0.36-1.el6.rf.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for pa                                                                                        ckage: cyrus-sasl-sql-2.1.23-15.el6_6.2.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for pa                                                                                        ckage: 1:dovecot-mysql-2.0.9-22.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for pa                                                                                        ckage: 2:postfix-2.6.6-6.el6_7.1.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for pa                                                                                        ckage: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for pa                                                                                        ckage: pure-ftpd-1.0.36-1.el6.rf.x86_64
---> Package mysql-libs.x86_64 0:5.5.50-1.el6.remi will be an update
--> Running transaction check
---> Package compat-mysql51.x86_64 0:5.1.54-1.el6.remi will be installed
---> Package mysql-devel.x86_64 0:5.1.73-7.el6 will be updated
---> Package mysql-devel.x86_64 0:5.5.50-1.el6.remi will be an update
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package               Arch          Version                  Repository   Size
================================================================================
Updating:
 mysql-server          x86_64        5.5.50-1.el6.remi        remi         10 M
Installing for dependencies:
 compat-mysql51        x86_64        5.1.54-1.el6.remi        remi        1.4 M
Updating for dependencies:
 mysql                 x86_64        5.5.50-1.el6.remi        remi        5.7 M
 mysql-devel           x86_64        5.5.50-1.el6.remi        remi        165 k
 mysql-libs            x86_64        5.5.50-1.el6.remi        remi        779 k

Transaction Summary
================================================================================
Install       1 Package(s)
Upgrade       4 Package(s)

Total download size: 18 M
Is this ok [y/N]: -y
Is this ok [y/N]: y
Downloading Packages:


Error Downloading Packages:
  compat-mysql51-5.1.54-1.el6.remi.x86_64: Insufficient space in download direct                                                                                        ory /var/cache/yum/x86_64/6/remi/packages
    * free   0
    * needed 1.4 M
  mysql-libs-5.5.50-1.el6.remi.x86_64: Insufficient space in download directory                                                                                         /var/cache/yum/x86_64/6/remi/packages
    * free   0
    * needed 779 k
  mysql-devel-5.5.50-1.el6.remi.x86_64: Insufficient space in download directory                                                                                         /var/cache/yum/x86_64/6/remi/packages
    * free   0
    * needed 165 k
  mysql-5.5.50-1.el6.remi.x86_64: Insufficient space in download directory /var/                                                                                        cache/yum/x86_64/6/remi/packages
    * free   0
    * needed 5.7 M
  mysql-server-5.5.50-1.el6.remi.x86_64: Insufficient space in download director                                                                                        y /var/cache/yum/x86_64/6/remi/packages
    * free   0
    * needed 10 M

how can i start back mysql server ?

you should check your disk space