#
# minimal sphinx configuration suited to piler
#
source base
{
type = mysql
sql_host = localhost
sql_db = piler
sql_user = piler
sql_pass = your_db_password
sql_attr_uint = size
sql_attr_uint = sent
sql_attr_uint = attachments
##
## From 0.1.25 these attributes are disabled for an optimized
version
## If you have indexed data already, then don't exclude them
otherwise
## you have to reindex all your emails
##
## sql_attr_uint = direction
## sql_attr_uint = arrived
## sql_attr_uint = folder
}
source delta : base
{
sql_query_pre = SET NAMES utf8
sql_query_pre = REPLACE INTO sph_counter SELECT 1, MAX(id) FROM
sph_index
sql_query_post_index = DELETE FROM sph_index WHERE id<=(SELECT
max_doc_id FROM sph_counter WHERE counter_id=1)
sql_query = SELECT id, `from`, `to`, `fromdomain`, `todomain`,
`subject`, `arrived`, `sent`, `body`, `size`, `direction`, `folder`,
`attachments`, `attachment_types` FROM sph_index
WHERE id <= (SELECT max_doc_id FROM sph_counter WHERE
counter_id=1)
sql_query_killlist = SELECT `id` FROM `metadata` WHERE `deleted`=1
}
source main1 : base
{
sql_query_pre = SET NAMES utf8
sql_query = SELECT id, `from`, `to`, `fromdomain`, `todomain`,
`subject`, `arrived`, `sent`, `body`, `size`, `direction`, `folder`,
`attachments`, `attachment_types` FROM sph_index WHERE id=-1
}
source main2 : base
{
sql_query_pre = SET NAMES utf8
sql_query = SELECT id, `from`, `to`, `fromdomain`, `todomain`,
`subject`, `arrived`, `sent`, `body`, `size`, `direction`, `folder`,
`attachments`, `attachment_types` FROM sph_index WHERE id=-1
}
source main3 : base
{
sql_query_pre = SET NAMES utf8
sql_query = SELECT id, `from`, `to`, `fromdomain`, `todomain`,
`subject`, `arrived`, `sent`, `body`, `size`, `direction`, `folder`,
`attachments`, `attachment_types` FROM sph_index WHERE id=-1
}
source main4 : base
{
sql_query_pre = SET NAMES utf8
sql_query = SELECT id, `from`, `to`, `fromdomain`, `todomain`,
`subject`, `arrived`, `sent`, `body`, `size`, `direction`, `folder`,
`attachments`, `attachment_types` FROM sph_index WHERE id=-1
}
source dailydelta : base
{
sql_query_pre = SET NAMES utf8
sql_query = SELECT id, `from`, `to`, `fromdomain`, `todomain`,
`subject`, `arrived`, `sent`, `body`, `size`, `direction`, `folder`,
`attachments`, `attachment_types` FROM sph_index WHERE id=-1
}
source tag : base
{
sql_query_pre = SET NAMES utf8
sql_query = SELECT `_id`, `id`, `uid`, `tag` FROM `tag`
sql_attr_uint = id
sql_attr_uint = uid
}
source note : base
{
sql_query_pre = SET NAMES utf8
sql_query = SELECT `_id`, `id`, `uid`, `note` FROM `note`
sql_attr_uint = id
sql_attr_uint = uid
}
index main1
{
source = main1
path = /var/piler/sphinx/main1
docinfo = extern
charset_type = utf-8
enable_star = 1
min_prefix_len = 6
min_word_len = 1
}
index main2
{
source = main2
path = /var/piler/sphinx/main2
docinfo = extern
charset_type = utf-8
enable_star = 1
min_prefix_len = 6
min_word_len = 1
}
index main3
{
source = main3
path = /var/piler/sphinx/main3
docinfo = extern
charset_type = utf-8
enable_star = 1
min_prefix_len = 6
min_word_len = 1
}
index main4
{
source = main4
path = /var/piler/sphinx/main4
docinfo = extern
charset_type = utf-8
enable_star = 1
min_prefix_len = 6
min_word_len = 1
}
index dailydelta1
{
source = dailydelta
path = /var/piler/sphinx/dailydelta1
docinfo = extern
charset_type = utf-8
enable_star = 1
min_prefix_len = 6
min_word_len = 1
}
index delta1
{
source = delta
path = /var/piler/sphinx/delta1
docinfo = extern
charset_type = utf-8
enable_star = 1
min_prefix_len = 6
min_word_len = 1
}
index tag1
{
source = tag
path = /var/piler/sphinx/tag1
docinfo = extern
charset_type = utf-8
enable_star = 1
min_prefix_len = 6
min_word_len = 1
}
index note1
{
source = note
path = /var/piler/sphinx/note1
docinfo = extern
charset_type = utf-8
enable_star = 1
min_prefix_len = 6
min_word_len = 1
}
indexer
{
mem_limit = 256M
}
searchd
{
listen = 127.0.0.1:9312 [1]
listen = 127.0.0.1:9306:mysql41
log = /dev/null
binlog_path =
##query_log =
read_timeout = 5
max_children = 30
pid_file = /var/run/piler/searchd.pid
max_matches = 1000
seamless_rotate = 1
preopen_indexes = 1
unlink_old = 1
workers = threads # for RT to work
compat_sphinxql_magics = 0
}
--
Tercio Gaudencio Filho
On Tue, Jan 27, 2015 at 10:23 AM, [email protected]
<[email protected]> wrote:
Could you please post the working Sphinx.conf
Sent from my iPhone
On 27 Jan 2015, at 2:16 PM, Tercio Gaudencio Filho
<[email protected]> wrote:
Well, the problem was with .conf file. I was using a different
version(From the new installation). I copied the old one and it
worked.
Now I'm getting a warning:
WARNING: IsEmpty != attribute size (32)
From CRON /usr/local/libexec/piler/indexer.delta.sh [2].
Any tips on that?
Thanks!
--
Tercio Gaudencio Filho
On Tue, Jan 27, 2015 at 7:04 AM, Janos SUTO <[email protected]> wrote:
Hello,
On 2015-01-26 22:26, Tercio Gaudencio Filho wrote:
I also received from Cron:
Cron <piler@mailpiler> /usr/local/libexec/piler/indexer.delta.sh
[2] [1]:
WARNING: IsEmpty != attribute size (32)
FATAL: failed to merge index 'delta1' into index 'dailydelta1':
dictionary types must be the same (dst dict=crc, src dict=keywords
)
I assume the sphinx version and the used sphinx.conf don't match
perfectly.
I recommend you to drop current sphinx data, reindex a few emails,
and check
if you can search for them. If so, then reindex the rest of your
emails.
Janos
--
Tercio Gaudencio Filho
On Mon, Jan 26, 2015 at 7:22 PM, Tercio Gaudencio Filho
<[email protected]> wrote:
Hi!
I have a installation of piler running OK.
I have to migrate to a new server. I installed this new server
and
installed piler from sources.
I copied .conf, .key and .pem from the original server and also
/var/piler.
The UI is running OK, but when I search no results are found.
In my syslog I have:
Jan 26 19:06:17 piler piler-webui[3441]: sphinx query: 'SELECT id
FROM main1,dailydelta1,delta1 WHERE MATCH('@(subject,body)
contract') ORDER BY `sent` DESC LIMIT 0,1000 OPTION
max_matches=1000' in 0.02 s, 0 hits, 121037 total found
In the UI I got:
"Empty search result. Try adding the wildcard character(*) after
a
word snippet, eg. duplic* to find "duplicate", "duplicated",
etc."
How to debug this?
Att.
--
Tercio Gaudencio Filho
Links:
------
[1] http://indexer.delta.sh [2]
Links:
------
[1] http://127.0.0.1:9312
[2] http://indexer.delta.sh
