Search not returning any values

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Search not returning any values

Stef Morrell
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
Reply | Threaded
Open this post in threaded view
|

Re: Search not returning any values

Mark
This post has NOT been accepted by the mailing list yet.
This post was updated on .
Hi Stef,

Did you get this working I am having the same issue, everything else works fine but search.  If you did could you point me in the right direction please.


Mark