Hi guys,
I've just about got this Baruwa 2 cracked and getting ready to start rolling
out on my CentOS 6.5 server. I've got fed up of fighting with SELinux and
turned it off for now, so most of my problems have vaporised.
I can't seem to get the search working though.
I can see messages logging to the postgres database and they are listing
correctly in the web interface, so that's all good.
However when I put any search term into the search box, I get returned no
results. I've tried message IDs and senders/recipients.
Sphinx is running and appears happy, searchd.log shows it starting up at boot
time with entries such as:
[Thu Mar 20 11:59:23.495 2014] [ 1115] Child process 1116 has been forked
[Thu Mar 20 11:59:23.495 2014] [ 1116] listening on 127.0.0.1:9312
[Thu Mar 20 11:59:23.505 2014] [ 1116] listening on 127.0.0.1:9306
[Thu Mar 20 11:59:23.642 2014] [ 1116] accepting connections
query.log is completely empty, however, which I find odd.
Top of my sphinx.conf is as follows:
searchd
{
listen = 127.0.0.1:9312
listen = 127.0.0.1:9306:mysql41
log = /var/log/sphinx/searchd.log
query_log = /var/log/sphinx/query.log
read_timeout = 5
max_children = 30
pid_file = /var/log/sphinx/searchd.pid
max_matches = 500
seamless_rotate = 1
preopen_indexes = 0
collation_server = utf8_general_ci
rt_flush_period = 3600
}
}
source messages : base
preopen_indexes = 0
unlink_old = 1
workers = threads
collation_server = utf8_general_ci
rt_flush_period = 3600
binlog_path = /var/lib/sphinx
}
indexer
{
mem_limit = 128M
}
source base
{
type = pgsql
sql_host = 127.0.0.1
sql_user = baruwa
sql_pass = my_redacted_password
sql_db = baruwa
}
and my production.ini contains
# SphinxSQL URL
sphinx.url = mysql://root:@127.0.0.1:9306
I am also running a mysql server on this machine if that makes a difference,
though on the default port 3306, so I would assume this isn't interfering.
Please can someone point me in the right direction for this.
Thanks
Stef
_______________________________________________
http://pledgie.com/campaigns/12056
