The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Can't Upgrade From MYSQL 4.1.22-standard

Discussion in 'General Discussion' started by 3guk, Mar 22, 2008.

  1. 3guk

    3guk Member

    Joined:
    Sep 15, 2007
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    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.
     
  2. 3guk

    3guk Member

    Joined:
    Sep 15, 2007
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    /scripts/mysqlup
    MySQL Setup Script Version 7.0
    Fetching http://httpupdate.cpanel.net/mysqlinstall/CURRENT/cPpkgversion (0)....@69.72.164.155......connected......receiving...65%...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)....@69.72.164.155......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%]
    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)....@69.72.164.155......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
    Fetching http://httpupdate.cpanel.net/mysqlinstall/5.0.45-0/centos/5/MySQL-shared-5.0.45-0.glibc23.i386.rpm (0)....@69.72.164.155......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%]
    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
     
  3. morefood2001

    morefood2001 Active Member

    Joined:
    Mar 18, 2008
    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    1
    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:

    [root@host ~]# 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:

    [root@host ~]# 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
    [root@host ~]#

    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
     
  4. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    Unmount /tmp

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

Share This Page