Control Web Panel

WebPanel => CentOS 6 Problems => Topic started by: mouchoon on January 05, 2019, 08:07:04 PM

Title: mysql crashed after server migration please help!
Post by: mouchoon on January 05, 2019, 08:07:04 PM
hello!

my server migrat to other location ... and my sql server crashed with this error in cwp:

Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0

Warning: mysqli_connect(): (HY000/2002): Connection refused 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:

how to solve this problem? It seems that innodb
Title: Re: mysql crashed after server migration please help!
Post by: Netino on January 06, 2019, 01:13:40 AM
Check if the passwords match between files:
/usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php
and
/root/.my.cnf

If the passwords mismatch, correct them.
It must be exact same in both files.

Restart mysql:
# systemctl restart mariadb (if in CentOS7)
or
# service mariadb restart (if in CentOS6)

Regards,
Netino
Title: Re: mysql crashed after server migration please help!
Post by: mouchoon on January 06, 2019, 09:52:52 PM
the passwords in both files similar

# service mariadb restart
mariadb: unrecognized service


# mysqlcheck --all-databases -r #repair
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) when trying to connect

also /var/lib/mysql/mysql.sock   is 0 kilibyte and not editable

What else comes to mind?

thanks
Title: Re: mysql crashed after server migration please help!
Post by: Netino on January 06, 2019, 11:39:52 PM
Seems you don't have mariadb installed.
Try that command with 'mysql'.

And list here the result of commands "systemctl status mariadb.service" or "systemctl status mysql.service" and "journalctl -xe".
Title: Re: mysql crashed after server migration please help!
Post by: mouchoon on January 07, 2019, 05:58:20 AM
#systemctl status mysql.service or systemctl status mysqld.service ->
command not found
#systemctl status mariadb.service ->
command not found

why?

# tail -f /var/log/mysqld.log
/usr/libexec/mysqld[0x7b0c10]
/usr/libexec/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x41)[0x67b271]
/usr/libexec/mysqld[0x58fe78]
/usr/libexec/mysqld(_Z11plugin_initPiPPci+0x928)[0x593a68]
/usr/libexec/mysqld[0x519338]
/usr/libexec/mysqld(_Z11mysqld_mainiPPc+0x3fd)[0x51c5fd]
/lib64/libc.so.6(__libc_start_main+0xfd)[0x3d4d01ed1d]
/usr/libexec/mysqld[0x511c85]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Title: Re: mysql crashed after server migration please help!
Post by: amlanrd on June 14, 2021, 06:53:23 PM
hello!

my server migrat to other location ... and my sql server crashed with this error in cwp:

Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0

Warning: mysqli_connect(): (HY000/2002): Connection refused 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:

how to solve this problem? It seems that innodb


Hi,

I'm facing the same issue. I hope you have already resolved the issue. Can you please help me out to resolve mine too?
Title: Re: mysql crashed after server migration please help!
Post by: Igor S. on July 11, 2021, 10:05:26 AM
Why do you trying systemctl with CentOS 6? You must try service mysqld status or service mysqld restart