Topic: Mass email sent with mailman - MAILER-DAEMON invalid email-adresses

[SchulzStefan]

Christmas is not far away, so everybody wants to send their customers or business-partners a merry christmas via email. Now we're using the mailman contrib for this. Of course, if an email-adress is invalid, it will bounce back.

Here's my question: is there any chance to grep those emails and pipe them in an csv-file? So I could import the file in libreoffice, and select the invalid email-adresses for a mass unsubscribe in mailman?

Any hint would be great.

Thank's in advance,
stefan

[guest22]

Hi Stefan, unfortunately I can not answer your question, but I'm sure somebody will jump in soonish.

As a tip, maybe for next year http://wiki.contribs.org/Phplist

[SchulzStefan]

RequestedDeletion,

thank you for your reply. I'll take a look on phplist as soon, as I find some time.

[SchulzStefan]

I think I found a way:

In the maillog/cur directory
#grep -A 2 -n "gescheitert" * > bad_email.csv

edit: this might be better:
#grep -n "550 5" * > bad_email.csv

In English it should be "failed". That gives a csv-file which can easily stripped in oo, libreoffice or any other calc-program.

Thank's to everybody for having a look.
stefan

[ReetP]

Hi Stefan, unfortunately I can not answer your question, but I'm sure somebody will jump in soonish.

As a tip, maybe for next year http://wiki.contribs.org/Phplist

It's very good and I use it for all our mailings. It will handle bounces, unsubscribes, google analytics (if you like such stuff) etc etc.

I'd like to build a contrib..... time... time... time....

[guest22]

But phplist *IS* already a contrib....

[janet]

RequestedDeletion et al

But phplist *IS* already a contrib....

Well to be pedantic, it is not a contrib.
From here
http://wiki.contribs.org/Category:Contrib
it says
To be listed on this page, the contrib should comply with these rules:
    Be available in the smecontrib repository
    Have a wiki page with install and usage instructions, following the template listed on the talk page.
    Have a Bugzilla Contribs Component

There are quite a few "contribs" appearing on the Contrib category page that are hosted externally on other peoples repos.
These externally hosted contribs should theoretically be Howtos.
I am not complaining about this, as I am extremely grateful to those who do make contribs & host them externally.

I understood years ago the reason for hosting them on the smecontrib repo was so that the code underwent peer review prior to being hosted by contribs.org

Do we need to relax the "rules" & leave things as they are, or do we need to tighten the "rules" & move articles for externally hosted contribs to the Howto category.

Like I said I am grateful & happy that there are people who have done the work to create these packages & are happy to host them & provide them to us all for free, & I do very much understand that there are only a few workers (coders) so we (collectively) have to accept how the few want to do things (ie host on their own sites for ease of management etc etc).

I have been caught (tricked myself) quite a number of times when looking for packages in the Howto page only to find them on the Contrib page & also could not find certain articles under Contrib or Howto, only to later find them uncategorised. There seems to be quite a few uncategorised articles that really should/could be labelled as Howto or Contrib (last time I looked anyway). Not really had time to search & fix them myself, due in part to inconsistencies mentioned above, so this was the time for me to mention something.

[guest22]

Excellent post! and completely true...


We are behind with our workload *and* following our own rules. Mostly because of lack of resources.

[ReetP]

Excellent post! and completely true...

+1 and nicely said by janet

Some good ideas there and we can definitely look at it but.....

We are behind with our workload *and* following our own rules. Mostly because of lack of resources.

Yup. Sad but true.

[CharlieBrady]

Christmas is not far away, so everybody wants to send their customers or business-partners a merry christmas via email. Now we're using the mailman contrib for this. Of course, if an email-adress is invalid, it will bounce back.

Here's my question: is there any chance to grep those emails and pipe them in an csv-file? So I could import the file in libreoffice, and select the invalid email-adresses for a mass unsubscribe in mailman?

If you use ezmlm, the unsubscribe of bad addresses is automatic.

[SchulzStefan]

Posted by: CharlieBrady:
If you use ezmlm, the unsubscribe of bad addresses is automatic.

That sounds pretty comfortable, I'll try this. Thank you for your hint.

---

Followed this: http://wiki.contribs.org/Ezmlm

# yum install --enablerepo=smecontribs smeserver-ezmlm-web
Geladene Plugins: fastestmirror, smeserver
Einrichten des Installationsprozess
Loading mirror speeds from cached hostfile
 * base: centos.copahost.com
 * smeaddons: sme.mellerupnet.dk
 * smecontribs: sme.mellerupnet.dk
 * smeextras: sme.mellerupnet.dk
 * smeos: sme.mellerupnet.dk
 * smeupdates: sme.mellerupnet.dk
 * updates: mirror2.hs-esslingen.de
Kein Paket smeserver-ezmlm-web verfügbar.
Fehler: Nichts zu tun

Tried that:

# yum install --enablerepo=smedev smeserver-ezmlm-web
Geladene Plugins: fastestmirror, smeserver
Einrichten des Installationsprozess
Loading mirror speeds from cached hostfile
 * base: centos.mirrors.as250.net
 * smeaddons: sme.mellerupnet.dk
 * smedev: sme.mellerupnet.dk
 * smeextras: sme.mellerupnet.dk
 * smeos: sme.mellerupnet.dk
 * smeupdates: sme.mellerupnet.dk
 * updates: centos.mirrors.as250.net
Löse Abhängigkeiten auf
--> Führe Transaktionsprüfung aus
---> Package smeserver-ezmlm-web.noarch 0:1.1.3-1.el6.sme will be installiert
--> Verarbeite Abhängigkeiten: perl(Mail::Ezmlm) >= 0.07 für Paket: smeserver-ezmlm-web-1.1.3-1.el6.sme.noarch
--> Verarbeite Abhängigkeiten: ezmlm-web für Paket: smeserver-ezmlm-web-1.1.3-1.el6.sme.noarch
--> Verarbeite Abhängigkeiten: ezmlm-idx-std für Paket: smeserver-ezmlm-web-1.1.3-1.el6.sme.noarch
--> Abhängigkeitsauflösung beendet
Fehler: Package: smeserver-ezmlm-web-1.1.3-1.el6.sme.noarch (smedev)
            Requires: ezmlm-idx-std
Fehler: Package: smeserver-ezmlm-web-1.1.3-1.el6.sme.noarch (smedev)
            Requires: ezmlm-web
Fehler: Package: smeserver-ezmlm-web-1.1.3-1.el6.sme.noarch (smedev)
            Requires: perl(Mail::Ezmlm) >= 0.07
 Sie können versuchen --skip-broken zu benutzen, um das Problem zu umgehen.
 You could try running: rpm -Va --nofiles --nodigest

Not able to install the contrib. Re-opend http://bugs.contribs.org/show_bug.cgi?id=8439

EDITED for the bug.