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(u...@domain.com): User query failed: Unknown column 'disableindexer' in 
'where clause'
Mar 13 01:46:40 mut-mx-1 dovecot: indexer-worker: Error: user u...@domain.com: 
Auth USER lookup failed
Mar 13 01:46:40 mut-mx-1 dovecot: indexer-worker: Error: User u...@domain.com 
lookup failed: Internal error occurred. Refer to server log for more 
information.
Mar 13 01:46:40 mut-mx-1 dovecot: imap(u...@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

Reply via email to