consultant help for cyrus pam_mysql (and exim)

[Roland Baum]

Ouuargl... Pam with Exim... with MySQL backend'ed...

I don't prefer this combination because... likely a lack of flexibility..

On my systems, a combination of Exim, Cyrus & PostgreSQL is running 
since nearly 3 years without any problem.s
Exim gets his router-information (target mailboxes, aliases, auth-data 
for SMTP-authentication) of "manged domains" directly from PostgreSQL 
and delivers them through lmtp.
Cyrus - on the other side - gets his authentication-data for mailboxes 
from the same database.

All in one it runs very fine and i don't need to fiddle around PAM-stuff 
configuration and
needed sql-statemens are fitted on my individual needs in configuration.


Just contact me, if you're interested in. I'll send you all neccessary 
files.


greeZ

roland


jerry at cockatoos.com schrieb:
> 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
>
> ----
> Cyrus Home Page: http://cyrusimap.web.cmu.edu/
> Cyrus Wiki/FAQ: http://cyrusimap.web.cmu.edu/twiki
> List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html
>