Cannot upgrade to MySQL5

[markhard]

I'm trying to upgrade to MySQL 5 from MySQL 4.1, did the change on WHM Tweak Settings and then run /scripts/mysqlup but i get this error:

the installer version: cPPkgs::MySQL 5.0.45 installer for Linux

Fetching http://httpupdate.cpanel.net/mysqlinstall/5.0.45-0/centos/5/MySQL-server-5.0.45-0.glibc23.i386.rpm (0)....@69.72.164.152......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
Preparing...                ########################################### [100%]
error:   install: %pre scriptlet failed (2), skipping MySQL-server-5.0.45-0.glibc23

running:

rpm -ivh MySQL-server-5.0.45-0.glibc23.i386.rpm

give error:

error: Failed dependencies:
        perl(DBI) is needed by MySQL-server-5.0.45-0.glibc23.i386

i did run /scripts/perlinstaller --force Bundle:BD::mysql too, but it doesn't fix it

[kernow]

Are you running perl v5.8.8 ??
#perl -v

[markhard]

yes, the perl is 5.8.8

i did try to install DBI:

spawn /scripts/perlinstaller DBI
Method: Perl Expect
Fetching CPAN timestamp...Done

Testing connection speed...(this could take a while)...Done

Ping:36.052 Testing connection speed to cpan.pair.com using pureperl...(52050.00 bytes/s)...Done

Ping:44.935 Testing connection speed to cpan.mirrors.hoobly.com using pureperl...(52066.67 bytes/s)...Done

Ping:20.483 Testing connection speed to mirror.datapipe.net using pureperl...(8747.22 bytes/s)...Done

Three usable mirrors located

Mirror Check passed for cpan.mirrors.hoobly.com (/index.html)

Unknown config variable 'less'

commit: wrote '/usr/lib/perl5/5.8.8/CPAN/Config.pm'

CPAN: File::HomeDir loaded ok (v0.67)

CPAN: Storable loaded ok (v2.18)

Going to read /home/.cpan/Metadata

Database was generated on Wed, 02 Jan 2008 07:37:59 GMT

DBI is up to date (1.601).

perlmod--Install done

after that run /scripts/mysqlup and still get the same error

[cpanelkenneth]

Try:

rpm -Uvh --nodeps MySQL-server-5.0.45-0.glibc23.i386.rpm

[markhard]

should i run /scripts/mysqlup again after that?

[markhard]

Try:

rpm -Uvh --nodeps MySQL-server-5.0.45-0.glibc23.i386.rpm

it still giving error:

rpm -Uvh --nodeps MySQL-server-5.0.45-0.glibc23.i386.rpm
Preparing...                ########################################### [100%]
error:   install: %pre scriptlet failed (2), skipping MySQL-server-5.0.45-0.glibc23

[troxalias]

Maybe you have to disable SeLinux before you begin the installation. Login to the server through SSH and run the command "setenforce 0" . Then proceed with installation and if it is all ok enable it again.

[markhard]

disabling selinux doesn't help, still the same error

[markhard]

running rpm -ivh --nodeps MySQL-server-5.0.45-0.glibc23.i386.rpm gives this errors:

Preparing... ########################################### [100%]
file /etc/init.d/mysql from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/bin/my_print_defaults from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/bin/myisam_ftdump from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/bin/myisamchk from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/bin/myisamlog from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/bin/myisampack from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/bin/mysql_convert_table_format from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/bin/mysql_explain_log from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/bin/mysql_fix_privilege_tables from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/bin/mysql_install_db from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/bin/mysql_secure_installation from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/bin/mysql_tzinfo_to_sql from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/bin/mysql_zap from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/bin/mysqlbug from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/bin/mysqld_multi from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/bin/mysqld_safe from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/bin/mysqldumpslow from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/bin/mysqlhotcopy from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/bin/mysqltest from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/bin/perror from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/bin/replace from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/bin/resolve_stack_dump from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/bin/resolveip from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/lib/mysql/mysqld.sym from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/sbin/mysqld from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/info/mysql.info.gz from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/man/man1/myisam_ftdump.1.gz from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/man/man1/myisamchk.1.gz from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/man/man1/myisamlog.1.gz from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/man/man1/myisampack.1.gz from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/man/man1/mysql.server.1.gz from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/man/man1/mysql_explain_log.1.gz from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/man/man1/mysql_fix_privilege_tables.1.gz from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/man/man1/mysql_zap.1.gz from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/man/man1/mysqld_multi.1.gz from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/man/man1/mysqld_safe.1.gz from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/man/man1/mysqlhotcopy.1.gz from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/man/man1/perror.1.gz from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/man/man1/replace.1.gz from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/man/man8/mysqld.8.gz from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/mysql/charsets/Index.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/mysql/charsets/armscii8.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/mysql/charsets/ascii.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/mysql/charsets/cp1250.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/mysql/charsets/cp1251.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/mysql/charsets/cp1256.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/mysql/charsets/cp1257.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/mysql/charsets/cp850.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/mysql/charsets/cp852.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/mysql/charsets/cp866.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/mysql/charsets/dec8.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/mysql/charsets/geostd8.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/mysql/charsets/greek.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/mysql/charsets/hebrew.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/mysql/charsets/hp8.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/mysql/charsets/keybcs2.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/mysql/charsets/koi8r.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/mysql/charsets/koi8u.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
file /usr/share/mysql/charsets/latin1.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23

should I uninstall MySQL-server-4.1.22-0.glibc23 first? but this is strange because rpm -Uvh gives error message. Is there anybody succeed on upgrading MySQL from 4.1 to 5.0?

[troxalias]

Have you tried with yum ?
yum install mysql-server

[markhard]

tried that, and it give 'nothing to do' message

[markhard]

it seems that cpanel do something on the /scripts/upcp, the mysql server is upgraded now with some error message:

Updating MySQL Server...MySQL Setup Script Version 7.0
Loaded cPPkgs::MySQL ok!
This is the cPPkgs::MySQL 5.0.45 installer for Linux.
Fetching http://httpupdate.cpanel.net/mysqlin...ibc23.i386.rpm (0)....@69.72.164.152......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
Preparing... ##################################################
MySQL-shared ##################################################
Fetching http://httpupdate.cpanel.net/mysqlin...ibc23.i386.rpm (0)....@69.72.164.152......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
Preparing... ##################################################
Giving mysqld a couple of seconds to exit nicely
MySQL-server ##################################################
ERROR: 1136 Column count doesn't match value count at row 1
080105 23:15:56 [ERROR] Aborting

080105 23:15:56 [Note] /usr/sbin/mysqld: Shutdown complete

Installation of system tables failed!

Examine the logs in /var/lib/mysql for more information.
You can try to start the mysqld daemon with:
/usr/sbin/mysqld --skip-grant &
and use the command line tool
/usr/bin/mysql to connect to the mysql
database and look at the grant tables:

shell> /usr/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/bin/mysqlbug script!
Starting MySQL SUCCESS!
Thank you for installing the MySQL Community Server! For Production
systems, we recommend MySQL Enterprise, which contains enterprise-ready
software, intelligent advisory services, and full production support with
scheduled service packs and more. Visit www.mysql.com/enterprise for more
information.
This script updates all the mysql privilege tables to be usable by
the current version of MySQL

You can safely ignore all 'Duplicate column' and 'Unknown column' errors
because these just mean that your tables are already up to date.
This script is safe to run even if your tables are already up to date!

done
Starting MySQL SUCCESS!

[markhard]

I'm trying to upgrade to MySQL 5 from MySQL 4.1, did the change on WHM Tweak Settings and then run /scripts/mysqlup but i get this error:

the installer version: cPPkgs::MySQL 5.0.45 installer for Linux

Fetching http://httpupdate.cpanel.net/mysqlinstall/5.0.45-0/centos/5/MySQL-server-5.0.45-0.glibc23.i386.rpm (0)....@69.72.164.152......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
Preparing...                ########################################### [100%]
error:   install: %pre scriptlet failed (2), skipping MySQL-server-5.0.45-0.glibc23

this is strange.. i install a new cpanel server and then upgrade the mysql to version 5 and get the same error. the /scripts/upcp doesn't fix the problem as on my previous post.

stoping the mysql server and then run /scripts/upcp doesn't work.

[jayh38]

did you try /scripts/upcp --force

[markhard]

yes did that already.. didn't work..

Fetching http://httpupdate.cpanel.net/mysqlinstall/5.0.45-0/centos/5/MySQL-server-5.0.45-0.glibc23.i386.rpm (0)....@74.200.65.162......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
Preparing...                ##################################################
error:   install: %pre scriptlet failed (2), skipping MySQL-server-5.0.45-0.glibc23