MYSQL Error…….

Several months ago I had problem on upgrading CPanel’s MySQL 4.1 to MySQL 5. The problem was occurred on Centos 5.

Error:
/scripts/mysqlup
error: install: %pre scriptlet failed (2), skipping MySQL-server-5.0.45-0.glibc23

first shutdown mysql, if it is running:

rpm -qa | grep -i mysql

MySQL-server-4.1.22-0.glibc23
MySQL-client-5.0.45-0.glibc23
MySQL-shared-5.0.45-0.glibc23
MySQL-shared-4.1.22-0.glibc23
MySQL-devel-5.0.45-0.glibc23
MySQL-bench-5.0.45-0.glibc23

Remove all the packages:
rpm -e MySQL-client-5.0.45-0.glibc23
rpm -e MySQL-shared-5.0.45-0.glibc23
rpm -e MySQL-devel-5.0.45-0.glibc23
rpm -e MySQL-bench-5.0.45-0.glibc23

List what remains uninstalled:

rpm -e –noscripts MySQL-server-4.1.22-0.glibc23
rpm -e –noscripts MySQL-shared-5.0.45-0.glibc23
rpm -e –noscripts MySQL-shared-4.1.22-0.glibc23

Run mysqlup again:

/scripts/mysqlup

If it still shows the same error, Install it via RPM.

wget http://httpupdate.cpanel.net/mysqlinstall/5.0.45-0/centos/5/MySQL-server-5.0.45-0.glibc23.i386.rpm

rpm -ivh –noscripts –nodeps MySQL-server-5.0.45-0.glibc23.i386.rpm

List Packages:

rpm -qa | grep -i mysql
MySQL-devel-5.0.45-0.glibc23
MySQL-bench-5.0.45-0.glibc23
MySQL-shared-5.0.45-0.glibc23
MySQL-client-5.0.45-0.glibc23
MySQL-server-5.0.45-0.glibc23

service mysql start
Starting MySQL SUCCESS!

FTP Timed Out……

When FTP gets timed out or got stuck without any errors, please increase the following variable in FTP configuration file and restart FTP.

MaxIdleTime (default 15) Increase it to 30 or more and try.

FTP should work fine now.