mySQL Crashes after /scripts/upcp update

[RazerFX]

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]

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

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...

 

[RazerFX]

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]

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]

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.

 

[cPanelNick]

What distro/version are you running ?

 

[RazerFX]

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]

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

 

[gtntguru]

How do you gracefully downgrade to 4.0.23?

 

[stratagem]

Fedora Core 4 i686
WHM 10.8.0 cPanel 10.8.2-R83

Thanks Nick (and RazerFX).

Mike

 

[cPanelNick]

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.

 

[gtntguru]

ticket# 138679

thanks!

 

[kyriakos]

How do you gracefully downgrade to 4.0.23?

thats what I'd like too know too.

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

 

[stratagem]

ticket #138681

Thanks again.

 

[RazerFX]

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]

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]

I am having the same problem too this morning

Please let me know how to downgrade mysql

 

[cPanelNick]

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]

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]

Fatal error: Can't change to run as user 'mysql'. Please check that the user exists!

Saw that.

uid=100(mysql) gid=101(mysql) groups=101(mysql)

and then that. Now confused, looking for Baily's to add to my coffee.

very odd. still looking.

I'm logged in but have/will not touch anything.

Ray,
Thank you.

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.