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, m...@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 > > > > >