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-boun...@lists.bestpractical.com [mailto:rt-users-boun...@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.poul...@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:luci...@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-boun...@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.zaki...@gmail.com [mailto:ruslan.zaki...@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. On Thu, Dec 29, 2011 at 17:26, Poulter, Dale <dale.poul...@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.zaki...@gmail.com [mailto:ruslan.zaki...@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.poul...@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.zaki...@gmail.com [mailto:ruslan.zaki...@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.poul...@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" <r...@bestpractical.com> wrote: >>> >>>> On Fri, Dec 23, 2011 at 18:22, Poulter, Dale >>>> <dale.poul...@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" <r...@bestpractical.com> wrote: >>>>> >>>>>> On Thu, Dec 15, 2011 at 17:32, Poulter, Dale >>>>>> <dale.poul...@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