Someone's trying to hack my database or an error? Please help

[jdiofu]

If the page gets too long to load, this warning message appears

Warning: mysql_connect() [function.mysql-connect]: User sitename_dir has already more than 'max_user_connections' active connections in /home/sitename/public_html/classes/DirDb.php on line 40
Could not connect: User sitename_dir has already more than 'max_user_connections' active connectionsCould not connect: User sitename_dir has already more than 'max_user_connections' active connections

[subseo]

Most probable this is caused by your host, they have a certain limit on connections per account, and probably it's not enough for your websites.

I don't know how to fix that without turning to webhost, maybe someone has a trick or two?

[Michael Krein]

Hi,

After installing eSyndicat version 2.0.01 I saw the same error twice for
about 3 days (the site where it appeared isn't with a large traffic).

Warning: mysql_connect() [function.mysql-connect]: User ***username*** has already more than 'max_user_connections' active connections in /home/user/public_html/classes/DirDb.php on line 35
Could not connect: User ***username*** has already more than 'max_user_connections' active connections Could not connect: ***username*** has already more than 'max_user_connections' active connections

I contacted our hosting provider (just to add here that we use one of the best
hosting providers for more than 4 years and I'm not considering to change them) and
they answered me that we have to examine our (eSyndicat) php code because the
reason for this happening can be that the script is not closing a mysql connection
after using it (which leaves it open and will eventually hit the limit).

It would be great if eSyndicat team can assist us with advice. :)

Thank you in advance!

[Michael Krein]

OK, Just received a notice from the Admins that they have found in the
error logs that there is the same problem with the other our site which
uses the same script.

That's not good :( I'll really appreciate your assistnance in resolving this.

[Bryan Ex]

Which version of Esyndicat are you using Michael? I've run into similar circumstances recently but I'm one a dedicated server. I have yet to trace it to one script but I do know there's a problem with one of them.

[Michael Krein]

Which version of Esyndicat are you using Michael?
version 2.0.01 (the latest)

If you're on dedicated server I suppose you can up the max user connection settings.

[Bryan Ex]

If you're on dedicated server I suppose you can up the max user connection settings.
True enough... but it doesn't fix the problem either. I know some of it is coming from a gallery script I use but I haven't looked into what's pushing my server to work far harder than it should be based on the number of users online. I'll be watching to see what, if anything, turns up for your question though as it may just give me some hints as to what to check out in the New Year.

[Michael Krein]

Just created a ticket about this (one of our site was down again
today with the same error message). eSyndicat is a great script but this can be
very serious problem on each one server.

Hope that support team will find a solution.

[Bryan Ex]

Keep me posted if you find some news on it will you?

[Michael Krein]

Keep me posted if you find some news on it will you?
Sure Bryan! I'll do it.

[John Turner]

Hi Michael Krein,

I have answered to your ticket.
I have optimized some of your tables.
Please check capacity for work and post results.

[Michael Krein]

Hi John,

Thank you for your assistance during the Holidays!
Unfortunately the problem still exists (I replied in the ticket).

[Michael Krein]

Hi again,

Just updated the ticket. :)
Looks like your optimization did the job, John! :)

Thank you once again!

[Bryan Ex]

If I understand correctly... table repair and optimization is all that was needed? I perform these functions weekly so my troubles are not here if that is the case.

[Greg]

If I understand correctly... table repair and optimization is all that was needed? I perform these functions weekly so my troubles are not here if that is the case.

Hi Bryan

How does one go about doing this? "table repair and optimization"
Though I don't have a live site at the time, it would be nice to know for the future.

Thanks :)

[Bryan Ex]

Easiest way is from phpMyAdmin. Go to your directory database and scroll down to the bottom of the list of tables, select all, and then in the drop down box one option is to repair table and another is to optimize (you need to repeat the proceedure for each).

[Greg]

Thanks Bryan

Simple enough. Learn something new every day.