very very slow Server Software Update

[galantina]

Hi everyone!

As many peaople did I also had trouble with mysql 4.0 on my server today. I tried to solve the problem with changing my mysql version in tweak settings to 4.1 and running Update Server Software afterwards. My problem is that the script (Update Server Software) is running for a few hours because mysql RPMS are downloading extremly slow. After few hours proccess just stopped. After that I run it again hopping that the script will use some faster mirror this time, but it used the same mirror again (http://mysql.mirrors.hoobly.com//). I wonder how can I change the mirror for mysql downloads and shouldn't it be done by a script itself?

Thanks.

Best regards.

 

[barts]

I have the some problem.

 

[cPanelNick]

rm -rf /root/.cpmysqlrpm

will force it to recheck mirrors.

This problem should be moot next month as we are switching to building our own mysql rpms instead of the offical ones as there have been too many problems to count.

 

[galantina]

Thanks.

It finished downloading RPMs after 5 hours

Now I know for the nex time.

Best Regards.

 

[jamesbond]

I just killed the upcp processes, it was still trying to download mysql after 10 hours.

I will try upgrading to 4.0.27 later again, because all mirrors seems either very very slow or not working at all.

Is it possible to update using the rpm's located here (this is for a RH 7.3 server) :

http://updates.cpanel.net/mysqlinstall/4.0.27-0/redhat/7.3/

I noticed MySQL-shared-compat-4.0.27-0.i386.rpm is missing there, is that a problem?

 

[cPanelNick]

I just killed the upcp processes, it was still trying to download mysql after 10 hours.

I will try upgrading to 4.0.27 later again, because all mirrors seems either very very slow or not working at all.

Is it possible to update using the rpm's located here (this is for a RH 7.3 server) :

http://updates.cpanel.net/mysqlinstall/4.0.27-0/redhat/7.3/

I noticed MySQL-shared-compat-4.0.27-0.i386.rpm is missing there, is that a problem?

Those rpms are just fine to update from. Just before to run /scripts/perlinstaller --force Bundle::DBD::mysql afterwards.

You don't need shared-compat with those since they are native built.

 

[cPanelNick]

also the point is moot, since if you have the latest RELEASE or newer it will use those anyways (instead of the mysql official ones)

 

[jamesbond]

Thanks! I'll update to the latest release first then

 

[jamesbond]

also the point is moot, since if you have the latest RELEASE or newer it will use those anyways (instead of the mysql official ones)

I did a /scripts/upcp, and as I expected it tries to install mysql (and testing mirrors for an eternity) before it gets to upgrade to RELEASE.

I'll give it another half hour

If no suitable mirrors can be found the following should work, right?

touch /etc/mysqlupdisable
/scripts/upcp
rm /etc/mysqlupdisable
/scripts/mysqlup
/scripts/perlinstaller --force Bundle::DBD::mysql

I hope this also helps others in the same situation.

UPDATE:

Upgraded to the latest RELEASE, but mysqlup still doesn't work (it's not trying to get the updates from cpanel.net)

MySQL Setup Script Version 7.0
Loaded cPPkgs::MySQL ok!
Fetching version information from http://updates.cpanel.net/mysqlinstall/version (RELEASE)....Fetching http://updates.cpanel.net/mysqlinstall/version (0)[email protected]%......Done
Use of uninitialized value in split at /scripts/cPpkgversions.pm line 59.
Use of uninitialized value in split at /scripts/cPpkgversions.pm line 59.
Use of uninitialized value in split at /scripts/cPpkgversions.pm line 59.
Done
This is the MySQL 4.0.27 installer release number 0 for platform
MySQL-shared is out of date (MySQL-shared-4.0.25-0 != MySQL-shared-4.0.27-0)
MySQL-shared-compat is out of date (MySQL-shared-compat-4.0.25-0 != MySQL-shared-compat-4.0.27-0)
MySQL-devel is out of date (MySQL-devel-4.0.25-0 != MySQL-devel-4.0.27-0)
MySQL-embedded is out of date (MySQL-embedded-4.0.25-0 != MySQL-embedded-4.0.27-0)
MySQL-client is out of date (MySQL-client-4.0.25-0 != MySQL-client-4.0.27-0)
MySQL-bench is out of date (MySQL-bench-4.0.25-0 != MySQL-bench-4.0.27-0)
MySQL-server is out of date (MySQL-server-4.0.25-0 != MySQL-server-4.0.27-0)
MySQL-shared is out of date (MySQL-shared-4.0.25-0 != MySQL-shared-4.0.27-0)

and further down:

Resetting MySQL to cPanel Defaults and Installing the Latest Version
About to fetch MySQL-shared-4.0.27-0.i386.rpm
Ping:1000 Testing connection speed to mysql.localhost.net.ar using wget...(35620 bytes/s)...Done
Ping:1000 Testing connection speed to mysql.mirrored.ca using wget...(310450 bytes/s)...Done
Ping:1000 Testing connection speed to www.stathy.com using wget...test failed...Done
Ping:1000 Testing connection speed to mysql.cs.pu.edu.tw using wget...(10280 bytes/s)...Done
--19:28:53-- http://mysql.mirrored.ca//Downloads/MySQL-4.0/MySQL-shared-4.0.27-0.i386.rpm
=> `/var/spool/cpupdates/MySQL-shared-4.0.27-0.i386.rpm'
Resolving mysql.mirrored.ca... done.
Connecting to mysql.mirrored.ca[142.77.49.222]:80... connected.
HTTP request sent, awaiting response... 404 Not Found
19:28:53 ERROR 404: Not Found.

--19:28:53-- http://mysql.localhost.net.ar//Downloads/MySQL-4.0/MySQL-shared-4.0.27-0.i386.rpm
=> `/var/spool/cpupdates/MySQL-shared-4.0.27-0.i386.rpm'
Resolving mysql.localhost.net.ar... done.
Connecting to mysql.localhost.net.ar[200.43.193.199]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 254,277 [text/plain]

0K .......... .......... .......... .......... .......... 20% 42.55 KB/s
50K .......... .......... .......... .......... .......... 40% 74.18 KB/s
100K .......... .......... .......... .......... .......... 60% 74.74 KB/s
150K .......... .......... .......... .......... .......... 80% 99.60 KB/s
200K .......... .......... .......... .......... ........ 100% 129.54 KB/s

19:28:56 (73.19 KB/s) - `/var/spool/cpupdates/MySQL-shared-4.0.27-0.i386.rpm' saved [254277/254277]

Checking MySQL-shared-4.0.27-0.i386.rpm ....Done
MySQL-shared-4.0.27-0
Check failed with status: 0 and error code 0 !
--19:28:57-- http://mysql.cs.pu.edu.tw//Downloads/MySQL-4.0/MySQL-shared-4.0.27-0.i386.rpm
=> `/var/spool/cpupdates/MySQL-shared-4.0.27-0.i386.rpm'

and so on...

 

[Blackknight]

Thanks, this fix works perfectly.

 

[jamesbond]

Well, this is just odd. Is there perhaps some cache file I have to remove? Cause mysqlup still is testing mirrors instead of just getting the cpanel.net rpm's.

All the 'working' mirrors seem to return this error:


Checking MySQL-shared-4.0.27-0.i386.rpm ....Done
MySQL-shared-4.0.27-0
Check failed with status: 0 and error code 0 !

I'm on 10.8.2-RELEASE_119

 

[tetraweb]

DId you ever resolve this, Jamesbond? I get identical results from upcp every night, trying to update itself to 4.0.27 and having a heck of a time...

Greg

 

[jamesbond]

No, that server is still running 4.0.25. I disabled mysql updates (touch /etc/mysqlupdisable) to prevent it from trying to update to 4.0.27 everyday.

Last week I tried updating (by removing /etc/mysqlupdisable and running /scripts/upcp) but still the same issues.

I haven't really looked into why this server is doing this. Hopefully someone has a fix for this

You could install it manually, but that doesn't solve the mirror issue for updates in the future.