Re: Cyrus-sasl + postfix + postgresql problem.

2009-06-22 Thread Rafał Radecki
SASL was compiled with --enable-sql. Here is the output of saslfinger: === saslfinger - postfix Cyrus sasl configuration pon cze 22 09:25:28 CEST 2009 version: 1.0.2 mode: server-side SMTP AUTH -- basics -- Postfix: 2.6.2 System: CentOS release 5

Re: Cyrus-sasl + postfix + postgresql problem.

2009-06-21 Thread mouss
Rafał Radecki a écrit : > I corrected my mistake but it doesn't help. Any other ideas? > Please do not top post: put your replies after the text your reply to. did you restart postfix after the fix? if so, download and run saslfinger (see Patrick's signature). - make sure you installed the post

Re: Cyrus-sasl + postfix + postgresql problem.

2009-06-21 Thread Steve
On Sun, 2009-06-21 at 17:05 +0200, Rafał Radecki wrote: > Yes, but in /usr/lib/sasl2/smtpd.conf i have: > > pwcheck_method: auxprop > sql_engine: pgsql > sql_user: postfix > sql_passwd: postfix > sql_hostnames: localhost > sql_database: postfix > sql_select: SELECT password FROM mailbox WHERE user

Re: Cyrus-sasl + postfix + postgresql problem.

2009-06-21 Thread Rafał Radecki
Yes, but in /usr/lib/sasl2/smtpd.conf i have: pwcheck_method: auxprop sql_engine: pgsql sql_user: postfix sql_passwd: postfix sql_hostnames: localhost sql_database: postfix sql_select: SELECT password FROM mailbox WHERE username='%...@%r' mech_list: login plain log_level: 4 2009/6/21 EASY steve.h

Re: Cyrus-sasl + postfix + postgresql problem.

2009-06-21 Thread EASY steve.h...@digitalcertainty.co.uk
On Sun, 2009-06-21 at 15:16 +0100, Steve wrote: > On Sun, 2009-06-21 at 15:58 +0200, Rafał Radecki wrote: > > I corrected my mistake but it doesn't help. Any other ideas? > What are the logs saying? > OFF LIST RESPONSE RECEIVED; >/var/log/maillog: >Jun 21 17:54:00 localhost postfix/smtpd[3091]:

Re: Cyrus-sasl + postfix + postgresql problem.

2009-06-21 Thread Steve
On Sun, 2009-06-21 at 15:58 +0200, Rafał Radecki wrote: > I corrected my mistake but it doesn't help. Any other ideas? What are the logs saying?

Re: Cyrus-sasl + postfix + postgresql problem.

2009-06-21 Thread Rafał Radecki
I corrected my mistake but it doesn't help. Any other ideas? 2009/6/21 Patrick Ben Koetter > * Rafał Radecki : > > Hi all. I'm currently installing an smtp server on CentOS 5.3. Part of it > is > > to use PostgreSQL backend to store virtual > users/domains/aliases/passwords > > and of course to

Re: Cyrus-sasl + postfix + postgresql problem.

2009-06-21 Thread Patrick Ben Koetter
* Rafał Radecki : > Hi all. I'm currently installing an smtp server on CentOS 5.3. Part of it is > to use PostgreSQL backend to store virtual users/domains/aliases/passwords > and of course to use it for SASL authentication. My > /usr/lib/sasl2/smtpd.conf file: > > pwdcheck_method: auxprop Typo!

Re: Cyrus-sasl + postfix + postgresql problem.

2009-06-21 Thread EASY steve.h...@digitalcertainty.co.uk
Strike that, I've just noticed you crossposted to; cyrus-s...@lists.andrew.cmu.edu, Please ignore my stupid answer.

Re: Cyrus-sasl + postfix + postgresql problem.

2009-06-21 Thread EASY steve.h...@digitalcertainty.co.uk
On Sun, 2009-06-21 at 10:35 +0200, Rafał Radecki wrote: > Hi all. I'm currently installing an smtp server on CentOS 5.3. Part of > it is to use PostgreSQL backend to store virtual > users/domains/aliases/passwords and of course to use it for SASL > authentication. My /usr/lib/sasl2/smtpd.conf file:

Cyrus-sasl + postfix + postgresql problem.

2009-06-21 Thread Rafał Radecki
Hi all. I'm currently installing an smtp server on CentOS 5.3. Part of it is to use PostgreSQL backend to store virtual users/domains/aliases/passwords and of course to use it for SASL authentication. My /usr/lib/sasl2/smtpd.conf file: pwdcheck_method: auxprop sql_engine: pgsql sql_user: postfix s