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 = 1
seamless_rotate = 1
preopen_indexes = 1
unlink_old = 1
compat_sphinxql_magics = 0
}
Sphinx is running OK:
netstat -ntlp | grep searchd
tcp0 0 0.0.0.0:33120.0.0.0:*
LISTEN 10762/searchd
ps -eaf |grep searchd
root 10762 1 0 09:17 pts/000: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
