Re: mySQL Query not working

2009-08-01 Thread mouss
Willy De la Court a écrit : > On Friday 31 July 2009, Tino Donderwinkel wrote: >> I have a virtual_alias map setup that uses this mySQL query; >> >> SELECT rcpt FROM aliases WHERE alias = '%s' OR alias = (SELECT >> CONCAT('%u@', alias_of) FROM domains WHERE domain = '%d') > > hmm I think the way t

Re: Blocking Hotmail

2009-08-01 Thread Robert Schetterer
Benny Pedersen schrieb: > On Thu, July 30, 2009 16:50, Rodman Frowert wrote: >> I wish there was a message board on the Postfix main site instead of JUST >> the mailing list. Would making find things that are asked a lot quite >> easier. Some of the mailing list archives don't have search functio

[SOLVED] RE: mySQL Query not working

2009-08-01 Thread Tino Donderwinkel
The problems was in here: http://www.postfix.org/mysql_table.5.html %u When the input key is an address of the form u...@domain, %u is replaced by the SQL quoted local part of the address. Other- wise, %u

put mails in hold queue based on size

2009-08-01 Thread ram
Some users on my postfix system send *Huge* mails and I dont want the mails to be transferred during peak hours Is there a way I can put mail to hold , if size exceeds a particular limit Thanks Ram

Re: mySQL Query not working

2009-08-01 Thread Willy De la Court
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Saturday 01 August 2009, Tino Donderwinkel wrote: > > > > On Friday 31 July 2009, Tino Donderwinkel wrote: > > > I have a virtual_alias map setup that uses this mySQL query; > > > > > > SELECT rcpt FROM aliases WHERE alias = '%s' OR alias = (SELECT

Re: put mails in hold queue based on size

2009-08-01 Thread Wietse Venema
ram: > Some users on my postfix system send *Huge* mails and I dont want the > mails to be transferred during peak hours > > Is there a way I can put mail to hold , if size exceeds a particular > limit Only via the policy daemon protocol. Wietse

reject_sender_login_mismatch doc

2009-08-01 Thread johnea
The postfix documentation regarding reject_sender_login_mismatch: http://www.postfix.org/postconf.5.html#reject_sender_login_mismatch or maybe in here: http://www.postfix.org/SMTPD_ACCESS_README.html Specifically the reject_authenticated_* and reject_unauthenticated_* forms, would greatly benef

Re: reject_sender_login_mismatch doc

2009-08-01 Thread /dev/rob0
On Saturday 01 August 2009 10:15:08 johnea wrote: > The postfix documentation regarding reject_sender_login_mismatch: > > http://www.postfix.org/postconf.5.html#reject_sender_login_mismatch > or maybe in here: > http://www.postfix.org/SMTPD_ACCESS_README.html > > Specifically the reject_authenticat

Re: put mails in hold queue based on size

2009-08-01 Thread Sahil Tandon
On Sat, 01 Aug 2009, ram wrote: > Some users on my postfix system send *Huge* mails and I dont want the > mails to be transferred during peak hours > > Is there a way I can put mail to hold , if size exceeds a particular > limit Yes, with a policy service called in smtpd_end_of_data_restrictio

Re: reject_sender_login_mismatch doc

2009-08-01 Thread mouss
/dev/rob0 a écrit : > On Saturday 01 August 2009 10:15:08 johnea wrote: >> The postfix documentation regarding reject_sender_login_mismatch: >> >> http://www.postfix.org/postconf.5.html#reject_sender_login_mismatch >> or maybe in here: >> http://www.postfix.org/SMTPD_ACCESS_README.html >> >> Specif

Omnipresent "conversation with timed out while sending message body)"

2009-08-01 Thread Andrew T. Robinson
Below: * Findings of fact * Representative messages from syslog * postconf -n * Output of tshark -- and if someone wants to complain about the length of this message, they should consider all the bandwidth wasted by people who quote entire messages in their replies :-) Findings of Fact 1. For

Re: Omnipresent "conversation with timed out while sending message body)"

2009-08-01 Thread Wietse Venema
Andrew T. Robinson: > delay=2005, delays=1283/0/361/361, dsn=4.4.2, status=deferred > delay=5004, delays=4283/0.01/361/361, dsn=4.4.2, status=deferred > delay=7283, delays=6561/0.01/361/361, dsn=4.4.2, status=deferred I these numbers aren't "modified for privacy reasons", Google is tarpitting you

Re: mail from,return-path,reverse-path

2009-08-01 Thread mouss
Magnus Bäck a écrit : > [snip] > > I haven't even heard the term "reverse path" before. Most likely it's > someone mixing it up with the more common "return path", so you can > assume they're synonyms. > I'm sure you heard it before, but forgot that. it's the term used in RFC 821 (and still used

Re: Stop spammers sending us spam from users in our domain...

2009-08-01 Thread mouss
Matthew D. Fuller a écrit : > On Wed, Jul 29, 2009 at 03:03:43PM +0100 I heard the voice of > Clunk Werclick, and lo! it spake thus: >> My apologies for the terse caveat. As I understand it, there are >> some external mail services that roaming users may use that forward >> mail into your Postfix c

Re: Omnipresent "conversation with timed out while sending message body)"

2009-08-01 Thread Andrew T. Robinson
Wietse Venema wrote: Andrew T. Robinson: delay=2005, delays=1283/0/361/361, dsn=4.4.2, status=deferred delay=5004, delays=4283/0.01/361/361, dsn=4.4.2, status=deferred delay=7283, delays=6561/0.01/361/361, dsn=4.4.2, status=deferred I these numbers aren't "modified for privacy reasons

checking local_recipient_maps

2009-08-01 Thread donovan jeffrey j
greetings, how can I test local_recipient_maps ? I am using an ldap local map, and I would like to insert a backup or failover map. here is what I am using. local_recipient_maps = ldap:/etc/postfix/ldaplocal $alias_maps #ldaplocal server_host = 10.10.1.12 search_base = dc=ldap,dc=mydomain,

Re: checking local_recipient_maps

2009-08-01 Thread Sahil Tandon
On Sat, 01 Aug 2009, donovan jeffrey j wrote: > i use ldap search all the time for testing but i would like to see how > postfix queries and replies. % man 1 postmap -- Sahil Tandon

Re: put mails in hold queue based on size

2009-08-01 Thread LuKreme
On 1-Aug-2009, at 06:18, ram wrote: Some users on my postfix system send *Huge* mails and I dont want the mails to be transferred during peak hours Why transfer them at all? Email is a horrible way to send HUGE files. And grossly inefficient. And rude. Is there a way I can put mail to hold

Re: put mails in hold queue based on size

2009-08-01 Thread Sahil Tandon
On Sat, 01 Aug 2009, LuKreme wrote: > On 1-Aug-2009, at 06:18, ram wrote: >> Some users on my postfix system send *Huge* mails and I dont want the >> mails to be transferred during peak hours > > Why transfer them at all? Email is a horrible way to send HUGE files. > And grossly inefficient. And

Re: put mails in hold queue based on size

2009-08-01 Thread LuKreme
On 1-Aug-2009, at 21:29, Sahil Tandon wrote: On Sat, 01 Aug 2009, LuKreme wrote: On 1-Aug-2009, at 06:18, ram wrote: Some users on my postfix system send *Huge* mails and I dont want the mails to be transferred during peak hours Why transfer them at all? Email is a horrible way to send HUGE