Hi! I added solr for dovecot (tomcat) on my Debian system with ISPConfig 3.0.5.3: dovecot.conf Code: mail_plugins = $mail_plugins fts fts_solr protocol imap { mail_plugins = quota imap_quota fts fts_solr } plugin { quota = dict:user::file:/var/vmail/%d/%n/.quotausage sieve=/var/vmail/%d/%n/.sieve fts = solr fts_solr = break-imap-search url=http://localhost:8983/solr/ # fts_autoindex = yes } Search worked fine for me, but executing a search or "doveadm index …" threw errors: Code: server dovecot: auth-worker(28077): Error: sql([email protected]): User query failed: Unknown column 'disableindexer' in 'where clause' server dovecot: indexer-worker: Error: user [email protected]: Auth USER lookup failed server dovecot: indexer-worker: Error: User [email protected] lookup failed: Internal error occurred. Refer to server log for more information. I did some search and realized that ISPconfig probably is missing a column (solution not found by myself but on the linked site): http://www.marshut.com/irvyzz/fts-solr-body-search-gives-mysql-error.html#iryuzw I added the column `disableindexer-worker` enum('n','y') default 'n' in the table "mail_user" and edited the dovecot-sql.conf as follows (added backticks around "disable%Ls"): Code: 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' Will the column be removed when I update ISPConfig? Should I add a bug somewhere? Or a feature request? Or is this thread just enough? Thank you!
