[rt-users] RES:RE: Re: RES: Sphinx fulltext index v4.0.4
gekkoman
gekkoman at illimitable.com
Thu Jan 12 18:45:04 EST 2012
Luciano,
this is probably a new thread, but I migrated to pg using the process and
script provided here
http://www.mailinglistarchive.com/html/rt-users@lists.bestpractical.com/2011-06/msg00514.html
and on mine I did not have any issues. There is an attempt at UTF-8
encoding done in this script.
eg push @values, encode("UTF-8", $row->{$key});
Not sure if this will fix your issue.
Tarek
> Did yoy run rt-fulltext-indexer with the default options, like
> sphinx://localhost:3312 ?
>
> Luciano
>
> -----Mensagem original-----
> De: Poulter, Dale [mailto:dale.poulter at Vanderbilt.Edu]
> Enviada em: quinta-feira, 12 de janeiro de 2012 13:02
> Para: Luciano Ernesto da Silva; gekkoman; rt-users at lists.bestpractical.com
> Assunto: [*****SPAM*****] RE: Re: [rt-users] RES: Sphinx fulltext index
> v4.0.4
>
> 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
>
>
>
> --
> 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.
More information about the rt-users
mailing list