[rt-users] RES: RE: RES: Sphinx fulltext index v4.0.4

Luciano Ernesto da Silva luciano at cpd.ufrgs.br
Thu Jan 5 09:55:28 EST 2012


Hello,

This is my configuration on sphinx.conf, seems that even I change the
name of sql_host, RT still says : "failed to resolve searchd host
(name=localhost"). Seems that RT isn't looking to the right  connection.


Luciano


vi /etc/sphinxsearch/sphinx.conf


source rt {
    type            = mysql

    sql_host        = localhost
    sql_db          = rt4
    sql_user        = rt4
    sql_pass        = secret

    sql_query_pre   = SET NAMES utf8
    sql_query       = \
        SELECT a.id, a.content FROM Attachments a \
        JOIN Transactions txn ON a.TransactionId = txn.id AND
txn.ObjectType = 'RT::Ticket' \
        JOIN Tickets t ON txn.ObjectId = t.id \
        WHERE a.ContentType = 'text/plain' AND t.Status != 'deleted'
    sql_query_info  = SELECT * FROM Attachments WHERE id=$id
}

index rt {
    source                  = rt
    path                    = /opt/rt4/var/sphinx/index
    docinfo                 = extern
    charset_type            = utf-8
}

indexer {
    mem_limit               = 32M
}

searchd {
    port                    = 3312
    log                     = /opt/rt4/var/sphinx/searchd.log
    query_log               = /opt/rt4/var/sphinx/query.log
    read_timeout            = 5
    max_children            = 30
    pid_file                = /opt/rt4/var/sphinx/searchd.pid
    max_matches             = 10000
    seamless_rotate         = 1
    preopen_indexes         = 1
    unlink_old              = 1
    compat_sphinxql_magics  = 0
}

Sphinx is running OK:

netstat -ntlp | grep searchd
tcp        0      0 0.0.0.0:3312            0.0.0.0:*
LISTEN      10762/searchd

ps -eaf |grep searchd 
root     10762     1  0 09:17 pts/0    00:00:00 searchd

The table AttachmentsIndex seems OK:

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:3312/rt' |
+------------------+----------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-------------------------------------------+
1 row in set (0.00 sec)

-----Mensagem original-----
De: Poulter, Dale [mailto:dale.poulter at Vanderbilt.Edu] 
Enviada em: quinta-feira, 5 de janeiro de 2012 10:50
Para: Luciano Ernesto da Silva; rt-users at lists.bestpractical.com
Assunto: RE: [rt-users] RES: Sphinx fulltext index v4.0.4

Sounds like it cannot connect to the sphinx server.  Can you confirm
that sphinx is running (ps -eaf |grep searchd ) and that it is running
on the port specified in the attachmentsindex create statement (mysql>
show create table AttachmentsIndex; )?   I believe the default port is
9312 but the documents at
http://blog.bestpractical.com/2011/06/full-text-searching.html indicate
that the port is 3312.

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

Hello,

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

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

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

DBIx::SearchBuilder is up to date.


Any ideas?


Luciano



-----Mensagem original-----
De: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] Em nome de Luciano
Ernesto da Silva Enviada em: sexta-feira, 30 de dezembro de 2011 10:49
Para: Poulter, Dale
Cc: rt-users at lists.bestpractical.com
Assunto: Re: [rt-users] Sphinx fulltext index v4.0.4

Thanks for you help!

Luciano

-----Original Message-----
From: Poulter,   Dale [mailto:dale.poulter at Vanderbilt.Edu]
Sent: Thu 12/29/2011 4:42 PM
To: Luciano Ernesto da Silva
Cc: rt-users at lists.bestpractical.com
Subject: RE: [rt-users] Sphinx fulltext index v4.0.4

Here is the process I used.

>From Mysql-5.5.17 source

Move the sphinx source directory msqlse (I used sphinx-2.0.2-beta)  to
storage/sphinx in the source tree

cmake \
-DWITH_UNIXODBC=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_SPHINX_STORAGE_ENGINE=1 \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_SSL=yes


Once mysql is compiled and installed you just need to install the plugin

mysql> INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so';

mysql>s elect * from mysql.plugin;

This should indicated that the sphinx plugin is installed.




-----Original Message-----
From: Luciano Ernesto da Silva [mailto:luciano at cpd.ufrgs.br]
Sent: Thursday, December 29, 2011 12:27 PM
To: Poulter, Dale
Cc: rt-users at lists.bestpractical.com
Subject: RE: [rt-users] Sphinx fulltext index v4.0.4

Hello Dale,

Can you point me how did you compiled sphinxSE with MySQL? I tryed
compile MySQL 5.1.41 with sphinx, but not worked for me in Ubuntu 10.04,
following instructions from Sphinx site.

Thanks


Luciano

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com on behalf of Poulter,
Dale
Sent: Thu 12/29/2011 1:15 PM
To: Ruslan Zakirov
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Sphinx fulltext index v4.0.4

Thanks.  I was just about to send out a note.  It appears the v4 was
installed on top of the v3.8.5 instance which caused many issues.  I did
a clean install and everything is working as of a few minutes ago.
Thanks again for all of your help!

-----Original Message-----
From: ruslan.zakirov at gmail.com [mailto:ruslan.zakirov at gmail.com] On
Behalf Of Ruslan Zakirov
Sent: Thursday, December 29, 2011 9:14 AM
To: Poulter, Dale
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Sphinx fulltext index v4.0.4

Hi,

Looks like your RT 4 instance is installed incorrectly. Log says that RT
loads libraries from RT 3.8 instance and this shouldn't happen.

On Thu, Dec 29, 2011 at 17:26, Poulter,   Dale
<dale.poulter at vanderbilt.edu> wrote:
> Here is the output from the debug log.  The mysql log did not have any
errors.
>
>
> [Thu Dec 29 13:01:54 2011] [error]: Found more than one occurrence of 
> the /Callbacks/AssetTracker/autohandler/Default callback.  This may 
> cause only one of the callbacks to run.  Look for the duplicate 
> Callback in your /apps/rt385/local/html 
> /apps/rt385/local/plugins/RT-Authen-ExternalAuth/html
> /apps/rt385/local/plugins/RT-Extension-MergeUsers/html
> /apps/rt385/local/plugins/RT-Extension-MergeUsersHistory/html
> /apps/rt385/local/plugins/RT-Extension-MandatorySubject/html
> /apps/rt385/local/plugins/RT-Extension-SummaryByUser/html
> /apps/rt385/local/plugins/RT-Extension-MobileUI/html
> /apps/rt385/share/html
> (/apps/rt385/sbin/../lib/RT/Interface/Web/Request.pm:133)
> [Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined, 
> falling back to deprecated defaults
> (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:202)
> [Thu Dec 29 13:02:21 2011] [warning]: RT::InactiveStatus undefined, 
> falling back to deprecated defaults
> (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:222)
> [Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined, 
> falling back to deprecated defaults
> (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:202)
> [Thu Dec 29 13:02:21 2011] [warning]: RT::InactiveStatus undefined, 
> falling back to deprecated defaults
> (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:222)
> [Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined, 
> falling back to deprecated defaults
> (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:202)
> [Thu Dec 29 13:02:21 2011] [warning]: RT::InactiveStatus undefined, 
> falling back to deprecated defaults
> (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:222)
> [Thu Dec 29 13:02:21 2011] [warning]: RT::ActiveStatus undefined, 
> falling back to deprecated defaults
> (/apps/rt385/sbin/../lib/RT/Queue_Overlay.pm:202)
> [Thu Dec 29 13:03:55 2011] [warning]: Subroutine IsGroup redefined at 
> /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 76.
> (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:76)
> [Thu Dec 29 13:03:55 2011] [warning]: Subroutine IsUser redefined at 
> /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 96.
> (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:96)
> [Thu Dec 29 13:03:55 2011] [warning]: Subroutine Object redefined at 
> /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 116.
> (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:116)
> [Thu Dec 29 13:03:55 2011] [warning]: Subroutine GrantRight redefined 
> at /apps/rt385/sbin/../lib/RT/Principal_Overlay.pm line 153.
> (/apps/rt385/sbin/../lib/RT/Principal_Overlay.pm:153)
> [Thu Dec 29 13:03:55 2011] [warning]: Subroutine RevokeRight redefined

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

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

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

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

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

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

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

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

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

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

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

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

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

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

> at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 109.
> (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:109)
> [Thu Dec 29 13:04:07 2011] [warning]: Subroutine _close_bundle 
> redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 
> 140. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:140)
> [Thu Dec 29 13:04:07 2011] [warning]: Subroutine _parser redefined at 
> /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 171.
> (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:171)
> [Thu Dec 29 13:04:07 2011] [warning]: Subroutine ClausesToSQL 
> redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 
> 247. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:247)
> [Thu Dec 29 13:04:07 2011] [warning]: Subroutine FromSQL redefined at 
> /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 282.
> (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:282)
> [Thu Dec 29 13:04:07 2011] [warning]: Subroutine Query redefined at 
> /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 348.
> (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:348)
> [Thu Dec 29 13:04:07 2011] [warning]: Subroutine ClassifySQLOperation 
> redefined at /apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm line 
> 365. (/apps/rt385/sbin/../lib/RT/Tickets_Overlay_SQL.pm:365)
> [Thu Dec 29 13:04:07 2011] [warning]:   (in cleanup) Error while
> loading /apps/rt385/sbin/rt-server: Can't locate 
> RT/Authen/ExternalAuth.pm in @INC (@INC contains:
> /apps/rt385/sbin/../local/lib /apps/rt385/sbin/../lib 
> /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi
> /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl 
> /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl 
> /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 
> . /opt/pkgs/apache-2.2.15) at /apps/rt385/sbin/../lib/RT.pm line 659.
> (/apps/rt385/sbin/../lib/RT.pm:343)
>
>
>
> -----Original Message-----
> From: ruslan.zakirov at gmail.com [mailto:ruslan.zakirov at gmail.com] On 
> Behalf Of Ruslan Zakirov
> Sent: Friday, December 23, 2011 11:27 AM
> To: Poulter, Dale
> Cc: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] Sphinx fulltext index v4.0.4
>
> Hi,
>
> Looks good. Move on to SQL log and debug log.
>
> On Fri, Dec 23, 2011 at 21:13, Poulter,   Dale
> <dale.poulter at vanderbilt.edu> wrote:
>> Here is the output.  Thanks.
>>
>> mysql> show create table AttachmentsIndex;
>>
+------------------+----------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-------------------------------------------+
>> | Table            | Create Table
>> | |
>>
+------------------+----------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-------------------------------------------+
>> | AttachmentsIndex | CREATE TABLE `AttachmentsIndex` (
>>  `id` int(10) unsigned NOT NULL,
>>  `weight` int(11) NOT NULL,
>>  `query` varchar(3072) NOT NULL,
>>  KEY `query` (`query`(1024))
>> ) ENGINE=SPHINX DEFAULT CHARSET=utf8
>> CONNECTION='sphinx://localhost:9312/rt' |
>>
+------------------+----------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-------------------------------------------+
>> 1 row in set (0.00 sec)
>>
>> -----Original Message-----
>> From: ruslan.zakirov at gmail.com [mailto:ruslan.zakirov at gmail.com] On 
>> Behalf Of Ruslan Zakirov
>> Sent: Friday, December 23, 2011 8:56 AM
>> To: Poulter, Dale
>> Cc: rt-users at lists.bestpractical.com
>> Subject: Re: [rt-users] Sphinx fulltext index v4.0.4
>>
>> On Fri, Dec 23, 2011 at 18:47, Poulter,   Dale
>> <dale.poulter at vanderbilt.edu> wrote:
>>> Correct.  The index and table seems to have been created.  One
strange item is that the attatchmentindex table in MySQL is empty.
Thanks for your help.
>>
>> It's sort of empty as it's dynamic. It's a special table that
connects mysql to sphinx. Run 'show create table AttachmentsIndex' and
send us output.
>>
>>>
>>>
>>> Sent from iphone
>>>
>>>
>>> On Dec 23, 2011, at 8:29 AM, "Ruslan Zakirov"
<ruz at bestpractical.com> wrote:
>>>
>>>> On Fri, Dec 23, 2011 at 18:22, Poulter,   Dale
>>>> <dale.poulter at vanderbilt.edu> wrote:
>>>>> I actually tried with and without the fulltext without any
success.
>>>>
>>>> It's hard to say what went wrong. Just for clarification, you've 
>>>> created required tables with a script, configured RT's config, 
>>>> configured sphinx, setup indexer that puts data into sphinx index.
>>>> Right?
>>>>
>>>> To diagnose this start with RT's debug log. Enable logging of SQL 
>>>> statements in RT. Use command line sphinx client to make sure data 
>>>> is in the index. At this moment we don't have any info to help you.
>>>>
>>>>> Sent from iphone
>>>>>
>>>>>
>>>>> On Dec 23, 2011, at 3:09 AM, "Ruslan Zakirov"
<ruz at bestpractical.com> wrote:
>>>>>
>>>>>> On Thu, Dec 15, 2011 at 17:32, Poulter,   Dale
>>>>>> <dale.poulter at vanderbilt.edu> wrote:
>>>>>>> However,  Request Tracker does not seem to be searching the
index.
>>>>>>> If we search for any term that is only in the contents of the 
>>>>>>> ticket and not the header we do not get any hits.  We do get 
>>>>>>> hits for terms in the ticket header though.  If I search sphinx 
>>>>>>> directly for a term everything works correctly.  It seems as if 
>>>>>>> RT is not searching Sphinx.  Have I missed a step in the setup
process?  Any assistance will be appreciated.  Thanks.
>>>>>>
>>>>>> How do you search? It's still required to use fulltext:x in 
>>>>>> simple search and Content in the query builder.
>>>>>>
>>>>>> --
>>>>>> Best regards, Ruslan.
>>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Best regards, Ruslan.
>>>>
>>>
>>> --------
>>> RT Training Sessions
>>> (http://bestpractical.com/services/training.html)
>>> * Boston  March 5 & 6, 2012
>>
>>
>>
>> --
>> Best regards, Ruslan.
>>
>
>
>
> --
> Best regards, Ruslan.
>



--
Best regards, Ruslan.

--------
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston  March 5 & 6, 2012





--------
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston  March 5 & 6, 2012
--------
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston  March 5 & 6, 2012





More information about the rt-users mailing list