MySql + FC4 + cpanel

ddaas · 09-27-2006, 02:02 AM

Hi there,
I have a FC4 hosting server with cpanel and mysql (4.0.27-standard). Yesterday I made a critical cpanel update. Since then mysql doesn't work any more.
I doesn't start any more with /etc/rc.d/init.d/mysql start (run as root)
From logs:

Code:

060927 09:53:40  mysqld started
Fatal error: Can't change to run as user 'mysql'.  Please check that the user exists!
060927  9:53:40 Aborting

060927  9:53:40 /usr/sbin/mysqld: Shutdown Complete

060927 09:53:40  mysqld ended

Of course mysql user exist.

Then, I've tried to su myql and start mysqld_safe or mysqld manually. It starts, run for approximately 8-9 minutes and terminates. I've observed that this behaviour repeats every 8-9 minutes. This is very very strange. I don't have any cron job or something that runs every 8 minutes and stops mysql.

What do you say? Any idea? Could it be a mysql bug?

Thanks a lot for your help.

Wim Sturkenboom · 09-27-2006, 03:22 AM

I'm not familiar with cpanel, but I think it's quite funny that you suspect mysql after you've updated cpanel. I would expect the update to be buggy.

Any additional info in the log files when MySQL stops?

ddaas · 09-27-2006, 04:04 AM

cpanel has also updated mysql. no other info in logs. it shuts down and reports that can't change to user mysql

Wim Sturkenboom · 09-27-2006, 05:29 AM

I don't like tools that not only update themselves but also update something else; personally I can not imagine that that has happened but OK.
I don't know what you exactly upgraded, but from the changelog on the cpanel site

Quote:

10.9.0 (build CURRENT) - 12 Tree
Ensure memory limits are unset when restarting chkservd
Added additional checks for execution of privileged binaries

And another point might be that selinux has a problem with your setup. Are you running it?

Last:
There is a cpanel forum on the cpanel website. Did you check there?

bin_asc · 11-01-2006, 03:02 PM

In SSH , do

Quote:

/scripts/upcp --force

Try it and tell me if it works.