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

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

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:

Re: Cyrus-sasl + postfix + postgresql problem.

2009-06-21 Thread Patrick Ben Koetter
* Rafał Radecki radecki.ra...@gmail.com: 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:

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 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 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

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