Update MySQL to 4.1.19 manually through cpanel

C

cooldude7273

Well-Known Member
Jan 11, 2004
357
0
166
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
 
cyrus

cyrus

Member
Mar 1, 2005
16
0
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 !
 
C

cooldude7273

Well-Known Member
Jan 11, 2004
357
0
166
Roswell, GA
cyrus said:
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 !
Click to expand...
:D

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

cooldude7273

Well-Known Member
Jan 11, 2004
357
0
166
Roswell, GA
netlook said:
What are the adventages of MySQL 4.1.19 you see?

Thanks
Click to expand...
It fixes a security vulnerability in 4.1.18, and you can use PHP 5.1.4 :)
 
D

docenta

Well-Known Member
May 9, 2006
64
0
156
Soould I run /scripts/easyapache after every upgrade of MySQL via CPanel updates ?
 
C

cooldude7273

Well-Known Member
Jan 11, 2004
357
0
166
Roswell, GA
Yup, looks like cPanel has rolled 4.1.19 all the way down to the stable builds. :)
 
J

jackie46

BANNED
Jul 25, 2005
536
0
166
cooldude7273 said:
Yup, looks like cPanel has rolled 4.1.19 all the way down to the stable builds. :)
Click to expand...
/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
 
C

cooldude7273

Well-Known Member
Jan 11, 2004
357
0
166
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
 
cyrus

cyrus

Member
Mar 1, 2005
16
0
151
trhosting.net said:
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.
Click to expand...
Well with every mysql update, you have a new mysq libclient for php too :) So I would suggest you recompile php as well.
 
J

jackie46

BANNED
Jul 25, 2005
536
0
166
:rolleyes:
cooldude7273 said:
^^ 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
Click to expand...
I upgraded it last night via ports since UPCP cant do it and 4.1.19 was installed for Freebsd 5.4.
 
X

XPerties

Well-Known Member
Apr 10, 2003
401
0
166
New Jersey, USA
Confirmed, this works with RedHat Enterprise 4 x86_64, Thanks!

/.cpobjcache/redhat_enterprise_4_STABLE_MySQL/cPpkgversion
Click to expand...
 
C

cooldude7273

Well-Known Member
Jan 11, 2004
357
0
166
Roswell, GA
fleksi said:
Does it work for mysql 4.1.20?

-FL-
Click to expand...
No, cPanel hasn't compiled any 4.1.20 builds yet. I'll post back when they do. (may be awhile)
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
R Unable to update from mysql to mariadb Databases 6
P The update from MySQL 5.7 to 8.0 failed Databases 7
Michaelit High CPU load on MySqld once update to Cpanel v.102.0.8 Databases 8
O Update mysql Which version i choose? Databases 2
manoaratefy MySQL clustering - Does users need to update their MySQL hosts on configuration file? Databases 3
Similar threads
Unable to update from mysql to mariadb
The update from MySQL 5.7 to 8.0 failed
High CPU load on MySqld once update to Cpanel v.102.0.8
Update mysql Which version i choose?
MySQL clustering - Does users need to update their MySQL hosts on configuration file?
Top Bottom