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@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