Hundreds of MySQL Errors by 1 IP Daily

[rantrave]

Here's a copy of the error:

mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11)

/forums/includes/class_core.php on line 279

I get this same error from the same ip everyday, is it possible that it's an attack? Also, what in layman's terms does this error mean. It's causing my host mucho trouble, and could get the boot, so your assistance is greatly needed.

[Paul M]

It's your hosts problem - that's a failure of mysql.

[rantrave]

It's your hosts problem - that's a failure of mysql.

Could it be attributed to the vbulletin software in some way? The reason I ask, you know hosting companies, if they think vb is doing it, I get cancelled. The server has crashed 2 out of the past three days after a forum attack (DoS I think), I want to cover my bases.

[Dan]

How big is your board? Do you have a lot of hacks installed that might cause high server load?

[rantrave]

How big is your board? Do you have a lot of hacks installed that might cause high server load?

Not that large, but growing....;)

744 Members
5682 Threads
157,714 Posts

Average Contections - About 50-100 all the time
Hacks: 3 minor 1 major (VB Image)

I stripped everything I thought could cause problems, but obviously to no avail.

[Dan]

What kind of hosting enviroment are you in? Might be time to look into upgrading.

[rantrave]

What kind of hosting enviroment are you in? Might be time to look into upgrading.

Although I can't argue that point (and it is being investigated), my load averages stay within .02-1.0 range, clearly an acceptable range for even a virtual dedicated server, yes? I know VDS is not good, that's a whole 'nother conversation....:cross-eyed:

[Dan]

Well if there's a lot of queries going in and out of the MySQL server that might cause it to crash.... don't know a lot about VDS though, if it runs a MySQL server for each virtual instance. If so It could be fine if not it could be that one of the other customers on the server could be contributing to the server crashes.

[rantrave]

Well if there's a lot of queries going in and out of the MySQL server that might cause it to crash.... don't know a lot about VDS though, if it runs a MySQL server for each virtual instance. If so It could be fine if not it could be that one of the other customers on the server could be contributing to the server crashes.

Thanks for the info!

I am also inquiring to the hosting company about the database error in question. It's ridiculous to be crashed 2 out of 3 days!

I will still accept any other information that you have that could resolve this issue. Thanks.

[hambil]

Here's a copy of the error:

mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11)

/forums/includes/class_core.php on line 279

I get this same error from the same ip everyday, is it possible that it's an attack? Also, what in layman's terms does this error mean. It's causing my host mucho trouble, and could get the boot, so your assistance is greatly needed.
From a single IP is suspicious. Have you looked up the ip? One option is to ban the ip in your hosts cp-panel. There are websites out there designed for load testing that can and are abused to attack boards. I won't link to one for obvious reasons.

The error most likely means you've exceeded max connections. What MySQL version are you using?

[rantrave]

The error most likely means you've exceeded max connections. What MySQL version are you using?

This was the same thing the hosting company said. As for MySQL, I am running 5.0.19 Also they are saying that I should not be using persistent connections (I have NO CLUE). So, my question is could I be having problems with MySQL 5.x, and could someone explain "persistent connections"?

[Paul M]

If it was too many connections then mySQL would say so.

You can set persistant connections in your config.php - AFAIK it's set to no by default - so you have to have manually changed this to be using them.

[rantrave]

If it was too many connections then mySQL would say so.

You can set persistant connections in your config.php - AFAIK it's set to no by default - so you have to have manually changed this to be using them.

I just checked, it's set to "no". Should I change this? And what about MySQL 5.x, is there compatability issues known?

[hambil]

This might help: http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html

Sounds like a problem your host has to sort out.

It looks like a solution is discussed in this (http://www.webhostingtalk.com/showthread.php?t=429766&page=2) thead, you might want to send the link to your hosting service.