[OGo-Users] Cyrus Authentication Via OGo

Adam Tauno Williams users@opengroupware.org
Mon, 13 Nov 2006 08:31:07 -0500


Does anyone have Cyrus IMAPd authenticating against the OGo database?
It appears this should be possible via either saslauthd and pam_pgsql or
using SQL auxprop.  Doesn't InstantOGo do this?

pam_pgsql appears to be deprecated, with no one working on it since
2001, and the documentation is seriously scant.  If anyone has an
example it would be great.

I'm trying to setup auxprop, but not having much luck:
sasl_mech_list: PLAIN
sasl_pwcheck_method: auxprop
sasl_sql_engine: pgsql
sasl_sql_hostnames: localhost
sasl_sql_user: OGo
sasl_sql_passwd: *******
sasl_sql_database: OGo
sasl_sql_select: select %p from sasl_users where login = '%u'
- and I created a view -
CREATE VIEW sasl_users (cmusaslsecretPLAIN, login) AS
SELECT password, login FROM person WHERE is_account = 1 AND password IS
NOT NULL;
- but I'm thinking that auxprop expects to find the password in the
clear (and not crypted).

Any pointers would be much appreciated.