Re: mysql query failed on non-existent mail address

Adrian Dinu wrote: Hello, I have the following problem with my postfix configuration: << SNIP >> Aug 18 10:56:20 server postfix/smtpd[17528]: warning: mysql query failed: Unknown column 'email' in 'where clause' << SNIP >> Kind Regards. OK You need to go through all the SQL queries you crea

Re: safe way to retire postfix gateway

Robert Lopez a écrit : > Having built new email gateways, it is time to retire the old ones. > > I have removed one email gateway running postfix from the MX records > for our college. > It still has a few hundred mail in the queues and some spam is still coming > in. > > What is the best way to

Re: Content checking - bulk emails

Jaroslaw Grzabel a écrit : > Hi guys, > > I'm wondering is there any way to configure postfix, to check content of > messages which contains ... let say more than 10 recipients, scan those > and check contents in looking for un.sub.scribe link (or particular words) > and if found pass messages if

Re: postfix + procmail master.cf question

Jeff Lacki a écrit : > Im having problems with the mail file being produced > when I setup procmail + postfix: > > Ive setup global procmail with the following in > my master.cf file: > > procmail unix - n n - - pipe > flags=DRX user=jeff argv=/usr/bin/procmail -

Re: mysql query failed on non-existent mail address

Adrian Dinu a écrit : > Hello, > > I have the following problem with my postfix configuration: > [snip] > Aug 18 10:56:20 server postfix/smtpd[17528]: warning: mysql query > failed: Unknown column 'email' in 'where clause' it said: unknown column. you're asking postfix to use a column that does n

Re: sending large number of emails

Ralf Hildebrandt a écrit : > * Hilel New : > >> I am looking for reading material about sending bulk mail. Tips and >> tricks, things to avoid, etc. Can you recommend one? > > Use a MLM (like Mailman) > Use VERP > Read > http://blog.summation.net/2008/06/email-deliverability-is-crucial-to-achiev

Re: HELO/EHLO rejection rate

Mike Cappella a écrit : > O[snip] > If the OPs question was about why the apparent discrepancy between > postfix-logwatch and the "other stats" generated from the unmentioned > stats tools, who can say without more data. Perhaps a representative > sample of log lines and direct comparison against

Re: postfix terminating on signal 15

Wietse Venema wrote: I don't think so. Instead of YOU filtering by hand a long file, let the COMPUTER do the work for you: egrep '(warning|error|fatal|panic):' /the/log/file | grep qmgr I read the links provided and that's what I did. I filtered by hand first and then grepped the logs to ve

Re: safe way to retire postfix gateway

What about adding this to main.cf?: inet_interfaces = loopback-only I believe that that would work as well. Basically, the idea is to cut off outside access to postfix so that new messages don't get in the queue. Simultaneously, postfix is attempting to empty the queue as normal. Eventu

Re: Looking for opinions on FreeBSD OS for Postfix

This is probably drifting off-topic, but I have a few questions regarding your setup... On Tue, 18 Aug 2009, Jordi Espasa Clofent wrote: 85.000 aprox. mail account here (spanish web-hosting company) using: * 25 FreeBSD 7.x as reception-only mailservers (3500 accounts per server aprox) * 3 F

Re: safe way to retire postfix gateway

Original Message Subject: safe way to retire postfix gateway From: Robert Lopez To: Postfix users Date: Tuesday, August 18, 2009 3:52:11 PM Having built new email gateways, it is time to retire the old ones. I have removed one email gateway running postfix from the MX record

safe way to retire postfix gateway

Having built new email gateways, it is time to retire the old ones. I have removed one email gateway running postfix from the MX records for our college. It still has a few hundred mail in the queues and some spam is still coming in. What is the best way to stop the incoming email and allow the q

Re: postfix performance

I spoke too soon Mark Johnson wrote: > hopcount_limit = 500 > This seems a bit unreasonable due to this exists to stop mail loops and overload. The default of 50 works in many, many situations. > maximal_queue_lifetime = 5h > Why so short? This can generate many, many bounces due to tr

Re: postfix performance

Mark Johnson wrote: > Here is the postconf -n > > [r...@mail postfix]# postconf -n > This seems fine, mostly using defaults. Can you please provide a non-verbose, log of a mail transaction you feel is affected? Barney had mentioned this too and it is quite important. Do you have a DNS caching

Re: postfix terminating on signal 15

Jeroen van Aart: > That's it until > Aug 15 02:55:06 prod101 postfix/master[9402]: warning: process > /usr/lib/postfix/qmgr pid 9582 exit status 1 I don't think so. Instead of YOU filtering by hand a long file, let the COMPUTER do the work for you: egrep '(warning|error|fatal|panic):' /the/log

Re: postfix performance

Here is the postconf -n [r...@mail postfix]# postconf -n alias_database = hash:/etc/aliases alias_maps = hash:/etc/aliases command_directory = /usr/sbin config_directory = /etc/postfix daemon_directory = /usr/libexec/postfix debug_peer_level = 2 disable_vrfy_command = yes hopcount_limit = 500 html

Re: RBLS and Hangup

Quoting LuKreme : On 18-Aug-2009, at 10:42, Noel Jones wrote: The STRESS_README was written before postfix supported 521 as a hangup action, so yes, it's reasonable to disconnect after any RBL hit during stress. I am somewhat hesitant to recommend using 521 as your "standard" RBL reject

Re: combine permit_sasl_authenticated with check_sender_access

* Stephan A. Rickauer : > Hi, > > i'd like to protect some internal accounts as described at > http://www.postfix.org/RESTRICTION_CLASS_README.html > > Currently, I have the following setup: > > smtpd_recipient_restrictions = > reject_unauth_pipelining > permit_inet_interfaces > permit_sasl_a

Re: RBLS and Hangup

LuKreme wrote: On 18-Aug-2009, at 10:42, Noel Jones wrote: The STRESS_README was written before postfix supported 521 as a hangup action, so yes, it's reasonable to disconnect after any RBL hit during stress. I am somewhat hesitant to recommend using 521 as your "standard" RBL reject code si

Re: strange virtual alias problem

Len Conrad wrote: > -- Original Message -- > From: Brian Evans - Postfix List > Reply-To: Postfix users > Date: Tue, 18 Aug 2009 12:58:43 -0400 > > >> Len Conrad wrote: >> >>> -- Original Message -- >>> From:

Re: RBLS and Hangup

On 18-Aug-2009, at 10:42, Noel Jones wrote: The STRESS_README was written before postfix supported 521 as a hangup action, so yes, it's reasonable to disconnect after any RBL hit during stress. I am somewhat hesitant to recommend using 521 as your "standard" RBL reject code since the RFCs

Re: postfix terminating on signal 15

Brian Evans - Postfix List wrote: This is the real problem. Search the logs just before this for a qmgr[9582] (error|fatal|panic). Thanks for the pointer. I don't find any indication that qmgr was having a problem, below are the last log entries: Aug 15 02:08:31 prod101 postfix/qmgr[9582]:

Re: strange virtual alias problem

-- Original Message -- From: Brian Evans - Postfix List Reply-To: Postfix users Date: Tue, 18 Aug 2009 12:58:43 -0400 >Len Conrad wrote: >> -- Original Message -- >> From: "Len Conrad" >> Reply-To: >> Date: Tue,

combine permit_sasl_authenticated with check_sender_access

Hi, i'd like to protect some internal accounts as described at http://www.postfix.org/RESTRICTION_CLASS_README.html Currently, I have the following setup: smtpd_recipient_restrictions = reject_unauth_pipelining permit_inet_interfaces permit_sasl_authenticated reject_non_fqdn_hostname reject

Re: strange virtual alias problem

Len Conrad wrote: > -- Original Message -- > From: "Len Conrad" > Reply-To: > Date: Tue, 18 Aug 2009 18:08:59 +0200 > > >> mail_version = 2.3.3 >> >> postconf | egrep virtual_alias_maps >> >> proxy_read_maps = $local_recipient_maps, $mydestination, >>

Re: RBLS and Hangup

LuKreme wrote: After reading (and implementing) http://www.postfix.org/STRESS_README.html#hangup I was wondering if there is any reason not to extend this behavior to 127.0.0.4-8 (the XBL)? Also, why would I want: 8 rbl_reply_maps = ${stress?hash:/etc/postfix/rbl_reply_maps} Is there a reas

strange virtual alias problem

-- Original Message -- From: "Len Conrad" Reply-To: Date: Tue, 18 Aug 2009 18:08:59 +0200 > >mail_version = 2.3.3 > >postconf | egrep virtual_alias_maps > >proxy_read_maps = $local_recipient_maps, $mydestination, >$virtual_alias_maps, $virtual_alias_doma

[no subject]

mail_version = 2.3.3 postconf | egrep virtual_alias_maps proxy_read_maps = $local_recipient_maps, $mydestination, $virtual_alias_maps, $virtual_alias_domains, $virtual_mailbox_maps, $virtual_mailbox_domains, $relay_recipient_maps, $relay_domains, $canonical_maps, $sender_canonical_maps, $reci

RBLS and Hangup

After reading (and implementing) http://www.postfix.org/STRESS_README.html#hangup I was wondering if there is any reason not to extend this behavior to 127.0.0.4-8 (the XBL)? Also, why would I want: 8 rbl_reply_maps = ${stress?hash:/etc/postfix/rbl_reply_maps} Is there a reason I would onl

Re: test

On 18-Aug-2009, at 07:42, Hilel New wrote: I can't submit to this list LIES! -- When cheese gets its picture taken, what does it say?

Re: 450 temp error when 550 perm error is possible

On 17-Aug-2009, at 03:25, Martijn de Munnik wrote: The 450 error triggers the spammer to retry sending the mail. In point of fact, if it is a spammer sending you the mail, a 450 error is often enough to dissuade them. This is the principle behind greylisting. However, if these are real m

Re: sending large number of emails

* Hilel New : > I am looking for reading material about sending bulk mail. Tips and > tricks, things to avoid, etc. Can you recommend one? Use a MLM (like Mailman) Use VERP Read http://blog.summation.net/2008/06/email-deliverability-is-crucial-to-achieve-consumer-internet-virality.html -- Ralf

sending large number of emails

I am looking for reading material about sending bulk mail. Tips and tricks, things to avoid, etc. Can you recommend one?

Re: Notification of non-delivery

Eduardo J?nior: > and I have some doubts. > This: > "With Postfix 2.4 and later, a message is returned as either message/rfc822 > (the complete original) or as text/rfc822-headers (the headers only)" > > does means that if my postifxis < 2.4 the body of the message sent > doesn't included in > the

Re: test

On 8/18/2009 9:42 AM, Hilel New wrote: > I can't submit to this list You just did... -- Best regards, Charles

test

I can't submit to this list

Re: mysql query failed on non-existent mail address

Adrian Dinu wrote: > Problem is when i send an email to an alias or mailbox that is not > valid in my database: > > Aug 18 10:56:20 server postfix/smtpd[17528]: connect from > mail-bw0-f205.google.com [209.85.218.205] > Aug 18 10:56:20 server postfix/smtpd[17528]: w

Re: postfix terminating on signal 15

Jeroen van Aart: > Aug 15 02:55:06 prod101 postfix/master[9402]: warning: process > /usr/lib/postfix/qmgr pid 9582 exit status 1 Good. Now look for error/fatal/warning loggings BEFORE this record. Wietse http://www.postfix.org/DEBUG_README.html#logging Look for obvious signs of trouble

Re: postfix terminating on signal 15

Jeroen van Aart wrote: > Wietse Venema wrote: >> It's unprodictive to kill off Postfix under overload. At the very >> least you should increase your 35-second deadline. > > Yes I did increase it to 120 seconds. I understand just killing and > restarting postfix is not a solution. > > As a test I sw

Re: Content checking - bulk emails

2009/8/18 Jaroslaw Grzabel : > > I'm wondering is there any way to configure postfix, to check content of > messages which contains ... let say more than 10 recipients, scan those > and check contents in looking for un.sub.scribe link (or particular words) > and if found pass messages if not block

Re: Looking for opinions on FreeBSD OS for Postfix

* Guy : I'm considering FreeBSD as an alternative, but I was wondering what people think of FreeBSD as a platform for Postfix. It's obviously not as easy to maintain as Ubuntu, but it does have a reputation for stability. Any thoughts, recommendations or experiences would be appreciated. 85.000

Re: Looking for opinions on FreeBSD OS for Postfix

Mikael Bak wrote: > Stefan Förster wrote: >> >> The documentation at http://www.postfix.org/INSTALL.html#4 mentions >> that earlier versions of Postfix were supported on FreeBSD 2.x to 5.x. >> >> I think it's very likely that you can run recent Postfix versions on >> newer FreeBSD releases, too. >>

mysql query failed on non-existent mail address

Hello, I have the following problem with my postfix configuration: If i send an email from gmail to a valid mailbox / alias on my server it works fine: Aug 18 10:57:52 server postfix/smtpd[17528]: connect from mail-bw0-f205.google.com[209.85.218.205] Aug 18 10:57:52 server postfix/smtpd[17528]:

Re: Looking for opinions on FreeBSD OS for Postfix

Stefan Förster wrote: > > The documentation at http://www.postfix.org/INSTALL.html#4 mentions > that earlier versions of Postfix were supported on FreeBSD 2.x to 5.x. > > I think it's very likely that you can run recent Postfix versions on > newer FreeBSD releases, too. > > Ack, I have FreeBSD

Re: Looking for opinions on FreeBSD OS for Postfix

Thanks for all the input. Now that I know so many people are happy with FreeBSD as a base for their Postfix machines I'll definitely be having a look at it as a possibility for the future. Thanks again. Guy -- Don't just do something...sit there!

Re: Looking for opinions on FreeBSD OS for Postfix

On 18/08/2009 10:00, Stefan Förster wrote: * Guy: I'm considering FreeBSD as an alternative, but I was wondering what people think of FreeBSD as a platform for Postfix. It's obviously not as easy to maintain as Ubuntu, but it does have a reputation for stability. Any thoughts, recommendations or

Re: Looking for opinions on FreeBSD OS for Postfix

* Guy : > I'm considering FreeBSD as an alternative, but I was wondering what > people think of FreeBSD as a platform for Postfix. It's obviously not > as easy to maintain as Ubuntu, but it does have a reputation for > stability. Any thoughts, recommendations or experiences would be > appreciated.

RE: Looking for opinions on FreeBSD OS for Postfix

>> -Original Message- >> I'm considering FreeBSD as an alternative, but I was wondering what >> people think of FreeBSD as a platform for Postfix. It's obviously not >> as easy to maintain as Ubuntu, but it does have a reputation for >> stability. Any thoughts, recommendations or experience