<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>
</p>
<p><font face="Times New Roman, Times, serif"><span
style="mso-ansi-language:EN-US" lang="EN-US">Dear dbwg,</span></font></p>
<p><font face="Times New Roman, Times, serif"><span
style="mso-ansi-language:EN-US" lang="EN-US"></span></font></p>
<p><font face="Times New Roman, Times, serif"><span
style="mso-ansi-language:EN-US" lang="EN-US"></span></font></p>
<font face="Times New Roman, Times, serif">
</font>
<p><font face="Times New Roman, Times, serif"><br>
<span style="mso-ansi-language:EN-US" lang="EN-US">Referring
to the previous email from my colleague Simon. </span></font></p>
<font face="Times New Roman, Times, serif"></font>
<p><font face="Times New Roman, Times, serif"><span
style="mso-ansi-language:EN-US" lang="EN-US">We indeed
delayed the deletion of the lame records for multiple reason
among them the
absence of a second nodes. We had some security challenges
that needed to be
addressed before being able to plan the second nodes.</span></font></p>
<font face="Times New Roman, Times, serif"></font>
<p><font face="Times New Roman, Times, serif"><span
style="mso-ansi-language:EN-US" lang="EN-US">We do
apologize for the delay on the second node implementation and
rest tune as deployment
will be scheduled very soon. And usual, announced on the usual
channels.</span></font></p>
<font face="Times New Roman, Times, serif"></font>
<p><font face="Times New Roman, Times, serif"><span
style="mso-ansi-language:EN-US" lang="EN-US">Thanks and
regards,</span></font></p>
<p class="MsoNormal"><span style="mso-ansi-language:EN-US"
lang="EN-US"><br>
</span></p>
<p>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:-536870145 1107305727 0 0 415 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-536859905 -1073732485 9 0 511 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0cm;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;
mso-fareast-language:EN-US;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;
mso-fareast-language:EN-US;}size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;
mso-header-margin:36.0pt;
mso-footer-margin:36.0pt;
mso-paper-source:0;}
div.WordSection1
{page:WordSection1;}</style></p>
<pre class="moz-signature" cols="72">--
_______________________________________________________________
Cedrick Adrien Mbeyet
IT Infrastructure Unit Manager, AFRINIC Ltd.
t: +230 403 5100 / 403 5115 | f: +230 466 6758 | tt: @afrinic | w: <a class="moz-txt-link-abbreviated" href="http://www.afrinic.net">www.afrinic.net</a>
facebook.com/afrinic | flickr.com/afrinic | youtube.com/afrinicmedia
______________________________________________________</pre>
<div class="moz-cite-prefix">On 07/09/2020 16:59, Simon Seruyinda
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:281B7F0D-6BDA-440A-94D4-C6E0B271B907@afrinic.net">
<pre class="moz-quote-pre" wrap="">Hi Frank,
The e-mail attribute was made mandatory in July 2012.
I have done a quick check in the database and we have 1048 person objects without the email attribute.
Most of these objects belong to legacy resource holders and were imported into the database during the initial setup.
Many are referenced in different objects. Below are some stats regarding number of objects that are referencing these person objects as admin-c,tech-c or zone-c.
zone-c:
===============
51 domain objects
tech-c
===============
as-block 248
as-set 11
domain 35
inetnum 574
mntner 60
org 162
role 7
route-set 6
admin-c:
==============
as-block 248
as-set 11
aut-num 2
domain 49
inet6num 1
inetnum 731
mntner 71
org 137
role 4
route-set 6
There is an ongoing project internally focused on contacting these legacy holders in order to update their contact details in the database. Another activity, under the scope of the whois business rules inconsistencies is also planned to get the emails updated for any resource members who may be having no emails in the any of their person objects. Incases where efforts to get in touch with the resource holder proves futile, a temporary measure using AFRINIC’s placeholder email accounts is undertaken. These activities are expected to decrease the number significantly.
With regards to the lame delegation handling, we are not doing deletion yet since we are running only one node to do the lame delegation checks. Once the second node is setup, we shall begin the deletion otherwise for now we run the risk of a few false positives.
Regarding the rdns objects size, thanks for bringing this up for discussion. Currently we have a limit for IPv4 set to minimum of /24, but there is no limit implemented for IPv6, so it will go up to 128.
I agree this could lead to unnecessary db growth and i think a limit should be set. Input from the DBWG members on what would be the appropriate minimum would highly be appreciated.
Regards;
Simon
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">On 6 Sep 2020, at 22:22, Frank Habicht <a class="moz-txt-link-rfc2396E" href="mailto:geier@geier.ne.tz"><geier@geier.ne.tz></a> wrote:
Hi AfriNIC staff,
since when is the 'e-mail:' attribute for 'person' objects mandatory?
I just found
nic-hdl: SE1-AFRINIC
that does not have an email.
It's got a GENERATED maintainer, and I'm also wondering how these new
maintainer credentials were communicated to the "person".
Yes, I don't want to rely on 'changed:' attributes.
Staff:
How many 'person' objects don't have an 'e-mail:' attribute ?
[slowly getting to another issue....]
Why did I get to check this person object at all....?
Because in a domain object it is
tech-c: SE1-AFRINIC
zone-c: SE1-AFRINIC
Also, the domain object is since "2020-02-02 02:02"
( nice time stamp!! ;-) ) marked as all 'nserver' being *lame*.
So when is it meant to get deleted?
I hope we're not waiting for the tech-c or zone-c to respond to the
email, which we could not send, because the 'person' doesn't have an
email address?
But what really got me to check the domain object:
domain:
0.1.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.1.0.0.8.f.3.4.1.0.0.2.ip6.arpa
yes, it's a bit long. a reverse DNS delegation for a /128
This is probably "legal".
But:
a) if disputable 'usefulness', and
b) I see "tremendous' potential for growth in the DB - in a bad way
All, Staff and WG:
should creation of domain objects be limited to certain prefix sizes?
Thanks,
Frank
_______________________________________________
DBWG mailing list
<a class="moz-txt-link-abbreviated" href="mailto:DBWG@afrinic.net">DBWG@afrinic.net</a>
<a class="moz-txt-link-freetext" href="https://lists.afrinic.net/mailman/listinfo/dbwg">https://lists.afrinic.net/mailman/listinfo/dbwg</a>
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
_______________________________________________
DBWG mailing list
<a class="moz-txt-link-abbreviated" href="mailto:DBWG@afrinic.net">DBWG@afrinic.net</a>
<a class="moz-txt-link-freetext" href="https://lists.afrinic.net/mailman/listinfo/dbwg">https://lists.afrinic.net/mailman/listinfo/dbwg</a>
</pre>
</blockquote>
</body>
</html>