Author Topic: Problem Danger: MySQL - BAD CONFIGURATION DETECTED  (Read 6903 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Problem Danger: MySQL - BAD CONFIGURATION DETECTED
« on: March 25, 2022, 07:37:08 PM »
Hello everyone, when I login as an administrator I am getting this error:

Code: [Select]
Danger: MySQL - BAD CONFIGURATION DETECTED
MySQL bad configuration detected, check from the console by using mysql command !!!

I hope you can help me to solve it.

Offline
****
Re: Problem Danger: MySQL - BAD CONFIGURATION DETECTED
« Reply #1 on: March 26, 2022, 01:24:42 AM »
please post the results of " journalctl -xeu mysqld "

Also, when you go into ssh, and run " mysql ", what does it say?
Google Hangouts:  rcschaff82@gmail.com

Offline
*
Re: Problem Danger: MySQL - BAD CONFIGURATION DETECTED
« Reply #2 on: March 26, 2022, 02:57:59 AM »
hello, thanks for answering, when I put the code

journalctl -xeu mysqld

Code: [Select]
[root@serverbackup492018i3 ~]# journalctl -xeu mysqld
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
-- Logs begin at Thu 2022-03-24 20:15:59 -05, end at Fri 2022-03-25 21:55:28 -05. --
-- No entries --
[root@serverbackup492018i3 ~]#

and code mysql

Code: [Select]
[root@serverbackup492018i3 ~]# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 282
Server version: 10.4.24-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

Offline
****
Re: Problem Danger: MySQL - BAD CONFIGURATION DETECTED
« Reply #3 on: March 26, 2022, 03:16:26 AM »
It seems like mariadb is running.  When exactly are you getting that error?
Google Hangouts:  rcschaff82@gmail.com

Offline
*
Re: Problem Danger: MySQL - BAD CONFIGURATION DETECTED
« Reply #4 on: March 27, 2022, 05:40:20 PM »
When I enter the login I get the error shown below.



After it finishes loading and it stays like this with a blank screen without being able to choose options.


Offline
****
Re: Problem Danger: MySQL - BAD CONFIGURATION DETECTED
« Reply #5 on: March 27, 2022, 06:38:01 PM »
Please run

sh /scripts/mysql_pwd_reset

Google Hangouts:  rcschaff82@gmail.com

Offline
*
Re: Problem Danger: MySQL - BAD CONFIGURATION DETECTED
« Reply #6 on: March 27, 2022, 07:10:54 PM »
I put the command that you indicated and followed the instructions of it, but the problem persists.

Code: [Select]
[root@localhost ~]# sh /scripts/mysql_pwd_reset

Enter the new root password (at least 8 chars).
Or leave it empty if you would like to generate it.
Or press CTRL+C to abort and do not touch it

Enter MySQL root password (NO special characters): ************
Shutting down any mysql processes...
/scripts/mysql_pwd_reset: line 14: [: -eq: unary operator expected
Redirecting to /bin/systemctl stop mariadb.service
/scripts/mysql_pwd_reset: line 26: [: -eq: unary operator expected
Redirecting to /bin/systemctl start mariadb.service
Resetting password... hold on
Cleaning up...
/scripts/mysql_pwd_reset: line 14: [: -eq: unary operator expected
Redirecting to /bin/systemctl stop mariadb.service

Password reset has been completed

New MySQL root password: ************

Remember to store this password safely!

/scripts/mysql_pwd_reset: line 26: [: -eq: unary operator expected
Redirecting to /bin/systemctl start mariadb.service
[root@localhost ~]#

Offline
****
Re: Problem Danger: MySQL - BAD CONFIGURATION DETECTED
« Reply #7 on: March 28, 2022, 12:32:03 AM »
Please post the results of the following command:

tail -n 50 /usr/local/cwpsrv/logs/error_log
Google Hangouts:  rcschaff82@gmail.com

Offline
*
Re: Problem Danger: MySQL - BAD CONFIGURATION DETECTED
« Reply #8 on: March 28, 2022, 01:41:11 AM »
hi this is result of command.

Code: [Select]
[root@serverbackup492018i3 ~]# tail -n 50 /usr/local/cwpsrv/logs/error_log
PHP message: PHP Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0" while reading response header from upstream, client: 186.68.104.140, server: localhost, request: "GET /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=csf HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer: "https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=freedns"
2022/03/27 16:03:25 [error] 964#0: *125 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP message: PHP Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0" while reading response header from upstream, client: 186.68.104.140, server: localhost, request: "GET /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=csf HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer: "https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=freedns"
2022/03/27 16:03:38 [error] 964#0: *126 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP message: PHP Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0" while reading response header from upstream, client: 186.68.104.140, server: localhost, request: "GET /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=scripts_manager HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer: "https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=csf"
2022/03/27 16:03:50 [error] 964#0: *125 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP message: PHP Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0" while reading response header from upstream, client: 186.68.104.140, server: localhost, request: "GET /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=settings HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer: "https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=scripts_manager"
2022/03/27 16:08:14 [error] 965#0: *134 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP message: PHP Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0" while reading response header from upstream, client: 186.68.104.140, server: localhost, request: "POST /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=settings HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer: "https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=settings"
2022/03/27 16:08:32 [error] 964#0: *135 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP message: PHP Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0" while reading response header from upstream, client: 186.68.104.140, server: localhost, request: "GET /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=settings HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer: "https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=settings"
2022/03/27 16:08:54 [error] 965#0: *134 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP message: PHP Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0" while reading response header from upstream, client: 186.68.104.140, server: localhost, request: "GET /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=ip_manager HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer: "https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=settings"
2022/03/27 16:09:07 [error] 964#0: *135 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP message: PHP Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0" while reading response header from upstream, client: 186.68.104.140, server: localhost, request: "GET /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=file_editor&file=/etc/sysconfig/selinux HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer: "https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=ip_manager"
2022/03/27 16:09:14 [error] 965#0: *134 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP message: PHP Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0" while reading response header from upstream, client: 186.68.104.140, server: localhost, request: "GET /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=webpanel_addons HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer: "https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=file_editor&file=/etc/sysconfig/selinux"
2022/03/27 16:09:22 [error] 965#0: *134 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP message: PHP Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0" while reading response header from upstream, client: 186.68.104.140, server: localhost, request: "GET /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=admin_apis HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer: "https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=webpanel_addons"
2022/03/27 16:09:22 [info] 965#0: *147 client 127.0.0.1 closed keepalive connection
2022/03/27 16:09:22 [notice] 965#0: *150 "^/v1/([^/]+)/?$" matches "/v1/valid_user/", client: 127.0.0.1, server: localhost, request: "GET /v1/valid_user/ HTTP/1.1", host: "127.0.0.1:2302"
2022/03/27 16:09:22 [notice] 965#0: *150 rewritten data: "/v1/index.php", args: "method=", client: 127.0.0.1, server: localhost, request: "GET /v1/valid_user/ HTTP/1.1", host: "127.0.0.1:2302"
2022/03/27 16:09:22 [info] 965#0: *150 client 127.0.0.1 closed keepalive connection
2022/03/27 16:09:23 [error] 965#0: *134 FastCGI sent in stderr: "PHP message: PHP Notice:  Trying to get property 'num_rows' of non-object in /usr/local/cwpsrv/htdocs/resources/admin/modules/admin_apis.php on line 0" while reading upstream, client: 186.68.104.140, server: localhost, request: "GET /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=admin_apis HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer: "https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=webpanel_addons"
2022/03/27 16:09:40 [error] 156796#0: *152 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP message: PHP Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0" while reading response header from upstream, client: 186.68.104.140, server: localhost, request: "GET /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=date_time HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer: "https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=admin_apis"
2022/03/27 16:09:56 [error] 156796#0: *152 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP message: PHP Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0" while reading response header from upstream, client: 186.68.104.140, server: localhost, request: "GET /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=quota_settings HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer: "https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=date_time"
2022/03/27 16:10:02 [error] 156796#0: *152 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP message: PHP Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0" while reading response header from upstream, client: 186.68.104.140, server: localhost, request: "GET /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=WebServers_manage HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer: "https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=quota_settings"
2022/03/27 16:10:20 [error] 156796#0: *152 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP message: PHP Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0" while reading response header from upstream, client: 186.68.104.140, server: localhost, request: "GET /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=php_selector3 HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer: "https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=WebServers_manage"
2022/03/27 16:11:54 [error] 156797#0: *162 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP message: PHP Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0" while reading response header from upstream, client: 186.68.104.140, server: localhost, request: "GET /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=php_selector3 HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer: "https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=WebServers_manage"
2022/03/27 16:12:01 [error] 156797#0: *163 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP message: PHP Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0" while reading response header from upstream, client: 186.68.104.140, server: localhost, request: "GET /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=notifications_list HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer: "https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=php_selector3"
2022/03/27 16:13:04 [warn] 157192#0: the "ssl" directive is deprecated, use the "listen ... ssl" directive instead in /usr/local/cwpsrv/conf.d/api.conf:8
2022/03/27 16:13:04 [warn] 157196#0: the "ssl" directive is deprecated, use the "listen ... ssl" directive instead in /usr/local/cwpsrv/conf.d/api.conf:8
2022/03/27 16:13:13 [error] 157199#0: *1 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP message: PHP Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0" while reading response header from upstream, client: 186.68.104.140, server: localhost, request: "GET /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=notifications_list HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer: "https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=php_selector3"
2022/03/27 16:13:28 [error] 157198#0: *2 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP message: PHP Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0" while reading response header from upstream, client: 186.68.104.140, server: localhost, request: "GET /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=monit_monitoring HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer: "https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=notifications_list"
2022/03/27 16:17:46 [error] 157198#0: *7 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP message: PHP Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0" while reading response header from upstream, client: 186.68.104.140, server: localhost, request: "GET /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=settings HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer:

Offline
*
Re: Problem Danger: MySQL - BAD CONFIGURATION DETECTED
« Reply #9 on: March 28, 2022, 01:43:22 AM »
This is part 2 of the command, it wouldn't let me post all in 1 post since it exceeded the character limit.

Code: [Select]
"https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=monit_monitoring"
2022/03/27 16:20:16 [error] 157198#0: *13 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP message: PHP Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0" while reading response header from upstream, client: 186.68.104.140, server: localhost, request: "GET /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=phpini_editor HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer: "https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=settings"
2022/03/27 16:20:40 [error] 157199#0: *12 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP message: PHP Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0" while reading response header from upstream, client: 186.68.104.140, server: localhost, request: "GET /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=php_addons HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer: "https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=phpini_editor"
2022/03/27 16:47:12 [error] 157198#0: *20 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0
PHP message: PHP Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions/func_mysql.php on line 0" while reading response header from upstream, client: 186.68.104.140, server: localhost, request: "GET /cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=php_addons HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "serverbackup492018i3.hostingsupremo.net:2031", referrer: "https://serverbackup492018i3.hostingsupremo.net:2031/cwp_d3db0e14764feb0d68879b601f03021e/admin/index.php?module=phpini_editor"

Offline
****
Re: Problem Danger: MySQL - BAD CONFIGURATION DETECTED
« Reply #10 on: March 28, 2022, 02:19:55 AM »
from command line: please do the following

Code: [Select]
mysql

show databases;


Make sure that root_cwp is listed as a database.

if so

Code: [Select]
use root_cwp;

show tables;

let me know what you find.
Google Hangouts:  rcschaff82@gmail.com

Offline
*
Re: Problem Danger: MySQL - BAD CONFIGURATION DETECTED
« Reply #11 on: March 28, 2022, 03:07:10 AM »
this is what i get with those commands

Code: [Select]
[root@serverbackup492018i3 ~]# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 394
Server version: 10.5.15-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| oauthv2            |
| performance_schema |
| postfix            |
| root_cwp           |
| roundcube          |
+--------------------+
7 rows in set (0.000 sec)

MariaDB [(none)]> use root_cwp;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [root_cwp]> show tables;
+--------------------+
| Tables_in_root_cwp |
+--------------------+
| backups            |
| domains            |
| nameserver         |
| notifications      |
| packages           |
| settings           |
| subdomains         |
| user               |
+--------------------+
8 rows in set (0.000 sec)

MariaDB [root_cwp]>

Offline
****
Re: Problem Danger: MySQL - BAD CONFIGURATION DETECTED
« Reply #12 on: March 28, 2022, 03:22:27 AM »
I'm honestly at a loss mate.  Everyting "Looks" good.

The only thing I can think of is to run the following scripts and see what happens:

/scripts/update_cwp
/scripts/cwp_update_all
/scripts/restart_cwpsrv

Google Hangouts:  rcschaff82@gmail.com

Offline
***
Re: Problem Danger: MySQL - BAD CONFIGURATION DETECTED
« Reply #13 on: March 28, 2022, 08:20:13 AM »
the latest error logs indicates php-mysql problems. have you considered reinstalling php-fpm?

Offline
***
Re: Problem Danger: MySQL - BAD CONFIGURATION DETECTED
« Reply #14 on: March 28, 2022, 09:36:34 PM »
If the message is claiming about "BAD CONFIGURATION DETECTED", I would check the configuration.

Type here all your mysql configuration files for us to check.
Content of files '/etc/my.cnf' and all files from folder '/etc/my.cnf.d/'.

Regards,
Netino