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.

Page 1 of 4
  1. RazerFX

    RazerFX Member

    Joined:
    Feb 4, 2004
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    151
    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.
     
    #1 RazerFX, May 23, 2006
  2. stratagem

    stratagem Member

    Joined:
    Jul 10, 2003
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    151
    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:
    151
    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!
     
    #3 RazerFX, May 24, 2006
  4. RazerFX

    RazerFX Member

    Joined:
    Feb 4, 2004
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    151
    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.
     
    #4 RazerFX, May 24, 2006
  5. stratagem

    stratagem Member

    Joined:
    Jul 10, 2003
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    151
    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.
     
    #5 stratagem, May 24, 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
    What distro/version are you running ?
     
    #6 cPanelNick, May 24, 2006
  7. RazerFX

    RazerFX Member

    Joined:
    Feb 4, 2004
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    151
    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.
     
    #7 RazerFX, May 24, 2006
  8. cPanelNick

    cPanelNick Administrator
    Staff Member

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

    You can drop the cpanel and call me Nick if you like :)
     
    #8 cPanelNick, May 24, 2006
  9. gtntguru

    gtntguru Member

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

    stratagem Member

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

    Thanks Nick (and RazerFX).

    Mike
     
    #10 stratagem, May 24, 2006
  11. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,451
    Likes Received:
    12
    Trophy Points:
    148
    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.
     
    #11 cPanelNick, May 24, 2006
  12. gtntguru

    gtntguru Member

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

    thanks!
     
    #12 gtntguru, May 24, 2006
  13. kyriakos

    kyriakos Member

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

    is upgrading to 4.1 solving the problem too? I might give that a go.
     
    #13 kyriakos, May 24, 2006
  14. stratagem

    stratagem Member

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

    Thanks again.
     
    #14 stratagem, May 24, 2006
  15. RazerFX

    RazerFX Member

    Joined:
    Feb 4, 2004
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    151
    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.
     
    #15 RazerFX, May 24, 2006
  16. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,451
    Likes Received:
    12
    Trophy Points:
    148
    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.
     
    #16 cPanelNick, May 24, 2006
  17. Haloweb

    Haloweb Well-Known Member

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

    Please let me know how to downgrade mysql
     
    #17 Haloweb, May 24, 2006
  18. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,451
    Likes Received:
    12
    Trophy Points:
    148
    cPanel Access Level:
    DataCenter Provider
    You can do this, but then its just going to get upgraded again next time upcp runs.
     
    #18 cPanelNick, May 24, 2006
  19. Haloweb

    Haloweb Well-Known Member

    Joined:
    Jul 2, 2004
    Messages:
    88
    Likes Received:
    0
    Trophy Points:
    156
    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
     
    #19 Haloweb, May 24, 2006
  20. stratagem

    stratagem Member

    Joined:
    Jul 10, 2003
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    151
    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.
     
    #20 stratagem, May 24, 2006
(You must log in or sign up to post here.)
Page 1 of 4
Loading...
Similar Threads - mySQL Crashes scripts
  1. nhadsall

    mysql cpu usage high, and crashes vps

    nhadsall, Jan 22, 2016, in forum: Workarounds and Optimization
    Replies:
    2
    Views:
    816
    cPanelMichael
    Jan 25, 2016
  2. unicornication

    MySQL crashes every other day, tuning ideas?

    unicornication, Oct 20, 2015, in forum: Workarounds and Optimization
    Replies:
    3
    Views:
    649
    cPanelMichael
    Oct 27, 2015
  3. Motamedi

    MySQL Usage and crashes every few hours

    Motamedi, Aug 9, 2015, in forum: Workarounds and Optimization
    Replies:
    4
    Views:
    678
    cPanelMichael
    Aug 11, 2015
  4. Skhilled44

    Installing mySQL and MariaDB

    Skhilled44, Jul 22, 2017 at 6:53 PM, in forum: Database Discussions
    Replies:
    1
    Views:
    12
    cPanelMichael
    Jul 24, 2017 at 11:00 AM
  5. Droidism20011

    MySQL -> MariaDB security questions

    Droidism20011, Jul 20, 2017 at 2:21 PM, in forum: Security
    Replies:
    3
    Views:
    65
    Droidism20011
    Jul 24, 2017 at 3:16 AM

Share This Page