gistfile1.txt

#
# Minimal Sphinx configuration sample (clean, simple, functional)
#

source src1
{
	type					= mysql

	sql_host				= localhost
	sql_user				= root
	sql_pass				= root
	sql_db					= atom
	sql_port				= 3306	# optional, default is 3306

	sql_query				= \
		SELECT id,title,auteur,titre, contenu_has_type.types_id AS types_id   \
		FROM contenu \
		INNER JOIN contenu_has_type ON contenu.id=contenu_has_type.contenu_id \
		INNER JOIN contenu_has_node ON contenu.id=contenu_has_node.contenu_id

	sql_attr_uint                = types_id 
	sql_attr_uint                = auteur 
        #sql_attr_uint  		     = node_id
	#sql_attr_uint			= group_id
	#sql_attr_timestamp		= date_added
	sql_query_info			= SELECT contenu.*,CONCAT(node.canonical_link, ',')  as nodes    \
						FROM contenu     					\
						CROSS JOIN contenu_has_node   				\
						LEFT JOIN node ON (node.id=contenu_has_node.node_id AND contenu.id=contenu_has_node.contenu_id) \
						WHERE contenu.id=$id
}

index test1
{
	source					= src1
	path					= /var/lib/sphinx/test1
	docinfo					= extern
	charset_type			= sbcs
        enable_star        = true
	min_prefix_len    = 0
	min_infix_len        = 1
	  infix_fields        = title

 charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, \
			        U+430..U+44F,U+C5->U+E5, \
                                U+E5, U+C4->U+E4, U+E4, U+D6->U+F6, U+F6, U+16B, U+0c1->a, U+0c4->a, U+0c9->e, U+0cd->i, \
                                U+0d3->o, U+0d4->o, U+0da->u, U+0dd->y, U+0e1->a, U+0e4->a, U+0e9->e, U+0ed->i, U+0f3->o, \
                                U+0f4->o, U+0fa->u, U+0fd->y, U+104->U+105, U+105, U+106->U+107, U+10c->c, U+10d->c, \
                                U+10e->d, U+10f->d, U+116->U+117, U+117, U+118->U+119, U+11a->e, U+11b->e, U+12E->U+12F, \
                                U+12F, U+139->l, U+13a->l, U+13d->l, U+13e->l, U+141->U+142, U+142, U+143->U+144, \
                                U+144,U+147->n, U+148->n, U+154->r, U+155->r, U+158->r, U+159->r, U+15A->U+15B, U+15B, \
                                U+160->s, U+160->U+161, U+161->s, U+164->t, U+165->t, U+16A->U+16B, U+16B, U+16e->u, \
                                U+16f->u, U+172->U+173, U+173, U+179->U+17A, U+17A, U+17B->U+17C, U+17C, U+17d->z, \
                                U+17e->z, U+DC->U+FC, U+DF, U+FC

}

indexer
{
	mem_limit				= 1000M
}


searchd
{
	listen				= 127.0.0.1:9312
	log						= /var/log/sphinx/searchd.log
	query_log				= /var/log/sphinx/query.log
	read_timeout			= 5
	max_children			= 30
	pid_file				= /var/run/sphinx/searchd.pid
	max_matches				= 1000
	seamless_rotate			= 1
	preopen_indexes			= 0
	unlink_old				= 1
}