For the past 3 days we have had lots of Database error in our Dolphin DEMO.
Error is
Database error in Dolphin Demo
Mysql error:
User flashdaw_d603 has already more than ‘max_user_connections‘ active connections
…
Called script: /demo/dolphin/d61/guestbook.php
Request parameters:
Array
…
We have contacted hosting company but they said all setting are the same and we need to switch plan to get more max_user_connections number.
What is max_user_connections? – Number of MySQL connections at the same time (let’s say 1 second ). In our hosting we have max_user_connections = 20. If you have 25 page impressions for a second than 5 people will see the Error page.
All seems to be clear but we do not have that much traffic on our Demo website. Lets say 20 people for a second and we should have about 1 700 000 page impressions for 24 hours. Our website does not have this number of visits.
All topics about this error on Boonex.com tell people to change hosting plan to VPS or dedicated but this is not the solution for us actually as we do not have that much visitors on website. I keep exploring the problem and have found solution on a website.
here is first one.
in your “inc” directory find the file db.inc.php. In that file find the line that reads:
$this->link = @mysql_pconnect( $this->host . $this->port . $this->sock, $this->user, $this->passwd );
and change it to:
$this->link = @mysql_connect( $this->host . $this->port . $this->sock, $this->user, $this->passwd );
Taking out the “p” from mysql_pconnect makes it a single connect instead of a persistant connection.
This solution helped some people but not our website and we found another thing. Most of errors was when guestbook.php file executed. We started exploring and found out that in member profile anyone can post a comment in member guestbook. Spammers used this option to live a links on their websites and they send requests 20-30 times a second and actually this was the problem for our demo website.
This can be called Denial-of-service attack when people visiting website see only Database error message.
I just removed guestbook.php file from demo website and member menu and now all is good and no more ERRORS.
if you have the same errors this can be spammers or you have very popular website and you should optimize Database request.
The only solution for us was removal of the PHP file. if you take a look to boonex.us and boonex.ru you will see that these websites does not have this files too. Boonex know where the problem is and removed it so you should do the same.
Good luck
That’s pretty weird that they would only give you 20 connections when the MySQL default is 100. I have a dolphin 5.6.005 site that has been the target of a guestbook spammer for about two weeks now. They are hammering this site to the tune of over 1000 hits a day. Finally, I put a trap in to prevent them from accessing the guestbook. Now I log their IP address and they come back again with the same address, I dump them. I am guessing that you are having the same problem if the persistent connection didn’t work for you.
I had the same problem on my host. I disabled the guestbook because they was bombed with spam and I made restrictions for not registred visitors in the backend. It helped but sometimes I get the same error, but not so often. I wrote to Boonex support and they put this php.ini file to each of my boonex folders (IN EACH ONE!!!!)
Thats the input of the php.ini :
allow_url_fopen=On
register_globals=Off
upload_max_filesize=100M
post_max_size=200M
memory_limit=256M
max_input_time=3000
max_execution_time=3000
copy it to each folder, maybe it helps!