Correction. The second fetchmail resulted in: May 1 18:58:17 freebsd pop3d[89249]: badlogin: localhost[::1] plaintext dom0001 cannot select MySQL database
As well as the first one! So, this seems to be a cyrus/mysql issue. Regards, Dustin At 09:48 PM 5/1/2002 -0500, you wrote: >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 <[EMAIL PROTECTED]> 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@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 <[EMAIL PROTECTED]> 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@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 <[EMAIL PROTECTED]> >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 --- Dustin Puryear <[EMAIL PROTECTED]> 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
