virtdomains + global admin + sql backend for sasl2 ... how?

Marc G. Fournier scrappy at
Mon Dec 11 21:54:06 EST 2006

Hash: SHA1

'k, I'm obviously missing something, cause its not working ...

I setup defaultdomain in imapd.conf to point to the domain, so now when I try 
to login, it shows:

plaintext cyrus SASL(-13): user not found: checkpass failed

and, in my sql backend, I have a user 'cyrus at domain', such that:

sasl_pwcheck_method: auxprop
auxprop_plugin: sql

sasl_sql_engine: mysql
sasl_sql_hostnames: localhost
sasl_sql_database: dtc
sasl_sql_user: dtcdaemons
sasl_sql_select: SELECT passwd FROM pop_access WHERE fullemail = '%u@%r'
sasl_sql_verbose: yes

> SELECT passwd FROM pop_access WHERE fullemail = 'cyrus at domain';
| passwd |
| cyrus  |
1 row in set (0.00 sec)

But I still get an auth-failed ...

And the sasl_sql_verbose setting doesn't appear to do anything, since I'm 
getting nadda in my log files that I can find :(

So, what's the magic I'm missing here to get it to work? :(

Thanks ...

- ----
Marc G. Fournier           Hub.Org Networking Services (
Email . scrappy at                              MSN . scrappy at
Yahoo . yscrappy               Skype:        ICQ . 7615664
Version: GnuPG v1.4.5 (FreeBSD)


More information about the Info-cyrus mailing list