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'; mysqls 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
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'; mysqls 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
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
Re: [rt-users] Sphinx fulltext index v4.0.4
/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
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
Re: [rt-users] Sphinx fulltext index v4.0.4
/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
Re: [rt-users] Sphinx fulltext index v4.0.4
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. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] Sphinx fulltext index v4.0.4
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
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. 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
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. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
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. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] Sphinx fulltext index v4.0.4
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. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] 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 = '1', ); 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.poul...@vanderbilt.edumailto:dale.poul...@vanderbilt.edu RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012