/scripts/mysql out of mirrors

[IberHosting]

Hello,

Is anyone experiencing any mirrors problems while uprgading mysql with /scripts/mysqlup ?

Thanks!

[celliott]

I had the same problem but eventually the install did complete. Also check that you have Wget enabled.

[chirpy]

I've had severe problems with the MySQL mirrors that cPanel uses and have had to resort to installing/upgrading MySQL by hand in the last few days.

[fleksi]

Is it safe to upgrade MySQL manually (by hand) ? How to do that?

-FL-

[cpanelnick]

MySQL 4.0 seems to be a problem now that is disappearing off mirrors. Updating to 4.1 (or 5.x with BETA/EDGE) is probably the best solution.

MySQL has all but given up on the 4.0 stuff.

[fleksi]

I still have error for /scripts/mysqlup
Error 404 while fetching url http://httpupdate.cpanel.net//mysqli...ibc23.i386.rpm
Failed to download a working MySQL-shared-4.1.18-0.glibc23.i386.rpm! Falling back to generic MySQL package.

When /scripts/mysqlup will be fixed?
Im using RHEL 3 & latest EDGE

-FL-

[chirpy]

MySQL 4.0 seems to be a problem now that is disappearing off mirrors. Updating to 4.1 (or 5.x with BETA/EDGE) is probably the best solution.

MySQL has all but given up on the 4.0 stuff.

The MySQL upgrade script to v5 in EDGE is completely broken I've had to hack it by hand to get it working - the embed rpm for v5 isn't on the mirrors and so the whole install loops and then dies. I've also found that the version of 4.1 in WHM is also missing from nearly all the mirrors.

[cpanelnick]

The MySQL upgrade script to v5 in EDGE is completely broken I've had to hack it by hand to get it working - the embed rpm for v5 isn't on the mirrors and so the whole install loops and then dies. I've also found that the version of 4.1 in WHM is also missing from nearly all the mirrors.

What kinda of error did you get (I'm asking after being unable to get it to break)?

[chirpy]

In EDGE (from memory - I know I should have logged a bugzilla entry) mysqlup tried to look for the v5 rpms on httpupdate.cpanel.net in a directory that did not exist for RHE (it was looking in a dir called redhat_enterprise IIRC). Having failed to find the rpms on the cpanel.net server it then went off to find them on the mysql mirrors and failed miserably because none of them had the embed rpm.

For the v4 rpms, IIRC, it checked the mirrors and was looking for 4.1.14 which wasn't on the mirrors (needed 4.1.18).

I'll log the issue properly when I come across it next.

[gemby]

What kinda of error did you get (I'm asking after being unable to get it to break)?

I have problem that mysqlup is looking for 4.1.13 and there is no 4.1.13 on mirrors any more, i checked few manualy. I am running latest stable.

[gemby]

I have problem that mysqlup is looking for 4.1.13 and there is no 4.1.13 on mirrors any more, i checked few manualy. I am running latest stable.

I made bugzilla entry for it.

[gemby]

Here is random picked mirror....

http://mysql.mirrors.arminco.com//Downloads/MySQL-4.1/

[dropby23]

cant we use anymore the mysql 4.0 rpms

[gemby]

I am analizing that thing with mysql today, and now i am apsolutly sure that this thing is going on from at least friday afternoon (morning ins US).

[gemby]

Cpanel guys, shame on you! Nobody is looking bugzilla for whole day, and Nick is only made a quick pick in forum this morning. Shame on you, you have this error from last week.

Ok, here is quick and dirty fix......

1. on one of your sites make file called version

# cd public_html
# pico version
And paste folowing inside:

BETA,EDGE,CURRENT,RELEASE,STABLE,DNSONLY:mysql50:5.0.18:0::shared,shared-compat,devel,embedded,client,bench,server,shared
BETA,EDGE,CURRENT,RELEASE,STABLE,DNSONLY:mysql50-64:5.0.18:0.glibc23::shared,shared-compat,devel,embedded,client,bench,server,shared
BETA,EDGE,CURRENT,RELEASE,STABLE,DNSONLY:mysql40:4.0.25:0::shared,shared-compat,devel,embedded,client,bench,server,shared
UNSTABLE:mysql40:4.0.24:0::shared,shared-compat,devel,embedded,client,bench,server,shared
STABLE,DNSONLY:mysql41:4.1.18:0::shared,devel,embedded,client,bench,server,shared
RELEASE,CURRENT,BETA,EDGE:mysql41:4.1.14:0::shared,devel,embedded,client,bench,server,shared
UNSTABLE:mysql41:4.1.11:0::shared,devel,embedded,client,bench,server,shared
BETA,EDGE,CURRENT,RELEASE,STABLE,DNSONLY:mysql40-64:4.0.25:0::shared,devel,embedded,client,bench,server,shared
UNSTABLE:mysql40-64:4.0.24:0::shared,devel,embedded,client,bench,server,shared
STABLE,DNSONLY:mysql41-64:4.1.13:0.glibc23::shared,devel,embedded,client,bench,server,shared
RELEASE,CURRENT,BETA,EDGE:mysql41-64:4.1.14:0.glibc23::shared,devel,embedded,client,bench,server,shared
UNSTABLE:mysql41-64:4.1.11:0.glibc23::shared,devel,embedded,client,bench,server,shared

Look for line that starts with STABLE,DNSONLY and version of mysql, i put 4.1.18 because it is more then one month old and it is ok for me. I am aware that this version is not as stable as 4.1.13 which is so stable so it is not on mirrors any more, but this is risk i am willing to take.

Then....
pico /scripts/cPpkgversions.pm

and change updates.cpanel.net in url to yourdomain.com in line which contains

my @VERINFO = split(/\n/,httpreq("updates.cpanel.net","/${pv}install/version"))


Then run:
# rm -rf /root/.cpmysqlrpm
# /scripts/mysqlup
After it finshes and says that mysql is started ok

# touch /etc/mysqlupdisable
# /scripts/perlinstaller --force DBD::mysql
# /scripts/perlinstaller --force List::Util

And put back updates.cpanel.net instead of yourdomain.com in

# /scripts/cPpkgversions.pm

And i have succesfuly upgraded mysql in cpanel!

Please, this is testing force upgrade, i am not sure if i have broke something, but so far everything is ok.