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.

Cannot upgrade to MySQL5

Discussion in 'General Discussion' started by markhard, Jan 3, 2008.

  1. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    16
    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
     
  2. kernow

    kernow Well-Known Member

    Joined:
    Jul 23, 2004
    Messages:
    865
    Likes Received:
    9
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Are you running perl v5.8.8 ??
    #perl -v
     
  3. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    16
    yes, the perl is 5.8.8

    i did try to install DBI:

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

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,460
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    Try:

    Code:
    rpm -Uvh --nodeps MySQL-server-5.0.45-0.glibc23.i386.rpm
    
     
  5. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    16
    should i run /scripts/mysqlup again after that?
     
  6. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    16
    it still giving error:

    Code:
    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
     
  7. troxalias

    troxalias Well-Known Member

    Joined:
    Nov 21, 2001
    Messages:
    96
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Athens - Greece
    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.
     
  8. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    16
    disabling selinux doesn't help, still the same error
     
  9. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    16
    running rpm -ivh --nodeps MySQL-server-5.0.45-0.glibc23.i386.rpm gives this errors:

    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?
     
  10. troxalias

    troxalias Well-Known Member

    Joined:
    Nov 21, 2001
    Messages:
    96
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Athens - Greece
    Have you tried with yum ?
    yum install mysql-server
     
  11. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    16
    tried that, and it give 'nothing to do' message
     
  12. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    16
    it seems that cpanel do something on the /scripts/upcp, the mysql server is upgraded now with some error message:

     
  13. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    16
    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.
     
  14. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    did you try /scripts/upcp --force
     
  15. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    16
    yes did that already.. didn't work..

    Code:
    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
    
     
  16. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    16
    i'm still having this problem on some servers..
     
  17. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    16
    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.
     
  18. troxalias

    troxalias Well-Known Member

    Joined:
    Nov 21, 2001
    Messages:
    96
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Athens - Greece
    rpm -e mysql --force
     
  19. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    16
    rpm: only installation, upgrading, rmsource and rmspec may be forced
     
  20. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,460
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    try stopping MySQL manually before executing /scripts/mysqlup (you might need the --force flag). Also, try renaming your /etc/my.cnf file as directives therein may be incompatible with the version of MySQL being installed.
     
Loading...

Share This Page