Am Mittwoch, 26. Mai 2004 23:56 schrieb Peter Duda: > I am new to this whole cyrus thing, but I am trying to learn. > > RedHat 9.0 > Cyrus 2.2.3-8 > Cyrus SASL 2.1.18 > Postfix > Mysql 3.23.58 > > I sort of had everything working so far by myself and a lot of Googleing > > :). But now I am having a difficult time getting the authentication to > > work properly. Web-cyradm works fine and sees all the cyrus info in the > mysql database, but I cannot connect to cyrus through other means: > imtest gives > > S: L01 NO Login failed: user not found > Authentication failed. generic failure > Security strength factor: 0 > C: Q01 LOGOUT > Connection closed. > > use not found shows up when I try and connect through evolution or OGo, > etc. > > I know the user is there because I can see them in web-cyradm > > I have tried multiple imapd.conf files including the HOWTO with > pam_mysql etc, but that didn't work. > > /var/log/messages gives a lot of these > > Flashy pop3[11789]: sql_select option missing > Flashy pop3s[11790]: auxpropfunc error no mechanism available > > I have tried auth with auxprop but it's not working either: > this was the imapd.conf file > > configdirectory: /var/lib/imap > partition-default: /var/spool/imap > admins: cyrus root > allowplaintext: yes > sievedir: /var/lib/imap/sieve > sendmail: /usr/sbin/sendmail > hashimapspool: true > tls_cert_file: /usr/share/ssl/certs/cyrus-imapd.pem > tls_key_file: /usr/share/ssl/certs/cyrus-imapd.pem > tls_ca_file: /usr/share/ssl/certs/ca-bundle.ca > pwcheck_method: auxprop > auxprop_plugin: sql > sql_engine: mysql > mech_list: login plain > sql_hostnames: localhost > sql_user: user > sql_passwd: password > sql_database: mail > sql_verbose: yes > sql_select: SELECT password FROM accountuser WHERE username = '[EMAIL PROTECTED]'
All sasl-options in imapd.conf begin with "sasl_". sasl_pwcheck_method: auxprop sasl_auxprop_plugin: sql sasl_sql_engine: mysql ... ... > /var/log/messages gives more of these: > > pop3[11465]: sql_select option missing > pop3[11465]: auxpropfunc error no mechanism available > pop3[11465]: unable to open Berkeley db /etc/sasldb2: Permission denied > > > the closest i came was when my imapd.conf looked like this: > > configdirectory: /var/lib/imap > partition-default: /var/spool/imap > admins: cyrus root > allowplaintext: yes > sievedir: /var/lib/imap/sieve > sendmail: /usr/sbin/sendmail > hashimapspool: true > pwcheck_method: saslauthd > sasl_mech_list: PLAIN > sasl_sql_engine: mysql > sasl_sql_hostnames: localhost > sasl_sql_user: user > sasl_sql_passwd: password > sasl_database: mail > sasl_sql_select: select password from accountuser where username = '%u' > tls_cert_file: /usr/share/ssl/certs/cyrus-imapd.pem > tls_key_file: /usr/share/ssl/certs/cyrus-imapd.pem > tls_ca_file: /usr/share/ssl/certs/ca-bundle.ca > > /var/log/messages doesnt give any errors upon startup, but when you try > and login then: > > Flashy imap[11940]: sql plugin could not connect to host localhost > Flashy imap[11940]: sql plugin couldn't connect to any host > Flashy imap[11940]: unable to open Berkeley db /etc/sasldb2: Permission > denied > > Now I used to just get the plugin error and not the Berkeley db error > and when that was happening I could login under the admins, but it > wouldn't work with a user - it still wasn't querying the mysql > database. But with all the changes now I can't open the Berkeley db > which put me a step backwards. > > Can someone point me in the right direction? I am really new to all of > this so forgive my rambling, but I would like to get this working > > Peter > > > > > > > > > > > > > > --- > 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 -- Andreas --- 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
