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:
    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,451
    Likes Received:
    12
    Trophy Points:
    148
    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,451
    Likes Received:
    12
    Trophy Points:
    148
    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,451
    Likes Received:
    12
    Trophy Points:
    148
    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. hicom

    Very slow backup on WHM 64.0 (build 24)

    hicom, Jun 9, 2017, in forum: Data Protection
    Replies:
    1
    Views:
    68
    cPanelChrisI
    Jun 9, 2017
  2. Israel_Paya

    My dedicated server goes very slow

    Israel_Paya, May 10, 2017, in forum: General Discussion
    Replies:
    2
    Views:
    105
    Dilan
    May 11, 2017
  3. Hostmag

    Very slow new account

    Hostmag, Oct 9, 2016, in forum: Workarounds and Optimization
    Replies:
    2
    Views:
    297
    cPanelMichael
    Oct 11, 2016
  4. Mugoma

    Apache HTTPD very slow

    Mugoma, Sep 13, 2016, in forum: EasyApache
    Replies:
    4
    Views:
    545
    NOC_Serverpoint
    Sep 21, 2016
  5. mlody69

    Very slow mysql queryies

    mlody69, Feb 9, 2016, in forum: Workarounds and Optimization
    Replies:
    5
    Views:
    800
    cPanelMichael
    Feb 23, 2016

Share This Page