[Rtir] "Lookup IP" suddenly stopped working...

Landon Stewart lstewart at superb.net
Tue Nov 24 17:32:08 EST 2009


Hate to sound like a noob here but I can't figure out how to apply the
changes from github apart from carefully reading them and editing the files
manually.  Is there a better way?

On Mon, Nov 23, 2009 at 2:51 PM, Ruslan Zakirov <ruslan.zakirov at gmail.com>wrote:

> Hi,
>
> There is a bug in RT 3.8.5 and earlier (I don't recall when exactly it
> was introduced, but somehwere between 3.8.2 and 3.8.5) that affects
> search by IP. SQL query generated by RT is just wrong. This bug has
> been fixed in RT 3.8.6. A few users of RTIR confirmed the fix.
>
> You either can upgrade RT or try the following changes out of github:
>
> 86cef7ee885912896a3be995a3cd5ebfe77ccf47
> e647495094f1a9c487a1953f10725127340940d4
>
> I hope it's all you need (80% sure :).
>
> Please report back.
>
> On Tue, Nov 24, 2009 at 12:09 AM, Landon Stewart <lstewart at superb.net>
> wrote:
> > Hi Ruslan,
> >
> > RT version is RT 3.8.5
> > RTIR version is RTIR is 2.4.1
> >
> > Thanks very much for checking this out.
> >
> > On Mon, Nov 23, 2009 at 12:58 PM, Ruslan Zakirov <
> ruslan.zakirov at gmail.com>
> > wrote:
> >>
> >> Hello Landon,
> >>
> >> You didn't mention RT/RTIR versions. I believe RT upgrade can cause
> >> this. Anyway, I'll make a check once you give me versions.
> >>
> >> On Mon, Nov 23, 2009 at 11:46 PM, Landon Stewart <lstewart at superb.net>
> >> wrote:
> >> > Hi Guys,
> >> >
> >> > No upgrades to any perl modules or server software of any kind or
> >> > changes to
> >> > any files have been made but it seems that the "Lookup IP" link within
> a
> >> > ticket doesn't quite work properly.  The link is displayed with what I
> >> > guess
> >> > is some incomplete information as the parameters.  For example when
> >> > viewing
> >> > ticket #12491 I see the link "Lookup IP" link pointing to
> >> > http://<ourhostname>/RTIR/Tools/Lookup.html?type=ip&q=209.160.28.156.
> >> > When
> >> > clicking it the results are empty but the rwhois lookup occurs at the
> >> > bottom
> >> > of the page.  If I edit the URL and include include ticket=12491 it
> >> > works
> >> > properly (eg.
> >> >
> >> > http://
> <ourhostname>/RTIR/Tools/Lookup.html?ticket=12491&type=ip&q=209.160.28.156).
> >> > and displays the "Current Incident: #12491" header with the current
> >> > ticket
> >> > listed as well as other tickets that match the IP address being looked
> >> > up.
> >> >
> >> > Conversely if I click the link as it is which sends me to
> >> > http://<ourhostname>/RTIR/Tools/Lookup.html?type=ip&q=209.160.28.156
> and
> >> > *then* click the "Go" button next to the WHOIS lookup field that's
> >> > already
> >> > filled out the lookup works and finds tickets with the IP address
> being
> >> > looked up but of course without the ticket lookup.
> >> >
> >> > I'm really at a loss for why it would stop working all of a sudden.
> >> > This
> >> > has been a problem for more than a week now, I thought maybe it was
> some
> >> > bad
> >> > database entries or caching or something but the issue has not gone
> away
> >> > after clearing the mason_data etc.
> >> >
> >> > If anyone has any ideas on what I should check or what I can provide
> to
> >> > help
> >> > troubleshoot this please let me know.  I'm moderately versed in Perl
> so
> >> > I
> >> > can try some things if anyone has any ideas.
> >> >
> >> > Regards,
> >> >
> >> >
> >> > --
> >> > Landon Stewart <LStewart at SUPERB.NET>
> >> > SuperbHosting.Net by Superb Internet Corp.
> >> > Toll Free: 888-354-6128 x 4199 (US/Canada)
> >> > Web hosting and more "Ahead of the Rest":
> http://www.superbhosting.net
> >> >
> >> > _______________________________________________
> >> > Rtir mailing list
> >> > Rtir at lists.bestpractical.com
> >> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rtir
> >> >
> >> >
> >>
> >>
> >>
> >> --
> >> Best regards, Ruslan.
> >
> >
> >
> > --
> > Landon Stewart <LStewart at SUPERB.NET>
> > SuperbHosting.Net by Superb Internet Corp.
> > Toll Free: 888-354-6128 x 4199 (US/Canada)
> > Web hosting and more "Ahead of the Rest": http://www.superbhosting.net
> >
>
>
>
> --
> Best regards, Ruslan.
>



-- 
Landon Stewart <LStewart at SUPERB.NET>
SuperbHosting.Net by Superb Internet Corp.
Toll Free: 888-354-6128 x 4199 (US/Canada)
Web hosting and more "Ahead of the Rest": http://www.superbhosting.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.bestpractical.com/pipermail/rtir/attachments/20091124/49191a96/attachment.htm 


More information about the Rtir mailing list