RES: Re: RES: Sphinx fulltext index v4.0.4

Tarek,

I already tried migrate from Mysql 5.1 to postgreSQL 9.1 but I had some problems quith some charset. Some records in Attachments table (from users that send an email in 8859-1) don’t get converted to utf8 and I get the strange character with letter I with acute, like "í "looking to "Â "(there’s a space after Â, hidden or not). I don’t know fix that, do you know any way to do that? I even used sed command, but it don’t remove the space or whatever this is.

Dale,

SPHINX: I’m thing theirs is a problem with perl module DBIx::SearchBuilder, mine is 1.61, but can’t connect to localhost port 3312. I tested searchd daemon and is working OK.

Dale, what version of DBIx::SearchBuilder are you using?

Luciano

-----Mensagem original-----De: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] Em nome de gekkoman
Enviada em: quinta-feira, 5 de janeiro de 2012 19:02
Para: Poulter, Dale; rt-users@lists.bestpractical.com
Assunto: [SPAM] Re: [rt-users] RES: Sphinx fulltext index v4.0.4

Greetings,

FYI I got sphinx running on 4.04 by following instructions before Christmas and everything looked ok…but then I started discovering non functioning aspects of RT post the change eg changing user group memberships stopped working for example. The database was intact with no corruptions.

This is obviously not ideal. I had debugged it to the point of finding some RT generated SQL no longer running properly on the database.

Since I actually prefer psql over mysql I ended up migrated to psql using exactly the same dataset, engaged fulltext indexing and the problems all went away.

Tarek

Sounds like it cannot connect to the sphinx server. Can you confirm
that sphinx is running (ps -eaf |grep searchd ) and that it is running
on the port specified in the attachmentsindex create statement (mysql> show
create table AttachmentsIndex; )? I believe the default port is 9312 but
the documents at
What's New in 4: Fast full-text searching — Best Practical Solutions
indicate that the port is 3312.

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Luciano
Ernesto da Silva
Sent: Thursday, January 05, 2012 5:24 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] RES: Sphinx fulltext index v4.0.4

Hello,

I installed everything as described here by Dale/ documentation from
docs/full_text_indexing.podc , documentarion by sphinxsearch but i
got this error:

RT: DBD::mysql::st execute failed: Unable to connect to foreign data
source: failed to resolve searchd host (name=localhost) at
/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
Jan 5 08:45:16 rt4 RT: RT::Handle=HASH(0x7faacbf8ec58) couldn’t
execute the query 'SELECT COUNT(DISTINCT main.id) FROM Tickets main
JOIN Transactions Transactions_1 ON ( Transactions_1.ObjectType = ‘RT::Ticket’
) AND ( Transactions_1.ObjectId = main.id ) JOIN Attachments
Attachments_2 ON ( Attachments_2.TransactionId = Transactions_1.id )
JOIN AttachmentsIndex AttachmentsIndex_3 ON ( AttachmentsIndex_3.id =
Attachments_2.id ) WHERE (main.Status !=
‘deleted’) AND (main.Queue = ‘23’ AND ( AttachmentsIndex_3.query =
‘ESEF;limit=10000;maxmatches=10000’ ) ) AND (main.Type = ‘ticket’) AND
(main.EffectiveId = main.id) ’ at
/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

The Mysql server is running on localhost and the firewall is off(Devel
server) and SELINUX is disabled.

DBIx::SearchBuilder is up to date.

Any ideas?

Luciano

-----Mensagem original-----
De: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@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.poulter@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:luciano@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-bounces@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.zakirov@gmail.com [mailto:ruslan.zakirov@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.

Here is the output from the debug log. The mysql log did not have
any
errors.

[Thu Dec 29 13:01:54 2011] [error]: Found more than one occurrence of
the /Callbacks/AssetTracker/autohandler/Default callback. This may
cause only one of the callbacks to run. Look for the duplicate
Callback in your /apps/rt385/local/html
/apps/rt385/local/plugins/RT-Authen-ExternalAuth/html
/apps/rt385/local/plugins/RT-Extension-MergeUsers/html
/apps/rt385/local/plugins/RT-Extension-MergeUsersHistory/html
/apps/rt385/local/plugins/RT-Extension-MandatorySubject/html
/apps/rt385/local/plugins/RT-Extension-SummaryByUser/html
/apps/rt385/local/plugins/RT-Extension-MobileUI/html
/apps/rt385/share/html
(/apps/rt385/sbin/…/lib/RT/Interface/Web/Request.pm:133)
[Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined,
falling back to deprecated defaults
(/apps/rt385/sbin/…/lib/RT/Queue_Overlay.pm:202)
[Thu Dec 29 13:02:21 2011] [warning]: RT::InactiveStatus undefined,
falling back to deprecated defaults
(/apps/rt385/sbin/…/lib/RT/Queue_Overlay.pm:222)
[Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined,
falling back to deprecated defaults
(/apps/rt385/sbin/…/lib/RT/Queue_Overlay.pm:202)
[Thu Dec 29 13:02:21 2011] [warning]: RT::InactiveStatus undefined,
falling back to deprecated defaults
(/apps/rt385/sbin/…/lib/RT/Queue_Overlay.pm:222)
[Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined,
falling back to deprecated defaults
(/apps/rt385/sbin/…/lib/RT/Queue_Overlay.pm:202)
[Thu Dec 29 13:02:21 2011] [warning]: RT::InactiveStatus undefined,
falling back to deprecated defaults
(/apps/rt385/sbin/…/lib/RT/Queue_Overlay.pm:222)
[Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined,
falling back to deprecated defaults
(/apps/rt385/sbin/…/lib/RT/Queue_Overlay.pm:202)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine IsGroup redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 76.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:76)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine IsUser redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 96.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:96)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine Object redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 116.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:116)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine GrantRight redefined
at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 153.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:153)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine RevokeRight
redefined

at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 190.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:190)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine HasRight redefined
at

/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 282.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:282)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine _HasRight redefined
at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 372.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:372)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine _HasGroupRight
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 390.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:390)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine _HasRoleRight
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 444.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:444)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine InvalidateACLCache
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 526.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:526)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine
_GetPrincipalTypeForACL redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 547.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:547)
[Thu Dec 29 13:03:55 2011] [warning]: Subroutine _ReferenceId
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 573.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:573)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine _InitSQL redefined
at

/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 64.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:64)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine _SQLLimit redefined
at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 77.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:77)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine _SQLJoin redefined
at

/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 96.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:96)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine _OpenParen redefined
at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 106.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:106)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine _CloseParen
redefined

at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 109.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:109)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine _close_bundle
redefined at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line
140. (/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:140)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine _parser redefined at
/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 171.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:171)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine ClausesToSQL
redefined at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line
247. (/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:247)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine FromSQL redefined at
/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 282.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:282)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine Query redefined at
/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 348.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:348)
[Thu Dec 29 13:03:56 2011] [warning]: Subroutine ClassifySQLOperation
redefined at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line
365. (/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:365)
[Thu Dec 29 13:03:56 2011] [warning]: (in cleanup) Error while
loading /apps/rt385/sbin/rt-server: Can’t locate
RT/Authen/ExternalAuth.pm in @INC (@INC contains:
/apps/rt385/sbin/…/local/lib /apps/rt385/sbin/…/lib
/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl
/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl
/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8
. /opt/pkgs/apache-2.2.15) at /apps/rt385/sbin/…/lib/RT.pm line 659.
(/apps/rt385/sbin/…/lib/RT.pm:343)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine IsGroup redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 76.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:76)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine IsUser redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 96.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:96)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine Object redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 116.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:116)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine GrantRight redefined
at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 153.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:153)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine RevokeRight
redefined

at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 190.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:190)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine HasRight redefined
at

/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 282.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:282)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine _HasRight redefined
at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 372.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:372)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine _HasGroupRight
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 390.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:390)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine _HasRoleRight
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 444.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:444)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine InvalidateACLCache
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 526.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:526)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine
_GetPrincipalTypeForACL redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 547.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:547)
[Thu Dec 29 13:04:01 2011] [warning]: Subroutine _ReferenceId
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 573.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:573)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine _InitSQL redefined
at

/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 64.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:64)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine _SQLLimit redefined
at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 77.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:77)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine _SQLJoin redefined
at

/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 96.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:96)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine _OpenParen redefined
at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 106.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:106)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine _CloseParen
redefined

at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 109.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:109)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine _close_bundle
redefined at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line
140. (/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:140)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine _parser redefined at
/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 171.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:171)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine ClausesToSQL
redefined at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line
247. (/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:247)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine FromSQL redefined at
/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 282.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:282)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine Query redefined at
/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 348.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:348)
[Thu Dec 29 13:04:02 2011] [warning]: Subroutine ClassifySQLOperation
redefined at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line
365. (/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:365)
[Thu Dec 29 13:04:02 2011] [warning]: (in cleanup) Error while
loading /apps/rt385/sbin/rt-server: Can’t locate
RT/Authen/ExternalAuth.pm in @INC (@INC contains:
/apps/rt385/sbin/…/local/lib /apps/rt385/sbin/…/lib
/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl
/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl
/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8
. /opt/pkgs/apache-2.2.15) at /apps/rt385/sbin/…/lib/RT.pm line 659.
(/apps/rt385/sbin/…/lib/RT.pm:343)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine IsGroup redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 76.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:76)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine IsUser redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 96.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:96)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine Object redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 116.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:116)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine GrantRight redefined
at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 153.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:153)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine RevokeRight
redefined

at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 190.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:190)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine HasRight redefined
at

/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 282.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:282)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _HasRight redefined
at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 372.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:372)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _HasGroupRight
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 390.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:390)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _HasRoleRight
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 444.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:444)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine InvalidateACLCache
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 526.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:526)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine
_GetPrincipalTypeForACL redefined at
/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 547.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:547)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _ReferenceId
redefined at /apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm line 573.
(/apps/rt385/sbin/…/lib/RT/Principal_Overlay.pm:573)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _InitSQL redefined
at

/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 64.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:64)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _SQLLimit redefined
at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 77.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:77)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _SQLJoin redefined
at

/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 96.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:96)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _OpenParen redefined
at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 106.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:106)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _CloseParen
redefined

at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 109.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:109)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _close_bundle
redefined at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line
140. (/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:140)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine _parser redefined at
/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 171.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:171)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine ClausesToSQL
redefined at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line
247. (/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:247)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine FromSQL redefined at
/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 282.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:282)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine Query redefined at
/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 348.
(/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:348)
[Thu Dec 29 13:04:07 2011] [warning]: Subroutine ClassifySQLOperation
redefined at /apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line
365. (/apps/rt385/sbin/…/lib/RT/Tickets_Overlay_SQL.pm:365)
[Thu Dec 29 13:04:07 2011] [warning]: (in cleanup) Error while
loading /apps/rt385/sbin/rt-server: Can’t locate
RT/Authen/ExternalAuth.pm in @INC (@INC contains:
/apps/rt385/sbin/…/local/lib /apps/rt385/sbin/…/lib
/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl
/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl
/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8
. /opt/pkgs/apache-2.2.15) at /apps/rt385/sbin/…/lib/RT.pm line 659.
(/apps/rt385/sbin/…/lib/RT.pm:343)

-----Original Message-----
From: ruslan.zakirov@gmail.com [mailto:ruslan.zakirov@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.

Here is the output. Thanks.

mysql> show create table AttachmentsIndex;

±-----------------±-------------------------------------------------
±-----------------±-


-------------------------------------------+

| Table | Create Table
| |

±-----------------±-------------------------------------------------
±-----------------±-


-------------------------------------------+

| AttachmentsIndex | CREATE TABLE AttachmentsIndex (
id int(10) unsigned NOT NULL,
weight int(11) NOT NULL,
query varchar(3072) NOT NULL,
KEY query (query(1024))
) ENGINE=SPHINX DEFAULT CHARSET=utf8
CONNECTION=‘sphinx://localhost:9312/rt’ |

±-----------------±-------------------------------------------------
±-----------------±-


-------------------------------------------+

1 row in set (0.00 sec)

-----Original Message-----
From: ruslan.zakirov@gmail.com [mailto:ruslan.zakirov@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

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

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

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

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.

We had the same problem.

This worked perfectly for us in the end, though we went to
PostgreSQL 8.4.9 as provided by RHEL 6.x

http://wiki-archive.bestpractical.com/view/rt-mysql2pg

When you migrate to PostgreSQL, what version of RT were you using? RT 4?
Any special option on script?

Luciano

-----Mensagem original-----De: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] Em nome de Jeff Blaine
Enviada em: quinta-feira, 12 de janeiro de 2012 15:06
Para: rt-users@lists.bestpractical.com
Assunto: Re: [rt-users] RES: Re: 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.

We had the same problem.

This worked perfectly for us in the end, though we went to PostgreSQL 8.4.9 as provided by RHEL 6.x

http://wiki-archive.bestpractical.com/view/rt-mysql2pg
RT Training Sessions (http://bestpractical.com/services/training.html)

  • Boston March 5 & 6, 2012

When you migrate to PostgreSQL, what version of RT were you using? RT 4?
Any special option on script?

We dumped our RT 3.4.4 database from MySQL 4.1 (this is the
last time we touched the old data)

We stood up a new host. It had MySQL 5.1.x

We loaded the MySQL 4.1 dump into the new MySQL 5.1.x instance

We followed docs/UPGRADING.mysql

We updated the password salt stuff (docs/UPGRADING.*)

Then…

We stood up PostgreSQL 8.4.9 on the same server

We reconfigured RT for ‘Pg’, then primed the DB + tables + acls
make install
sbin/rt-setup-database --action drop # ignore any errors
sbin/rt-setup-database --action create
sbin/rt-setup-database --action schema
sbin/rt-setup-database --action acl

Then we migrated the data from MySQL 5.1 (running) to
PostgreSQL 8.4.9 (running) with:

 http://wiki-archive.bestpractical.com/view/rt-mysql2pg

There’s no magic to the script’s options. It has --help

Thanks for your help. I’ll try the script.

Luciano

-----Mensagem original-----De: Jeff Blaine [mailto:jblaine@kickflop.net]
Enviada em: quinta-feira, 12 de janeiro de 2012 16:12
Para: Luciano Ernesto da Silva
Cc: rt-users@lists.bestpractical.com
Assunto: Re: RES: [rt-users] RES: Re: RES: Sphinx fulltext index v4.0.4

When you migrate to PostgreSQL, what version of RT were you using? RT 4?
Any special option on script?

We dumped our RT 3.4.4 database from MySQL 4.1 (this is the last time we touched the old data)

We stood up a new host. It had MySQL 5.1.x

We loaded the MySQL 4.1 dump into the new MySQL 5.1.x instance

We followed docs/UPGRADING.mysql

We updated the password salt stuff (docs/UPGRADING.*)

Then…

We stood up PostgreSQL 8.4.9 on the same server

We reconfigured RT for ‘Pg’, then primed the DB + tables + acls
make install
sbin/rt-setup-database --action drop # ignore any errors
sbin/rt-setup-database --action create
sbin/rt-setup-database --action schema
sbin/rt-setup-database --action acl

Then we migrated the data from MySQL 5.1 (running) to PostgreSQL 8.4.9 (running) with:

 http://wiki-archive.bestpractical.com/view/rt-mysql2pg

There’s no magic to the script’s options. It has --help

-----Mensagem original-----
De: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] Em nome de Jeff
Blaine Enviada em: quinta-feira, 12 de janeiro de 2012 15:06
Para: rt-users@lists.bestpractical.com
Assunto: Re: [rt-users] RES: Re: 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.

We had the same problem.

This worked perfectly for us in the end, though we went to PostgreSQL
8.4.9 as provided by RHEL 6.x

http://wiki-archive.bestpractical.com/view/rt-mysql2pg

RT Training Sessions (http://bestpractical.com/services/training.html)

  • Boston March 5& 6, 2012