RTIR Graphs not showing

Jorge_Ruao · January 9, 2013, 3:27pm

Hi everyone,

Since we were having problems upgrading to RTIR 2.6.1 in our RT 3.8.4 installation we’ve prepared a new virtual machine with RT 3.8.15, RTFM 2.4.5 and RTIR 2.6.1.

All configurations were replicated on the new machine and the database as been dumped from the old RT 3.8.4 installation and inserted in the new RT 3.8.15.

Everything seems working, all RTIR queues are being shown, tickets available and incident reports are being created by mailgate. Nevertheless we don’t see the Charts button anymore in RTIR search result queues. Instead, right after the “Spreadsheet | RSS | Shredder” it shows the following text:
chart grouped by Status Queue Owner Name Owner EmailAddress Owner RealName Owner NickName Owner Organization Owner Lang Owner City Owner Country Owner Timezone Creator Name Creator EmailAddress Creator RealName Creator NickName Creator Organization Creator Lang Creator City Creator Country Creator Timezone LastUpdatedBy Name LastUpdatedBy EmailAddress LastUpdatedBy RealName LastUpdatedBy NickName LastUpdatedBy Organization LastUpdatedBy Lang LastUpdatedBy City LastUpdatedBy Country LastUpdatedBy Timezone Requestor Name Requestor EmailAddress Requestor RealName Requestor NickName Requestor Organization Requestor Lang Requestor City Requestor Country Requestor Timezone Cc Name Cc EmailAddress Cc RealName Cc NickName Cc Organization Cc Lang Cc City Cc Country Cc Timezone AdminCc Name AdminCc EmailAddress AdminCc RealName AdminCc NickName AdminCc Organization AdminCc Lang AdminCc City AdminCc Country AdminCc Timezone Watcher Name Watcher EmailAddress Watcher RealName Watcher NickName Watcher Organization Watcher Lang Watcher City Watcher Country Watcher Timezone DueHourly DueDaily DueMonthly DueAnnually ResolvedHourly ResolvedDaily ResolvedMonthly ResolvedAnnually CreatedHourly CreatedDaily CreatedMonthly CreatedAnnually LastUpdatedHourly LastUpdatedDaily LastUpdatedMonthly LastUpdatedAnnually StartedHourly StartedDaily StartedMonthly StartedAnnually StartsHourly StartsDaily StartsMonthly StartsAnnually style: bar pie

It seems there is some bugged code.

Any tips where to look at?

Thanks in advance.

Regards,
Jorge Ruão

Computer Security Incident Response Team (CSIRT.FEUP)
Prof. Correia de Araújo Computer Center
University of Oporto - Faculty of Engineering

Tony_Arnold · January 9, 2013, 3:52pm

Jorge,

I had the same problem. The attached patch fixed it.

Regards,
Tony.On 09/01/13 15:27, Jorge Ruao wrote:

Hi everyone,

Since we were having problems upgrading to RTIR 2.6.1 in our RT 3.8.4
installation we’ve prepared a new virtual machine with RT 3.8.15,
RTFM 2.4.5 and RTIR 2.6.1.

All configurations were replicated on the new machine and the
database as been dumped from the old RT 3.8.4 installation and
inserted in the new RT 3.8.15.

Everything seems working, all RTIR queues are being shown, tickets
available and incident reports are being created by mailgate.
Nevertheless we don’t see the Charts button anymore in RTIR search
result queues. Instead, right after the “Spreadsheet | RSS |
Shredder” it shows the following text: ------------ chart grouped by
Status Queue Owner
Name Owner
EmailAddress Owner
RealName Owner
NickName Owner
Organization Owner Lang
Owner City Owner Country Owner Timezone Creator Name Creator EmailAddress Creator RealName Creator NickName Creator Organization Creator Lang Creator City Creator Country Creator Timezone LastUpdatedBy Name LastUpdatedBy EmailAddress LastUpdatedBy RealName LastUpdatedBy NickName LastUpdatedBy Organization LastUpdatedBy Lang LastUpdatedBy City LastUpdatedBy Country LastUpdatedBy Timezone Requestor Name Requestor EmailAddress Requestor RealName Requestor NickName Requestor Organization Requestor Lang Requestor City Requestor Country Requestor Timezone Cc Name Cc EmailAddress Cc RealName Cc NickName Cc Organization Cc Lang Cc City Cc Country Cc Timezone AdminCc Name AdminCc EmailAddress AdminCc RealName AdminCc NickName AdminCc Organization AdminCc Lang AdminCc City AdminCc Country AdminCc Timezone Watcher Name Watcher EmailAddress Watcher RealName Watcher NickName Watcher Organization Watcher Lang Watcher City Watcher Country Watcher Timezone DueHourly DueDaily DueMonthly DueAnnually ResolvedHourly ResolvedDaily ResolvedMonthly ResolvedAnnually CreatedHourly CreatedDaily CreatedMonthly CreatedAnnually LastUpdatedHourly LastUpdatedDaily LastUpdatedMonthly LastUpdatedAnnually StartedHourly StartedDaily StartedMonthly StartedAnnually StartsHourly StartsDaily StartsMonthly StartsAnnually style: bar pie ------------
It seems there is some bugged code.

Any tips where to look at?

Thanks in advance.

Regards, Jorge Ruï¿½o

Computer Security Incident Response Team (CSIRT.FEUP) Prof. Correia
de Araï¿½jo Computer Center University of Oporto - Faculty of
Engineering _______________________________________________ Rtir
mailing list Rtir@lists.bestpractical.com
The rtir Archives

Tony Arnold, Tel: +44 (0) 161 275 6093
Head of IT Security, Fax: +44 (0) 705 344 3082
University of Manchester, Mob: +44 (0) 773 330 0039
Manchester M13 9PL. Email: tony.arnold@manchester.ac.uk

0001-Begin-using-l_unsafe-in-a-few-places-that-pass-HTML-.patch (4.73 KB)

Jorge_Ruao · January 9, 2013, 4:01pm

Hi Tony,

thanks for the quick reply.

Apologies for my ignorance, but how do I apply that patch?

Regards,
Jorge RuãoOn 09/01/2013, at 15:52, Tony Arnold wrote:

Jorge,

I had the same problem. The attached patch fixed it.

Regards,
Tony.

On 09/01/13 15:27, Jorge Ruao wrote:

Hi everyone,

Since we were having problems upgrading to RTIR 2.6.1 in our RT 3.8.4
installation we’ve prepared a new virtual machine with RT 3.8.15,
RTFM 2.4.5 and RTIR 2.6.1.

All configurations were replicated on the new machine and the
database as been dumped from the old RT 3.8.4 installation and
inserted in the new RT 3.8.15.

Everything seems working, all RTIR queues are being shown, tickets
available and incident reports are being created by mailgate.
Nevertheless we don’t see the Charts button anymore in RTIR search
result queues. Instead, right after the “Spreadsheet | RSS |
Shredder” it shows the following text: ------------ chart grouped by
Status Queue Owner
Name Owner
EmailAddress Owner
RealName Owner
NickName Owner
Organization Owner Lang
Owner City Owner Country Owner Timezone Creator Name Creator EmailAddress Creator RealName Creator NickName Creator Organization Creator Lang Creator City Creator Country Creator Timezone LastUpdatedBy Name LastUpdatedBy EmailAddress LastUpdatedBy RealName LastUpdatedBy NickName LastUpdatedBy Organization LastUpdatedBy Lang LastUpdatedBy City LastUpdatedBy Country LastUpdatedBy Timezone Requestor Name Requestor EmailAddress Requestor RealName Requestor NickName Requestor Organization Requestor Lang Requestor City Requestor Country Requestor Timezone Cc Name Cc EmailAddress Cc RealName Cc NickName Cc Organization Cc Lang Cc City Cc Country Cc Timezone AdminCc Name AdminCc EmailAddress AdminCc RealName AdminCc NickName AdminCc Organization AdminCc Lang AdminCc City AdminCc Country AdminCc Timezone Watcher Name Watcher EmailAddress Watcher RealName Watcher NickName Watcher Organization Watcher Lang Watcher City Watcher Country Watcher Timezone DueHourly DueDaily DueMonthly DueAnnually ResolvedHourly ResolvedDaily ResolvedMonthly ResolvedAnnually CreatedHourly CreatedDaily CreatedMonthly CreatedAnnually LastUpdatedHourly LastUpdatedDaily LastUpdatedMonthly LastUpdatedAnnually StartedHourly StartedDaily StartedMonthly StartedAnnually StartsHourly StartsDaily StartsMonthly StartsAnnually style: bar pie ------------
It seems there is some bugged code.

Any tips where to look at?

Thanks in advance.

Regards, Jorge Ruão

Computer Security Incident Response Team (CSIRT.FEUP) Prof. Correia
de Araújo Computer Center University of Oporto - Faculty of
Engineering _______________________________________________ Rtir
mailing list Rtir@lists.bestpractical.com
The rtir Archives

–
Tony Arnold, Tel: +44 (0) 161 275 6093
Head of IT Security, Fax: +44 (0) 705 344 3082
University of Manchester, Mob: +44 (0) 773 330 0039
Manchester M13 9PL. Email: tony.arnold@manchester.ac.uk
<0001-Begin-using-l_unsafe-in-a-few-places-that-pass-HTML-.patch>_______________________________________________
Rtir mailing list
Rtir@lists.bestpractical.com
The rtir Archives

James_Mcloughlin · January 9, 2013, 4:07pm

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello Jorge,On 09/01/13 16:01, Jorge Ruao wrote:

Hi Tony,

thanks for the quick reply.

Apologies for my ignorance, but how do I apply that patch?

cd /opt/rt3/local/plugins/RT-IR
patch -p1
</path/to/0001-Begin-using-l_unsafe-in-a-few-places-that-pass-HTML-.patch

Regards

Jamie Mcloughlin +44 1235 822 383 PGP: FF7746C1
JANET CSIRT 0870 850 2340 (+44 1235 822 340)
Lumen House, Library Avenue, Didcot, Oxfordshire, OX11 0SG
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.14 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAlDtldEACgkQk+nTdv93RsF9mgCgnsfP4ITJZ2dffVnzeboQfGWI
DmQAn3biWG5KoaqeDYKDXUAjHBYCvSUe
=OT/I
-----END PGP SIGNATURE-----