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

[Marc G. Fournier]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



- --On Monday, December 11, 2006 22:54:06 -0400 "Marc G. Fournier" 
<scrappy at hub.org> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> 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? :(

'k, think I just figured it out ... had virtdomain set to 1 .. changing it to 
userid seems to fix it .. will do more testing, but Ithink I have it ...

- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy at hub.org                              MSN . scrappy at hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (FreeBSD)

iD8DBQFFfjSU4QvfyHIvDvMRAhSIAJwPDS8LP+xNr6OBG6o7hTQCHom7XQCgh8R+
ozMbp3TxeAD2bwgZjXoX0Kw=
=rPPT
-----END PGP SIGNATURE-----