From: david eitzinger (no email)
Date: Thu May 02 2002 - 05:26:43 EDT
Hello, Dustin !
I just wanted to let you know, that you're not alone. I've been using
cyrus+mysql for more than two years now. And I can tell you that it is
still confusing if I setup a new box and try to install the various
packages and patches that are needed in such a setup.
However right now I'm using the following constellation on our primary mx:
RedHat 6.2
MySQL-3.23.43-1
postfix-1.1.2-1
cyrus-imapd-sql-1.6.24-7
cyrus-sasl-1.5.21-8
On the backup mx, I use:
RedHat 7.1
mysql-3.23.36-1
postfix-1.1.3-1
cyrus-imapd-2.0.16-4
cyrus-sasl-1.5.24-17
pam_mysql-0.4.7-1
Both machines work very nice. The first one uses a patched version of
cyrus-imapd that authenticates against a MySQL database. Unfortunately
the maintainer switched to qmail and this package is now unsupported.
The constellation on the second server is indeed *very* cool since it
uses PAM to authenticate. However it also has its drawbacks as the 2.x
version of cyrus doesn't have a reconstruct -m command anymore, I cannot
use my old rsync-scripts to hold both servers in sync....
As I said, I just wanted to let you know that there are more people
using cyrus-mysql. And as I've seen, there were numerous threads on this
subject in this mailinglist, as it seems to be a very confusing story .
But I guess you've already searched the archives.
Cheers, David
On 05/02/2002 04:58 AM, Dustin Puryear wrote:
> 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 <>
>> 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
>
>
>
> ---
> 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
>
|
|
|