Skip to content

Add column disableindexer-worker in mail_user

Hi!

Adding dovecot_solr currently throws errors because of a missing column. Found the solution here: http://www.marshut.com/irvyzz/fts-solr-body-search-gives-mysql-error.html#iryuzw

Add the column disableindexer-worker enum('n','y') default 'n' in the table "mail_user".

Edit dovecot-sql.conf (add backticks around "disable%Ls"):

user_query = SELECT email as user, maildir as home, CONCAT('maildir:', maildir, '/Maildir') as mail, uid, gid, CONCAT('*:storage=', quota, 'B') AS quota_rule, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE (login = '%u' OR email = '%u') AND disable%Ls = 'n'

Also see http://www.howtoforge.com/forums/showthread.php?t=65463