RES: RE: RES: Sphinx fulltext index v4.0.4

RT Users
1

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@Vanderbilt.Edu]
Enviada em: quinta-feira, 5 de janeiro de 2012 10:50
Para: Luciano Ernesto da Silva; rt-users@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
What's New in 4: Fast full-text searching — Best Practical Solutions indicate
that the port is 3312.

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Luciano
Ernesto da Silva
Sent: Thursday, January 05, 2012 5:24 AM
To: rt-users@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

-----Mensagem original-----
De: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] Em nome de Luciano
Ernesto da Silva Enviada em: sexta-feira, 30 de dezembro de 2011 10:49
Para: Poulter, Dale
Cc: rt-users@lists.bestpractical.com
Assunto: Re: [rt-users] Sphinx fulltext index v4.0.4

Thanks for you help!

Luciano

From: Poulter, Dale [mailto:dale.poulter@Vanderbilt.Edu]
Sent: Thu 12/29/2011 4:42 PM
To: Luciano Ernesto da Silva
Cc: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Sphinx fulltext index v4.0.4

Here is the process I used.

From Mysql-5.5.17 source

Move the sphinx source directory msqlse (I used sphinx-2.0.2-beta) to
storage/sphinx in the source tree

cmake
-DWITH_UNIXODBC=1
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_ARCHIVE_STORAGE_ENGINE=1
-DWITH_SPHINX_STORAGE_ENGINE=1
-DDEFAULT_CHARSET=utf8
-DDEFAULT_COLLATION=utf8_general_ci
-DWITH_SSL=yes

Once mysql is compiled and installed you just need to install the plugin

mysql> INSTALL PLUGIN sphinx SONAME ‘ha_sphinx.so’;

mysql>s elect * from mysql.plugin;

This should indicated that the sphinx plugin is installed.

From: Luciano Ernesto da Silva [mailto:luciano@cpd.ufrgs.br]
Sent: Thursday, December 29, 2011 12:27 PM
To: Poulter, Dale
Cc: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Sphinx fulltext index v4.0.4

Hello Dale,

Can you point me how did you compiled sphinxSE with MySQL? I tryed
compile MySQL 5.1.41 with sphinx, but not worked for me in Ubuntu 10.04,
following instructions from Sphinx site.

Thanks

Luciano

From: rt-users-bounces@lists.bestpractical.com on behalf of Poulter,
Dale
Sent: Thu 12/29/2011 1:15 PM
To: Ruslan Zakirov
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Sphinx fulltext index v4.0.4

Thanks. I was just about to send out a note. It appears the v4 was
installed on top of the v3.8.5 instance which caused many issues. I did
a clean install and everything is working as of a few minutes ago.
Thanks again for all of your help!

From: ruslan.zakirov@gmail.com [mailto:ruslan.zakirov@gmail.com] On
Behalf Of Ruslan Zakirov
Sent: Thursday, December 29, 2011 9:14 AM
To: Poulter, Dale
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Sphinx fulltext index v4.0.4

Hi,

Looks like your RT 4 instance is installed incorrectly. Log says that RT
loads libraries from RT 3.8 instance and this shouldn’t happen.

Here is the output from the debug log. The mysql log did not have any
errors.

[Thu Dec 29 13:01:54 2011] [error]: Found more than one occurrence of
the /Callbacks/AssetTracker/autohandler/Default callback. This may
cause only one of the callbacks to run. Look for the duplicate
Callback in your /apps/rt385/local/html
/apps/rt385/local/plugins/RT-Authen-ExternalAuth/html
/apps/rt385/local/plugins/RT-Extension-MergeUsers/html
/apps/rt385/local/plugins/RT-Extension-MergeUsersHistory/html
/apps/rt385/local/plugins/RT-Extension-MandatorySubject/html
/apps/rt385/local/plugins/RT-Extension-SummaryByUser/html
/apps/rt385/local/plugins/RT-Extension-MobileUI/html
/apps/rt385/share/html
(/apps/rt385/sbin/…/lib/RT/Interface/Web/Request.pm:133)
[Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined,
falling back to deprecated defaults
(/apps/rt385/sbin/…/lib/RT/Queue_Overlay.pm:202)
[Thu Dec 29 13:02:21 2011] [warning]: RT::InactiveStatus undefined,
falling back to deprecated defaults
(/apps/rt385/sbin/…/lib/RT/Queue_Overlay.pm:222)
[Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined,
falling back to deprecated defaults
(/apps/rt385/sbin/…/lib/RT/Queue_Overlay.pm:202)
[Thu Dec 29 13:02:21 2011] [warning]: RT::InactiveStatus undefined,
falling back to deprecated defaults
(/apps/rt385/sbin/…/lib/RT/Queue_Overlay.pm:222)
[Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined,
falling back to deprecated defaults
(/apps/rt385/sbin/…/lib/RT/Queue_Overlay.pm:202)
[Thu Dec 29 13:02:21 2011] [warning]: RT::InactiveStatus undefined,
falling back to deprecated defaults
(/apps/rt385/sbin/…/lib/RT/Queue_Overlay.pm:222)
[Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined,
falling back to deprecated defaults
(/apps/rt385/sbin/…/lib/RT/Queue_Overlay.pm:202)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine IsGroup redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 76.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:76)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine IsUser redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 96.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:96)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine Object redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 116.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:116)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine GrantRight redefined
at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 153.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:153)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine RevokeRight redefined

at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 190.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:190)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine HasRight redefined at

/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 282.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:282)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine _HasRight redefined
at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 372.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:372)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine _HasGroupRight
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 390.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:390)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine _HasRoleRight
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 444.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:444)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine InvalidateACLCache
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 526.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:526)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine
_GetPrincipalTypeForACL redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 547.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:547)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine _ReferenceId
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 573.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:573)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine _InitSQL redefined at

/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 64.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:64)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine _SQLLimit redefined
at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 77.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:77)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine _SQLJoin redefined at

/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 96.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:96)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine _OpenParen redefined
at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 106.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:106)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine _CloseParen redefined

at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 109.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:109)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine _close_bundle
redefined at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line
140. (/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:140)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine _parser redefined at
/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 171.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:171)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine ClausesToSQL
redefined at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line
247. (/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:247)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine FromSQL redefined at
/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 282.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:282)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine Query redefined at
/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 348.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:348)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine ClassifySQLOperation
redefined at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line
365. (/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:365)
[Thu Dec 29 13:03:56 2011] [warning]: (in cleanup) Error while
loading /apps/rt385/sbin/rt-server: Can’t locate
RT/Authen/ExternalAuth.pm in @INC (@INC contains:
/apps/rt385/sbin/…/local/lib /apps/rt385/sbin/…/lib
/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl
/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl
/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8
. /opt/pkgs/apache-2.2.15) at /apps/rt385/sbin/…/lib/RT.pm line 659.
(/apps/rt385/sbin/…/lib/RT.pm:343)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine IsGroup redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 76.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:76)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine IsUser redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 96.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:96)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine Object redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 116.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:116)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine GrantRight redefined
at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 153.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:153)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine RevokeRight redefined

at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 190.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:190)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine HasRight redefined at

/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 282.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:282)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine _HasRight redefined
at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 372.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:372)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine _HasGroupRight
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 390.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:390)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine _HasRoleRight
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 444.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:444)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine InvalidateACLCache
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 526.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:526)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine
_GetPrincipalTypeForACL redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 547.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:547)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine _ReferenceId
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 573.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:573)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine _InitSQL redefined at

/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 64.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:64)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine _SQLLimit redefined
at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 77.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:77)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine _SQLJoin redefined at

/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 96.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:96)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine _OpenParen redefined
at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 106.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:106)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine _CloseParen redefined

at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 109.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:109)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine _close_bundle
redefined at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line
140. (/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:140)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine _parser redefined at
/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 171.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:171)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine ClausesToSQL
redefined at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line
247. (/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:247)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine FromSQL redefined at
/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 282.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:282)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine Query redefined at
/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 348.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:348)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine ClassifySQLOperation
redefined at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line
365. (/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:365)
[Thu Dec 29 13:04:02 2011] [warning]: (in cleanup) Error while
loading /apps/rt385/sbin/rt-server: Can’t locate
RT/Authen/ExternalAuth.pm in @INC (@INC contains:
/apps/rt385/sbin/…/local/lib /apps/rt385/sbin/…/lib
/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl
/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl
/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8
. /opt/pkgs/apache-2.2.15) at /apps/rt385/sbin/…/lib/RT.pm line 659.
(/apps/rt385/sbin/…/lib/RT.pm:343)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine IsGroup redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 76.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:76)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine IsUser redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 96.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:96)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine Object redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 116.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:116)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine GrantRight redefined
at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 153.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:153)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine RevokeRight redefined

at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 190.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:190)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine HasRight redefined at

/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 282.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:282)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _HasRight redefined
at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 372.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:372)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _HasGroupRight
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 390.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:390)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _HasRoleRight
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 444.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:444)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine InvalidateACLCache
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 526.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:526)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine
_GetPrincipalTypeForACL redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 547.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:547)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _ReferenceId
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 573.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:573)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _InitSQL redefined at

/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 64.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:64)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _SQLLimit redefined
at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 77.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:77)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _SQLJoin redefined at

/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 96.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:96)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _OpenParen redefined
at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 106.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:106)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _CloseParen redefined

at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 109.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:109)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _close_bundle
redefined at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line
140. (/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:140)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _parser redefined at
/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 171.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:171)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine ClausesToSQL
redefined at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line
247. (/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:247)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine FromSQL redefined at
/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 282.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:282)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine Query redefined at
/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 348.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:348)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine ClassifySQLOperation
redefined at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line
365. (/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:365)
[Thu Dec 29 13:04:07 2011] [warning]: (in cleanup) Error while
loading /apps/rt385/sbin/rt-server: Can’t locate
RT/Authen/ExternalAuth.pm in @INC (@INC contains:
/apps/rt385/sbin/…/local/lib /apps/rt385/sbin/…/lib
/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl
/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl
/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8
. /opt/pkgs/apache-2.2.15) at /apps/rt385/sbin/…/lib/RT.pm line 659.
(/apps/rt385/sbin/…/lib/RT.pm:343)

-----Original Message-----
From: ruslan.zakirov@gmail.com [mailto:ruslan.zakirov@gmail.com] On
Behalf Of Ruslan Zakirov
Sent: Friday, December 23, 2011 11:27 AM
To: Poulter, Dale
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Sphinx fulltext index v4.0.4

Hi,

Looks good. Move on to SQL log and debug log.

Here is the output. Thanks.

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:9312/rt’ |

1 row in set (0.00 sec)

-----Original Message-----
From: ruslan.zakirov@gmail.com [mailto:ruslan.zakirov@gmail.com] On
Behalf Of Ruslan Zakirov
Sent: Friday, December 23, 2011 8:56 AM
To: Poulter, Dale
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Sphinx fulltext index v4.0.4

Correct. The index and table seems to have been created. One
strange item is that the attatchmentindex table in MySQL is empty.
Thanks for your help.

It’s sort of empty as it’s dynamic. It’s a special table that
connects mysql to sphinx. Run ‘show create table AttachmentsIndex’ and
send us output.

Sent from iphone

I actually tried with and without the fulltext without any
success.

It’s hard to say what went wrong. Just for clarification, you’ve
created required tables with a script, configured RT’s config,
configured sphinx, setup indexer that puts data into sphinx index.
Right?

To diagnose this start with RT’s debug log. Enable logging of SQL
statements in RT. Use command line sphinx client to make sure data
is in the index. At this moment we don’t have any info to help you.

Sent from iphone

However, Request Tracker does not seem to be searching the
index.
If we search for any term that is only in the contents of the
ticket and not the header we do not get any hits. We do get
hits for terms in the ticket header though. If I search sphinx
directly for a term everything works correctly. It seems as if
RT is not searching Sphinx. Have I missed a step in the setup
process? Any assistance will be appreciated. Thanks.

How do you search? It’s still required to use fulltext:x in
simple search and Content in the query builder.

–
Best regards, Ruslan.

–
Best regards, Ruslan.

RT Training Sessions
(http://bestpractical.com/services/training.html)

  • Boston March 5 & 6, 2012

–
Best regards, Ruslan.

–
Best regards, Ruslan.

Best regards, Ruslan.

RT Training Sessions (http://bestpractical.com/services/training.html)

  • Boston March 5 & 6, 2012

RT Training Sessions (http://bestpractical.com/services/training.html)

2

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

3

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?

RegardsOn 04/12/2013 13:45, ms@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
What's New in 4: Fast full-text searching — Best Practical Solutions 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

4

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?

This lies firmly in the domain of having to debug MySQL and the SphinxSE
plugin, and not in debugging RT itself. From recent testing locally,
using 127.0.0.1 instead of localhost works acceptably. Future versions
of RT may default to 127.0.0.1 instead of localhost in the Sphinx
connection parameters – though I would be much more comfortable making
that change if the underlying reason for the ‘localhost’ failure were
clear. Unfortunately, debugging mysql is rather complex.

You can drop and re-create your SphinxSE table by running ‘DROP TABLE
AttachmentsIndex’ at a mysql prompt, re-running rt-setup-fulltext-index,
and providing sphinx://127.0.0.1:3312/rt as the URL of the Sphinx
server.

  • Alex
5

This lies firmly in the domain of having to debug MySQL and the SphinxSE
plugin, and not in debugging RT itself. From recent testing locally,
using 127.0.0.1 instead of localhost works acceptably.

I have confirmed that this is a bug in sphinxsearch. mysql 5.5.15 and
above removed a codepath that SphinxSE was using to do name resolution,
and the re-implementation of it that SphinxSE uses could never have
worked.

The work-around is to use an IP address (rather than a hostname like
localhost) in the sphinx:// URL that rt-setup-fulltext-index prompts
for. Alternately, the two attached patches can be applied to the
storage/sphinx/ directory.

The issue has been reported to sphinxsearch as bug 1815. RT may work
around this issue in a future release by defaulting to suggesting
127.0.0.1 instead of localhost when running on MySQL 5.5.

  • Alex

0001-getaddrinfo-returns-0-on-success.patch (764 Bytes)

0002-Copy-out-the-correct-part-of-the-addrinfo-response.patch (1.12 KB)