I'm passing this on to the customer (a secondary school), I'm sure they'll take exactly that action.

Ross

Ross

Thanks for the additional info - I'm not getting anywhere with the hosting company, here's a selection of their replies:

We made standard optimization for mysql configurations within your account. We checked and monitored the domain till time and it is loading fine with us now.

and

You are under "share hosting plan" and other customers use the same server. We have this issue only with your website - "blocked because of many connection errors" . Unfortunately we can not "increase max_connect_errors to 1000000 or setup a cron job to run "FLUSH HOSTS"" as it is very un-secure, and it take effect with our other customers. I've investigated it once again, I added more permission to your database user. Hopefully it will help at this stage.

The problem recurs daily now. Is there any chance that the code is the problem?

Thanks,

Ross

What does the number of connections depend on, is it determined by the code or the number of visitors to the site? And where are the errors likely to be generated (I'm assuming time outs from the server)?

The host support have asked me how many connections I expect to the server - sound like a "How long is a piece of string" question to me...

Ross

On a school's website running CMSB, every couple of weeks the website goes down with the following error message:

We were unable to connect to the database, possibly because:

Your database settings are incorrect (check in /data/settings.dat.php)
Your database server is down or overloaded (check with your host)


The database error given was:
Host '<Control Panel Name>' is blocked because of many connection errors;
unblock with 'mysqladmin flush-hosts'

Obviously the hosting company says that it's the code that is the issue rather than their servers. Naturally I need to be sure this is not the case. What should I be looking for in the way of error logs? Any other pointers you can give?

The site was stable for a long period before this started.

Thanks,

Ross

I'm getting the following error message on a new installation of CMSB when I try to change a section record:

Warning: is_dir(): open_basedir restriction in effect. File(/) is not within the allowed path(s): (/usr/share/pear/:/usr/share/php/:/usr/local/pem/vhosts/115545/) in /usr/local/pem/vhosts/115545/webspace/httpdocs/ennisoft-webdev.com/cmsAdmin/lib/common.php on line 175

It happens when I add an upload field into a section editor - I remove the upload, the message stops appearing.

I also get a message telling me that the uploads folder does not exist - I have checked the paths in Server Settings, and they seem right to me.

I contacted my hosting company and they gave me the following response:

Open_basedir is no longer applicable since the PHP 5.3.3 upgrade that was made to the control panel awhile back. 
You would need to look in to the software you are using for alternatives to open_basedir where applicable, or migrate to cloud as they will require PHP 5.2

I see there are similar posts, but no solutions, they all seem to go to second level support. Any ideas?

Thanks,

Ross