Results 1 to 20 of 20
  1. #1

    Upgrading CPanel's MySQL problem

    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
    Code:
    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:
    Code:
    rpm -ivh MySQL-server-5.0.45-0.glibc23.i386.rpm
    give error:

    Code:
    error: Failed dependencies:
            perl(DBI) is needed by MySQL-server-5.0.45-0.glibc23.i386
    i did run /scripts/perlinstaller --force Bundle::DBD::mysql too, but it doesn't fix it

    anybody knows how to solve this?
    HalfDedi.com Half Dedicated Half Price
    We provide affordable VPS hosting solution Singapore datacenter

  2. #2
    Join Date
    Oct 2004
    Location
    Kerala, India
    Posts
    4,750
    Login as root, open the file /var/cpanel/cpanel.config and search for the term mysql-version. Change as given below.

    mysql-version=5

    Then run the following script.

    /scripts/mysqlup --force
    David | www.cliffsupport.com
    Affordable Server Management Solutions sales AT cliffsupport DOT com
    CliffWebManager | Access WHM from iPhone and Android

  3. #3
    david, I already did that.. if not I'll not getting this error message:

    Code:
    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
    HalfDedi.com Half Dedicated Half Price
    We provide affordable VPS hosting solution Singapore datacenter

  4. #4
    Join Date
    Nov 2001
    Location
    Ann Arbor, MI
    Posts
    2,978
    Does Bundle::DBD::mysql contain perl DBI? I haven't checked, but my memory says "no".
    -Mark Adams
    www.bitserve.com - Secure Michigan web hosting for your business.
    Only host still offering a full money back uptime guarantee and prorated refunds.
    Offering advanced server management and security incident response!

  5. #5
    i did run /scripts/perlinstaller --force Bundle::DBD::mysql too, but that didn't help

    search 'DBI' on WHM perl module installer and found 1 exact match, install it and still problem exist.
    HalfDedi.com Half Dedicated Half Price
    We provide affordable VPS hosting solution Singapore datacenter

  6. #6
    you need to remove the perl-DBI rpm package which prevents you to upgrade mysql

    rpm -e --nodeps perl-DBI

    then run: /usr/local/cpanel/bin/checkperlmodules
    (cPanel installs perl-DBI from sources)

    Then you can run the MySQL upgrade
    Server Surgeon George
    http://www.serversurgeon.com
    Linux, BSD and Windows Administration Services
    Toll Free US 877-378-7436 International +1-213-291-9191

  7. #7
    Join Date
    Oct 2004
    Location
    Kerala, India
    Posts
    4,750
    Quote Originally Posted by markhard View Post
    david, I already did that.. if not I'll not getting this error message:
    Try updating cpanel and re-install mysql.
    David | www.cliffsupport.com
    Affordable Server Management Solutions sales AT cliffsupport DOT com
    CliffWebManager | Access WHM from iPhone and Android

  8. #8
    Quote Originally Posted by izghitu View Post
    you need to remove the perl-DBI rpm package which prevents you to upgrade mysql

    rpm -e --nodeps perl-DBI

    then run: /usr/local/cpanel/bin/checkperlmodules
    (cPanel installs perl-DBI from sources)

    Then you can run the MySQL upgrade
    rpm -e --nodeps perl-DBI giving no result.. it seems that package is not installed. i run the checkperlmodules and do mysqlup still getting the same error.
    HalfDedi.com Half Dedicated Half Price
    We provide affordable VPS hosting solution Singapore datacenter

  9. #9
    If you got no result then this means the package has been uninstalled.

    What happens if you do: rpm -e --nodeps perl-DBD-MySQL
    then checkperlmodules then upgrade mysql?
    Server Surgeon George
    http://www.serversurgeon.com
    Linux, BSD and Windows Administration Services
    Toll Free US 877-378-7436 International +1-213-291-9191

  10. #10
    strangely when i try to downgrade to MySQL 4.1, the same problem occurs.

    can't we force MySQL uninstall? as i try to do rpm -e MySQL-server but it does nothing.

    Code:
    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
    HalfDedi.com Half Dedicated Half Price
    We provide affordable VPS hosting solution Singapore datacenter

  11. #11
    Join Date
    Oct 2004
    Location
    Kerala, India
    Posts
    4,750
    Have you tried updating cpanel?
    David | www.cliffsupport.com
    Affordable Server Management Solutions sales AT cliffsupport DOT com
    CliffWebManager | Access WHM from iPhone and Android

  12. #12
    Code:
    rpm -qa perl-DBD-MySQL
    giving no result, which means it's not installed. it is installed by compiling and not rpm isn't it?
    HalfDedi.com Half Dedicated Half Price
    We provide affordable VPS hosting solution Singapore datacenter

  13. #13
    Quote Originally Posted by david510 View Post
    Have you tried updating cpanel?
    yes, that is the second thing i do after /scripts/mysqlup failed
    HalfDedi.com Half Dedicated Half Price
    We provide affordable VPS hosting solution Singapore datacenter

  14. #14
    can we do a force mysql uninstall?
    HalfDedi.com Half Dedicated Half Price
    We provide affordable VPS hosting solution Singapore datacenter

  15. #15
    Join Date
    Oct 2004
    Location
    Kerala, India
    Posts
    4,750
    Use the following.

    rpm -qa | grep My

    Note the resulting rpms.

    rpm -e --nodeps rpm1 rpm2 rpm3
    David | www.cliffsupport.com
    Affordable Server Management Solutions sales AT cliffsupport DOT com
    CliffWebManager | Access WHM from iPhone and Android

  16. #16
    does removing mysql also remove the databases file?
    HalfDedi.com Half Dedicated Half Price
    We provide affordable VPS hosting solution Singapore datacenter

  17. #17
    Join Date
    Oct 2004
    Location
    Kerala, India
    Posts
    4,750
    You can take the backup of the mysql folder before removing the mysql.

    /var/lib/mysql

    Also if you wish you can take the dump of the databases before proceeding.
    David | www.cliffsupport.com
    Affordable Server Management Solutions sales AT cliffsupport DOT com
    CliffWebManager | Access WHM from iPhone and Android

  18. #18
    yes, i currently doing it right now

    thank you
    HalfDedi.com Half Dedicated Half Price
    We provide affordable VPS hosting solution Singapore datacenter

  19. #19
    I'm having the same exact issue. Did you ever manage to get MySql-server updated to 5.x?

  20. #20
    not really.

    the first server having this trouble fixed it self "automagically" on cpanel update

    the second server i install cpanel and upgrade mysql have the same problem. it seems that mysql5 is having conflict with mysql4's glibc. i can't fix it though so the server keep using version 4.1 until now

    if it's a fresh install of cpanel then the easiest solution is to modify the /var/cpanel/cpanel.config when you in the process of installing and modify the mysql version to 5.0 (i have do this and the installation script install mysql 5 directly, so no need to upgrade, but i haven't check again as cpanel modify the installation script)
    HalfDedi.com Half Dedicated Half Price
    We provide affordable VPS hosting solution Singapore datacenter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •