Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    151
    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.
     
    #1 galantina, May 24, 2006
  2. barts

    barts Member

    Joined:
    Sep 23, 2004
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    151
    I have the some problem.
     
    #2 barts, May 24, 2006
  3. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,480
    Likes Received:
    29
    Trophy Points:
    158
    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.
     
    #3 cPanelNick, May 24, 2006
  4. galantina

    galantina Member

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

    It finished downloading RPMs after 5 hours:)

    Now I know for the nex time.

    Best Regards.
     
    #4 galantina, May 24, 2006
  5. jamesbond

    jamesbond Well-Known Member

    Joined:
    Oct 9, 2002
    Messages:
    738
    Likes Received:
    1
    Trophy Points:
    168
    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?
     
    #5 jamesbond, May 25, 2006
  6. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,480
    Likes Received:
    29
    Trophy Points:
    158
    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.
     
    #6 cPanelNick, May 25, 2006
  7. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,480
    Likes Received:
    29
    Trophy Points:
    158
    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)
     
    #7 cPanelNick, May 25, 2006
  8. jamesbond

    jamesbond Well-Known Member

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

    jamesbond Well-Known Member

    Joined:
    Oct 9, 2002
    Messages:
    738
    Likes Received:
    1
    Trophy Points:
    168
    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:
    151
    Thanks, this fix works perfectly.
     
    #10 Blackknight, May 26, 2006
  11. jamesbond

    jamesbond Well-Known Member

    Joined:
    Oct 9, 2002
    Messages:
    738
    Likes Received:
    1
    Trophy Points:
    168
    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
     
    #11 jamesbond, May 26, 2006
  12. tetraweb

    tetraweb Member

    Joined:
    May 19, 2003
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    151
    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
     
    #12 tetraweb, Jul 12, 2006
  13. jamesbond

    jamesbond Well-Known Member

    Joined:
    Oct 9, 2002
    Messages:
    738
    Likes Received:
    1
    Trophy Points:
    168
    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.
     
    #13 jamesbond, Jul 12, 2006
(You must log in or sign up to post here.)
Loading...
Similar Threads - very very slow
  1. vinhhali

    New Thread Site loading very slow

    vinhhali, Jun 17, 2018 at 10:08 PM, in forum: Workarounds and Optimization
    Replies:
    0
    Views:
    28
    vinhhali
    Jun 17, 2018 at 10:08 PM
  2. bipsalam

    After upgrade from EA3 to EA4 website with SSL is very slow

    bipsalam, Oct 12, 2017, in forum: EasyApache
    Replies:
    9
    Views:
    752
    Alrissa
    Oct 30, 2017
  3. kaisar alam

    Server Very Slow (Cpu, Load Fine)

    kaisar alam, Aug 14, 2017, in forum: Workarounds and Optimization
    Replies:
    1
    Views:
    547
    cPanelMichael
    Aug 14, 2017
  4. yu0307

    Site very slow, High TTFB, what happened?

    yu0307, Aug 11, 2017, in forum: Workarounds and Optimization
    Replies:
    3
    Views:
    800
    cPanelMichael
    Aug 14, 2017
  5. hicom

    Very slow backup on WHM 64.0 (build 24)

    hicom, Jun 9, 2017, in forum: Data Protection
    Replies:
    1
    Views:
    670
    cPanelChrisI
    Jun 9, 2017

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice