[rt-users] RES: Sphinx fulltext index v4.0.4

Poulter, Dale dale.poulter at Vanderbilt.Edu
Thu Jan 12 10:02:29 EST 2012


We are using v.1.6.1

-----Original Message-----
From: Luciano Ernesto da Silva [mailto:luciano at cpd.ufrgs.br]
Sent: Thursday, January 12, 2012 8:47 AM
To: gekkoman; Poulter, Dale; rt-users at 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 at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] Em nome de gekkoman Enviada em: quinta-feira, 5 de janeiro de 2012 19:02
Para: Poulter, Dale; rt-users at 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
> http://blog.bestpractical.com/2011/06/full-text-searching.html
> indicate that the port is 3312.
>
> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com
> [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Luciano
> Ernesto da Silva
> Sent: Thursday, January 05, 2012 5:24 AM
> To: rt-users at lists.bestpractical.com
> Subject: [rt-users] RES: Sphinx fulltext index v4.0.4
>
> Hello,
>
> I installed everything as described here by Dale/ documentation from
> docs/full_text_indexing.podc  ,  documentarion by sphinxsearch but i
> got this error:
>
> RT: DBD::mysql::st execute failed: Unable to connect to foreign data
> source: failed to resolve searchd host (name=localhost) at
> /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
> (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
> Jan  5 08:45:16 rt4 RT: RT::Handle=HASH(0x7faacbf8ec58) couldn't
> execute the query 'SELECT COUNT(DISTINCT main.id) FROM Tickets main
> JOIN Transactions Transactions_1  ON ( Transactions_1.ObjectType = 'RT::Ticket'
> ) AND ( Transactions_1.ObjectId = main.id ) JOIN Attachments
> Attachments_2  ON ( Attachments_2.TransactionId = Transactions_1.id )
> JOIN AttachmentsIndex AttachmentsIndex_3  ON ( AttachmentsIndex_3.id =
> Attachments_2.id )  WHERE (main.Status !=
> 'deleted') AND (main.Queue = '23' AND  ( AttachmentsIndex_3.query =
> 'ESEF;limit=10000;maxmatches=10000' ) ) AND (main.Type = 'ticket') AND
> (main.EffectiveId = main.id) ' at
> /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600
>
> The Mysql server is running on localhost and the firewall is off(Devel
> server) and SELINUX is disabled.
>
> DBIx::SearchBuilder is up to date.
>
>
> Any ideas?
>
>
> Luciano
>
>
>
> -----Mensagem original-----
> De: rt-users-bounces at lists.bestpractical.com
> [mailto:rt-users-bounces at 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 at 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 at Vanderbilt.Edu]
> Sent: Thu 12/29/2011 4:42 PM
> To: Luciano Ernesto da Silva
> Cc: rt-users at 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 at cpd.ufrgs.br]
> Sent: Thursday, December 29, 2011 12:27 PM
> To: Poulter, Dale
> Cc: rt-users at 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 at lists.bestpractical.com on behalf of Poulter,
> Dale
> Sent: Thu 12/29/2011 1:15 PM
> To: Ruslan Zakirov
> Cc: rt-users at 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 at gmail.com [mailto:ruslan.zakirov at gmail.com] On
> Behalf Of Ruslan Zakirov
> Sent: Thursday, December 29, 2011 9:14 AM
> To: Poulter, Dale
> Cc: rt-users at 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.
>
> On Thu, Dec 29, 2011 at 17:26, Poulter,   Dale
> <dale.poulter at 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 at gmail.com [mailto:ruslan.zakirov at gmail.com] On
>> Behalf Of Ruslan Zakirov
>> Sent: Friday, December 23, 2011 11:27 AM
>> To: Poulter, Dale
>> Cc: rt-users at 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 at 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 at gmail.com [mailto:ruslan.zakirov at gmail.com] On
>>> Behalf Of Ruslan Zakirov
>>> Sent: Friday, December 23, 2011 8:56 AM
>>> To: Poulter, Dale
>>> Cc: rt-users at 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 at 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 at bestpractical.com> wrote:
>>>>
>>>>> On Fri, Dec 23, 2011 at 18:22, Poulter,   Dale
>>>>> <dale.poulter at 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 at bestpractical.com> wrote:
>>>>>>
>>>>>>> On Thu, Dec 15, 2011 at 17:32, Poulter,   Dale
>>>>>>> <dale.poulter at 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.
>
> --------
> 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





More information about the rt-users mailing list