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.

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:
    363
    Likes Received:
    0
    Trophy Points:
    16
    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
     
  2. cyrus

    cyrus Member

    Joined:
    Mar 1, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    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:
    363
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Roswell, GA
    :D

    Glad to help, I was wondering if anyone was ever going to reply! :(
     
  4. netlook

    netlook Well-Known Member
    PartnerNOC

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

    Thanks
     
  5. cooldude7273

    cooldude7273 Well-Known Member

    Joined:
    Jan 11, 2004
    Messages:
    363
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Roswell, GA
    It fixes a security vulnerability in 4.1.18, and you can use PHP 5.1.4 :)
     
  6. dyrer

    dyrer Active Member

    Joined:
    Jun 3, 2005
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Website Owner
    Is this version 4.1 better than 5
     
  7. joel69

    joel69 Active Member

    Joined:
    Feb 17, 2005
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    1
    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:
    151
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Turkey
    upcp is now updating MySQL to 4.1.19
     
  9. docenta

    docenta Well-Known Member

    Joined:
    May 9, 2006
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    6
    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:
    151
    Likes Received:
    0
    Trophy Points:
    16
    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.
     
  11. cooldude7273

    cooldude7273 Well-Known Member

    Joined:
    Jan 11, 2004
    Messages:
    363
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Roswell, GA
    Yup, looks like cPanel has rolled 4.1.19 all the way down to the stable builds. :)
     
  12. jackie46

    jackie46 BANNED

    Joined:
    Jul 25, 2005
    Messages:
    537
    Likes Received:
    0
    Trophy Points:
    0
    /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:
    363
    Likes Received:
    0
    Trophy Points:
    16
    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
     
  14. cyrus

    cyrus Member

    Joined:
    Mar 1, 2005
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    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:
    0
    :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:
    16
    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:
    16
    Location:
    New Jersey, USA
    Confirmed, this works with RedHat Enterprise 4 x86_64, Thanks!

     
  18. cooldude7273

    cooldude7273 Well-Known Member

    Joined:
    Jan 11, 2004
    Messages:
    363
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Roswell, GA
    No, cPanel hasn't compiled any 4.1.20 builds yet. I'll post back when they do. (may be awhile)
     
  19. sokol

    sokol Member

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

    -sokol
     
  20. donniesd

    donniesd Member

    Joined:
    Dec 12, 2003
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
Loading...

Share This Page