[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
e 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 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 : +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 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 >>>> <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
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 > > 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 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 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
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=Comment&DefaultStatus=resolved&id=" . $id,
> title => loc('Resolve') };
> }
>
>
> to:
>
> if ( $Ticket->Status ne 'resolved' ) {
> $actions->{'G'} = {
>
> path =>
> "Ticket/Update.html?Action=Respond&DefaultStatus=resolved&id=" . $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] 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
[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
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 "RT statistics" > $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 "Tickets activity for queues
$QUEUE">>$HTMLPATH/index.html
echo "">> $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("%16s%16s%16s%16s
\n","WeekEndingDay","NewTickets","OpenTickets","ResolvedTickets") }
{ printf("%16s%16s%16s%16s\n",$1,$2,$3,$4) }
END { print "" } '
$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] 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] 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
