piler-webui[814]: ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 unknown local table(s) 'main1, dailydelta1, delta1' in search request

[Mark Clarke]

I have installed manticore via the repros for ubuntu and installed piler via the deb package. I manually created the tables in mysq from the /usr/share/piler/db-mysql.sql and also ran the /usr/libexec/piler/postinstall.sh script. I enabled and stared manticore.service, piler.servce and piler-smtp.service. I appear to be able to import email via the importer. It is when I try search by the web interface that I get no result and the error in mail.log:

piler-webui[814]: ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 unknown local table(s) ‘main1, dailydelta1, delta1' in search request

I can’t find any information on how to fix this but suspect it has something to do with sphinx. I used the piler.confdist file as the basis for my piler.conf. I am not sure what is wrong. I can’t see any references in site-config.php to anyting to do with sphinx or manticore.

results

[Janos SUTO]

Verify the settings rtindex=1 in piler.conf, and $config['RT'] = 1; in config-site.php

[Mark Clarke]

I think I got it working following this and then saw your comment. Thanks.

https://www.mailpiler.org/manticore-search/

Will it auto-reindex the mail that has already been ingested with RT mode? If I try kick of the indexer I get an error and research indicates you can’t run the indexer in real time mode?

[Janos SUTO]

No, RT=1 won’t auto-reindex enything. You are correct, you don’t need the indexer scripts to run (from crontab), because real time indexing means just like that :-)