Has anyone tried Xmail?
curtis
On Sat, 8 Mar 2003, Blake wrote:
> The stock qmail has no database interaction capability what so ever, none.
> Luckily it's split up into a lot of small parts, so it's not hard to add on
> to.
> I have seen a modified version qmail-smtpd that will access an LDAP database,
> but that's not quite what you want either.
>
> I've got a simple idea, I don't think it's terribly efficient, but it should
> do
> the job. Here's what the supervise run script for my external smtp server
> looks
> like now:
>
> [EMAIL PROTECTED]:~$ cat /service/smtp_inet/run
> #!/bin/sh
> PATH="/usr/local/qmail/bin:/usr/local/ucspi-tcp/bin:/usr/local/bin:$PATH"
> export PATH
> QMAILQUEUE=/service/smtp_inet/filter
> export QMAILQUEUE
> exec 2>&1 \
> envuidgid qmaild \
> softlimit -d250000 \
> tcpserver -vUDRHl `uname -n`.`dnsdomainname` -x tcp.cdb -- 66.92.8.243 25 \
> rblsmtpd -b \
> -r relays.ordb.org \
> -r list.dsbl.org \
> -r relays.osirusoft.com \
> qmail-smtpd
>
> If the environment variable RELAYCLIENT is set when qmail-smtpd is executed,
> it
> will allow that client to send outgoing email. I purpose to insert a program
> between tcpserver and qmail-smtpd to modify the environment based on the
> database. Here's what that would look like:
>
> [EMAIL PROTECTED]:~$ cat /service/smtp_inet/run.pbsmtp
> #!/bin/sh
> PATH="/usr/local/qmail/bin:/usr/local/ucspi-tcp/bin:/usr/local/bin:$PATH"
> export PATH
> QMAILQUEUE=/service/smtp_inet/filter
> export QMAILQUEUE
> exec 2>&1 \
> envuidgid qmaild \
> softlimit -d250000 \
> tcpserver -vUDRHl `uname -n`.`dnsdomainname` -x tcp.cdb -- 66.92.8.243 25 \
> rblsmtpd -b \
> -r relays.ordb.org \
> -r list.dsbl.org \
> -r relays.osirusoft.com \
> /path/to/dbmail-qmail-pbsmtp \
> qmail-smtpd
>
> Here's an example dbmail-qmail-pbsmtp that I hacked up in perl right quick.
> It
> should work, but by no means is it ready for production, I haven't even
> tested it!
>
> [EMAIL PROTECTED]:~$ cat dbmail-qmail-pbsmtp
> #!/usr/bin/perl -w
> use strict;
> use warnings;
> use DBI;
> # connect to the dbmail db
> my $dbh = DBI->connect('db', 'user', 'passwd', {RaiseError => 1})
> or die $DBI::errstr;
> # tcpserver passes in the remote IP via the environment.
> # this select statement assumes a table named 'pbsmtp'
> # with a single column 'ip' containing all the valid IPs
> # which are allowed to relay, in dotted decimal format
> my($pbsmtp, @junk) = $dbh->selectrow_array(
> "select count(*) from pbsmtp where ip = '$ENV{TCPREMOTEIP}'"
> );
> # (un)set RELAYCLIENT in the environment as appropriate
> if($pbsmtp) {
> $ENV{RELAYCLIENT} = "";
> } else {
> delete $ENV{RELAYCLIENT};
> }
> # exec the next program in the chain...
> exec @ARGV;
>
> That should do it, but again I would like to stress that this code has NEVER
> BEEN TESTED, and if you use it in a production system it, is likely to error
> out
> at an inopportune time and cause you to LOSE EMAIL.
>
> Hope this helps,
> Blake
>
> [EMAIL PROTECTED] wrote:
> > Hi all!!
> >
> > I need install smtp-auth or pop before smtp but i dont's found nothing to
> > this in my configuration (qmail + dbmail + postgresql)
> >
> > I found in the list one person to have a "checkpassword" work with qmail +
> > dbmail but the direction he's indicate it's down (
> > http://www.squeakerbill.com/dbmail/ )
> >
> > On the other hand, i try to create in my postgresql, how indicate in
> > manual, a table caled pbsp, and i put "yes" in the /etc/dbmail.conf,
> > hoping that dbmail-pop3d or dbmail-imap add to this table "IP" for the
> > last consult of user's, but nothing..
> >
> > Anyboy work dbmail + qmail + postgresl, or some light about this???
> >
> > thank's for all...
> >
>
> _______________________________________________
> Dbmail mailing list
> Dbmail@dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
--
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
