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

ms at fv-berlin.de ms at fv-berlin.de
Tue Dec 17 17:11:24 EST 2013


Hi,

didn't get a response there. Is there a way to solve this? Possibly
through debugging RT4 to see how its actually trying to connect to
searchd instead of how the config looks like it should?

Regards

On 04/12/2013 13:45, ms at fv-berlin.de wrote:
> 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
> 
> 
> 
> 
> 




More information about the rt-users mailing list