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

[Ruslan Zakirov]

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.