Can't Upgrade From MYSQL 4.1.22-standard

[3guk]

Hi Guys,

You will have to bear with me, this is my first VPS and I have only had it for around 6months, I have been having problems with my databases recently, and my forums have been progressively getting slower, the developers of said forum, said it would run much better if I had MYSQL 5.

I thought this would be a relatively easy upgrade, but I can't seem to get it to upgrade, it always appears that it has, but when I check under phpmyadmin it still tells me that it is running on 4.1.22-standard.

I have tried /scripts/mysqlup and have used the --force tag as well but to no avail. I have the 5.0 bit checked under tweak settings in WHM, and since i'm new to all of this have hit a brick wall.

I have posted the output of mysqlup below.

 

[3guk]

/scripts/mysqlup
MySQL Setup Script Version 7.0
Fetching http://httpupdate.cpanel.net/mysqlinstall/CURRENT/cPpkgversion (0)[email protected]%...100%......Done
Loaded cPPkgs::MySQL ok!
This is the cPPkgs::MySQL 5.0.45 installer for Linux.
Fetching http://httpupdate.cpanel.net/mysqlinstall/5.0.45-0/centos/5/MySQL-shared-5.0.45-0.glibc23.i386.rpm (0)[email protected]%...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%]
1:MySQL-shared ########################################### [100%]
Fetching http://httpupdate.cpanel.net/mysqlinstall/5.0.45-0/centos/5/MySQL-server-5.0.45-0.glibc23.i386.rpm (0)[email protected]%...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
Fetching http://httpupdate.cpanel.net/mysqlinstall/5.0.45-0/centos/5/MySQL-shared-5.0.45-0.glibc23.i386.rpm (0)[email protected]%...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%]
1:MySQL-shared ########################################### [100%]
This script updates all the mysql privilege tables to be usable by
MySQL 4.0 and above.
Starting MySQL SUCCESS!
Method: Perl Expect
Fetching CPAN timestamp...Done
Testing connection speed...(this could take a while)...Done
Ping:1.904 Testing connection speed to cpan.etla.org using pureperl...(313600.00 bytes/s)...Done
Ping:1.657 Testing connection speed to cpan.mirror.anlx.net using pureperl...(155850.00 bytes/s)...Done
Ping:3.843 Testing connection speed to www.mirrorservice.org using pureperl...(53200.00 bytes/s)...Done
Three usable mirrors located
Mirror Check passed for cpan.etla.org (/index.html)
Unknown config variable 'less'
commit: wrote '/usr/lib/perl5/5.8.8/CPAN/Config.pm'
CPAN: File::HomeDir loaded ok (v0.69)
CPAN: Storable loaded ok (v2.18)
Going to read /home/.cpan/Metadata
Database was generated on Sat, 22 Mar 2008 02:31:52 GMT
Running install for module 'DBD::mysql'
Running make for C/CA/CAPTTOFU/DBD-mysql-4.006.tar.gz
CPAN: Digest::SHA loaded ok (v5.45)
CPAN: Compress::Zlib loaded ok (v1.42)
Checksum for /home/.cpan/sources/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.006.tar.gz ok
DBD-mysql-4.006/
DBD-mysql-4.006/ChangeLog
DBD-mysql-4.006/constants.h
DBD-mysql-4.006/dbdimp.c
DBD-mysql-4.006/dbdimp.h
DBD-mysql-4.006/eg/
DBD-mysql-4.006/eg/._bug14979.pl
DBD-mysql-4.006/eg/bug14979.pl
DBD-mysql-4.006/eg/._bug21028.pl
DBD-mysql-4.006/eg/bug21028.pl
DBD-mysql-4.006/eg/bug30033.pl
DBD-mysql-4.006/eg/bug30033pg.pl
DBD-mysql-4.006/eg/decimal_test.pl
DBD-mysql-4.006/eg/issue21946.pl
DBD-mysql-4.006/eg/prepare_memory_usage.pl
DBD-mysql-4.006/eg/proc_example1.pl
DBD-mysql-4.006/eg/proc_example2.pl
DBD-mysql-4.006/eg/proc_example2a.pl
DBD-mysql-4.006/eg/proc_example2b.pl
DBD-mysql-4.006/eg/proc_example3.pl
DBD-mysql-4.006/eg/proc_example4.pl
DBD-mysql-4.006/INSTALL.html
DBD-mysql-4.006/lib/
DBD-mysql-4.006/lib/Bundle/
DBD-mysql-4.006/lib/Bundle/DBD/
DBD-mysql-4.006/lib/Bundle/DBD/mysql.pm
DBD-mysql-4.006/lib/DBD/
DBD-mysql-4.006/lib/DBD/mysql/
DBD-mysql-4.006/lib/DBD/mysql/GetInfo.pm
DBD-mysql-4.006/lib/DBD/mysql/INSTALL.pod
DBD-mysql-4.006/lib/DBD/mysql.pm
DBD-mysql-4.006/Makefile.PL
DBD-mysql-4.006/Makefile.PL.embedded
DBD-mysql-4.006/MANIFEST
DBD-mysql-4.006/MANIFEST.SKIP
DBD-mysql-4.006/META.yml
DBD-mysql-4.006/myld
DBD-mysql-4.006/mysql.xs
DBD-mysql-4.006/README
DBD-mysql-4.006/t/
DBD-mysql-4.006/t/00base.t
DBD-mysql-4.006/t/10connect.t
DBD-mysql-4.006/t/20createdrop.t
DBD-mysql-4.006/t/25lockunlock.t
DBD-mysql-4.006/t/30insertfetch.t
DBD-mysql-4.006/t/35limit.t
DBD-mysql-4.006/t/35prepare.t
DBD-mysql-4.006/t/40bindparam.t
DBD-mysql-4.006/t/40bindparam2.t
DBD-mysql-4.006/t/40blobs.t
DBD-mysql-4.006/t/40catalog.t
DBD-mysql-4.006/t/40keyinfo.t
DBD-mysql-4.006/t/40listfields.t
DBD-mysql-4.006/t/40nulls.t
DBD-mysql-4.006/t/40numrows.t
DBD-mysql-4.006/t/40server_prepare.t
DBD-mysql-4.006/t/40types.t
DBD-mysql-4.006/t/41bindparam.t
DBD-mysql-4.006/t/41blobs_prepare.t
DBD-mysql-4.006/t/42bindparam.t
DBD-mysql-4.006/t/50chopblanks.t
DBD-mysql-4.006/t/50commit.t
DBD-mysql-4.006/t/60leaks.t
DBD-mysql-4.006/t/65types.t
DBD-mysql-4.006/t/70takeimp.t
DBD-mysql-4.006/t/75supported_sql.t
DBD-mysql-4.006/t/80procs.t
DBD-mysql-4.006/t/insertid.t
DBD-mysql-4.006/t/lib.pl
DBD-mysql-4.006/t/multi_statement.t
DBD-mysql-4.006/t/mysql.dbtest
DBD-mysql-4.006/t/param_values.t
DBD-mysql-4.006/t/prepare_noerror.t
DBD-mysql-4.006/t/test.pl
DBD-mysql-4.006/t/test_data.txt
DBD-mysql-4.006/t/texecute.t
DBD-mysql-4.006/t/utf8.t
DBD-mysql-4.006/t/warnings.t
DBD-mysql-4.006/TODO
CPAN: File::Temp loaded ok (v0.20)
CPAN: YAML loaded ok (v0.66)

CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-4.006.tar.gz

Checking if your kit is complete...
Looks good
Using DBI 1.603 (for perl 5.008008 on i686-linux) installed in /usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBI/
Writing Makefile for DBD::mysql
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
cc -c -I/usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBI -I/usr/include/mysql -g -march=i386 -mcpu=i686 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -DVERSION=\"4.006\" -DXS_VERSION=\"4.006\" -fpic "-I/usr/lib/perl5/5.8.8/i686-linux/CORE" dbdimp.c
`-mcpu=' is deprecated. Use `-mtune=' or '-march=' instead.
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBI/Driver.xst > mysql.xsi
/usr/bin/perl /usr/lib/perl5/5.8.8/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.8.8/ExtUtils/typemap mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line 225
Warning: duplicate function definition 'rows' detected in mysql.xs, line 612
cc -c -I/usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBI -I/usr/include/mysql -g -march=i386 -mcpu=i686 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -DVERSION=\"4.006\" -DXS_VERSION=\"4.006\" -fpic "-I/usr/lib/perl5/5.8.8/i686-linux/CORE" mysql.c
`-mcpu=' is deprecated. Use `-mtune=' or '-march=' instead.
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/usr/lib/mysql" /usr/bin/perl myld cc -shared -L/usr/local/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so \
-L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm \

chmod 755 blib/arch/auto/DBD/mysql/mysql.so
cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
Manifying blib/man3/DBD::mysql.3
Manifying blib/man3/DBD::mysql::INSTALL.3
Manifying blib/man3/Bundle::DBD::mysql.3
CAPTTOFU/DBD-mysql-4.006.tar.gz
/usr/bin/make -- OK
Running make install
Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
Installing /usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so
Writing /usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBD/mysql/.packlist
Appending installation info to /usr/lib/perl5/5.8.8/i686-linux/perllocal.pod
CAPTTOFU/DBD-mysql-4.006.tar.gz
/usr/bin/make install UNINST=1 -- OK
perlmod--Install done
Install Complete

 

[morefood2001]

I am getting the same exact message. However I do have some leads (I have been working on this issue for a week now):

This is a clean vps install with 768MB of ram, and I have rebuilt this vps 4 times to try different methods of upgrade, all with the same exact failure.

It seems that everything but mysql server upgrade to 5.1.

Shell session:

[[email protected] ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 343
Server version: 4.1.22-standard

I have looked at the cpanel mysqlup script more closely since and found
this (as posted above):

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

After some more research, I discovered a dependency error:

[[email protected] ~]# rpm -ivh MySQL-server-5.0.45-0.glibc23.i386.rpm
error: Failed dependencies:
perl(DBI) is needed by MySQL-server-5.0.45-0.glibc23.i386
[[email protected] ~]#

Google searches give me only this, which isn't much help:
http://www.webhostingtalk.com/showthread.php?t=668586

I downloaded a perl(DBI) package to my home directory and have been checking packages. After installing the perl package, all the dependencies are now ok, however I still cannot upgrade. I cannot remove the mysql 4.1 shared or server rpms from the server (I have stopped the mysql service also hoping it was that) even using rpm -e --nodeps <Package>. As a result, when at my home directory, I cannot install the server version 5.0 due to conflicts. Upgrading gives the pre scriptlet fails line that cpanel's scripts give.

I have ran out of ideas of how to solve this. This is a centos 5 server with hypervm.

Please help!

Thanks,
Philip

 

[cPanelKenneth]

Unmount /tmp

Depending upon your setup, you might have to do the unmount several times.