Multi layer help.

[Anon]

My ordeal is lengthy, any solutions from you guys would really help.

If I were to recieve an email event to a solaris server, and the solaris server auto parses the data into a database, then I want to take that data, from a database, and spit it into an email in a template, then have the server automatically send the email.

So the steps are:

Email comes in through SNMP, its parsed to a SQL database, then I want it to automatically grab the data from the database, put it into a template email, and send it out.

Any ideas?

[Anon]

(I think you mean SMTP, or "Simple Mail Transfer Protocol", instead of SNMP, or "Simple Network Management Protocol")

The first half is easy (stuffing into the database). Use a sendmail directive to redirect all email to the given address to a processing script that dumps the stuff into the DB.

The second half (grabbing from DB and remailing it) culd be done with a cron job that runs every 1/2 hour.

But, why database it? Why not just re-template the email on the fly and remail immediately?

-Ben

[Anon]

That sounds good, but how would I implement it? Also, the data would need to be stored in a database to run reports.