[Dovecot] Dovecot fails after updating MySQL
Bradley Giesbrecht
bradley.giesbrecht at gmail.com
Tue Jan 11 02:54:39 EET 2011
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
More information about the dovecot
mailing list