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.

Manual upgrade to MySQL 4.1.22 on the CURRENT tree ?

Discussion in 'General Discussion' started by mOdY, Dec 20, 2006.

  1. mOdY

    mOdY Well-Known Member

    Joined:
    Dec 25, 2004
    Messages:
    80
    Likes Received:
    0
    Trophy Points:
    6
    Hello,

    I realized that the EDGE tree now have the mysql-4.1.22 rpm's, this version addresses many bugs which we really need.

    The question is ! how to manually upgrade from mysql-4.1.21 on the CURRENT tree to mysql-4.1.22 from the EDGE tree, I've got the rpm's related to this.

    Here's the rpm's I've got.

    MySQL-bench-4.1.22-0.glibc23.x86_64.rpm
    MySQL-devel-4.1.22-0.glibc23.x86_64.rpm
    MySQL-server-4.1.22-0.glibc23.x86_64.rpm
    MySQL-client-4.1.22-0.glibc23.x86_64.rpm
    MySQL-embedded-4.1.22-0.glibc23.x86_64.rpm
    MySQL-shared-4.1.22-0.glibc23.x86_64.rpm


    However, when running "$rpm -Uhv *", it spits out this error..

    error: Failed dependencies:
    perl-DBI is needed by MySQL-bench-4.1.22-0.glibc23.x86_64
    perl(DBI) is needed by MySQL-client-4.1.22-0.glibc23.x86_64
    perl(DBI) is needed by MySQL-server-4.1.22-0.glibc23.x86_64


    I queried the rpm database and couldn't fine this perl-DBI rpm installed.

    How is it suggested to proceed ?


    ,Thanks.
     
  2. curriertech

    curriertech Active Member

    Joined:
    Jun 25, 2004
    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    03819
    I'd love to do this as well. I'm not willing to go to EDGE just yet to get it. :eek:
     
  3. deastwood

    deastwood Member

    Joined:
    Sep 22, 2006
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    i could do with this as have a couple of scripts that don't report data correctly under 4.1.21, any help would be appreciated.
     
  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
    This is not supported, so do so at own risk:

    1. Touch /etc/mysqlupdisable
    2. rpm -Uvh --force --nodeps *.rpm
     
  5. deastwood

    deastwood Member

    Joined:
    Sep 22, 2006
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    is it likely to cause issues? will cpanel be supporting it soon, if so i will maybe wait until they do
     
  6. ttk_2k

    ttk_2k Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    45
    Likes Received:
    0
    Trophy Points:
    6
  7. deastwood

    deastwood Member

    Joined:
    Sep 22, 2006
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    no because we already have 4.1 installed.
     
  8. ttk_2k

    ttk_2k Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    45
    Likes Received:
    0
    Trophy Points:
    6
    Ok, thanks... actually I just tried that method a few seconds ago, and I couldn't have my mysql upgraded..

    So anyone tried above ways and got done successfully?
     
  9. ttk_2k

    ttk_2k Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    45
    Likes Received:
    0
    Trophy Points:
    6
    OK, SEEMS TO BE AN IMPORTANT UPDATE

    I tried hardly to successfully upgraded the MySQL on one of my machine from 4.1.21 to 4.1.22, and tested, and no problem at all, BUT BUT BUT.... see what, by running "upcp --force" it downgraded the MySQL version automatically back to 4.1.21. :eek: :eek: :eek:

    So folks I'd suggest you guys do NOT do manually upgrade anything especially if you are like me not a professional server guy.. :D

    Sticking to 4.1.21.... wait untill CPanel to support it, and it will always do the upgrading job for you..

    ciao
    TT

    EDIT: but again, why CPanel still does not support 4.1.22 since this new release of mysql has been released for a couple of months, just curious.
     
    #9 ttk_2k, Mar 9, 2007
    Last edited: Mar 9, 2007
  10. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

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

    That's why you need to touch the /etc/mysqlupdisable file

    We do support 4.1.22, just not in all branches.
     
  11. ttk_2k

    ttk_2k Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    45
    Likes Received:
    0
    Trophy Points:
    6
    OMG I see... so after touch /etc/mysqldisable, it won't be automatically upgraded even by running "upcp --force"??

    Thank you very much.

    [update]

    Ok, done smoothly on all of my servers, just one question however:

    why on every account's cPanel home page, it still shows this:

    MySQL version: 4.1.21-standard

    however on PhpMyAdmin and other places incld SSH are all showing I'm having the new version!

    ???

    Thanks!!

    TT

    [update 2]

    Never mind, solved by this:

    http://forums.cpanel.net/showthread.php?t=58420&highlight=mysql+version+cpanel
     
    #11 ttk_2k, Mar 9, 2007
    Last edited: Mar 9, 2007
  12. Panagioths

    Panagioths Registered

    Joined:
    Mar 15, 2004
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    About how much time is it estimated for the mySQL 4.1.22 to be available for upgrade in a current or stable version?

    Today 10.9.0 (build 7924) - CURRENT Tree was released but it stills supports 4.1.21 only.
     
  13. ttk_2k

    ttk_2k Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    45
    Likes Received:
    0
    Trophy Points:
    6
    Oh... I doubt that would be a short waiting...
     
Loading...

Share This Page