Page 3 of 7

Re: Maybe pruning?

Posted: Thu Jun 29, 2023 11:36 pm
by bradrn
rotting bones wrote: Thu Jun 29, 2023 11:25 pm
bradrn wrote: Thu Jun 29, 2023 10:57 pm The hosting company should almost certainly keep logs. I can’t remember which one you’re using now… at least for Dreamhost, viewing them seems to be pretty easy, though they only keep 3 days’ worth: https://help.dreamhost.com/hc/en-us/articles/216512197. Running tracepath brings up the name of Bluehost instead, which also keeps access logs.
Right, if this site isn't self-hosted, I don't know what will be visible from the outside.
Well, all those links are to the bits of the documentation explaining how to access them from outside.
bradrn wrote: Thu Jun 29, 2023 11:09 pm OK, got this working. At a glance, they do have a section on ‘Spambot countermeasures’: they seem to mostly be CAPTCHAs of various types. However, the focus is on blocking spam registrations and logins, rather than on blocking viewers. For the latter, I suspect you’ll need to configure things on the hosting provider.
When I Googled this earlier, I found a dizzying array of CAPTCHA-related extensions. IIRC a lot of them change the CAPTCHA type.
Indeed. By default it appears the following ones are available by default:
  • Simple image
  • GD image
  • GD 3D image
  • Q&A
  • reCaptcha v2
  • reCaptcha v3
Of these, it appears Q&A is least invasive: it just asks the user to supply an answer to a predefined question (so you could ask e.g. ‘Name a word class’ with acceptable answers ‘noun’, ‘verb’, etc.). But also, all these plugins are specific to spam registrations: for normal views they don’t do a thing (presumably because you’d normally want the forum to be visible to everyone). This is why I suggested configuring the hosting provider, which might provide functionality for blocking access to the webserver in the first place.

Re: Maybe pruning?

Posted: Fri Jun 30, 2023 1:32 am
by zompist
We already use a captcha (the question one), which is why we don't get spammers.

I'm not convinced robots are a problem... if I recall, once someone noticed like 900 robots as guests. But anything is possible.

Edit: as a check, I went over to incatena.org, which of course is static. 75 or 85 guests, as opposed to 25 or 29 here.

Re: Maybe pruning?

Posted: Fri Jun 30, 2023 2:18 am
by bradrn
zompist wrote: Fri Jun 30, 2023 1:32 am I'm not convinced robots are a problem... if I recall, once someone noticed like 900 robots as guests.
Indeed, it’s right at the bottom of the front page:
phpBB wrote: Most users ever online was 907 on Sat Nov 30, 2019 8:59 am

Re: Maybe pruning?

Posted: Fri Jun 30, 2023 10:51 am
by Travis B.
zompist wrote: Thu Jun 29, 2023 5:15 pm That's addressing business websites, from a company that wants to sell you security products. We need advice specific to phpBB boards.

I don't even know if logs are kept, or for what. If someone wants to research and tell me exactly what to look for, I'll be happy to. I don't think guesses about robots are much better than my guesses about pruning. :(
I also very much dislike the idea of outright blocking clients based on client version. E.g. my phone dates back to 2017 - I don't like the idea of having to get a new phone just use the Zeeb on it.

Re: Maybe pruning?

Posted: Sat Jul 01, 2023 4:25 pm
by rotting bones
zompist wrote: Fri Jun 30, 2023 1:32 am We already use a captcha (the question one), which is why we don't get spammers.

I'm not convinced robots are a problem... if I recall, once someone noticed like 900 robots as guests. But anything is possible.

Edit: as a check, I went over to incatena.org, which of course is static. 75 or 85 guests, as opposed to 25 or 29 here.
After a bit of Googling, everyone says the way to fix "too many connections" is to increase the number of connections in MySQL and reload the database. Eg: https://thomas.vanhoutte.be/miniblog/ph ... he%20issue.

If the webhost doesn't allow access to MySQL, then pruning might be the only choice after all.

Re: Maybe pruning?

Posted: Sat Jul 01, 2023 5:27 pm
by rotting bones
bradrn wrote: Fri Jun 30, 2023 2:18 am
zompist wrote: Fri Jun 30, 2023 1:32 am I'm not convinced robots are a problem... if I recall, once someone noticed like 900 robots as guests.
Indeed, it’s right at the bottom of the front page:
phpBB wrote: Most users ever online was 907 on Sat Nov 30, 2019 8:59 am
Surely the number of connections is a function of both the number of robots and the number of entries they're trying to access?

Re: Maybe pruning?

Posted: Sat Jul 01, 2023 6:56 pm
by bradrn
rotting bones wrote: Sat Jul 01, 2023 5:27 pm
bradrn wrote: Fri Jun 30, 2023 2:18 am
zompist wrote: Fri Jun 30, 2023 1:32 am I'm not convinced robots are a problem... if I recall, once someone noticed like 900 robots as guests.
Indeed, it’s right at the bottom of the front page:
phpBB wrote: Most users ever online was 907 on Sat Nov 30, 2019 8:59 am
Surely the number of connections is a function of both the number of robots and the number of entries they're trying to access?
I don’t see why it should be. One visitor = one HTTP request = one connection. (I think?)

Re: Maybe pruning?

Posted: Sat Jul 01, 2023 7:25 pm
by rotting bones
bradrn wrote: Sat Jul 01, 2023 6:56 pm I don’t see why it should be. One visitor = one HTTP request = one connection. (I think?)
IIRC phpBB opens a new connection to fetch the posts for each page.

Re: Maybe pruning?

Posted: Sat Jul 01, 2023 7:26 pm
by rotting bones
zompist wrote: Fri Jun 30, 2023 1:32 am We already use a captcha (the question one), which is why we don't get spammers.

I'm not convinced robots are a problem... if I recall, once someone noticed like 900 robots as guests. But anything is possible.

Edit: as a check, I went over to incatena.org, which of course is static. 75 or 85 guests, as opposed to 25 or 29 here.
BTW, my support for pruning is based on the assumption that the webhost is highly restrictive. I don't know if it allows these kinds of methods: https://phpbb.hifikabin.me.uk/viewtopic.php?t=110

PS. I'm also assuming the host doesn't let you see which domains the bots are coming from, and blocking them, etc.

Re: Maybe pruning?

Posted: Sun Jul 02, 2023 2:50 am
by bradrn
rotting bones wrote: Sat Jul 01, 2023 7:25 pm
bradrn wrote: Sat Jul 01, 2023 6:56 pm I don’t see why it should be. One visitor = one HTTP request = one connection. (I think?)
IIRC phpBB opens a new connection to fetch the posts for each page.
Ah, I think I misunderstood what you were saying.

Re: Maybe pruning?

Posted: Wed Dec 27, 2023 1:08 pm
by Raphael
And there seems to have been some trouble again today.

Re: Maybe pruning?

Posted: Fri Dec 29, 2023 8:47 am
by Ahzoh
Raphael wrote: Wed Dec 27, 2023 1:08 pm And there seems to have been some trouble again today.
Ye I keep getting internal server errors

Re: Maybe pruning?

Posted: Fri Dec 29, 2023 11:05 am
by Travis B.
Ahzoh wrote: Fri Dec 29, 2023 8:47 am
Raphael wrote: Wed Dec 27, 2023 1:08 pm And there seems to have been some trouble again today.
Ye I keep getting internal server errors
As do I.

Re: Maybe pruning?

Posted: Fri Dec 29, 2023 3:35 pm
by bradrn
And me too, although I’m not sure it’s related to pruning.

Re: Maybe pruning?

Posted: Fri Dec 29, 2023 5:06 pm
by zompist
I've been having trouble too, though it comes and goes. I'll probably have to contact the hosting company (though last time I did, I think they were kind of useless... all they know how to do is restore from backup).

Re: Maybe pruning?

Posted: Fri Dec 29, 2023 5:44 pm
by masako
I fully support letting anything with more than 2 years of inactivity go away. I think though, if zomp and/or the mods wanted to make a specific "hall of records" for topics that might need/should be kept, that would be cool.

Re: Maybe pruning?

Posted: Sat Dec 30, 2023 1:52 am
by bradrn
Now I notice that incatena.org is no longer accessible (‘Site not found · DreamHost’). Very sad, if true.
masako wrote: Fri Dec 29, 2023 5:44 pm I fully support letting anything with more than 2 years of inactivity go away. I think though, if zomp and/or the mods wanted to make a specific "hall of records" for topics that might need/should be kept, that would be cool.
We had that in the old forum (for both Languages and Conlangery). I very much liked it, and would be happy to see it return.

Re: Maybe pruning?

Posted: Sat Dec 30, 2023 3:45 am
by zompist
bradrn wrote: Sat Dec 30, 2023 1:52 am Now I notice that incatena.org is no longer accessible (‘Site not found · DreamHost’). Very sad, if true.
Working for me. (It's hosted by another company, in fact Dreamhost. Maybe a glitch on their end.)

Re: Maybe pruning?

Posted: Sat Dec 30, 2023 3:55 am
by bradrn
zompist wrote: Sat Dec 30, 2023 3:45 am
bradrn wrote: Sat Dec 30, 2023 1:52 am Now I notice that incatena.org is no longer accessible (‘Site not found · DreamHost’). Very sad, if true.
Working for me. (It's hosted by another company, in fact Dreamhost. Maybe a glitch on their end.)
On further testing, it works with HTTP, just not HTTPS.

Re: Maybe pruning?

Posted: Sat Dec 30, 2023 8:49 am
by Raphael
I would really prefer it if as much of the ZBB as possible would stay available for as long as possible, but of course if it takes more pruning to keep the ZBB functional, then we need more pruning.