bot limit

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
php_BB_Lover
I've Been Banned!
Posts: 352
Joined: Tue Jun 23, 2020 5:18 am

bot limit

Post by php_BB_Lover »

hi,
i wanna prevent bots to come to my site (for not finishing sql query).
except Google [Bot]. i want only google be able to index site's pages.
that's why i wanna do theses:

1. deactivate all the bots here (Spiders/Robots -> Manage bots -> Deactivate). except Google [Bot].
3. Permissions -> Group permissions -> Guests -> All NO [guests have to register]
4. Permissions -> Forum permissions -> All forums -> Remove permissions [Guests]

- now no bot could use my sql-query right? except Google [Bot].
- and google still will index the site right? [when a user clicks on one of the site's pages from google, will come to the site's page and see the message to register.]

am i doing right?
Version: phpBB 3.3.0
Theme: default
Regards
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70268
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: bot limit

Post by KevC »

Deactivating bots in the admin does not stop them coming to your site. it just means they are no longer controlled by the bots group. They will still come to the domain. Do a web search for robots.txt files and stopping bots by .htaccess if you want to stop them coming to the domain itself. Note that it will greatly impact on your sites page ranking. Google is not the only search engine!

You do not need to do point 2. By default guests can't do anything anyway.

permissions
group forum permissions
guests
select all the forums
no access

Note that that can be highly disadvantageous. People will not want to join a site that they cannot see. They have no idea what they're joining! It is worth giving them access to at least one or two forums to give them a taster for what the site is so they know what they're signing up to.

Google will still index the site. If you stop guest access people will just see a message saying 'This board has no forums'. They are not automatically taken to the registration page. The common solution to that is to change the language/XX/common.pgp file to edit that message (around line 500) to something like

'NO_FORUMS' => 'This board has no forums.',

to
'NO_FORUMS' => 'Please register to see these forums',
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
User avatar
scooterbird
Registered User
Posts: 70
Joined: Tue Jul 07, 2020 8:40 am
Location: Columbia
Name: Steve
Contact:

Re: bot limit

Post by scooterbird »

There are lists of known bot IP ranges - however, unless the bots are overwhelming MySQL, it may be better to control spam from the registration standpoint.
THE SCOOTERBIRD

"No bird soars too high if he soars with his own wings."
php_BB_Lover
I've Been Banned!
Posts: 352
Joined: Tue Jun 23, 2020 5:18 am

Re: bot limit

Post by php_BB_Lover »

KevC wrote:
Sat Jul 11, 2020 11:06 am
Deactivating bots...
The reason that im setting guest to see nothing is not to let bots to come as guest and finish my query limit.
So what is the %100 way to prevent all the bots except google?
Version: phpBB 3.3.0
Theme: default
Regards
php_BB_Lover
I've Been Banned!
Posts: 352
Joined: Tue Jun 23, 2020 5:18 am

Re: bot limit

Post by php_BB_Lover »

scooterbird wrote:
Sat Jul 11, 2020 11:10 pm
There are lists of known bot IP ranges - however, unless the bots are overwhelming MySQL, it may be better to control spam from the registration standpoint.
No i don't wanna block ips.
My registration is completely protective from bots. I have no spam registration.
Version: phpBB 3.3.0
Theme: default
Regards
rxu
Extensions Development Team
Posts: 3430
Joined: Wed Oct 25, 2006 12:46 pm
Location: Siberia, Russian Federation
Name: Ruslan
Contact:

Re: bot limit

Post by rxu »

As long as bots/guests visit the board, SQL queries are being executed to the DB. No matter if they have permissions to see forums or register on phpBB level or they don't.
If you want no SQL queries to be executed you'd need to stop them before they came to any phpBB page. That can be done by complete access denial on webserver level only.
php_BB_Lover
I've Been Banned!
Posts: 352
Joined: Tue Jun 23, 2020 5:18 am

Re: bot limit

Post by php_BB_Lover »

rxu wrote:
Sun Jul 12, 2020 6:12 am
As long as bots/guests visit the board, SQL queries are being executed to the DB. No matter if they have permissions to see forums or register on phpBB level or they don't.
If you want no SQL queries to be executed you'd need to stop them before they came to any phpBB page. That can be done by complete access denial on webserver level only.
- Like htaccess?

- how can i see all the query counts and monitor it? I just uncommented the @define('DEBUG_CONTAINER', true); but queries didn't show up on the footer.
Version: phpBB 3.3.0
Theme: default
Regards
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70268
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: bot limit

Post by KevC »

None of this is going to solve your problem. Upgrade your hosting. Job done.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
php_BB_Lover
I've Been Banned!
Posts: 352
Joined: Tue Jun 23, 2020 5:18 am

Re: bot limit

Post by php_BB_Lover »

KevC wrote:
Sun Jul 12, 2020 7:28 pm
None of this is going to solve your problem. Upgrade your hosting. Job done.
:arrow: :arrow: :arrow:
Version: phpBB 3.3.0
Theme: default
Regards
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70268
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: bot limit

Post by KevC »

What does that mean?
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
User avatar
eeji
Jr. Style Validator
Posts: 1303
Joined: Fri Dec 12, 2008 9:08 pm
Location: Manchester, UK
Contact:

Re: bot limit

Post by eeji »

If your host limits how many queries can be made, t's time to find a new host.
My phpBB styles: phpbbstyles.oo.gd
My board: iansvivarium.com
php_BB_Lover
I've Been Banned!
Posts: 352
Joined: Tue Jun 23, 2020 5:18 am

Re: bot limit

Post by php_BB_Lover »

eeji wrote:
Tue Jul 14, 2020 6:56 pm
If your host limits how many queries can be made, t's time to find a new host.
:arrow: :arrow: :arrow:
Version: phpBB 3.3.0
Theme: default
Regards
User avatar
janus_zonstraal
Registered User
Posts: 4885
Joined: Sat Aug 30, 2014 1:30 pm

Re: bot limit

Post by janus_zonstraal »

It is time to send user php_BB_Lover to :arrow: :arrow: :arrow:
If you ask me.
Sorry! My English is bat ;) !!!
User avatar
warmweer
Jr. Extension Validator
Posts: 5805
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: bot limit

Post by warmweer »

janus_zonstraal wrote:
Wed Jul 15, 2020 10:21 am
It is time to send user php_BB_Lover to :arrow: :arrow: :arrow:
If you ask me.
Nice one!! :lol:
and consider this an ask ;)
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70268
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: bot limit

Post by KevC »

What on earth is :arrow: :arrow: :arrow: supposed to mean?
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
Locked

Return to “[3.3.x] Support Forum”