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