[Dovecot] Dovecot fails after updating MySQL

[Bradley Giesbrecht]

On Jan 10, 2011, at 4:19 PM, Jerry wrote:

> I just updated MySQL to Server version: 5.5.8 on my FreeBSD-8.2  
> system.
> Now Dovecot refuses to run. Prior to this, dovecot had been running  
> for several
> years without a problem.
>
> This is the output of "dovecot -n"
>
> # 1.2.16: /usr/local/etc/dovecot.conf
> # OS: FreeBSD 8.2-PRERELEASE amd64  ufs
> log_path: /var/log/dovecot.log
> login_dir: /var/run/dovecot/login
> login_executable: /usr/local/libexec/dovecot/imap-login
> verbose_proctitle: yes
> first_valid_uid: 1000
> first_valid_gid: 1000
> mail_privileged_group: mail
> mail_location: maildir:/var/mail/vhost/seibercom.net/gerard
> mail_plugins: expire
> imap_client_workarounds: delay-newmail netscape-eoh tb-extra-mailbox- 
> sep
> lda:
>  postmaster_address: postmaster at seibercom.net
>  mail_plugins: sieve
>  sieve_global_path: /usr/local/etc/dovecot/sieve/gerard.sieve
>  sendmail_path: /usr/sbin/sendmail
> auth default:
>  mechanisms: plain login digest-md5 cram-md5
>  username_format: %Lu
>  verbose: yes
>  debug: yes
>  debug_passwords: yes
>  passdb:
>    driver: sql
>    args: /usr/local/etc/dovecot-sql.conf
>  userdb:
>    driver: sql
>    args: /usr/local/etc/dovecot-sql.conf
>  socket:
>    type: listen
>    client:
>      path: /var/run/dovecot/auth-client
>      mode: 432
>    master:
>      path: /var/run/dovecot/auth-master
>      mode: 384
>      user: vmail
>      group: vmail
> plugin:
>  expire: Trash 2 Spam/* 2
>  expire_dict: proxy::expire
> dict:
>  expire: mysql:/usr/local/etc/dovecot-dict-expire.conf
>
> The /var/run/dovecot directory looks like this:
>
> drwxr-xr-x   3 root   wheel     512B 2011-01-10 18:49:44 EST ./
> drwxr-xr-x  15 root   wheel     1.0K 2011-01-10 18:49:37 EST ../
> srw-rw----   1 root   wheel       0B 2011-01-10 18:49:37 EST auth- 
> client=
> srw-------   1 vmail  vmail       0B 2011-01-10 18:49:37 EST auth- 
> master=
> srw-------   1 root   wheel       0B 2011-01-10 18:49:37 EST auth- 
> worker.34781=
> srwxrwxrwx   1 root   wheel       0B 2011-01-10 18:49:37 EST dict- 
> server=
> lrwx------   1 root   wheel      27B 2011-01-10 18:49:37 EST
> dovecot.conf@ -> /usr/local/etc/dovecot.conf
> drwxr-x---   2 root   dovecot   512B 2011-01-10 18:49:37 EST login/
> -rw-------   1 root   wheel       6B 2011-01-10 18:49:37 EST  
> master.pid
>
> This is the log file output, updated every second (snippet)
>
> Jan 10 18:42:11 dovecot: Info: Dovecot v1.2.16 starting up
> Jan 10 18:42:11 dovecot: Error: child 34517 (auth-worker) killed with
> signal 11 (core not dumped)
> Jan 10 18:42:11 dovecot: Error: child 34521 (auth-worker) killed with
> signal 11 (core not dumped)
>
> I have tried deleting and rebuilding dovecot without success. I am  
> at a
> lose to figure out what the problem is.


What version of mysql were you at before?

Do your mysql logs reveal anything?

Have you turned on mysql query logging?

Can you run the /usr/local/etc/dovecot-sql.conf queries in a mysql  
client successfully?

--
Brad