Hi Janos!
i have started rsyslogd, and found
Mar 3 19:17:55 5257465bf880 piler-webui[34]: ERROR: SQLSTATE[42000]:
Syntax error or access violation: 1064 unknown local table(s) 'main1,
dailydelta1, delta1' in search request
in /var/log/syslog when hitting the search button (there is no mail.log
inside the container).
mysql -h 172.18.0.3 -u piler -p xxxxxxx
use piler;
show tables;
gives 42 tables, but in fact no main1, dailydelta1, delta1.
yours, Gerd
Am 03.03.24 um 20:06 schrieb Janos SUTO:
Verify that rsyslogd is running in the container. Then as an auditor
just hit the search button, and notice the syslogged "sphx" query
in /var/log/mail.log. What would that be?
Janos
On 2024-03-03 18:28, Gerd Wilhelm wrote:
Hi Janos!
Thanks for your help!
"pilerconf -q rtindex" gives rtindex=1
"mysql -h0 -P9306 <<< "show tables"" shows three tables (note1,
piler1, tag1) with type rt
"mysql -h0 -P9306 <<< "select * from piler1"" gives me the number of
hits corresponding to the importet mails.
It seems as am nearly arrived.
But i still do not get any hits when searching in the Web UI.
yours, Gerd
Am 03.03.24 um 18:15 schrieb Janos SUTO:
Hello Gerd,
the compose file sets RT=1 (=realtime index). It means you should not
run the indexer scripts any longer. Try the following:
Run "pilerconf -q rtindex", and verify the output is rtindex=1
Then run mysql -h0 -P9306 <<< "show tables", and verify that you
can see rt table(s). Then run mysql -h0 -P9306 <<< "select * from
piler1",
and you should see some hits.
Janos SUTO
On 2024-03-03 17:59, Gerd Wilhelm wrote:
Hi Everyone,
I want to install a new Server, but i do not arrive in getting the
indexing to work.
I have chosen to run piler as a docker container and have used
https://bitbucket.org/jsuto/piler/src/master/docker/docker-compose.yaml.
After starting with "docker-compose up" piler seems to run, i can
connect to the Web-Interface and i can log in with the default
credentials.
If i import mails, the counter "Processed Mails" on the Health
Monitor page increases as expected.
But if i log in as auditor i do not find any mail.
if i enter the docker container with
"docker exec -it <container-id> /bin/bash"
then
"su - piler"FATAL: no tables found in config file
'/etc/piler/manticore.conf'
and then
"/usr/libexec/piler/indexer.delta.sh" or
"/usr/libexec/piler/indexer.main.sh"
i get the following error:
"FATAL: no tables found in config file '/etc/piler/manticore.conf'"
Can anyone give me some advise how to investigate further?
Yours,
Gerd
--
Gerd Wilhelm (RHCE)
Tel.: +496414419289
it_werk.wilhelm
Neue Str. 7
35396 Gießen
https://www.gi-it.de
