Subversion Repositories Applications.papyrus

Rev

Rev 2108 | Rev 2113 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2108 Rev 2112
Line 13... Line 13...
13 
 
 13 
 
14 
	sql_host		= localhost
 14 
	sql_host		= localhost
15 
	sql_user		= root
 15 
	sql_user		= root
16 
	sql_pass		=
 16 
	sql_pass		=
17 
	sql_db			= raphdb
 17 
	sql_db			= raphdb
18 
	sql_sock		= /home/raphael/web/mysql/mysql.sock
 18 
	sql_sock		= /var/lib/mysql/mysql.sock
19 
    #sql_query_pre   = SET NAMES utf8
 19 
    #sql_query_pre   = SET NAMES utf8
20 
    sql_query_pre   = SET NAMES latin1
 20 
    sql_query_pre   = SET NAMES latin1
Line 21... Line -...
21 
}
 - 
 
22 
 
 21 
}
23 
 
 22 
 
24 
index i_common
 23 
index i_common
25 
{
 24 
{
26 
	# source			=
 25 
	# source			=
Line 88... Line 87...
88 
    # prefix_fields   = titre, texte
 87 
    # prefix_fields   = titre, texte
89 
    infix_fields    = titre, texte
 88 
    infix_fields    = titre, texte
90 
}
 89 
}
Line 91... Line -...
91 
 
 - 
 
92 
 
 90 
 
93 
 
 91 
 
94 
# PAPYRUS
 92 
# PAPYRUS
95 
source papyrus : common
 93 
source papyrus : common
96 
{
 94 
{
Line 179... Line 177...
179 
	sql_attr_timestamp	= bf_date_debut_evenement
 177 
	sql_attr_timestamp	= bf_date_debut_evenement
180 
	sql_field_string	= group_id
 178 
	sql_field_string	= group_id
181 
	sql_attr_string		= main_id
 179 
	sql_attr_string		= main_id
182 
}
 180 
}
Line 183... Line -...
183 
 
 - 
 
184 
 
 - 
 
185 
 
 - 
 
186 
 
 - 
 
187 
# misc...
 181 
 
188 
index i_bazar : i_common {
 182 
index i_bazar : i_common {
189 
	source			= bazar
 183 
	source			= bazar
Line 190... Line 184...
190 
	path			= /var/lib/sphinx/bazar
 184 
	path			= /var/lib/sphinx/bazar
191 
 
 185 
 
192 
    # prefix_fields   = titre, texte
 186 
    # prefix_fields   = titre, texte
Line -... Line 187...
- 
 
 187 
    infix_fields    = titre, texte
- 
 
 188 
}
- 
 
 189 
 
- 
 
 190 
 
- 
 
 191 
 
- 
 
 192 
# COSTE
- 
 
 193 
source coste : common {
- 
 
 194 
	sql_query		= \
- 
 
 195 
        SELECT c.num_nom AS id, CONCAT("bdtfx", ":", c.num_nom) AS group_id, CONCAT(c.nom_sci, dsc.body) AS texte, CONCAT(c.nom_sci, cle.body) AS determination, c.nom_sci AS nom_sci \
- 
 
 196 
        FROM tb_eflore.coste_v2_00 c \
- 
 
 197 
        LEFT JOIN tela_prod_wikini.florecoste_pages dsc ON c.page_wiki_dsc = dsc.tag AND dsc.latest = 'Y' \
- 
 
 198 
        LEFT JOIN tela_prod_wikini.florecoste_pages cle ON c.page_wiki_cle = dsc.tag AND dsc.latest = 'Y';
- 
 
 199 
 
- 
 
 200 
	sql_field_string	= group_id
- 
 
 201 
}
- 
 
 202 
 
- 
 
 203 
index i_coste : i_common {
- 
 
 204 
	source			= coste
- 
 
 205 
	path			= /var/lib/sphinx/coste
- 
 
 206 
 
- 
 
 207 
    infix_fields    = texte, nom_sci
- 
 
 208 
 
- 
 
 209 
    # override latin1, nécessaire pour les 4 indexes ci-dessus:
- 
 
 210 
	charset_type	= utf-8
- 
 
 211 
    sql_query_pre   = SET NAMES utf8
- 
 
 212 
    sql_query_pre   = SET CHARACTER_SET_RESULTS=utf8
- 
 
 213 
    # valeur par défaut, cf http://sphinxsearch.com/docs/archives/1.10/conf-charset-table.html
- 
 
 214 
    # pour écraser i_common
- 
 
 215 
    charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F
- 
 
 216 
}
193 
    infix_fields    = titre, texte
 217 
 
194 
}
 218 
 
195 
 
 219 
# misc...
196 
index testrt
 220 
index testrt
Line 227... Line 251...
227 
	preopen_indexes	= 1
 251 
	preopen_indexes	= 1
228 
	unlink_old		= 1
 252 
	unlink_old		= 1
229 
	workers			= threads # for RT to work
 253 
	workers			= threads # for RT to work
230 
	binlog_path		= /var/lib/sphinx
 254 
	binlog_path		= /var/lib/sphinx
Line 231... Line 255...
231 
 
 255 
 
232 
    #collation_server = utf8_general_ci  # unsure
 256 
    # collation_server = utf8_general_ci  # unsure
Line 233... Line 257...
233 
    #collation_libc_locale = fr_FR.UTF-8
 257 
    # collation_libc_locale = fr_FR.UTF-8
234 
 
 258 
 
235 
    # collation_libc_locale = fr_FR@euro
 259 
    # collation_libc_locale = fr_FR@euro
Line 236... Line 260...
236 
    # collation_libc_locale = fr_FR@euro
 260 
    # collation_libc_locale = fr_FR@euro
237 
}
 261 
}
- 
 
 262 
 
- 
 
 263 
 
- 
 
 264 
 
- 
 
 265 
 
- 
 
 266 
# sudo sphinx-searchd --stopwait -c sphinx-min.conf; sudo sphinx-indexer -c sphinx-min.conf i_projet; sphinx-search -q -c sphinx-min.conf -i i_projet "@texte homogé*"
- 
 
 267 
# sudo sphinx-searchd -c sphinx-min.conf