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@xxxxxxxxxxxxx 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@xxxxxxxxx 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 > ---- 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
