URGENT! Server down

likegeo · February 06, 2016, 02:52:40 PM

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!

HostPuma · February 06, 2016, 04:33:21 PM

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.

likegeo · February 06, 2016, 05:01:17 PM

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,

HostPuma · February 06, 2016, 07:37:44 PM

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.

likegeo · February 07, 2016, 01:04:47 PM

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.

likegeo · February 07, 2016, 07:47:44 PM

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,

likegeo · February 07, 2016, 08:15:57 PM

I fund it

akmallinux · March 03, 2016, 02:14:29 PM

same with me, this is bug in version 0.9.8.11

LiXuS · July 10, 2016, 03:52:31 PM

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 ?

Administrator · July 10, 2016, 07:54:59 PM

you should check your disk space

URGENT! Server down

likegeo

HostPuma

likegeo

HostPuma

likegeo

likegeo

likegeo

akmallinux

LiXuS

Administrator

Control Web Panel

Learn

Services

Community