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!

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:
    166
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. kernow

    kernow Well-Known Member

    Joined:
    Jul 23, 2004
    Messages:
    920
    Likes Received:
    13
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    Are you running perl v5.8.8 ??
    #perl -v
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. markhard

    markhard Well-Known Member

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

    i did try to install DBI:

    after that run /scripts/mysqlup and still get the same error
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,563
    Likes Received:
    43
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    Try:

    Code:
    rpm -Uvh --nodeps MySQL-server-5.0.45-0.glibc23.i386.rpm
    
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    166
    should i run /scripts/mysqlup again after that?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    166
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. troxalias

    troxalias Well-Known Member

    Joined:
    Nov 21, 2001
    Messages:
    96
    Likes Received:
    0
    Trophy Points:
    306
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  8. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    166
    disabling selinux doesn't help, still the same error
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  9. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    166
    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?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  10. troxalias

    troxalias Well-Known Member

    Joined:
    Nov 21, 2001
    Messages:
    96
    Likes Received:
    0
    Trophy Points:
    306
    Location:
    Athens - Greece
    Have you tried with yum ?
    yum install mysql-server
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  11. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    166
    tried that, and it give 'nothing to do' message
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  12. markhard

    markhard Well-Known Member

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

     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  13. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    166
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  14. jayh38

    jayh38 Well-Known Member

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

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    166
    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
    
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  16. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    166
    i'm still having this problem on some servers..
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  17. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    166
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  18. troxalias

    troxalias Well-Known Member

    Joined:
    Nov 21, 2001
    Messages:
    96
    Likes Received:
    0
    Trophy Points:
    306
    Location:
    Athens - Greece
    rpm -e mysql --force
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  19. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    166
    rpm: only installation, upgrading, rmsource and rmspec may be forced
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  20. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,563
    Likes Received:
    43
    Trophy Points:
    308
    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.
     
    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