consultant help for cyrus pam_mysql (and exim)

[jerry at cockatoos.com]

Hi,

Could someone please point me to a consultant to help with the final
configuration for a new server? A consulting system admin has had to give up
getting this running and I need it in within the day. This consultant
successfully did my last move, but had lots of issues. This time he decided
to use pam_mysql and now can't finish.

I can manage the migration, mysql, and cyrus management, but I have now
stuggle through google and the archives, but it is not working yet.

It is likely a configuration issue. 

As a desperate attempt, here is what we currently have in 
/etc/pam.d/imap

#%PAM-1.0
#auth       include      system-auth
#account    include      system-auth
#auth   required  pam_mysql.so  user=cyrus passwd=cypass host=127.0.0.1
db=email table=popusers passwdcolumn=password, concat(alias,'@
#account  required  pam_mysql.so  user=cyrus passwd=cypass host=127.0.0.1
db=email table=popusers passwdcolumn=password, concat(alias,
account required  pam_mysql.so  user=cyrus passwd=cypass host=127.0.0.1
db=email table=blah passwdcolumn=password usercolumn=username
auth  sufficient  pam_mysql.so  user=cyrus passwd=cypass host=127.0.0.1
db=email table=blah passwdcolumn=password usercolumn=username 

blah was just a test table to avoid the complication of the concat for alias
and domain.

imap.conf

configdirectory: /cyrus/imap
partition-default: /cyrus/spool/default
virtdomains: yes
#defaultdomain: nolet.com
servername: peekdate.nolet.com
unixhierarchysep: yes
defaultacl: lrswipcd
admins: cyrus at nolet.com cyrus
allowanonymouslogin: no
timeout: 400
plaintextloginpause: 0
quotawarn: 90
autocreatequota: 0
autocreateinboxfolders: no
singleinstancestore: yes
allowplaintext: yes
duplicatesuppression: no

sasl_pwcheck_method: saslauthd
sasl_mech_list: plain
## LOGIN CRAM-MD5 DIGEST-MD5

sieveusehomedir: false
sievedir: /data/sieve
sieve_maxscriptsize: 32
sieve_maxscripts: 5
anysievefolder: yes
partition-0: /cyrus/spool/0


Thanks, Jerry