[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