source src1
{
type = mysql
sql_host = localhost
sql_user = root
sql_pass = ####
sql_db = ####
sql_port = 3306 # optional, default is 3306

sql_query = SELECT n.nid, u.name, n.title, u.uid, n.created, \
n.type from node n INNER JOIN users u on n.uid=u.uid where \
n.type in ('forum','page','homeslideshow','smartlink','smartfiles') group by n.nid

sql_attr_uint = uid
sql_attr_timestamp = created

sql_query_info = SELECT * FROM node where nid=$id
}

index test1
{
source = src1
path = /var/lib/sphinxsearch/data/test1
docinfo = extern
charset_type = sbcs
}

indexer
{
mem_limit = 32M
}

searchd
{
port = 3312
log = /var/log/sphinxsearch/searchd.log
query_log = /var/log/sphinxsearch/query.log
read_timeout = 5
max_children = 30
pid_file = /var/run/searchd.pid
max_matches = 1000
seamless_rotate = 1
preopen_indexes = 0
unlink_old = 1
}