Control Web Panel

WebPanel => MySQL => Topic started by: fa46 on April 14, 2017, 11:18:58 AM

Title: Warning: [obfuscated](): (HY000/2002): Connection refused
Post by: fa46 on April 14, 2017, 11:18:58 AM

When loading, mysql drops and gives an error

Warning: [obfuscated](): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0

Warning: [obfuscated](): (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: service cwpsrv restart

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


Warning: [obfuscated]() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Could not connect:

Title: Re: Warning: [obfuscated](): (HY000/2002): Connection refused
Post by: Administrator on April 14, 2017, 08:07:37 PM

you should check your mysql server logs in /var/lib/mysql/

Title: Re: Warning: [obfuscated](): (HY000/2002): Connection refused
Post by: fa46 on April 15, 2017, 07:50:42 AM

I got these errors



Sat Apr 15 09:36:22.827571 2017] [:error] [pid 2056:tid 140028550313728] [client 46.183.165.7:37010]   thrown in /home/fa461/public_html/includes/database/database.inc on line 2227
[Sat Apr 15 09:36:22.838341 2017] [:error] [pid 819:tid 140028432815872] [client 46.183.165.9:60712] PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /home/fa461/public_html/includes/database/database.inc:2227
[Sat Apr 15 09:36:22.838376 2017] [:error] [pid 819:tid 140028432815872] [client 46.183.165.9:60712] Stack trace:
[Sat Apr 15 09:36:22.838393 2017] [:error] [pid 819:tid 140028432815872] [client 46.183.165.9:60712] #0 /home/fa461/public_html/includes/database/database.inc(2227): PDOStatement->execute(Array)
[Sat Apr 15 09:36:22.838411 2017] [:error] [pid 819:tid 140028432815872] [client 46.183.165.9:60712] #1 /home/fa461/public_html/includes/database/database.inc(697): DatabaseStatementBase->execute(Array, Array)
[Sat Apr 15 09:36:22.838433 2017] [:error] [pid 819:tid 140028432815872] [client 46.183.165.9:60712] #2 /home/fa461/public_html/includes/database/database.inc(2406): DatabaseConnection->query('SELECT expire, ...', Array, Array)
[Sat Apr 15 09:36:22.838458 2017] [:error] [pid 819:tid 140028432815872] [client 46.183.165.9:60712] #3 /home/fa461/public_html/includes/lock.inc(167): db_query('SELECT expire, ...', Array)
[Sat Apr 15 09:36:22.838485 2017] [:error] [pid 819:tid 140028432815872] [client 46.183.165.9:60712] #4 /home/fa461/public_html/includes/lock.inc(146): lock_may_be_available('theme_registry:...')
[Sat Apr 15 09:36:22.838501 2017] [:error] [pid 819:tid 140028432815872] [client 46.183.165.9:60712] #5 /home/fa461/public_html/includes/theme.inc(449): lock_acquire('theme_registry:...')
[Sat Apr 15 09:36:22.838515 2017] [:error] [pid 819:tid 140028432815872] [client 46.183.165.9:60712] #6 /home/fa461/public_html/includes/bootstrap.inc(455): ThemeRegistry->set(Array)
[Sat Apr 15 09:36:22.838525 2017] [:error] [pid 819:tid 140028432815872] [client 46.183.165.9:60712] #7 [internal function]: DrupalCacheArray->__destruct()
[Sat Apr 15 09:36:22.838527 2017] [:error] [pid 819:tid 140028432815872] [client 46.183.165.9:60712] #8 {main}1
[Sat Apr 15 09:36:22.838542 2017] [:error] [pid 819:tid 140028432815872] [client 46.183.165.9:60712]   thrown in /home/fa461/public_html/includes/database/database.inc on line 2227

Title: Re: Warning: [obfuscated](): (HY000/2002): Connection refused
Post by: asrof_id on May 31, 2017, 11:39:02 PM

I am in the same problem.

Happens almost everyday, affeted: website "database error". Running well after login webpanel GUI.

Also happens every reboot server.

Any solution?

Title: Re: Warning: [obfuscated](): (HY000/2002): Connection refused
Post by: chkuo on June 04, 2017, 01:13:55 AM

I am in the same problem.

Title: Re: Warning: [obfuscated](): (HY000/2002): Connection refused
Post by: tonysar on December 12, 2017, 04:53:14 PM

at very beginning of this error your 2006 Mysql server has gone away error indication of time out. you can set
max_allowed_packet to higher value such as 100M in your mysql configuration and see if this will sort the problem .

Title: Re: Warning: [obfuscated](): (HY000/2002): Connection refused
Post by: asrof_id on December 12, 2017, 05:20:12 PM

The solution is simple "just upgrade our server with bigger ram", supposed to be "2 GB or higher".

Title: Re: Warning: [obfuscated](): (HY000/2002): Connection refused
Post by: locvfx on January 11, 2018, 10:56:40 AM

I guess two reasons:
- Your app has problem, try to check it
- your server's spec is too low (under 1 GB RAM, not recommended)

If you are unable to upgrade your server, maybe try to extend swap memory
https://www.digitalocean.com/community/tutorials/how-to-add-swap-on-centos-7

Note: I have tested, only work on KVM, does not work on openVZ