<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I fully agree with Cynthia here, we use the maintainer STACLAR for example.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I have looked through the database files and there seem to be exactly 26 maintainer objects that are named as an ASN (without any prefixes or suffixes). I think the best solution would be to just block the creation of new objects like this and manually check
through the existing ones to find potentially fraudulent ones.</div>
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<table style="color:rgb(255,255,255); font-size:medium; text-align:start; background-color:rgb(255,255,255); font-family:Arial">
<tbody>
<tr>
<td>
<table style="vertical-align:-webkit-baseline-middle">
<tbody>
<tr>
<td style="vertical-align:middle">
<h3 color="#0C0C35" style="margin:0px; font-size:18px; color:rgb(12,12,53)"><span>Matthias</span><span> </span><span>Merkel</span></h3>
<p color="#0C0C35" style="margin:0px; color:rgb(12,12,53); font-size:14px; line-height:22px">
<span>Vice President</span></p>
<p color="#0C0C35" style="margin:0px; font-weight:500; color:rgb(12,12,53); font-size:14px; line-height:22px">
<span>Staclar, Inc.</span></p>
</td>
<td width="30">
<div style="box-sizing:border-box"></div>
</td>
<td color="#37ABC8" width="1" style="width:1px; border-bottom:none; border-left:1px solid rgb(55,171,200)">
</td>
<td width="30">
<div style="box-sizing:border-box"></div>
</td>
<td style="vertical-align:middle">
<table style="vertical-align:-webkit-baseline-middle">
<tbody>
<tr height="25" style="vertical-align:middle">
<td width="30" style="vertical-align:middle">
<table style="vertical-align:-webkit-baseline-middle">
<tbody>
<tr>
<td style="vertical-align:bottom"><span color="#37ABC8" width="11" style="display:block; background-color:rgb(55,171,200)"><img color="#37ABC8" width="13" style="display:block; background-color:rgb(55,171,200)" src="https://cdn2.hubspot.net/hubfs/53/tools/email-signature-generator/icons/phone-icon-2x.png"></span></td>
</tr>
</tbody>
</table>
</td>
<td style="color:rgb(12,12,53)"><span style="font-size:12px">+1-302-291-1141 </span>|<span> </span><span style="color:rgb(12,12,53); font-family:Arial; background-color:rgb(255,255,255); display:inline!important"><span style="font-family:Arial; font-size:12px; background-color:rgb(255,255,255); display:inline!important">+49
15678 585608</span></span></td>
</tr>
<tr height="25" style="vertical-align:middle">
<td width="30" style="vertical-align:middle">
<table style="vertical-align:-webkit-baseline-middle">
<tbody>
<tr>
<td style="vertical-align:bottom"><span color="#37ABC8" width="11" style="display:block; background-color:rgb(55,171,200)"><img color="#37ABC8" width="13" style="display:block; background-color:rgb(55,171,200)" src="https://cdn2.hubspot.net/hubfs/53/tools/email-signature-generator/icons/email-icon-2x.png"></span></td>
</tr>
</tbody>
</table>
</td>
<td><a href="mailto:matthias.merkel@staclar.com" color="#0C0C35" style="color:rgb(12,12,53); font-size:12px"><span>matthias.merkel@staclar.com</span></a></td>
</tr>
<tr height="25" style="vertical-align:middle">
<td width="30" style="vertical-align:middle">
<table style="vertical-align:-webkit-baseline-middle">
<tbody>
<tr>
<td style="vertical-align:bottom"><span color="#37ABC8" width="11" style="display:block; background-color:rgb(55,171,200)"><img color="#37ABC8" width="13" style="display:block; background-color:rgb(55,171,200)" src="https://cdn2.hubspot.net/hubfs/53/tools/email-signature-generator/icons/link-icon-2x.png"></span></td>
</tr>
</tbody>
</table>
</td>
<td><a href="https://staclar.com/" color="#0C0C35" style="color:rgb(12,12,53); font-size:12px"><span>staclar.com</span></a></td>
</tr>
<tr height="25" style="vertical-align:middle">
<td width="30" style="vertical-align:middle">
<table style="vertical-align:-webkit-baseline-middle">
<tbody>
<tr>
<td style="vertical-align:bottom"><span color="#37ABC8" width="11" style="display:block; background-color:rgb(55,171,200)"><img color="#37ABC8" width="13" style="display:block; background-color:rgb(55,171,200)" src="https://cdn2.hubspot.net/hubfs/53/tools/email-signature-generator/icons/address-icon-2x.png"></span></td>
</tr>
</tbody>
</table>
</td>
<td><span color="#0C0C35" style="font-size:12px; color:rgb(12,12,53)"><span>Munich, Germany</span></span></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td>
<table style="width:434px">
<tbody>
<tr>
<td height="30"></td>
</tr>
<tr>
<td color="#37ABC8" height="1" style="width:434px; border-bottom:1px solid rgb(55,171,200); border-left:none; display:block">
</td>
</tr>
<tr>
<td height="30"></td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td>
<table style="width:434px">
<tbody>
<tr>
<td style="vertical-align:top"><img width="130" style="max-width:130px; display:inline-block" src="https://staclar.com/images/logo.png"></td>
<td style="text-align:right; vertical-align:top">
<table style="display:inline-block">
<tbody>
<tr>
<td><a href="https://www.linkedin.com/in/matthias-merkel/" color="#37ABC8" style="display:inline-block; background-color:rgb(55,171,200)"><img alt="linkedin" color="#37ABC8" height="24" style="background-color:rgb(55,171,200); max-width:135px; display:block" src="https://cdn2.hubspot.net/hubfs/53/tools/email-signature-generator/icons/linkedin-icon-2x.png"></a></td>
<td width="5">
<div style="box-sizing:border-box"></div>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td height="30"><br>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> db-wg <db-wg-bounces@ripe.net> on behalf of Cynthia Revstr�m via db-wg <db-wg@ripe.net><br>
<b>Sent:</b> Wednesday, July 1, 2020 7:36 PM<br>
<b>To:</b> Job Snijders <job@instituut.net><br>
<b>Cc:</b> DB-WG <db-wg@ripe.net><br>
<b>Subject:</b> Re: [db-wg] mntner with misleading primary key</font>
<div> </div>
</div>
<div>
<div dir="ltr">I am not sure how feasible the mandatory "-mnt" would be at this point tbh.
<div>I can easily think of at least 2 maintainers that are actually used that I see quite often that wouldn't fit that pattern.</div>
<div>There are probably a considerable amount of maintainers that do not follow this pattern in fact...</div>
<div><br>
</div>
<div>$ grep -P 'mntner:\s+(?:(?!mnt\-|MNT\-|MAINT\-|maint\-).(?!\-MNT|\-mnt|\-maint|\-MAINT))+$' ripe.db.mntner | wc -l<br>
6990<br>
</div>
<div><br>
</div>
<div>$ grep -P 'mntner:\s+' ripe.db.mntner | wc -l</div>
<div>56524<br>
</div>
<div><br>
</div>
<div>I don't think we can make 12% of people change their maintainer for this purpose.</div>
<div><br>
</div>
<div>- Cynthia</div>
</div>
<br>
<div class="x_gmail_quote">
<div dir="ltr" class="x_gmail_attr">On Wed, Jul 1, 2020 at 6:28 PM Job Snijders via db-wg <<a href="mailto:db-wg@ripe.net">db-wg@ripe.net</a>> wrote:<br>
</div>
<blockquote class="x_gmail_quote" style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
Dear Tom,<br>
<br>
On Wed, Jul 1, 2020, at 16:16, Tom Hill via db-wg wrote:<br>
> Unless of course, parsing/filtering before insertion (thus augmenting<br>
> the database's table natural design restrictions) is not something Good<br>
> To Do. Database design definitely isn't my primary skill.<br>
> <br>
> Saying that, I have long been idly frustrated by the way that mntners<br>
> seemingly have a reversible, unwritten standard of 'MNT-[random]' or<br>
> '[random]-MNT'. I can't be the only one.<br>
<br>
It is possible to change this, but it'll take some time: extensive research to figure out a path which causes the least disruption to the fewest amount of people. Ideally only a handful of people have to change their "mntner:" primary key.<br>
<br>
I think a mandatory "-MNT" or "MNT-" or "-MAINT" is helpful because the maintainers primary key string does pop up from time to time without any context, and this can lead to confusion. See
<a href="https://seclists.org/nanog/2020/Jan/650" rel="noreferrer" target="_blank">
https://seclists.org/nanog/2020/Jan/650</a> for a fun story about how one person's email error code is another person's BGP autonomous system reference. :-)<br>
<br>
It starts with a volunteer who does some digging in the data to see if a migration path can be constructed or not. A conclusion may be that it is too hard, but we don't know yet. Are you up for it? :)<br>
<br>
Kind regards,<br>
<br>
Job<br>
<br>
</blockquote>
</div>
</div>
</body>
</html>