On Thu, 9 Aug 2018 at 18:20, Brian Rak via db-wg <db-wg@ripe.net> wrote:
We hit issues with: https://rdap.db.ripe.net/ip/37.246.0.0/16
It looks like someone added multiple country: fields in the RIPE database
inetnum: 37.246.0.0 - 37.246.255.255 netname: MD-SHATRANS-20120417 country: GB country: US org: ORG-TS151-RIPE
How did this even get into the database in the first place? I'm not sure returning an error via RDAP is really the best way of handling this.
Looks like several INETNUM objects have more than 1 country code attached in the RIPE NCC database. :/ ~ > whois -h whois.ripe.net -rB -T as-set,aut-num,domain,filter-set,inetnum,inet6num,person,peering-set,organisation,mntner,key-cert,irt,inet-rtr,poem,poetic-form,role,route,route6,route-set,rtr-set -i mnt-routes,mnt-ref,mnt-nfy,mnt-lower,mnt-irt,mnt-domains,mnt-by SHA-MNT | grep -v '^%' | cat -s inetnum: 37.246.0.0 - 37.246.127.255 netname: FHN-MPLS-200092990T descr: Fiberhop Communications Ltd. country: GB country: US admin-c: FNS32-RIPE tech-c: FNS32-RIPE status: ASSIGNED PA mnt-by: SHA-MNT created: 2013-03-13T14:13:05Z last-modified: 2018-01-25T22:44:54Z source: RIPE inetnum: 37.246.0.0 - 37.246.255.255 netname: MD-SHATRANS-20120417 country: US org: ORG-TS151-RIPE admin-c: FH5305-RIPE tech-c: FH5305-RIPE status: ALLOCATED PA mnt-by: RIPE-NCC-HM-MNT mnt-by: SHA-MNT mnt-routes: SHA-MNT notify: noc@fiberhop.com created: 2012-04-17T07:57:05Z last-modified: 2018-08-09T16:30:43Z source: RIPE inetnum: 37.246.128.0 - 37.246.191.255 netname: FHN-RPLS-10393K descr: Fiberhop Communications Ltd. country: GB country: US admin-c: FH5305-RIPE tech-c: FH5305-RIPE status: ASSIGNED PA mnt-by: SHA-MNT created: 2013-08-29T17:05:24Z last-modified: 2018-01-25T22:47:10Z source: RIPE inetnum: 37.246.192.0 - 37.246.255.255 netname: FHN-RPLS-54100029K descr: Fiberhop Communications Ltd. country: GB country: US country: TR admin-c: FNS32-RIPE tech-c: FNS32-RIPE status: ASSIGNED PA mnt-by: SHA-MNT created: 2013-03-17T18:34:07Z last-modified: 2018-01-25T22:44:27Z source: RIPE inetnum: 81.162.128.0 - 81.162.191.255 netname: SHA-Trans country: US org: ORG-TS151-RIPE admin-c: FNS32-RIPE tech-c: FNS32-RIPE status: ASSIGNED PI mnt-by: RIPE-NCC-END-MNT mnt-by: SHA-MNT mnt-routes: SHA-MNT mnt-domains: SHA-MNT created: 2011-12-06T13:51:42Z last-modified: 2018-08-09T16:31:19Z source: RIPE aut-num: AS57598 as-name: SHA-AS org: ORG-TS151-RIPE import: from AS15836 accept ANY export: to AS15836 announce AS57598 admin-c: FH5305-RIPE tech-c: FH5305-RIPE status: ASSIGNED mnt-by: RIPE-NCC-END-MNT mnt-by: SHA-MNT mnt-routes: SHA-MNT created: 2011-12-07T11:09:46Z last-modified: 2018-01-26T23:02:37Z source: RIPE route: 37.246.0.0/16 descr: SHA-Trans Route origin: AS57598 mnt-by: SHA-MNT created: 2012-04-19T12:24:58Z last-modified: 2012-04-19T12:24:58Z source: RIPE route: 81.162.128.0/18 descr: "S.H.A. Trans" S.R.L. origin: AS57598 mnt-by: SHA-MNT created: 2011-12-07T11:20:01Z last-modified: 2011-12-07T12:13:43Z source: RIPE mntner: SHA-MNT descr: Fiberhop Communications Ltd. admin-c: FNS32-RIPE upd-to: noc@fiberhop.co.uk auth: SSO # Filtered mnt-by: SHA-MNT created: 2011-12-07T12:11:51Z last-modified: 2018-01-25T22:41:10Z source: RIPE # Filtered irt: IRT-SHATRANS address: FiberHop Communications Ltd. address: 71-75 Shelton Street Covent Garden address: London, WC2H 9JQ address: GB e-mail: noc@fiberhop.co.uk admin-c: FNS32-RIPE tech-c: FNS32-RIPE auth: MD5-PW # Filtered mnt-by: SHA-MNT created: 2012-04-24T18:53:29Z last-modified: 2018-01-27T00:09:45Z source: RIPE # Filtered organisation: ORG-TS151-RIPE org-name: "S.H.A. Trans" S.R.L. org-type: LIR address: 71?75 Shelton Street Covent Garden address: WC2H 9JQ address: London address: UNITED KINGDOM e-mail: noc@fiberhop.com mnt-ref: SHA-MNT mnt-ref: RIPE-NCC-HM-MNT mnt-by: RIPE-NCC-HM-MNT mnt-by: SHA-MNT abuse-c: FNS32-RIPE created: 2012-03-19T16:28:42Z last-modified: 2018-08-09T16:02:13Z source: RIPE phone: +13058097217 fax-no: +13058097217 admin-c: FH5305-RIPE role: FiberHop Hostmaster address: 71-75 Shelton Street Covent Garden address: WC2H 9JQ address: London, GB phone: +13058097217 e-mail: noc@fiberhop.com admin-c: MMB144-RIPE admin-c: JC9841-RIPE tech-c: MMB144-RIPE tech-c: JC9841-RIPE nic-hdl: FH5305-RIPE remarks: mnt-by: SHA-MNT created: 2018-01-25T22:34:09Z last-modified: 2018-08-09T15:58:31Z source: RIPE role: FiberHop Network Security nic-hdl: FNS32-RIPE address: 71-75 Shelton Street Covent Garden address: London, GB WC2H 9JQ abuse-mailbox: security@fiberhop.com mnt-by: SHA-MNT e-mail: noc@fiberhop.com created: 2018-01-25T22:33:34Z last-modified: 2018-08-09T16:00:38Z source: RIPE person: Jerry Coleman address: Fiberhop Communications Ltd. address: 71-75 Shelton Street address: Covent Garden, WC2H 9JQ address: London, GB phone: +13058097217 e-mail: jerry.coleman@fiberhop.co.uk nic-hdl: JC9841-RIPE remarks: notify: noc@fiberhop.co.uk mnt-by: SHA-MNT created: 2018-01-25T22:24:04Z last-modified: 2018-01-25T22:34:37Z source: RIPE person: Michael M. Basaran address: Fiberhop Communications Ltd. address: 71-75 Shelton Street address: Covent Garden, WC2H 9JQ address: London, GB phone: +13058097217 e-mail: noc@fiberhop.co.uk nic-hdl: MMB144-RIPE remarks: notify: noc@fiberhop.co.uk mnt-by: SHA-MNT created: 2018-01-25T22:26:34Z last-modified: 2018-01-25T22:34:17Z source: RIPE