RE: Filter on recipient and subject

2010-01-29 Thread Nick Lunt
-Original Message- From: owner-postfix-us...@postfix.org [mailto:owner-postfix- us...@postfix.org] On Behalf Of DUBOURG Kevin Sent: 28 January 2010 13:38 To: postfix users Subject: Re: Filter on recipient and subject Hello ! Maildrop can routing your email with many regex and

Re: virtual_alias_maps mysql

2010-01-29 Thread Bradley Giesbrecht
On Jan 28, 2010, at 12:35 PM, Serge Fonville wrote: Hi, I using virtual_alias_maps with mysql for storage. Working fine. Does anyone have a suggestion on how to update a timestamp field in the mysql table when postfix finds a virtual_alias_maps match? I'm looking for a way to measure

Re: virtual_alias_maps mysql

2010-01-29 Thread Serge Fonville
On Fri, Jan 29, 2010 at 9:19 AM, Bradley Giesbrecht bradley.giesbre...@gmail.com wrote: On Jan 28, 2010, at 12:35 PM, Serge Fonville wrote: Hi, I using virtual_alias_maps with mysql for storage. Working fine. Does anyone have a suggestion on how to update a timestamp field in the mysql

Re: virtual_alias_maps mysql

2010-01-29 Thread Bradley Giesbrecht
On Jan 29, 2010, at 12:29 AM, Serge Fonville wrote: On Fri, Jan 29, 2010 at 9:19 AM, Bradley Giesbrecht bradley.giesbre...@gmail.com wrote: On Jan 28, 2010, at 12:35 PM, Serge Fonville wrote: Hi, I using virtual_alias_maps with mysql for storage. Working fine. Does anyone have a

sasl map multiple query question

2010-01-29 Thread Robert Schetterer
Hi all, i have a sasl mysql map matching existing users in mysql SELECT username FROM mailbox WHERE username='%s' AND active = 1 this works nice but now i need a query or chain for allowing specific admin users in mysql to allow so i am unsure about the syntax of the or statement i need

From: header correctness

2010-01-29 Thread Ion-Mihai Tetcu
Hi, I've run into a little problem, easily solved, but I'd like to know where the problem actually is. I have a mail that is rejected by the destination server (an exim) with: 1964422C509A 4257 Thu Jan 28 13:51:40 segrete...@cameradicommercio.ro (host mail.intesasanpaolo.ro[80.96.9.11]

Re: Add Header

2010-01-29 Thread Wietse Venema
Ralf Hildebrandt: * Victor Duchovni victor.ducho...@morganstanley.com: On Thu, Jan 28, 2010 at 05:41:03PM -0600, AMP Admin wrote: just in case anyone comes across this I got it sorted with the following: /^Subject: .*/ PREPEND MyString This is still wrong. Because it

RE: virtual_alias_maps mysql

2010-01-29 Thread Rob Sterenborg
I have but was hoping for something simpler like I do with dovecot deliver where you create a script that calls deliver after you do what you want for logging and then name your script in something like deliver_exec = script. Might be wrong with the names but thats more or less what

Re: From: header correctness

2010-01-29 Thread Wietse Venema
Ion-Mihai Tetcu: From: CCIpR: Segreteria segrete...@cameradicommercio.ro That is incorrect syntax. The form label: address, address...; is a named group in RFC5322 syntax. To fix: quote the CCIpR: Segreteria portion (or add a ; at the end, but this could confuse some poorly-written

Re: smtpd processes congregating at the pub

2010-01-29 Thread Wietse Venema
Stan Hoeppner: Based on purely visual non-scientific observation (top), it seems my smtpd processes on my MX hang around much longer in (Debian) 2.5.5 than they did in (Debian) 2.3.8. In 2.3.8 Master seemed to build them and tear them down very Perhaps Debian changed this:

Re: [SASL]: Recipient address rejected: Access denied while SASL/TLS are really enabled

2010-01-29 Thread David Touzeau
Message initial De: Patrick Ben Koetter p...@state-of-mind.de À: postfix-users@postfix.org Sujet: Re: [SASL]: Recipient address rejected: Access denied while SASL/TLS are really enabled Date: Fri, 29 Jan 2010 02:09:53 +0100 * David Touzeau da...@touzeau.eu: Dear I don't

Re: virtual_alias_maps mysql

2010-01-29 Thread Brian Evans - Postfix List
On 1/29/2010 2:41 AM, Serge Fonville wrote: On Thu, Jan 28, 2010 at 10:40 PM, Brian Evans - Postfix List grkni...@scent-team.com wrote: On 1/28/2010 4:12 PM, Serge Fonville wrote: I using virtual_alias_maps with mysql for storage. Working fine. Does anyone have a suggestion on how

Re: virtual_alias_maps mysql

2010-01-29 Thread Serge Fonville
On Fri, Jan 29, 2010 at 2:51 PM, Brian Evans - Postfix List grkni...@scent-team.com wrote: On 1/29/2010 2:41 AM, Serge Fonville wrote: On Thu, Jan 28, 2010 at 10:40 PM, Brian Evans - Postfix List grkni...@scent-team.com wrote: On 1/28/2010 4:12 PM, Serge Fonville wrote: I using

Re: sasl map multiple query question

2010-01-29 Thread Brian Evans - Postfix List
On 1/29/2010 4:41 AM, Robert Schetterer wrote: Hi all, i have a sasl mysql map matching existing users in mysql SELECT username FROM mailbox WHERE username='%s' AND active = 1 this works nice but now i need a query or chain for allowing specific admin users in mysql to allow so i am

Re: [SASL]: Recipient address rejected: Access denied while SASL/TLS are really enabled

2010-01-29 Thread Brian Evans - Postfix List
On 1/29/2010 7:24 AM, David Touzeau wrote: smtpd_tls_auth_only = yes Thanks Patrick for your answer but sasl is correctly installed And testsaslauthd answer OK to authentification test Any others ways ?? to understand this problem ? i don't know why thereis no entry on -- mechanisms

Relay/Deliver depending on full recipient email address?

2010-01-29 Thread Michele Carandente
Hi, I am trying to setup a new postfix server in a location where there is limited internet connectivity. I want local users to send emails to my Postfix server which then relays the emails later on when there is a internet connection (the plan is to put the emails in the hold queue and then

Re: smtpd processes congregating at the pub

2010-01-29 Thread Noel Jones
On 1/29/2010 1:37 AM, Stan Hoeppner wrote: Stan Hoeppner put forth on 1/29/2010 12:27 AM: Based on purely visual non-scientific observation (top), it seems my smtpd processes on my MX hang around much longer in (Debian) 2.5.5 than they did in (Debian) 2.3.8. In 2.3.8 Master seemed to build

Re: sasl map multiple query question

2010-01-29 Thread Robert Schetterer
Am 29.01.2010 14:57, schrieb Brian Evans - Postfix List: On 1/29/2010 4:41 AM, Robert Schetterer wrote: Hi all, i have a sasl mysql map matching existing users in mysql SELECT username FROM mailbox WHERE username='%s' AND active = 1 this works nice but now i need a query or chain for

Re: sasl map multiple query question

2010-01-29 Thread Robert Schetterer
Am 29.01.2010 16:58, schrieb Robert Schetterer: Am 29.01.2010 14:57, schrieb Brian Evans - Postfix List: On 1/29/2010 4:41 AM, Robert Schetterer wrote: Hi all, i have a sasl mysql map matching existing users in mysql SELECT username FROM mailbox WHERE username='%s' AND active = 1 this

Re: sasl map multiple query question

2010-01-29 Thread Brian Evans - Postfix List
On 1/29/2010 11:02 AM, Robert Schetterer wrote: Am 29.01.2010 16:58, schrieb Robert Schetterer: things with union work but , the problem seems to be the double result of equal entries query = SELECT DISTINCT concat('@', domain,' ', username) username FROM domain_admins WHERE

Use transport to re-route a particuliar sender address ?

2010-01-29 Thread Frank Bonnet
Hello Is it possible to use transport ( from the MX ) to redirect a particuliar external sender address ? I mean : if the MX receive an email from t...@domain.tld I want to reroute this email to another account/machine than the internal mailhub. Thanks for any info

Re: sasl map multiple query question

2010-01-29 Thread Robert Schetterer
Am 29.01.2010 17:24, schrieb Brian Evans - Postfix List: On 1/29/2010 11:02 AM, Robert Schetterer wrote: Am 29.01.2010 16:58, schrieb Robert Schetterer: things with union work but , the problem seems to be the double result of equal entries query = SELECT DISTINCT concat('@', domain,'

Re: sasl map multiple query question

2010-01-29 Thread Victor Duchovni
On Fri, Jan 29, 2010 at 05:57:30PM +0100, Robert Schetterer wrote: jep that query works postmap -q rob...@schetterer.org mysql:/etc/postfix/mysql_sasl_login_maps-test.cf @schetterer.org rob...@schetterer.org This is the wrong result format. The value retuned must be a comma separated list

Re: sasl map multiple query question

2010-01-29 Thread Robert Schetterer
Am 29.01.2010 18:12, schrieb Victor Duchovni: On Fri, Jan 29, 2010 at 05:57:30PM +0100, Robert Schetterer wrote: jep that query works postmap -q rob...@schetterer.org mysql:/etc/postfix/mysql_sasl_login_maps-test.cf @schetterer.org rob...@schetterer.org This is the wrong result format.

Re: sasl map multiple query question

2010-01-29 Thread Victor Duchovni
On Fri, Jan 29, 2010 at 06:30:45PM +0100, Robert Schetterer wrote: smtpd_sender_login_maps = hash:/etc/postfix/sasl_senders pico /etc/postfix/sasl_senders @domain.de username which works as desired As documented, in indexed files the first non-whitespace token is the lookup *key*, and

Re: sasl map multiple query question

2010-01-29 Thread Robert Schetterer
Am 29.01.2010 18:36, schrieb Victor Duchovni: On Fri, Jan 29, 2010 at 06:30:45PM +0100, Robert Schetterer wrote: smtpd_sender_login_maps = hash:/etc/postfix/sasl_senders pico /etc/postfix/sasl_senders @domain.de username which works as desired As documented, in indexed files the first

Re: Use transport to re-route a particuliar sender address ?

2010-01-29 Thread adrian ilarion ciobanu
Hello Is it possible to use transport ( from the MX ) to redirect a particuliar external sender address ? I mean : if the MX receive an email from t...@domain.tld I want to reroute this email to another account/machine than the internal mailhub. i'm not sure what an internal

Re: sasl map multiple query question

2010-01-29 Thread Victor Duchovni
On Fri, Jan 29, 2010 at 06:41:48PM +0100, Robert Schetterer wrote: smtpd_sender_login_maps = hash:/etc/postfix/sasl_senders pico /etc/postfix/sasl_senders @domain.de username which works as desired As documented, in indexed files the first non-whitespace token is the lookup

Unknown Recipient Domain

2010-01-29 Thread Dan Lists
When a user mistypes an email address domain (eg @monsant.com), the message is sitting in the queue for days before they know about it. We'd like to give them immediate feedback instead of making them wail. I'm trying to have the outbound mail server permanently reject email with an invalid

Re: [SASL]: Recipient address rejected: Access denied while SASL/TLS are really enabled

2010-01-29 Thread David Touzeau
Many many,many,many thanks Brian By set to no smtpd_tls_auth_only token fix the situation and Postfix ask authentification during the SMTP session ! Case closed :=) Message initial De: Brian Evans - Postfix List grkni...@scent-team.com Reply-to: Postfix users

Re: Unknown Recipient Domain

2010-01-29 Thread Noel Jones
On 1/29/2010 11:57 AM, Dan Lists wrote: When a user mistypes an email address domain (eg @monsant.com), the message is sitting in the queue for days before they know about it. We'd like to give them immediate feedback instead of making them wail. I'm trying to have the outbound mail server

Re: Unknown Recipient Domain

2010-01-29 Thread adrian ilarion ciobanu
On Fri, Jan 29, 2010 at 12:22:53PM -0600, Noel Jones wrote: On 1/29/2010 11:57 AM, Dan Lists wrote: smtpd_recipient_restrictions = reject_non_fqdn_recipient, reject_unknown_recipient_domain, permit_mynetworks, reject_unauth_destination

Re: Unknown Recipient Domain

2010-01-29 Thread adrian ilarion ciobanu
atleast in postfix stable, specifying unknown_address_reject_code=550 works no matter if servfail or nx. maybe 2.7 makes now distinctions between different dns error replies? it doesn't. my bad Don't confuse temporary errors (you don't know if the domain exists or

Re: sasl map multiple query question

2010-01-29 Thread Robert Schetterer
Am 29.01.2010 18:49, schrieb Victor Duchovni: On Fri, Jan 29, 2010 at 06:41:48PM +0100, Robert Schetterer wrote: smtpd_sender_login_maps = hash:/etc/postfix/sasl_senders pico /etc/postfix/sasl_senders @domain.de username which works as desired As documented, in indexed files the first

Re: Unknown Recipient Domain

2010-01-29 Thread Dan Lists
On Fri, Jan 29, 2010 at 12:22 PM, Noel Jones njo...@megan.vbhcs.org wrote: On 1/29/2010 11:57 AM, Dan Lists wrote: When a user mistypes an email address domain (eg @monsant.com), the message is sitting in the queue for days before they know about it. We'd like to give them immediate feedback

Re: Unknown Recipient Domain

2010-01-29 Thread Noel Jones
On 1/29/2010 12:42 PM, Dan Lists wrote: On Fri, Jan 29, 2010 at 12:22 PM, Noel Jonesnjo...@megan.vbhcs.org wrote: $ host monsant.com Host monsant.com not found: 2(SERVFAIL) This is a temporary error. The name server for monsant.com could not be contacted. You don't know if the domain exists

Re: Unknown Recipient Domain

2010-01-29 Thread Wietse Venema
Dan Lists: [ Charset ISO-8859-1 unsupported, converting... ] $ host monsant.com Host monsant.com not found: 2(SERVFAIL) This is a temporary error. The name server for monsant.com could not be contacted. ?You don't know if the domain exists or not. ?whois shows this domain does exist,

Re: Unknown Recipient Domain

2010-01-29 Thread Dan Lists
On Fri, Jan 29, 2010 at 1:17 PM, Wietse Venema wie...@porcupine.org wrote: Dan Lists: [ Charset ISO-8859-1 unsupported, converting... ] $ host monsant.com Host monsant.com not found: 2(SERVFAIL) This is a temporary error. The name server for monsant.com could not be contacted. ?You

Re: Unknown Recipient Domain

2010-01-29 Thread Wietse Venema
Dan Lists: On Fri, Jan 29, 2010 at 1:17 PM, Wietse Venema wie...@porcupine.org wrote: Dan Lists: $ host monsant.com Host monsant.com not found: 2(SERVFAIL) This is a temporary error. The name server for monsant.com could not be contacted. ?You don't know if the domain exists or

Re: sasl map multiple query question fixed

2010-01-29 Thread Robert Schetterer
Am 29.01.2010 19:37, schrieb Robert Schetterer: Am 29.01.2010 18:49, schrieb Victor Duchovni: On Fri, Jan 29, 2010 at 06:41:48PM +0100, Robert Schetterer wrote: smtpd_sender_login_maps = hash:/etc/postfix/sasl_senders pico /etc/postfix/sasl_senders @domain.de username which works as

Re: sasl map multiple query question fixed

2010-01-29 Thread Victor Duchovni
On Fri, Jan 29, 2010 at 11:06:51PM +0100, Robert Schetterer wrote: this works query = SELECT username FROM domain_admins WHERE domain='%d' UNION SELECT username FROM mailbox WHERE username='%s' AND active = 1 Yes, a user can send mail as himself, and a domain admin can send email as

Re: relay help

2010-01-29 Thread Wade Smart
Noel Jones wrote: On 1/28/2010 4:57 PM, Wade Smart wrote: I have been using postfix for about two + years but something that was just out of my understanding at the time was setting up relaying. Right now I just sent from my mail client (thunderbird) but I would like to be able to send back

Re: sasl map multiple query question fixed

2010-01-29 Thread Robert Schetterer
Am 29.01.2010 23:13, schrieb Victor Duchovni: On Fri, Jan 29, 2010 at 11:06:51PM +0100, Robert Schetterer wrote: this works query = SELECT username FROM domain_admins WHERE domain='%d' UNION SELECT username FROM mailbox WHERE username='%s' AND active = 1 Yes, a user can send mail as

Re: relay help

2010-01-29 Thread Noel Jones
On 1/29/2010 4:46 PM, Wade Smart wrote: Noel Jones wrote: On 1/28/2010 4:57 PM, Wade Smart wrote: I have been using postfix for about two + years but something that was just out of my understanding at the time was setting up relaying. Right now I just sent from my mail client (thunderbird) but

VRFY defaults to on--why?

2010-01-29 Thread Stan Hoeppner
Hay Wietse, Someone was wondering on spam-l why Postfix defaults smtpd VRFY to ON instead of OFF. Their theory being that the default of ON makes it easier for spammers to harvest addresses. Most people shut if off (including me). Then spammers go to RCPT TO checking, so IMO it makes little

Re: VRFY defaults to on--why?

2010-01-29 Thread Wietse Venema
Stan Hoeppner: Hay Wietse, Someone was wondering on spam-l why Postfix defaults smtpd VRFY to ON instead of OFF. Their theory being that the default of ON makes it easier for spammers to harvest addresses. Postfix implements the SMTP protocol according to the RFCs that describe the

Re: smtpd processes congregating at the pub

2010-01-29 Thread Stan Hoeppner
Wietse Venema put forth on 1/29/2010 6:15 AM: Stan Hoeppner: Based on purely visual non-scientific observation (top), it seems my smtpd processes on my MX hang around much longer in (Debian) 2.5.5 than they did in (Debian) 2.3.8. In 2.3.8 Master seemed to build them and tear them down very