Check out the DBI module for perl on cpan.org. Perhaps there's a Mail
module too. In fact, I'm sure there's a Mail module.
example
=======
# use module
use DBI;
# connect to mysql database
my $dbh = DBI->connect("DBI:mysql:tablename:localhost", "user",
"passwd");
# make query and execute it
$table_data = $dbh->prepare("select * from tablename");
$table_data->execute;
# disconnect from database
$dbh->disconnect();
On Fri, 4 Aug 2000, Andrei Gologan wrote:
Hi,
What I need to do is a litle bit hard (at least for me).
I need a system in which a user (1) sends an e-mail to a predefined e-mail
adress (2) , then it should get forwarded to another e-mail adress (robot)
(3) , that answers to the e-mail adress (2), and that sends the answerd
e-mail back to user (1)
The user should see only the answer from adress (2)
I allready got an answer like:
to install a procmail script as (2) recipient.
The script should:
* If the mail is not from (3) then store msgid->sender_address
mapping in local database [e.g. hash database as used by sendmail
- perl modules are available] and forward to (3)
* If the mail is from (3) then get msgid of the email the robot
replied to (last msgid in References: header), from local database
get (1) address, remove any headers which may give
away (3) address, send message
Thr Problem is : I donīt know how to write to database. I allready read
procmail.org, sendmail.org perl.com but I canīt get a start.
Does anybody have an idea ? Or a different solution ?
Thank you
Andrei Gologan
_______________________________________________
procmail mailing list
procmail(_at_)lists(_dot_)RWTH-Aachen(_dot_)DE
http://MailMan.RWTH-Aachen.DE/mailman/listinfo/procmail
_______________________________________________
procmail mailing list
procmail(_at_)lists(_dot_)RWTH-Aachen(_dot_)DE
http://MailMan.RWTH-Aachen.DE/mailman/listinfo/procmail