Control Web Panel
WebPanel => CentOS-WebPanel Bugs => Topic started by: likegeo on 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!
-
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