Bot's removal

Do not post support requests, bug reports or feature requests. Discuss phpBB here. Non-phpBB related discussion goes in General Discussion!
Scam Warning
Post Reply
JenYard
Registered User
Posts: 8
Joined: Mon Apr 15, 2019 11:54 am

Bot's removal

Post by JenYard » Thu Apr 25, 2019 3:39 pm

Hi.
If I go to DataBase and remove all bots which have permission =2, will it affect to the work of the forum, will it crash smth?

User avatar
HiFiKabin
Community Team Member
Community Team Member
Posts: 3961
Joined: Wed May 14, 2014 9:10 am
Location: Swearing at the PC, UK
Name: James
Contact:

Re: Bot's removal

Post by HiFiKabin » Thu Apr 25, 2019 3:46 pm

If you edit the database directly you are likely to break your board.

To prevent BOTs from indexing your board go to Groups Forum Permissions and set BOT access to NEVER

User avatar
KevC
Support Team Member
Support Team Member
Posts: 68959
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Bot's removal

Post by KevC » Thu Apr 25, 2019 3:46 pm

Yes. You should never remove users directly from the database.

What exactly do you want to do (rather than how you think it should be done)?
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

JenYard
Registered User
Posts: 8
Joined: Mon Apr 15, 2019 11:54 am

Re: Bot's removal

Post by JenYard » Thu Apr 25, 2019 6:58 pm

Thank you guys!!
I'm trying recover my forum after smbd hacked it and looks like this smbd had an access to DataBase directly. I've found some extra users with founder rights (=3) and with permissions = 2 (like bots). So first I've removed all those users directly from DB and than figured out, that forum does not work after it. I've recovered it again, gave permission 0 to all extra users and removed all bot's just in case, but forum was not working after it also. So thank's, you've explained, I should not remove them directly from DB.
WIll I have any problems if I give permission 0 to all bots directly in DB (after further recover)? ..just blowing on the water

User avatar
KevC
Support Team Member
Support Team Member
Posts: 68959
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Bot's removal

Post by KevC » Thu Apr 25, 2019 7:10 pm

The incident team dealing with your hack should be guiding you on doing this. You ought to post in your incident ticket about it.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

JenYard
Registered User
Posts: 8
Joined: Mon Apr 15, 2019 11:54 am

Re: Bot's removal

Post by JenYard » Thu Apr 25, 2019 7:15 pm

One more question. There is specific rule which user should have ordinal number "1" in the table or I can give it to any random user?
Also advise please, there is coding in column of password. If I want to change password for some users, what should I put in the cell? By doing that and putting random e-mail, I want to prevent those users from further penetration and using those Nicknames (again may be just blowing on the water) .

JenYard
Registered User
Posts: 8
Joined: Mon Apr 15, 2019 11:54 am

Re: Bot's removal

Post by JenYard » Thu Apr 25, 2019 7:17 pm

KevC wrote:
Thu Apr 25, 2019 7:10 pm
The incident team dealing with your hack should be guiding you on doing this. You ought to post in your incident ticket about it.
I've filed a request, but not sure if I can help those guys and not sure the guys can help me, so right now I'm just trying to recover it myself and clearing some info.

User avatar
KevC
Support Team Member
Support Team Member
Posts: 68959
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Bot's removal

Post by KevC » Thu Apr 25, 2019 7:42 pm

User ID 1 is the anonymous account used by everyone who has not logged in yet
User Type 1 is all accounts that have not been activated yet.

Don't mess with the user ID numbers.

I wouldn't mess with any of that stuff unless a database specialist tells you to. You can't just put a new password in that field.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

JenYard
Registered User
Posts: 8
Joined: Mon Apr 15, 2019 11:54 am

Re: Bot's removal

Post by JenYard » Thu Apr 25, 2019 8:12 pm

KevC wrote:
Thu Apr 25, 2019 7:42 pm
User ID 1 is the anonymous account used by everyone who has not logged in yet
Thank's! Funny, I was sure "Anonimous" is extra one :)

User avatar
KevC
Support Team Member
Support Team Member
Posts: 68959
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Bot's removal

Post by KevC » Thu Apr 25, 2019 8:37 pm

This is why you don't want to mess around in that table.

The anonymous account is used by everyone is is not logged in and should be in the guest group only.
ID2 is the person who installed the board
Accounts 3-47 are the standard installation search engine bots used to control how your site gets indexed. You should keep these.
The first real account by a registered user is ID48

That's why I started off by asking you to explain what you're wanting to do rather than what you think you should be doing.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

JenYard
Registered User
Posts: 8
Joined: Mon Apr 15, 2019 11:54 am

Re: Bot's removal

Post by JenYard » Thu Apr 25, 2019 8:38 pm

Dear KevC, thank's for the help from the full of the hart! Forum runs perfectly and I could update it.

JenYard
Registered User
Posts: 8
Joined: Mon Apr 15, 2019 11:54 am

Re: Bot's removal

Post by JenYard » Thu Apr 25, 2019 8:42 pm

cleared

Post Reply

Return to “phpBB Discussion”