[Dovecot] FTS solr : body search gives mysql error

[Steffen Kaiser]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, 13 Mar 2014, Alexandre Ellert wrote:

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

We always do and include any additional conf files with mysql queries.

- -- 
Steffen Kaiser
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iQEVAwUBUyF19XD1/YhP6VMHAQIWiwgAzY3ZdKczZu6Mvsq/6zUdX1uhnyiptHaN
0l8NHG8cJxj1gvEAptMAstwsaIga6KbAq9XrwB2Np2H3E+LQ96C9hBeAmA6NDFAM
oifUwi5nzjxYYDIO0TESxhgLCOlLxNbelIcJ+JLPk1uhM4mcHEuhJfJ/FRcwcwTN
PaCyZ8k/bW9HyfyM7+YB9GNCQkLCkz8SuSzifqX2IucTAds24UefB440v1Z/dbjF
0YbheR9QlWc/87/Nzbzid3QB0yebcsBHmKd/u1bQp7A/woYtWum+iKXjlP4Cz5rh
HU5vDzLg/GC5IW5DXs/qFJZ9CJac+V4I6zLWn7acAkJRJg3sIlNo8w==
=D/3o
-----END PGP SIGNATURE-----