mySQL Crashes after /scripts/upcp update

RazerFX

Member
Feb 4, 2004
9
0
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:


[email protected] [/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:

[email protected] [/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.
 

stratagem

Member
Jul 10, 2003
19
0
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)[email protected]%......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...
 
Last edited:

RazerFX

Member
Feb 4, 2004
9
0
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!
 

RazerFX

Member
Feb 4, 2004
9
0
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.
 

stratagem

Member
Jul 10, 2003
19
0
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.
 

RazerFX

Member
Feb 4, 2004
9
0
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.
 

cPanelNick

Administrator
Staff member
Mar 9, 2015
3,488
35
158
cPanel Access Level
DataCenter Provider
RazerFX said:
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.
Which version of fedora are you running?

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

RazerFX

Member
Feb 4, 2004
9
0
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.
 

cPanelNick

Administrator
Staff member
Mar 9, 2015
3,488
35
158
cPanel Access Level
DataCenter Provider
stratagem said:
ticket #138681

Thanks again.

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.
 

Haloweb

Well-Known Member
Jul 2, 2004
88
0
156
I am having the same problem too this morning :mad:

Please let me know how to downgrade mysql
 

cPanelNick

Administrator
Staff member
Mar 9, 2015
3,488
35
158
cPanel Access Level
DataCenter Provider
RazerFX said:
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.
You can do this, but then its just going to get upgraded again next time upcp runs.
 

Haloweb

Well-Known Member
Jul 2, 2004
88
0
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
 

stratagem

Member
Jul 10, 2003
19
0
151
cpanelnick said:
Fatal error: Can't change to run as user 'mysql'. Please check that the user exists!
Saw that.
cpanelnick said:
uid=100(mysql) gid=101(mysql) groups=101(mysql)
and then that. Now confused, looking for Baily's to add to my coffee.
cpanelnick said:
very odd. still looking.
I'm logged in but have/will not touch anything.

Ray,
:) Thank you.

cpanelnick said:
You can do this, but then its just going to get upgraded again next time upcp runs.
That's what I was afraid of...that, or breaking the cPanel updates.