Opened 2 years ago

Last modified 2 years ago

#27715 new enhancement

support relative time in timestamp parameter

Reported by: exonerator Owned by: metrics-team
Priority: Medium Milestone:
Component: Metrics/ExoneraTor Version:
Severity: Normal Keywords:
Cc: Actual Points:
Parent ID: Points:
Reviewer: Sponsor:


for our tor exit abuse ticket system (which is sending auto-replies) it would be nice to be able to include a direct exonerator URL with our IP and say a lookup for yesterday (or 2 days ago)

The auto-reply text is static so the URL would also have to be a static string

Child Tickets

Change History (1)

comment:1 Changed 2 years ago by karsten

Hmm, I see the use case, but I don't really like that the timestamp parameter accepts a date and a number.

Here's a possible variation of your idea, which would cover even more use cases than yours: if the timestamp parameter is left empty, we return the most recent 3 days when the given IP address was seen in the Tor network. We could even include this in the web interface by making the date parameter optional and saying what we return if it's left empty.

In theory, our new database schema should handle this query just fine. It should be just one more query in the date_address24 table to learn the latest contained date for a given IP address prefix. That table is currently 1130 MB large with over 10 years of data.

If this makes sense, we can put it on the list. Needs a patch and a fair amount of testing, so that we're not running into performance issues again.

Note: See TracTickets for help on using tickets.