Hello, I am trying to run dovecot on my Linux. I am using an exim 3.30 as the MTA with vmail-sql virtual users. I have installed latest dovecot release and ran through the config file. Some options seemed unclear to me, but generally I think it is OK. The problem is, that MySQL authentication does not work. It even does not try to authenticate! Dovecot connects correctly with MySQL database, but then no activity is shown in MySQL logs - but when I try to login manually with the telnet, i get: [root at mainframe root]# telnet localhost 143 Trying 127.0.0.1.143... Connected to localhost. Escape character is '^]'. * OK dovecot ready. 1 login [my_email] [my_password] 1 NO Authentication failed. Maybe I am doing something wrong? I have spent two days with this problem, even modifying source files could not help me localize the source of my troubles :( Here are the important (I think) entries from /etc/dovecot/dovecot.conf: ------- # Authentication process name. auth = default # Space separated list of wanted authentication mechanisms: # plain digest-md5 anonymous auth_mechanisms = plain auth_userdb = mysql /etc/dovecot/dovecot-mysql.conf auth_passdb = mysql /etc/dovecot/dovecot-mysql.conf ------- Any suggestions? Best regards, -- Jacek Osiecki joshua at ceti.pl Poland
On 6.9.2004, at 11:04, Jacek Osiecki wrote:> The problem is, that MySQL authentication does not work. It even does > not > try to authenticate! Dovecot connects correctly with MySQL database, > but > then no activity is shown in MySQL logs - but when I try to login > manually > with the telnet, i get:Try setting auth_verbose = yes, and with 0.99.11 even auth_debug = yes if it didn't help. Those should give enough information about the problem. -------------- next part -------------- A non-text attachment was scrubbed... Name: PGP.sig Type: application/pgp-signature Size: 186 bytes Desc: This is a digitally signed message part URL: <http://dovecot.org/pipermail/dovecot/attachments/20040906/5077d758/attachment-0001.bin>
On Mon, 6 Sep 2004, Timo Sirainen wrote:> On 6.9.2004, at 11:04, Jacek Osiecki wrote:>> The problem is, that MySQL authentication does not work. It even does not >> try to authenticate! Dovecot connects correctly with MySQL database, but >> then no activity is shown in MySQL logs - but when I try to login manually >> with the telnet, i get:> Try setting auth_verbose = yes, and with 0.99.11 even auth_debug = yes if it > didn't help. Those should give enough information about the problem.Thanks for help. I have downloaded 0.99.11 for better debugging and enabled both options. However, it did not help: I am getting the "NO Authentication failed." answer, and the log files still give no further details: dovecot: Sep 06 11:00:49 Info: Dovecot starting up dovecot-auth: Sep 06 11:00:50 Info: MySQL: connected to localhost dovecot-auth: Sep 06 11:00:50 Info: Login process 8 connected dovecot-auth: Sep 06 11:00:50 Info: Login process 9 connected dovecot-auth: Sep 06 11:00:50 Info: Login process 8 sent handshake: PID 6544 dovecot-auth: Sep 06 11:00:50 Info: Login process 9 sent handshake: PID 6545 dovecot-auth: Sep 06 11:00:50 Info: Login process 10 connected dovecot-auth: Sep 06 11:00:50 Info: Login process 10 sent handshake: PID 6547 imap-login: Sep 06 11:00:55 Info: Disconnected [127.0.0.1] dovecot-auth: Sep 06 11:00:55 Info: Login process 9 disconnected dovecot-auth: Sep 06 11:00:55 Info: Login process 9 connected dovecot-auth: Sep 06 11:00:55 Info: Login process 9 sent handshake: PID 6552 Still looking forward for help :) Maybe someone could send me the conf file from working configuration, so I could check whether I have set something wrong? Best regards, -- Jacek Osiecki joshua at ceti.pl Poland
Jacek Osiecki wrote:> I have installed latest dovecot release and ran through the config file. > Some options seemed unclear to me, but generally I think it is OK. > > The problem is, that MySQL authentication does not work.[...]> auth_userdb = mysql /etc/dovecot/dovecot-mysql.conf > auth_passdb = mysql /etc/dovecot/dovecot-mysql.confIn addition to what Timo suggested, I'd recommend first trying to get logins to work using more traditional user and password databases (i.e. /etc/passwd). Otherwise you end up debugging general configuration problems at the same time as SQL database configuration problems. (My yet to be completed Dovecot-MySQL HOWTO will include this tip.) -Tom