mysql auth via auxprop sql plugin broken in cvs version

Vladimir V. Kamarzin vvk at vvk.pp.ru
Tue Nov 11 06:45:23 EST 2008


Hi

I'm tried latest cvs version of cyrus sasl:
Author: murch <murch>
Date:   Tue Nov 4 18:40:46 2008 +0000
Message: can't have a connection-specific mech_list without a connection

As testcase i'm use postfix + mysql + cyrus-sasl:

# cat /etc/postfix/sasl/smtpd.conf
pwcheck_method: auxprop
mech_list: plain login
auxprop_plugin: sql
sql_engine: mysql
sql_hostnames: 127.0.0.1
sql_database: mail
sql_user: mail
sql_passwd: mail
sql_select: SELECT psw FROM users WHERE mail = '%u'
sql_usessl: no
log_level: 7

init.sql:
create database mail;
CREATE TABLE users ( 
mail varchar(128) NOT NULL default '', 
psw varchar(128) NOT NULL default '', 
enabled tinyint(4) NOT NULL default '1', 
PRIMARY KEY (mail) 
) TYPE=MyISAM;

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES ('test','parol',1);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

% telnet 192.168.203.13 25
Trying 192.168.203.13...
Connected to 192.168.203.13.
Escape character is '^]'.
220 ve116-postfix-stand.localdomain ESMTP Postfix
ehlo foo
250-ve116-postfix-stand.localdomain
250-PIPELINING
250-SIZE 10240000
250-ETRN
250-AUTH PLAIN LOGIN
250-ENHANCEDSTATUSCODES
250-8BITMIME
250 DSN
AUTH PLAIN AHRlc3QAcGFyb2w=
535 5.7.0 Error: authentication failed: authentication failure

In system logs i can't see something interesting, only
Nov 11 16:37:21 ve116-postfix-stand postfix/smtpd[1987]: warning: SASL authentication failure: Password verifica
tion failed
Nov 11 16:37:21 ve116-postfix-stand postfix/smtpd[1987]: warning: unknown[192.168.3.41]: SASL PLAIN authenticati
on failed: authentication failure

sql queries log:
081111 16:37:21      28 Connect     mail at localhost on mail
                     28 Quit


cvs version
Author: mel <mel>
Date:   Sun Oct 19 21:53:32 2008 +0000
Message: Corrected a comment

works fine with same settings. Any suggestions?

-- 
vvk



More information about the Cyrus-sasl mailing list