Control Web Panel

WebPanel => MySQL => Topic started by: jonathan1 on August 31, 2017, 05:41:40 PM

Title: getting errors when trying to "stop" the mysql service
Post by: jonathan1 on August 31, 2017, 05:41:40 PM

I'm getting the following errors each time I try to "stop" the mysql service.

Can someone help me figure out why this happens and resolve it?

Code: [Select]

Warning: Error while sending QUERY packet. PID=5284 in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: [obfuscated]() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: [obfuscated]() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
Top 5 Process [live monitor]

Could not select database root_cwp Could not select database root_cwp Could not select database root_cwp
Oh also, then when I go to the dashboard homepage, I get this error (upon second refresh, it loads fine)

Code: [Select]

Warning: [obfuscated](): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0

Warning: [obfuscated](): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0


Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: sh /scripts/restart_cwpsrv

**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf


Warning: [obfuscated]() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Could not connect:

Title: Re: getting errors when trying to "stop" the mysql service
Post by: 24x7servermanagement on August 31, 2017, 08:07:52 PM

Did you recently changed MySQL root password?

If yes then check if its present in these file or not  /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf

Let me know if you are still facing the same issue. :)

Title: Re: getting errors when trying to "stop" the mysql service
Post by: jonathan1 on August 31, 2017, 08:18:22 PM

Nope, I've never changed it. I've never actually used mysql, I installed postgres and have been using that since the start.

I want to disable mysql for the time being since I'm not using it.

How can I resolve the issue if I've never used mysql?

Thank you for your help

Title: Re: getting errors when trying to "stop" the mysql service
Post by: jonathan1 on August 31, 2017, 08:32:47 PM

Also, these passwords do match in both of those files.

Title: Re: getting errors when trying to "stop" the mysql service
Post by: studio4host on September 04, 2017, 09:42:56 AM

you can't stop mysql since cwp is using it and mail server also.

You can stop mysql only if you will not use cwp and emails on that server.

Title: Re: getting errors when trying to "stop" the mysql service
Post by: jonathan1 on September 04, 2017, 03:52:29 PM

oh, had no idea.

Would be great to add more of a warning and usage disclaimer to let people know what apps require it to be running.

thanks