From: Dustin Puryear (no email)
Date: Wed May 01 2002 - 22:48:21 EDT
Okay, one final try. Is anyone in the world that happens to be on this list
using mysql with cyrus? I can't be the only one. If you do exist, and I'm
happy to see that you do, I have cyrus compiled with mysql support.
Unfortunately, when I try to auth against Cyrus via POP3 or whatever I get
an error that Cyrus can't select the mysql database.
I have imapd.conf with:
sasl_pwcheck_method: mysql
sasl_mysqluser: mail
sasl_mysqlpasswd: secret
sasl_mysqlhost: localhost
sasl_mysqldatabase: mail
sasl_mysqltable: accountuser
sasl_mysqluidcol: username
sasl_mysqlpwcol: password
I've also verified that this information is correct:
freebsd# mysql -u mail -psecret \
? -e 'select username,password from accountuser' mail
+----------+----------+
| username | password |
+----------+----------+
| 0001 | password |
| dom0001 | password |
+----------+----------+
I didn't make any modifications to pam. Should this just work? If I try to
check my mail using:
freebsd# cat .fetchmailrc
poll localhost protocol pop3 username "dom0001" password "password"
With fetchmail I get:
May 1 18:50:11 freebsd pop3d[89212]: badlogin: localhost[::1] CRAM-MD5 no
secret in database
May 1 18:50:11 freebsd pop3d[89212]: badlogin: localhost[::1] plaintext
dom0001 cannot select MySQL database
The first line appears to be pop3d reporting that there is no md5 entry in
the sasl database. Also, notice the 'select MySQL database' issue. (The
fetchmail output is at the bottom of this mail, it's a bit long.) Now, if I
force password authentication I get:
freebsd# fetchmail --auth=password -vvv -c
fetchmail: 5.9.6 querying localhost (protocol POP3) at Wed May 1 18:53:08
2002: poll started
fetchmail: POP3< +OK <> Cyrus
POP3 v2.0.16 server ready
fetchmail: POP3> USER dom0001
fetchmail: POP3< +OK Name is a valid mailbox
fetchmail: POP3> PASS *
fetchmail: POP3< -ERR Invalid login
fetchmail: Invalid login
fetchmail: Authorization failure on dom0001 at localhost
fetchmail: POP3> QUIT
fetchmail: POP3< +OK
fetchmail: 5.9.6 querying localhost (protocol POP3) at Wed May 1 18:53:11
2002: poll completed
fetchmail: normal termination, status 3
But no errors via syslog.
In the first attempt, fetchmail reports:
freebsd# fetchmail -vvv -c
fetchmail: 5.9.6 querying localhost (protocol POP3) at Wed May 1 18:50:08
2002: poll started
fetchmail: POP3< +OK <> Cyrus
POP3 v2.0.16 server ready
fetchmail: POP3> CAPA
fetchmail: POP3< +OK List of capabilities follows
fetchmail: POP3< SASL DIGEST-MD5 CRAM-MD5
fetchmail: POP3< EXPIRE NEVER
fetchmail: POP3< LOGIN-DELAY 0
fetchmail: POP3< TOP
fetchmail: POP3< UIDL
fetchmail: POP3< PIPELINING
fetchmail: POP3< RESP-CODES
fetchmail: POP3< USER
fetchmail: POP3< IMPLEMENTATION Cyrus POP3 server v2.0.16
fetchmail: POP3< .
fetchmail: POP3> AUTH CRAM-MD5
fetchmail: POP3< + PDk3MjA5NDcuMTM2NjQxMDhAZnJlZWJzZC5kcGJveC5kaHMub3JnPg==
fetchmail: POP3> ZG9tMDAwMSA4MDA3ZjM0MDhjNmFjOTgzOWFiMjliNDk5NzNlN2I0NA==
fetchmail: POP3< -ERR authenticating: no secret in database
fetchmail: authenticating: no secret in database
fetchmail: POP3> USER dom0001
fetchmail: POP3< +OK Name is a valid mailbox
fetchmail: POP3> PASS *
fetchmail: POP3< -ERR Invalid login
fetchmail: Invalid login
fetchmail: Authorization failure on dom0001 at localhost
fetchmail: POP3> QUIT
fetchmail: POP3< +OK
fetchmail: 5.9.6 querying localhost (protocol POP3) at Wed May 1 18:50:14
2002: poll completed
fetchmail: normal termination, status 3
Am I doing something dumb here? I see that cyrus seems to be using native
mysql calls, so I assume I don't need to make any other modifications to my
system? What is going wrong? Any leads? Similar stories?
Regards, Dustin
--- Dustin Puryear <> UNIX and Network Consultant http://members.telocity.com/~dpuryear PGP Key available at http://www.us.pgp.net In the beginning the Universe was created. This has been widely regarded as a bad move. - Douglas Adams
|
|
|