Update MySQL to 4.1.19 manually through cpanel

**cooldude7273** · 05-27-2006, 06:52 PM

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!!

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!

**cyrus** · 05-29-2006, 08:26 PM

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 !

**cooldude7273** · 05-30-2006, 09:55 AM

Originally Posted by cyrus

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 !

Glad to help, I was wondering if anyone was ever going to reply!

**netlook** · 05-30-2006, 02:01 PM

What are the adventages of MySQL 4.1.19 you see?

Thanks

**cooldude7273** · 05-30-2006, 02:32 PM

Originally Posted by netlook

What are the adventages of MySQL 4.1.19 you see?

Thanks

It fixes a security vulnerability in 4.1.18, and you can use PHP 5.1.4

**dyrer** · 05-30-2006, 03:04 PM

Is this version 4.1 better than 5

**joel69** · 05-31-2006, 10:10 PM

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.

**trhosting.net** · 06-01-2006, 01:03 AM

upcp is now updating MySQL to 4.1.19

**docenta** · 06-01-2006, 01:27 AM

Soould I run /scripts/easyapache after every upgrade of MySQL via CPanel updates ?

**trhosting.net** · 06-01-2006, 10:38 AM

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.

**cooldude7273** · 06-01-2006, 11:00 AM

Yup, looks like cPanel has rolled 4.1.19 all the way down to the stable builds.

**jackie46** · 06-01-2006, 12:46 PM

Originally Posted by cooldude7273

Yup, looks like cPanel has rolled 4.1.19 all the way down to the stable builds.

/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

**cooldude7273** · 06-01-2006, 01:49 PM

^^ 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

**cyrus** · 06-02-2006, 08:16 PM

Originally Posted by trhosting.net

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.

Well with every mysql update, you have a new mysq libclient for php too

So I would suggest you recompile php as well.

**jackie46** · 06-02-2006, 10:43 PM

Originally Posted by cooldude7273

^^ 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

I upgraded it last night via ports since UPCP cant do it and 4.1.19 was installed for Freebsd 5.4.

Forums

Thread: Update MySQL to 4.1.19 manually through cpanel

LinkBack

Thread Tools

Update MySQL to 4.1.19 manually through cpanel

Similar Threads

Manually upgrade Mysql to 5.5, CPanel's Database lost

How to update manually Compiled PHP?

Update nameserver zones manually

how do I manually update the webstats?

Way to manually update CPU/Memory/MySQL Usage?

cPanel & WHM

Enkompass

Help

Community

Company

Connect with Us