Intermittent "Can't Connect To MySQL Server"

Mar 9, 2007

I started getting small periods of intermittent connection errors about once every hour, lasting for about 1 to 5 minutes each time:
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock'

I enabled the error log and did some other monitoring and established 2 things:
- the server doesn't crash/restart, it keeps running throughout the errors
- the errors do not match the load on the website, as sometimes when 500 users are online there are no errors, but when 300 are online they may by prolific

I checked many forums and then made 5 changes:
- changed the directory containing the mysql.sock file so only file owners or superusers can delete files from it
- I changed the default socket file setting in both my.cnf and php.ini
- I read about SELinux causing such a problem, so I disabled SELinux completely, rebooted the server and double-checked that it is indeed disabled.
- I changed the maximum amount of open files allowed by the operating system from 1024 to 30000.

Despite all these changes, I still get the errors. I then read that there is a workaround by using TCP/IP instead of the sock file. I tried that, but I still get the error intermittently in the form of:
Can't connect to MySQL server on 127.0.0.1

MySQL server 4.1.20, PHP 4.3.9, client API 4.1.20, CentOS 4.3, Intel P4 2.8GHz 1GB RAM

View 2 Replies


ADVERTISEMENT

Users Cannot Connect To Remote MySQL Server

May 8, 2009

I have a few users that have a hosting account with me and are trying to connect to their own MySQL servers elsewhere. Both said that they are able to connect to the MySQL server with other hosting accounts but not the ones hosted with me. I asked if they had setup permissions to allow remote connections from my server and they confirmed that they did.

What am I missing? Do I need to configure my firewall somehow? I figured the connection is just using port 80 since it's from an PHP script right?

View 4 Replies View Related

Can't Connect To MySQL Server On 'localhost' (10055)

Jun 24, 2009

Do you guys know anything about this?

My server works perfectly with INSERT, UPDATE, DELETE for mysql.
but after like 12 hours later, my application crashes and I get this
"Can't connect to MySQL server on 'localhost' (10055)" and I would have to restart my applications and everything will be working perfectly.

Do you guys have any idea why this happen?

I do have a lot of connections coming in and out of my server. Would that mean anything?

View 9 Replies View Related

Can't Connect To Local MySQL Server Through Socket

Oct 6, 2007

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/thesymbi/public_html/includes/class_core.php on line 274

I get this around 50 times a day!
I am fed up!

View 14 Replies View Related

Is It Possible To Make Joomla Connect To An External Mysql Database Server

Jul 31, 2007

Is it possible to make Joomla connect to an external mysql database server?

Meaning, the database for Joomla won't be local, but on another server.

Will it work by just entering the mysql hostname, user and password in Joomla's config?

What issues might arose by doing this?

View 3 Replies View Related

Server Intermittent

Apr 12, 2008

I'm having problem with godaddy shared server. I've signup with godaddy since 2006. Within the 2years, godaddy has been having so many downtime. Replies from them were always pointing faults to my internet service provider, but everytime I could serve other websites with ease.

View 9 Replies View Related

Intermittent Domain Name Server (DNS) Problems

May 2, 2006

My employer hosts a website for a company that has a .co.uk site and a .com site. The .com site generally cannot be accessed but the .co.uk site can always be accessed. Both sites are on the same server (which we maintain), but an outside company hosts the DNS records and refuses to admit there is a problem.

Since one domain is accessible and one isn't and they are both on the same server I'm pretty sure it's a DNS issue. I did a report on www.dnsreport.com and it says there are lame nameservers on the .com domain, but the .co.uk domain doesn't show that issue.

Am I on the right track with lame nameservers?

View 3 Replies View Related

Connect To MySQL DB Only On Certain User

Apr 20, 2009

I am using cPanel 11 (stable release) on a CentOS 5 server and would like to make it so that a certain database can only be connected to from the cPanel user that it is under (ie. user1_db can only be connected to from the user "user1" on the same server).

View 9 Replies View Related

MySQL Can't Connect To Socket.....

Sep 9, 2007

I saw following error in some of my site in my server.

Coppermine critical error:
Unable to connect to database !

MySQL said: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

or following error :

Invalid mysql server connection

Please help me how can I resolve this error !

/etc/my.cnf :

[mysqld]
datadir=/var/lib/mysql
skip-locking
skip-innodb
skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=16M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=200
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=64M ## 128MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=1M ## 1MB for every 1GB of RAM
read_buffer_size=1M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=1M ## 1MB for every 1GB of RAM
thread_concurrency=8 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
collation-server=latin1_general_ci

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout

My server details :
1 GB RAM
P4 3.00 HT

View 8 Replies View Related

MySQL Cannot Connect To Database Via PHP

Dec 1, 2007

I got this weird problem with my VPS which has MySQL 4.1.22 running on it. Everything works fine for sometime and then out of a sudden, it stop recognizing the mysql users and refused to allow my PHP scripts to access the database.

It seems that I needed to restart mySQL server to resolve the issue. Then out of the blues, the same problem occurs.

I am running Cpanel on a VPS and there isn't any overloading as the database access is pretty light on my 512mb VPS.

I contacted my web host about the issue and it seems like all they do is to restart the mySQL. This cannot be a solution as it happens at least once or twice a day depending on how soon I could catch the problem.

All the time this problem occurs, the MYSQL Server is still active and working. I can even access it through PHPMyAdmin but not through the scripts.

I just added an hourly crontab so as to restart the MySQL server as a stop gap.

View 7 Replies View Related

Users Cannot Connect To MySQL Via Phpmyadmin

Aug 17, 2008

It seems I am having issues with WHM/CPanel. I cannot connect to mysql via phpmyadmin through WHM as a root and get this error

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

All users get the same error when they try to access mysql from cpanel. The access seems to be only for valid for 192.168.1.%

Would allowing access to localhost will help and how can I do that for all users?

View 8 Replies View Related

Mysql Connect Problem After Easyapache

Jan 6, 2008

I updated my php to 4.4.8 via easyapache. But after that my scripts couldn't connect the databases?

View 3 Replies View Related

Connect To Mysql From Many Remote Virtual Hosts

Jan 9, 2007

I have a set up where server 1 holds a mysql DB and a virtual host. server 2 holds many virtual hosts in apache (16) connecting to this DB.

The virtual hosts all hold the same script, but the single VH on server 1 receives about the same amount of visits as all the VHs of server 2.

server 1 is very busy at times, like 100% CPU and a load around 10 for long period of times.
server 2 is not very busy, around 30% CPU usage and 0.6 CPU load.

Yet, users on server 2 experience *much slower* response times than the ones on server 1.

The obvious reason could be the network between the two, but I'm not convinced (6 seconds for a query run from server 2 when it brings back 1 row and takes 0.01 second from server 1).

I was wondering what other reasons it could be.

The mysql processlist is weird:

Code:
mysql> show processlist;
+-------+----------+---------------+----------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+----------+---------------+----------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+
| 81817 | mysite | localhost | mysite | Sleep | 865 | | NULL |
| 94992 | mysite | server2:47927 | mysite | Sleep | 188 | | NULL |
| 96890 | mysite | server2:50881 | mysite | Sleep | 26 | | NULL |
| 97213 | mysite | server2:51010 | mysite | Sleep | 22 | | NULL |
| 97391 | mysite | server2:51085 | mysite | Sleep | 36 | | NULL |
| 97919 | mysite | server2:51300 | mysite | Sleep | 49 | | NULL |
| 97927 | mysite | server2:51306 | NULL | Sleep | 49 | | NULL |
| 97933 | mysite | server2:51282 | mysite | Sleep | 48 | | NULL
| 97933 | mysite | server2:51282 | mysite | Sleep | 48 | | NULL |
| 97958 | mysite | server2:51321 | mysite | Sleep | 26 | | NULL |
| 97961 | mysite | server2:51323 | mysite | Sleep | 46 | | NULL |
| 98104 | mysite | server2:51344 | mysite | Sleep | 39 | | NULL |
| 98169 | mysite | server2:51376 | NULL | Sleep | 36 | | NULL |
| 98177 | mysite | server2:51388 | mysite | Sleep | 9 | | NULL |
| 98365 | mysite | server2:51461 | mysite | Sleep | 26 | | NULL |
| 98377 | mysite | server2:51427 | mysite | Sleep | 26 | | NULL |
| 98380 | mysite | server2:51468 | mysite | Sleep | 6 | | NULL |
| 98394 | mysite | server2:51474 | mysite | Sleep | 26 | | NULL |
| 98404 | mysite | server2:51479 | mysite | Sleep | 26 | | NULL |
| 98418 | mysite | server2:51486 | mysite | Sleep | 26 | | NULL |
| 98419 | mysite | server2:51487 | mysite | Sleep | 26 | | NULL |
| 98429 | mysite | server2:51496 | mysite | Sleep | 2 | | NULL |
| 98503 | mysite | server2:51520 | mysite | Sleep | 22 | | NULL |
| 98512 | mysite | server2:51524 | mysite | Sleep | 22 | | NULL |
| 98514 | mysite | server2:51525 | mysite | Sleep | 20 | | NULL |
| 98519 | mysite | server2:51526 | mysite | Sleep | 22 | | NULL |
| 98557 | mysite | server2:51514 | mysite | Sleep | 21 | | NULL |
| 98568 | mysite | server2:51548 | mysite | Sleep | 20 | | NULL |
| 98581 | mysite | server2:51557 | mysite | Sleep | 5 | | NULL |
| 98617 | mysite | server2:51572 | mysite | Sleep | 18 | | NULL |
| 98620 | mysite | server2:51574 | NULL | Sleep | 18 | | NULL |
| 98630 | mysite | server2:51577 | mysite | Sleep | 17 | | NULL |
| 98644 | mysite | server2:51584 | mysite | Sleep | 17 | | NULL |
| 98681 | mysite | server2:51601 | mysite | Sleep | 15 | | NULL |
| 98698 | mysite | server2:51604 | mysite | Sleep | 14 | | NULL |
| 98704 | mysite | server2:51606 | mysite | Sleep | 14 | | NULL |
| 98714 | mysite | server2:51610 | NULL | Sleep | 14 | | NULL |
| 98736 | mysite | server2:51619 | NULL | Sleep | 13 | | NULL |
| 98748 | mysite | server2:51626 | NULL | Sleep | 12 | | NULL |
| 98753 | mysite | server2:51628 | mysite | Sleep | 12 | | NULL |
| 98785 | mysite | server2:51635 | mysite | Sleep | 11 | | NULL |
| 98820 | mysite | server2:51654 | mysite | Sleep | 10 | | NULL |
| 98821 | mysite | server2:51655 | mysite | Sleep | 10 | | NULL |
| 98822 | mysite | server2:51656 | mysite | Sleep | 10 | | NULL |
| 98823 | mysite | server2:51657 | mysite | Sleep | 10 | | NULL |
| 98836 | mysite | server2:51660 | mysite | Sleep | 9 | | NULL |
| 98840 | mysite | server2:51662 | NULL | Sleep | 9 | | NULL |
| 98841 | mysite | localhost | NULL | Query | 0 | NULL | show processlist |
| 98901 | mysite | server2:51680 | mysite | Sleep | 6 | | NULL |
| 98903 | mysite | server2:51651 | mysite | Sleep | 7 | | NULL |
| 98920 | mysite | server2:51684 | mysite | Sleep | 6 | | NULL |
| 98947 | mysite | localhost | mysite | Sleep | 1 | | NULL |
| 98954 | mysite | server2:51696 | mysite | Sleep | 5 | | NULL |
| 99024 | mysite | server2:51710 | mysite | Sleep | 1 | | NULL |
| 99031 | mysite | server2:51712 | mysite | Sleep | 2 | | NULL |
| 99032 | mysite | server2:51686 | mysite | Sleep | 2 | | NULL |
| 99041 | mysite | server2:51694 | mysite | Sleep | 2 | | NULL |
| 99049 | mysite | server2:51717 | mysite | Sleep | 2 | | NULL |
| 99058 | mysite | server2:51720 | mysite | Sleep | 1 | | NULL |
| 99063 | mysite | server2:51685 | mysite | Sleep | 1 | | NULL |
| 99064 | mysite | server2:51722 | mysite | Sleep | 2 | | NULL |
| 99073 | mysite | localhost | mysite | Sleep | 1 | | NULL |
| 99075 | mysite | server2:51724 | mysite | Sleep | 1 | | NULL |
| 99086 | mysite | localhost | mysite | Query | 1 | Creating tmp table | SELECT DISTINCT * |
| 99089 | mysite | localhost | mysite | Sleep | 1 | | NULL |
+-------+----------+---------------+----------+---------+------+-----------

Why so many sleeping processes from server 2, and none or almost none from server 1 ?
Is it normal that every query from server 2 is open on a different port ? Should they be grouped by virtual host, or is there one different port for each script running concurrently?

What could be a reason for server 2 having problems to open connections on server 1, and how to solve it?

Right now I'm about to deport more users from server 1 to new virtual hosts on server 2, hoping it will lower the load on the first machine and overall accelerate the response times. I just thought I'd post here first because this all seems very weird to me and i thought someone with an external look might tell me what I'm doing wrong. And also if network would be the problem maybe that's not the clever thing to do to make more users remote.

View 4 Replies View Related

Plesk 12.x / Linux :: PHP Could Not Connect To MySQL Over Localhost

Feb 6, 2015

I have a problem with connection to MySQL database over PHP.

If I define host address '127.0.0.1' works well. Problem occurs if host address is 'localhost'.

How to allow both 'localhost' and '127.0.0.1'?

View 1 Replies View Related

Plesk 11.x / Linux :: Roundcube Can't Connect To MySQL

Oct 5, 2013

With one from another server. Now roundcube does not want to connect to mysql anymore, i tried to edit this :

line:$rcmail_config['db_dsnw'] = 'mysql://roundcube:randompassword@localhost/roundcubemail';

i then used a MD5 generator to input the hash in the password field of the roundcube user in mysql, with no luck...I even tried to delete roundcube user from mysql, then remove psa-roundcube, then go through the plesk update manager and install roundcube again, did not change nothing, it didn't even create the roundcube user.

Is there anyway i can reinstall roundcube from scratch?PPP 11.5 up to date on ubuntu 12.04

Code:

[05-Oct-2013 14:03:54 +0200]: DB Error: _doConnect: [Error message: Access denied for user 'roundcube'@'localhost' (using password: YES)]
[Native code: 1045]
[Native message: Access denied for user 'roundcube'@'localhost' (using password: YES)]

[code]....

View 7 Replies View Related

Plesk 11.x / Windows :: Unable To Connect To MySQL?

Jul 17, 2012

I've upgraded to 11, but when I try and apply updates, I'm getting

WARNING: Unable to connect to local default MySQL server. Read carefully article [URL] ..... for details.

I've followed the directions in the KB mentioned, but haven't had any luck yet.

View 8 Replies View Related

Error: Warning: Mysql_connect() [function.mysql-connect]

Dec 19, 2008

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in /home/.../public_html/enhu.com/includes/connection.php on line 5

Database connection failed: Access denied for user 'root'@'localhost' (using password: YES)

i'm using wamp.

how must i fix this error?

View 12 Replies View Related

Plesk 12.x / Linux :: Unable To Connect To MySQL Hosts

Jul 18, 2014

After changing my web hosting (same system : VPS, same version of linux : CentOS 6 , but passage from Plesk 11 to 12), i am now unable to connect remotely via TCP-IP to my mysql databases (with third-party tools like Mysql Workbench, Toad...) ! I never met this problem before.

The only way to connect is to use a "Standard TCP-IP over SSH" connection method ... but i don't want (i did'nt need this method before) !

Though, remote connections are allowed from any host in the settings.

View 3 Replies View Related

"Can't Connect To Local MySQL Server" + "IPS Driver Error"

Jun 4, 2007

During peak times (especially weekends) many of my site's users have been reporting intermittent 'IPS Driver Errors' in the forums and the following error in the coppermine gallery:

Quote:

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)

(The forums and the gallery are the main parts of the site).

I'm assuming that the site is having problems handling the number of users trying to connect to SQL. I tried increasing the max_connections and max_user_connections settings in my.cnf but it doesn't seem to have made a significant difference.

What do I need to do to fix this? Would I need to upgrade my server specs or is it something to do with the server settings?

my server specs: AMD Dual/Dual Opteron 270 with 4GB RAM.

View 3 Replies View Related

Plesk 12.x / Linux :: Fail To Connect MySQL / Database / WebAdmin - File Not Found

Mar 30, 2015

I cant connect to the Database WebAdmin. If I click the icon, i got an "File not found." in the opening tab. Back in Plesk I get the following:

ERROR: PlexkFatalException
Server id is undefined?

I even cant connect via ssh to the mysql part of my server. But the server is running and both of my two wordpress pages run smoothly. I know this page: [URL] .... – but as I sad, cant enter die mysql.

It seems something is wrong with the permissions. I'm on the point where I just want to reset everything database related. But how?

View 2 Replies View Related

Intermittent Forbidden Error Message

May 9, 2008

my vBulletin forum members start complaing about an intermittent forbidden error message:

Forbidden
You don't have permission to access /vb/forumdisplay.php on this server.

Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request

i did tail -f /usr/local/apache/logs/error_log and find lot of lines like this:

[Fri May 9 17:13:33 2008] [crit] [client 217.69.189.2] (24)Too many open files: /.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable

i also found the vb folder and all folders inside it have permession of 775 and all files have permession of 664

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved