[rt-users] RES: RE: RES: Sphinx fulltext index v4.0.4

[ms at fv-berlin.de]

On Jan 5 09:55:28 EST 2012, Luciano Ernesto da Silva wrote:

Hi,

did you ever receive an answer to your problem because I am encountering
the same thing (searchd running on 0.0.0.0:3312 but RT reporting it cant
connect to it / resolve localhost).

Additionally to what you already posted, I made sure /etc/hosts connects
127.0.0.1 to "localhost" and commented out the ::1 line because I
suspected RT4 might not be IPv6-aware, but that didnt help.

KR

> Hello,
> 
> This is my configuration on sphinx.conf, seems that even I change the
> name of sql_host, RT still says : "failed to resolve searchd host
> (name=localhost"). Seems that RT isn't looking to the right  connection.
> 
> 
> Luciano
> 
> 
> vi /etc/sphinxsearch/sphinx.conf
> 
> 
> source rt {
>     type            = mysql
> 
>     sql_host        = localhost
>     sql_db          = rt4
>     sql_user        = rt4
>     sql_pass        = secret
> 
>     sql_query_pre   = SET NAMES utf8
>     sql_query       = \
>         SELECT a.id, a.content FROM Attachments a \
>         JOIN Transactions txn ON a.TransactionId = txn.id AND
> txn.ObjectType = 'RT::Ticket' \
>         JOIN Tickets t ON txn.ObjectId = t.id \
>         WHERE a.ContentType = 'text/plain' AND t.Status != 'deleted'
>     sql_query_info  = SELECT * FROM Attachments WHERE id=$id
> }
> 
> index rt {
>     source                  = rt
>     path                    = /opt/rt4/var/sphinx/index
>     docinfo                 = extern
>     charset_type            = utf-8
> }
> 
> indexer {
>     mem_limit               = 32M
> }
> 
> searchd {
>     port                    = 3312
>     log                     = /opt/rt4/var/sphinx/searchd.log
>     query_log               = /opt/rt4/var/sphinx/query.log
>     read_timeout            = 5
>     max_children            = 30
>     pid_file                = /opt/rt4/var/sphinx/searchd.pid
>     max_matches             = 10000
>     seamless_rotate         = 1
>     preopen_indexes         = 1
>     unlink_old              = 1
>     compat_sphinxql_magics  = 0
> }
> 
> Sphinx is running OK:
> 
> netstat -ntlp | grep searchd
> tcp        0      0 0.0.0.0:3312            0.0.0.0:*
> LISTEN      10762/searchd
> 
> ps -eaf |grep searchd 
> root     10762     1  0 09:17 pts/0    00:00:00 searchd
> 
> The table AttachmentsIndex seems OK:
> 
> mysql> show create table AttachmentsIndex; 
> +------------------+----------------------------------------------------
> ------------------------------------------------------------------------
> ------------------------------------------------------------------------
> -------------------------------------------+
> | Table            | Create Table
> |
> +------------------+----------------------------------------------------
> ------------------------------------------------------------------------
> ------------------------------------------------------------------------
> -------------------------------------------+
> | AttachmentsIndex | CREATE TABLE `AttachmentsIndex` (
>   `id` int(10) unsigned NOT NULL,
>   `weight` int(11) NOT NULL,
>   `query` varchar(3072) NOT NULL,
>   KEY `query` (`query`(1024))
> ) ENGINE=SPHINX DEFAULT CHARSET=utf8
> CONNECTION='sphinx://localhost:3312/rt' |
> +------------------+----------------------------------------------------
> ------------------------------------------------------------------------
> ------------------------------------------------------------------------
> -------------------------------------------+
> 1 row in set (0.00 sec)
> 
> -----Mensagem original-----
> De: Poulter, Dale [mailto:dale.poulter at Vanderbilt.Edu] 
> Enviada em: quinta-feira, 5 de janeiro de 2012 10:50
> Para: Luciano Ernesto da Silva; rt-users at lists.bestpractical.com
> Assunto: RE: [rt-users] RES: Sphinx fulltext index v4.0.4
> 
> Sounds like it cannot connect to the sphinx server.  Can you confirm
> that sphinx is running (ps -eaf |grep searchd ) and that it is running
> on the port specified in the attachmentsindex create statement (mysql>
> show create table AttachmentsIndex; )?   I believe the default port is
> 9312 but the documents at
> http://blog.bestpractical.com/2011/06/full-text-searching.html indicate
> that the port is 3312.
> 
> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com
> [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Luciano
> Ernesto da Silva
> Sent: Thursday, January 05, 2012 5:24 AM
> To: rt-users at lists.bestpractical.com
> Subject: [rt-users] RES: Sphinx fulltext index v4.0.4
> 
> Hello,
> 
> I installed everything as described here by Dale/ documentation from
> docs/full_text_indexing.podc  ,  documentarion by sphinxsearch but i got
> this error:
> 
> RT: DBD::mysql::st execute failed: Unable to connect to foreign data
> source: failed to resolve searchd host (name=localhost) at
> /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
> (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
> Jan  5 08:45:16 rt4 RT: RT::Handle=HASH(0x7faacbf8ec58) couldn't execute
> the query 'SELECT COUNT(DISTINCT main.id) FROM Tickets main JOIN
> Transactions Transactions_1  ON ( Transactions_1.ObjectType =
> 'RT::Ticket' ) AND ( Transactions_1.ObjectId = main.id ) JOIN
> Attachments Attachments_2  ON ( Attachments_2.TransactionId =
> Transactions_1.id ) JOIN AttachmentsIndex AttachmentsIndex_3  ON (
> AttachmentsIndex_3.id = Attachments_2.id )  WHERE (main.Status !=
> 'deleted') AND (main.Queue = '23' AND  ( AttachmentsIndex_3.query =
> 'ESEF;limit=10000;maxmatches=10000' ) ) AND (main.Type = 'ticket') AND
> (main.EffectiveId = main.id) ' at
> /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600
> 
> The Mysql server is running on localhost and the firewall is off(Devel
> server) and SELINUX is disabled.
> 
> DBIx::SearchBuilder is up to date.
> 
> 
> Any ideas?
> 
> 
> Luciano