sqllog - Autoresponder - Forwarding

Roland Reimann

unread,

Dec 1, 2002, 12:23:37 PM12/1/02

to

Hi at all!

I惴 now proudly running Postfix with Cyrus SASL2, Cyrus IMAP, MySQL,
Web-Cyradm and pam_mysql.

Everything works fine with SMTP_AUTH.

Thx a lot to all people here who helped me very well. For future I惻l be
able to help a little for others with same problems.

A few questions are open.

1.) sqllog

A few lines of my /var/adm/auth.log

Nov 30 16:28:41 kl saslauthd[22626]: sqlLog called.
Nov 30 16:28:41 kl saslauthd[22626]: pam_mysql: error: sqllog set but
logtable not set
Nov 30 16:28:41 kl saslauthd[22626]: pam_mysql: error: sqllog set but
logmsgcolumn not set
Nov 30 16:28:41 kl saslauthd[22626]: pam_mysql: error: sqllog set but
logusercolumn not set
Nov 30 16:28:41 kl saslauthd[22626]: pam_mysql: error: sqllog set but
loghostcolumn not set
Nov 30 16:28:41 kl saslauthd[22626]: pam_mysql: error: sqllog set but
logtimecolumn not set

It works, but logging were nice to have. Any ideas for realisation? I扉e
googled but nothing found that helps a little bit.

2.) Holiday messages

Is it possible to realize a Holiday-message or auto-responder? With my
config?

3.) Forwarding

Is there any possibility to forward accounts with my config?

4.) X-Info

How is a X-Info possible for Postfix?

Thx a lot for suggestions!

Roland

Gimbert Mario

unread,

Dec 2, 2002, 3:30:44 AM12/2/02

to

> -----Original Message-----
> From: owner-pos...@postfix.org
> [mailto:owner-pos...@postfix.org]On Behalf Of Roland Reimann
> Sent: Sunday, December 01, 2002 6:29 PM
> To: postfi...@postfix.org
> Subject: sqllog - Autoresponder - Forwarding - X-Info
>
>I惴 now proudly running Postfix with Cyrus SASL2, Cyrus IMAP, MySQL,
>Web-Cyradm and pam_mysql.

> 2.) Holiday messages

>
> Is it possible to realize a Holiday-message or auto-responder? With my
> config?

i don愒 run cyrus but our config for autoresponder looks like this
we have the following config:
if you cannot adopt my solution 1 to 1 it may at least give you a hint....

transport table:
+----+---------------------+--------------+
| id | domain | transport |
+----+---------------------+--------------+
| 8 | autoreply.domain.de | autoreply |
+----+---------------------+--------------+

master.cf:
autoreply unix - n n - - pipe flags=F
use
r=nobody argv=/usr/local/bin/autoresponder.pl ${sender} ${recipient}

/usr/local/bin/autoresponder.pl:
--begin script--
#!/usr/bin/perl
($sender, $recipient) = @ARGV;

$SENDMAIL = "/usr/local/sbin/sendmail";

#db schmick
$db_name = "xxx";
$db_host = "xxx";
$db_user = "xxx";
$db_pass = "xxx";

$dsn = "dbi:mysql:dbname=$db_name;host=$db_host";

open DEBUG, ">> /tmp/autoreply";

use DBI;
$db = DBI->connect($dsn, $db_user, $db_pass) || die "DB connect failed";

$sth = $db->prepare("SELECT virtual,autoreplymsg FROM virtual WHERE local =
'$recipient'");
$sth->execute();
($virtual, $autoreplymsg) = $sth->fetchrow_array;

## do not reply to mailing lists.....
if
($sender=~/^(?i)owner-.*|^(?i)newsletter.*|(?i)listserver.*|^(?i)mailerdaemo
n.*|^(?i)maile
r-daemon.*/){
exit 0;
}else{
open(MAIL, "|$SENDMAIL -f '' -t") || die "Cannot execute $SENDMAIL: $!\n";
print MAIL <<EOF;
From: MAILER-DAEMON (Automatic reply service)
To: $sender
Subject: $virtual is away from the mail

$autoreplymsg

EOF

close MAIL || die "$SENDMAIL failed: $!\n";
exit 0;
};
---end script----

hth, mario

Tornoci Laszlo

unread,

Dec 2, 2002, 8:16:09 AM12/2/02

to

On Sun, 1 Dec 2002, Roland Reimann wrote:

Hi,

> I´m now proudly running Postfix with Cyrus SASL2, Cyrus IMAP, MySQL,
> Web-Cyradm and pam_mysql.
>

> A few questions are open.
>

> 2.) Holiday messages
> Is it possible to realize a Holiday-message or auto-responder? With my
> config?

You could use the sieve filter that comes with Cyrus imapd, it
has a vacation extension (see http://www.cyrusoft.com/sieve/).
A few of the mail clients have direct support for sieve, otherwise
you need to write a web interface to enable your users to upload
their sieve scripts.

Or you can use procmail to deliver your messages. Once you have procmail,
you can do pretty much anything, including using vacation scripts. Two
reasons not to use procmail: it may cause security problems to allow your
users to upload any procmail rule, and it is said to use a lot of resources.
Sieve doesn't have these problems, but it has its drawbacks too: it is a
lot less popular, there is little documentation available for it, and you
cannot have systemwide scripts with it.

> 3.) Forwarding
>
> Is there any possibility to forward accounts with my config?

Yes. You could use sieve, or more simply use a mysql table for your
postfix alias maps. This could be updated by a web form.
Examples:
login_name -> other_name will forward all mail to user other_name
login_name -> ot...@other.domain will forward all mail to an external
account
login_name -> oth...@other.domain1, oth...@other.domain2 will do that
to two external mailboxes
If you include login_name in the list on the right side, you can have
both local delivery and forwarding.

Yours: Laszlo
--

----------------------------------------------------------------------
Laszlo L Tornoci Inst Pathophysiology
E-mail: tor...@xenia.sote.hu Semmelweis Univ Med School
tor...@net.sote.hu Nagyvarad ter 4.
fax: (36-1)-210-4409 Budapest, H-1089, Hungary
----------------------------------------------------------------------