dovecot: missing tables columns for solr

Discussion in 'General' started by bax, Apr 4, 2014.

  1. bax

    bax Member


    I added solr for dovecot (tomcat) on my Debian system with ISPConfig

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

    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):

    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"):

    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!
  2. till

    till Super Moderator Staff Member ISPConfig Developer


    Feel free to make a feature reqquest in the bugtracker.
  3. bax

    bax Member

Share This Page