[Dovecot] Dovecot Crashing after MySQL Auth

['Donovan Craig']

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>