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
-----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@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@domain.com: Auth USER lookup failed > Mar 13 01:46:40 mut-mx-1 dovecot: indexer-worker: Error: User user@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@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-----
-----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-----