after changing to manticore error at indexer

[Jan Kraljič]

I have updated mailpiler to latest ubuntu version, including update of ubuntu to 22.04. now i have some problems with indexer:

‌

/usr/libexec/piler/indexer.main.sh
FATAL: no tables found in config file '/etc/piler/manticore.conf'

‌

which variable did I forget to set?

‌

‌

[Janos SUTO]

Show the output of /etc/piler/manticore.conf and the contents of piler.conf (No passwords please)

[Jan Kraljič]

attached

[Janos SUTO]

Execute /etc/piler/manticore.conf, and show me its output.

[Jan Kraljič]

/etc/piler# ./manticore.conf

#
# minimal manticore configuration suited to piler
#

‌

index piler1
{
type = rt
path = /var/piler/manticore/piler1
rt_mem_limit = 512M
stored_fields =
min_word_len = 1
min_prefix_len = 5
charset_table  = 0..9, english, _, \
U+C1->U+E1, U+C4->U+E4, U+C5->U+E5, U+C6->U+E6, U+C9->U+E9, U+CD->U+ED, U+D3->U+F3, U+D6->U+F6, U+D8->U+F8, \
U+DA->U+FA, U+DC->U+FC, U+0150->U+0151, U+0152->U+0153, U+0170->U+0171, U+01E2->U+E6, U+01E3->U+E6, U+01FC->U+E6, \
U+01FD->U+E6, U+1D01->U+E6, U+1D02->U+E6, U+1D2D->U+E6, U+1D46->U+E6, \
U+DF, U+E1, U+E4, U+E5, U+E6, U+E9, U+ED, U+00F3, U+F6, U+F8, U+FA, U+FC, U+0151, U+0153, U+0171
# See https://manual.manticoresearch.com/Creating_an_index/Data_types#Row-wise-and-columnar-attribute-storages
# if you want to enable columnar storage
# columnar_attrs = *
rt_field = sender
rt_field = rcpt
rt_field = senderdomain
rt_field = rcptdomain
rt_field = subject
rt_field = body
rt_field = attachment_types
rt_attr_bigint = arrived
rt_attr_bigint = sent
rt_attr_uint = size
rt_attr_uint = direction
rt_attr_uint = folder
rt_attr_uint = attachments
}

index tag1
{
type = rt
path = /var/piler/manticore/tag1
rt_mem_limit = 16M
stored_fields = tag
min_word_len = 2
min_prefix_len = 5
charset_table  = 0..9, english, _, \
U+C1->U+E1, U+C4->U+E4, U+C5->U+E5, U+C6->U+E6, U+C9->U+E9, U+CD->U+ED, U+D3->U+F3, U+D6->U+F6, U+D8->U+F8, \
U+DA->U+FA, U+DC->U+FC, U+0150->U+0151, U+0152->U+0153, U+0170->U+0171, U+01E2->U+E6, U+01E3->U+E6, U+01FC->U+E6, \
U+01FD->U+E6, U+1D01->U+E6, U+1D02->U+E6, U+1D2D->U+E6, U+1D46->U+E6, \
U+DF, U+E1, U+E4, U+E5, U+E6, U+E9, U+ED, U+00F3, U+F6, U+F8, U+FA, U+FC, U+0151, U+0153, U+0171
rt_field = tag
rt_attr_bigint = mid
rt_attr_uint = uid
}

index note1
{
type = rt
path = /var/piler/manticore/note1
rt_mem_limit = 16M
stored_fields = note
min_word_len = 2
min_prefix_len = 5
charset_table  = 0..9, english, _, \
U+C1->U+E1, U+C4->U+E4, U+C5->U+E5, U+C6->U+E6, U+C9->U+E9, U+CD->U+ED, U+D3->U+F3, U+D6->U+F6, U+D8->U+F8, \
U+DA->U+FA, U+DC->U+FC, U+0150->U+0151, U+0152->U+0153, U+0170->U+0171, U+01E2->U+E6, U+01E3->U+E6, U+01FC->U+E6, \
U+01FD->U+E6, U+1D01->U+E6, U+1D02->U+E6, U+1D2D->U+E6, U+1D46->U+E6, \
U+DF, U+E1, U+E4, U+E5, U+E6, U+E9, U+ED, U+00F3, U+F6, U+F8, U+FA, U+FC, U+0151, U+0153, U+0171
rt_field = note
rt_attr_bigint = mid
rt_attr_uint = uid
}

‌

‌

searchd
{
listen                  = 127.0.0.1:9312
listen                  = 127.0.0.1:9306:mysql41
log                     = /var/piler/manticore/manticore.log
binlog_max_log_size     = 256M
binlog_path             = /var/piler/manticore
binlog_flush            = 2
query_log               = /var/piler/manticore/query.log
network_timeout         = 5
pid_file                = /var/run/piler/searchd.pid
seamless_rotate         = 1
preopen_tables          = 1
unlink_old              = 1
thread_stack            = 512k
rt_flush_period         = 300

}

[Janos SUTO]

You have real time indexes enabled in manticore.conf. In that case you don’t need to run the indexer scripts shipped by piler. Also make sure that you set rtindex=1 in piler.conf.