[pfx] Re: Postfix "sendmail -bv" command: Trouble with spamassassin and virtual_aliases

2023-07-10 Thread Robert Senger via Postfix-users
Am Montag, dem 10.07.2023 um 09:39 -0400 schrieb Viktor Dukhovni via Postfix-users: > On Mon, Jul 10, 2023 at 03:24:54PM +0200, Robert Senger wrote: > > > Hey, that was me! My full given name *is* Robert'); DROP ... > > > > CONFDIR=/etc/postfix > > POSTMAP=/usr/sbin/postmap > >

[pfx] Re: Postfix "sendmail -bv" command: Trouble with spamassassin and virtual_aliases

2023-07-10 Thread Viktor Dukhovni via Postfix-users
On Mon, Jul 10, 2023 at 03:24:54PM +0200, Robert Senger wrote: > Hey, that was me! My full given name *is* Robert'); DROP ... > > CONFDIR=/etc/postfix > POSTMAP=/usr/sbin/postmap > LOCAL_VIRTUAL_USERS=mysql:${CONFDIR}/virtual_mailboxes.mysql.cf > > recipient=$(printf '%s' "$2" | sed

[pfx] Re: Postfix "sendmail -bv" command: Trouble with spamassassin and virtual_aliases

2023-07-10 Thread Robert Senger via Postfix-users
Am Montag, dem 10.07.2023 um 08:52 -0400 schrieb Viktor Dukhovni via Postfix-users: > > On 10 Jul 2023, at 5:50 am, Matus UHLAR - fantomas via Postfix- > > users wrote: > > > > > > #!/bin/bash > > > > user=`echo "$2" | sed 's/[<>]//g'` > > > > ret=`echo "select destination from virtual_aliases

[pfx] Re: Postfix "sendmail -bv" command: Trouble with spamassassin and virtual_aliases

2023-07-10 Thread Viktor Dukhovni via Postfix-users
> On 10 Jul 2023, at 5:50 am, Matus UHLAR - fantomas via Postfix-users > wrote: > >>> #!/bin/bash >>> user=`echo "$2" | sed 's/[<>]//g'` >>> ret=`echo "select destination from virtual_aliases where >>> source=\"$user\";" | /usr/bin/mysql -upostfix -psecretpassword >>> mailserver | tail -n 1`

[pfx] Re: Postfix "sendmail -bv" command: Trouble with spamassassin and virtual_aliases

2023-07-10 Thread Matus UHLAR - fantomas via Postfix-users
On 10.07.23 01:17, Robert Senger via Postfix-users wrote: Thanks to all of you for your tips and advices! This turned out to be far more complicated than I thought... I am staying with spamass-milter and bash scripting for the moment (but implemented all of your programming advices), it's a

[pfx] Re: Postfix "sendmail -bv" command: Trouble with spamassassin and virtual_aliases

2023-07-09 Thread Robert Senger via Postfix-users
Thanks to all of you for your tips and advices! This turned out to be far more complicated than I thought... I am staying with spamass-milter and bash scripting for the moment (but implemented all of your programming advices), it's a testing environment only. I'll have a look at amavis as well

[pfx] Re: Postfix "sendmail -bv" command: Trouble with spamassassin and virtual_aliases

2023-06-30 Thread Matus UHLAR - fantomas via Postfix-users
On Thu, Jun 29, 2023 at 05:21:32PM +0200, Robert Senger via Postfix-users wrote: Of course, I could write my own "sendmail" script which takes the virtual_alias, I was thinking about the same, just utilising postconf and postmap... On 29.06.23 12:02, Viktor Dukhovni via Postfix-users wrote:

[pfx] Re: Postfix "sendmail -bv" command: Trouble with spamassassin and virtual_aliases

2023-06-29 Thread Benny Pedersen via Postfix-users
Robert Senger via Postfix-users skrev den 2023-06-29 17:21: ... The point is that spamassassin needs to know the username when processing an email, to update the correct bayes database. The username given to spamassassin by spamass-milter is the email address of the recipient. This is fine, as

[pfx] Re: Postfix "sendmail -bv" command: Trouble with spamassassin and virtual_aliases

2023-06-29 Thread Wietse Venema via Postfix-users
Robert Senger via Postfix-users: > Hi all! > > I am running Postfix 3.4.23 on Debian 10.13 Buster, with SpamAssassin > 4.0.0 and spamass-milter 0.4.0-2 for spam detection. > > Until now, SpamAssassin was configured to use system wide bayes > database for the bayesian classifier, which is trained

[pfx] Re: Postfix "sendmail -bv" command: Trouble with spamassassin and virtual_aliases

2023-06-29 Thread Viktor Dukhovni via Postfix-users
On Thu, Jun 29, 2023 at 05:21:32PM +0200, Robert Senger via Postfix-users wrote: > Of course, I could write my own "sendmail" script which takes the > virtual_alias, This is possible with care, but not ideal, better would be to find some way to get the milter to make the relevant queries