Control Web Panel

WebPanel => Information => Topic started by: sdbacchu on October 22, 2024, 04:18:37 AM

Title: stop automatic mysql , mariadb
Post by: sdbacchu on October 22, 2024, 04:18:37 AM

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 Control 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
You can reset the MySQL root password fast with this command: /scripts/mysql_pwd_reset -q


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: stop automatic mysql , mariadb
Post by: overseer on October 22, 2024, 04:34:52 AM

And you followed the advice to check the two files to make sure the MySQL (MariaDB) root password is correct?

Title: Re: stop automatic mysql , mariadb
Post by: sdbacchu on October 22, 2024, 04:52:56 AM

i can not login to mysql.

i find this error log
InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
InnoDB: mmap(134217728 bytes) failed; errno 12
 InnoDB: Cannot allocate memory for the buffer pool
InnoDB: Plugin initialization aborted with error Generic error
Starting shutdown...
 Plugin 'InnoDB' init function returned error.
 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
 [Note] Plugin 'FEEDBACK' is disabled.
 [ERROR] Unknown/unsupported storage engine: InnoDB
[ERROR] Aborting
mysqld: Out of memory (Needed 128663552 bytes)

Title: Re: stop automatic mysql , mariadb
Post by: sdbacchu on October 22, 2024, 05:07:34 AM

i solved the issue now running

i cahnged the /etc/my.cnf file data to

[mysqld]
innodb_buffer_pool_size = 64M

user=mysql
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[client]
socket=/var/lib/mysql/mysql.sock

[client-server]
!includedir /etc/my.cnf.d


then restart mysql

sudo systemctl restart mysqld

then working  :)

Title: Re: stop automatic mysql , mariadb
Post by: Starburst on October 22, 2024, 04:52:54 PM

Just curious what OS & version you are running.

On new servers running CWP 0.9.8.1187 they use mariadb, not mysql anymore.

This many because MariaDB is dropping mysql calls to their newer versions.