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.

mySQL Crashes after /scripts/upcp update

Discussion in 'General Discussion' started by RazerFX, May 23, 2006.

  1. RazerFX

    RazerFX Member

    Joined:
    Feb 4, 2004
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Hello Folks:

    My cPanel has been working excellent for the past 3+ months without issues. Everyday the /scripts/upcp runs at the same time.

    Today as usual, the /upcp/scripts completed its job at 9:07 PM (EST) and at 9:09 PM (EST) mysql has not been working at all.

    When I run a mysqld_safe I get the following:


    root@clients [/scripts]# mysqld_safe
    Starting mysqld daemon with databases from /var/lib/mysql
    STOPPING server from pid file /var/lib/mysql/clients.pid
    060524 00:25:09 mysqld ended

    When I run mysqld I get the following:

    root@clients [/scripts]# mysqld
    Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
    060524 0:37:11 Aborting
    060524 0:37:11 mysqld: Shutdown Complete

    I ran a /scripts/upcp --force and also ran a /scripts/mysqlup without results.

    Now before I go ahead and manually create the sockets and do other things and forcefully make mysql work - I want to understand why this problem occurred and how to avoid it in the future.

    Most importantly I want to know how this issue can be resolved from within cPanel, vs. me doing this the hard way, re-installing mysql, re-create all symlinks etc.

    I've posted a ticket directly with the makers of cPanel, but I would also love to hear from any of you folks, as your knowledge sharing is definitely appreciated!

    Thanks and regards,
    Ray.
     
  2. stratagem

    stratagem Member

    Joined:
    Jul 10, 2003
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    Cpanel/WHM daily update (RELEASE) 12:28 AM GMT-4
    eximstats failed 12:29 AM GMT-4
    mysqld failed 12:29 AM GMT-4

    WHM -> Restart SQL server (MySQL)
    -- error: 'Can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock' (2)'
    -- Check that mysqld is running and that the socket: 'var/lib/mysql/mysql.sock' exists!

    WTF?

    Login to WHM, awake. Security warning, Apache 1.3.36 (running Apache 1.3.34).
    WHM -> cPanel -> Upgrade to Latest Version

    note the scripts errors and .26
    Code:
    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.36......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.
    Done
    This is the MySQL 4.0.26 installer release number 0 for platform
    .
    .
    .
    
    *sniffle* Looks like it's time to brew a pot of coffee...
     
    #2 stratagem, May 24, 2006
    Last edited: May 24, 2006
  3. RazerFX

    RazerFX Member

    Joined:
    Feb 4, 2004
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Makes two of us!

    Ok... Looks like it's two of us now. Do you have a SIP Phone, or can you download a SIP compatible software phone? I can give you an extension on my VOIP server & we both can talk and brain storm on how to fix this. Alternative I can give you my direct number or you can give me yours and we can try to resolve this talking on the phone.

    My clients overseas are irated!!! Try dealing with people from Israel and Asian business men in Asia. While they yap and curse over the phone, I just put my phone down on the desk and I can still hear them yell while I drink my coffee and am so thankfull that I'm not in the same country or room with them! LOL!

    So in my situation when one runs his/her own business, to survive in this cut-throat business, one must sollow his/her pride, take the verbal abuse, fix the problem and keep making money ;).

    Cheers!
     
  4. RazerFX

    RazerFX Member

    Joined:
    Feb 4, 2004
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    What version of mysql are you running?

    Stratagem:

    What version of mySQL are you running? Can you do a:
    mysql -V and let me know what your output is?

    Mine is:
    mysql Ver 12.22 Distrib 4.0.26

    My problem has been resolved. All that I did was forced a downgrade of mySQL to
    mysql Ver 12.22 Distrib 4.0.23

    I tell ya! It's them damn upcp scripts! It breaks version 4.0.26 after a upcp update. So.... if you are running the same version... downgrade it!

    Good luck!
    Ray.
     
  5. stratagem

    stratagem Member

    Joined:
    Jul 10, 2003
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    mysql Ver 12.22 Distrib 4.0.26

    Thanks for the pointer. I thought as much after noticing the version change in upcp output. I'm going to look into the problem in a few minutes, right after I deal with a few more people who seem to know my home number :(.

    Happy to hear you sorted yourself out.
     
  6. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
    What distro/version are you running ?
     
  7. RazerFX

    RazerFX Member

    Joined:
    Feb 4, 2004
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Version/Distro

    Hello Cpnel Nick!

    I am using WHM 10.8.0 cPanel 10.8.2-R83 running on Fedora i686. Hope this helps to debug future problems with others.

    By the way... are are your first names? I feel weird calling you guys Strategem or CpanelNick ;).


    Cheers!
    Ray.
     
  8. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
    Which version of fedora are you running?

    You can drop the cpanel and call me Nick if you like :)
     
  9. gtntguru

    gtntguru Member

    Joined:
    May 24, 2006
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    How do you gracefully downgrade to 4.0.23?
     
  10. stratagem

    stratagem Member

    Joined:
    Jul 10, 2003
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    Fedora Core 4 i686
    WHM 10.8.0 cPanel 10.8.2-R83

    Thanks Nick (and RazerFX).

    Mike
     
  11. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
    If you open a ticket, I'll be happy to look @ anyone's server who is having a problem. Please post the ticket # as well.
     
  12. gtntguru

    gtntguru Member

    Joined:
    May 24, 2006
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    ticket# 138679

    thanks!
     
  13. kyriakos

    kyriakos Member

    Joined:
    May 24, 2006
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    thats what I'd like too know too.

    is upgrading to 4.1 solving the problem too? I might give that a go.
     
  14. stratagem

    stratagem Member

    Joined:
    Jul 10, 2003
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    ticket #138681

    Thanks again.
     
  15. RazerFX

    RazerFX Member

    Joined:
    Feb 4, 2004
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Kyriakos: I cannot gurantee you that upgrading will work, though you are welcome to try it at your own risk and let us know. If the version number of your mySQL corresponds to my exact version, only then I recommend you to take that chance.

    Mike, Kyriakos, and Gtntguru:


    Gracefully Downgrading? Or Forcefully Downgrading? ;) Below are the steps.

    1. Go to: http://updates.cpanel.net/mysqlinstall/i386/
    2. Download ALL files from there except Mysql-Bench
    3. Run rpm -Uvh MySQL-*.rpm --force
    4. Under your /scripts directory, run ./restartsrv_mysql
    5. Keep your fingers crossed
    6. Pray to what ever God you believe in! ;)


    If you succeed, go give some donations to the Red Cross.

    Good luck!
    Ray.
     
  16. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider

    Fatal error: Can't change to run as user 'mysql'. Please check that the user exists!
    uid=100(mysql) gid=101(mysql) groups=101(mysql)

    very odd. still looking.
     
  17. Haloweb

    Haloweb Well-Known Member

    Joined:
    Jul 2, 2004
    Messages:
    88
    Likes Received:
    0
    Trophy Points:
    6
    I am having the same problem too this morning :mad:

    Please let me know how to downgrade mysql
     
  18. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
    You can do this, but then its just going to get upgraded again next time upcp runs.
     
  19. Haloweb

    Haloweb Well-Known Member

    Joined:
    Jul 2, 2004
    Messages:
    88
    Likes Received:
    0
    Trophy Points:
    6
    I tried running /scripts/upcp --force

    and found the following

    MySQL-shared is out of date (package MySQL-shared is not installed != MySQL-shared-4.0.26-0)
    MySQL-shared is out of date (package MySQL-shared is not installed != MySQL-shared-4.0.26-0)

    It also seems like there is a problem getting the latest update
    mysql.mirrors.hoobly.com keeps timing out

    I hope this will help a bit
     
  20. stratagem

    stratagem Member

    Joined:
    Jul 10, 2003
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    Saw that.
    and then that. Now confused, looking for Baily's to add to my coffee.
    I'm logged in but have/will not touch anything.

    Ray,
    :) Thank you.

    That's what I was afraid of...that, or breaking the cPanel updates.
     
Loading...

Share This Page