Messages

1

CentOS 6 Problems / Could not select database root_cwp

« on: October 16, 2017, 09:16:37 AM »

 After upgrading MySQL server from 5.1 to 5.5 CWP stopped working.

Its giving me following error.

Could not select database root_cwp

2

CentOS 6 Problems / Re: CentOS6 Upgrade

« on: October 15, 2017, 10:23:56 AM »

Hello Support,

I wanted to update the CWP version and I went ahead and upgraded the MySQL first, following below KB.

http://forum.centos-webpanel.com/centos-6-problems/centos6-upgrade/

I applied following commands.

cd /usr/local/src
wget http://dl1.centos-webpanel.com/files/el6/cwpupgrade/mysql.sh
sh mysql.sh

Code: [Select]


[root@www src]# sh mysql.sh
Loaded plugins: fastestmirror, replace
Loading mirror speeds from cached hostfile
 * base: mirror.gpmidi.net
 * extras: mirror.calgah.com
 * rpmforge: mirror.us.leaseweb.net
 * updates: centos.zswap.net
 * webtatic: us-east.repo.webtatic.com
repo id                                  repo name                                                        status
base                                     CentOS-6 - Base                                                  6706
extras                                   CentOS-6 - Extras                                                  46
rpmforge                                 RHEL 6 - RPMforge.net - dag                                      4718
updates                                  CentOS-6 - Updates                                                722
webtatic                                 Webtatic Repository EL6 - x86_64                                  362


After this MYSQL server stopped with following error.

Code: [Select]

[root@www src]# service mysqld start
MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]


I went ahead and checked the  yum history, and noticed that there are 2 versions of MySQL.

Code: [Select]


Warning: RPMDB altered outside of yum.
** Found 2 pre-existing rpmdb problem(s), 'yum check' output follows:
mysql55w-5.5.57-1.w6.x86_64 has installed conflicts mysql < ('0', '5.5', None): mysql-5.1.73-8.el6_8.x86_64
mysql55w-libs-5.5.57-1.w6.x86_64 has installed conflicts mysql-libs < ('0', '5.5', None): mysql-libs-5.1.73-8.el6_8.x86_64


and MySQL version shows the following output.

Code: [Select]

[root@www src]# mysql --version
mysql  Ver 14.14 Distrib 5.5.57, for Linux (x86_64) using readline 5.1


I checked the MYSQL logs and it gave following output.

Code: [Select]

171015  5:41:01 [Note] /usr/libexec/mysqld: Normal shutdown

171015  5:41:01 [Note] Event Scheduler: Killing the scheduler thread, thread id 1
171015  5:41:01 [Note] Event Scheduler: Waiting for the scheduler thread to reply
171015  5:41:01 [Note] Event Scheduler: Stopped
171015  5:41:01 [Note] Event Scheduler: Purging the queue. 1 events
171015  5:41:01  InnoDB: Starting shutdown...
171015  5:41:22  InnoDB: Shutdown completed; log sequence number 1 2391391413
171015  5:41:22 [Note] /usr/libexec/mysqld: Shutdown complete

171015 05:41:22 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

MySQL upgrade also failed with the error.

Code: [Select]

[root@www log]# mysql_upgrade -u roor -p
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Error: Failed while fetching Server version! Could be due to unauthorized access.
FATAL ERROR: Upgrade failed

I am stuck with the stopped MySQL serer.

Please assist.