my forum is blocked

[hamidouki]

hello my forum is blocked alone on this message.
do you have an idea ?

General Error
SQL ERROR [ mysqli ]

Too many connections [1040]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

[[Dimetrodon]]

Hello.
It's not blocked, rather, the server has too many people connecting to it. How long has it been like that? It may be getting scraped by bad bots or DDOSed.

[nice100]

indeed
I sometimes have that too
Too many users (resources)
you are not alone on a server
There are various website, s
On a server.
You can rent a server for 1000 euros
And you are the only one on that site

[Lumpy Burgertushie]

before you do that, contact your host. they are the ones that can tell you exactly what is going on and what is causing it.


robert

[hamidouki]

before you do that, contact your host. they are the ones that can tell you exactly what is going on and what is causing it.


robert

the blockage disappeared after an hour without contacting anyone

[janus_zonstraal]

But it will come back, as the bots and scrapers visit your website, so block them now!
From your site:
"Most users ever online was 341 on 30 November 2022, 23:51"

[[Dimetrodon]]

This may be of use. HiFiKabin's method of blocking bad bots: https://phpbb.hifikabin.me.uk/viewtopic.php?t=110

[KevC]

Your board is (likely) on a shared server with dozens or even hundreds of other websites.

That server has a limit for the number of connections it can deal with in total. It is going over that limit. After an hour or so the host probably kicks off all of the connections which resets the limit and your site comes back on again automatically, as does every other site on that server.

The only people who can do something about this is your host. They either move your board to a quieter server or they do that with the one or more which are pushing it over the limit.

[janus_zonstraal]

Your board is (likely) on a shared server with dozens or even hundreds of other websites.

That server has a limit for the number of connections it can deal with in total. It is going over that limit. After an hour or so the host probably kicks off all of the connections which resets the limit and your site comes back on again automatically, as does every other site on that server.

The only people who can do something about this is your host. They either move your board to a quieter server or they do that with the one or more which are pushing it over the limit.

First try to block the bots and scrapers on your site, most of the time this helps.

[P_I]

From another topic,

The large number of guests issue has come up here numerous times.

For my boards I found the blog post Blocking aggressive Chinese crawlers/scrapers/bots - John Large .co.uk very useful to understand whether or not the guests are legitimate or not. I'm using the solution mentioned in this comment to deal with the automated crawlers/scrapers/bots.

[hamidouki]

It's too complicated for me and thank you for these clear and precise answers.
currently all works well with captcha v3 google

[janus_zonstraal]

It's too complicated for me

Just add these lines in the bottom of your .htaccess file

Code: Select all

##spammers
Options +FollowSymLinks
RewriteEngine On
RewriteBase /
RewriteCond %{HTTP_USER_AGENT} AhrefsBot/6.1|Ahrefs|Baiduspider|BLEXBot|SemrushBot|YandexBot/3.0|YandexBot|Mb2345Browser|LieBaoFast|zh-CN|MicroMessenger|zh_CN|Kinza|Datanyze|serpstatbot|spaziodati|OPPO\sA33|AspiegelBot|PetalBot [NC]
RewriteRule ^ - [F,L]

[Mick]

currently all works well with captcha v3 google

Are you sure?

[hamidouki]

It's too complicated for me

Just add these lines in the bottom of your .htaccess file

Code: Select all

##spammers
Options +FollowSymLinks
RewriteEngine On
RewriteBase /
RewriteCond %{HTTP_USER_AGENT} AhrefsBot/6.1|Ahrefs|Baiduspider|BLEXBot|SemrushBot|YandexBot/3.0|YandexBot|Mb2345Browser|LieBaoFast|zh-CN|MicroMessenger|zh_CN|Kinza|Datanyze|serpstatbot|spaziodati|OPPO\sA33|AspiegelBot|PetalBot [NC]
RewriteRule ^ - [F,L]

Code: Select all

<IfModule mod_rewrite.c>
RewriteEngine on

#
# Uncomment the statement below if URL rewriting doesn't
# work properly. If you installed phpBB in a subdirectory
# of your site, properly set the argument for the statement.
# e.g.: if your domain is test.com and you installed phpBB
# in http://www.test.com/phpBB/index.php you have to set
# the statement RewriteBase /phpBB/
#
#RewriteBase /

#
# Uncomment the statement below if you want to make use of
# HTTP authentication and it does not already work.
# This could be required if you are for example using PHP via Apache CGI.
#
#RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization},L]

#
# The following 3 lines will rewrite URLs passed through the front controller
# to not require app.php in the actual URL. In other words, a controller is
# by default accessed at /app.php/my/controller, but can also be accessed at
# /my/controller
#
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ app.php [QSA,L]

#
# If symbolic links are not already being followed,
# uncomment the line below.
# http://anothersysadmin.wordpress.com/2008/06/10/mod_rewrite-forbidden-403-with-apache-228/
#
#Options +FollowSymLinks
</IfModule>

# Apache content negotation tries to interpret non-existent paths as files if
# MultiViews is enabled. This will however cause issues with paths containg
# dots, e.g. for the cron tasks
<IfModule mod_negotiation.c>
	Options -MultiViews
</IfModule>

# With Apache 2.4 the "Order, Deny" syntax has been deprecated and moved from
# module mod_authz_host to a new module called mod_access_compat (which may be
# disabled) and a new "Require" syntax has been introduced to mod_authz_host.
# We could just conditionally provide both versions, but unfortunately Apache
# does not explicitly tell us its version if the module mod_version is not
# available. In this case, we check for the availability of module
# mod_authz_core (which should be on 2.4 or higher only) as a best guess.
<IfModule mod_version.c>
	<IfVersion < 2.4>
		<Files "config.php">
			Order Allow,Deny
			Deny from All
		</Files>
		<Files "common.php">
			Order Allow,Deny
			Deny from All
		</Files>
	</IfVersion>
	<IfVersion >= 2.4>
		<Files "config.php">
			Require all denied
		</Files>
		<Files "common.php">
			Require all denied
		</Files>
	</IfVersion>
</IfModule>
<IfModule !mod_version.c>
	<IfModule !mod_authz_core.c>
		<Files "config.php">
			Order Allow,Deny
			Deny from All
		</Files>
		<Files "common.php">
			Order Allow,Deny
			Deny from All
		</Files>
	</IfModule>
	<IfModule mod_authz_core.c>
		<Files "config.php">
			Require all denied
		</Files>
		<Files "common.php">
			Require all denied
		</Files>
	</IfModule>
</IfModule>

# php -- BEGIN cPanel-generated handler, do not edit
# Set the “ea-php72” package as the default “PHP” programming language.
<IfModule mime_module>
  AddHandler application/x-httpd-ea-php72 .php .php7 .phtml
</IfModule>
# php -- END cPanel-generated handler, do not edit

[hamidouki]

currently all works well with captcha v3 google

Are you sure?