Rtir

RTIR
1

Hello,

I was wondering if anyone can tell me what RTIR adds to RT over the base
install. We have a customized verions of RT3 that we are using as an IR
database and were about to go production with it. I was wondering if I
should rethink that. What extra features would we be getting by install RTIR

Also does anyone have an example of RTIR running some place.

Thanks
Jason Alexander
University of Iowa Security

2

Jason Alexander wrote:

Hello,

I was wondering if anyone can tell me what RTIR adds to RT over the base
install. We have a customized verions of RT3 that we are using as an IR
database and were about to go production with it. I was wondering if I
should rethink that. What extra features would we be getting by install RTIR.

The development of RTIR was done to add some features to RT which
JANET-CERT needed before we felt we could use it for Incident Response
work (JANET is the Education and Research network in the UK).

Some of the features may need tuning to match your needs.

  • We have 4 queues, Incident, Incident Reports, Investigations and Blocks.

All new work enters the Incident Report queue.
Investigations are a queue for conversations initiated by the team.
Blocks are used to track the block we place on the borders of the network.
Investigations don’t hold any correspondence, they just act as a
container object to hold the other three ticket types.

Lots of interface work has been done to make these dependencies easier
to manage.

  • MakeClicky

A really nice feature where all mail becomes clickable (its matches
various regexps, such as IPs). Clicking on an IP gives you a whois
result (possibly from your own local datasource/contact info),
traceroute, and a list of the other tickets containing this IP.

  • Reporting

We have to do reporting to our funding body on a number of things, so
each Incident has a number of classification, which can be reported on.
This includes SLA stuff, like answering reports within 1 hour.

  • Scripted action

Web interface to do the same thing for N IP’s. eg list of 100 CodeRed
infected machines - it looks up the contact, send them an email as an
Investigation, and links it to a newly created Incident.

  • Due dates
    Ownership is carried out on Incidents, each member of the team owns the
    Incident, and deals with all the work held within it. Each child has a
    due date, which is shown on the main screen by the parent incident
    (sorted by due date). New mail entering a child ticket sets due date to
    now, so it can be dealt with.

I’m probably not describing it very well. Its easy enough to install,
and should cooexist with any current RT installation (as long as the
queue names are unique).

There are some screenshots, from our (me and Jesse) presentation at
FIRST available from my website.

http://kaizo.org/girona/ (*.png)

I hope this makes sense.

Any questions please ask.

John
JANET-CERT

3

Well, I installed the latest version into my existing RT installation. It
appears all I got was 4 new queues with no added functionality. Is there
somewhere I can look to see how it is supposed to be functioning? Some more
documentation somewhere?

Roger Spencer

RSpencer@evare.com

smime.p7s (3.67 KB)

4

Well, I installed the latest version into my existing RT installation. It
appears all I got was 4 new queues with no added functionality. Is there
somewhere I can look to see how it is supposed to be functioning? Some more
documentation somewhere?

Provided you followed the installation instructions closely and added
proper people to the ‘DutyTeam’ group, start from:
http://your.site.goes.here/RTIR/index.html
Enjoy!

Best regards,
Przemek
“Delenda est Carthago” /Cato Maior/ .d~^v
Przemyslaw Jaroszewski 8 E R T
CERT Polska, http://www.cert.pl/ `b.a’POLSKA|
przemek@cert.pl; tel.+48 22 5231377; fax.: +48 22 5231399

5

That’s better. I did try adding /rtir/ to RT’s url but as it turns out, it
is case sensitive. Is there supposed to be a link from the main RT page?

Also, is there any documentation for using this? I’m playing around with
it, seems pretty useful, just can’t get a handle on the logic flow yet. I
think I’ve read everything on www.bestpractical.com site I could find.

Roger Spencer
RSpencer@evare.comFrom: Przemek Jaroszewski [mailto:przemek@cert.pl]
Sent: Wednesday, February 25, 2004 8:42 AM
To: Spencer, Roger
Cc: rtir@lists.bestpractical.com
Subject: Re: [Rtir] RTIR

Well, I installed the latest version into my existing RT installation. It
appears all I got was 4 new queues with no added functionality. Is there
somewhere I can look to see how it is supposed to be functioning? Some
more
documentation somewhere?

Provided you followed the installation instructions closely and added
proper people to the ‘DutyTeam’ group, start from:
http://your.site.goes.here/RTIR/index.html
Enjoy!

Best regards,
Przemek
“Delenda est Carthago” /Cato Maior/ .d~^v
Przemyslaw Jaroszewski 8 E R T
CERT Polska, http://www.cert.pl/ `b.a’POLSKA|
przemek@cert.pl; tel.+48 22 5231377; fax.: +48 22 5231399

smime.p7s (3.67 KB)

6

Spencer, Roger wrote:

That’s better. I did try adding /rtir/ to RT’s url but as it turns out, it
is case sensitive. Is there supposed to be a link from the main RT page?

There is, although the permissions are sometimes a little “suboptimal”
in the CallBacks directory. Check they are readable by apache.

Also, is there any documentation for using this? I’m playing around with
it, seems pretty useful, just can’t get a handle on the logic flow yet. I
think I’ve read everything on www.bestpractical.com site I could find.

Jesse?

Cheers
John

7

I changed the permissions on the RTIS directory
share/html/Callbacks/RTIM to match those of RTFM and the link in RT
showed up.

Thanks for the help.

Roger Spencer
RSpencer@evare.comFrom: John Green [mailto:j.green@ukerna.ac.uk]
Sent: Wednesday, February 25, 2004 11:38 AM
To: Spencer, Roger
Cc: rtir@lists.bestpractical.com
Subject: Re: [Rtir] RTIR

Spencer, Roger wrote:

That’s better. I did try adding /rtir/ to RT’s url but as it turns
out, it
is case sensitive. Is there supposed to be a link from the main RT
page?

There is, although the permissions are sometimes a little “suboptimal”
in the CallBacks directory. Check they are readable by apache.

Also, is there any documentation for using this? I’m playing around
with
it, seems pretty useful, just can’t get a handle on the logic flow
yet. I
think I’ve read everything on www.bestpractical.com site I could find.

Jesse?

Cheers
John

8

Spencer, Roger wrote:

Also, is there any documentation for using this? I’m playing around
with
it, seems pretty useful, just can’t get a handle on the logic flow
yet. I
think I’ve read everything on www.bestpractical.com site I could find.

Jesse?

http://bestpractical.com/rtir/usingrtir.pdf is the draft manual we put
together. I’m almost tempted to migrate it to the wiki
(wiki.bestpractical.com) so that interested users could contribute to
it. If we did that, would folks be up for keeping it up to date?

Jesse

PGP.sig (186 Bytes)

9

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

Hi all,

I want to install RTIR but the releases are too old. Which version do
you suggest for rt and rtir to install? Should I install rt 3.6 and rtir
1.1.5 or newer but experimental versions? I tried rt 3.6 and rtir 1.1.5
facing with some problems on installation (rt is still running as a
trouble ticket system).

Thanks,

  • -ge
    -----BEGIN PGP SIGNATURE-----
    Version: GnuPG v1.4.6 (GNU/Linux)
    Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGL0l9/pk5/FzrR5YRAsVxAJ9w3AAt2Sh9ZawB3bkjMFZexdLgvQCeKOPn
rAWKytVgPSN4hord8HUIfRI=
=h597
-----END PGP SIGNATURE-----

10

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

Hi all,

I want to install RTIR but the releases are too old. Which version do
you suggest for rt and rtir to install? Should I install rt 3.6 and
rtir
1.1.5 or newer but experimental versions? I tried rt 3.6 and rtir
1.1.5
facing with some problems on installation (rt is still running as a
trouble ticket system).

We’re hard at work on the next stable release of RTIR as a project
for a consortium of European CSIRT teams.
Our last milestone build is composed of:

http://download.bestpractical.com/pub/rt/devel/RTFM-2.2.0RC5.tar.gz
http://download.bestpractical.com/pub/rt/devel/RT-3.7.5.tar.gz
http://download.bestpractical.com/pub/rt/devel/RT-IR-2.1.5.tar.gz

It should be much, much more stable and robust than the 1.1.x beta
versions.

Best,
Jesse

PGP.sig (186 Bytes)

11

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

ok, I will install them. Thanks a lot :slight_smile: .

Regards,

Gokhan ERYOL
ULAK-CSIRT
http://csirt.ulakbim.gov.tr

Jesse Vincent wrote:

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

Hi all,

I want to install RTIR but the releases are too old. Which version do
you suggest for rt and rtir to install? Should I install rt 3.6 and rtir
1.1.5 or newer but experimental versions? I tried rt 3.6 and rtir 1.1.5
facing with some problems on installation (rt is still running as a
trouble ticket system).

We’re hard at work on the next stable release of RTIR as a project for a
consortium of European CSIRT teams.
Our last milestone build is composed of:

http://download.bestpractical.com/pub/rt/devel/RTFM-2.2.0RC5.tar.gz
http://download.bestpractical.com/pub/rt/devel/RT-3.7.5.tar.gz
http://download.bestpractical.com/pub/rt/devel/RT-IR-2.1.5.tar.gz

It should be much, much more stable and robust than the 1.1.x beta
versions.

Best,
Jesse

Thanks,

  • -ge

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGL1/3/pk5/FzrR5YRAs3hAKCE+kvfiOpiPGCNOGTjJy3MBia8ngCfeswi
XVTHXlg58Wv8Uwr43FC4JjU=
=Zr7q
-----END PGP SIGNATURE-----

12

Hi,

I tried to install this version, but II received this error at
/RTIR/Tools/Lookup.html?ticket=1&type=host&q=teste.com :

error: Unsatisfied dependency chain in joins Attachments_2 Transactions_1 at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 1045.
context:
…
1041:
1042: # here we could check if there is recursion in joins by checking that
all joins
1043: # are processed
1044: if ( my @not_processed = grep !$processed{ $_ }, keys %$joins ) {
1045: die “Unsatisfied dependency chain in joins @not_processed”;
1046: }
1047: return $join_clause;
1048: }
1049:

How I solve this error?

regards,
Fernando.

Citando Gokhan ERYOL eryol@ulakbim.gov.tr:

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

ok, I will install them. Thanks a lot :slight_smile: .

Regards,

Gokhan ERYOL
ULAK-CSIRT
http://csirt.ulakbim.gov.tr

Jesse Vincent wrote:

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

Hi all,

I want to install RTIR but the releases are too old. Which version do
you suggest for rt and rtir to install? Should I install rt 3.6 and rtir
1.1.5 or newer but experimental versions? I tried rt 3.6 and rtir 1.1.5
facing with some problems on installation (rt is still running as a
trouble ticket system).

We’re hard at work on the next stable release of RTIR as a project for a
consortium of European CSIRT teams.
Our last milestone build is composed of:

http://download.bestpractical.com/pub/rt/devel/RTFM-2.2.0RC5.tar.gz
http://download.bestpractical.com/pub/rt/devel/RT-3.7.5.tar.gz
http://download.bestpractical.com/pub/rt/devel/RT-IR-2.1.5.tar.gz

It should be much, much more stable and robust than the 1.1.x beta
versions.

Best,
Jesse

Thanks,

Fernando Fugita
Centro de Computacao Eletronica

13

Hi,

I tried to install this version, but II received this error at
/RTIR/Tools/Lookup.html?ticket=1&type=host&q=teste.com :

Are you current on DBIx::SearchBuilder? Can you give us the full
stack trace? Which Database/

PGP.sig (186 Bytes)

14

Vicent,

I running last version of SearchBuilder (1.48), and MySQL 5.0.18 in my test
environment.

code stack:
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:1045
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm:353
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm:430
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm:233
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm:498
/usr/local/rt3/lib/RT/Tickets_Overlay.pm:2593
/usr/local/rt3/share/html/RTIR/Elements/IncidentSummary:77
/usr/local/rt3/share/html/RTIR/Tools/Lookup.html:44
/usr/local/rt3/share/html/Widgets/TitleBox:49
/usr/local/rt3/share/html/RTIR/Tools/Lookup.html:50
/usr/local/rt3/share/html/autohandler:290
raw error

Unsatisfied dependency chain in joins Attachments_2 Transactions_1 at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 1045.

Trace begun at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Exceptions.pm
line 129
HTML::Mason::Exceptions::rethrow_exception(‘Unsatisfied dependency chain in
joins Attachments_2 Transactions_1 at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line
1045.^J’) called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 1045
DBIx::SearchBuilder::Handle::_BuildJoins(‘RT::Handle=HASH(0x1110f218)’,
‘RT::Tickets=HASH(0x11eab464)’) called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line 353
DBIx::SearchBuilder::_BuildJoins(‘RT::Tickets=HASH(0x11eab464)’) called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line 430
DBIx::SearchBuilder::BuildSelectQuery(‘RT::Tickets=HASH(0x11eab464)’) called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line 233
DBIx::SearchBuilder::_DoSearch(‘RT::Tickets=HASH(0x11eab464)’) called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line 498
DBIx::SearchBuilder::Next(‘RT::Tickets=HASH(0x11eab464)’) called at
/usr/local/rt3/lib/RT/Tickets_Overlay.pm line 2593
RT::tickets::Next(‘RT::Tickets=HASH(0x11eab464)’) called at
/usr/local/rt3/share/html/RTIR/Elements/IncidentSummary line 77
HTML::Mason::Commands::ANON(‘Type’, ‘Incident’, ‘ticket’, 1, ‘lookuptype’,
‘host’, ‘q’, ‘teste.com’) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x11f05050)’,
‘Type’, ‘Incident’, ‘ticket’, 1, ‘lookuptype’, ‘host’, ‘q’, ‘teste.com’) called
at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1256
eval {…} at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line
1250
HTML::Mason::Request::comp(undef, undef, ‘Type’, ‘Incident’, ‘ticket’, 1,
‘lookuptype’, ‘host’, ‘q’, ‘teste.com’) called at
/usr/local/rt3/share/html/RTIR/Tools/Lookup.html line 44
HTML::Mason::Commands::ANON at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1321
HTML::Mason::Request::content(‘HTML::Mason::Request::ApacheHandler=HASH(0x11c99064)’)
called at /usr/local/rt3/share/html/Widgets/TitleBox line 49
HTML::Mason::Commands::ANON(‘title’, ‘Incidents: teste.com’) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x114feb38)’,
‘title’, ‘Incidents: teste.com’) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1256
eval {…} at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line
1250
HTML::Mason::Request::comp(undef, undef, undef, ‘title’, ‘Incidents: teste.com’)
called at /usr/local/rt3/share/html/RTIR/Tools/Lookup.html line 50
HTML::Mason::Commands::ANON(‘q’, ‘teste.com’, ‘type’, ‘host’, ‘ticket’, 1)
called at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line
135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x11ea488c)’,
‘q’, ‘teste.com’, ‘type’, ‘host’, ‘ticket’, 1) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1256
eval {…} at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line
1250
HTML::Mason::Request::comp(undef, undef, undef, ‘q’, ‘teste.com’, ‘type’,
‘host’, ‘ticket’, 1) called at /usr/local/rt3/share/html/autohandler line 290
HTML::Mason::Commands::ANON(‘q’, ‘teste.com’, ‘type’, ‘host’, ‘ticket’, 1)
called at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line
135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x11420694)’,
‘q’, ‘teste.com’, ‘type’, ‘host’, ‘ticket’, 1) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1251
eval {…} at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line
1250
HTML::Mason::Request::comp(undef, undef, undef, ‘q’, ‘teste.com’, ‘type’,
‘host’, ‘ticket’, 1) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 460
eval {…} at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line
460
eval {…} at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line
412
HTML::Mason::Request::exec(‘HTML::Mason::Request::ApacheHandler=HASH(0x11c99064)’)
called at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line
168
HTML::Mason::Request::ApacheHandler::exec(‘HTML::Mason::Request::ApacheHandler=HASH(0x11c99064)’)
called at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line
826
HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(0x1110a1b8)’,
‘Apache=SCALAR(0x11bfae70)’) called at /usr/local/rt3/bin/webmux.pl line 123
eval {…} at /usr/local/rt3/bin/webmux.pl line 123
RT::Mason::handler(‘Apache=SCALAR(0x11bfae70)’) called at /dev/null line 0
eval {…} at /dev/null line 0

Regards,
Fernando.

Citando Jesse Vincent jesse@bestpractical.com:

15

I fixed this problem in RT’s repo several weeks ago, I can find
patches. Or you can downgrade SB to 1.45x or earlier.On 4/25/07, Fernando Fugita fugita@usp.br wrote:

Vicent,

I running last version of SearchBuilder (1.48), and MySQL 5.0.18 in my test
environment.

code stack:
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:1045
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm:353
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm:430
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm:233
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm:498
/usr/local/rt3/lib/RT/Tickets_Overlay.pm:2593
/usr/local/rt3/share/html/RTIR/Elements/IncidentSummary:77
/usr/local/rt3/share/html/RTIR/Tools/Lookup.html:44
/usr/local/rt3/share/html/Widgets/TitleBox:49
/usr/local/rt3/share/html/RTIR/Tools/Lookup.html:50
/usr/local/rt3/share/html/autohandler:290
raw error

Unsatisfied dependency chain in joins Attachments_2 Transactions_1 at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 1045.

Trace begun at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Exceptions.pm
line 129
HTML::Mason::Exceptions::rethrow_exception(‘Unsatisfied dependency chain in
joins Attachments_2 Transactions_1 at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line
1045.^J’) called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 1045
DBIx::SearchBuilder::Handle::_BuildJoins(‘RT::Handle=HASH(0x1110f218)’,
‘RT::Tickets=HASH(0x11eab464)’) called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line 353
DBIx::SearchBuilder::_BuildJoins(‘RT::Tickets=HASH(0x11eab464)’) called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line 430
DBIx::SearchBuilder::BuildSelectQuery(‘RT::Tickets=HASH(0x11eab464)’) called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line 233
DBIx::SearchBuilder::_DoSearch(‘RT::Tickets=HASH(0x11eab464)’) called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line 498
DBIx::SearchBuilder::Next(‘RT::Tickets=HASH(0x11eab464)’) called at
/usr/local/rt3/lib/RT/Tickets_Overlay.pm line 2593
RT::tickets::Next(‘RT::Tickets=HASH(0x11eab464)’) called at
/usr/local/rt3/share/html/RTIR/Elements/IncidentSummary line 77
HTML::Mason::Commands::ANON(‘Type’, ‘Incident’, ‘ticket’, 1, ‘lookuptype’,
‘host’, ‘q’, ‘teste.com’) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x11f05050)’,
‘Type’, ‘Incident’, ‘ticket’, 1, ‘lookuptype’, ‘host’, ‘q’, ‘teste.com’) called
at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1256
eval {…} at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line
1250
HTML::Mason::Request::comp(undef, undef, ‘Type’, ‘Incident’, ‘ticket’, 1,
‘lookuptype’, ‘host’, ‘q’, ‘teste.com’) called at
/usr/local/rt3/share/html/RTIR/Tools/Lookup.html line 44
HTML::Mason::Commands::ANON at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1321
HTML::Mason::Request::content(‘HTML::Mason::Request::ApacheHandler=HASH(0x11c99064)’)
called at /usr/local/rt3/share/html/Widgets/TitleBox line 49
HTML::Mason::Commands::ANON(‘title’, ‘Incidents: teste.com’) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x114feb38)’,
‘title’, ‘Incidents: teste.com’) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1256
eval {…} at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line
1250
HTML::Mason::Request::comp(undef, undef, undef, ‘title’, ‘Incidents: teste.com’)
called at /usr/local/rt3/share/html/RTIR/Tools/Lookup.html line 50
HTML::Mason::Commands::ANON(‘q’, ‘teste.com’, ‘type’, ‘host’, ‘ticket’, 1)
called at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line
135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x11ea488c)’,
‘q’, ‘teste.com’, ‘type’, ‘host’, ‘ticket’, 1) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1256
eval {…} at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line
1250
HTML::Mason::Request::comp(undef, undef, undef, ‘q’, ‘teste.com’, ‘type’,
‘host’, ‘ticket’, 1) called at /usr/local/rt3/share/html/autohandler line 290
HTML::Mason::Commands::ANON(‘q’, ‘teste.com’, ‘type’, ‘host’, ‘ticket’, 1)
called at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line
135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x11420694)’,
‘q’, ‘teste.com’, ‘type’, ‘host’, ‘ticket’, 1) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1251
eval {…} at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line
1250
HTML::Mason::Request::comp(undef, undef, undef, ‘q’, ‘teste.com’, ‘type’,
‘host’, ‘ticket’, 1) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 460
eval {…} at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line
460
eval {…} at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line
412
HTML::Mason::Request::exec(‘HTML::Mason::Request::ApacheHandler=HASH(0x11c99064)’)
called at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line
168
HTML::Mason::Request::ApacheHandler::exec(‘HTML::Mason::Request::ApacheHandler=HASH(0x11c99064)’)
called at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line
826
HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(0x1110a1b8)’,
‘Apache=SCALAR(0x11bfae70)’) called at /usr/local/rt3/bin/webmux.pl line 123
eval {…} at /usr/local/rt3/bin/webmux.pl line 123
RT::Mason::handler(‘Apache=SCALAR(0x11bfae70)’) called at /dev/null line 0
eval {…} at /dev/null line 0

Regards,
Fernando.

Citando Jesse Vincent jesse@bestpractical.com:

On Apr 25, 2007, at 10:50 AM, Fernando Fugita wrote:

Hi,

I tried to install this version, but II received this error at
/RTIR/Tools/Lookup.html?ticket=1&type=host&q=teste.com :

Are you current on DBIx::SearchBuilder? Can you give us the full
stack trace? Which Database/

Rtir mailing list
Rtir@lists.bestpractical.com
The rtir Archives

Best regards, Ruslan.

16

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

Hi,

I’m facing with the same problem. When I try to “Lookup” whois record
for an IP address, an error with message “Unsatisfied dependency chain
in joins Attachments_2 Transactions_1 at /usr/share/perl/5.8/CGI/Carp.pm
line 314.” occurs. Attached file contains the error page.

Is this problem also related with that patch and if so, where can I find
patches?

Regards,

  • -ge

PS: Components of system: Debian OS (testing), Postgresql 8.1, Apache2
mod Perl2, with RT-3.7.5, RTFM-2.2.ORC5 and RTIR-2.1.5

Ruslan Zakirov wrote:

I fixed this problem in RT’s repo several weeks ago, I can find
patches. Or you can downgrade SB to 1.45x or earlier.

Vicent,

Hi,

I tried to install this version, but II received this error at
/RTIR/Tools/Lookup.html?ticket=1&type=host&q=teste.com :
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGNcuD/pk5/FzrR5YRAnNWAJ90p9bCYNuTlzHtTuiCRkvZgAjhXwCfUR6K
d3lOOLw5GwklbTTQq+ZG4jc=
=rH79
-----END PGP SIGNATURE-----

rtir-error.txt (6.01 KB)

17

easy way is to downgrade DBIx::SearchBuilder to 1.45On 4/30/07, Gokhan ERYOL eryol@ulakbim.gov.tr wrote:

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

Hi,

I’m facing with the same problem. When I try to “Lookup” whois record
for an IP address, an error with message “Unsatisfied dependency chain
in joins Attachments_2 Transactions_1 at /usr/share/perl/5.8/CGI/Carp.pm
line 314.” occurs. Attached file contains the error page.

Is this problem also related with that patch and if so, where can I find
patches?

Regards,

  • -ge

PS: Components of system: Debian OS (testing), Postgresql 8.1, Apache2
mod Perl2, with RT-3.7.5, RTFM-2.2.ORC5 and RTIR-2.1.5

Ruslan Zakirov wrote:

I fixed this problem in RT’s repo several weeks ago, I can find
patches. Or you can downgrade SB to 1.45x or earlier.

On 4/25/07, Fernando Fugita fugita@usp.br wrote:

Vicent,

On Apr 25, 2007, at 10:50 AM, Fernando Fugita wrote:

Hi,

I tried to install this version, but II received this error at
/RTIR/Tools/Lookup.html?ticket=1&type=host&q=teste.com :
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGNcuD/pk5/FzrR5YRAnNWAJ90p9bCYNuTlzHtTuiCRkvZgAjhXwCfUR6K
d3lOOLw5GwklbTTQq+ZG4jc=
=rH79
-----END PGP SIGNATURE-----

System error
error: Unsatisfied dependency chain in joins Attachments_2 Transactions_1 at /usr/share/perl/5.8/CGI/Carp.pm line 314.
context:
…
310: }
311:
312: # These are the originals
313: sub realwarn { CORE::warn(@); }
314: sub realdie { CORE::die(@); }
315:
316: sub id {
317: my $level = shift;
318: my($pack,$file,$line,$sub) = caller($level);
…
code stack: /usr/share/perl/5.8/CGI/Carp.pm:314
/usr/share/perl/5.8/CGI/Carp.pm:385
/usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm:1044
/usr/local/share/perl/5.8.8/DBIx/SearchBuilder.pm:353
/usr/local/share/perl/5.8.8/DBIx/SearchBuilder.pm:430
/usr/local/share/perl/5.8.8/DBIx/SearchBuilder.pm:233
/usr/local/share/perl/5.8.8/DBIx/SearchBuilder.pm:498
/usr/local/rt3/lib/RT/Tickets_Overlay.pm:2593
/usr/local/rt3/share/html/RTIR/Elements/IncidentSummary:77
/usr/local/rt3/share/html/RTIR/Tools/Lookup.html:44
/usr/local/rt3/share/html/Widgets/TitleBox:49
/usr/local/rt3/share/html/RTIR/Tools/Lookup.html:50
/usr/local/rt3/share/html/autohandler:290

raw error
Unsatisfied dependency chain in joins Attachments_2 Transactions_1 at /usr/share/perl/5.8/CGI/Carp.pm line 314.

Trace begun at /usr/local/share/perl/5.8.8/HTML/Mason/Exceptions.pm line 129
HTML::Mason::Exceptions::rethrow_exception(‘Unsatisfied dependency chain in joins Attachments_2 Transactions_1 at /usr/share/perl/5.8/CGI/Carp.pm line 314.^J’) called at /usr/share/perl/5.8/CGI/Carp.pm line 314
CGI::Carp::realdie(‘Unsatisfied dependency chain in joins Attachments_2 Transactions_1’) called at /usr/share/perl/5.8/CGI/Carp.pm line 385
CGI::Carp::die(‘Unsatisfied dependency chain in joins Attachments_2 Transactions_1’) called at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 1044
DBIx::SearchBuilder::Handle::_BuildJoins(‘RT::Handle=HASH(0xb0e173c)’, ‘RT::Tickets=HASH(0xbb2fee8)’) called at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder.pm line 353
DBIx::SearchBuilder::_BuildJoins(‘RT::Tickets=HASH(0xbb2fee8)’) called at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder.pm line 430
DBIx::SearchBuilder::BuildSelectQuery(‘RT::Tickets=HASH(0xbb2fee8)’) called at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder.pm line 233
DBIx::SearchBuilder::_DoSearch(‘RT::Tickets=HASH(0xbb2fee8)’) called at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder.pm line 498
DBIx::SearchBuilder::Next(‘RT::Tickets=HASH(0xbb2fee8)’) called at /usr/local/rt3/lib/RT/Tickets_Overlay.pm line 2593
RT::tickets::Next(‘RT::Tickets=HASH(0xbb2fee8)’) called at /usr/local/rt3/share/html/RTIR/Elements/IncidentSummary line 77
HTML::Mason::Commands::ANON(‘Type’, undef, ‘ticket’, ‘’, ‘lookuptype’, undef, ‘q’, 144.122.3.235) called at /usr/local/share/perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xbb47db0)’, ‘Type’, undef, ‘ticket’, ‘’, ‘lookuptype’, undef, ‘q’, 144.122.3.235) called at /usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 1256
eval {…} at /usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 1246
HTML::Mason::Request::comp(undef, undef, ‘Type’, undef, ‘ticket’, ‘’, ‘lookuptype’, undef, ‘q’, 144.122.3.235) called at /usr/local/rt3/share/html/RTIR/Tools/Lookup.html line 44
HTML::Mason::Commands::ANON at /usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 1329
eval {…} at /usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 1329
HTML::Mason::Request::content(‘HTML::Mason::Request::ApacheHandler=HASH(0xb5a3a28)’) called at /usr/local/rt3/share/html/Widgets/TitleBox line 49
HTML::Mason::Commands::ANON(‘title’, ‘Incidents: 144.122.3.235’) called at /usr/local/share/perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xbb4e030)’, ‘title’, ‘Incidents: 144.122.3.235’) called at /usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 1256
eval {…} at /usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 1246
HTML::Mason::Request::comp(undef, undef, undef, ‘title’, ‘Incidents: 144.122.3.235’) called at /usr/local/rt3/share/html/RTIR/Tools/Lookup.html line 50
HTML::Mason::Commands::ANON(‘q’, 144.122.3.235, ‘server’, ‘whois.ripe.net’, ‘ticket’, ‘’) called at /usr/local/share/perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xb68c524)’, ‘q’, 144.122.3.235, ‘server’, ‘whois.ripe.net’, ‘ticket’, ‘’) called at /usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 1256
eval {…} at /usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 1246
HTML::Mason::Request::comp(undef, undef, undef, ‘q’, 144.122.3.235, ‘server’, ‘whois.ripe.net’, ‘ticket’, ‘’) called at /usr/local/rt3/share/html/autohandler line 290
HTML::Mason::Commands::ANON(‘q’, 144.122.3.235, ‘server’, ‘whois.ripe.net’, ‘ticket’, ‘’) called at /usr/local/share/perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xb6abd74)’, ‘q’, 144.122.3.235, ‘server’, ‘whois.ripe.net’, ‘ticket’, ‘’) called at /usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 1251
eval {…} at /usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 1246
HTML::Mason::Request::comp(undef, undef, undef, ‘q’, 144.122.3.235, ‘server’, ‘whois.ripe.net’, ‘ticket’, ‘’) called at /usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 460
eval {…} at /usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 460
eval {…} at /usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 412
HTML::Mason::Request::exec(‘HTML::Mason::Request::ApacheHandler=HASH(0xb5a3a28)’) called at /usr/local/share/perl/5.8.8/HTML/Mason/ApacheHandler.pm line 168
HTML::Mason::Request::ApacheHandler::exec(‘HTML::Mason::Request::ApacheHandler=HASH(0xb5a3a28)’) called at /usr/local/share/perl/5.8.8/HTML/Mason/ApacheHandler.pm line 826
HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(0x8e839a0)’, ‘Apache2::RequestRec=SCALAR(0x8e82a78)’) called at /usr/local/rt3/bin/webmux.pl line 123
eval {…} at /usr/local/rt3/bin/webmux.pl line 123
RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0x8e82a78)’) called at -e line 0
eval {…} at -e line 0

Best regards, Ruslan.

18

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

Ok, it’s running now, thanks :slight_smile:

By the way, I saw the latest uploads under the link:
Index of /pub/rt/devel/RTIR_M3 .
Before going into production environment, should we install these
versions or wait for new release?

  • -ge

Ruslan Zakirov wrote:

easy way is to downgrade DBIx::SearchBuilder to 1.45

Hi,

I’m facing with the same problem. When I try to “Lookup” whois record
for an IP address, an error with message “Unsatisfied dependency chain
in joins Attachments_2 Transactions_1 at /usr/share/perl/5.8/CGI/Carp.pm
line 314.” occurs. Attached file contains the error page.

Is this problem also related with that patch and if so, where can I find
patches?

Regards,

-ge

PS: Components of system: Debian OS (testing), Postgresql 8.1, Apache2
mod Perl2, with RT-3.7.5, RTFM-2.2.ORC5 and RTIR-2.1.5
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGNeoi/pk5/FzrR5YRApqCAJ4pFs5Niti8y6YW0FcNMSCAbobmaACfcJVK
KFjkUkigA0FYBXe3s7JX+f8=
=ubLN
-----END PGP SIGNATURE-----

19

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

Ok, it’s running now, thanks :slight_smile:

By the way, I saw the latest uploads under the link:
Index of /pub/rt/devel/RTIR_M3 .
Before going into production environment, should we install these
versions or wait for new release?

These devel milestone builds are brand new and the results of six
months of hard development by Best Practical hackers. We’d certainly
appreciate you putting them through their paces, but I’d recommend
doing so in your testing environment first.

Best,
Jesse

PGP.sig (186 Bytes)

20

Jesse,

I downloaded this milestone, but I would like to run it on RedHat
EL 5,
which only comes with mod_perl2. The make fixdeps fails trying to
build
libapreq from CPAN. Is there a recent version of IR that will build
against mod_perl2?

It’s just a different configure invocation.

[Please CC the list on replies in the future]

Best,
Jesse

PGP.sig (186 Bytes)