Move from Mailmain to self-sending

[szabgab]

Currently mailman is used both to allow users to subscribe and unsubscribe and to send the emails. There are several issues with this:

• spamming the subscription form
• mails sent from my server are considered spam

I'd like to move to Perl-based web application to handle registration and then use something like SendGrid to send out the messages.

• SendGrid: We already have a script that can send messages via SendGrid, now it needs to be able to send to all the addresses extracted from mailmain.

• Register with an e-mail, send confirmation code, expect the user to click on it to verify the e-mail.

• Use some Perl-ish captcha to limit the spammy registrations.

• Allow unsubscribe - for this we can have the same mechanism: send a confirmation request to the email address and when the use clicks on the link in it we remove that email. (This will eliminate the need to store and handle passwords)

• In the database store the email address, weather it was verified or not, when was the email added, when was it verified. Full name.

• Send confirmation mail about subscription and un-subscription to the user.

Admin features:

• Send notification about each subscription and un-subscription to the "admin" email address.
• See the list of subscribers - It is enough to have this on the command line.
• Unsubscribe and e-mail address without the need of confirmation from the user (sometimes they don't know how to do it), use a flag to notify (or not) the user about the un-subscribe.
• Import all the users from mailman (Those include name, email address). In order to know which users were imported from mailman we can set them to be verified and we can set both the subscription and verification date to the date of import. We can also keep around - in a hidden place, the list of all the people who were imported for later lookup.