Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-06-02 Thread Gerry Snyder
A. Pagaltzis wrote: This suggests a different strategy: alternate between sending opt-out and opt-in mails. Indiscriminate autoresponders will unsubscribe themselves when they get an opt-out mail; people who throw the mail away will silently drop out after failing to respond to the opt-in mail.

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-06-01 Thread Florian Weimer
* Clay Dowling: > [EMAIL PROTECTED] at least does have an auto-responder. The message > contains the text of any message sent to it, appended to the bottom of > the email. That would serve to automatically validate the check > email. In my experience, the real problem with ezmlm's subscription

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-31 Thread Dennis Jenkins
Clark Christensen wrote: >> And yet somehow, the spammer still managed to get signed up >> using a "paypal.com" address. How did they do that? >> -- >> > > As others have pointed-out, there's probably a simple autoresponder on many > [EMAIL PROTECTED] mailboxes. It replied, and that was

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-31 Thread Ulrich Schöbel
How about asking a new subscriber to copy some magic number from the body to the subject of his reply? AFAIK autoresponders can't do that. Kind regards Ulrich On Wednesday 31 May 2006 17:17, Clark Christensen wrote: > > And yet somehow, the spammer still managed to get signed up > > using a

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-31 Thread Clark Christensen
> And yet somehow, the spammer still managed to get signed up > using a "paypal.com" address. How did they do that? > -- As others have pointed-out, there's probably a simple autoresponder on many [EMAIL PROTECTED] mailboxes. It replied, and that was good enough :-) I think if the list

RE: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-30 Thread Bob Dankert
PROTECTED] Sent: Tuesday, May 30, 2006 10:26 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access I agree with Jay. I'd hate to have to respond to an e-mail ping every so often just to continue reading the list. On the other

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-30 Thread Craig Morrison
Jay Sprenkle wrote: On 5/30/06, Eric Scouten <[EMAIL PROTECTED]> wrote: I agree with Jay. I'd hate to have to respond to an e-mail ping every so often just to continue reading the list. On the other hand, I wouldn't mind terribly if I got placed on "moderated" status (i.e. had to go through a

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-30 Thread Jay Sprenkle
On 5/30/06, Eric Scouten <[EMAIL PROTECTED]> wrote: I agree with Jay. I'd hate to have to respond to an e-mail ping every so often just to continue reading the list. On the other hand, I wouldn't mind terribly if I got placed on "moderated" status (i.e. had to go through a verification step in

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-30 Thread Eric Scouten
I agree with Jay. I'd hate to have to respond to an e-mail ping every so often just to continue reading the list. On the other hand, I wouldn't mind terribly if I got placed on "moderated" status (i.e. had to go through a verification step in order to *post* to the list) if I were either

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-30 Thread A. Pagaltzis
* Jay Sprenkle <[EMAIL PROTECTED]> [2006-05-30 17:00]: > You could sign up an autoresponder email account (like paypal) > and it would stay signed up forever. It would always respond to > the query email with a reply including the original text of the > message. You'd need to set it up so they had

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-30 Thread Jay Sprenkle
On 5/30/06, Eugene Wee <[EMAIL PROTECTED]> wrote: Hi, Basically, what I imagined from DRH's original proposal was that accounts that have not sent out mails after some period of time would receive an email informing them that they will be unsubscribed unless they send a mail to the mailing

RE: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-30 Thread Fred Williams
BUT, the spammers ARE posting... > -Original Message- > From: Jay Sprenkle [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 30, 2006 8:46 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Purging the mailing list roles. Was: Please > Restore Your Account Acces

RE: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-30 Thread Brandon, Nicholas (UK)
> > I wonder if I need to implement some kind of mechanism that requires > you to either send a message to the mailing list or else renew your > subscription every 3 months. Does anybody have any experience with > other mailing lists that require such measures? > As most people, they are either

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-30 Thread Jay Sprenkle
On 5/29/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: I wonder if I need to implement some kind of mechanism that requires you to either send a message to the mailing list or else renew your subscription every 3 months. Does anybody have any experience with other mailing lists that require

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-29 Thread John Stanton
[EMAIL PROTECTED] wrote: "Fred Williams" <[EMAIL PROTECTED]> wrote: How about some form of automated(?) sequence where: New subscriber submits subscription request. System sends "query" message to subscriber address. New subscriber sends "confirmation" message within

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-29 Thread Paul Nash
1200 is a modest number for a mailing list . Expect it to go up to 3-4000 as SQLite gets more popular. One reason for the lists popularity is the friendliness of the list members and their willingness to respond to basic SQL queries. At some stage the list could be split into two. One for

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-29 Thread Alex Roston
This is an excellent idea. Alex René Tegel wrote: Hi, Seen the popularity of sqlite, i think 1200 subscribers is very reasonable. Lots of people track mailing lists, only contributing rarely but nevertheless are interested. You could consider a system that requires moderation by the

RE: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-29 Thread Robert Simpson
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, May 29, 2006 7:25 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Purging the mailing list roles. Was: > Please Restore Your Account Access > > Such a system is a

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-29 Thread Markus Hoenicka
Clay Dowling <[EMAIL PROTECTED]> was heard to say: > You might want to consider reworking the check mechanism, using the > capture mechanism that a lot of web forums and blogs use. Users must > type in text presented on a web page in the form of a graphic. That > will put a stop to the

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-29 Thread Clay Dowling
[EMAIL PROTECTED] wrote: "Fred Williams" <[EMAIL PROTECTED]> wrote: How about some form of automated(?) sequence where: New subscriber submits subscription request. System sends "query" message to subscriber address. New subscriber sends "confirmation" message within

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-29 Thread Jalil Vaidya
--- [EMAIL PROTECTED] wrote: > And yet somehow, the spammer still managed to get > signed up > using a "paypal.com" address. How did they do that? Its probably very easy to screen scrape the message to harvest every link in the confirmation message and do a wget on it! I must admit that I do

RE: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-29 Thread Fred Williams
-- > -Original Message- > From: Fred Williams [mailto:[EMAIL PROTECTED] > Sent: Monday, May 29, 2006 9:07 AM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] Purging the mailing list roles. Was: Please > Restore Your Account Access > > > How a

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-29 Thread drh
"Fred Williams" <[EMAIL PROTECTED]> wrote: > How about some form of automated(?) sequence where: > > New subscriber submits subscription request. > > System sends "query" message to subscriber address. > > New subscriber sends "confirmation" message within reasonable time >

RE: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-29 Thread Fred Williams
o:[EMAIL PROTECTED] > Sent: Monday, May 29, 2006 7:13 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Purging the mailing list roles. Was: Please > Restore Your Account Access > > > Hi, > > Seen the popularity of sqlite, i think 1200 subscribers is very &

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-29 Thread Clay Dowling
[EMAIL PROTECTED] wrote: In order to be able to send messages to this mailing list, the spammer above had to subscribe. To subscribe means that he had to respond to an email that was sent to the subscription address. Since his email address does not exist, I'm wondering how he managed to pull

AW: Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-29 Thread michael . ruck
I second this. I don't mind having to post or refresh my subscription every once in a while. It would however be important for me to receive a notification to refresh my subscription instead of just silently removing my subscription. HTH, Mike >Hi, > >I think many of the 1217 active

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-29 Thread René Tegel
Hi, Seen the popularity of sqlite, i think 1200 subscribers is very reasonable. Lots of people track mailing lists, only contributing rarely but nevertheless are interested. You could consider a system that requires moderation by the list administrator for each first message a newly

Re: [sqlite] Purging the mailing list roles. Was: Please Restore Your Account Access

2006-05-29 Thread Eugene Wee
Hi, I think many of the 1217 active subscribers are people like me who tune in to the list but only contribute once in a blue moon. I do not have any objection to a "send email to keep your subscription active" idea, but I have never seen that used in the other mailing lists that I