Control Web Panel

WebPanel => MySQL => Topic started by: luanpham92 on May 02, 2016, 06:47:29 AM

Title: Could not select database root_cwp
Post by: luanpham92 on May 02, 2016, 06:47:29 AM

Warning: Error while sending SET_OPTION packet. PID=18961 in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php(1) : eval()'d code(1) : eval()'d code on line 5
MySQL server has gone away
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php(1) : eval()'d code(1) : eval()'d code on line 5

Title: Re: Could not select database root_cwp
Post by: Sandeep on May 02, 2016, 07:53:18 AM

Elaborate more about your problem. What modifications you did before getting this error ?

Title: Re: Could not select database root_cwp
Post by: luanpham92 on May 02, 2016, 08:26:25 AM

How you doing
"Warning: mysql_connect(): No such file or directory in /usr/local/cwpsrv/htdocs/admin/index.php(1) : eval()'d code(1) : eval()'d code on line 2
mysqld (pid 16643) is running...

Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: service cwpsrv restart

**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf

Could not connect: No such file or directory"

Title: Re: Could not select database root_cwp
Post by: Sandeep on May 02, 2016, 10:31:45 AM

mysql version?

you need to reset the mysql password

open ssh/terminal

type in this commands :
cd /usr/local/cwpsrv/htdocs/resources/scripts

sh mysql_pwd_reset

Title: Re: Could not select database root_cwp
Post by: luanpham92 on May 09, 2016, 08:27:12 AM

a time it still fails
Any other measures
"Warning: mysql_connect(): No such file or directory in /usr/local/cwpsrv/htdocs/admin/index.php(1) : eval()'d code(1) : eval()'d code on line 2
mysqld (pid 19729) is running...

Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: service cwpsrv restart

**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf

Could not connect: No such file or directory"

Title: Re: Could not select database root_cwp
Post by: Sandeep on May 09, 2016, 09:15:01 AM

post your server config and mysql version


Run the command in ssh and post the result output here
curl http://dl1.centos-webpanel.com/files/s_scripts/sinfo.sh|sh

Title: Re: Could not select database root_cwp
Post by: luanpham92 on May 10, 2016, 07:11:58 AM

I need to do what
and where to send the information about
I am not very clear to your needs
--- Thanks you !

Title: Re: Could not select database root_cwp
Post by: Sandeep on May 10, 2016, 11:54:38 AM

Mysql 5.1 , 5.5 , 5.6 or 5.7 ???

you can post here

Title: Re: Could not select database root_cwp
Post by: luanpham92 on May 11, 2016, 01:14:28 AM

I use version:
MySQL version: 5.5.49

Title: Re: Could not select database root_cwp
Post by: Sandeep on May 11, 2016, 03:29:48 AM

you need to reset root password of mysql

or upgrade to mariadb

Title: Re: Could not select database root_cwp
Post by: luanpham92 on May 11, 2016, 04:13:06 AM

Access over 150 people
will fail
That is the only way to overcome
Changes can not pass mysql

Title: Re: Could not select database root_cwp
Post by: luanpham92 on May 11, 2016, 04:28:03 AM

Errors in CWP

"Warning: Error while sending SET_OPTION packet. PID=12224 in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php(1) : eval()'d code(1) : eval()'d code on line 5
MySQL server has gone away
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php(1) : eval()'d code(1) : eval()'d code on line 5"

myql pass conversion error
"error 2002: can't coonect to local My SQL server through socket '/var/lib/mysql/mysql.sock' (2)"

Title: Re: Could not select database root_cwp
Post by: ogimedia on November 19, 2016, 09:57:06 AM

MySQL info:
mysql  Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1

this is my version

not works
Stopping mysqld:  [  OK  ]
Starting mysqld:  [  OK  ]

Warning: Error while sending QUERY packet. PID=31185 in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
MySQL server has gone away
Warning: [obfuscated]() expects parameter 1 to be resource, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

i gived the  command from up but nothing

same problem

Title: Re: Could not select database root_cwp
Post by: Sandeep on November 19, 2016, 10:48:13 AM

what is the error log can you check and post it here ?

Title: Re: Could not select database root_cwp
Post by: ogimedia on November 19, 2016, 10:18:21 PM

i get mysql restart or stop and cwp not work fine is going down many times, i reinstaled it and when i give restart to the server i get the errors  send me on my mail or private a number for wahatsapp or skype or if u talk on fb ...

i like verry much cwp and i dont wanna to put another panel.


Warning: Error while sending QUERY packet. PID=21747 in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
MySQL server has gone away
Warning: [obfuscated]() expects parameter 1 to be resource, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
Top 5 Process [live monitor]

watch this error

when i tried to go on cwp

Warning: [obfuscated](): No such file or directory in /usr/local/cwpsrv/htdocs/admin/index.php on line 0
mysqld (pid 23779) is running...

Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: service cwpsrv restart

**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf

Could not connect: No such file or directory

Title: Re: Could not select database root_cwp
Post by: robbyq on January 24, 2017, 12:24:08 PM

Quote from: ogimedia on November 19, 2016, 10:18:21 PM

i get mysql restart or stop and cwp not work fine is going down many times, i reinstaled it and when i give restart to the server i get the errors  send me on my mail or private a number for wahatsapp or skype or if u talk on fb ...

i like verry much cwp and i dont wanna to put another panel.


Warning: Error while sending QUERY packet. PID=21747 in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
MySQL server has gone away
Warning: [obfuscated]() expects parameter 1 to be resource, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
Top 5 Process [live monitor]

watch this error

when i tried to go on cwp

Warning: [obfuscated](): No such file or directory in /usr/local/cwpsrv/htdocs/admin/index.php on line 0
mysqld (pid 23779) is running...

Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: service cwpsrv restart

**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf

Could not connect: No such file or directory

same error resolved? i think it after upgrade version and check upgrades.

Title: Re: Could not select database root_cwp
Post by: bmthien on February 27, 2020, 09:41:02 AM

I also the same error, admin help me please!!!
(https://www.dropbox.com/s/4e02858bmpa4m4n/2020-02-27_16-36-10.png?dl=0)

Title: Re: Could not select database root_cwp
Post by: Sandeep on February 27, 2020, 02:01:27 PM

open you own topic with detailed information