[OGo-Users] Ogo + Cyrus + SASL + PAM

Mark Pavlichuk users@opengroupware.org
Thu, 14 Jun 2007 16:31:22 +1000


 I'm experimenting with getting Cyrus to authenticate against 
Ogo/PostgreSQL via SASL/PAM.

 My /etc/pam_pgsql.conf is as follows :

database = ogo
host = localhost
user = ogo
password = ********
table = person
user_column = login
pwd_column = password
pwd_type = crypt

 I'm using the password in 
/etc/opengroupware.org/ogo/Defaults/NSGlobalDomain.plist.
Is this correct?

 I noticed that Adam Tauno Williams wrote an email in November on this, 
and it seems
he was using a custom database view.  Is this required rather than 
simply using the person
table?

 In my case :

testsaslauthd -u markp -p my_password -s imap

  ...with the /etc/pam.d/imap file configured :

auth       required   pam_pgsql.so   debug
account   required   pam_pgsql.so   debug

 ...returns :

0: NO "authentication failed"

  I don't get any useful information (or anything logged at all) in 
/var/log/syslog or messages.
Any ideas on how I could troubleshoot?

-Mark