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.

/scripts/mysqlup

Discussion in 'General Discussion' started by Mini, Feb 11, 2006.

  1. Mini

    Mini Well-Known Member

    Joined:
    Mar 4, 2005
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    6
    Hello,

    I was and I still am having problem with mysql so I decided to reinstall mysql. So I did a 'yum remove mysql' and also afterwards, I did a '/scripts/mysqlup' and pressed CTRL+C (abort) about 10 times in the middle of it so that I could stop it to fix something before upgrading. I've rebooted like 5 times and now when I run '/scripts/mysqlup' I get this; does anyone know how to fix this?

    Thanks,
    Mini

    root@kathrine [~]# /scripts/mysqlup
    MySQL Setup Script Version 6.1
    Fetching version information from http://updates.cpanel.net/mysqlinstall/version (STABLE)....Done
    This is the MySQL 4.0.25 installer release number 0 for platform
    MySQL-server is out of date (package MySQL-server is not installed != MySQL-server-4.0.25-0)
    Repository base is listed more than once in the configuration
    Repository addons is listed more than once in the configuration
    Repository extras is listed more than once in the configuration
    Repository extras is listed more than once in the configuration
    Repository updates is listed more than once in the configuration
    Repository base is listed more than once in the configuration
    Repository addons is listed more than once in the configuration
    Using newyum support..
    Repository base is listed more than once in the configuration
    Repository addons is listed more than once in the configuration
    Repository extras is listed more than once in the configuration
    Repository extras is listed more than once in the configuration
    Repository updates is listed more than once in the configuration
    Repository base is listed more than once in the configuration
    Repository addons is listed more than once in the configuration
    Setting up Install Process
    Setting up repositories
    Reading repository metadata in from local files
    Excluding Packages in global exclude list
    Finished
    Parsing package install arguments
    Nothing to do
    Resetting MySQL to cPanel Defaults and Installing the Latest Version
    I ran out of mirrors for MySQL. at /scripts/mysqlup line 227.
     
  2. rustelekom

    rustelekom Well-Known Member
    PartnerNOC

    Joined:
    Nov 13, 2003
    Messages:
    290
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    moscow
    "I ran out of mirrors for MySQL. at /scripts/mysqlup line 227."

    that means you server cannot reach to repositary miirors. this may happen for different reason - from incorrect settings in /etc/yum.conf to problem with your network settings.
    jsut try do whois cpanel.net if you get any whois output, then check your /etc/yum.conf for respositaries url's.
     
  3. dalem

    dalem Well-Known Member
    PartnerNOC

    Joined:
    Oct 24, 2003
    Messages:
    2,577
    Likes Received:
    40
    Trophy Points:
    48
    Location:
    SLC
    cPanel Access Level:
    DataCenter Provider
    rm -rf ~/.cpmysqlrpm

    make sure your resolv.conf is correct

    /scripts/mysqlup
     
  4. joel69

    joel69 Active Member

    Joined:
    Feb 17, 2005
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    East Vancouver, BC, Canada
    I too ran out of mirrors.

    The script

    /scripts/mysqlup

    takes a very long time to run, and ends like this:

    -----------------------------------------------------------------------------------------------------------------------------
    http://mysql.mirrored.ca/

    http://mysql.blic.net/

    http://mysql.mesi.com.ar/

    Ping:26.446 Testing connection speed to mysql.mirror.secondchapter.info using wget...test failed...Done
    Ping:46.868 Testing connection speed to www.unixsoft.org using wget...test failed...Done
    Ping:64.652 Testing connection speed to www.maxmind.com using wget...test failed...Done
    Ping:182.602 Testing connection speed to mysql.ausgamers.com using wget...test failed...Done
    Ping:183.056 Testing connection speed to ftp.sunet.se using wget...test failed...Done
    Ping:198.731 Testing connection speed to www.opensourcecommunity.ph using wget...test failed...Done
    Ping:204.383 Testing connection speed to mysql.mainseek.com using wget...test failed...Done
    Ping:220.244 Testing connection speed to mysql.tsuren.net using wget...test failed...Done
    Ping:225.917 Testing connection speed to mirrors.mybsd.org.my using wget...test failed...Done
    Ping:227.763 Testing connection speed to mysql.interec.es using wget...test failed...Done
    Ping:250.895 Testing connection speed to www.oynasana.com using wget...test failed...Done

    .
    .
    .

    test failed...Done
    I ran out of mirrors for MySQL. at /scripts/mysqlup line 227.
    -----------------------------------------------------------------------------------------------------------------------------

    I have run these commands for testing:

    -----------------------------------------------------------------------------------------------------------------------------
    host www.oynasana.com
    www.oynasana.com is an alias for oynasana.com.
    oynasana.com has address 212.109.99.154
    -----------------------------------------------------------------------------------------------------------------------------

    -----------------------------------------------------------------------------------------------------------------------------
    ping 212.109.99.154
    PING 212.109.99.154 (212.109.99.154) 56(84) bytes of data.
    64 bytes from 212.109.99.154: icmp_seq=0 ttl=48 time=256 ms
    64 bytes from 212.109.99.154: icmp_seq=1 ttl=48 time=256 ms
    64 bytes from 212.109.99.154: icmp_seq=2 ttl=48 time=256 ms

    --- 212.109.99.154 ping statistics ---
    4 packets transmitted, 3 received, 25% packet loss, time 3005ms
    rtt min/avg/max/mdev = 256.114/256.532/256.791/0.510 ms, pipe 2
    -----------------------------------------------------------------------------------------------------------------------------

    www.oynasana.com is just a randomly picked one out of the list that reported to fail. I have managed to resolve its IP and ping that IP, so something else has to be wrong. Does anybody have any ideas?
     
  5. joel69

    joel69 Active Member

    Joined:
    Feb 17, 2005
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    East Vancouver, BC, Canada
    Forgot to mention

    I also followed this advice:

    rm -rf ~/.cpmysqlrpm
    make sure your resolv.conf is correct
    /scripts/mysqlup

    ... It started everything again from scratch but I ran into the same problem then when I did it through the WHM.
     
  6. joel69

    joel69 Active Member

    Joined:
    Feb 17, 2005
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    East Vancouver, BC, Canada
    As I suspected the 25% packet loss was a temporary glitch:

    I ran the ping again for longer:

    --- 212.109.99.154 ping statistics ---
    41 packets transmitted, 41 received, 0% packet loss, time 40051ms
    rtt min/avg/max/mdev = 250.512/255.779/258.097/1.776 ms, pipe 2
     
  7. electron33

    electron33 Well-Known Member

    Joined:
    Feb 24, 2004
    Messages:
    90
    Likes Received:
    0
    Trophy Points:
    16
    How safe is it to upgrade MySQL

    please ignore
     
Loading...

Share This Page