Hi I am wanting to install : dovecot 1.0-stable I currently have dovecot 0.99.11-1 which came packaged on Fedora Core 3 It is doing auth off a MySQL db an working well I have downloaded the latest stable tarball and extracted ... I don't see how to enable mysql lookups at compile time... Help please ... I am getting a lot of pressure from the people at work ... Regards Andrew Andrew Gargan Developer Interface Media (PTY) Ltd. Tel: 011 507 3003 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://dovecot.org/pipermail/dovecot/attachments/20050728/152e1d4c/attachment-0002.html>
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Andrew Gargan <andrew at iface.co.za> wrote:> Hi > > I am wanting to install : dovecot 1.0-stable > > I currently have dovecot 0.99.11-1 which came packaged on Fedora Core 3 > > It is doing auth off a MySQL db an working well > > I have downloaded the latest stable tarball and extracted ... I don't > see how to enable mysql lookups at compile time...If you look at configure --help, you'll spy the --with-mysql flag for configure. That should do it. Thanks, - -- Brett Parker web: http://www.sommitrealweird.co.uk/ email: iDunno at sommitrealweird.co.uk -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFC6MBBEh8oWxevnjQRAn9hAJ9oFCJZ65vLujZui81LZuZuhRw+zACgl4ZT 5WdKeITFldpZz0Bi72bbdSQ=vsC5 -----END PGP SIGNATURE-----
I've just managed to get dovecot to install on one of our FreeBSD 5.4 servers, using the ports collection. I've set up dovecot to query the mysql database I'm using, and the query I'm using is: SELECT clear AS password FROM users LEFT JOIN domains ON domains.domain_id = users.domain_id WHERE domain="%d" AND username="%d" AND users.enabled = 1 AND domains.enabled = 1 If I perform this query by hand, I get a single row with the field 'password' which contains the password I'm using the perform my intial test. However, dovecot won't authenticate, and returns this error: dovecot-auth: mysql(justin at redwiredesign.co.uk): Password mismatch Is there a way that I can see how dovecot's doing the comparison? I have set the following in dovecot.conf: auth_verbose = yes auth_debug = yes I've read the wiki on raw logging, but I don't know: (a) how to enable this through the port (b) whether this is even applicable as apparently all it logs is the imap traffic. Any suggestions? j. Redwire Design Limited Studio 12 37 Tanner Street London SE1 3LF [ www.redwiredesign.com ] [ 020 7403 1444 ] - voice [ 020 7378 8711 ] - fax
I hadn't set the default_pass_scheme. Thanks for pointing that out! j. -----Original Message----- From: dovecot-bounces at dovecot.org [mailto:dovecot-bounces at dovecot.org] On Behalf Of Timo Sirainen Sent: 15 August 2005 10:11 To: Justin Finkelstein Cc: dovecot at dovecot.org Subject: Re: [Dovecot] mysql authentication On 15.8.2005, at 11:33, Justin Finkelstein wrote:> SELECT clear AS password FROM users LEFT JOIN domains ON > domains.domain_id = users.domain_id WHERE domain="%d" AND > username="%d" AND users.enabled = 1 AND domains.enabled = 1So the password is in cleartext? Have you changed default_pass_scheme to plain?> dovecot-auth: mysql(justin at redwiredesign.co.uk): Password mismatch > > Is there a way that I can see how dovecot's doing the comparison? I > have set the following in dovecot.conf:No. I think it's maybe a bit too much to log passwords.. It's usually just that the scheme is wrong anyway.> I've read the wiki on raw logging, but I don't know: (a) how to enable > this through the port (b) whether this is even applicable as > apparently all it > logs is the imap traffic.Rawlog isn't able to log preauthentication traffic.