blob: 24d271b4a58f393e3ecdc64e65b420f06517ca31 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
|
source journal
{
type = mysql
sql_host = localhost
sql_user = journal_user
sql_pass = journal_password
sql_db = journal
# sql_sock = /var/run/mysqld/mysqld.sock
sql_port = 3306
# indexer query
# document_id MUST be the very first field
# document_id MUST be positive (non-zero, non-negative)
# document_id MUST fit into 32 bits
# document_id MUST be unique
sql_query = \
SELECT \
`id`, `fulltext`, `image_url` \
FROM \
journals;
#
# sql_group_column = assembly
# sql_group_column = model
# document info query
# ONLY used by search utility to display document information
# MUST be able to fetch document info by its id, therefore
# MUST contain '$id' macro
#
sql_query_info = SELECT * FROM journals WHERE id=$id
}
index journal
{
source = journal
path = /home/pepper/sphinx/journal
morphology = stem_en
min_word_len = 3
min_prefix_len = 0
min_infix_len = 3
}
searchd
{
port = 3312
log = /var/log/searchd/searchd.log
query_log = /var/log/searchd/query.log
pid_file = /var/log/searchd/searchd.pid
}
|
