Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    51
    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:
    51
    /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:
    51
    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,570
    Likes Received:
    45
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    Unmount /tmp

    Depending upon your setup, you might have to do the unmount several times.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice