Sphinx fulltext index v4.0.4

Greetings,

We are testing an upgrade to version 4.0.4 from 3.8.7. The upgrade went fine and we are able to view, submit, edit, etc. We also want to implement the fulltext index using sphinx. We have compiled sphinx, added it to mysql as a plugin and successfully ran the sbin/rt-setup-fulltext-index script. We also added:

Set( %FullTextSearch,
Enable => 1,
Indexed => 1,
Table => ‘AttachmentsIndex’,
MaxMatches => ‘10000’,
);

to the RT_SiteConfig.pm. 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.

–Dale

Dale Poulter
Automation Coordinator
Library Information Technology Services
Vanderbilt University
419 21st Avenue South, Room 812
Nashville, TN 37203-2427
(615)343-5388
(615)343-8834 (fax)
(615)207-9705 (cell)
dale.poulter@vanderbilt.edumailto:dale.poulter@vanderbilt.edu

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.

I actually tried with and without the fulltext without any success.On Dec 23, 2011, at 3:09 AM, “Ruslan Zakirov” ruz@bestpractical.com wrote:

On Thu, Dec 15, 2011 at 17:32, Poulter, Dale dale.poulter@vanderbilt.edu wrote:

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.

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.

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.On Dec 23, 2011, at 8:29 AM, “Ruslan Zakirov” ruz@bestpractical.com wrote:

On Fri, Dec 23, 2011 at 18:22, Poulter, Dale dale.poulter@vanderbilt.edu wrote:

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

On Dec 23, 2011, at 3:09 AM, “Ruslan Zakirov” ruz@bestpractical.com wrote:

On Thu, Dec 15, 2011 at 17:32, Poulter, Dale dale.poulter@vanderbilt.edu wrote:

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.

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.

Hi,

Looks good. Move on to SQL log and debug log.On Fri, Dec 23, 2011 at 21:13, Poulter, Dale dale.poulter@vanderbilt.edu wrote:

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

On Fri, Dec 23, 2011 at 18:47, Poulter, Dale dale.poulter@vanderbilt.edu wrote:

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

On Dec 23, 2011, at 8:29 AM, “Ruslan Zakirov” ruz@bestpractical.com wrote:

On Fri, Dec 23, 2011 at 18:22, Poulter, Dale dale.poulter@vanderbilt.edu wrote:

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

On Dec 23, 2011, at 3:09 AM, “Ruslan Zakirov” ruz@bestpractical.com wrote:

On Thu, Dec 15, 2011 at 17:32, Poulter, Dale dale.poulter@vanderbilt.edu wrote:

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.

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)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.

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)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.

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.On Thu, Dec 29, 2011 at 17:26, Poulter, Dale dale.poulter@vanderbilt.edu wrote:

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.

On Fri, Dec 23, 2011 at 21:13, Poulter, Dale dale.poulter@vanderbilt.edu wrote:

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

On Fri, Dec 23, 2011 at 18:47, Poulter, Dale dale.poulter@vanderbilt.edu wrote:

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

On Dec 23, 2011, at 8:29 AM, “Ruslan Zakirov” ruz@bestpractical.com wrote:

On Fri, Dec 23, 2011 at 18:22, Poulter, Dale dale.poulter@vanderbilt.edu wrote:

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

On Dec 23, 2011, at 3:09 AM, “Ruslan Zakirov” ruz@bestpractical.com wrote:

On Thu, Dec 15, 2011 at 17:32, Poulter, Dale dale.poulter@vanderbilt.edu wrote:

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.

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.

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

LucianoFrom: 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 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.

Thanks for you help!

LucianoFrom: 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.

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)

  • Boston March 5 & 6, 2012

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)

Greetings,

FYI I got sphinx running on 4.04 by following instructions before
Christmas and everything looked ok…but then I started discovering non
functioning aspects of RT post the change eg changing user group
memberships stopped working for example. The database was intact with no
corruptions.

This is obviously not ideal. I had debugged it to the point of finding
some RT generated SQL no longer running properly on the database.

Since I actually prefer psql over mysql I ended up migrated to psql using
exactly the same dataset, engaged fulltext indexing and the problems all
went away.

Tarek

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@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

-----Original Message-----
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.

-----Original Message-----
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

-----Original Message-----
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!

-----Original Message-----
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)

  • Boston March 5 & 6, 2012

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

  • Boston March 5 & 6, 2012

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

  • Boston March 5 & 6, 2012


This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

We are using v.1.6.1From: Luciano Ernesto da Silva [mailto:luciano@cpd.ufrgs.br]
Sent: Thursday, January 12, 2012 8:47 AM
To: gekkoman; Poulter, Dale; rt-users@lists.bestpractical.com
Subject: RES: Re: [rt-users] RES: Sphinx fulltext index v4.0.4

Tarek,

I already tried migrate from Mysql 5.1 to postgreSQL 9.1 but I had some problems quith some charset. Some records in Attachments table (from users that send an email in 8859-1) don’t get converted to utf8 and I get the strange character with letter I with acute, like "í "looking to "Â "(there’s a space after Â, hidden or not). I don’t know fix that, do you know any way to do that? I even used sed command, but it don’t remove the space or whatever this is.

Dale,

SPHINX: I’m thing theirs is a problem with perl module DBIx::SearchBuilder, mine is 1.61, but can’t connect to localhost port 3312. I tested searchd daemon and is working OK.

Dale, what version of DBIx::SearchBuilder are you using?

Luciano

-----Mensagem original-----
De: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] Em nome de gekkoman Enviada em: quinta-feira, 5 de janeiro de 2012 19:02
Para: Poulter, Dale; rt-users@lists.bestpractical.com
Assunto: [SPAM] Re: [rt-users] RES: Sphinx fulltext index v4.0.4

Greetings,

FYI I got sphinx running on 4.04 by following instructions before Christmas and everything looked ok…but then I started discovering non functioning aspects of RT post the change eg changing user group memberships stopped working for example. The database was intact with no corruptions.

This is obviously not ideal. I had debugged it to the point of finding some RT generated SQL no longer running properly on the database.

Since I actually prefer psql over mysql I ended up migrated to psql using exactly the same dataset, engaged fulltext indexing and the problems all went away.

Tarek

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@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

-----Original Message-----
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.

-----Original Message-----
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

-----Original Message-----
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!

-----Original Message-----
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)

  • Boston March 5 & 6, 2012

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

  • Boston March 5 & 6, 2012

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

  • Boston March 5 & 6, 2012


This message has been scanned for viruses and dangerous content by
MailScanner, and is believed to be clean.

This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

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

  • Boston March 5 & 6, 2012