Hi,
Has any one tried integrating sendmail with mysql for storing emails to an database. Can sendmail be modified to store incoming mail in databases.
What is the general experience running (my)SQL databases with MTA's? What kind of solutions have people used them for?
Please if some one has done this, do respond back.
Regards,
Rajendra Rait.
Sometime Today, RR cobbled together some glyphs to say:
Has any one tried integrating sendmail with mysql for storing emails to an database. Can sendmail be modified to store incoming mail in
Just curious. Why do you want to do that? It's really not a good idea.
Has any one tried integrating sendmail with mysql for storing emails to an database. Can sendmail be modified to store incoming mail in databases.
Yes. Write a local mailer, which parse local e-mails into mysql database.
What is the general experience running (my)SQL databases with MTA's? What
not really good.
kind of solutions have people used them for?
to achive what ?
Animesh.
__________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com
On Friday 04 Nov 2005 7:11 pm, Rajendra Rait wrote:
Hi,
Has any one tried integrating sendmail with mysql for storing emails to an database. Can sendmail be modified to store incoming mail in databases.
i did this long ago - not storing the whole mail, just piped each mail to a perl script which wrote relevant details into a mysql database and piped it back to sendmail. Main use of this was, accounting (i was running a mailserver and charging for each mail according to size) and elimination of duplicate mails (in the days when downloads got cut resulting in multiple copies of the same mail). I still have the perl scripts somewhere if you are interested.
i did this long ago - not storing the whole mail, just piped each mail to a perl script which wrote relevant details into a mysql database and piped it back to sendmail. Main use of this was,
Sounds interesting. were you fitted the code ?
accounting (i was running a mailserver and charging for each mail according to size) and elimination of duplicate mails (in the days when downloads got cut resulting in multiple copies of the same mail). I
seems you too wrote a local mailer.
still have the perl scripts somewhere if you are interested.
Yes I would be interested in seeing the code. If it was not replacing MDA.
thanks,
Animesh.
__________________________________ Yahoo! FareChase: Search multiple travel sites in one click. http://farechase.yahoo.com
On Saturday 05 Nov 2005 10:02 am, Animesh Singh wrote:
elimination of duplicate mails (in the days when downloads got cut resulting in multiple copies of the same mail). I
seems you too wrote a local mailer.
not a local mailer, just a script (with a gui) for storing relevant details of the mail in a database
still have the perl scripts somewhere if you are interested.
Yes I would be interested in seeing the code. If it was not replacing MDA.
it is not replacing the MDA which was sendmail - i will put it up somewhere in a day or two
dear kenneth,
not a local mailer, just a script (with a gui) for storing relevant details of the mail in a database
Wish to know where you injected the script in MTA ( sendmail ).
it is not replacing the MDA which was sendmail - i
FYI: Sendmail is MTA and I pointed out for MDA.
wish to see your script, as you mention that it was not replacing MDA.
Animesh.
__________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com
On Saturday 05 Nov 2005 6:02 pm, Animesh Singh wrote:
storing relevant details of the mail in a database
Wish to know where you injected the script in MTA ( sendmail ).
sorry, i searched, but could not find the original script where i had injected in sendmail - i had later changed the script to parse the output from fetchmail as those details were enough for my database. I do remember it involved adding a line in sendmail.cf which piped the mail to my script which then piped it back to sendmail for further processing, but since i stopped using sendmail some years back, i cant remember how i did it.
-
Animesh Singh -
Kenneth Gonsalves -
Philip Tellis -
Rajendra Rait