Re: [sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

On Oct 15, 2019, at 8:07 AM, Peter da Silva wrote: > A mail server speaks SMTP for both inbound and outbound That’s only useful if you’ve configured Fossil to integrate with a third-party bidirectional SMTP server, which is *not* the only way to configure Fossil’s email integration:

Re: [sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

I think you're conflating things. A mail server speaks SMTP for both inbound and outbound, IMAP/POP/webmail is all part of the user interface stack... as would be the webforum component in any mailing list/web forum scheme. On Mon, 14 Oct 2019, 20:45 Warren Young, wrote: > On Oct 14, 2019, at

Re: [sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

On Oct 14, 2019, at 3:04 PM, Keith Medcalf wrote: > > On Monday, 14 October, 2019 14:18, Warren Young wrote: > >> Fossil Forums allow you to subscribe to email notifications. From the >> reader’s perspective, it’s really very little different from the current >> Mailman based scheme. > > The

Re: [sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

On Monday, 14 October, 2019 14:18, Warren Young wrote: >Fossil Forums allow you to subscribe to email notifications. From the >reader’s perspective, it’s really very little different from the current >Mailman based scheme. The preceding paragraph is completely at odds with the following

Re: [sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

On Oct 11, 2019, at 11:33 AM, Tim Streater wrote: > > A mailing list suits me just fine. It works well and gets next to no spam. In > addition, it's not yet another damn website I have to log into to use and > remember my username/password for. And I don't care if it's not "modern”. Fossil

Re: [sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

On Oct 11, 2019, at 9:56 AM, Brannon King wrote: > > I'd like to propose that we > upgrade to something more modern and secure like Sympa or mlmmj, or even a > more drastic system upgrade to something like Redmine -- a project > tracker + forum. This is a really old argument, which we’ve had at

Re: [sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

On Oct 11, 2019, at 9:41 AM, Mike Bayer wrote: > > what is the reason that the SQLite mailing list archives...are private for > members only in order to be read? Probably because you can extract email addresses and real names from the archives. Harvesting of such information is

Re: [sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

Brannon King wrote: > [...] I'd like to propose that we upgrade to something more modern and > secure like Sympa or mlmmj, or even a more drastic system upgrade to > something like Redmine -- a project tracker + forum. I would propose instead to upgrade to a NNTP. (I even wrote a NNTP software

Re: [sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

> On Oct 11, 2019, at 9:19 AM, Mike Bayer wrote: > > GNU Mailman is still very widely used and IMO does the job very well Its web interface is like something from 1997. In particular, it makes reading archives very painful, clicking through to one message at a time. I’d recommend groups.io —

Re: [sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

On 11 Oct 2019, at 16:56, Brannon King wrote: > I agree that Mailman is archaic. I worry about the security on it. I don't > enjoy using 3rd-party mirrors for searching it. I'd like to propose that we > upgrade to something more modern and secure like Sympa or mlmmj, or even a > more drastic

Re: [sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

Are there specific Mailman CVEs you can refer towards such that these settings could not be opened up? The read-only archives appear to be static files, so there is no additional security issue that isn't already presented by the existing cgi-bin already open for public access. Similarly for

Re: [sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

I agree that Mailman is archaic. I worry about the security on it. I don't enjoy using 3rd-party mirrors for searching it. I'd like to propose that we upgrade to something more modern and secure like Sympa or mlmmj, or even a more drastic system upgrade to something like Redmine -- a project

[sqlite] rationale for private archives of the SQLite mailing list and suppressed reply-to

Apologies if this has been asked before but what is the reason that the SQLite mailing list archives, linked at http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users, are private for members only in order to be read? The archives can be viewed at a mirror such as http://sqlite

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

> On Oct 15, 2018, at 5:36 AM, Rowan Worth wrote: > > Anyway my point is I'm not seeing evidence to support the assertion that > gmail treats messages to the list in general as spammish. Ditto. ___ sqlite-users mailing list

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Wed, 10 Oct 2018 at 05:18, Warren Young wrote: > That event was the immediate spur to start this Fossil forum project, but > if you search the archives, there are multiple threads. Here’s one from > about a year ago: > > >

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Tue, Oct 9, 2018 at 5:18 PM Warren Young wrote: > ... The problem is happening because spam gets reflected off this list, so > people click “This is Spam” in Gmail, which causes Gmail’s spam filters to > treat all messages on the list as more spammish. The more that happens, > the less

Re: [sqlite] SQLite mailing list

On 13/10/2018 16:28, Balaji Ramanathan wrote: 8. Re: sqlite-users Digest, Vol 130, Issue 11 (Shawn Wagner) On Thu, 11 Oct 2018 09:51:15 -0500, Balaji Ramanathan < balaji.ramanat...@gmail.com> wrote: 2. Re: SQLite mailing list The 1990's called and they want their mailing

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

>> On Oct 9, 2018, at 7:19 PM, Warren Young wrote: >> >> The arguments about mailing lists vs forums have all been had. > It’s not clear why this entire conversation is presented in such stark terms: LIST > *OR* FORUM. Puzzling. > > If this is all driven by DRH edict that “all things shall run

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

> On Oct 9, 2018, at 7:19 PM, Warren Young wrote: > > The arguments about mailing lists vs forums have all been had. It’s not clear why this entire conversation is presented in such stark terms: LIST *OR* FORUM. Puzzling. If this is all driven by DRH edict that “all things shall run on

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Oct 11, 2018, at 12:06 AM, Random Coder wrote: > > On Wed, Oct 10, 2018 at 3:45 PM Warren Young wrote: >> The salt is the project code combined with the user ID, not a secret >> per-user salt. Both of those values are publicly visible, but it does >> defeat rainbow table attacks, which is

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Oct 11, 2018, at 12:26 AM, Darren Duncan wrote: > > On 2018-10-10 1:36 PM, Eric wrote: >> Too much overhead, how often must I clone ... > > This makes me think that it would be useful, if it doesn't already, for > Fossil to have something analogous to a database replication feature. That’s

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Wed, 10 Oct 2018 16:00:02 -0600, Warren Young wrote: 8>< There comes a point in any written discussion where point-by-point answers become a risk to sanity. I think we are there. It seems that a Fossil forum will someday be able to behave like a mailing list. Good, but if the price

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

Darren Duncan wrote: > On 2018-10-10 10:51 AM, Chris Green wrote: > > Warren Young wrote: > >> Fossil forum email alerts include the full content of the message. > > That's great! Especially if the alert email subject includes the forum > thread > subject. > > That said, I consider it

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Thursday, 11 October, 2018 00:22, Darren Duncan wrote: >On 2018-10-10 12:26 PM, Keith Medcalf wrote: >> And if you think that I am going to create YET ANOTHER LOGIN and >> YET ANOTHER PASSWORD just to use some crappy forum software, you have >> another think coming. > What do you think

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On 2018-10-10 1:36 PM, Eric wrote: Too much overhead, how often must I clone ... This makes me think that it would be useful, if it doesn't already, for Fossil to have something analogous to a database replication feature. A bit like a mailing list but that the sender and client are both

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On 2018-10-10 12:26 PM, Keith Medcalf wrote: And if you think that I am going to create YET ANOTHER LOGIN and YET ANOTHER PASSWORD just to use some crappy forum software, you have another think coming. What do you think password managers are for? Proper security means having a different

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On 2018-10-10 10:51 AM, Chris Green wrote: Warren Young wrote: Fossil forum email alerts include the full content of the message. That's great! Especially if the alert email subject includes the forum thread subject. That said, I consider it critical that these alert emails can also send

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Wed, Oct 10, 2018 at 3:45 PM Warren Young wrote: > Fossil currently has no restrictions on password length[1] or content. The > input text is simply salted, hashed, and inserted into the user table: > [...] > The salt is the project code combined with the user ID, not a secret per-user >

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Oct 10, 2018, at 2:42 PM, Keith Medcalf wrote: > > On Wednesday, 10 October, 2018 14:08, Warren Young wrote: > >> On Oct 10, 2018, at 1:26 PM, Keith Medcalf wrote: > >> The “security code” is just a CAPTCHA > > I hate captcha's and will not use them. They require permitting unrestricted

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Oct 10, 2018, at 2:36 PM, Eric wrote: > > On Wed, 10 Oct 2018 11:10:24 -0600, Warren Young wrote: >> On Oct 10, 2018, at 10:39 AM, Eric wrote: >>> >>> * mailing lists come to me, I don't have to go and get them >> >> So do Fossil email alerts. > > Do they thread? They do in Apple Mail,

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Wed, 10 Oct 2018 14:08:11 -0600, Warren Young wrote: 8>< > I think I can summarize the real objection to this plan quite simply: > nobody likes to have their cheese moved. But cheese moves nevertheless. Cheese does not move, it gets moved. Even in the face of reasoned arguments.

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Wednesday, 10 October, 2018 14:08, Warren Young wrote: >On Oct 10, 2018, at 1:26 PM, Keith Medcalf >wrote: >> there is also absolutely no way to perform "positive identity >checks" on a web page post that cannot be equally trivially >falsified. >You’re conflating physical identity with

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

pository: > > https://fossil-scm.org/fossil/doc/trunk/www/shunning.wiki > > This includes forum posts. Too tedious, and also seems like misuse of a feature, in which case it is the potential start of a slippery slope. > What non-accidental differences do you have in your local

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Oct 10, 2018, at 1:26 PM, Keith Medcalf wrote: > > there is also absolutely no way to perform "positive identity checks" on a > web page post that cannot be equally trivially falsified. You’re conflating physical identity with forum identity. I don’t care whether you have state-approved

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Wednesday, 10 October, 2018 12:31, Warren Young wrote: >On Oct 10, 2018, at 11:51 AM, Chris Green wrote: >> Warren Young wrote: >>> Fossil forum email alerts include the full content of the message. >> And can you then simply 'reply' from your E-Mail client? If not >> then it doesn't

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

> On Oct 10, 2018, at 8:31 PM, Warren Young wrote: > > addresses can be *forged* forged fɔːdʒd/ adjective • copied fraudulently; fake. O no! :( Perhaps the time has come for you to learn the gory details of that so-called 'Simple Mail Transfer Protocol'! :) Simple, but

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

> On Oct 10, 2018, at 8:31 PM, Warren Young wrote: > > The next version of Fossil is likely to include a fully-capable SMTP server Zawinski's Law at work! :D “Every program attempts to expand until it can read mail. Those programs which cannot so expand are replaced by ones which can.”

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Oct 10, 2018, at 11:51 AM, Chris Green wrote: > > Warren Young wrote: >> Fossil forum email alerts include the full content of the message. > > And can you then simply 'reply' from your E-Mail client? If not then > it doesn't really help much. I already addressed that up-thread. The next

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

Warren Young wrote: > On Oct 10, 2018, at 11:23 AM, Tim Streater wrote: > > > > On 10 Oct 2018, at 18:10, Warren Young wrote: > > > >> On Oct 10, 2018, at 10:39 AM, Eric wrote: > >>> > >>> * mailing lists come to me, I don't have to go and get them > >> > >> So do Fossil email alerts. > >

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

> On Oct 10, 2018, at 6:02 PM, Warren Young wrote: > > I’ve written up a long list of advantages to the Fossil forum feature here: Quixotic, but your dedication has to be applauded. Could we agree to disagree though? Or is it a case of "somebody is wrong on the internet”?

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Oct 10, 2018, at 11:23 AM, Tim Streater wrote: > > On 10 Oct 2018, at 18:10, Warren Young wrote: > >> On Oct 10, 2018, at 10:39 AM, Eric wrote: >>> >>> * mailing lists come to me, I don't have to go and get them >> >> So do Fossil email alerts. > > So there's an unecessary email I've

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On 10 Oct 2018, at 18:10, Warren Young wrote: > On Oct 10, 2018, at 10:39 AM, Eric wrote: >> >> * mailing lists come to me, I don't have to go and get them > > So do Fossil email alerts. So there's an unecessary email I've just received telling me to go to the forum. I hate emails like that.

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

doc/trunk/www/shunning.wiki This includes forum posts. What non-accidental differences do you have in your local SQLite mailing list archive as compared to those on the public mailing list archive services? This line of argument also ignores the opposite virtue: with Fossil forums, it is eas

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Wed, 10 Oct 2018 22:48:37 +1100, "Gary R. Schmidt" wrote: > On 10/10/2018 22:20, Petite Abeille wrote: > > > [SNIP] > > ( Also, fwiw: please keep the mailing list, it's perfectly functional as > > is. ) > > > Seconded. > > It isn't broken, so please don't try and fix it. That, and *

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Oct 10, 2018, at 9:09 AM, Eric wrote: > > I don't think that "all been had" applies. Pedantically speaking, yes, you’re right, every possible argument has not been had on this mailing list yet. In order to avoid an “infinite monkeys” argument, let’s make it concrete: what substantial

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Tue, 9 Oct 2018 15:17:52 -0600, Warren Young wrote: > On Oct 9, 2018, at 1:56 PM, Eric wrote: > > > > I suppose I must be an "anti-forum type" even though I have never used > > Gmane, but it does rather sound as though you are applying a somewhat > > perjorative label here. > > I make no

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

Gary R. Schmidt wrote: > On 10/10/2018 22:20, Petite Abeille wrote: > > > [SNIP] > > ( Also, fwiw: please keep the mailing list, it's perfectly functional as > > is. ) > > > Seconded. > > It isn't broken, so please don't try and fix it. > Exactly! :-) -- Chris Green ·

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On 10/10/2018 22:20, Petite Abeille wrote: [SNIP] ( Also, fwiw: please keep the mailing list, it's perfectly functional as is. ) Seconded. It isn't broken, so please don't try and fix it. Cheers, GaryB-) ___

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

> On Oct 9, 2018, at 11:42 PM, Simon Slavin wrote: > > On 9 Oct 2018, at 10:38pm, Keith Medcalf wrote: > >> And just what is NSFW spam? > > Messages purporting to come from young women. Some including images > purporting to be them in various states of undress. ( How does one subscribe?

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On 9 Oct 2018, at 10:38pm, Keith Medcalf wrote: > And just what is NSFW spam? Messages purporting to come from young women. Some including images purporting to be them in various states of undress. Simon. ___ sqlite-users mailing list

Re: [sqlite] SQLite mailing list

On Oct 9, 2018, at 3:05 PM, Simon Slavin wrote: > > On 9 Oct 2018, at 9:49pm, Warren Young wrote: > >> Also: This list may be an unusually juicy target, given the number of places >> SQLite is deployed. > > The minute SQLite gains any sort of internet connectivity, a hundred thousand >

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

>One of the problems we’ve been having on these lists is that every >time someone posts to it, they get NSFW spam, presumably because by >posting, you’ve just proven that your email address is valid. >Everyone on the ML sees the poster’s email address. My mailer >included yours in the quoting

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Oct 9, 2018, at 2:50 PM, Darren Duncan wrote: > > On 2018-10-09 12:56 PM, Eric wrote: >> On Tue, 9 Oct 2018 11:19:13 -0600, Warren Young wrote: >>> Gmane is part of the problem that lead to the creation of the Fossil >>> forum feature. Viz., it enables spammers, by design: >>> >>>

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Oct 9, 2018, at 1:56 PM, Eric wrote: > > I suppose I must be an "anti-forum type" even though I have never used > Gmane, but it does rather sound as though you are applying a somewhat > perjorative label here. I make no value judgement. If you are against web forums, then you are

Re: [sqlite] SQLite mailing list

On 9 Oct 2018, at 9:49pm, Warren Young wrote: > Also: This list may be an unusually juicy target, given the number of places > SQLite is deployed. The minute SQLite gains any sort of internet connectivity, a hundred thousand man-hours of cracking attempts will be launched. Which is why it's

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On 2018-10-09 12:56 PM, Eric wrote: On Tue, 9 Oct 2018 11:19:13 -0600, Warren Young wrote: Gmane is part of the problem that lead to the creation of the Fossil forum feature. Viz., it enables spammers, by design: http://gmane.org/about/ I don't see that page saying what you claim it

Re: [sqlite] SQLite mailing list

On Oct 9, 2018, at 1:20 PM, Ian Zimmerman wrote: > > There are many mailing lists which are not moderated by a human (to my > knowledge) and do not suffer from this problem. Why? Maybe because > someone took time to put a well tuned spam filter in place on the MTA > level? Would you rather

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Tue, 9 Oct 2018 11:19:13 -0600, Warren Young wrote: > On Oct 9, 2018, at 7:48 AM, Scott Robison wrote: >> >> Isn't Gmane a web forum style interface to email lists? > > Gmane also provides NNTP access. I suspect the anti-forum types are > using Usenet news readers to follow such lists.

Re: [sqlite] SQLite mailing list

On 2018-10-09 11:19, Warren Young wrote: > Gmane is part of the problem that lead to the creation of the Fossil > forum feature. Viz., it enables spammers, by design: > > http://gmane.org/about/ > [...] > It is possible that Fossil will grow an email submission feature > before that

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Oct 9, 2018, at 7:48 AM, Scott Robison wrote: > > Isn't Gmane a web forum style interface to email lists? Gmane also provides NNTP access. I suspect the anti-forum types are using Usenet news readers to follow such lists. Gmane is part of the problem that lead to the creation of the

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Tue, Oct 9, 2018, 6:34 AM Will Parsons wrote: > On Sunday, 7 Oct 2018 5:25 PM -0400, Keith Medcalf wrote: > > > > Many people do not "do" web forums. I am one of them. If there is not > a mailing list then it does not exist. > > I completely agree. I read and post to the SQLite mailing

[sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Sunday, 7 Oct 2018 5:25 PM -0400, Keith Medcalf wrote: > > Many people do not "do" web forums. I am one of them. If there is not a > mailing list then it does not exist. I completely agree. I read and post to the SQLite mailing via Gmane, and I used to do the same for Fossil. Now that

Re: [sqlite] Mailing list shutting down...

Check out: http://c.qyv.net/mailmansrc/info/a6250b7ba075294c This is a patch to mailman version 2.1.20 (the version deployed on sqlite.org). It adds a three day waiting period between subscription attempts. When applying this patch also be sure to edit Defaults.py (which is generated at

Re: [sqlite] Mailing list shutting down...

I am so offering... -Jeff On Wed, Jun 13, 2018 at 12:42 PM Richard Hipp wrote: > On 6/13/18, Michael Tiernan wrote: > > May I respectfully suggest to everyone that offering solutions, while > > valuable and helpful, may not be as valuable as the offer of assistance > > to our listmaster. > >

Re: [sqlite] Mailing list shutting down...

The latest version of Mailman does implement a Captcha (via reCaptcha). Also, if you set mm_cfg.SUBSCRIBE_FORM_SECRET to a secret value, Mailman will insist that the subscription form be submitted after a slight delay, which defaults to 5 seconds. This features exists in the version currently used

Re: [sqlite] Mailing list shutting down...

On 2018-06-14 17:17, Vincenzo Campanella wrote: > uses googlegroups.com, that then works exactly as a mailing list > (their mail address is wx-us...@googlegroups.com); perhaps this can > give you an alternative idea... It works fine as a mailing list _if_ most (better: all) posters use it as

Re: [sqlite] Mailing list shutting down...

Il 13.06.2018 15:28, Olivier Mascia ha scritto: Le 13 juin 2018 à 13:22, Richard Hipp a écrit : Unfortunately, I'm going to need to shut down this mailing list due to robot harassment. ... I have already suspended new subscriptions. Existing subscribers will be able to continue using this

Re: [sqlite] Mailing list shutting down...

On Wed, 13 Jun 2018 07:22:20 -0400 Richard Hipp wrote: > Unfortunately, I'm going to need to shut down this mailing list due to > robot harassment. I am working to come up with a fix or an > alternative now. Your suggestions are welcomed. > > This mailing list has operated for many years

Re: [sqlite] Mailing list shutting down...

On 6/13/18 6:52 PM, Bob Friesenhahn wrote: > On Wed, 13 Jun 2018, Jeffrey Schiller wrote: > >> Would limiting subscription requests to one per day help. I'm >> familiar with >> the Mailman code, having modified it for use at MIT, and can code the >> necessary changes. I suspect only one file would

Re: [sqlite] Mailing list shutting down...

On Wed, Jun 13, 2018 at 5:17 PM Simon Slavin wrote: > 13 Jun 2018, at 11:52pm, Bob Friesenhahn > wrote: > > > The problem is knowing what "one" means. The subscription request is > likely submitted via http/https into the web form and using a bogus email > subscription address (of the

Re: [sqlite] Mailing list shutting down...

13 Jun 2018, at 11:52pm, Bob Friesenhahn wrote: > The problem is knowing what "one" means. The subscription request is likely > submitted via http/https into the web form and using a bogus email > subscription address (of the "victim"). A botnet is able to submit these > requests from

Re: [sqlite] Mailing list shutting down...

On Wed, 13 Jun 2018, Jeffrey Schiller wrote: Would limiting subscription requests to one per day help. I'm familiar with the Mailman code, having modified it for use at MIT, and can code the necessary changes. I suspect only one file would need to be changed. The problem is knowing what "one"

Re: [sqlite] Mailing list shutting down...

Would limiting subscription requests to one per day help. I'm familiar with the Mailman code, having modified it for use at MIT, and can code the necessary changes. I suspect only one file would need to be changed. -Jeff On Wed, Jun 13, 2018 at 6:16 PM Gary R. Schmidt wrote: > On 13/06/2018

Re: [sqlite] Mailing list shutting down...

On 13/06/2018 21:42, Gary R. Schmidt wrote: On 13/06/2018 21:22, Richard Hipp wrote: Unfortunately, I'm going to need to shut down this mailing list due to robot harassment.  I am working to come up with a fix or an alternative now.  Your suggestions are welcomed. This mailing list has

Re: [sqlite] Mailing list shutting down...

On 14/06/2018 03:37, John Long wrote: On Wed, 2018-06-13 at 21:42 +1000, Gary R. Schmidt wrote: This is an increasing problem, and has been discussed on the Mailman mailing list recently, you should join them and see what mitigation strategies are available. Well I'm sure he would like to,

Re: [sqlite] Mailing list shutting down...

On 6/13/18, Florian Weimer wrote: > if the bots are > actually targeting innocent users, for most recipients, they can just > use multiple aliases of the form , > , and so on. I have a accumulated a good assortment of robot counter-measures over the years, a few of which are outlined here:

Re: [sqlite] Mailing list shutting down...

* Richard Hipp: > On 6/13/18, Brian Curley wrote: >> Doesn't the Fossil site already have a Capcha interface built into it that >> could be adopted to enforce additional authentication around subscriptions? > > There are no captchas built into GNU MailMan. You enter your email > address to

Re: [sqlite] Mailing list shutting down...

Using policyd one should be able to limit the rate at which one account (subscribe confirmation) is able to send messages to a particular address, or the overall number of mails sent to an address. https://wiki.policyd.org/quotas On Wed, Jun 13, 2018, 9:36 PM Richard Hipp wrote: > On 6/13/18,

Re: [sqlite] Mailing list shutting down...

Richard, We use Discourse (as a user) to get support for the Mail in a Box system. MIAB use Discourse for their support systems. I also think Discourse is used for the Ionic support pages as well as they have very similar looking interfaces. Until now I paid little attention to them. I was

Re: [sqlite] Mailing list shutting down...

On 6/13/18, Simon Slavin wrote: > > > On 13 Jun 2018, at 3:02pm, Simon Slavin wrote: > >> you might try the solution described in the lower part of >> >> >> >> and also the measure recommended here: >> >>

Re: [sqlite] Mailing list shutting down...

On 6/13/18, Alessandro Marzocchi wrote: > Do you have control over postfix server? If so maybe adding a policy to the > account used for subscription confirmation may work. I dont have a PC > available at the moment but in the case i may check. I don't see how that could possibly help. Please

Re: [sqlite] Mailing list shutting down...

Do you have control over postfix server? If so maybe adding a policy to the account used for subscription confirmation may work. I dont have a PC available at the moment but in the case i may check. On Wed, Jun 13, 2018, 9:16 PM Chris Brody wrote: > On Wed, Jun 13, 2018 at 3:00 PM Richard Hipp

Re: [sqlite] Mailing list shutting down...

On Wed, Jun 13, 2018 at 3:00 PM Richard Hipp wrote: > > Cross-posted to the fossil-users mailing list since www.fossil-scm.org +1 > Even so, Discourse does seem like considering. Does anybody else have > any experience with Discourse, good or bad? SQLCipher switched over to Discourse for the

Re: [sqlite] Mailing list shutting down...

On 13 Jun 2018, at 3:02pm, Simon Slavin wrote: > you might try the solution described in the lower part of > > > > and also the measure recommended here: > >

Re: [sqlite] Mailing list shutting down...

Cross-posted to the fossil-users mailing list since www.fossil-scm.org and www.sqlite.org are the same machine and both mailing lists are impacted by the current problem. On 6/13/18, Luiz Américo wrote: > How about using https://www.discourse.org/ ? > > Open source projects can use for free

Re: [sqlite] Mailing list shutting down...

How about using https://www.discourse.org/ ? Open source projects can use for free Luiz Em qua, 13 de jun de 2018 14:37, John Long escreveu: > On Wed, 2018-06-13 at 21:42 +1000, Gary R. Schmidt wrote: > > > > > > This is an increasing problem, and has been discussed on the Mailman > > mailing

Re: [sqlite] Mailing list shutting down...

On Wed, 2018-06-13 at 21:42 +1000, Gary R. Schmidt wrote: > > > This is an increasing problem, and has been discussed on the Mailman > mailing list recently, you should join them and see what mitigation > strategies are available. Well I'm sure he would like to, but subscriptions have

Re: [sqlite] Mailing list shutting down...

On 6/13/18, Michael Tiernan wrote: > May I respectfully suggest to everyone that offering solutions, while > valuable and helpful, may not be as valuable as the offer of assistance > to our listmaster. +1 :-) -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] Mailing list shutting down...

May I respectfully suggest to everyone that offering solutions, while valuable and helpful, may not be as valuable as the offer of assistance to our listmaster. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Mailing list shutting down...

On Wed, Jun 13, 2018 at 12:14:46PM -0400, Richard Hipp wrote: > (1) Nobody seems to want to own the GNU MailMan software. It is not > well maintained as far as I can see. I'm not an expert, but how does Sympa handle this? I remember a few years ago a lot of people were moving their Mailman

Re: [sqlite] Mailing list shutting down...

On 6/13/18, Brian Curley wrote: > Doesn't the Fossil site already have a Capcha interface built into it that > could be adopted to enforce additional authentication around subscriptions? There are no captchas built into GNU MailMan. You enter your email address to subscribe and you get a

Re: [sqlite] Mailing list shutting down...

Doesn't the Fossil site already have a Capcha interface built into it that could be adopted to enforce additional authentication around subscriptions? Or a 2-step, email confirmation-type option, maybe? If they're robots causing the problem, then they wouldn't be able to mive beyond the initial

Re: [sqlite] Mailing list shutting down...

On 6/13/18, Chris Brody wrote: > On Wed, Jun 13, 2018 at 10:44 AM jungle Boogie > wrote: >> [...] >> http://spamassassin.apache.org/ > > Maybe just add SpamAssassin to the existing GNU MailMan setup? > > http://www.jamesh.id.au/articles/mailman-spamassassin/ That solves a different problem from

Re: [sqlite] Mailing list shutting down...

On Wed, Jun 13, 2018 at 10:44 AM jungle Boogie wrote: > [...] > http://spamassassin.apache.org/ Maybe just add SpamAssassin to the existing GNU MailMan setup? http://www.jamesh.id.au/articles/mailman-spamassassin/ ___ sqlite-users mailing list

Re: [sqlite] Mailing list shutting down...

On 13 June 2018 at 04:22, Richard Hipp wrote: > Unfortunately, I'm going to need to shut down this mailing list due to > robot harassment. I am working to come up with a fix or an > alternative now. Your suggestions are welcomed. > OpenBSD uses Majordomo for their mailing lists:

Re: [sqlite] Mailing list shutting down...

On 13 Jun 2018, at 12:22pm, Richard Hipp wrote: > The most recent problem is that robots are visiting the subscription > page and entering innocent user's email addresses and names. I'm surprised the server lasted this long. That problem has been around since 2010. I don't know what you've

Re: [sqlite] Mailing list shutting down...

> Le 13 juin 2018 à 13:22, Richard Hipp a écrit : > > Unfortunately, I'm going to need to shut down this mailing list due to > robot harassment. > ... > I have already suspended new subscriptions. Existing subscribers will > be able to continue using this list until I come up with a replacement

Re: [sqlite] Mailing list shutting down...

On 6/13/18, Tim Streater wrote: > Personally I'd be loath to see this list moved to a web page, for > instance. We invite you to submit working code that implements your desired solution. :-) -- D. Richard Hipp d...@sqlite.org ___ sqlite-users

Re: [sqlite] Mailing list shutting down...

On 13 Jun 2018, at 12:22, Richard Hipp wrote: > Unfortunately, I'm going to need to shut down this mailing list due to > robot harassment. I am working to come up with a fix or an > alternative now. Your suggestions are welcomed. Perhaps another subscription mechanism is needed, if that is

Re: [sqlite] Mailing list shutting down...

On 13/06/2018 21:22, Richard Hipp wrote: Unfortunately, I'm going to need to shut down this mailing list due to robot harassment. I am working to come up with a fix or an alternative now. Your suggestions are welcomed. This mailing list has operated for many years using GNU MailMan.

  1   2   >