Re: Update sendmail's email result to database

Hi,

I just think another solution,
1. Add the email id into each email's subject.
2. log email's subject into log file, like:
[code]LOCAL_CONFIG
Klog syslog
HSubject: $>;+CheckSubject

LOCAL_RULESETS
SCheckSubject
R$* $: $(log Subject: $1 $) $1[/code]
3. Use logwatch to monitor mail log, update database according to
email id and email address.

Havn't try yet, will update to you after tried.
Please tell me if you have better solution.

Thanks,

Regards,
Cheow Yong



On 9 19 , 5 06 , cyh...@xxxxxxxxx wrote:
Hi,

We will put the email id in all email's content, so that if we read
files in /var/spool/mqueue, we will able to get the email id.

Another solution is, write a program to:
1. read email id from all files in /var/spool/mqueue directory. So
that we get the problem email list and its failed reason.
2. go to /var/log/maillog*, find out the success sent email list.
3. update the status and reason of all problem email list into
database.
4. update the status of all email address in success email list to
success status in database.

This solution assume that if one email have send successfully to
destination, it will always success within some period of time.
Because we only can get the email id from mail queue, we can't get the
email id from /var/log/maillog* files. So that we will update all
email status to success sent at step 4.

Please provide me some advices.

Thanks for your help.

Regards,
Cheow Yong

On 9 19 , 6 33 , cyh...@xxxxxxxxx wrote:

Hi,

Our system auto send out email to customer configured email address.
But we hope to update all outgoing status to database, so that we can
find out any problem happened after email send to sendmail server. For
example we need to know any typo of customer's email address, delay of
email send out, or the mx record failed in DNS query.

At first, I think that we can write a milter program like following:
1. each email content has a email id.
2. the milter program get outgoing status in mlfi_connect() and
mlfi_cleanup() functions.
3. update the result status into database by the email id.

But after some testing, I found that the callback function in milter
program only called when email send INTO sendmail server. It is not
called when email send from sendmail server to other mail server.

I am out of idea now. Please give me some suggestion about how to make
this.

Thanks for your help.

Regards,
Cheow Yong


.

Relevant Pages

  • Re: Update sendmails email result to database
    ... success status in database. ... find out any problem happened after email send to sendmail server. ... I think that we can write a milter program like following: ...
    (comp.mail.sendmail)
  • Re: Import Data succeeds but doesnt copy data?
    ... Looks like you are copying from a database to the SAME ... I mentioned that I copied to a new dB on the destination server ... Configure the TransferProvider with files and Source/Destination ...
    (microsoft.public.sqlserver.tools)
  • Re: DBConcurrencyException on dataset update (because of datetime primary key ?)
    ... I fill a Dataset with data extracted from a table of my database, ... Date/Time field. ... I also tested to fix the OleDbType of parameters, without success. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Selling MV...
    ... I am pleased that you received such a positive response. ... your success and am sure the information you provide is valuable to large IT ... longer care, if they ever did, about the database. ...
    (comp.databases.pick)
  • Update sendmails email result to database
    ... But we hope to update all outgoing status to database, ... find out any problem happened after email send to sendmail server. ... I think that we can write a milter program like following: ...
    (comp.mail.sendmail)