Control Web Panel

WebPanel => CentOS-WebPanel Bugs => Topic started by: diwebcol on June 05, 2020, 04:24:19 AM

Title: Trying to start mysql server, please wait! help!!!!!
Post by: diwebcol on June 05, 2020, 04:24:19 AM: Hello, I was deleting some folders, and suddenly the site stopped working and appears when entering the panel:

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

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

Warning: mysqli_connect(): (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: mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Could not connect:
Title: Re: Trying to start mysql server, please wait! help!!!!!
Post by: rcschaff on June 05, 2020, 04:28:49 AM: What were you deleting??

Manual Reinstall the files with the following:

Code: [Select]
chattr -i -R /usr/local/cwpsrv/htdocs cd /usr/local/cwpsrv/htdocs wget static.cdn-cwp.com/files/cwp/el7/cwp-el7-0.9.8.961.zip unzip -o -q cwp-el7-0.9.8.961.zip rm -f cwp-el7-0.9.8.961.zip ``` **Manual update CentOS 6 (ignore if you have CentOS 7)** ``` chattr -i -R /usr/local/cwpsrv/htdocs cd /usr/local/cwpsrv/htdocs wget dl1.centos-webpanel.com/files/cwp/cwp2-0.9.8.765.zip unzip -o cwp2-0.9.8.765.zip rm -f cwp2-0.9.8.765.zip ``` **Manual update for services (This steep must be done for CentOS 6 and 7)** ``` chattr -R -i /usr/local/cwpsrv/var/services/ cd /usr/local/cwpsrv/var/services/ wget static.cdn-cwp.com/files/cwp/el7/cwp-services.zip unzip -o -q cwp-services.zip rm -f cwp-services.zip
if you delete /root/.my.cnf, you may be screwed.

you can try /scripts/mysql_pwd_reset
Title: Re: Trying to start mysql server, please wait! help!!!!!
Post by: diwebcol on June 05, 2020, 04:46:04 AM: I was deleting in the file manager, backup folders of my sites, and in the home directory also directories of sites that I no longer use or were created directly there.
Title: Re: Trying to start mysql server, please wait! help!!!!!
Post by: diwebcol on June 05, 2020, 04:50:12 AM: Please confirm MySQL root password reset. Continue? (y/N): y
Shutting down any mysql processes...
Stopping mysqld (via systemctl): [ OK ]
mysqld: no process found
Resetting password... hold on
ERROR 1146 (42S02) at line 1: Table 'mysql.user' doesn't exist
Cleaning up...
Stopping mysqld (via systemctl): [ OK ]
Killed mysqld(6835) with signal 15
Starting mysqld (via systemctl): Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
[FAILED]
ERROR! MySQL is not running

Password reset has been completed

New MySQL root password: xxxxxxxxxxx

Remember to store this password safely!
Title: Re: Trying to start mysql server, please wait! help!!!!!
Post by: rcschaff on June 05, 2020, 05:24:36 AM: Your going to want to reinstall mysql/mariadb. After reinstalling, you will have to restore databases.
Title: Re: Trying to start mysql server, please wait! help!!!!!
Post by: diwebcol on June 05, 2020, 05:53:19 PM: how do i re-install and then restore databases

thanks