wasanzy
October 30th, 2010, 12:04 PM
Hi,
There is this project I am about to work on. The whole picture of the project is that, we have a mail server (qmail) and a ticketing system(kayako) and an mssql database that contains clintes and other information.
Now what I want to do is, write a perl script that will querry the mssql database to check if the email coming is from a client or not. procmail I will configure to make this script run base on the email header. If the email is going to support@ourdomain.com, the the script is going to run. When the user exist in the database, the script wil have to rewrite the subject hearder of the email and add the account manager of the client's code in the database to it and report to procmail where procmail will take it over from there.
Please who have an idea on how I can start this? I have already connected from the qmal to the mssql database uging DBI and odbc.
Thank you.
There is this project I am about to work on. The whole picture of the project is that, we have a mail server (qmail) and a ticketing system(kayako) and an mssql database that contains clintes and other information.
Now what I want to do is, write a perl script that will querry the mssql database to check if the email coming is from a client or not. procmail I will configure to make this script run base on the email header. If the email is going to support@ourdomain.com, the the script is going to run. When the user exist in the database, the script wil have to rewrite the subject hearder of the email and add the account manager of the client's code in the database to it and report to procmail where procmail will take it over from there.
Please who have an idea on how I can start this? I have already connected from the qmal to the mssql database uging DBI and odbc.
Thank you.