[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