[plug] mysql + mailman

[Shayne O'Neill]

Ok. Found a spunky little patch that seems to do the job..

http://kyrian.ore.org/MailmanMysql/

Required some massaging to get it to work, but it works just lovely.

basically takes out the pickle adaptor and replaces it with mysql

Now I just gotta migrate these little bastards on the current list.

Tis nice so far.... basic scenario. On Filemaker pro, the user selects a
range of students (ie "international" or whatever) , then using sql
adaptor, it transfers these into mysql on another machine and from here,
they can be directly emailed.

Now to move all the student records off the fscking buggy Filemaker pro
system completely .... eep.

Anyone had any experience with pgaccess ?? is it 'enterprise' useable. I'm
tempted to build a front end for the mysql stuff with boa-constructor (for
purrrty gui purposes) but .. yeah.

------------------------------------
"Must not Sleep! Must warn others!"
-Aesop.
Shayne O'Neill. Indymedia. Fun.
http://www.perthimc.asn.au

On Fri, 28 May 2004, Andrew Howell wrote:

> I just use a script that removes everyone from the list and then adds
> everyone back based on a sql query. So it doesn't store membership in
> the database but the membership is generated from the database.
>
> Andrew
>
> On Thu, 2004-05-27 at 15:04, Shayne O'Neill wrote:
> > Has anyone ever tried, or know if its possible , to use mysql as a storage
> > medium for mailman list membership.?
> >
> > I need a method to syncronise a realtime student details db with mailman
> >
> > (And no I'm not making a spam deathmachine)
> >
> > Shayne
> >
> > ------------------------------------
> > "Must not Sleep! Must warn others!"
> > -Aesop.
> > Shayne O'Neill. Indymedia. Fun.
> > http://www.perthimc.asn.au
> >
> >
> > _______________________________________________
> > PLUG discussion list: plug at plug.linux.org.au
> > http://mail.plug.linux.org.au/cgi-bin/mailman/listinfo/plug
> > Committee e-mail: committee at plug.linux.org.au
> --
> Andrew Howell
> Director
> Informed Technology
> E-mail: andrew at it.net.au
> Ph: 08 9380 4244  Fax: 08 9380 4354
>
> _______________________________________________
> PLUG discussion list: plug at plug.linux.org.au
> http://mail.plug.linux.org.au/cgi-bin/mailman/listinfo/plug
> Committee e-mail: committee at plug.linux.org.au
>