15,12 → 15,11 |
sql_user = root |
sql_pass = |
sql_db = raphdb |
sql_sock = /home/raphael/web/mysql/mysql.sock |
sql_sock = /var/lib/mysql/mysql.sock |
#sql_query_pre = SET NAMES utf8 |
sql_query_pre = SET NAMES latin1 |
} |
|
|
index i_common |
{ |
# source = |
90,7 → 89,6 |
} |
|
|
|
# PAPYRUS |
source papyrus : common |
{ |
181,10 → 179,6 |
sql_attr_string = main_id |
} |
|
|
|
|
# misc... |
index i_bazar : i_common { |
source = bazar |
path = /var/lib/sphinx/bazar |
193,6 → 187,36 |
infix_fields = titre, texte |
} |
|
|
|
# COSTE |
source coste : common { |
sql_query = \ |
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 \ |
FROM tb_eflore.coste_v2_00 c \ |
LEFT JOIN tela_prod_wikini.florecoste_pages dsc ON c.page_wiki_dsc = dsc.tag AND dsc.latest = 'Y' \ |
LEFT JOIN tela_prod_wikini.florecoste_pages cle ON c.page_wiki_cle = dsc.tag AND dsc.latest = 'Y'; |
|
sql_field_string = group_id |
} |
|
index i_coste : i_common { |
source = coste |
path = /var/lib/sphinx/coste |
|
infix_fields = texte, nom_sci |
|
# override latin1, nécessaire pour les 4 indexes ci-dessus: |
charset_type = utf-8 |
sql_query_pre = SET NAMES utf8 |
sql_query_pre = SET CHARACTER_SET_RESULTS=utf8 |
# valeur par défaut, cf http://sphinxsearch.com/docs/archives/1.10/conf-charset-table.html |
# pour écraser i_common |
charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F |
} |
|
|
# misc... |
index testrt |
{ |
type = rt |
239,5 → 263,11 |
|
|
|
# sudo sphinx-searchd --stop -c sphinx-min.conf; sleep 2; sudo sphinx-indexer -c sphinx-min.conf i_projet; sphinx-search -q -c sphinx-min.conf -i i_projet "@texte homogé*" |
# 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é*" |
# sudo sphinx-searchd -c sphinx-min.conf |
|
|
# problème de charsets: |
# + https://raw.github.com/melo/scripts/master/bin/x-sphinx-charset-generator |
# $ wget https://raw.github.com/tom--/Collation-to-Charset-Table/master/collation_2_charset_table-{1,2}.php |
# $ php collation_2_charset_table-1.php|sed -n -e '/^[A-Z]/p'|php collation_2_charset_table-2.php |