Author Topic: stop automatic mysql , mariadb  (Read 138 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
stop automatic mysql , mariadb
« 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:

Offline
*****
Re: stop automatic mysql , mariadb
« Reply #1 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?

Offline
*
Re: stop automatic mysql , mariadb
« Reply #2 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)

Offline
*
Re: stop automatic mysql , mariadb
« Reply #3 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  :)

Offline
*****
Re: stop automatic mysql , mariadb
« Reply #4 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.