postfix dbmail and cyrus-sasl

[Alan Glait]

Ok ! its working .... mmm but is not validating my pass  :(

050908 15:25:19       1 Connect     dbmail at localhost on dbmail
                     1 Quit
                     2 Connect     dbmail at localhost on dbmail
                     2 Quit
                     3 Connect     dbmail at localhost on dbmail
                     3 Query       START TRANSACTION
                     3 Query       SELECT passwd FROM dbmail_users WHERE 
userid                                               = 'aglait'
                     3 Query       SELECT passwd FROM dbmail_users WHERE 
userid                                               = 'aglait'
                     3 Query       COMMIT
                     3 Quit
                     4 Connect     dbmail at localhost on dbmail
                     4 Quit
050908 15:26:02       5 Connect     dbmail at localhost on dbmail

and
Sep  8 15:24:44 mx2 postfix/smtpd[11502]: sql auxprop plugin using mysql 
engine
Sep  8 15:25:19 mx2 postfix/smtpd[11502]: sql plugin Parse the username 
aglait
Sep  8 15:25:19 mx2 postfix/smtpd[11502]: sql plugin try and connect to 
a host
Sep  8 15:25:19 mx2 postfix/smtpd[11502]: sql plugin trying to open db 
'dbmail' on host 'localhost'
Sep  8 15:25:19 mx2 postfix/smtpd[11502]: sql plugin Parse the username 
aglait
Sep  8 15:25:19 mx2 postfix/smtpd[11502]: sql plugin try and connect to 
a host
Sep  8 15:25:19 mx2 postfix/smtpd[11502]: sql plugin trying to open db 
'dbmail' on host 'localhost'
Sep  8 15:25:19 mx2 postfix/smtpd[11502]: sql plugin Parse the username 
aglait
Sep  8 15:25:19 mx2 postfix/smtpd[11502]: sql plugin try and connect to 
a host
Sep  8 15:25:19 mx2 postfix/smtpd[11502]: sql plugin trying to open db 
'dbmail' on host 'localhost'
Sep  8 15:25:19 mx2 postfix/smtpd[11502]: begin transaction
Sep  8 15:25:19 mx2 postfix/smtpd[11502]: sql plugin create statement 
from userPassword aglait mx2.renatre.org.ar
Sep  8 15:25:19 mx2 postfix/smtpd[11502]: sql plugin doing query SELECT 
passwd FROM dbmail_users WHERE userid = 'aglait';
Sep  8 15:25:19 mx2 postfix/smtpd[11502]: sql plugin create statement 
from cmusaslsecretPLAIN aglait mx2.renatre.org.ar
Sep  8 15:25:19 mx2 postfix/smtpd[11502]: sql plugin doing query SELECT 
passwd FROM dbmail_users WHERE userid = 'aglait';
Sep  8 15:25:19 mx2 postfix/smtpd[11502]: commit transaction
Sep  8 15:25:19 mx2 postfix/smtpd[11502]: sql plugin Parse the username 
aglait
Sep  8 15:25:19 mx2 postfix/smtpd[11502]: sql plugin try and connect to 
a host
Sep  8 15:25:19 mx2 postfix/smtpd[11502]: sql plugin trying to open db 
'dbmail' on host 'localhost'
Sep  8 15:26:02 mx2 postfix/smtpd[11506]: sql auxprop plugin using mysql 
engine

I dont see it comparing passwords ....

Alexander Dalloz wrote:

> Am Do, den 08.09.2005 schrieb Alan Glait um 18:41:
>
>  
>
>> I will send you a gift for all your help ;)
>> I have /usr/local/lib/sasl2/smtpd.conf with
>>
>> pwcheck_method: auxprop
>> auxprop_plugin: sql
>> sql_engine: mysql
>> mech_list: PLAIN LOGIN
>> sql_hostnames: localhost
>> sql_user:
>> sql_passwd:
>>   
>
>
> The user and his password to query the MySQL database should be added.
>
>  
>
>> sql_database: dbmail
>> sql_verbose: yes
>> sql_select: SELECT passwd FROM dbmail_users WHERE userid = '%u'
>>   
>
>
> Looks correct so far.
>
>  
>
>> so ... I have to start saslatuh.sh ?? How I use it and test it ?? I 
>> have to add log_level in this file ?
>>   
>
>
> No, saslauthd is the alternate to using auxprop. Means, either one or
> the other - both have different capabilities. Running auxprop auth you
> don't need to run / start saslauthd. The smtpd.conf will be simply read
> in by Postfix.
>
> log_level: 6
>
> will cause SASL to log traces of internal protocols. In addition
> saslfinger
>
> http://postfix.state-of-mind.de/patrick.koetter/saslfinger/
>
> may be of help to see whether your SASL setup is as you like it to be.
>
> Alexander
>
>
>  
>