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!

Update MySQL to 4.1.19 manually through cpanel

Discussion in 'General Discussion' started by cooldude7273, May 27, 2006.

  1. cooldude7273

    cooldude7273 Well-Known Member

    Joined:
    Jan 11, 2004
    Messages:
    359
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Roswell, GA
    There's no need to wait for MySQL 4.1.19 to be added to the CURRENT, RELEASE, or STABLE builds, or the need to install it from RPM. I found a way to do it through cpanel while running a non-edge build.

    First thing we need to do is update cPpkgversion to tell the server to get 4.1.19.

    For Fedora 4 users, go here: /root/.cpobjcache/fedora_4_RELEASE_MySQL I'm guessing the rest of the versions and OSs will be similar.

    Now, lets edit cPpkgversion: for me: nano ./cPpkgversion You may have to use vi or pico depending on your OS.

    Now, we have the file where cPanel looks for it's MySQL version, right now, it looks like:

    Code:
    package cPPkgs::MySQL;
    $PKGDATA = {
                 'x86_64' => {
                               '4.0' => {
                                          'flags' => '',
                                          'files' => [
                                                       'MySQL-shared-4.0.27-0.%arch%.rpm',
                                                       'MySQL-devel-4.0.27-0.%arch%.rpm',
                                                       'MySQL-embedded-4.0.27-0.%arch%.rpm',
                                                       'MySQL-client-4.0.27-0.%arch%.rpm',
                                                       'MySQL-bench-4.0.27-0.%arch%.rpm',
                                                       'MySQL-server-4.0.27-0.%arch%.rpm',
                                                       'MySQL-shared-4.0.27-0.%arch%.rpm'
                                                     ],
                                          'version' => '4.0.27',
                                          'release' => '0',
                                          'dir' => '4.0.27-0'
                                        },
                               '5.0' => {
                                          'flags' => '',
                                          'files' => [
                                                       'MySQL-shared-5.0.18-0.glibc23.%arch%.rpm',
                                                       'MySQL-shared-compat-5.0.18-0.glibc23.%arch%.rpm',
                                                       'MySQL-devel-5.0.18-0.glibc23.%arch%.rpm',
                                                       'MySQL-embedded-5.0.18-0.glibc23.%arch%.rpm',
                                                       'MySQL-client-5.0.18-0.glibc23.%arch%.rpm',
                                                       'MySQL-bench-5.0.18-0.glibc23.%arch%.rpm',
                                                       'MySQL-server-5.0.18-0.glibc23.%arch%.rpm',
                                                       'MySQL-shared-5.0.18-0.glibc23.%arch%.rpm'
                                                     ],
                                          'version' => '5.0.18',
                                          'release' => '0.glibc23',
                                          'dir' => '5.0.18-0'
                                        },
                               '4.1' => {
                                          'flags' => '',
                                          'files' => [
                                                       'MySQL-shared-4.1.18-0.glibc23.%arch%.rpm',
                                                       'MySQL-devel-4.1.18-0.glibc23.%arch%.rpm',
                                                       'MySQL-embedded-4.1.18-0.glibc23.%arch%.rpm',
                                                       'MySQL-client-4.1.18-0.glibc23.%arch%.rpm',
                                                       'MySQL-bench-4.1.18-0.glibc23.%arch%.rpm',
                                                       'MySQL-server-4.1.18-0.glibc23.%arch%.rpm',
                                                       'MySQL-shared-4.1.18-0.glibc23.%arch%.rpm'
                                                     ],
                                          'version' => '4.1.18',
                                          'release' => '0.glibc23',
                                          'dir' => '4.1.18-0'
                                        }
                             },
                 'x86' => {
                            '4.0' => {
                                       'flags' => '',
                                       'files' => [
                                                    'MySQL-shared-4.0.27-0.%arch%.rpm',
                                                    'MySQL-shared-compat-4.0.27-0.%arch%.rpm',
                                                    'MySQL-devel-4.0.27-0.%arch%.rpm',
                                                    'MySQL-embedded-4.0.27-0.%arch%.rpm',
                                                    'MySQL-client-4.0.27-0.%arch%.rpm',
                                                    'MySQL-bench-4.0.27-0.%arch%.rpm',
                                                    'MySQL-server-4.0.27-0.%arch%.rpm',
                                                    'MySQL-shared-4.0.27-0.%arch%.rpm'
                                                  ],
                                       'version' => '4.0.27',
                                       'release' => '0',
                                       'dir' => '4.0.27-0'
                                     },
                            '5.0' => {
                                       'flags' => '',
                                       'files' => [
                                                    'MySQL-shared-5.0.18-0.glibc23.%arch%.rpm',
                                                    'MySQL-shared-compat-5.0.18-0.glibc23.%arch%.rpm',
                                                    'MySQL-devel-5.0.18-0.glibc23.%arch%.rpm',
                                                    'MySQL-embedded-5.0.18-0.glibc23.%arch%.rpm',
                                                    'MySQL-client-5.0.18-0.glibc23.%arch%.rpm',
                                                    'MySQL-bench-5.0.18-0.glibc23.%arch%.rpm',
                                                    'MySQL-server-5.0.18-0.glibc23.%arch%.rpm',
                                                    'MySQL-shared-5.0.18-0.glibc23.%arch%.rpm'
                                                  ],
                                       'version' => '5.0.18',
                                       'release' => '0.glibc23',
                                       'dir' => '5.0.18-0'
                                     },
                            '4.1' => {
                                       'flags' => '',
                                       'files' => [
                                                    'MySQL-shared-4.1.18-0.glibc23.%arch%.rpm',
                                                    'MySQL-devel-4.1.18-0.glibc23.%arch%.rpm',
                                                    'MySQL-embedded-4.1.18-0.glibc23.%arch%.rpm',
                                                    'MySQL-client-4.1.18-0.glibc23.%arch%.rpm',
                                                    'MySQL-bench-4.1.18-0.glibc23.%arch%.rpm',
                                                    'MySQL-server-4.1.18-0.glibc23.%arch%.rpm',
                                                    'MySQL-shared-4.1.18-0.glibc23.%arch%.rpm'
                                                  ],
                                       'version' => '4.1.18',
                                       'release' => '0.glibc23',
                                       'dir' => '4.1.18-0'
                                     }
                          }
               };
    1;
    
    Now, simply replace the every instance of 4.1.18 with 4.1.19. Save and exit.

    Enter WHM, click Update Server Software, it'll update you to 4.1.19!! :D

    If you'd like me to do this for you, click the link in my sig, go to Server Security, and order the update MySQL package (near the bottom).

    Enjoy 4.1.19! :D
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. cyrus

    cyrus Member

    Joined:
    Mar 1, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    151
    Dude ! This really worked ! After all the downloading and modifying crap i've been through, this reallly worked!
    Thanks again for sharing it :)
    Keep rocking !
     
  3. cooldude7273

    cooldude7273 Well-Known Member

    Joined:
    Jan 11, 2004
    Messages:
    359
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Roswell, GA
    :D

    Glad to help, I was wondering if anyone was ever going to reply! :(
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. netlook

    netlook Well-Known Member
    PartnerNOC

    Joined:
    Mar 25, 2004
    Messages:
    335
    Likes Received:
    0
    Trophy Points:
    166
    What are the adventages of MySQL 4.1.19 you see?

    Thanks
     
  5. cooldude7273

    cooldude7273 Well-Known Member

    Joined:
    Jan 11, 2004
    Messages:
    359
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Roswell, GA
    It fixes a security vulnerability in 4.1.18, and you can use PHP 5.1.4 :)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. dyrer

    dyrer Active Member

    Joined:
    Jun 3, 2005
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    156
    cPanel Access Level:
    Website Owner
    Is this version 4.1 better than 5
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. joel69

    joel69 Active Member

    Joined:
    Feb 17, 2005
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    151
    Location:
    East Vancouver, BC, Canada
    Good work Cool Dude! I upgraded to MySQL 4.1.19 and managed to convince /scripts/easyapache to run for me. Everything looks good so far.
     
  8. trhosting.net

    trhosting.net Well-Known Member

    Joined:
    Mar 7, 2006
    Messages:
    152
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Turkey
    upcp is now updating MySQL to 4.1.19
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  9. docenta

    docenta Well-Known Member

    Joined:
    May 9, 2006
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    156
    Soould I run /scripts/easyapache after every upgrade of MySQL via CPanel updates ?
     
  10. trhosting.net

    trhosting.net Well-Known Member

    Joined:
    Mar 7, 2006
    Messages:
    152
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Turkey
    If you are not changing the major version (4.0.x -> 4.1.x or 4.1 -> 5.0 etc.) you don't need to run easyapache after every upgrade.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  11. cooldude7273

    cooldude7273 Well-Known Member

    Joined:
    Jan 11, 2004
    Messages:
    359
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Roswell, GA
    Yup, looks like cPanel has rolled 4.1.19 all the way down to the stable builds. :)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  12. jackie46

    jackie46 BANNED

    Joined:
    Jul 25, 2005
    Messages:
    537
    Likes Received:
    0
    Trophy Points:
    166
    /scripts/mysqlup --force
    MySQL Setup Script Version 7.0
    This is the MySQL installer for OS FreeBSD
    Source: packages-5.4-release
    looking up ftp13.freebsd.org
    connecting to ftp13.freebsd.org:21
    setting passive mode
    opening data connection
    initiating transfer
    remote size / mtime: 5419513 / 1114211126
    /root/.cpbsdpkgs/6-1-2006.INDEX 5292 kB 1127 kBps
    mysql-client-4.1 (4.1.10a) is already installed.
    mysql-client-4.1 (4.1.10a) is newer then requested version 4.1.10a. (no install needed)
    Source: packages-5.4-release
    looking up ftp13.freebsd.org
    connecting to ftp13.freebsd.org:21
    setting passive mode
    opening data connection
    initiating transfer
    remote size / mtime: 5419513 / 1114211126
    /root/.cpbsdpkgs/6-1-2006.INDEX 5292 kB 1127 kBps
    mysql-client-4.1 (4.1.10a) is already installed.
    mysql-client-4.1 (4.1.10a) is newer then requested version 4.1.10a. (no install needed)
    mysql-server-4.1 (4.1.10a) is already installed.
    mysql-server-4.1 (4.1.10a) is newer then requested version 4.1.10a. (no install needed)
    mysql-server-4.1 (4.1.10a) is already installed.
    mysql-server-4.1 (4.1.10a) is newer then requested version 4.1.10a. (no install needed)
    Install Complete
     
  13. cooldude7273

    cooldude7273 Well-Known Member

    Joined:
    Jan 11, 2004
    Messages:
    359
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Roswell, GA
    ^^ For linux, that is. It looks like mysqlup is trying to download the latest mysql packages from the freebsd site. And it is doing so correctly, the latest for FreeBSD 5.4 is MySQL 4.1.10a
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  14. cyrus

    cyrus Member

    Joined:
    Mar 1, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    151
    Well with every mysql update, you have a new mysq libclient for php too :) So I would suggest you recompile php as well.
     
  15. jackie46

    jackie46 BANNED

    Joined:
    Jul 25, 2005
    Messages:
    537
    Likes Received:
    0
    Trophy Points:
    166
    :rolleyes:
    I upgraded it last night via ports since UPCP cant do it and 4.1.19 was installed for Freebsd 5.4.
     
  16. fleksi

    fleksi Well-Known Member

    Joined:
    Sep 17, 2003
    Messages:
    125
    Likes Received:
    0
    Trophy Points:
    166
    Does it work for mysql 4.1.20?

    -FL-
     
  17. XPerties

    XPerties Well-Known Member

    Joined:
    Apr 10, 2003
    Messages:
    401
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    New Jersey, USA
    Confirmed, this works with RedHat Enterprise 4 x86_64, Thanks!

     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  18. cooldude7273

    cooldude7273 Well-Known Member

    Joined:
    Jan 11, 2004
    Messages:
    359
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Roswell, GA
    No, cPanel hasn't compiled any 4.1.20 builds yet. I'll post back when they do. (may be awhile)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  19. sokol

    sokol Member

    Joined:
    Jun 8, 2006
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    151
    How about 5.19+?

    -sokol
     
  20. donniesd

    donniesd Member

    Joined:
    Dec 12, 2003
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    151
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