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:
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:
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