[rt-users] 3.6.x end of support ?
Hi, I currently use 3.6.x Does anyone know how long it will be supported ? Regards, -- Oleg Sladkoff KELKOO - Service Architect oleg.sladk...@kelkoo.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] Reqest Tracker CentOS 5.3 setup
Hi , rt3 is available through EPEL repository with all dependencies... http://wiki.bestpractical.com/view/RHELorCentOSusingEPEL regards, Oleg. On Sun, 2009-04-26 at 21:49 +0100, Grant Deters wrote: OK, got that far, has a bit of trouble with XML::RSS, however, I was able to pull it from the web. jmose...@corp.xanadoo.com wrote: First and foremost, please email your requests for assistance to the mailing list. With that said, the main installation guide is Unix-generic, but if you know enough about your particular OS, you shouldn't have too many problems. Cent OS/RHEL (and other) guides do exist in the official RT setup wiki (http://wiki.bestpractical.com/view/InstallationGuides), but they quickly become a bit outdated because package names change, versions change, etc, and some refer to third-party yum repos to install RT-required software and even RT itself. The obvious questions are what have you installed thus far and where are you encountering problems? I would say RT installation falls into four basic steps: 1. Installing necessary software that RT requires (perl, perl modules, database software (both client and server), webserver, perl interpreter, etc) 2. Installing RT (this is the point where most perl modules will be installed) 3. Setting up RT database 4. Configuring RT (RT_SiteConfig.pm), webserver, and mail environment I'll go ahead and start with numbers one and two above using Mysql, Apache, and FastCGI. In this example, RT itself will be installed from source, supporting software will be installed via standard CentOS yum repositories, and most perl modules via CPAN. It's further assumed that Mysql will be running on the same server as RT (I prefer separate servers as perfomance will be better with a dedicated mysql server with fast disks and lots of memory, preferably a 64-bit system to better take advantage of memory). Perhaps you've already completed these steps: 1. Install the following via yum: httpd, perl, mysql, mysql-server, mod_fcgid, ncftp a) create entry in /etc/group for rt group: rt:x:501:apache b) disable Selinux in /etc/selinux/config: SELINUX=disabled c) then execute the following from a shell prompt: echo 0 /selinux/enforce This way you don't have to reboot the box... If for some reason this doesn't work, simply reboot... 2. Download RT source; unzip, untar it, rename to 'rt-3.8.2.src' a) CD into your source directory and then run the following command (you can choose to install RT in any directory you want, of course): ./configure --prefix=/opt/rt3.8.2 --with-web-user=apache --with-web-group=apache --with-mysql --with-web-handler=fastcgi b) make testdeps This will list all the perl modules you need to install c) make fixdeps This will automatically try to install all the required perl modules by invoking CPAN. If you haven't already invoked the CPAN shell environment, there will be a set of setup questions CPAN will ask you. There is a strong possibly that 'make fixdeps' won't get all required modules installed. In this case, you will have to run 'cpan' from a shell prompt and install one perl module at a time. Be advised that many of the required perl modules have dependencies, so the CPAN installer will attempt to install those as well. As a last resort if run into problems with CPAN, you can install quite a few of the required perl modules from yum. Look at the wiki refereneced above for RHEL/Cent OS examples of what perl modules are generally available via yum. Keep performing 'make testdeps' to ensure all perl modules have been installed. When they have been: d) make install e) ln -s /opt/rt3.8.2 /opt/rt3 I do the following to keep upgrades sane. For example, when I upgrade to say, RT 3.8.3, it will be installed in /opt/rt3.8.3 and I will then delete the existing /opt/rt3 soft link and repoint it at the new installation. This way, I can install a new version of RT without upgrading/blowing away the live version, which also means I can fall back to the previous version if the new version doesn't work for some reason. Hope this helps! If you get passed this, then I will continue with the other steps. I'll then add to the RT wiki... James Moseley Grant Deters gdet...@usd250.org wrote: Hello, I was wondering if you had any good guides to installing RT on CentOS 5.3. I have been unsuccessful in my first attempt as the guides for it on their website where hard for me to follow as they don't provide one specifically for this OS. Any help would be greatly appreciated. Thanks -- Grant S. Deters USD 250 School District Assistant Network/Systems Administrator Ph. (620) 235.3246 -- Oleg Sladkoff KELKOO - Service Architect oleg.sladk...@kelkoo.com Yahoo messenger : Kelkoooleg tel
Re: [rt-users] rt3 performance problem when updating a ticket
Hello slight problem, RT doesn't send any mail since I updated the configuration (nothing in rt's logs ) any help appreciated ! Oleg. On Thu, 2009-04-23 at 09:49 +0100, Oleg Sladkoff wrote: Hi Ruslan thanks for your feedback :) after making a few tests it appears that the gap appears whenever someone is in CC on the ticket (This message will be sent to...) On mysql side I do not see any slow query (time 1) and I see no process (show process list). after following sendmailtips my problem was fixed :) in RT_SiteConfig.pm : Set($SendmailArguments, -ODeliveryMode=q ); thanks for your help ! best regards, Oleg. On Wed, 2009-04-22 at 22:32 +0100, Ruslan Zakirov wrote: Check out RT logs and look at timings. It may help you spot big gaps and localize problem. It can be sendmail or whatever you use as MTA: http://wiki.bestpractical.com/view/SendmailTips What have you done to make sure it's not mysql? On Wed, Apr 22, 2009 at 7:40 PM, Oleg Sladkoff sladk...@yahoo-inc.com wrote: Hi Since a few weeks it takes about 10 seconds whenever I update any ticket . Looking at mysql I don't see any activity. Any idea where the problem could come from ? -- Oleg Sladkoff KELKOO - Service Architect oleg.sladk...@kelkoo.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 -- Oleg Sladkoff KELKOO - Service Architect oleg.sladk...@kelkoo.com Yahoo messenger : Kelkoooleg tel : +33 (0)476848147 gsm : +33(0)675768532 -- Oleg Sladkoff KELKOO - Service Architect oleg.sladk...@kelkoo.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] rt3 performance problem when updating a ticket
Hi all Thanks for all feedbacks! Indeed I have a network problem on my server since yesterday, so the problem does not come from RT... the mailq command shows many (Deferred: Connection timed out with my.mail.server.) Oleg. On Fri, 2009-04-24 at 17:40 +0100, Ruslan Zakirov wrote: I want to note that Set($SendmailArguments, -ODeliveryMode=q ); is incorrect. Default value in the RT config is not empty. So new value should be: Set($SendmailArguments, -ODeliveryMode=q -oi -t ); On Fri, Apr 24, 2009 at 6:56 PM, Raed El-Hames r...@vialtus.com wrote: Oleg; You need to bare in mind that Set($SendmailArguments, -ODeliveryMode=q ); puts the message in a mail queue, you need to check the frequency of how often your mta process its queue btw, you are using sendmail ?? because the above line wont work if you are using exim, you need : Set($SendmailArguments, -odq ); yes I'm using sendmail Regards; *Roy El-hames * ISP Systems *Vialtus Solutions* *(formerly Pipex Business)* Direct Dial: +44(0) 208 587 6181 E-mail: r...@vialtus.com mailto:r...@vialtus.com Visit us on: www.vialtus.com http://www.vialtus.com/ This email is subject to: http://www.vialtus.com/disclaimer.html Oleg Sladkoff wrote: Hello slight problem, RT doesn't send any mail since I updated the configuration (nothing in rt's logs ) any help appreciated ! Oleg. On Thu, 2009-04-23 at 09:49 +0100, Oleg Sladkoff wrote: Hi Ruslan thanks for your feedback :) after making a few tests it appears that the gap appears whenever someone is in CC on the ticket (*/This message will be sent to.../*) On mysql side I do not see any slow query (time 1) and I see no process (show process list). after following sendmailtips my problem was fixed :) in RT_SiteConfig.pm : Set($SendmailArguments, -ODeliveryMode=q ); thanks for your help ! best regards, Oleg. On Wed, 2009-04-22 at 22:32 +0100, Ruslan Zakirov wrote: Check out RT logs and look at timings. It may help you spot big gaps and localize problem. It can be sendmail or whatever you use as MTA: http://wiki.bestpractical.com/view/SendmailTips What have you done to make sure it's not mysql? On Wed, Apr 22, 2009 at 7:40 PM, Oleg Sladkoff sladk...@yahoo-inc.com mailto:sladk...@yahoo-inc.com wrote: Hi Since a few weeks it takes about 10 seconds whenever I update any ticket . Looking at mysql I don't see any activity. Any idea where the problem could come from ? -- Oleg Sladkoff KELKOO - Service Architect oleg.sladk...@kelkoo.com mailto:oleg.sladk...@kelkoo.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 mailto:sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com -- Oleg Sladkoff KELKOO - Service Architect oleg.sladk...@kelkoo.com mailto:oleg.sladk...@kelkoo.com Yahoo messenger : Kelkoooleg tel : +33 (0)476848147 gsm : +33(0)675768532 -- Oleg Sladkoff KELKOO - Service Architect oleg.sladk...@kelkoo.com mailto:oleg.sladk...@kelkoo.com Yahoo messenger : Kelkoooleg tel : +33 (0)476848147 gsm : +33(0)675768532 -- Best regards, Ruslan. ___ 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 -- Oleg Sladkoff KELKOO - Service Architect oleg.sladk...@kelkoo.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] rt3 performance problem when updating a ticket
Hi Ruslan thanks for your feedback :) after making a few tests it appears that the gap appears whenever someone is in CC on the ticket (This message will be sent to...) On mysql side I do not see any slow query (time 1) and I see no process (show process list). after following sendmailtips my problem was fixed :) in RT_SiteConfig.pm : Set($SendmailArguments, -ODeliveryMode=q ); thanks for your help ! best regards, Oleg. On Wed, 2009-04-22 at 22:32 +0100, Ruslan Zakirov wrote: Check out RT logs and look at timings. It may help you spot big gaps and localize problem. It can be sendmail or whatever you use as MTA: http://wiki.bestpractical.com/view/SendmailTips What have you done to make sure it's not mysql? On Wed, Apr 22, 2009 at 7:40 PM, Oleg Sladkoff sladk...@yahoo-inc.com wrote: Hi Since a few weeks it takes about 10 seconds whenever I update any ticket . Looking at mysql I don't see any activity. Any idea where the problem could come from ? -- Oleg Sladkoff KELKOO - Service Architect oleg.sladk...@kelkoo.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 -- Oleg Sladkoff KELKOO - Service Architect oleg.sladk...@kelkoo.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] rt3 performance problem when updating a ticket
Hi Since a few weeks it takes about 10 seconds whenever I update any ticket . Looking at mysql I don't see any activity. Any idea where the problem could come from ? -- Oleg Sladkoff KELKOO - Service Architect oleg.sladk...@kelkoo.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] Reply to requestors when resolving a ticket
Hi I would like to know how I can have by default Reply to requestors when I Resolve a ticket (the actual default is Comments (not sent to requestors). thanks in advance :) -- Oleg Sladkoff KELKOO - Service Architect oleg.sladk...@kelkoo.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] Reply to requestors when resolving a ticket
fantastic, that worked !
thanks :)
On Fri, 2009-04-17 at 13:11 +0100, Raed El-Hames wrote:
Oleg;
Modify
/opt/rt3/local/html/Ticket/Elements/Tabs
Change:
if ( $Ticket-Status ne 'resolved' ) {
$actions-{'G'} = {
path =
Ticket/Update.html?Action=CommentDefaultStatus=resolvedid= . $id,
title = loc('Resolve') };
}
to:
if ( $Ticket-Status ne 'resolved' ) {
$actions-{'G'} = {
path =
Ticket/Update.html?Action=RespondDefaultStatus=resolvedid= . $id,
title = loc('Resolve') };
}
##Note changing the Action from Comment to Respond
Regards;
Roy
Oleg Sladkoff wrote:
Hi
I would like to know how I can have by default Reply to requestors
when I Resolve a ticket (the actual default is Comments (not sent to
requestors).
thanks in advance :)
--
Oleg Sladkoff
KELKOO - Service Architect
oleg.sladk...@kelkoo.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
___
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
--
Oleg Sladkoff
KELKOO - Service Architect
oleg.sladk...@kelkoo.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] recommended max_allowed_packet value (for attachments)
Hello I am using Mysql 4.1 / RT 3.6.5. on mysql , max_allowed_packet is set to 1048576 , which causes attachements greater than 1M to fail (see in apache log): Attachment insert failed - Got a packet bigger than 'max_allowed_packet' bytes (/usr/lib/perl5/vendor_perl/5.8.8/RT/Attachment_Overlay.pm:195) I would like to know if there are any max_allowed_packet value recommendation , because I would not like to have my database size grow , and because I might then have performance problems... so what value are you using / recommending for max_allowed_packet ? -- 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] problem with RTAddressRegexp - BUG
Thank you so much Jo , that did the trick ;) here is the modified regexp : Set($RTAddressRegexp , '^(?:.*sladko...@yahoo-inc\.com)$'); Best regards, Oleg. On Wed, 2009-03-04 at 03:12 +, Jo Rhett wrote: On Mar 2, 2009, at 8:02 AM, Oleg Sladkoff wrote: RTAddressRegexp doesn't work as expected on my RT 3.6.5 system. I have setup the following in /etc/rt3/RT_SiteConfig.pm : Set($RTAddressRegexp , '^(.*sladko...@yahoo-inc\.com)$'); However I am still able to create tickets with that mail address. I there anything I missed ? Make it a non-referrable entry with ?: It didn't work for me until I did that. Honestly that should be fixed in the code. It won't work any other way. ;-) -- 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] problem with RTAddressRegexp
Hi, RTAddressRegexp doesn't work as expected on my RT 3.6.5 system. I have setup the following in /etc/rt3/RT_SiteConfig.pm : Set($RTAddressRegexp , '^(.*sladko...@yahoo-inc\.com)$'); However I am still able to create tickets with that mail address. I there anything I missed ? regards, -- 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] 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] 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
Re: [rt-users] Resolving a ticket takes ages
Hi I suggest you look at the slow queries on your database. ( or show processlist when resolving a ticket) Oleg. On Sat, 2009-02-07 at 22:19 +, Lauren, Robin wrote: Hi, We’re administering an RT 3.6.5 with MySQL ver 14.12 Distrib 5.0.51a for a customer. While other uses of the system is relatively quick and painless, getting the screen to “resolve” the ticket after clicking the resolve link can take minutes. Actually resolving the ticket again is a snap. Is the database stuck? Number of pipelines from RT to MySQL inadequate (or is there even such a thing?)? What would be appropriate debugging procedures to take? Best regards, ~Robin Laurén / eCraft -- 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] RTFM 2.4.1 on RT 3.8.2
Hi, I have added this in my RT_SiteConfig.pm : Set(@Plugins,qw(RT::FM)); regards On Tue, 2009-02-03 at 16:10 +, Josh Fiske wrote: I am attempting to install RTFM 2.4.1 on my existing (fully functional) RT 3.8.2 installation. This is on a CentOS 5 host with RT installed in the standard location (/opt/rt3). So, I do the following (all of which complete without any error messages): cd /usr/local/src wget http://download.bestpractical.com/pub/rt/release/RTFM-2.4.1.tar.gz tar zxf RTFM-2.4.1.tar.gz cd RTFM-2.4.1 perl Makefile.PL make make install make initdb /etc/init.d/httpd restart I login to RT as a SuperUser and I don’t see any reference to RTFM. I know that with other RT plugins (RT-Authen-ExternalAuth), I have needed to include a line in my RT_SiteConfig.pm. But when I tried adding this [ Set( @Plugins, (qw(RT::Authen::ExternalAuth),RT-FM)); ] and restarting, it had no impact. Any suggestions? Am I missing a simple step? Thanks, Josh - - - - Joshua Fiske '03, '04 Network and Security Engineer Clarkson University, Office of Information Technology (315) 268-6722 -- Fax: (315) 268-6570 I route, therefore you are. green Think before you print. CONFIDENTIALITY: This e-mail (including any attachments) may contain confidential, proprietary and privileged information, and unauthorized disclosure or use is prohibited. If you received this e-mail in error, please notify the sender and delete this e-mail from your system. -- 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
