[db-wg] Fw: [anti-abuse-wg] NWI reviews: NWI-1 staying on top of abuse contact changes

> > We need to take some action on these old NWIs. Either we move forward
> with them or we cancel them. It is difficult to draw a consensus on 2
> comments. Can you please give us a couple of minutes of your time and
> let us know if this NWI-1 is needed, useful or a waste of time.
> 
> I share the view already expressed. If we need a tool, maybe the problem
> is somewhere else.

I support any proposal, that comes to the same result as the ripe whois database tool.
It's not really hard to do correctly.

#! /bin/sh

getripe="whois -h whois.ripe.net --"

$getripe -rL -T inetnum,inet6num "$1" | egrep '^org:' | while read ot ov; do
  $getripe -r -T organisation $ov | egrep '^abuse-c:' | while read at av; do
    $getripe -r $av | fgrep abuse-mailbox
  done
done | tail -1


In order to fix the issue on the database side, it's necessary to prevent any occurrence of "abuse-mailbox" in all objects beside an newly created "abuse-contact" type, which is only allowed to referenced in the "abuse-c".

See here for a corner case: https://lutz.donnerhacke.de/eng/Blog/Antispammers-and-Abuse-C