Hello all, I have researched a fair amount via the dbmail wiki, googling and searching the mailing list archives and have yet to come across clear direction and am seeking your collecive wisdom. I am considering the use of dbmail for a project where I have email that needs to be processed and inserted into mysql. I am thinking it would be very helpful to incorporate dbmail into the mix to properly parse and insert the email into mysql. Ultimately what I am trying to do seems very similar to what I am certain others have done to port over existing mail from a remote IMAP server into a local dbmail instance.
At present, I am accessing/processing multiple email boxes, one at a time, via IMAP in a custom built script. As such, I have access to the raw email message. I was hoping to be able to fetch the email via IMAP and pipe the email directly to dbmail-smtp but I am uncertain what format dbmail-smtp is expecting. Can I simply open a pipe to it and start shoving email across the pipe? Though I wish it was that simple, I am guessing that is not the case. Do you know what communications format dbmail-smtp is expecting when it is being communicated with via a un*x pipe? Is is expecting a fully formed SMTP interchange over the pipe connection? Alternately, if I can not pipe directly to dbmail, do you have a suggested path of least resistance? I have thought about writing the email out from my custom script in maildir or similar format and using some middleman software to read the emails from the filesystem and send them on to dbmail. Presumably mailbox2dbmail would serve this purpose. This method is less desirable to me because of the the intermediary involvement of the filesystem but I am willing to consider it. I suppose it does have some upside as I could use dbmail-lmtp as a daemon for receiving the files. Of greatest importance, I prefer the email to be imported as-is. Meaning, I do not want the headers disturbed or appended to by the intervening processes. Where the process looks like the following: original IMAP account --> Custom Script accessing via IMAP --> (intervening steps) --> dbmail. Maybe, I should just be downloading the email from the remote IMAP server and saving/inserting the messages via IMAP to the dbmail users mailbox. Experience with any method suggested above or informed discussion (pro or con) of other solutions is greatly appreciated. Thank you in advance for your time and consideration. -- View this message in context: http://www.nabble.com/Pipe-to-DBMAIL-SMTP-tp25530183p25530183.html Sent from the dbmail users mailing list archive at Nabble.com. _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
