[rt-users] Trying top upgrade rt3 3.6.5 database to rt4 4.0.5 database.

2012-03-15 Thread Juanjo
Hello Again.

I´m trying to upgrade the old database to my new server database.

And i have problems with the 1b point.

   1b) Configure the new MySQL to use Latin1 as the default character
   set everywhere, not UTF-8.  This is necessary so the import in
   the next step assumes the data is Latin1.

Now i have this

character set clientutf8(Valor global)latin1 character set
connectionlatin1character set database
latin1 character set filesystembinary character set resultsutf8(Valor
global)latin1 character set serverlatin1 character set systemutf8
And all the database tables or fields is in utf8_general_ci.

Could you help me to make this database upgrade?

Thanks.
Kindest regards.


[rt-users] RT 4 Apache2 Performance Tuning

2012-03-15 Thread john s.

Test-System: RT 4.05 
Ubuntu:  10.4.3 Lucid  

Hello everybody 

We have an RT 3.8.9 System running in an Prod Environment 

Now i tried to find out the best Settings for the new RT-Version 4.0.5 that
we can migrate asap. 

But Rt 4.0 seems to slow ( especially the loadingtime from a webif page)  to
beat our Prod. One.

Maybe my settings aren't correct or i should use an other webhandler 

okay now here the facts:

reconfigure rt with  the webhandler flag for fastcgi: ./configure 
--with-web-handler=fastcgi

test  dependencies: make fixdeps 

Webhandler: fcgid

RT_SiteConfig: 

Set( $rtname, 'example.com');


1;


Set($JSMinPath, '/opt/rt4/bin/jsmin');


Set($WebPath, "/rt");

Set($WebDomain, '192.168.xxx.xxx')



apache config: 

 rt4.0fcgid




AddDefaultCharset UTF-8
AddHandler fcgid-script .fcgi

Alias /NoAuth/images/ /opt/rt4/share/html/NoAuth/images/
ScriptAlias /rt  /opt/rt4/sbin/rt-server.fcgi

DocumentRoot "/opt/rt4/share/html"

Order allow,deny
Allow from all

Options +ExecCGI
AddHandler fcgid-script fcgi


 


and here is the 
fcgid config: 


  AddHandlerfcgid-script .fcgi
  FcgidConnectTimeout 20



# FCGID Configuration. See more details:
#http://fastcgi.coremail.cn/doc.htm



IdleTimeout 7200


IdleScanInterval 480

BusyTimeout 3000


BusyScanInterval 480

ErrorScanInterval 3

ZombieScanInterval 3

ProcessLifeTime 86400

SocketPath /tmp/fcgid/sock.rt3

SpawnScoreUpLimit 10

SpawnScore 1

TerminationScore 2

MaxProcessCount 40

DefaultMaxClassProcessCount 32

DefaultMinClassProcessCount 3

IPCConnectTimeout 100

IPCCommTimeout 1200




# END FCGID CONFIG 





Maybe someone know some hints or tipps to speed up my rt 4.0 instance  

best regards 

john s. 















-- 
View this message in context: 
http://old.nabble.com/RT-4--Apache2-Performance-Tuning-tp33508831p33508831.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.



Re: [rt-users] Subject in Template options

2012-03-15 Thread Kevin Falcone
On Fri, Mar 02, 2012 at 02:44:57PM -0500, Joe Kirby wrote:

Joe - this line

>Subject: AutoReply: {$Ticket->Subject}

Is just adding AutoReply to the email that goes out.

>  Subject: [RT - Request Tracker #144013] AutoReply: test for attachement

The [RT - Request Tracker #144013] part is your $rtname or queue
Subject Tag setting plus the ticket id.

You don't *have* to have the Subject: Autoreply line, but remove it is
not going to remove RT's tag.  You can shorten that RT - Request
Tracker part by customizing a Subject Tag on each of your queues from
the Queue administration page.

I'm still not sure what the problem with thread is.  RT improved a few
threading things in later releases, but those are related to Owner
Change emails, not to Auto Replies and Correspondences.

-kevin


pgpGdR9YdJIsP.pgp
Description: PGP signature


Re: [rt-users] RES: Customer cannot see tickets with active custom status

2012-03-15 Thread Kevin Falcone
On Mon, Mar 05, 2012 at 12:41:25PM +, Diaulas Castro wrote:
> >>"I can't replicate this on a clean 4.0.5.  Have you customized the self 
> >>service at all?  It requests a list of all possibly active statuses to use 
> >>in the search, so if this is breaking, it's most likely because the 
> Requestor can't see a ticket in some queue." Kevin
> 
> SelfService intact as come from Ubuntu apt.
> 
> If I put the ticket number on top-right search box I got the ticket showing, 
> this exclude permission problem?

That removes permissions and moves on to "Is the user correctly listed as
a Requestor / Cc of the ticket".  It can be easy sometimes to have 2
accounts in RT, especially for unprivileged users, so make sure the
exact same user is logged in and listed as a Requestor.

-kevin


pgpUlfAb6OwjO.pgp
Description: PGP signature


Re: [rt-users] Open ticket VIA URL (Create.html) without authentication

2012-03-15 Thread Kevin Falcone
On Wed, Mar 14, 2012 at 08:51:25PM -0500, Seann wrote:
> I am researching a method that I can use to open a ticket from a web
> page not hosted on the RT system I have set up. I would rather not
> use email unless I absolutely have to.
> 
> The interface I am working on is an Ajax enabled content filter
> block page. It has an option to request that a site be unblocked in
> line to the page. I want that unblock request to drop into a ticket
> without the user interacting with the RT system.
> 
> I am using jquery as the core of my JavaScript, which intercepts the
> submit button click, and posts the data to RT. Everything works
> perfectly, except RT issuing a 302 back to my script, which is due
> to authentication (this was validated through a packet capture).
> 
> I have two options, to push this create ticket request without
> authentication or to figure out how RT expects authentication in
> relation to ticket creation requests.

A standard RT expects authentication as username/password.  You can
look at how issues.bestpractical.com implements the Login as Guest
button using JS to get an idea of what you might need to do.  You
may be able to post the appropriate parameters along with your
create request.

However, email would make it easy to set the Requestor properly as the
user submitting your form.

-kevin


pgpYImcCk2RYQ.pgp
Description: PGP signature


Re: [rt-users] Subject in Template options

2012-03-15 Thread Thomas Sibley
On 03/15/2012 11:51 AM, Kevin Falcone wrote:
>>  Subject: [RT - Request Tracker #144013] AutoReply: test for attachement
> 
> The [RT - Request Tracker #144013] part is your $rtname or queue
> Subject Tag setting plus the ticket id.

Joe: To be clear, whoever installed your RT set the $rtname config
option to "RT - Request Tracker".  (Either that or one of your queue
Subject Tags is set to it.)

You may want to fix $rtname to be something more sane (as documented in
/opt/rt4/etc/RT_Config.pm), however changing $rtname has implications
for email and you should understand what will break and how to prevent
the breakage before you change $rtname.


[rt-users] Graphs displaying "No tickets found"

2012-03-15 Thread Thomas Smith
Hi,

CentOS 4.8
RT 4.0.2

I'm working on setting up some saved graphs and am getting the error mentioned 
in the subject.

What I do is build my query and run it to ensure that it displays the expected 
results. Then I click on "Chart" to graph the data and it displays "No tickets 
found."

Not really sure what to do with this, I've Googled and didn't really find 
anything relevant to the problem.

Any help would be appreciated.

Thank you,

~ Tom

[rt-users] rt 3.8.2 is not working after upgrade to centos 5.8

2012-03-15 Thread testwreq wreq
I upgraded centos from 5.5 to 5.8 release. I cannot get RT to work. the
browser tries to find some filetype to open a file.

Has anyone experienced this issue?


Re: [rt-users] rt-mailgate 302 Error. No, not Plack.

2012-03-15 Thread Jourdan Perla
Using 3.8 since there are no RT4 packages for Ubuntu 10.4 LTS. Attempts to 
manually install RT4 on Lucid would result in a whole 'nother ticket. Plan was 
to run 3.8 for now, then migrate to 4 on 12 this winter once things had settled 
down here.

No https redirects going on. I am using CAS Authentication (via mod_auth_cas) 
for the main site.


Apache httpd.conf
LoadFile /usr/lib/libcurl.so
LoadModule auth_cas_module /usr/lib/apache2/modules/mod_auth_cas.so

CASLoginURL https://cas.myserver.com/cas/login
CASValidateURL https://cas.myserver.com/cas/serviceValidate
CASCertificatePath /etc/ssl/certs/my_cas_bundle.pem
CASCookiePath /var/cache/apache2/mod_auth_cas/
CASSSOEnabled On
CASValidateServer On
CASDebug Off



 
   AuthType CAS
   AuthName " CAS"
 
   Require valid-user


   AllowOverRide None
   Satisfy Any


   AllowOverRide None
   Allow from all
   Satisfy Any


   Order allow,deny
   Allow from all
   Satisfy Any


   Order allow,deny
   Allow from all
   Satisfy Any


Satisfy Any
Allow from all


-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin Falcone
Sent: Wednesday, March 14, 2012 4:49 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] rt-mailgate 302 Error. No, not Plack.

On Wed, Mar 14, 2012 at 09:43:47PM +, Jourdan Perla wrote:
> 
> An Error Occurred
> =
> 
> 302 Found
> 
> /usr/bin/rt-mailgate: undefined server error

This is Apache issuing a 302 before it gets to RT

> Grep all my logs for what happens at the same time and
> apache2/access.log:
> rt.myserver.com - - [14/Mar/2012:14:05:33 -0700] "POST 
> /rt/REST/1.0/NoAuth/mail-gateway HTTP/1.1" 302 715 "-" "libwww-perl/6.04"
> 
> I've got the following in my httpd.conf
> 
> 
>AllowOverRide None
>Satisfy Any
> 
> 
>AllowOverRide None
>Allow from all
>Satisfy Any
> 
> 
>Order allow,deny
>Allow from all
>Satisfy Any
> 
> 
>Order allow,deny
>Allow from all
>Satisfy Any
> 

What else do you have in apache.  Are you redirecting from http to https?  
Since you're using the debian packages, what else is going on there.  Also, 
this is where I feel compelled to ask why you're using
3.8 rather than 4.0 for a new install.

-kevin


[rt-users] FW: rt-mailgate 302 Error. No, not Plack.

2012-03-15 Thread Jourdan Perla
Missed a Location in /etc/request-tracker3.8/apache2-modperl2.conf



Order Allow,Deny
Allow from rt.myserver.com


Did the trick.

-Jourdan


-Original Message-
From: Jourdan Perla 
Sent: Thursday, March 15, 2012 10:44 AM
To: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] rt-mailgate 302 Error. No, not Plack.

Using 3.8 since there are no RT4 packages for Ubuntu 10.4 LTS. Attempts to 
manually install RT4 on Lucid would result in a whole 'nother ticket. Plan was 
to run 3.8 for now, then migrate to 4 on 12 this winter once things had settled 
down here.

No https redirects going on. I am using CAS Authentication (via mod_auth_cas) 
for the main site.


Apache httpd.conf
LoadFile /usr/lib/libcurl.so
LoadModule auth_cas_module /usr/lib/apache2/modules/mod_auth_cas.so

CASLoginURL https://cas.myserver.com/cas/login
CASValidateURL https://cas.myserver.com/cas/serviceValidate
CASCertificatePath /etc/ssl/certs/my_cas_bundle.pem CASCookiePath 
/var/cache/apache2/mod_auth_cas/ CASSSOEnabled On CASValidateServer On CASDebug 
Off 


 
   AuthType CAS
   AuthName " CAS"
 
   Require valid-user


   AllowOverRide None
   Satisfy Any


   AllowOverRide None
   Allow from all
   Satisfy Any


   Order allow,deny
   Allow from all
   Satisfy Any


   Order allow,deny
   Allow from all
   Satisfy Any


Satisfy Any
Allow from all


-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin Falcone
Sent: Wednesday, March 14, 2012 4:49 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] rt-mailgate 302 Error. No, not Plack.

On Wed, Mar 14, 2012 at 09:43:47PM +, Jourdan Perla wrote:
> 
> An Error Occurred
> =
> 
> 302 Found
> 
> /usr/bin/rt-mailgate: undefined server error

This is Apache issuing a 302 before it gets to RT

> Grep all my logs for what happens at the same time and
> apache2/access.log:
> rt.myserver.com - - [14/Mar/2012:14:05:33 -0700] "POST 
> /rt/REST/1.0/NoAuth/mail-gateway HTTP/1.1" 302 715 "-" "libwww-perl/6.04"
> 
> I've got the following in my httpd.conf
> 
> 
>AllowOverRide None
>Satisfy Any
> 
> 
>AllowOverRide None
>Allow from all
>Satisfy Any
> 
> 
>Order allow,deny
>Allow from all
>Satisfy Any
> 
> 
>Order allow,deny
>Allow from all
>Satisfy Any
> 

What else do you have in apache.  Are you redirecting from http to https?  
Since you're using the debian packages, what else is going on there.  Also, 
this is where I feel compelled to ask why you're using
3.8 rather than 4.0 for a new install.

-kevin


[rt-users] Relational Graphs not displaying in RT 4.0.5

2012-03-15 Thread Christopher Lasater
I no longer see the Relational graphs in RT 4.0.5 after upgrading.  The
legend does appear but the graph is just a box with an X in it.  I have
attached the error logs if I go to the page.  Also, nothing appears in
the rt logs on the actual server.  

Is anyone on 4.0.5 able to see these graphs or is this just me?

Chris
System Error: ack Broken pipe: write( 21, 'digraph ticket_links_142 {
ratio="fill";
bgcolor="transparent";
node [fillcolor="white", shape="box", 
style="filled,rounded"];
node1 [URL="/Ticket/Display.html?id=142", 
fontcolor="#FF", fontsize="10", label="142", 
style="filled,rounded", tooltip="test2"];
}
' ) at /opt/rt4/perl5lib/lib/site_perl/5.12.4/IPC/Run/IO.pm line 558



Trace begun at /opt/rt4/perl5lib/lib/perl5/HTML/Mason/Exceptions.pm line 129
HTML::Mason::Exceptions::rethrow_exception('System Error: ack Broken pipe: 
write( 21, \'digraph ticket_links_142 
{^J^Iratio="fill";^J^Ibgcolor="transparent";^J^Inode 
[fillcolor="white", shape="box", 
style="filled,rounded"];^J^Inode1 
[URL="/Ticket/Display.html?id=142", fontcolor="#FF", 
fontsize="10", label="142", 
style="filled,rounded", tooltip="test2"];^J}^J\' ) at 
/opt/rt4/perl5lib/lib/site_perl/5.12.4/IPC/Run/IO.pm line 558^J^J') called at 
/opt/rt4/sbin/../lib/RT/Util.pm line 95
RT::Util::safe_run_child('CODE(0x123e67b8)') called at 
/opt/opt/rt4/share/html/Ticket/Graphs/dhandler line 76
HTML::Mason::Commands::__ANON__('Ticket', 'RT::Ticket=HASH(0x1aa70738)', 
'MaxDepth', 3, 'id', 142, 'LeadingLink', 'Members', 'ShowLinks', 
'ARRAY(0x123c8768)') called at 
/opt/rt4/perl5lib/lib/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x123d2660)',
 'Ticket', 'RT::Ticket=HASH(0x1aa70738)', 'MaxDepth', 3, 'id', 142, 
'LeadingLink', 'Members', 'ShowLinks', 'ARRAY(0x123c8768)') called at 
/opt/rt4/perl5lib/lib/perl5/HTML/Mason/Request.pm line 1302
eval {...} at /opt/rt4/perl5lib/lib/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'Ticket', 
'RT::Ticket=HASH(0x1aa70738)', 'MaxDepth', 3, 'id', 142, 'LeadingLink', 
'Members', 'ShowLinks', 'ARRAY(0x123c8768)') called at 
/opt/rt4/perl5lib/lib/perl5/HTML/Mason/Request.pm line 955
HTML::Mason::Request::call_next('RT::Interface::Web::Request=HASH(0x12344418)') 
called at /opt/opt/rt4/share/html/Ticket/autohandler line 19
HTML::Mason::Commands::__ANON__('Ticket', 'RT::Ticket=HASH(0x1aa70738)', 
'MaxDepth', 3, 'id', 142, 'LeadingLink', 'Members', 'ShowLinks', 
'ARRAY(0x123c8768)') called at 
/opt/rt4/perl5lib/lib/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x123c7e98)',
 'Ticket', 'RT::Ticket=HASH(0x1aa70738)', 'MaxDepth', 3, 'id', 142, 
'LeadingLink', 'Members', 'ShowLinks', 'ARRAY(0x123c8768)') called at 
/opt/rt4/perl5lib/lib/perl5/HTML/Mason/Request.pm line 1302
eval {...} at /opt/rt4/perl5lib/lib/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'Ticket', 
'RT::Ticket=HASH(0x1aa70738)', 'MaxDepth', 3, 'id', 142, 'LeadingLink', 
'Members', 'ShowLinks', 'ARRAY(0x123c8768)') called at 
/opt/rt4/sbin/../lib/RT/Interface/Web.pm line 548
RT::Interface::Web::ShowRequestedPage('HASH(0x12353f38)') called at 
/opt/rt4/sbin/../lib/RT/Interface/Web.pm line 295
RT::Interface::Web::HandleRequest('HASH(0x12353f38)') called at 
/opt/opt/rt4/share/html/autohandler line 53
HTML::Mason::Commands::__ANON__('Ticket', 'RT::Ticket=HASH(0x1aa70738)', 
'MaxDepth', 3, 'id', 142, 'LeadingLink', 'Members', 'ShowLinks', 
'ARRAY(0x123b04f8)') called at 
/opt/rt4/perl5lib/lib/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x121d3e70)',
 'Ticket', 'RT::Ticket=HASH(0x1aa70738)', 'MaxDepth', 3, 'id', 142, 
'LeadingLink', 'Members', 'ShowLinks', 'ARRAY(0x123b04f8)') called at 
/opt/rt4/perl5lib/lib/perl5/HTML/Mason/Request.pm line 1297
eval {...} at /opt/rt4/perl5lib/lib/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'Ticket', 
'RT::Ticket=HASH(0x1aa70738)', 'MaxDepth', 3, 'id', 142, 'LeadingLink', 
'Members', 'ShowLinks', 'ARRAY(0x123b04f8)') called at 
/opt/rt4/perl5lib/lib/perl5/HTML/Mason/Request.pm line 481
eval {...} at /opt/rt4/perl5lib/lib/perl5/HTML/Mason/Request.pm line 481
eval {...} at /opt/rt4/perl5lib/lib/perl5/HTML/Mason/Request.pm line 433
HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x12344418)') 
called at /opt/rt4/perl5lib/lib/site_perl/5.12.4/HTML/Mason/PSGIHandler.pm line 
85
eval {...} at /opt/rt4/perl5lib/lib/site_perl/5.12.4/HTML/Mason/PSGIHandler.pm 
line 85
HTML::Mason::Request::PSGI::exec('RT::Interface::Web::Request=HASH(0x12344418)')
 called at /opt/rt4/perl5lib/lib/perl5/HTML/Mason/Interp.pm line 342
HTML::Mason::Interp::exec(undef, undef, 'Ticket', 
'RT::Ticket=HASH(0x1aa70738)', 'MaxDepth', 3, 'id', 142, 'LeadingLink', 
'Members', 'ShowLinks', 'ARRAY(0x123b04f8)') called at 
/opt/rt4/perl5li

[rt-users] Displaying the Articles menu in the SelfService interface

2012-03-15 Thread Thomas Smith
Hi,

I would like to be able to display certain classes of articles to unprivileged 
users and allow them to access those whenever they need. Is this possible? I'm 
able to configure the rights for those users (Unprivileged) but the menu option 
isn't showing up in the SelfService interface.

~ Tom

Re: [rt-users] rt-mailgate 302 Error. No, not Plack.

2012-03-15 Thread Tim Cutts

On 15 Mar 2012, at 17:44, Jourdan Perla wrote:

> Using 3.8 since there are no RT4 packages for Ubuntu 10.4 LTS. Attempts to 
> manually install RT4 on Lucid would result in a whole 'nother ticket.

I'm running 4.0.5 on Lucid.  Wasn't really a problem; I just don't use the 
packaged version and let 'make fixdeps' do its thing.  As you say though, 
waiting for 12.04 to come out is probably sensible, since Dominic *has* 
packaged rt4 more recently.

At one point I went to the effort of using dh-make-perl to update perl module 
packages to versions that RT needed, but for my 4.0.5 deployment I just thought 
"sod it" and took the fixdeps route.

The really hard bit actually was getting SphinxSE to work with the 
lucid-supplied MySQL server. *that* was painful, and I think if I were doing it 
again, I wouldn't use the packaged MySQL server either.  Actually, if I were 
really starting again I wouldn't use MySQL at all.

It's the Siren of databases, seducing you in with its lovely songs and apparent 
ease of use, and then smashing you to pieces on the rocks. :-/

Tim

--
 The Wellcome Trust Sanger Institute is operated by Genome Research
 Limited, a charity registered in England with number 1021457 and a
 company registered in England with number 2742969, whose registered
 office is 215 Euston Road, London, NW1 2BE.


Re: [rt-users] Relational Graphs not displaying in RT 4.0.5

2012-03-15 Thread Christopher Lasater
Found the problem.  Something is wrong with my compiled GraphViz/expat
dependencies.  


On Thu, 2012-03-15 at 14:35 -0400, Christopher Lasater wrote:
> I no longer see the Relational graphs in RT 4.0.5 after upgrading.  The
> legend does appear but the graph is just a box with an X in it.  I have
> attached the error logs if I go to the page.  Also, nothing appears in
> the rt logs on the actual server.  
> 
> Is anyone on 4.0.5 able to see these graphs or is this just me?
> 
> Chris



Re: [rt-users] rt 3.8.2 is not working after upgrade to centos 5.8

2012-03-15 Thread Ruslan Zakirov
On Thu, Mar 15, 2012 at 21:01, testwreq wreq  wrote:
> I upgraded centos from 5.5 to 5.8 release. I cannot get RT to work. the
> browser tries to find some filetype to open a file.
>
> Has anyone experienced this issue?

Most probably you upgrade downgraded perl modules below versions
required by RT. Use rt-test-dependencies script or make testdeps from
RT's tarball.



-- 
Best regards, Ruslan.


Re: [rt-users] Graphs displaying "No tickets found"

2012-03-15 Thread Ruslan Zakirov
Hi,

I recall similar bug and it was related to query you use to search for
tickets. Send us full query, use advanced page of the query builder.

On Thu, Mar 15, 2012 at 20:42, Thomas Smith  wrote:
> Hi,
>
> CentOS 4.8
> RT 4.0.2
>
> I'm working on setting up some saved graphs and am getting the error 
> mentioned in the subject.
>
> What I do is build my query and run it to ensure that it displays the 
> expected results. Then I click on "Chart" to graph the data and it displays 
> "No tickets found."
>
> Not really sure what to do with this, I've Googled and didn't really find 
> anything relevant to the problem.
>
> Any help would be appreciated.
>
> Thank you,
>
> ~ Tom



-- 
Best regards, Ruslan.


Re: [rt-users] Graphs displaying "No tickets found"

2012-03-15 Thread Thomas Smith
This is the simplest query that I've tried that doesn't work.

Updated = 'yesterday'

On Mar 15, 2012, at 1:24 PM, Ruslan Zakirov wrote:

> Hi,
> 
> I recall similar bug and it was related to query you use to search for
> tickets. Send us full query, use advanced page of the query builder.
> 
> On Thu, Mar 15, 2012 at 20:42, Thomas Smith  wrote:
>> Hi,
>> 
>> CentOS 4.8
>> RT 4.0.2
>> 
>> I'm working on setting up some saved graphs and am getting the error 
>> mentioned in the subject.
>> 
>> What I do is build my query and run it to ensure that it displays the 
>> expected results. Then I click on "Chart" to graph the data and it displays 
>> "No tickets found."
>> 
>> Not really sure what to do with this, I've Googled and didn't really find 
>> anything relevant to the problem.
>> 
>> Any help would be appreciated.
>> 
>> Thank you,
>> 
>> ~ Tom
> 
> 
> 
> -- 
> Best regards, Ruslan.



Re: [rt-users] Graphs displaying "No tickets found"

2012-03-15 Thread Thomas Smith
I played around with some different queries, based on your earlier comment. I 
was able to get a chart to display as expected when I did a simple search for a 
string in the subject line.

Subject LIKE 'String: '

Can I provide you any more data about this problem?

On Mar 15, 2012, at 1:31 PM, Thomas Smith wrote:

> This is the simplest query that I've tried that doesn't work.
> 
> Updated = 'yesterday'
> 
> On Mar 15, 2012, at 1:24 PM, Ruslan Zakirov wrote:
> 
>> Hi,
>> 
>> I recall similar bug and it was related to query you use to search for
>> tickets. Send us full query, use advanced page of the query builder.
>> 
>> On Thu, Mar 15, 2012 at 20:42, Thomas Smith  wrote:
>>> Hi,
>>> 
>>> CentOS 4.8
>>> RT 4.0.2
>>> 
>>> I'm working on setting up some saved graphs and am getting the error 
>>> mentioned in the subject.
>>> 
>>> What I do is build my query and run it to ensure that it displays the 
>>> expected results. Then I click on "Chart" to graph the data and it displays 
>>> "No tickets found."
>>> 
>>> Not really sure what to do with this, I've Googled and didn't really find 
>>> anything relevant to the problem.
>>> 
>>> Any help would be appreciated.
>>> 
>>> Thank you,
>>> 
>>> ~ Tom
>> 
>> 
>> 
>> -- 
>> Best regards, Ruslan.
> 



[rt-users] ExternalAuth problem

2012-03-15 Thread Sandra Wittenbrock

Hello,

About 6 months ago, I set up External Auth to use the ExternalAuth, with 
our ldap authentication server.  Recently, it stopped working.


I checked the syslog, and turned up the log level, but still did not get 
any useful error messages.


Mar 15 13:12:15 hpcrdticket RT: FAILED LOGIN for sandra from 
xxx.xxx.xxx.xxx (/usr/share/request-tracker3.8/lib/RT/Interface/Web.pm:457)



The same user was able to authenticate to the ldap service via another 
application.


Using TCP dump on the RT server, I don't see any network traffic between 
the RT server and the ldap server, when I try to use ldap 
authentication.  So, it looks like RT isn't trying to communicate with 
the LDAP server.  I am able to see pings between the machines using tcpdump.


Does anyone know how I can get some better log messages?  Or better yet, 
have some good idea of where/why RT seems to not be enabling the 
ExteralAuth?  As I mentioned, the config was working a couple weeks ago.


Between when it was working and now, I did install mergeuser, so my 
users can use multiple email addresses to create tickets.  You think the 
two could be interfering?  I double checked the settings in 
RT_SiteConfig.pm.


Set( @Plugins, (qw(
RT::Authen::ExternalAuth
RT::Extension::LDAPImport
RT::Extension::MergeUsers
RT::Extension::CommandByMail)));


Regards,

Sandra



[rt-users] rt-client 0.4 bug for uploading attachments

2012-03-15 Thread Thierry Thelliez
Today I found a bug in rt-client when trying to programmatically
create a ticket.  Uploaded binary files were corrupted.  In fact the
two last bytes were missing.  The bug is in client.rb.
Sorry, I just closed my VM but it is towards the end of the file at
the line including:

body << File.read(v)

An empty line should be added just after the file content. Here is my fix:

body << File.read(v)
body << "\r\n"



Cheers,
Thierry Thelliez


Re: [rt-users] Graphs displaying "No tickets found"

2012-03-15 Thread Kevin Falcone
On Thu, Mar 15, 2012 at 02:26:31PM -0700, Thomas Smith wrote:
> I played around with some different queries, based on your earlier comment. I 
> was able to get a chart to display as expected when I did a simple search for 
> a string in the subject line.
> 
> Subject LIKE 'String: '
> 
> Can I provide you any more data about this problem?
> 
> > This is the simplest query that I've tried that doesn't work.
> > 
> > Updated = 'yesterday'

I can confirm a failure for that search string on 4.0-trunk.
I'll forward your report into the bugtracker.

Thanks

-kevin


pgp3xDYFVBcBI.pgp
Description: PGP signature