Luciano, this is probably a new thread, but I migrated to pg using the process and script provided here
http://www.mailinglistarchive.com/html/[email protected]/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:[email protected]] > Enviada em: quinta-feira, 12 de janeiro de 2012 13:02 > Para: Luciano Ernesto da Silva; gekkoman; [email protected] > 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:[email protected]] > Sent: Thursday, January 12, 2012 8:47 AM > To: gekkoman; Poulter, Dale; [email protected] > 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: [email protected] > [mailto:[email protected]] Em nome de gekkoman > Enviada em: quinta-feira, 5 de janeiro de 2012 19:02 > Para: Poulter, Dale; [email protected] > 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: [email protected] >> [mailto:[email protected]] On Behalf Of Luciano >> Ernesto da Silva >> Sent: Thursday, January 05, 2012 5:24 AM >> To: [email protected] >> 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: [email protected] >> [mailto:[email protected]] Em nome de Luciano >> Ernesto da Silva Enviada em: sexta-feira, 30 de dezembro de 2011 10:49 >> Para: Poulter, Dale >> Cc: [email protected] >> Assunto: Re: [rt-users] Sphinx fulltext index v4.0.4 >> >> Thanks for you help! >> >> Luciano >> >> -----Original Message----- >> From: Poulter, Dale [mailto:[email protected]] >> Sent: Thu 12/29/2011 4:42 PM >> To: Luciano Ernesto da Silva >> Cc: [email protected] >> 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:[email protected]] >> Sent: Thursday, December 29, 2011 12:27 PM >> To: Poulter, Dale >> Cc: [email protected] >> 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: [email protected] on behalf of Poulter, >> Dale >> Sent: Thu 12/29/2011 1:15 PM >> To: Ruslan Zakirov >> Cc: [email protected] >> 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: [email protected] [mailto:[email protected]] On >> Behalf Of Ruslan Zakirov >> Sent: Thursday, December 29, 2011 9:14 AM >> To: Poulter, Dale >> Cc: [email protected] >> 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 >> <[email protected]> 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: [email protected] [mailto:[email protected]] On >>> Behalf Of Ruslan Zakirov >>> Sent: Friday, December 23, 2011 11:27 AM >>> To: Poulter, Dale >>> Cc: [email protected] >>> 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 >>> <[email protected]> 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: [email protected] [mailto:[email protected]] On >>>> Behalf Of Ruslan Zakirov >>>> Sent: Friday, December 23, 2011 8:56 AM >>>> To: Poulter, Dale >>>> Cc: [email protected] >>>> Subject: Re: [rt-users] Sphinx fulltext index v4.0.4 >>>> >>>> On Fri, Dec 23, 2011 at 18:47, Poulter, Dale >>>> <[email protected]> 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" >> <[email protected]> wrote: >>>>> >>>>>> On Fri, Dec 23, 2011 at 18:22, Poulter, Dale >>>>>> <[email protected]> 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" >> <[email protected]> wrote: >>>>>>> >>>>>>>> On Thu, Dec 15, 2011 at 17:32, Poulter, Dale >>>>>>>> <[email protected]> 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. -------- RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
