Re: database driven mail server
Pretty nice idea indeed; I'll give a try. Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356699 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
database driven mail server
Hi, I'm presently using MailEnable on my server. It's a good program, but I need to build a system to follow up messages. My customers (associations) send messages to their members and some messages do not go through for many reasons. They need to have confirmations and reasons of failures. The problem with Mail Enable is that the logs are a real mess and very complicated to parse. I would need a program that generates more comprehensive logs in a database I could read more easily. Any suggestion? Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356683 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: database driven mail server
Claude, I was thinking that @mail (or atmail?) has MySQL based logs - but I could be mistaken. The data is definitely stored in mysql however. There may be a plugin for Zimbra that handles logs via ODBC. 2 cents - make sure you tell your users that the information they are looking for is heavily dependent on the downstream servers and largely out of your control :) I'm sure you have. -Mark Mark Kruger - CFG CF Webtools www.cfwebtools.com www.coldfusionmuse.com O: 402.932.3318 E: mkru...@cfwebtools.com Skype: markakruger -Original Message- From: Claude Schnéegans schneeg...@internetique.com [mailto:=?ISO-8859-1?Q?Claude_Schn=E9egans schneegans@interneti=71?= =?ISO-8859-1?Q?ue.com=3E?=] Sent: Monday, September 02, 2013 8:34 AM To: cf-talk Subject: database driven mail server Hi, I'm presently using MailEnable on my server. It's a good program, but I need to build a system to follow up messages. My customers (associations) send messages to their members and some messages do not go through for many reasons. They need to have confirmations and reasons of failures. The problem with Mail Enable is that the logs are a real mess and very complicated to parse. I would need a program that generates more comprehensive logs in a database I could read more easily. Any suggestion? Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356684 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: database driven mail server
If you are looking to not reinvent the wheel... For our marketing messages, we use Marketo. Their reporting has stuff like bounce, open rates and some other details. I don't believe Marketo has an smtp relay, you basically maintain email lists in their console and render messages from there. Also nice in that they handle unsubscribes. Sendgrid is more a pure smtp relay, but I believe they have more detailed reporting on bounce rates, and etc. They have an api for integrations. We have recently started to refer some customers there, who require reliable messaging in bulk. Aka, non spam spammers, whom get our mail servers blacklisted. Byron Mann Lead Engineer Architect HostMySite.com On Sep 2, 2013 9:34 AM, wrote: Hi, I'm presently using MailEnable on my server. It's a good program, but I need to build a system to follow up messages. My customers (associations) send messages to their members and some messages do not go through for many reasons. They need to have confirmations and reasons of failures. The problem with Mail Enable is that the logs are a real mess and very complicated to parse. I would need a program that generates more comprehensive logs in a database I could read more easily. Any suggestion? Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356685 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: database driven mail server
Claude, it rather depends what else you want out of the mail server. If you just want better reporting for SMTP to track bounces, rejections, failures etc, then you only need to change the SMTP server and you could keep MailEnable for incoming mail if you are happy with it. I have used HmailServer for SMTP many times and it does have good logging and you can use MSSQL or MYSQL for storage too, it is also FREE. It is an OK basic pop/IMAP server too, but the anti-spam is basic content filtering, DNSBL etc, there is no Bayesian engine , so you need to setup an external solution if you want high grade anti-spam, so it depends if this extra work is worth it for you compared to paying for a commercial solution with built in anti-spam. SmarterMail is also a very good and robust solution, and again if you were only going to use this for SMTP then it would be FREE, you may also prefer it to MailEnable overall. On Mon, Sep 2, 2013 at 2:33 PM, wrote: Hi, I'm presently using MailEnable on my server. It's a good program, but I need to build a system to follow up messages. My customers (associations) send messages to their members and some messages do not go through for many reasons. They need to have confirmations and reasons of failures. The problem with Mail Enable is that the logs are a real mess and very complicated to parse. I would need a program that generates more comprehensive logs in a database I could read more easily. Any suggestion? Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356686 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: database driven mail server
For our marketing messages, we use Marketo. We don't send marketing messages and I'm not looking for a third party solution. We offer a complete Content management and email system, with SMTP and POP servers. I want to be able to control both of them more precisely. When I get a call like I've send messages and one of our members did not get the message. I want to be able to tell the user if and when the message was sent by my server, and is it was refused by the other server, why. Presently, with MailEnable, I have to gather information in huge log files. What I need is a more comprehensive logging system, preferabily in a database system. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356687 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: database driven mail server
We parse bounces and returns using Boogie Tools and love it. http://www.boogietools.com/ Craig From: Russ Michaels r...@michaels.me.uk Sent: Monday, September 02, 2013 9:45 AM To: cf-talk cf-talk@houseoffusion.com Subject: Re: database driven mail server Claude, it rather depends what else you want out of the mail server. If you just want better reporting for SMTP to track bounces, rejections, failures etc, then you only need to change the SMTP server and you could keep MailEnable for incoming mail if you are happy with it. I have used HmailServer for SMTP many times and it does have good logging and you can use MSSQL or MYSQL for storage too, it is also FREE. It is an OK basic pop/IMAP server too, but the anti-spam is basic content filtering, DNSBL etc, there is no Bayesian engine , so you need to setup an external solution if you want high grade anti-spam, so it depends if this extra work is worth it for you compared to paying for a commercial solution with built in anti-spam. SmarterMail is also a very good and robust solution, and again if you were only going to use this for SMTP then it would be FREE, you may also prefer it to MailEnable overall. On Mon, Sep 2, 2013 at 2:33 PM, wrote: Hi, I'm presently using MailEnable on my server. It's a good program, but I need to build a system to follow up messages. My customers (associations) send messages to their members and some messages do not go through for many reasons. They need to have confirmations and reasons of failures. The problem with Mail Enable is that the logs are a real mess and very complicated to parse. I would need a program that generates more comprehensive logs in a database I could read more easily. Any suggestion? Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356688 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: database driven mail server
If you just want better reporting for SMTP to track bounces, rejections, failures etc, Yes, this is mostly what I'm looking for. but the anti-spam is basic content filtering, DNSBL etc, there is no Bayesian engine , Anti-spam is not a problem, I'm fondamentally opposed to anti-spam systems on the server. My users are aware that if they want their messages to be filtered by an anti-spam system they will have to use one on their client email reader, ie: Thunderbird,... Thanks for your suggestions, I will have a look. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356689 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: database driven mail server
I rolled my own solution with CF coupled to Smartermail's support of Plus-addressing. If you aren't familar with it, its pretty powerful. Lets say my email is u...@domain.com. I send mail with CF as usual and set CFMAIL's FailTo parameter to 'failedmail+1...@domain.com', where 1234 is the primary key ID number for the user record. So bounces come back and plus addressing puts every failure into failedm...@domain.com. I use CFPOP with GETHEADERSONLY (!) to read that mailbox periodically and parse thru returned emails, figuring out what happened from the headers and doing stuff accordingly. Sound like what you're after? A quick snippet to illustrate the maintenance process (which I cfschedule): cfpop server=#servername# username=#failUser# password=#failPwd# action=GETHEADERONLY name=GetHeaders cfloop query=getHeaders !--- this header identifies the email --- cfset variables.emailID=getHeaders.UID !--- this pulls out the user ID from the return address. Note if the email itself is stored in a db then this next step is unnecessary and so is plus addressing as you could just log the user id with the email record --- cfset variables.usrID=listLast(listFirst(getHeaders.to,@),+) !--- run tests here, as detailed as you like. For example I keep track of failure counts and scrub emails from my list if they reach three strikes. --- cfif findNoCase(fail,getHeaders.subject,1) blah /cfif cfif findNoCase(error,getHeaders.subject,1) woof /cfif !--- do more clever stuff here as needed. Then delete the failed email from the inbox and continue. --- cfpop server=#servername# username=#failUser# password=#failPwd# action=DELETE uid=#variables.emailID# /cfloop -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356692 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: database driven mail server
Matt, That's pretty nifty. I use a number of the API features of smarter mail integrated into my company management/hours/tasks system. It's definitely a great platform and worth a look. -mark -Original Message- From: Money Pit [mailto:websitema...@gmail.com] Sent: Monday, September 02, 2013 5:53 PM To: cf-talk Subject: Re: database driven mail server I rolled my own solution with CF coupled to Smartermail's support of Plus-addressing. If you aren't familar with it, its pretty powerful. Lets say my email is u...@domain.com. I send mail with CF as usual and set CFMAIL's FailTo parameter to 'failedmail+1...@domain.com', where 1234 is the primary key ID number for the user record. So bounces come back and plus addressing puts every failure into failedm...@domain.com. I use CFPOP with GETHEADERSONLY (!) to read that mailbox periodically and parse thru returned emails, figuring out what happened from the headers and doing stuff accordingly. Sound like what you're after? A quick snippet to illustrate the maintenance process (which I cfschedule): cfpop server=#servername# username=#failUser# password=#failPwd# action=GETHEADERONLY name=GetHeaders cfloop query=getHeaders !--- this header identifies the email --- cfset variables.emailID=getHeaders.UID !--- this pulls out the user ID from the return address. Note if the email itself is stored in a db then this next step is unnecessary and so is plus addressing as you could just log the user id with the email record --- cfset variables.usrID=listLast(listFirst(getHeaders.to,@),+) !--- run tests here, as detailed as you like. For example I keep track of failure counts and scrub emails from my list if they reach three strikes. --- cfif findNoCase(fail,getHeaders.subject,1) blah /cfif cfif findNoCase(error,getHeaders.subject,1) woof /cfif !--- do more clever stuff here as needed. Then delete the failed email from the inbox and continue. --- cfpop server=#servername# username=#failUser# password=#failPwd# action=DELETE uid=#variables.emailID# /cfloop -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356693 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: database driven mail server
And there is already a cf wrapper for smartermail api too Russ Michaels www.michaels.me.uk cfmldeveloper.com cflive.net cfsearch.com On 3 Sep 2013 02:25, Mark A Kruger mkru...@cfwebtools.com wrote: Matt, That's pretty nifty. I use a number of the API features of smarter mail integrated into my company management/hours/tasks system. It's definitely a great platform and worth a look. -mark -Original Message- From: Money Pit [mailto:websitema...@gmail.com] Sent: Monday, September 02, 2013 5:53 PM To: cf-talk Subject: Re: database driven mail server I rolled my own solution with CF coupled to Smartermail's support of Plus-addressing. If you aren't familar with it, its pretty powerful. Lets say my email is u...@domain.com. I send mail with CF as usual and set CFMAIL's FailTo parameter to 'failedmail+1...@domain.com', where 1234 is the primary key ID number for the user record. So bounces come back and plus addressing puts every failure into failedm...@domain.com. I use CFPOP with GETHEADERSONLY (!) to read that mailbox periodically and parse thru returned emails, figuring out what happened from the headers and doing stuff accordingly. Sound like what you're after? A quick snippet to illustrate the maintenance process (which I cfschedule): cfpop server=#servername# username=#failUser# password=#failPwd# action=GETHEADERONLY name=GetHeaders cfloop query=getHeaders !--- this header identifies the email --- cfset variables.emailID=getHeaders.UID !--- this pulls out the user ID from the return address. Note if the email itself is stored in a db then this next step is unnecessary and so is plus addressing as you could just log the user id with the email record --- cfset variables.usrID=listLast(listFirst(getHeaders.to,@),+) !--- run tests here, as detailed as you like. For example I keep track of failure counts and scrub emails from my list if they reach three strikes. --- cfif findNoCase(fail,getHeaders.subject,1) blah /cfif cfif findNoCase(error,getHeaders.subject,1) woof /cfif !--- do more clever stuff here as needed. Then delete the failed email from the inbox and continue. --- cfpop server=#servername# username=#failUser# password=#failPwd# action=DELETE uid=#variables.emailID# /cfloop -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356694 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
