Re: %d and %s in mysql queries?

2010-01-30 Thread Jeff Weinberger
On Sat, Jan 30, 2010 at 4:41 PM, Wietse Venema wrote: > Jeff Weinberger: >> I am using mysql (quite successfully in most cases) to do lookups for >> a variety of reasons in postfix. >> >> Recently, I had some issues with a domain lookup and in the testing >> tri

%d and %s in mysql queries?

2010-01-30 Thread Jeff Weinberger
I am using mysql (quite successfully in most cases) to do lookups for a variety of reasons in postfix. Recently, I had some issues with a domain lookup and in the testing tried varying my MySQL query between using %d and %s as the lookup key. The documentation is clear on this when the query is f

Re: allowing outside users access to mailman lists

2010-01-30 Thread Jeff Weinberger
On Thu, Jan 28, 2010 at 4:02 PM, Jeff Weinberger wrote: > On Thu, Jan 28, 2010 at 3:39 PM, Noel Jones wrote: >> On 1/28/2010 5:36 PM, Jeff Weinberger wrote: >>> >>> On Thu, Jan 28, 2010 at 3:16 PM, Noel Jones >>>  wrote: >>>>

Re: allowing outside users access to mailman lists

2010-01-28 Thread Jeff Weinberger
On Thu, Jan 28, 2010 at 3:39 PM, Noel Jones wrote: > On 1/28/2010 5:36 PM, Jeff Weinberger wrote: >> >> On Thu, Jan 28, 2010 at 3:16 PM, Noel Jones >>  wrote: >>> >>> On 1/28/2010 4:46 PM, Jeff Weinberger wrote: >>>> &

Re: allowing outside users access to mailman lists

2010-01-28 Thread Jeff Weinberger
On Thu, Jan 28, 2010 at 3:16 PM, Noel Jones wrote: > On 1/28/2010 4:46 PM, Jeff Weinberger wrote: >> >> virtual_alias_domains = mysql:/etc/postfix/mysql_virtual_alias_domains.cf > > does lists.mylistserver.com match the above lookup? > postmap -q lists.mylistserver.com m

Re: allowing outside users access to mailman lists

2010-01-28 Thread Jeff Weinberger
On Thu, Jan 28, 2010 at 2:38 PM, Stan Hoeppner wrote: > Jeff Weinberger put forth on 1/28/2010 4:18 PM: > >> You've made it clear I'm posting the wrong thing - but I don't know >> what the "right" thing is > > Sorry to but in Wietse. > >

Re: allowing outside users access to mailman lists

2010-01-28 Thread Jeff Weinberger
On Thu, Jan 28, 2010 at 1:36 PM, Wietse Venema wrote: > Jeff Weinberger: >> > Jeff Weinberger: >> > > I changed main.cf so the only "relay_domains" entry is: >> > > >> > > relay_domains=lists.mylistserver.com >> > >> > Y

Re: allowing outside users access to mailman lists

2010-01-28 Thread Jeff Weinberger
--- In postfix-us...@yahoogroups.com, Wietse Venema wrote: > > Jeff Weinberger: > > I changed main.cf so the only "relay_domains" entry is: > > > > relay_domains=lists.mylistserver.com > > You need to verify this with the command > > postconf -n >

Re: allowing outside users access to mailman lists

2010-01-27 Thread Jeff Weinberger
--- In postfix-us...@yahoogroups.com, Wietse Venema wrote: > > Jeff Weinberger: > > > > > > Jeff Weinberger: > > > [ Charset UTF-8 unsupported, converting... ] > > > > --- In postfix-us...@yahoogroups.com, mouss wrote: > > > > > >

Re: allowing outside users access to mailman lists

2010-01-26 Thread Jeff Weinberger
--- In postfix-us...@yahoogroups.com, Wietse Venema wrote: > > Jeff Weinberger: > [ Charset UTF-8 unsupported, converting... ] > > --- In postfix-us...@yahoogroups.com, mouss wrote: > > > > > > Jeff Weinberger a ?crit : > > > > I am hoping that this

Re: allowing outside users access to mailman lists

2010-01-26 Thread Jeff Weinberger
--- In postfix-us...@yahoogroups.com, mouss wrote: > > Jeff Weinberger a �crit : > > I am hoping that this is something fairly simple that I am missing > > > > I have a few lists on a mailman server that I run. Until recently, only > > authenticated users (those

allowing outside users access to mailman lists

2010-01-26 Thread Jeff Weinberger
I am hoping that this is something fairly simple that I am missing I have a few lists on a mailman server that I run. Until recently, only authenticated users (those who have actual accounts on my IMAP/Virtual mailboxes server and can authenticate via SASL). Now I want to allow certain users w

Re: Redirect all mail from one domain to the same u...@otherdomain?

2009-02-12 Thread Jeff Weinberger
Mouss wrote: Jeff Weinberger a �crit : > [snip] > > This is helpful, but I still need the query to take all the other > alias domains into account. So, I need the IF condition, or a second map. > I don't think so. I used this. I don't remember the details, but the i

Re: Redirect all mail from one domain to the same u...@otherdomain?

2009-02-10 Thread Jeff Weinberger
ns (it doesn't work if example.net is an alis for example.org which is in turn an alias of example.com). but this should be enough in most cases. This is helpful, but I still need the query to take all the other alias domains into account. So, I need the IF condition, or a second map. Tha

Redirect all mail from one domain to the same u...@otherdomain?

2009-02-08 Thread Jeff Weinberger
o: or Cc: address (such as list mail). Really, I am just checking with experts more knowledgeable than I whether I have chosen a good (or the best) way to achieve this, or if there is a better way. Any advice and help are much appreciated! Thanks, --Jeff -- Jeff Weinberger

Re: Question on sendmail submission and master.cf -o overrides

2009-01-20 Thread Jeff Weinberger
Viktor Wrote: Date: Tue, 20 Jan 2009 22:26:23 -0500 From: Victor Duchovni Subject: Re: Question on sendmail submission and master.cf -o overrides On Tue, Jan 20, 2009 at 07:11:16PM -0800, Jeff Weinberger wrote: I am hoping someone can offer help in determining this information about

Question on sendmail submission and master.cf -o overrides

2009-01-20 Thread Jeff Weinberger
Hi: I am hoping someone can offer help in determining this information about the specifics of how sendmail submits mail. I have three different services configured in master.cf to accept mail: 1) the regular smtpd service on port 25, 2) a submission service for authenticated clients, and

Re: Question about reject_unauthenticated_sender_login_mismatch (additional information)

2009-01-15 Thread Jeff Weinberger
Viktor Wrote: On Thu, Jan 15, 2009 at 10:01:51PM +0100, mouss wrote: > jeff_homeip a ?crit : > > [snip] > > When I added this back, all worked fine. If I remove this one restriction > > (check_sender_access), I can no longer send. > > > > is this check_sender_access, because it's not rejectin

Re: holding messages for one address or one domain in the queue?

2009-01-14 Thread Jeff Weinberger
On Jan 14, 2009, at 3:53 PM, Roderick A. Anderson wrote: Jeff Weinberger wrote: This may seem like an odd question, but I need to find a way to suspend delivery of mail to one account or one domain for a short period of time to allow me to do a bit of maintenance. As it stands now, I use

holding messages for one address or one domain in the queue?

2009-01-14 Thread Jeff Weinberger
This may seem like an odd question, but I need to find a way to suspend delivery of mail to one account or one domain for a short period of time to allow me to do a bit of maintenance. As it stands now, I use maildrop as my delivery transport for virtual mailboxes. Is there a way to tell

Re: Question about reject_unauthenticated_sender_login_mismatch

2009-01-12 Thread Jeff Weinberger
Viktor Duchovni wrote: On Mon, Jan 12, 2009 at 01:25:38PM -0800, Jeff Weinberger wrote: reject_sender_login_mismatch checks the from address against smtpd_sender_login_maps to be sure that the MAIL FROM address is owned by the SASL-authenticated sender. But with

Question about reject_unauthenticated_sender_login_mism atch

2009-01-12 Thread Jeff Weinberger
Hi: This question is just a request for information on this... I currently use reject_sender_login_mismatch in my smtpd_sender_restrictions as an added precaution against someone sending undesirable mail. I see that I can also use reject_unauthenticated_sender_login_mismatch, but I don't underst

Re: "forcing" authenticated users to use port 587?

2009-01-08 Thread Jeff Weinberger
On Jan 8, 2009, at 6:53 AM, Jorey Bump wrote: Jeff Weinberger wrote, at 01/08/2009 09:27 AM: Setting smtpd_sasl_auth_enable = no would mean that no authentication is required on port 25, but if I understand it correctly, it wouldn't actually stop an authenticated user from sending

Re: "forcing" authenticated users to use port 587?

2009-01-08 Thread Jeff Weinberger
On Thu, 08 Jan 2009 09:53:45 -0500, Jorey Bump wrote: > Jeff Weinberger wrote, at 01/08/2009 09:27 AM: > >> Setting smtpd_sasl_auth_enable = no would mean that no authentication is >> required on port 25, but if I understand it correctly, it wouldn't >> actually st

Re: "forcing" authenticated users to use port 587?

2009-01-08 Thread Jeff Weinberger
On Jan 8, 2009, at 5:49 AM, Jorey Bump wrote: Jeff Weinberger wrote, at 01/08/2009 12:10 AM: Hi: Based on good practice and the help and urging of some of the gurus on this list, I am moving my users to using the submission service (port 587) instead of port 25 to send mail from their mail

"forcing" authenticated users to use port 587?

2009-01-07 Thread Jeff Weinberger
Hi: Based on good practice and the help and urging of some of the gurus on this list, I am moving my users to using the submission service (port 587) instead of port 25 to send mail from their mail clients. Once most of them move, I'd like to start warning the ones who don't that they shoul

how to specify an over-ride in master.cf that contains whitespace

2009-01-06 Thread Jeff Weinberger
Hi: Yet another question I hope I can impose upon your help for... I am testing sender restrictions and have defined an alternate submission entry in master.cf for this purpose (and not to disrupt other users while I test). I want to test the check_sender_access which requires the form "

Re: Getting reject_sender_login_mismatch/smtpd_sender_login_maps and mysql to work together

2009-01-06 Thread Jeff Weinberger
On Jan 6, 2009, at 5:59 PM, Wietse Venema wrote: Jeff Weinberger: I then added the line: smtpd_sender_login_maps=hash:/path/to/map to my main.cf and send a few messages. Postfix correctly allowed and rejected all of the test messaages, and the logs showed the correct reason for the rejection

Re: Getting reject_sender_login_mismatch/smtpd_sender_login_maps and mysql to work together

2009-01-06 Thread Jeff Weinberger
On Tue Jan 6, 2009 2:42 pm Victor Duchovni wrote: > I know that it is not a good model for the way postfix requires the > query, More stronly, an SQL schema in which multiple data items are stored concatenated in a single table element is a poor schema regardless of the application. This violat

Getting reject_sender_login_mismatch/smtpd_sender_login_maps and mysql to work together

2009-01-06 Thread Jeff Weinberger
Hi: I would very much appreciate any help, advice, pointers, etc. to resolve an issue I am encountering. I am having a challenge trying to use a mysql table for smtpd_sender_login_maps. Right now I have: In main.cf: smtpd_sender_login_maps=mysql:/path/to/map.cf smtpd_sender_restrict

Re: Finding the envelope-sender after always_bcc? (SOLVED)

2009-01-02 Thread Jeff Weinberger
On Jan 2, 2009, at 5:32 PM, mouss wrote: Jeff Weinberger a écrit : I'm guessing I should leave my port 25 (smtp) entry to allow submission on that port with authentication (leaving "smtpd_client_restrictions=permit_sasl_authenticated...") - is there any harm in that? no.

Re: Finding the envelope-sender after always_bcc? (SOLVED)

2009-01-02 Thread Jeff Weinberger
On Jan 2, 2009, at 4:03 PM, mouss wrote: Jeff Weinberger a écrit : OK, thanks. I will set up dspam to listen on port 10024 - seems to make the most sense. I don't need a localhost:10024 entry in master.cf then? right? no, 10024 will be used by dspam. your postfix should h

Re: issue connecting to mysql after upgrade (issue not postfix)

2009-01-02 Thread Jeff Weinberger
On Jan 1, 2009, at 4:53 PM, mouss wrote: Jeff Weinberger a écrit : [snip] - try with "hosts = 127.0.0.1" (without "localhost") Tried this - no change. :( ahem. if you do this, you should not hear about a socket. it should use a TCP connection. can you show the er

Re: Finding the envelope-sender after always_bcc? (SOLVED)

2009-01-02 Thread Jeff Weinberger
On Jan 2, 2009, at 3:20 PM, mouss wrote: Jeff Weinberger a écrit : content_filter=lmtp:unix:/path/to/dspam args No. content_filter=lmtp:inet:127.0.0.1:10024 where the 10024 is the same port used in dspam.conf: ServerPort10024 of course, dspam must be running in daemon mode

Re: Finding the envelope-sender after always_bcc? (SOLVED)

2009-01-02 Thread Jeff Weinberger
On Jan 2, 2009, at 2:17 PM, mouss wrote: Jeff Weinberger a écrit : On Jan 2, 2009, at 9:20 AM, mouss wrote: Jeff Weinberger a écrit : It's definitely my set up. I don't use LMTP to pass the message to dspam, I use a transport called "dspam" that uses pipe. That mea

Re: Finding the envelope-sender after always_bcc? (SOLVED)

2009-01-02 Thread Jeff Weinberger
Wietse Venema wrote: Jeff Weinberger: [ Charset ISO-8859-1 unsupported, converting... ] > On Jan 2, 2009, at 2:30 AM, mouss wrote: > > > Jeff Weinberger a ?crit : > >> > >> I used a pcre: table for smtpd_sender_restrictions and the PREPEND > >&g

Re: Finding the envelope-sender after always_bcc? (SOLVED)

2009-01-02 Thread Jeff Weinberger
On Jan 2, 2009, at 9:20 AM, mouss wrote: Jeff Weinberger a écrit : It's definitely my set up. I don't use LMTP to pass the message to dspam, I use a transport called "dspam" that uses pipe. That means there's no S/LMTP dialog, just the message itself passed as S

Re: Finding the envelope-sender after always_bcc? (SOLVED)

2009-01-02 Thread Jeff Weinberger
On Jan 2, 2009, at 2:30 AM, mouss wrote: Jeff Weinberger a écrit : I used a pcre: table for smtpd_sender_restrictions and the PREPEND action as follows: main.cf: smtpd_sender_restrictions = check_sender_access pcre:/etc/postfix/smtpd_sender_restrictions.pcre

Re: Finding the envelope-sender after always_bcc? (SOLVED)

2009-01-01 Thread Jeff Weinberger
On Jan 1, 2009, at 12:58 PM, mouss wrote: Jeff Weinberger a écrit : I've been reading the dspam docs this morning and the project owner states fairly strongly that sendmail is far preferable to SMTP re-injection (in the postfix setup docs), but doesn't say why. if he doesn'

Re: issue connecting to mysql after upgrade

2009-01-01 Thread Jeff Weinberger
On Jan 1, 2009, at 4:53 PM, mouss wrote: Jeff Weinberger a écrit : [snip] - try with "hosts = 127.0.0.1" (without "localhost") Tried this - no change. :( ahem. if you do this, you should not hear about a socket. it should use a TCP connection. can you show the err

Re: issue connecting to mysql after upgrade

2009-01-01 Thread Jeff Weinberger
On Jan 1, 2009, at 1:55 PM, mouss wrote: Jeff Weinberger a écrit : Hello again: One more issue on which I would appreciate any help anyone can offer: Yesterday I upgraded my postfix installation from 2.5.2 to 2.5.5 and my MySQL installation from 5.0.51b to 5.0.75. Immediately after

issue connecting to mysql after upgrade

2009-01-01 Thread Jeff Weinberger
Hello again: One more issue on which I would appreciate any help anyone can offer: Yesterday I upgraded my postfix installation from 2.5.2 to 2.5.5 and my MySQL installation from 5.0.51b to 5.0.75. Immediately after restarting everything (the whole computer), I started seeing these message

Re: Finding the envelope-sender after always_bcc?

2009-01-01 Thread Jeff Weinberger
On Jan 1, 2009, at 9:49 AM, mouss wrote: Jeff Weinberger a écrit : Thank you! That helps clarify what I was missing in this - so clearly dspam is not passing the envelope sender back to postfix. I suspect it doesn't know how via SMTP, but it can also use the sendmail command to do th

Re: Finding the envelope-sender after always_bcc?

2009-01-01 Thread Jeff Weinberger
On Jan 1, 2009, at 9:31 AM, mouss wrote: jeff_homeip a écrit : --- In post...@yahoogroups.com, mouss wrote: Jeff Weinberger a écrit : I've verified that the "R" flag is there and I use -f ${sender} on the command line (the script does parse the arguments) I think the env

Re: Finding the envelope-sender after always_bcc?

2009-01-01 Thread Jeff Weinberger
mouss wrote: Jeff Weinberger a écrit : > > I've verified that the "R" flag is there and I use -f ${sender} on the > command line (the script does parse the arguments) > > I think the envelope-sender is missing before it enters the content > filter. This from

Re: Finding the envelope-sender after always_bcc?

2008-12-31 Thread Jeff Weinberger
On Dec 31, 2008, at 6:11 PM, mouss wrote: Jeff Weinberger a écrit : Hi: After reading http://www.irbs.net/internet/postfix/0703/1471.html and http://www.irbs.net/internet/postfix/0703/1519.html to help with my autoreply capability (and making sure i get it as close to "right" as pos

Finding the envelope-sender after always_bcc?

2008-12-31 Thread Jeff Weinberger
Hi: After reading http://www.irbs.net/internet/postfix/0703/1471.html and http://www.irbs.net/internet/postfix/0703/1519.html to help with my autoreply capability (and making sure i get it as close to "right" as possible!), I am trying to ensure that I can take all reasonable measures to ge

Can recipient_bcc_maps be over-riden in master.cf?

2008-12-27 Thread Jeff Weinberger
Hi: I am having a problem with duplicate bcc's (from recipient_bcc_maps) and I suspect I know why - but I hope someone can point me to a solution. I have a content filter set up for dspam (content_filter = dspam:dspam in main.cf) set up as described in the "Advanced content filter examp

Implementing autoreply for all received mail (including internally forwarded)

2008-12-27 Thread Jeff Weinberger
Hi: I am hoping I can ask for suggestions or pointers to help solve this challenge. I am trying to implement an autoreply capability. I am putting together a script that will handle the messages. Many of the autoreply examples I've found suggest implementing this by: main.cf: always_b

Content filtering using MySQL table

2008-07-27 Thread Jeff Weinberger
Hi: I"m using content filtering by using the following (this is the example) syntax in master.cf: smtp inet ...other stuff here, do not change... smtpd -o content_filter=myfilter:myfilter myfilter unix - n n - 10 pipe flags.. All is wo

Wildcard for domain instead of user?

2008-07-27 Thread Jeff Weinberger
is much appreciated! -- Jeff Weinberger http://disruptivemarketing.jeffweinberger.com