[Mimedefang] PHP and Releasing a message

[Kevin A. McGrail]

Gord,

You have a mysql database and a PHP script.  You should not be using
sendmail or cat but rather something like:

$dbhost = "localhost";
$dbuser = "imauser";
$dbpass = "imapassword";
$dbname = "md_quarantine";

$link = mysql_connect("$dbhost", "$dbuser", "$dbpass")
        or die ("Could not connect");
mysql_select_db ("$dbname")
        or die ("Could not select database");

$cmd = "select * from emails where email_id = <some variable you are taking
care of'";

$result = mysql_query($cmd);

while($row=mysql_fetch_array($result)) {
  mail($row[email_address], $row[email_subject], $row[email_body]);
}

Depending on how you are storing the data in the database, you might need to
rebuild a mime-email (beyond me in php), etc. but this should be some
framework to get started.

KAM

----- Original Message ----- 
From: <gord at linvwin.com>
To: <MIMEDefang at lists.roaringpenguin.com>
Sent: Monday, January 12, 2004 5:16 PM
Subject: [Mimedefang] PHP and Releasing a message


> Hello,
>
> This is my first post on this list.
>
> At my work place we have dumped all quarantined emails to a mysql
database.
>
> A little background is that our Mail server is just an email gateway and
> hands off messages to the internal mail server.
>
> We are attempting to release the messages fromt he web interface but are
> having problems witht he command. Every time we try it trys to send it to
> localhost and not to the internal mail server. Anyone tried to build a
> 'release of quarantined emails' script?
>
> I tried the 'sendmail -f `cat SENDER` `cat RECIPIENTS` < ENTIRE_MESSAGE'
>
> Thanks,
>
> Gord
>
>
>
>
> _______________________________________________
> Visit http://www.mimedefang.org and http://www.canit.ca
> MIMEDefang mailing list
> MIMEDefang at lists.roaringpenguin.com
> http://lists.roaringpenguin.com/mailman/listinfo/mimedefang
>