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.

very very slow Server Software Update

Discussion in 'General Discussion' started by galantina, May 24, 2006.

  1. galantina

    galantina Member

    Joined:
    Sep 2, 2004
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    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.
     
  2. barts

    barts Member

    Joined:
    Sep 23, 2004
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    I have the some problem.
     
  3. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
    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.
     
  4. galantina

    galantina Member

    Joined:
    Sep 2, 2004
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    Thanks.

    It finished downloading RPMs after 5 hours:)

    Now I know for the nex time.

    Best Regards.
     
  5. jamesbond

    jamesbond Well-Known Member

    Joined:
    Oct 9, 2002
    Messages:
    738
    Likes Received:
    1
    Trophy Points:
    18
    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?
     
  6. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
    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.
     
  7. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
    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)
     
  8. jamesbond

    jamesbond Well-Known Member

    Joined:
    Oct 9, 2002
    Messages:
    738
    Likes Received:
    1
    Trophy Points:
    18
    Thanks! I'll update to the latest release first then :)
     
  9. jamesbond

    jamesbond Well-Known Member

    Joined:
    Oct 9, 2002
    Messages:
    738
    Likes Received:
    1
    Trophy Points:
    18
    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)....@69.90.250.35......connected......receiving...100%......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...
     
    #9 jamesbond, May 25, 2006
    Last edited: May 25, 2006
  10. Blackknight

    Blackknight Member

    Joined:
    Jul 12, 2003
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Thanks, this fix works perfectly.
     
  11. jamesbond

    jamesbond Well-Known Member

    Joined:
    Oct 9, 2002
    Messages:
    738
    Likes Received:
    1
    Trophy Points:
    18
    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
     
  12. tetraweb

    tetraweb Member

    Joined:
    May 19, 2003
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    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
     
  13. jamesbond

    jamesbond Well-Known Member

    Joined:
    Oct 9, 2002
    Messages:
    738
    Likes Received:
    1
    Trophy Points:
    18
    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.
     
Loading...

Share This Page