[rt-users] occasional broken attachments, will be okay when forwarded
Hi, we run into broken attachments from time to time, broken in a sense that they can't be viewed, RT will return a 401 error. When we forward them, the attachments are okay for both Thunderbird and Outlook users. What's so strange about this is that it only happens from time to time. Did anyone encounter this? Any suggestions? Thank you all, Bernhard ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Images not centered
On Tue, Feb 24, 2009 at 09:27:33AM -, Javier Garcia wrote: Hello, I've just installed RT 3.8.2 on a Linux Debian Etch with apache2, mod_perl2 and MySQL. Everything is working, but some images are not centered, like the footnote with the RT info. I've tried using Firefox, IExplorer and Safari, but it's the same. You may not like this, but it's a feature, not a bug ;) To change this, you have to edit the css in /whatever_dir_rt_is_installed/share/html/NoAuth/css/web2/ for footer: layout.css - div#footer for login box: login.css - #login-box ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Images not centered
I see. Thanks -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Emmanuel Lacour Sent: 24 February 2009 09:45 To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Images not centered On Tue, Feb 24, 2009 at 09:27:33AM -, Javier Garcia wrote: Hello, I've just installed RT 3.8.2 on a Linux Debian Etch with apache2, mod_perl2 and MySQL. Everything is working, but some images are not centered, like the footnote with the RT info. I've tried using Firefox, IExplorer and Safari, but it's the same. You may not like this, but it's a feature, not a bug ;) To change this, you have to edit the css in /whatever_dir_rt_is_installed/share/html/NoAuth/css/web2/ for footer: layout.css - div#footer for login box: login.css - #login-box ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Long queue name coming out of frame on homepage
Hi, I am using RT 3.8.2, and I have a problem on the homepage. The length of the name of many of my queues are quite long(they follow a naming convention which tends to add a '.help' to the queue name) that it juts out of the the left frame, where we see tabs like homepage,configuration etc.. Earlier in 3.6, I didnt have this problem because the layout was different. I tried a lot to wrap the text, but in firefox which is the browser many ppl here use, I am unable to do so. Can anyone help me out here? -Ashish ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] RTx::WorkflowBuilder is now available on CPAN
Hi, RTx::WorkflowBuilder is a tool that helps you configure multi-stage approval workflow in rt. It is now available at http://search.cpan.org/dist/RTx-WorkflowBuilder/. examples can be found in the doc at http://search.cpan.org/dist/RTx-WorkflowBuilder/bin/rt-workflow Cheers, CLK ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] anybody using RTx::Statistics
anybody using RTx::Statistics package? I'm on 3.8.2. seems like the last dev on this package was done in 2006. Just wondering if anybody's got it up and running nicely? -- Calvin Chiang Network Admin Utilyx 1st Floor, 55 North Wharf Road Paddington London, W2 1LA Tel: 020 7087 8673 www.utilyx.com __ Utilyx is the trading name of Utilyx Limited and Utilyx Risk Management Limited (URML). URML is authorised and regulated by the Financial Services Authority (FSA). This message contains information that may be privileged or confidential and is the property of Utilyx. It is intended only for the person to whom it is addressed. No confidentiality or privilege is waived or lost by any mistransmission. Any views or opinions expressed in this message are solely those of the author and do not necessarily represent those of Utilyx. Unless otherwise stated, any pricing information given in this message is indicative only and does not constitute an offer to deal at any price quoted. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] anybody using RTx::Statistics
Calvin, We're using a version of RTx::Statistics on RT v3.6.2. It's partly working. Histograms are OK, but the line graphs (Tkts per day, Multiple Qs, Time to resolve) display constant values across the entire graph. I think the query is gathering data just from the latest date rather than as an array across the date range, but we don't make great use of the package and so haven't seen this as a priority fix. The default RT reports get more use than RTx::Statistics charts. Steve Bioinformatics Health Protection Agency -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Calvin Chiang Sent: 24 February 2009 12:00 To: rt-users@lists.bestpractical.com Subject: [rt-users] anybody using RTx::Statistics anybody using RTx::Statistics package? I'm on 3.8.2. seems like the last dev on this package was done in 2006. Just wondering if anybody's got it up and running nicely? -- Calvin Chiang Network Admin Utilyx 1st Floor, 55 North Wharf Road Paddington London, W2 1LA Tel: 020 7087 8673 www.utilyx.com __ Utilyx is the trading name of Utilyx Limited and Utilyx Risk Management Limited (URML). URML is authorised and regulated by the Financial Services Authority (FSA). This message contains information that may be privileged or confidential and is the property of Utilyx. It is intended only for the person to whom it is addressed. No confidentiality or privilege is waived or lost by any mistransmission. Any views or opinions expressed in this message are solely those of the author and do not necessarily represent those of Utilyx. Unless otherwise stated, any pricing information given in this message is indicative only and does not constitute an offer to deal at any price quoted. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com - ** The information contained in the EMail and any attachments is confidential and intended solely and for the attention and use of the named addressee(s). It may not be disclosed to any other person without the express authority of the HPA, or the intended recipient, or both. If you are not the intended recipient, you must not disclose, copy, distribute or retain this message or any part of it. This footnote also confirms that this EMail has been swept for computer viruses, but please re-sweep any attachments before opening or saving. HTTP://www.HPA.org.uk ** ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Help with permissions?
On Tue, 24 Feb 2009 01:54:38 -0500, George Beitis george.bei...@googlemail.com wrote: If i did that, wouldn't that allow the user to view all the tickets in a queue? On Mon, Feb 23, 2009 at 5:16 PM, Stephen Turner stur...@mit.edu wrote: I think you may also need to grant SeeQueue on the queue to the group. Steve No, it just allows them to see the queue. ShowTicket would allow them to see all tickets. Steve -- Stephen Turner Senior Programmer/Analyst - SAIS MIT IST ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Approvals in 3.8.2
On Fri, Feb 20, 2009 at 8:43 AM, L B bertig...@gmail.com wrote: Hello, This extension looks very interesting. Do you have an idea of the release date ? Even a devel version for testing ? I saw that it was released now: http://search.cpan.org/~clkao/RTx-WorkflowBuilder-1.02/ Drew -- Drew Taylor * Web development consulting Email: d...@drewtaylor.com * Site implementation hosting Web : www.drewtaylor.com * perl/mod_perl/DBI/mysql/postgres ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Help with permissions?
On Tue, 24 Feb 2009 09:06:45 -0500, George Beitis george.bei...@googlemail.com wrote: That means that if a ticket they requested is not owned by them they wouldn't be able to see it right? That would depend on your other permissions - why not give it a try and see what happens? Good luck, Steve -- Stephen Turner Senior Programmer/Analyst - SAIS MIT IST ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Help with permissions?
That means that if a ticket they requested is not owned by them they wouldn't be able to see it right? On Tue, Feb 24, 2009 at 3:46 PM, Stephen Turner stur...@mit.edu wrote: On Tue, 24 Feb 2009 01:54:38 -0500, George Beitis george.bei...@googlemail.com wrote: If i did that, wouldn't that allow the user to view all the tickets in a queue? On Mon, Feb 23, 2009 at 5:16 PM, Stephen Turner stur...@mit.edu wrote: I think you may also need to grant SeeQueue on the queue to the group. Steve No, it just allows them to see the queue. ShowTicket would allow them to see all tickets. Steve -- Stephen Turner Senior Programmer/Analyst - SAIS MIT IST ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Searching for To: field in Content
Hopefully this is really simple, but I haven't got it working yet. I'm trying to search for text that would be in the To: field of the headers of a ticket that was created via email. I've found (finally) where this lives, it's in the attachment table in the DB. When building a query, content does seem to search the headers field in the Attachment table. Is there no way to do this through the web interface? I don't see Headers anywhere in the Query builder. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] anybody using RTx::Statistics
+1 PS : I had to make my own reports / graphs with direct Mysql queries and gnuplot to have exactly what I wanted. On Tue, 2009-02-24 at 12:17 +, Steven Platt wrote: Calvin, We're using a version of RTx::Statistics on RT v3.6.2. It's partly working. Histograms are OK, but the line graphs (Tkts per day, Multiple Qs, Time to resolve) display constant values across the entire graph. I think the query is gathering data just from the latest date rather than as an array across the date range, but we don't make great use of the package and so haven't seen this as a priority fix. The default RT reports get more use than RTx::Statistics charts. Steve Bioinformatics Health Protection Agency -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Calvin Chiang Sent: 24 February 2009 12:00 To: rt-users@lists.bestpractical.com Subject: [rt-users] anybody using RTx::Statistics anybody using RTx::Statistics package? I'm on 3.8.2. seems like the last dev on this package was done in 2006. Just wondering if anybody's got it up and running nicely? -- Oleg Sladkoff KELKOO - Service Architect oleg.sladk...@yahoo-inc.com Yahoo messenger : Kelkoooleg tel : +33 (0)476848147 gsm : +33(0)675768532 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Searching for To: field in Content
On Tue, Feb 24, 2009 at 09:27:34AM -0500, Stephen Cochran wrote: Hopefully this is really simple, but I haven't got it working yet. I'm trying to search for text that would be in the To: field of the headers of a ticket that was created via email. I've found (finally) where this lives, it's in the attachment table in the DB. When building a query, content does seem to search the headers field in the Attachment table. Is there no way to do this through the web interface? I don't see Headers anywhere in the Query builder. Currently, you will need to select content to search for something anywhere in the content including the headers. There is not a header specific item. This should not be too onerous if you have full-text indexing available. The Wiki has instructions currently for Oracle and PostgreSQL backends. Cheers, Ken ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] anybody using RTx::Statistics
thanks for the info guys! @Oleg is the gnuplot/mysql stuff fairly straightforward? (i dont code at all) Oleg Sladkoff wrote: +1 PS : I had to make my own reports / graphs with direct Mysql queries and gnuplot to have exactly what I wanted. On Tue, 2009-02-24 at 12:17 +, Steven Platt wrote: Calvin, We're using a version of RTx::Statistics on RT v3.6.2. It's partly working. Histograms are OK, but the line graphs (Tkts per day, Multiple Qs, Time to resolve) display constant values across the entire graph. I think the query is gathering data just from the latest date rather than as an array across the date range, but we don't make great use of the package and so haven't seen this as a priority fix. The default RT reports get more use than RTx::Statistics charts. Steve Bioinformatics Health Protection Agency -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Calvin Chiang Sent: 24 February 2009 12:00 To: rt-users@lists.bestpractical.com Subject: [rt-users] anybody using RTx::Statistics anybody using RTx::Statistics package? I'm on 3.8.2. seems like the last dev on this package was done in 2006. Just wondering if anybody's got it up and running nicely? -- Calvin Chiang Network Admin Utilyx 1st Floor, 55 North Wharf Road Paddington London, W2 1LA Tel: 020 7087 8673 www.utilyx.com __ Utilyx is the trading name of Utilyx Limited and Utilyx Risk Management Limited (URML). URML is authorised and regulated by the Financial Services Authority (FSA). This message contains information that may be privileged or confidential and is the property of Utilyx. It is intended only for the person to whom it is addressed. No confidentiality or privilege is waived or lost by any mistransmission. Any views or opinions expressed in this message are solely those of the author and do not necessarily represent those of Utilyx. Unless otherwise stated, any pricing information given in this message is indicative only and does not constitute an offer to deal at any price quoted. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Help with permissions?
On Tue, Feb 24, 2009 at 9:08 AM, Stephen Turner stur...@mit.edu wrote: On Tue, 24 Feb 2009 09:06:45 -0500, George Beitis george.bei...@googlemail.com wrote: That means that if a ticket they requested is not owned by them they wouldn't be able to see it right? That would depend on your other permissions - why not give it a try and see what happens? You may also be interested in this thread http://www.mail-archive.com/rt-users@lists.bestpractical.com/msg18209.html which allows perms to be applied before default views are constructed. -- /chown -R us:us /yourbase ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Second Instance Of RT (for branding purposes)
I'm so close nowbut it's always selecting brandy (the new brand). I'm
sure it's something small and simply that I'm missing now. I really
appreciate your help so far.
I know the whole brandx, brandy thing is a little confusing. I've double
checked all of the refences below, and brandx and brandy are used the
correct spots in each code snippet below.
Here is the output of the foo file that shows that the ENV variables are
being set:
tickets.brandy.com http://tickets.brandy.com
tickets.brandx.com http://tickets.brandx.com
tickets.brandy.com http://tickets.brandy.com
tickets.brandx.com http://tickets.brandx.com
tickets.brandy.com http://tickets.brandy.com
tickets.brandx.com http://tickets.brandx.com
tickets.brandy.com http://tickets.brandy.com
tickets.brandx.com http://tickets.brandx.com
tickets.brandy.com http://tickets.brandy.com
tickets.brandx.com http://tickets.brandx.com
I've double checked the httpd.conf file, inside of the brandy site, we have
PerlRequire /opt/rt3/bin/webmux-brandy.pl
Inside of the brandx site, we have
PerlRequire /opt/rt3/bin/webmux.pl
Here's my webmux.pl changes for the old brand:
#This drags in RT's config.pm
BEGIN {
$ENV{'SERVER'}= 'tickets.brandx.com http://tickets.brandx.com';
RT::LoadConfig();
if ($RT::DevelMode) { require Module::Refresh; }
}
Here's my webmux-brandy.pl changes for the old brand:
#This drags in RT's config.pm
BEGIN {
$ENV{'SERVER'}= 'tickets.brandy.com http://tickets.brandy.com';
RT::LoadConfig();
if ($RT::DevelMode) { require Module::Refresh; }
}
This is my RT.pm LoadConfig sub, right before it stats and loads the site
config file:
my $ser = $ENV{'SERVER'} ;
open F, /tmp/foo ;
print F $ser \n;
close F;
if ($ENV{'SERVER'} eq tickets.brandy.com http://tickets.brandy.com) {
$SITE_CONFIG_FILE = '/opt/rt3/etc/RT_SiteConfig-Refense.pm' ;
}
if ($ENV{'SERVER'} eq tickets.brandx.com http://tickets.brandx.com) {
$SITE_CONFIG_FILE = '/opt/rt3/etc/RT_SiteConfig.pm' ;
}
Sincerely,
Doug Eubanks
ad...@dougware.net
On Tue, Feb 24, 2009 at 9:53 AM, Raed El-Hames r...@vialtus.com wrote:
Sorry Doug my mistake its been a long time since I did this:
we set :
$ENV{'SERVER'}= 'my_brandx_instance.com http://my_brandx_instance.com
in the relavent webmux-brandx.pl , it would n't have existed before ..
The best bet to see if its loaded into ENV is by adding a print statement
in RT.pm LoadConfig, looking at my dev code I think I managed to do
something like
sub LoadConfig {
my $ser = $ENV{'SERVER'} ;
open F, /opt/rt3/bin/foo ;
print F $ser \n;
close F;
if ($ENV{'SERVER'} eq 'my_brandx_instance.com
http://my_brandx_instance.com' ) {
$SITE_CONFIG_FILE = '/opt/rt3/local/etc/RT_SiteConfig_brandx.pm' ;
}
I think at the time of restarting apache something will be written to the
foo file
Roy
Doug Eubanks wrote:
Here is my relevant httpd.conf sectionsI've sanitized the
hostnames..
VirtualHost *:80
CacheEnable disk /
ServerAdmin supp...@brandy.com mailto:supp...@brandy.com
DocumentRoot /opt/rt3/share/html
ServerName tickets.brandy.com http://tickets.brandy.com
ServerAlias tickets.brandy.com http://tickets.brandy.com
tickets2.brandy.com http://tickets2.brandy.com ticket.brandy.com
http://ticket.brandy.com ticket2.brandy.com http://ticket2.brandy.com
AddDefaultCharset UTF-8
PerlModule Apache::DBI
PerlRequire /opt/rt3/bin/webmux.pl
PerlSetVar MasonStaticSource true
PerlSetVar MasonBufferPreallocateSize 1073741824
PerlSetVar MasonDataCacheDefaults cache_class= SharedMemoryCache,
cache_de $
PerlSetVar MasonPreloads '/Elements/*'
PerlSetVar MasonCompRoot /opt/rt3
SetHandler perl-script
PerlHandler RT::Mason
Alias /titan /opt/rt3/share/html
# ScriptAlias /titan/ /opt/rt3/share/html
/VirtualHost
VirtualHost *:80
CacheEnable disk /
ServerAdmin supp...@brandx.com mailto:supp...@brandx.com
DocumentRoot /opt/rt3/share/html
ServerName tickets.brandx.com http://tickets.brandx.com
ServerAlias tickets.brandx.com http://tickets.brandx.com
tickets2.brandx.com http://tickets2.brandx.com ticket.brandx.com
http://ticket.brandx.com ticket2.brandx.com http://ticket2.brandx.com
AddDefaultCharset UTF-8
PerlModule Apache::DBI
PerlRequire /opt/rt3/bin/webmux.pl
PerlSetVar MasonStaticSource true
PerlSetVar MasonBufferPreallocateSize 1073741824
PerlSetVar MasonDataCacheDefaults cache_class= SharedMemoryCache,
cache_de $
PerlSetVar MasonPreloads '/Elements/*'
PerlSetVar MasonCompRoot /opt/rt3
SetHandler perl-script
PerlHandler RT::Mason
Alias /refense /opt/rt3/share/html
# ScriptAlias /refense/ /opt/rt3/share/html
ErrorLog logs/error_log-tickets
/VirtualHost
Sincerely,
Doug Eubanks
ad...@dougware.net mailto:ad...@dougware.net
On Tue, Feb 24, 2009 at 5:45 AM, Raed El-Hames r...@vialtus.com mailto:
Re: [rt-users] Long queue name coming out of frame on homepage
On Tue, Feb 24, 2009 at 05:29, Potla, Ashish Bassaliel c_apo...@qualcomm.com wrote: Hi, I am using RT 3.8.2, and I have a problem on the homepage. The length of the name of many of my queues are quite long(they follow a naming convention which tends to add a '.help' to the queue name) that it juts out of the the left frame, where we see tabs like homepage,configuration etc.. Earlier in 3.6, I didnt have this problem because the layout was different. I tried a lot to wrap the text, but in firefox which is the browser many ppl here use, I am unable to do so. Such are the joys of CSS. You could try using one of using one of the older themes, reordering widgets so that it doesn't overlap anything else, or shortening the name. Else, have fun with Mason... -- Cambridge Energy Alliance: Save money. Save the planet. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] anybody using RTx::Statistics
Hello
If you want to adapt it , then you need to know bash/awk/sql/gnuplot but
this is not complicated (only a few lines of code)
however you can probably use it as is if you update the for q in line
only...
the reports created show tickets historic information per week
- tickets created per week per queue
- tickets resolved per week per queue
- currently open tickets per week
bash script :
#!/bin/bash
newTickets()
{
mysql -urt3 -p -h myhost rt3 -N -e select count(*) from
Tickets,Queues where Tickets.queue=Queues.id and Queues.name in ($QUEUE)
and date(Tickets.Created) between '$BEFORE' and '$DAY'
}
resolvedTickets()
{
mysql -urt3 -p -h myhost rt3 -N -e select count(*) from
Tickets,Queues where Tickets.queue=Queues.id and Queues.name in ($QUEUE)
and date(Tickets.Resolved) between '$BEFORE' and '$DAY'
}
openTickets()
{
mysql -urt3 -p -h myhost rt3 -N -e select count(*) from
Tickets,Queues where Tickets.queue=Queues.id and Queues.name in ($QUEUE)
and date(Tickets.Created)='$DAY' and ( date(Tickets.Resolved)'$DAY' or
status='new' or status='open' or status='stalled')
}
HISTORY=9
FULLHISTORY=100
let H=$HISTORY+1
DAY=$(date +%Y-%m-%d -d $H weeks ago )
HTMLPATH=/var/www/html/statistics
echo h1RT statistics/h1 $HTMLPATH/index.html
for q in 'ops.support':operations
'team1.support','team2.support','team3.support':backend
'team4.support','team5.support','team6..support':frontend
do
QUEUE=$(printf $q | cut -d: -f1)
QUEUENAME=$(printf $q | cut -d: -f2)
echo h3Tickets activity for queues
$QUEUE/h3$HTMLPATH/index.html
echo tabletrtda href=tickets_full_$QUEUENAME.pngimg
src=tickets_$QUEUENAME.png/a/td $HTMLPATH/index.html
echo $HTMLPATH/tickets_$QUEUENAME.csv
echo $HTMLPATH/tickets_full_$QUEUENAME.csv
for d in `seq $FULLHISTORY -1 0`
do
BEFORE=$DAY
DAY=$(date +%Y-%m-%d -d $d weeks ago )
[ $d -lt $HISTORY ] printf %s;%i;%i;%i\n $DAY $(newTickets)
$(openTickets) $(resolvedTickets) $HTMLPATH/tickets_$QUEUENAME.csv
printf %s;%i;%i;%i\n $DAY $(newTickets) $(openTickets)
$(resolvedTickets) $HTMLPATH/tickets_full_$QUEUENAME.csv
done
sed -e s/QUEUE/$QUEUENAME/g /root/RTstats/graphic.plt | gnuplot
awk -F\; ' BEGIN { printf(tdpre%16s%16s%16s%16s
\n,WeekEndingDay,NewTickets,OpenTickets,ResolvedTickets) }
{ printf(%16s%16s%16s%16s\n,$1,$2,$3,$4) }
END { print /pre/td/tr/tablebr } '
$HTMLPATH/tickets_$QUEUENAME.csv $HTMLPATH/index.html
done
gnuplot script :
set datafile separator ;
set terminal png small
set autoscale x
set mxtics 1
set yrange [0:140]
set xdata time
set timefmt %Y-%m-%d
set format x w%W
set style fill solid 9 border 0
set boxwidth 0.6 relative
set style line 1 lt 1 linewidth 3 pt 1 ps 0.5
set style line 2 lt 2 linewidth 3 pt 2 ps 0.5
set style line 3 lt 9 linewidth 3 pt 3 ps 0.5
set title tickets activity for QUEUE
set output /var/www/html/statistics/tickets_QUEUE.png
plot '/var/www/html/statistics/tickets_QUEUE.csv' using 1:3 title Total
remaining tickets with boxes ls 3 , \
'/var/www/html/statistics/tickets_QUEUE.csv' using 1:2 title
tickets created per week with lp ls 1 , \
'/var/www/html/statistics/tickets_QUEUE.csv' using 1:4 title
tickets resolved per week with lp ls 2
set terminal png small transparent
set boxwidth 1 relative
set autoscale y
set title tickets full activity for QUEUE
set format x %m/%y
set output /var/www/html/statistics/tickets_full_QUEUE.png
plot '/var/www/html/statistics/tickets_full_QUEUE.csv' using 1:3 title
Total remaining tickets with boxes ls 3 , \
'/var/www/html/statistics/tickets_full_QUEUE.csv' using 1:2 title
tickets created per week with lp ls 1 , \
'/var/www/html/statistics/tickets_full_QUEUE.csv' using 1:4 title
tickets resolved per week with lp ls 2
On Tue, 2009-02-24 at 15:04 +, Calvin Chiang wrote:
@Oleg
is the gnuplot/mysql stuff fairly straightforward?
(i dont code at all)
--
Oleg Sladkoff
KELKOO - Service Architect
oleg.sladk...@yahoo-inc.com
Yahoo messenger : Kelkoooleg
tel : +33 (0)476848147
gsm : +33(0)675768532
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
[rt-users] User given Administrator Privelages - Still can't make changes
Good Morning, We have a user that was just given administrator privelages to make some queue changes, but he cannot make any changes (given error Access Denied). Is there any tweak in the MySQL database so that I can forcefully grant him access to RT? We're running RT 3.6.6. -- Ryan Stepalavich Linux Windows Administrator SS Worldwide, Inc. (800) 537-3451 Ext. 2195 http://www.ssww.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] User given Administrator Privelages - Still can't make changes
On Tue, Feb 24, 2009 at 10:14:49AM -0500, Ryan Stepalavich wrote: Good Morning, We have a user that was just given administrator privelages to make some queue changes, but he cannot make any changes (given error Access Denied). Is there any tweak in the MySQL database so that I can forcefully grant him access to RT? What right exactly did you grant to him? What things you want to allow him to do? ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Second Instance Of RT (for branding purposes)
That's what I have, two different webmux.pl files...
They are in the same /opt/rt3/bin folder...
The old brand is called webmux.pl, the new brand is called webmux-brandy.pl
They are called in httpd.conf with these two separate lines in their
respective host entries...
PerlRequire /opt/rt3/bin/webmux-brandy.pl
PerlRequire /opt/rt3/bin/webmux.pl
Sincerely,
Doug Eubanks
ad...@dougware.net
On Tue, Feb 24, 2009 at 11:54 AM, Raed El-Hames r...@vialtus.com wrote:
Doug;
Looking at the http conf file you sent below, you seem to call the same
webmux.pl
PerlRequire /opt/rt3/bin/webmux.pl
You 'll need to have multiple versions of webmux.pl in each version you
add the line
$ENV{'SERVER'}= 'my_brand(?)_instance.com
http://my_brandx_instance.com
For example you have tickets.brandy.com http://tickets.brandy.com and
tickets.brandx.com http://tickets.brandy.com
httpd.conf :
VirtualHost tickets.brandy.com http://tickets.brandy.com:80
ServerName tickets.brandy.com http://tickets.brandy.com
DocumentRoot /opt/rt3/share/html
etc etc etc
PerlRequire /opt/rt3/bin/webmux-brandy http://tickets.brandy.com.pl
etc etc etc
/VirtualHost
VirtualHost tickets.brandx.com http://tickets.brandy.com:80
ServerName tickets.brandx.com http://tickets.brandy.com
DocumentRoot /opt/rt3/share/html
etc etc etc
PerlRequire /opt/rt3/bin/webmux-brandx http://tickets.brandy.com.pl
etc etc etc
/VirtualHost
Now webmux:
You should have atleast 2 copies in /opt/rt3/bin one called webmux-brandy
http://tickets.brandy.com.pl and the other webmux-brandx
http://tickets.brandy.com.pl
Edit webmux-brandy http://tickets.brandy.com.pl adding the line:
$ENV{'SERVER'}= 'tickets.brandy.com http://tickets.brandy.com';
where ENV is being set
so basically you'll end up with something similar to:
BEGIN {
$ENV{'PATH'} = '/bin:/usr/bin'; # or whatever you
need
$ENV{'CDPATH'} = '' if defined $ENV{'CDPATH'};
$ENV{'SHELL'} = '/bin/sh' if defined $ENV{'SHELL'};
$ENV{'ENV'}= '' if defined $ENV{'ENV'};
$ENV{'IFS'}= '' if defined $ENV{'IFS'};
$ENV{'SERVER'}= 'tickets.brandy.com http://tickets.brandy.com';
Now edit webmux-brandx http://tickets.brandy.com.pl adding the line
$ENV{'SERVER'}= 'tickets.brandx.com http://tickets.brandy.com';
where ENV is being set
so basically you'll end up with something similar to:
BEGIN {
$ENV{'PATH'} = '/bin:/usr/bin'; # or whatever you
need
$ENV{'CDPATH'} = '' if defined $ENV{'CDPATH'};
$ENV{'SHELL'} = '/bin/sh' if defined $ENV{'SHELL'};
$ENV{'ENV'}= '' if defined $ENV{'ENV'};
$ENV{'IFS'}= '' if defined $ENV{'IFS'};
$ENV{'SERVER'}= 'tickets.brandy.com http://tickets.brandy.com';
Now RT.pm
at the start of sub LoadConfig add the lines:
if ($ENV{'SERVER'} eq 'tickets.brandx.com http://tickets.brandy.com' )
{
$SITE_CONFIG_FILE = '/opt/rt3/local/etc/RT_SiteConfig_brandx.pm' ;
} elsif ($ENV{'SERVER'} eq 'tickets.brandy.com http://tickets.brandy.com'
) {
$SITE_CONFIG_FILE = '/opt/rt3/local/etc/RT_SiteConfig_brandy.pm' ;
}
Now RT_SiteConfig:
You should have atleast 2 copies RT_SiteConfig_brandx.pm, and
RT_SiteConfig_brandy.pm each have the instance customisation ,
And thats it..
Roy
Doug Eubanks wrote:
I'm so close nowbut it's always selecting brandy (the new brand). I'm
sure it's something small and simply that I'm missing now. I really
appreciate your help so far.
I know the whole brandx, brandy thing is a little confusing. I've double
checked all of the refences below, and brandx and brandy are used the
correct spots in each code snippet below.
Here is the output of the foo file that shows that the ENV variables are
being set:
tickets.brandy.com http://tickets.brandy.com http://tickets.brandy.com
tickets.brandx.com http://tickets.brandx.com http://tickets.brandx.com
tickets.brandy.com http://tickets.brandy.com http://tickets.brandy.com
tickets.brandx.com http://tickets.brandx.com http://tickets.brandx.com
tickets.brandy.com http://tickets.brandy.com http://tickets.brandy.com
tickets.brandx.com http://tickets.brandx.com http://tickets.brandx.com
tickets.brandy.com http://tickets.brandy.com http://tickets.brandy.com
tickets.brandx.com http://tickets.brandx.com http://tickets.brandx.com
tickets.brandy.com http://tickets.brandy.com http://tickets.brandy.com
tickets.brandx.com http://tickets.brandx.com http://tickets.brandx.com
I've double checked the httpd.conf file, inside of the brandy site, we
have
PerlRequire /opt/rt3/bin/webmux-brandy.pl
Inside of the brandx site, we have
PerlRequire /opt/rt3/bin/webmux.pl
Here's my webmux.pl changes for the old brand:
#This drags in RT's config.pm http://config.pm
BEGIN {
$ENV{'SERVER'}= 'tickets.brandx.com http://tickets.brandx.com
http://tickets.brandx.com';
RT::LoadConfig();
if
Re: [rt-users] Second Instance Of RT (for branding purposes)
And is RT calling the right RT_SiteConfig ?? I am guessing you have modified each RT_SiteConfig per brand?? what do you get when you restart apache and when you browse to each instance?? Roy Doug Eubanks wrote: That's what I have, two different webmux.pl files... They are in the same /opt/rt3/bin folder... The old brand is called webmux.pl, the new brand is called webmux-brandy.pl They are called in httpd.conf with these two separate lines in their respective host entries... PerlRequire /opt/rt3/bin/webmux-brandy.pl PerlRequire /opt/rt3/bin/webmux.pl Sincerely, Doug Eubanks ad...@dougware.net mailto:ad...@dougware.net ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] User given Administrator Privelages - Still can't make changes
We need the user to be able to add Ticket Custom Fields for queues. (Configuration/Queues/*Queue*/Ticket Custom Fields). -- Ryan Stepalavich Linux Windows Administrator SS Worldwide, Inc. (800) 537-3451 Ext. 2195 http://www.ssww.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] RT 3.8 and FastCGI out of memory via http but not https
I had RT 3.6.7 installed on a Debian Etch machine, and all was well. I decided to upgrade to RT 3.8.2, and I upgraded the machine from Etch to Lenny (making sure to clear out old custom-built Perl module packages). I rebuilt all the Perl dependencies missing from the Debian repositories, and upgraded my RT install. Now I have a strange issue...hitting RT 3.8 via HTTP results in an Out of memory! error in Apache's error.log, but visiting via HTTPS works fine. Another RT 3.6.7 instance on this box works fine with both. Apache vhost config (slightly edited for privacy on things like cert and site names): VirtualHost 1.2.3.4:80 127.0.1.1:80 ServerAdmin netadmin ServerName rt DocumentRoot /var/www/ Directory /home/rt/3.8_rt Options FollowSymLinks ExecCGI AllowOverride None /Directory ScriptAlias /3.8 /home/rt/3.8_rt/bin/mason_handler.fcgi Location /3.8 RewriteEngine On RedirectMatch Permanent /3.8$ $1/3.8/ /Location Directory /home/rt/3.6_rt Options FollowSymLinks ExecCGI AllowOverride None /Directory ScriptAlias /3.6 /home/rt/3.6_rt/bin/mason_handler.fcgi Location /3.6 RewriteEngine On RedirectMatch Permanent /3.6$ $1/3.6/ /Location /VirtualHost VirtualHost 1.2.3.4:443 127.0.1.1:443 ServerAdmin netadmin ServerName rt DocumentRoot /var/www/ Directory /home/rt/3.8_rt Options FollowSymLinks ExecCGI AllowOverride None /Directory ScriptAlias /3.8 /home/rt/3.8_rt/bin/mason_handler.fcgi Location /3.8 RewriteEngine On RedirectMatch Permanent /3.8$ $1/3.8/ /Location Directory /home/rt/3.6 Options FollowSymLinks ExecCGI AllowOverride None /Directory ScriptAlias /3.6 /home/rt/3.6_rt/bin/mason_handler.fcgi Location /3.6 RewriteEngine On RedirectMatch Permanent /3.6$ $1/3.6/ /Location SSLEngine On SSLCertificateKeyFile /etc/ssl/private/rt.key SSLCertificateFile /etc/ssl/certs/rt.crt SSLCACertificateFile /etc/ssl/certs/intermediate.crt SetEnvIf User-Agent .*MSIE.* nokeepalive ssl-unclean-shutdown downgrade-1.0 force-response-1.0 /VirtualHost Apache2 error.log excerpt: [Tue Feb 24 10:29:15 2009] [warn] FastCGI: (dynamic) server /home/rt/3.8_rt/bin/mason_handler.fcgi started (pid 5872) [Tue Feb 24 10:29:18 2009] [warn] FastCGI: (dynamic) server /home/rt/3.8_rt/bin/mason_handler.fcgi started (pid 5875) Out of memory! [Tue Feb 24 10:29:19 2009] [error] [client 10.202.35.3] FastCGI: incomplete headers (0 bytes) received from server /home/rt/3.8_rt/bin/mason_handler.fcgi [Tue Feb 24 10:29:20 2009] [warn] FastCGI: (dynamic) server /home/rt/3.8_rt/bin/mason_handler.fcgi (pid 5872) terminated by calling exit with status '1' Out of memory! [Tue Feb 24 10:31:26 2009] [error] [client 10.202.35.3] FastCGI: incomplete headers (0 bytes) received from server /home/rt/3.8_rt/bin/mason_handler.fcgi [Tue Feb 24 10:31:26 2009] [warn] FastCGI: (dynamic) server /home/rt/3.8_rt/bin/mason_handler.fcgi (pid 5875) terminated by calling exit with status '1' [Tue Feb 24 10:31:26 2009] [warn] FastCGI: (dynamic) server /home/rt/3.8_rt/bin/mason_handler.fcgi restarted (pid 5898) Out of memory! [Tue Feb 24 10:31:30 2009] [error] [client 10.202.35.3] FastCGI: incomplete headers (0 bytes) received from server /home/rt/3.8_rt/bin/mason_handler.fcgi [Tue Feb 24 10:31:30 2009] [warn] FastCGI: (dynamic) server /home/rt/3.8_rt/bin/mason_handler.fcgi (pid 5898) terminated by calling exit with status '1' [Tue Feb 24 10:31:31 2009] [warn] FastCGI: (dynamic) server /home/rt/3.8_rt/bin/mason_handler.fcgi restarted (pid 5902) Out of memory! [Tue Feb 24 10:31:38 2009] [error] [client 10.202.35.3] FastCGI: incomplete headers (0 bytes) received from server /home/rt/3.8_rt/bin/mason_handler.fcgi [Tue Feb 24 10:31:38 2009] [warn] FastCGI: (dynamic) server /home/rt/3.8_rt/bin/mason_handler.fcgi (pid 5902) terminated by calling exit with status '1' [Tue Feb 24 10:31:38 2009] [warn] FastCGI: (dynamic) server /home/rt/3.8_rt/bin/mason_handler.fcgi has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds fastcgi.conf: IfModule mod_fastcgi.c AddHandler fastcgi-script .fcgi FastCgiIpcDir /tmp /IfModule Oh, and here's what the system memory looks like: total used free sharedbuffers cached Mem:386252 279420 106832 0 45484 103824 -/+ buffers/cache: 130112 256140 Swap: 1044184 881044096 Any thoughts? Any other logs or config info that could be useful in troubleshooting this?
Re: [rt-users] RT 3.8 and FastCGI out of memory via http but not https
-- Steve Christou UWM Information Security Phone: 414-229-1100 Email: osa-l...@uwm.edu ---BeginMessage--- I had this same issue. This worked for me. First login to your mysql database Mysql –p –u root –D rtdb This will log you in as root(-u) in the rtdb database(-D) with a prompt for a password(-p). Next, we want to change the session tables. Type in this exact command when you get to the mysql prompt (note capitalization areas): /ALTER TABLE sessions CHANGE a_session a_session LONGBLOB;/ // A lot of people have been having this issue, but hopefully this will fix the issue. Nick Kartsioukas wrote: I had RT 3.6.7 installed on a Debian Etch machine, and all was well. I decided to upgrade to RT 3.8.2, and I upgraded the machine from Etch to Lenny (making sure to clear out old custom-built Perl module packages). I rebuilt all the Perl dependencies missing from the Debian repositories, and upgraded my RT install. Now I have a strange issue...hitting RT 3.8 via HTTP results in an Out of memory! error in Apache's error.log, but visiting via HTTPS works fine. Another RT 3.6.7 instance on this box works fine with both. Apache vhost config (slightly edited for privacy on things like cert and site names): VirtualHost 1.2.3.4:80 127.0.1.1:80 ServerAdmin netadmin ServerName rt DocumentRoot /var/www/ Directory /home/rt/3.8_rt Options FollowSymLinks ExecCGI AllowOverride None /Directory ScriptAlias /3.8 /home/rt/3.8_rt/bin/mason_handler.fcgi Location /3.8 RewriteEngine On RedirectMatch Permanent /3.8$ $1/3.8/ /Location Directory /home/rt/3.6_rt Options FollowSymLinks ExecCGI AllowOverride None /Directory ScriptAlias /3.6 /home/rt/3.6_rt/bin/mason_handler.fcgi Location /3.6 RewriteEngine On RedirectMatch Permanent /3.6$ $1/3.6/ /Location /VirtualHost VirtualHost 1.2.3.4:443 127.0.1.1:443 ServerAdmin netadmin ServerName rt DocumentRoot /var/www/ Directory /home/rt/3.8_rt Options FollowSymLinks ExecCGI AllowOverride None /Directory ScriptAlias /3.8 /home/rt/3.8_rt/bin/mason_handler.fcgi Location /3.8 RewriteEngine On RedirectMatch Permanent /3.8$ $1/3.8/ /Location Directory /home/rt/3.6 Options FollowSymLinks ExecCGI AllowOverride None /Directory ScriptAlias /3.6 /home/rt/3.6_rt/bin/mason_handler.fcgi Location /3.6 RewriteEngine On RedirectMatch Permanent /3.6$ $1/3.6/ /Location SSLEngine On SSLCertificateKeyFile /etc/ssl/private/rt.key SSLCertificateFile /etc/ssl/certs/rt.crt SSLCACertificateFile /etc/ssl/certs/intermediate.crt SetEnvIf User-Agent .*MSIE.* nokeepalive ssl-unclean-shutdown downgrade-1.0 force-response-1.0 /VirtualHost Apache2 error.log excerpt: [Tue Feb 24 10:29:15 2009] [warn] FastCGI: (dynamic) server /home/rt/3.8_rt/bin/mason_handler.fcgi started (pid 5872) [Tue Feb 24 10:29:18 2009] [warn] FastCGI: (dynamic) server /home/rt/3.8_rt/bin/mason_handler.fcgi started (pid 5875) Out of memory! [Tue Feb 24 10:29:19 2009] [error] [client 10.202.35.3] FastCGI: incomplete headers (0 bytes) received from server /home/rt/3.8_rt/bin/mason_handler.fcgi [Tue Feb 24 10:29:20 2009] [warn] FastCGI: (dynamic) server /home/rt/3.8_rt/bin/mason_handler.fcgi (pid 5872) terminated by calling exit with status '1' Out of memory! [Tue Feb 24 10:31:26 2009] [error] [client 10.202.35.3] FastCGI: incomplete headers (0 bytes) received from server /home/rt/3.8_rt/bin/mason_handler.fcgi [Tue Feb 24 10:31:26 2009] [warn] FastCGI: (dynamic) server /home/rt/3.8_rt/bin/mason_handler.fcgi (pid 5875) terminated by calling exit with status '1' [Tue Feb 24 10:31:26 2009] [warn] FastCGI: (dynamic) server /home/rt/3.8_rt/bin/mason_handler.fcgi restarted (pid 5898) Out of memory! [Tue Feb 24 10:31:30 2009] [error] [client 10.202.35.3] FastCGI: incomplete headers (0 bytes) received from server /home/rt/3.8_rt/bin/mason_handler.fcgi [Tue Feb 24 10:31:30 2009] [warn] FastCGI: (dynamic) server /home/rt/3.8_rt/bin/mason_handler.fcgi (pid 5898) terminated by calling exit with status '1' [Tue Feb 24 10:31:31 2009] [warn] FastCGI: (dynamic) server /home/rt/3.8_rt/bin/mason_handler.fcgi restarted (pid 5902) Out of memory! [Tue Feb 24 10:31:38 2009] [error] [client 10.202.35.3] FastCGI: incomplete headers (0 bytes) received from server /home/rt/3.8_rt/bin/mason_handler.fcgi [Tue Feb 24 10:31:38 2009] [warn] FastCGI: (dynamic) server /home/rt/3.8_rt/bin/mason_handler.fcgi (pid 5902) terminated by calling exit with status '1' [Tue Feb
Re: [rt-users] RT 3.8 and FastCGI out of memory via http but not https *SOLVED*
Changing the a_sessions table from longtext to longblob fixed it. Thanks, Steven! Now that I know the answer I've found the other threads relating to this, but I was apparently using poor search terms before :) ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8 and FastCGI out of memory via http but not https *SOLVED*
Changing the a_sessions table from longtext to longblob fixed it. Shouldn't the upgrade scripts for rt-setup-database --action upgrade take care of this? Seems weird that it doesn't. -- -- Tom Lahti BIT Statement LLC (425)251-0833 x 117 http://www.bitstatement.net/ -- ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8 and FastCGI out of memory via http but not https *SOLVED*
On Tue, Feb 24, 2009 at 03:09:44PM -0800, Tom Lahti wrote: Changing the a_sessions table from longtext to longblob fixed it. Shouldn't the upgrade scripts for rt-setup-database --action upgrade take care of this? Seems weird that it doesn't. The schema changes necessary for this major upgrade were deemed too invasive (and slow) to automate. UPGRADING.somethingorother talks you through the update. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] REST interface attachment weirdness
In the REST interface, if you make a request like:
Request: /REST/1.0/ticket/ticket-id/attachments/attachment-id
You get a response like:
RT/3.8.2 200 Ok
id: 866
Subject:
Creator: 66
Created: 2008-08-05 00:27:27
Transaction: 2467
Parent: 864
MessageId:
Filename: word.doc
ContentType: application/msword
ContentEncoding: none
o
Headers: Content-Type: application/msword; name=word.doc
Content-Disposition: inline; filename=word.doc
Content-Transfer-Encoding: base64
Content-Length: 27648
Content: .
.
.
Now, the content-length says 27648, but the length of everything after
Content: is 38884. Noting that it has spaces in it after each newline, I
can search replace \n\s{9} with \n and get to 38470 -- I'm still way
above 27648. Now, supposedly this is base64 encoded, according to the
Content-Transfer-Encoding, but if I base64 decode this string of 38470 I get
a string that is 2314 bytes.
Worse, the actual file size is 31332, which is what I get when I download it
through the web interface interactively. This is greater than the
Content-Length header, and less than the content returned. This is
obviously a bit puzzling.
If I use the REST request
/REST/1.0/ticket/ticket-id/attachments/attachment-id/content
I get the correct content, plus 3 extra carriage returns. But I don't get
the filename, the size, or the content type. I could do both, but then I'm
downloading the content from the REST interface twice per attachment, which
is silly, especially if its necessary to scale.
Is there a way I can reconstruct the content correctly from the former REST
call, or get the filename/content type/encoding with the latter? I'd hate
to have to rely on patching the REST interface and then maintaining the
patch for when we upgrade.
--
--
Tom Lahti
BIT Statement LLC
(425)251-0833 x 117
http://www.bitstatement.net/
--
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] REST interface attachment weirdness
Tom Lahti wrote: In the REST interface, if you make a request like: I may have stumbled into a different problem here. I recently (well, 2 weeks ago) upgraded from 3.8.0 to 3.8.2 and now all non-text attachments do not open properly. I created a new test ticket with a new attachment, and it doesn't open properly either, so its not a corruption issue with the upgrade. I took a PDF that is 401,353 bytes and attached it to a ticket. Then I downloaded it to another folder, and the file size on the one I downloaded is 387,675. I don't even know where to begin diagnosing this, any thoughts on what to check? -- -- Tom Lahti BIT Statement LLC (425)251-0833 x 117 http://www.bitstatement.net/ -- ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] REST interface attachment weirdness
I may have stumbled into a different problem here. I recently (well, 2 weeks ago) upgraded from 3.8.0 to 3.8.2 and now all non-text attachments do not open properly. I created a new test ticket with a new attachment, and Nevermind, I seem to have fixed it, and am whacking myself with the Duh Bat[tm] now. Now the question is, did that fix my REST interface weirdness as well.. probably. It's late so I'll work on that tomorrow. -- -- Tom Lahti BIT Statement LLC (425)251-0833 x 117 http://www.bitstatement.net/ -- ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] force a dashboard report right now?
I'm trying to debug why dashboard mail isn't going out. I had some errors in rt.log related to graphviz until I found the undocumented disableGraphViz set command and used it. But now there is no error ... just nothing. No attempt to send mail. Funny enough -- if I delete a dashboard I do get e-mail saying that the dashboard is no longer there. But never the dashboard mail. Is there any way to get a dashboard e-mail done *NOW* instead of on a given hour? Every attempt forces me to back off and wait another hour to see what's going wrong. I'd love to say run my dashboard RIGHT NOW so I could use ktrace on it to determine what is failing. Please clue me in. -- Jo Rhett Net Consonance : consonant endings by net philanthropy, open source and other randomness ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] force a dashboard report right now?
On Tue, Feb 24, 2009 at 11:13:08PM -0800, Jo Rhett wrote: I'm trying to debug why dashboard mail isn't going out. I had some errors in rt.log related to graphviz until I found the undocumented disableGraphViz set command and used it. But now there is no error ... just nothing. No attempt to send mail. Funny enough -- if I delete a dashboard I do get e-mail saying that the dashboard is no longer there. But never the dashboard mail. Is there any way to get a dashboard e-mail done *NOW* instead of on a given hour? Every attempt forces me to back off and wait another hour to see what's going wrong. I'd love to say run my dashboard RIGHT NOW so I could use ktrace on it to determine what is failing. Please clue me in. rt-email-dashboards has an --all option to ignore subscription date/time constraints. Invoke it with --help to get more information. The --debug and --verbose options will be helpful for you. This isn't the first time I've heard of this failure mode so I'd be happy to work with you to track it down. I wasn't able to reproduce it myself. Shawn ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] force a dashboard report right now?
On Tue, Feb 24, 2009 at 11:13:08PM -0800, Jo Rhett wrote: I'm trying to debug why dashboard mail isn't going out. I had some errors in rt.log related to graphviz until I found the undocumented disableGraphViz set command and used it. But now there is no error ... just nothing. No attempt to send mail. Funny enough -- if I delete a dashboard I do get e-mail saying that the dashboard is no longer there. But never the dashboard mail. On Feb 24, 2009, at 11:33 PM, Shawn M Moore wrote: rt-email-dashboards has an --all option to ignore subscription date/ time constraints. Invoke it with --help to get more information. The -- debug and --verbose options will be helpful for you. This isn't the first time I've heard of this failure mode so I'd be happy to work with you to track it down. I wasn't able to reproduce it myself. doh! Sorry, I misread the --all syntax in help to mean something different. Anyway, I did figure it out: [Wed Feb 25 06:00:03 2009] [error]: Caught exception: mkdir /var/run/ rt38/mason_data/obj/3583890391: Permission denied at /usr/local/lib/ perl5/site_perl/5.8.8/HTML/Mason/Compiler/ToObject.pm line 107 (/usr/ local/sbin/rt-email-dashboards:119) The problem was that the user I was running the dashboard under has no ability to write to this directory. The directory is created as www:www 640. I know you guys just LOVE to run things as root, but I really prefer to run with the most limited rights. And I hate running these scripts as the web server too, but that's all that seems to work given the rights structure. When I have time I'll be proposing some alternatives to limit the necessary rights for RT ;-) -- Jo Rhett Net Consonance : consonant endings by net philanthropy, open source and other randomness ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
