Messages

1

Apache / Re: mysql server can't start

« on: August 19, 2018, 12:49:46 PM »

nobody can help me. i will cwp pro... (

2

Installation / Re: Cannot connect to MySQL, db_conn.php is missing

« on: July 03, 2018, 08:21:25 AM »

You have to check error log which is in place /usr/local/cwpsrv/logs/error.log

option 1
if you dont have file ~/.my.cnf

2018/05/06 15:52:42 [error] 15352#0: *3609 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
PHP message: PHP Warning:  mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
PHP message: PHP Warning:  mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
PHP message: PHP Warning:  mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0" while reading response header from upstream, client: XX.XX.XX.XX, server: localhost, request: "GET /admin/index.php?module=crontab HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "www.dnsbg.com:2030", referrer: "http://www.domain.com:2030/admin/index.php?module=crontab"

Option 2:

If you have file ~/.my.cnf but information like password is wrong - error will be

2018/05/06 22:53:37 [error] 8815#0: *324 FastCGI sent in stderr: "PHP message: PHP Notice:  Undefined variable: pass in /usr/local/cwpsrv/var/services/oauth/v2/server/server.php on line 21
PHP message: PHP Warning:  mysqli::__construct(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO) in /usr/local/cwpsrv/var/services/oauth/v2/server/server.php on line 25
PHP message: PHP Warning:  mysqli::__construct(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO) in /usr/local/cwpsrv/var/services/oauth/v2/server/server.php on line 27
PHP message: PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /usr/local/cwpsrv/var/services/oauth/v2/server/server.php on line 29
PHP message: PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /usr/local/cwpsrv/var/services/oauth/v2/server/server.php on line 95
PHP message: PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /usr/local/cwpsrv/var/services/oauth/v2/server/server.php on line 95
PHP message: PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /usr/local/cwpsrv/var/services/oauth/v2/server/server.php on line 95
PHP message: PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /usr/local/cwpsrv/var/services/oauth/v2/server/server.php on line 95
PHP message: PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /usr/local/cwpsrv/var/services/oauth/v2/server/server.php on line 95
PHP message: PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /usr/local/cwpsrv/var/services/oauth/v2/server/server.php on line 95
PHP message: PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /usr/local/cwpsrv/var/services/oauth/v2/server/server.php on line 95
PHP message: PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) in /usr/local/cwpsrv/var/services/oauth/v2/server/OAuth2/Storage/Pdo.php:67
Stack trace:
#0 /usr/local/cwpsrv/var/services/oauth/v2/server/OAuth2/Storage/Pdo.php(67): PDO->__construct('mysql:dbname=oa...', 'root', ''

What can be wrong in the file ~./.my.cnf

Wrong

~./.my.cnf

[client]
user = root
password = mypassword

~./.my.cnf

Correct ( without space passowrd=mypassword )
[client]
user=root
password=mypassword

Regards,
kkovachki

Thank you, i have same error. how to fix ?

3

Apache / Re: mysql server can't start

« on: July 03, 2018, 08:03:36 AM »

cwp error log:

2018/07/03 13:03:24 [error] 7311#0: *7 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
PHP message: PHP Warning:  mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
PHP message: PHP Warning:  mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
PHP message: PHP Warning:  mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
PHP message: PHP Warning:  mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0" while reading response header from upstream, client: xxxxxxxx, server: localhost, request: "GET /admin/index.php?chk=y HTTP/1.1", upstream: "fastcgi://unix:/usr/local/cwp/php71/var/sockets/cwpsrv.sock:", host: "xxxxxxxxxxx:2030"

4

Apache / mysql server can't start

« on: July 03, 2018, 07:16:13 AM »

pls help me, i don;t why. anyone has encountered the same problem ? i don't change mysql password


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:

5

Updates / Re: Purchased CWP Pro - What's next?

« on: June 05, 2018, 07:45:20 AM »

got the issue resolved.  turns out we were not doing a direct NAT in our firewall so the server thought it was suing a different IP than the one i had registered.  once we put in a support ticket to change the IP and ran the sh /scripts/update_cwp

it all works great now as PRO.

error same you., what did you do it ?