newbie authentication problem

[Andreas Winkelmann]

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 = '%u@%r'

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