Hi,
I'm running a mixed Debian Woody/Sarge system with Dovecot version:
(0.99.12-1)
I can't seem to be able to get dovecot working with mysql. It seems to
authenticate
successfully then crash. This happens when I use the Debian package and
also when I've compiled from source.
dovecot: Jan 06 12:21:14 Info: Dovecot starting up
dovecot-auth: Jan 06 12:21:15 Info: MySQL: connected to localhost
dovecot-auth: Jan 06 12:21:15 Info: Login process 8 connected
dovecot-auth: Jan 06 12:21:15 Info: Login process 8 sent handshake: PID
11587
dovecot-auth: Jan 06 12:21:16 Info: Login process 9 connected
dovecot-auth: Jan 06 12:21:16 Info: Login process 9 sent handshake: PID
11589
dovecot-auth: Jan 06 12:21:17 Info: Login process 10 connected
dovecot-auth: Jan 06 12:21:17 Info: Login process 10 sent handshake: PID
11590
dovecot-auth: Jan 06 12:21:32 Info: MySQL: Performing query: SELECT
substring(password_hash, 6) AS password FROM popbox WHERE local_part
'donovan' AND domain_name = 'somedomain.com'
dovecot: Jan 06 12:21:32 Error: login: Authentication process 11585
doesn't exist
imap-login: Jan 06 12:21:32 Info: Internal login failure:
donovan at somedomain.com [127.0.0.1]
dovecot: Jan 06 12:21:32 Error: child 11585 (auth) killed with signal 11
dovecot-auth: Jan 06 12:21:32 Info: MySQL: connected to localhost
dovecot-auth: Jan 06 12:21:33 Info: Login process 8 connected
dovecot-auth: Jan 06 12:21:33 Info: Login process 8 sent handshake: PID
11587
dovecot-auth: Jan 06 12:21:33 Info: Login process 9 connected
dovecot-auth: Jan 06 12:21:33 Info: Login process 9 sent handshake: PID
11589
dovecot-auth: Jan 06 12:21:33 Info: Login process 10 connected
dovecot-auth: Jan 06 12:21:33 Info: Login process 10 sent handshake: PID
11590
----
Core was generated by `dovecot-auth'.
Program terminated with signal 11, Segmentation fault.
#0 0x402c0284 in mallopt () from /lib/libc.so.6
dovecot.conf
base_dir = /var/run/dovecot
# Protocols we want to be serving:
# imap imaps pop3 pop3s
protocols = imap
disable_plaintext_auth = no
log_path = /var/log/dovecot.log
info_log_path = /var/log/dovecot.log
login_chroot = no
login = imap
login_user = dovecot
login_process_per_connection = no
login = pop3
first_valid_uid = 20
mail_extra_groups = vmail
default_mail_env client_workarounds = outlook-idle outlook-pop3-no-nuls
mail_drop_priv_before_exec = no
auth = default
auth_mechanisms = plain
auth_userdb = mysql /usr/local/etc/dovecot-mysql.conf
auth_passdb = mysql /usr/local/etc/dovecot-mysql.conf
auth_user = root
auth_verbose = yes
auth_debug = yes
dovecot-mysql.conf
db_host = localhost
db_port = 3306
# db_unix_socket = /var/tmp/mysql.sock
db_unix_socket = /var/run/mysqld/mysqld.sock
db = vmail
db_user = vmail
db_passwd = xxxxx
db_client_flags = 0
# Default password scheme.
#
# Currently supported schemes include PLAIN, PLAIN-MD5, DIGEST-MD5, and
# CRYPT.
#
default_pass_scheme = PLAIN-MD5
# Query to retrieve the password.
#
# The query should return one row, one column. If more than one row or
# column
# is returned, authentication will automatically fail.
#
password_query = SELECT substring(password_hash, 6) AS password FROM
popbox WHERE local_part = '%n' AND domain_name = '%d'
# user_query = SELECT CONCAT('maildir:',domain.path,'/',
# popbox.mbox_name) AS home, '508' AS uid, '508' AS gid FROM
popbox,
# domain WHERE popbox.local_part = '%n' AND popbox.domain_name =
'%d'
# AND popbox.domain_name = domain.domain_name
user_query = SELECT CONCAT(domain.path,'/', popbox.mbox_name) AS home,
'508' AS uid, '508' AS gid FROM popbox, domain WHERE
popbox.local_part '%n' AND popbox.domain_name = '%d' AND
popbox.domain_name domain.domain_name
Any ideas?
The spool directories are maildir and are set with 700 permissions as
508.508 (vmail).
Regards,
Donovan
Donovan Craig
Go4 Multimedia
Phone : +61 3 95 306 658
Fax : +61 3 95 306 435
Mobile : 0414 666 518
Web : http://www.go4.com.au/
14B Warleigh Grv, Brighton VIC 3186
GnuPG Key : http://bilby.snapfrozen.com/gpg/dcraig.asc
Fingerprint: 3E73 E01A D24F 3737 9427 58A7 90F4 9671 ADAB CA76
"Well, let's just say, 'if your VCR is still blinking 12:00, you
don't
want Linux'".
--- Bruce Perens, Debian's Fearless Leader
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20050106/7a535acb/attachment-0001.bin>