Re: [rt-users] rt-mailgate issues with 4.2.12 (Use of uninitialized value $NewSubject)

2016-02-10 Thread Poulter, Dale 
All,

It appears that the problem is even more widespread.  The system will not 
accept any email.  The errors appear to point to missing subjects and from 
addresses but the process worked before the upgrade.  ANY help will be 
appreciated.  I am out of ideas.


-Dale

From: Poulter, Dale
Sent: Tuesday, February 09, 2016 12:41 PM
To: rt-users@lists.bestpractical.com
Subject: rt-mailgate issues with 4.2.12 (Use of uninitialized value $NewSubject)

We upgraded to 4.2.12 and everything looked ok.  However,  we are now unable to 
submit tickets via email using rt-mailgate. I have seen many posts but none of 
the proposed solutions seem to work.  We are using the same command as we did 
in 3.8.7 for sendmail .  Here is our setup.

Perl: 5.16.3
Rt-mailgate is using sendmail

testemail: "|/apps/rt4/bin/rt-mailgate  \
  --queue 'General' --action correspond \
  --url https://requesttracker.edu/ --no-verify-ssl"

In RT_SiteConfig.pm
Set($WebFallbackToRTLogin, "true");
Set($WebRemoteUserAutocreate, 1);


Error:
Command line  : not ok - Could not load a valid user

RT debug log; [20557] [Tue Feb  9 18:36:23 2016] [warning]: Use of 
uninitialized value $NewSubject in scalar chomp at 
/apps/rt4/sbin/../lib/RT/Interface/Email.pm line 1374. 
(/apps/rt4/sbin/../lib/RT/Interface/Email.pm:1374)
[20557] [Tue Feb  9 18:36:23 2016] [error]: Couldn't parse or find sender's 
address (/apps/rt4/sbin/../lib/RT/Interface/Email/Auth/MailFrom.pm:74)
[20557] [Tue Feb  9 18:36:23 2016] [error]: Could not record email: Could not 
load a valid user (/apps/rt4/share/html/REST/1.0/NoAuth/mail-gateway:75)







--Dale

---
Dale Poulter
Coordinator, Search and Core Services
Library Digital Services
Vanderbilt University
419 21st Avenue South, Room 812
Nashville, TN  37203-2427
(615)343-5388
(615)207-9705 (cell)
dale.poul...@vanderbilt.edu<mailto:dale.poul...@vanderbilt.edu>


-
RT 4.4 and RTIR Training Sessions 
(http://bestpractical.com/services/training.html)
* Hamburg Germany — March 14 & 15, 2016

[rt-users] rt-mailgate issues with 4.2.12 (Use of uninitialized value $NewSubject)

2016-02-09 Thread Poulter, Dale 
We upgraded to 4.2.12 and everything looked ok.  However,  we are now unable to 
submit tickets via email using rt-mailgate. I have seen many posts but none of 
the proposed solutions seem to work.  We are using the same command as we did 
in 3.8.7 for sendmail .  Here is our setup.

Perl: 5.16.3
Rt-mailgate is using sendmail

testemail: "|/apps/rt4/bin/rt-mailgate  \
  --queue 'General' --action correspond \
  --url https://requesttracker.edu/ --no-verify-ssl"

In RT_SiteConfig.pm
Set($WebFallbackToRTLogin, "true");
Set($WebRemoteUserAutocreate, 1);


Error:
Command line  : not ok - Could not load a valid user

RT debug log; [20557] [Tue Feb  9 18:36:23 2016] [warning]: Use of 
uninitialized value $NewSubject in scalar chomp at 
/apps/rt4/sbin/../lib/RT/Interface/Email.pm line 1374. 
(/apps/rt4/sbin/../lib/RT/Interface/Email.pm:1374)
[20557] [Tue Feb  9 18:36:23 2016] [error]: Couldn't parse or find sender's 
address (/apps/rt4/sbin/../lib/RT/Interface/Email/Auth/MailFrom.pm:74)
[20557] [Tue Feb  9 18:36:23 2016] [error]: Could not record email: Could not 
load a valid user (/apps/rt4/share/html/REST/1.0/NoAuth/mail-gateway:75)







--Dale

---
Dale Poulter
Coordinator, Search and Core Services
Library Digital Services
Vanderbilt University
419 21st Avenue South, Room 812
Nashville, TN  37203-2427
(615)343-5388
(615)207-9705 (cell)
dale.poul...@vanderbilt.edu


-
RT 4.4 and RTIR Training Sessions 
(http://bestpractical.com/services/training.html)
* Hamburg Germany — March 14 & 15, 2016

Re: [rt-users] RT upgrade still seeing old version

2016-02-07 Thread Poulter, Dale 
In case others experience this issue.  I was able locate 2 solutions.


1- Recompile mod_perl2 using the current version of perl

2- Switch from mod_perl to mod_fcgid - this is the option we selected.


-Dale

From: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of 
Poulter, Dale
Sent: Saturday, February 6, 2016 6:59 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] RT upgrade still seeing old version

We recently upgraded from 3.8.7 to 4.2.12.  The upgrade on our development 
machine went great and the upgrade on production seem to go well also until 
restarting apache with the new configuration.  When restarting it gives me the 
error

"Wrong version of RT 3.8.7 found; need 4.2.* at /apps/rt4/sbin/rt-server line 
87.\n\t(in cleanup) Error while loading /apps/rt4/sbin/rt-server: Wrong version 
of RT 3.8.7 found; need 4.2.* at /apps/rt4/sbin/rt-server line 87.\n"

Has this happened to anyone else?  Any suggestions?

Installation information:  Apache/mysql (remote server)/php/mod_perl2/perl 
5.16.3

Thank you.



--Dale

---
Dale Poulter
Coordinator, Search and Core Services
Library Digital Services
Vanderbilt University
419 21st Avenue South, Room 812
Nashville, TN  37203-2427
(615)343-5388
(615)207-9705 (cell)
dale.poul...@vanderbilt.edu<mailto:dale.poul...@vanderbilt.edu>



-
RT 4.4 and RTIR Training Sessions 
(http://bestpractical.com/services/training.html)
* Hamburg Germany — March 14 & 15, 2016

[rt-users] RT upgrade still seeing old version

2016-02-06 Thread Poulter, Dale 
We recently upgraded from 3.8.7 to 4.2.12.  The upgrade on our development 
machine went great and the upgrade on production seem to go well also until 
restarting apache with the new configuration.  When restarting it gives me the 
error

"Wrong version of RT 3.8.7 found; need 4.2.* at /apps/rt4/sbin/rt-server line 
87.\n\t(in cleanup) Error while loading /apps/rt4/sbin/rt-server: Wrong version 
of RT 3.8.7 found; need 4.2.* at /apps/rt4/sbin/rt-server line 87.\n"

Has this happened to anyone else?  Any suggestions?

Installation information:  Apache/mysql (remote server)/php/mod_perl2/perl 
5.16.3

Thank you.



--Dale

---
Dale Poulter
Coordinator, Search and Core Services
Library Digital Services
Vanderbilt University
419 21st Avenue South, Room 812
Nashville, TN  37203-2427
(615)343-5388
(615)207-9705 (cell)
dale.poul...@vanderbilt.edu



-
RT 4.4 and RTIR Training Sessions 
(http://bestpractical.com/services/training.html)
* Hamburg Germany — March 14 & 15, 2016

[rt-users] Table creation question (v4.0.6)

2012-06-13 Thread Poulter, Dale 
Good morning,

We are upgrading to  4.0.6 and changing our architecture a little.  We will be 
running RT on one server and connect to the database on another server.  This 
works fine for most functions but I am attempting to determine how the sphinx 
server should be setup.  This is how I THINK is should be but would like to 
hear back from anyone that has attempted this scenario

DB server:  mysql
Sphinx should run on the RT server and not the Sphinx server.

Creation of Attachementsindex should be

CREATE TABLE AttachmentsIndex (
id INTEGER UNSIGNED NOT NULL,
weight INTEGER NOT NULL,
query  VARCHAR(3072) NOT NULL,
INDEX(query)
) ENGINE=SPHINX CONNECTION=sphinx://rtserver.org:9312/rt CHARACTER SET 
utf8


Is this correct or should the SPHINX CONNECTION be the localhost?  Thanks.

--Dale

---
Dale Poulter
Coordinator, Search and Core Services
Library Digital Services
Vanderbilt University
419 21st Avenue South, Room 812
Nashville, TN  37203-2427
(615)343-5388
(615)343-8834 (fax)
(615)207-9705 (cell)
dale.poul...@vanderbilt.edumailto:dale.poul...@vanderbilt.edu

[rt-users] RT 4.0.5 fulltext errors

2012-03-23 Thread Poulter, Dale 
Good afternoon,

We have just install 4.0.5 in a test environment and migrated our data from 
3.8.7.  The system was working with 4.0.4 with the same configuration before 
our dev server crashed. The system seems to be working well until we attempt to 
do a full text search.  Sphinx is enabled in mysql and the indexer has ran 
successfully.  I can do a basic simple search without any problems but when I 
do a fulltext search (fulltext: test) mysql restarts and I get the error below. 
 Has anyone encountered this issue?




Mar 23 11:14:26 libk RT: _DoSearch is not so successful as it still needs redo 
search, won't call _BuildAccessTable 
(/apps/rtdev/sbin/../lib/RT/Attributes.pm:85)
Mar 23 11:14:26 libk RT: DBD::mysql::st execute failed: MySQL server has gone 
away at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 587. 
(/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:587)
Mar 23 11:14:26 libk RT: RT::Handle=HASH(0xd146ca0) couldn't execute the query 
'SELECT main.* FROM Attributes main  WHERE (main.ObjectType = 'RT::System') AND 
(main.ObjectId = 1)  ORDER BY main.id ASC ' at 
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 600   
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xd146ca0)', 'SELECT 
main.* FROM Attributes main  WHERE (main.ObjectType = ...') called at 
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line 235   
DBIx::SearchBuilder::_DoSearch('RT::Attributes=HASH(0xd4dd120)') called at 
/apps/rtdev/sbin/../lib/RT/SearchBuilder.pm line 320  
RT::SearchBuilder::_DoSearch('RT::Attributes=HASH(0xd4dd120)') called at 
/apps/rtdev/sbin/../lib/RT/Attributes.pm line 81
RT::Attributes::_DoSearch('RT::Attributes=HASH(0xd4dd120)') called at 
/apps/rtdev/sbin/../lib/RT/Attributes.pm line 106  
RT::Attributes::_AttrHash('RT::Attributes=HASH(0xd4dd120)') called at 
/apps/rtdev/sbin/../lib/RT/Attributes.pm line 137 
RT::Attributes::Named('RT::Attributes=HAS
Mar 23 11:14:26 libk RT: _DoSearch is not so successful as it still needs redo 
search, won't call _BuildAccessTable 
(/apps/rtdev/sbin/../lib/RT/Attributes.pm:85)
Mar 23 11:14:26 libk RT: DBD::mysql::st execute failed: MySQL server has gone 
away at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 587. 
(/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:587)
Mar 23 11:14:26 libk RT: RT::Handle=HASH(0xd146ca0) 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 ( (  ( attachmentsindex_3.query = 
'test;limit=1;maxmatches=1' )  )  AND  ( main.Status = 'new' OR 
main.Status = 'open' OR main.Status = 'stalled' ) ) AND (main.Type = 'ticket') 
AND (main.EffectiveId = main.id) ' at 
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 600 
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xd146ca0)', 'SELECT 
COUNT(DISTINCT main.id) FROM Tickets main JOIN Transac...') called at 
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line 291   
DBIx::SearchBuilder::_DoCount('RT::Tickets=HASH(0x
Mar 23 11:14:26 libk RT: DBD::mysql::st execute failed: MySQL server has gone 
away at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 587. 
(/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:587)
Mar 23 11:14:26 libk RT: RT::Handle=HASH(0xd146ca0) couldn't execute the query 
'SELECT  * FROM Attributes WHERE Name = ? AND ObjectType = ? AND ObjectId = ?' 
at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 600
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xd146ca0)', 'SELECT  
* FROM Attributes WHERE Name = ? AND ObjectType = ? A...', 'Pref-RT::System-1', 
'RT::User', 205) called at 
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1206 
DBIx::SearchBuilder::Record::_LoadFromSQL('RT::Attribute=HASH(0xd6b3e20)', 
'SELECT  * FROM Attributes WHERE Name = ? AND ObjectType = ? A...', 
'Pref-RT::System-1', 'RT::User', 205) called at 
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1125  
DBIx::SearchBuilder::Record::LoadByCols('RT::Attribute=HASH(0xd6b3e20)', 
'Name', 'Pref-RT::System-1', 'ObjectId', 205, 'ObjectType', 'RT::User') called 
at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record/Cachable.pm line 
120 DBIx::SearchBuilder::Record::Cachable:
Mar 23 11:14:26 libk RT: DBD::mysql::st execute failed: MySQL server has gone 
away at /usr/lib/perl5/site_perl/5.8.8/Apache/Session/Store/DBI.pm line 67. 
(/usr/lib/perl5/site_perl/5.8.8/Apache/Session/Store/DBI.pm:67)
Mar 23 11:14:26 libk RT: DBD::mysql::st execute failed: MySQL server has gone 
away at

Re: [rt-users] RT 4.0.5 fulltext errors

2012-03-23 Thread Poulter, Dale 
Nothing is appearing in the mysql error log.

When I go into mysql the AttachmentsIndex is empty -- although the indexing 
appeared to succeed.


indexing index 'rt'...
WARNING: Attribute count is 0: switching to none docinfo
collected 110222 docs, 96.0 MB
sorted 14.9 Mhits, 100.0% done
total 110222 docs, 95954943 bytes
total 48.936 sec, 1960788 bytes/sec, 2252.32 docs/sec
total 12 reads, 0.046 sec, 3133.3 kb/call avg, 3.8 msec/call avg
total 95 writes, 0.322 sec, 940.1 kb/call avg, 3.3 msec/call avg


-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin Falcone
Sent: Friday, March 23, 2012 1:37 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT 4.0.5 fulltext errors

On Fri, Mar 23, 2012 at 12:51:35PM -0500, Poulter,   Dale wrote:
We have just install 4.0.5 in a test environment and migrated our data 
 from 3.8.7.  The system
was working with 4.0.4 with the same configuration before our dev server 
 crashed. The system
seems to be working well until we attempt to do a full text search.  
 Sphinx is enabled in
mysql and the indexer has ran successfully.  I can do a basic simple 
 search without any
problems but when I do a fulltext search (fulltext: test) mysql restarts 
 and I get the error
below.  Has anyone encountered this issue?

What's in the mysql error log?  RT is just reporting that there was an error, 
mysql will be able to tell you what's really going on.

Also, what happens when you try to select from your AttachmentsIndex table 
manually?

-kevin

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

2012-01-12 Thread Poulter, Dale 
We are using v.1.6.1

-Original Message-
From: Luciano Ernesto da Silva [mailto:luci...@cpd.ufrgs.br]
Sent: Thursday, January 12, 2012 8:47 AM
To: gekkoman; Poulter, Dale; rt-users@lists.bestpractical.com
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: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@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
 http://blog.bestpractical.com/2011/06/full-text-searching.html
 indicate that the port is 3312.

 -Original Message-
 From: rt-users-boun...@lists.bestpractical.com
 [mailto:rt-users-boun...@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=1;maxmatches=1' ) ) AND (main.Type = 'ticket') AND
 (main.EffectiveId = main.id) ' at
 /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

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

 DBIx::SearchBuilder is up to date.


 Any ideas?


 Luciano



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

 Thanks for you help!

 Luciano

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

 Here is the process I used.

 From Mysql-5.5.17 source

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

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


 Once mysql is compiled and installed

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

2012-01-05 Thread Poulter, Dale 
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-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@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=1;maxmatches=1' ) ) AND (main.Type = 'ticket') AND 
(main.EffectiveId = main.id) ' at 
/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

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

DBIx::SearchBuilder is up to date.


Any ideas?


Luciano



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

Thanks for you help!

Luciano

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

Here is the process I used.

From Mysql-5.5.17 source

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

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


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

mysql INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so';

mysqls elect * from mysql.plugin;

This should indicated that the sphinx plugin is installed.




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

Hello Dale,

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

Thanks


Luciano

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

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

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

Hi,

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

On Thu, Dec 29, 2011 at 17:26, Poulter,   Dale
dale.poul...@vanderbilt.edu wrote:
 Here is the output from the debug log.  The mysql log did not have any
errors.


 [Thu Dec 29 13:01:54 2011] [error]: Found more than one occurrence of
 the /Callbacks/AssetTracker/autohandler/Default callback.  This may
 cause only one of the callbacks to run.  Look for the duplicate
 Callback in your /apps/rt385/local/html
 /apps/rt385/local/plugins/RT-Authen

[rt-users] permissions in v4 versus v3.8.7

2012-01-04 Thread Poulter, Dale 
Greetings,

We are working towards migrating our RT installation from v3.8.7 to v4.0.4, but 
have encountered an issue with permissions.  We have a queue(maintenance) that 
gets many requests daily and often fills up the Newest Unowned section of the 
RT at a Glance.  In v3.8.7 we were able to give everyone create ticket rights 
to the maintenance queue but not view rights.  This resulted in everyone being 
able to submit to the maintenance queue but not see the unowned tickets.  In 
version 4 I have the same settings but the unowned tickets are showing even if 
the view queue is not selected.  Is this still possible in version 4? Am I 
missing something obvious?  Thanks.


--Dale

---
Dale Poulter
Automation Coordinator
Library Information Technology Services
Vanderbilt University
419 21st Avenue South, Room 812
Nashville, TN  37203-2427
(615)343-5388
(615)343-8834 (fax)
(615)207-9705 (cell)
dale.poul...@vanderbilt.edumailto:dale.poul...@vanderbilt.edu


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

Re: [rt-users] permissions in v4 versus v3.8.7

2012-01-04 Thread Poulter, Dale 
Thanks for the help.  This did seem to correct the issue, strange though that 
it worked in 3.8.7.

-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Thomas Sibley
Sent: Wednesday, January 04, 2012 3:13 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] permissions in v4 versus v3.8.7

On 01/04/2012 04:07 PM, Poulter, Dale wrote:
 In version 4 I have the same settings but the unowned tickets are 
 showing even if the “view queue” is not selected.  Is this still 
 possible in version 4? Am I missing something obvious?  Thanks.

I'm betting you don't actually have the same rights setup.  View Queue
is SeeQueue, and that only controls the visibility of the queue _name_.
 ShowTicket is the right that lets people see tickets in a queue.  You probably 
have it granted too widely.

Thomas

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

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

2011-12-29 Thread Poulter, Dale 
Here is the process I used.

From Mysql-5.5.17 source

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

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


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

mysql INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so';

mysqls elect * from mysql.plugin;

This should indicated that the sphinx plugin is installed.




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

Hello Dale,

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

Thanks


Luciano

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

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

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

Hi,

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

On Thu, Dec 29, 2011 at 17:26, Poulter,   Dale
dale.poul...@vanderbilt.edu wrote:
 Here is the output from the debug log.  The mysql log did not have any errors.


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

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

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

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

Hi,

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

On Thu, Dec 29, 2011 at 17:26, Poulter,   Dale
dale.poul...@vanderbilt.edu wrote:
 Here is the output from the debug log.  The mysql log did not have any errors.


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

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

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



-Original Message-
From: ruslan.zaki...@gmail.com [mailto:ruslan.zaki...@gmail.com] On Behalf Of 
Ruslan Zakirov
Sent: Friday, December 23, 2011 11:27 AM
To: Poulter, Dale
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Sphinx fulltext index v4.0.4

Hi,

Looks good. Move on to SQL log and debug log.

On Fri, Dec 23, 2011 at 21:13, Poulter,   Dale
dale.poul...@vanderbilt.edu wrote:
 Here is the output.  Thanks.

 mysql show create table AttachmentsIndex;
 +--+---+
 | Table| Create Table
 | |
 +--+---+
 | AttachmentsIndex | CREATE TABLE `AttachmentsIndex` (
  `id` int(10) unsigned NOT NULL,
  `weight` int(11) NOT NULL,
  `query` varchar(3072) NOT NULL,
  KEY `query` (`query`(1024))
 ) ENGINE=SPHINX DEFAULT CHARSET=utf8
 CONNECTION='sphinx://localhost:9312/rt' |
 +--+---+
 1 row in set (0.00 sec)

 -Original Message-
 From: ruslan.zaki...@gmail.com [mailto:ruslan.zaki...@gmail.com] On
 Behalf Of Ruslan Zakirov
 Sent: Friday, December 23, 2011 8:56 AM
 To: Poulter, Dale
 Cc: rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] Sphinx fulltext index v4.0.4

 On Fri, Dec 23, 2011 at 18:47, Poulter,   Dale
 dale.poul...@vanderbilt.edu wrote:
 Correct.  The index and table seems to have been created.  One strange item 
 is that the attatchmentindex table in MySQL is empty. Thanks for your help.

 It's sort of empty as it's dynamic. It's a special table that connects mysql 
 to sphinx. Run 'show create table AttachmentsIndex' and send us output.



 Sent from iphone


 On Dec 23, 2011, at 8:29 AM, Ruslan Zakirov r...@bestpractical.com wrote:

 On Fri, Dec 23, 2011 at 18:22, Poulter,   Dale
 dale.poul...@vanderbilt.edu wrote:
 I actually tried with and without the fulltext without any success.

 It's hard to say what went wrong. Just for clarification, you've
 created required tables with a script, configured RT's config,
 configured sphinx, setup indexer that puts data into sphinx index.
 Right?

 To diagnose this start with RT's debug log. Enable logging of SQL
 statements in RT. Use command line sphinx client to make sure data
 is in the index. At this moment we don't have any info to help you.

 Sent from iphone


 On Dec 23, 2011, at 3:09 AM, Ruslan Zakirov r...@bestpractical.com 
 wrote:

 On Thu, Dec 15, 2011 at 17:32, Poulter,   Dale
 dale.poul...@vanderbilt.edu wrote:
 However,  Request Tracker does not seem to be searching the index.
 If we

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

2011-12-23 Thread Poulter, Dale 
Correct.  The index and table seems to have been created.  One strange item is 
that the attatchmentindex table in MySQL is empty. Thanks for your help. 


Sent from iphone


On Dec 23, 2011, at 8:29 AM, Ruslan Zakirov r...@bestpractical.com wrote:

 On Fri, Dec 23, 2011 at 18:22, Poulter,   Dale
 dale.poul...@vanderbilt.edu wrote:
 I actually tried with and without the fulltext without any success.
 
 It's hard to say what went wrong. Just for clarification, you've
 created required tables with a script, configured RT's config,
 configured sphinx, setup indexer that puts data into sphinx index.
 Right?
 
 To diagnose this start with RT's debug log. Enable logging of SQL
 statements in RT. Use command line sphinx client to make sure data is
 in the index. At this moment we don't have any info to help you.
 
 Sent from iphone
 
 
 On Dec 23, 2011, at 3:09 AM, Ruslan Zakirov r...@bestpractical.com wrote:
 
 On Thu, Dec 15, 2011 at 17:32, Poulter,   Dale
 dale.poul...@vanderbilt.edu wrote:
 However,  Request Tracker does not seem to be searching the index.  If we
 search for any term that is only in the contents of the ticket and not the
 header we do not get any hits.  We do get hits for terms in the ticket
 header though.  If I search sphinx directly for a term everything works
 correctly.  It seems as if RT is not searching Sphinx.  Have I missed a 
 step
 in the setup process?  Any assistance will be appreciated.  Thanks.
 
 How do you search? It's still required to use fulltext:x in simple
 search and Content in the query builder.
 
 --
 Best regards, Ruslan.
 
 
 
 
 
 -- 
 Best regards, Ruslan.
 


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

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

2011-12-23 Thread Poulter, Dale 
Here is the output.  Thanks.

mysql show create table AttachmentsIndex;
+--+---+
| Table| Create Table   


   |
+--+---+
| AttachmentsIndex | CREATE TABLE `AttachmentsIndex` (
  `id` int(10) unsigned NOT NULL,
  `weight` int(11) NOT NULL,
  `query` varchar(3072) NOT NULL,
  KEY `query` (`query`(1024))
) ENGINE=SPHINX DEFAULT CHARSET=utf8 CONNECTION='sphinx://localhost:9312/rt' |
+--+---+
1 row in set (0.00 sec)

-Original Message-
From: ruslan.zaki...@gmail.com [mailto:ruslan.zaki...@gmail.com] On Behalf Of 
Ruslan Zakirov
Sent: Friday, December 23, 2011 8:56 AM
To: Poulter, Dale
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Sphinx fulltext index v4.0.4

On Fri, Dec 23, 2011 at 18:47, Poulter,   Dale
dale.poul...@vanderbilt.edu wrote:
 Correct.  The index and table seems to have been created.  One strange item 
 is that the attatchmentindex table in MySQL is empty. Thanks for your help.

It's sort of empty as it's dynamic. It's a special table that connects mysql to 
sphinx. Run 'show create table AttachmentsIndex' and send us output.



 Sent from iphone


 On Dec 23, 2011, at 8:29 AM, Ruslan Zakirov r...@bestpractical.com wrote:

 On Fri, Dec 23, 2011 at 18:22, Poulter,   Dale 
 dale.poul...@vanderbilt.edu wrote:
 I actually tried with and without the fulltext without any success.

 It's hard to say what went wrong. Just for clarification, you've 
 created required tables with a script, configured RT's config, 
 configured sphinx, setup indexer that puts data into sphinx index.
 Right?

 To diagnose this start with RT's debug log. Enable logging of SQL 
 statements in RT. Use command line sphinx client to make sure data is 
 in the index. At this moment we don't have any info to help you.

 Sent from iphone


 On Dec 23, 2011, at 3:09 AM, Ruslan Zakirov r...@bestpractical.com 
 wrote:

 On Thu, Dec 15, 2011 at 17:32, Poulter,   Dale 
 dale.poul...@vanderbilt.edu wrote:
 However,  Request Tracker does not seem to be searching the index.  
 If we search for any term that is only in the contents of the 
 ticket and not the header we do not get any hits.  We do get hits 
 for terms in the ticket header though.  If I search sphinx 
 directly for a term everything works correctly.  It seems as if RT 
 is not searching Sphinx.  Have I missed a step in the setup process?  Any 
 assistance will be appreciated.  Thanks.

 How do you search? It's still required to use fulltext:x in simple 
 search and Content in the query builder.

 --
 Best regards, Ruslan.





 --
 Best regards, Ruslan.


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



--
Best regards, Ruslan.


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

[rt-users] Sphinx fulltext index v4.0.4

2011-12-15 Thread Poulter, Dale 
Greetings,

We are testing an upgrade to version 4.0.4 from 3.8.7.  The upgrade went fine 
and we are able to view, submit, edit, etc.  We also want to implement the 
fulltext index using sphinx.  We have compiled sphinx, added it to mysql as a 
plugin and successfully ran the sbin/rt-setup-fulltext-index script.  We also 
added:

Set( %FullTextSearch,
Enable = 1,
Indexed= 1,
Table  = 'AttachmentsIndex',
MaxMatches = '1',
);

to the RT_SiteConfig.pm.  However,  Request Tracker does not seem to be 
searching the index.  If we search for any term that is only in the contents of 
the ticket and not the header we do not get any hits.  We do get hits for terms 
in the ticket header though.  If I search sphinx directly for a term everything 
works correctly.  It seems as if RT is not searching Sphinx.  Have I missed a 
step in the setup process?  Any assistance will be appreciated.  Thanks.



--Dale

---
Dale Poulter
Automation Coordinator
Library Information Technology Services
Vanderbilt University
419 21st Avenue South, Room 812
Nashville, TN  37203-2427
(615)343-5388
(615)343-8834 (fax)
(615)207-9705 (cell)
dale.poul...@vanderbilt.edumailto:dale.poul...@vanderbilt.edu


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

Re: [rt-users] Unable to access site after reboot -solved

2010-09-24 Thread Poulter, Dale 
The problem appears to have been related to the Scalar::Util  perl module.  It 
apparently was corrupted at some point.  Once I forced it to reinstall 
everything worked correctly. In order to find the bad module,  I ended up 
reinstalling several other modules -testing access after each.



From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Poulter, Dale
Sent: Friday, September 24, 2010 7:16 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Unable to access site after reboot
Importance: High

We have been running RT 387 for several months without any issues.  However,  
after a reboot of the server the site is not accessible.  When we attempt to 
access the site we get prompted to download the file.  This appears to point to 
a module not being loaded but no errors seem to be generated.  Have any one 
experienced this and resolved it?  Any suggestions?  Thanks.

--Dale

---
Dale Poulter
Automation Coordinator
Library Information Technology Services
Vanderbilt University
419 21st Avenue South, Room 812
Nashville, TN  37203-2427
(615)343-5388
(615)343-8834 (fax)
(615)207-9705 (cell)
dale.poul...@vanderbilt.edumailto:dale.poul...@vanderbilt.edu


RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!

[rt-users] RT permissions question

2010-05-25 Thread Poulter, Dale 
Good evening,

I have a group of users that have full access to all queues on the system.  
However,  we have on queue that this group should be able to open a ticket in 
but they should not be able to see the tickets in the new tickets.  Any 
suggestions as to how this can be done?  Thanks.



--Dale

---
Dale Poulter
Automation Coordinator
Library Information Technology Services
Vanderbilt University
419 21st Avenue South, Room 812
Nashville, TN  37203-2427
(615)343-5388
(615)343-8834 (fax)
(615)207-9705 (cell)
dale.poul...@vanderbilt.edumailto:dale.poul...@vanderbilt.edu


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] RT LDAP not loging in

2010-04-01 Thread Poulter, Dale 
Are you able to login if you turn off ldap authentication?  Also you may want 
to turn on the debugging in the RT_SiteConfig.pm

Set($LogToFile , 'debug');
Set($LogDir, '$RTHOME/var/log');
Set($LogToFileNamed , debug.log);


From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of JEEVAN P K
Sent: Thursday, April 01, 2010 7:05 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] RT LDAP not loging in


Hi,

I am new to RT and was trying to implement on my office space on my Ubuntu OS. 
i got the same installed but the issue is that i am  getting the LDAP 
authentication for the RT, but getting error with internel server.  I am not 
able to trace out the issue. Can anyone give me some inputs to resolve the 
issue.

Thanks  Regards,
Jeevan

Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Mergeusers problem

2010-03-31 Thread Poulter, Dale 
Good morning,


We have just started using the MergeUsers plugin. The merging of users seems to 
work great but the user is then unable to see their tickets using either 
account.  Are we missing something obvious?  Thanks.

--Dale

---
Dale Poulter
Automation Coordinator
Library Information Technology Services
Vanderbilt University
Suite 700
110 21st Avenue South
Nashville, TN  37240
(615)343-5388
(615)343-8834 (fax)
(615)207-9705 (cell)
dale.poul...@vanderbilt.edumailto:dale.poul...@vanderbilt.edu


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Mergeusers problem

2010-03-31 Thread Poulter, Dale 
This worked great. Thanks.

From: Brumm, Torsten / Kuehne + Nagel / Ham MI-ID 
[mailto:torsten.br...@kuehne-nagel.com]
Sent: Wednesday, March 31, 2010 8:57 AM
To: Poulter, Dale; rt-users@lists.bestpractical.com
Subject: AW: [rt-users] Mergeusers problem

Have a look onto additional pakckage rt-extension-mergeusershistory this the 
one you need!

Torsten


Von: rt-users-boun...@lists.bestpractical.com 
rt-users-boun...@lists.bestpractical.com
An: rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com
Gesendet: Wed Mar 31 15:54:05 2010
Betreff: [rt-users] Mergeusers problem
Good morning,


We have just started using the MergeUsers plugin. The merging of users seems to 
work great but the user is then unable to see their tickets using either 
account.  Are we missing something obvious?  Thanks.

--Dale

---
Dale Poulter
Automation Coordinator
Library Information Technology Services
Vanderbilt University
Suite 700
110 21st Avenue South
Nashville, TN  37240
(615)343-5388
(615)343-8834 (fax)
(615)207-9705 (cell)
dale.poul...@vanderbilt.edumailto:dale.poul...@vanderbilt.edu



Kühne + Nagel (AG  Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), 
Dirk Blesius, Reiner Heiken, Bruno Mang, Alfred Manke, Christian Marnetté, Mark 
Reinhardt, Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, 
HRA 21928, USt-IdNr.: DE 812773878, Persönlich haftende Gesellschaft: Kühne  
Nagel A.G., Sitz: Contern/Luxemburg, Geschäftsführender Verwaltungsrat: 
Klaus-Michael Kühne


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

[rt-users] User information issue

2010-03-23 Thread Poulter, Dale 
All,

We use ldap for authentication and information.  The account creation and 
update of user information works great.  However,  we have some people that 
would like to use another email address.  If we change the email in the account 
it is overwritten the next time they log into the system.  Is there a way to 
not overwrite changes in the user's account?

--Dale

---
Dale Poulter
Automation Coordinator
Library Information Technology Services
Vanderbilt University
Suite 700
110 21st Avenue South
Nashville, TN  37240
(615)343-5388
(615)343-8834 (fax)
(615)207-9705 (cell)
dale.poul...@vanderbilt.edumailto:dale.poul...@vanderbilt.edu


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

[rt-users] RT and email addresses

2010-03-19 Thread Poulter, Dale 
Good morning,

We are running RT 3.8.7  and using LDAP for both authentication and 
information.  The process is working well but we have encounter several users 
that have their  email address in LDAP forwarded to another email address.  As 
a result, when the user replies to the ticket the system does not recognize the 
update.  If we change the email address in their record it is overwritten by 
the ldap information the next time they log into the system.  Has anyone found 
a solution to this type of situation?  Thanks in advance for your assistance.



--Dale

---
Dale Poulter
Automation Coordinator
Library Information Technology Services
Vanderbilt University
Suite 700
110 21st Avenue South
Nashville, TN  37240
(615)343-5388
(615)343-8834 (fax)
(615)207-9705 (cell)
dale.poul...@vanderbilt.edumailto:dale.poul...@vanderbilt.edu

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com

2010 RT Training Sessions!
San Francisco, CA, USA - Feb 22  23
Dublin, Ireland - Mar 15  16
Boston, MA, USA - April 5  6
Washington DC, USA - Oct 25  26

Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com