Re: FATAL: no tables found in config file '/etc/piler/manticore.conf' in docker install
Thats it, it works now !!! Thanks a lot. Gerd Am 04.03.24 um 10:39 schrieb Janos SUTO: $config['SPHINX_MAIN_INDEX'] = 'piler1'; -- Gerd Wilhelm (RHCE) Tel.: +496414419289 it_werk.wilhelm Neue Str. 7 35396 Gießen https://www.gi-it.de
Re: FATAL: no tables found in config file '/etc/piler/manticore.conf' in docker install
Right. The missing piece in config-site.php is $config['SPHINX_MAIN_INDEX'] = 'piler1'; I'll update the docker stuff with it. Janos On 2024-03-04 09:09, Gerd Wilhelm wrote: Thank you for your patient help! /etc/piler/config-site.php already contains $config['RT'] = 1; as the last line. Yours, Gerd Am 04.03.24 um 08:06 schrieb Janos SUTO: OK, you are almost there. The gui is configured to use the plain manticore tables. Set the following in /etc/piler/config-site.php, then try again: $config['RT'] = 1; Janos On 2024-03-03 20:26, Gerd Wilhelm wrote: 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 xxx 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 /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
Re: FATAL: no tables found in config file '/etc/piler/manticore.conf' in docker install
Thank you for your patient help! /etc/piler/config-site.php already contains $config['RT'] = 1; as the last line. Yours, Gerd Am 04.03.24 um 08:06 schrieb Janos SUTO: OK, you are almost there. The gui is configured to use the plain manticore tables. Set the following in /etc/piler/config-site.php, then try again: $config['RT'] = 1; Janos On 2024-03-03 20:26, Gerd Wilhelm wrote: 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 xxx 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 /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
Re: FATAL: no tables found in config file '/etc/piler/manticore.conf' in docker install
OK, you are almost there. The gui is configured to use the plain manticore tables. Set the following in /etc/piler/config-site.php, then try again: $config['RT'] = 1; Janos On 2024-03-03 20:26, Gerd Wilhelm wrote: 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 xxx 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 /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
Re: FATAL: no tables found in config file '/etc/piler/manticore.conf' in docker install
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 xxx 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 /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
Re: FATAL: no tables found in config file '/etc/piler/manticore.conf' in docker install
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 /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
Re: FATAL: no tables found in config file '/etc/piler/manticore.conf' in docker install
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 /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
Re: FATAL: no tables found in config file '/etc/piler/manticore.conf' in docker install
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 /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
