Hi, i had created the file /etc/pam.d/imap with the following entries: auth sufficient pam_mysql.so user=mail passwd=secret host=localhost db=mail table=accountuser usercolumn=username passwdcolumn=password crypt=1 logtable=log logmsgcolumn=msg logusercolumn=user loghostcolumn=host logpidcolumn=pid logtimecolumn=time
account required pam_mysql.so user=mail passwd=secret host=localhost db=mail table=accountuser usercolumn=username passwdcolumn=password crypt=1 logtable=log logmsgcolumn=msg logusercolumn=user loghostcolumn=host logpidcolumn=pid logtimecolumn=time And i have also posted this Problem in the web-cyradm list with the hope to get the answers i need. Thanks, Evil --- [EMAIL PROTECTED] schrieb: > Hi, > > First of all try to post this question to web-cyradm > list, I'm too on their list and if you have further > questions we'll try to help you. > > It may be related to creation of the file > /etc/pam.d/imap with the following entries: > ---------------------------------------------- > #%PAM-1.0 > auth sufficient pam_mysql.so user=mail passwd=secret > host=localhost db=mail table=accountuser > usercolumn=username passwdcolumn=password crypt=1 > logtable=log logmsgcolumn=msg logusercolumn=user > loghostcolumn=host logpidcolumn=pid > logtimecolumn=time sqllog=yes > > # auth sufficient pam_unix_auth.so > > account required pam_mysql.so user=mail > passwd=secret host=localhost db=mail > table=accountuser usercolumn=username > passwdcolumn=password crypt=1 logtable=log > logmsgcolumn=msg logusercolumn=user > loghostcolumn=host logpidcolumn=pid > logtimecolumn=time > > # account sufficient pam_unix_acct.so > --------------------------------------------- > > Regards, > Leon Kolchinsky > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of evildad > Sent: Sunday, September 25, 2005 10:31 PM > To: info-cyrus@lists.andrew.cmu.edu > Subject: Cyrus Imap Authentication Problems > > HI there, > i'd like to set-up an working IMAP Server on my > Gentoo System. I used the > Postfix-Cyrus-Web-cyradm-HOWTO from > http://www.delouw.ch/linux/Postfix-Cyrus-Web-cyradm-HOWTO/html/index.html > > Because I use Gentoo, I compiled all the packages > with the âemergeâ command. Here are the versions > for my installed packages: > > cyrus-sasl-2.1.21-r1 > cyrus-imapd-2.2.12 > postfix-2.1.5-r2 > pam_mysql-0.6.0 > mysql-4.0.25-r2 > web-cyradm-0.5.4.1 > > > They all compiled without errors but after i wanted > to create the user cyrus with the command > > # saslpasswd2 -c cyrus > Password: > Again (for verification): > > > ... the following errors appear in > /var/log/messages: > > Sep 25 17:21:01 evildad saslpasswd2: sql_select > option missing Sep 25 17:21:01 evildad saslpasswd2: > auxpropfunc error no mechanism available Sep 25 > 17:21:01 evildad saslpasswd2: _sasl_plugin_load > failed on sasl_auxprop_plug_init for plugin: sql Sep > 25 17:21:05 evildad saslpasswd2: setpass succeeded > for cyrus Sep 25 17:21:05 evildad saslpasswd2: error > deleting entry from sasldb: DB_NOTFOUND: No matching > key/data pair found Sep 25 17:21:05 evildad > saslpasswd2: error deleting entry from sasldb: > DB_NOTFOUND: No matching key/data pair found Sep 25 > 17:21:05 evildad saslpasswd2: error deleting entry > from sasldb: DB_NOTFOUND: No matching key/data pair > found > > > I don't understand why sasl won't find the DB. > > Another Problem is the command to connect to the > Server. > > When i type in the following command to the Server I > get the following output: > > # cyradm --user cyrus --server localhost --auth > plain > Password: > IMAP Password: > Login failed: authentication failure > at > /usr/lib/perl5/site_perl/5.8.6/x86_64-linux/Cyrus/IMAP/Admin.pm > line 118 > cyradm: cannot authenticate to server with plain as > cyrus > > > and in /var/log/messages: > > Sep 25 21:18:26 evildad master[7102]: about to exec > /usr/lib/cyrus/imapd Sep 25 21:18:26 evildad > imap[7102]: executed Sep 25 21:18:26 evildad > imap[7102]: sql auxprop plugin using mysql engine > Sep 25 21:18:26 evildad imap[7102]: accepted > connection Sep 25 21:18:37 evildad imap[7102]: > badlogin: > localhost [127.0.0.1] PLAIN [SASL(-16): encryption > needed to use mechanism: security flags do not match > required] Sep 25 21:18:40 evildad perl: No worthy > mechs found Sep 25 21:18:44 evildad imap[7102]: sql > plugin Parse the username cyrus Sep 25 21:18:44 > evildad imap[7102]: sql plugin try and connect to a > host Sep 25 21:18:44 evildad imap[7102]: sql plugin > trying to open db 'mail' on host 'localhost' > Sep 25 21:18:44 evildad imap[7102]: sql plugin Parse > the username cyrus Sep 25 21:18:44 evildad > imap[7102]: sql plugin try and connect to a host Sep > 25 21:18:44 evildad imap[7102]: sql plugin trying to > open db 'mail' on host 'localhost' > Sep 25 21:18:44 evildad saslauthd[6930]: DEBUG: > auth_pam: pam_acct_mgmt failed: User account has > expired > Sep 25 21:18:44 evildad saslauthd[6930]: do_auth > > : auth failure: [user=cyrus] [service=imap] > [realm=] [mech=pam] [reason=PAM acct error] Sep 25 > 21:18:44 evildad imap[7102]: badlogin: > localhost [127.0.0.1] plaintext cyrus SASL(-13): > authentication failure: checkpass failed Sep 25 > 21:19:47 evildad master[20809]: process 7102 exited, > status 0 > > > Hope anyone can help me to get the authentication > work... > And i don't know why the User account has been > expired though it has never worked before... > > Thanks in advance, > Evildad > > > > > > ___________________________________________________________ > > Was denken Sie über E-Mail? Wir hören auf Ihre > Meinung: > http://surveylink.yahoo.com/wix/p0379378.aspx > ---- > Cyrus Home Page: http://asg.web.cmu.edu/cyrus > Cyrus Wiki/FAQ: http://cyruswiki.andrew.cmu.edu > List Archives/Info: > http://asg.web.cmu.edu/cyrus/mailing-list.html > ___________________________________________________________ Gesendet von Yahoo! Mail - Jetzt mit 1GB Speicher kostenlos - Hier anmelden: http://mail.yahoo.de ---- Cyrus Home Page: http://asg.web.cmu.edu/cyrus Cyrus Wiki/FAQ: http://cyruswiki.andrew.cmu.edu List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html