[Dovecot] FTS solr : body search gives mysql error

Alexandre Ellert aellert at numeezy.com
Thu Mar 13 08:48:15 UTC 2014


Hello,

I've recently setup FTS solr plugin, following http://wiki2.dovecot.org/Plugins/FTS/Solr,  and I have this error in logs when I do a body search :

Mar 13 01:46:40 mut-mx-1 dovecot: auth-worker(5808): Warning: mysql: Query failed, retrying: Unknown column 'disableindexer' in 'where clause'
Mar 13 01:46:40 mut-mx-1 dovecot: auth-worker(5808): Error: sql(user at domain.com): User query failed: Unknown column 'disableindexer' in 'where clause'
Mar 13 01:46:40 mut-mx-1 dovecot: indexer-worker: Error: user user at domain.com: Auth USER lookup failed
Mar 13 01:46:40 mut-mx-1 dovecot: indexer-worker: Error: User user at domain.com lookup failed: Internal error occurred. Refer to server log for more information.
Mar 13 01:46:40 mut-mx-1 dovecot: imap(user at domain.com): Error: indexer failed to index mailbox INBOX

Anyway, the search result seems good. Should I worry about this error or is there other thing I should do (i.e modify mysql schema) ?

I'm using mysql as a backend to store users and password.
According to the documentation, I just added this block of configuration (please tell me if need full doveconf -n) :

mail_plugins = fts fts_solr [ my other plugins ]
plugin {
  fts = solr
  fts_solr = url=http://127.0.0.1:8080/solr/
}

Versions :
OS : Debian 7
dovecot : 2.2.12 (from dovecot-ee repo)
solr : 3.6.0 (from distrib repo)

Other recommendations and feedback about using solr FTS in production would be greatly appreciated.
Many thanks.

Alexandre




More information about the dovecot mailing list