<div dir="auto">This is another case of wrong database design coupled by lack of form validation (assuming forms are being used obviously).<div dir="auto"><br></div><div dir="auto">The best way to handle this as Collins has highlighted remove all repeating data at least we will have correct data.</div><div dir="auto"><br></div><div dir="auto">I would really like to know who designed/developed the system and process and tests done when deploying the system. </div><div dir="auto"><br></div><div dir="auto">Its a good thing IEBC has noticed the issue at this stage rather than during the election day. This begs the question has IEBC done other tests to the like stress testing the system? </div></div><div class="gmail_extra"><br><div class="gmail_quote">On Jan 25, 2017 9:36 AM, "waudo siganga via kictanet" <<a href="mailto:kictanet@lists.kictanet.or.ke" target="_blank">kictanet@lists.kictanet.or.ke</a><wbr>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div style="font-family:Arial;font-size:medium" dir="ltr"><div>The National Registration Bureau people should actually make better use of IT - it is possible to use one's surname as one of the variables in a hash algorithm to GENERATE a unique ID number; this means the wrong number can thereafter never be accepted by the system, which uses a reverse hash algorithm to check input. The technique of hashing is used e.g. in banks to generate bank account numbers. I am suspecting that currently ID numbers are given randomly rather than generated.</div>
<div> </div>
<div>W.</div>
<div class="m_1466784160998148781defangedMessage">
<div id="m_1466784160998148781me67471">
<div> </div>
<div> </div>
<div>On Wed, Jan 25, 2017, at 08:57 AM, awatila--- via kictanet wrote:</div>
<blockquote class="m_1466784160998148781me67471QuoteMessage" type="cite">
<div class="m_1466784160998148781me67471WordSection1">
<p class="m_1466784160998148781me67471MsoNormal">Arent they supposed to validate your id number by looking at your ID while registering you?</p>
<p class="m_1466784160998148781me67471MsoNormal"><u></u> <u></u></p>
<p class="m_1466784160998148781me67471MsoNormal">The control is that all National ID numbers are unique (same control used in mpesa). Unless we want to say that there are people with different IDs that have the same national ID number</p>
<p class="m_1466784160998148781me67471MsoNormal"><u></u> <u></u></p>
<p class="m_1466784160998148781me67471MsoNormal">Regards,</p>
<p class="m_1466784160998148781me67471MsoNormal"><u></u> <u></u></p>
<p class="m_1466784160998148781me67471MsoNormal">Sent from <a href="https://go.microsoft.com/fwlink/?LinkId=550986" target="_blank">Mail</a> for Windows 10</p>
<p class="m_1466784160998148781me67471MsoNormal"><u></u> <u></u></p>
<div style="border-width:1pt medium medium;border-style:solid none none;border-color:rgb(225,225,225) currentColor currentColor;padding:3pt 0in 0in">
<p class="m_1466784160998148781me67471MsoNormal" style="padding:0in;border:currentColor"><span style="font-weight:bold">From: </span><a href="mailto:kictanet@lists.kictanet.or.ke" target="_blank">Collins Areba via kictanet</a><br>
<span style="font-weight:bold">Sent: </span>Tuesday, January 24, 2017 9:20 PM<br>
<span style="font-weight:bold">To: </span><a href="mailto:awatila@yahoo.co.uk" target="_blank">awatila@yahoo.co.uk</a><br>
<span style="font-weight:bold">Cc: </span><a href="mailto:arebacollins@gmail.com" target="_blank">Collins Areba</a><br>
<span style="font-weight:bold">Subject: </span>Re: [kictanet] IEBC registry shows 128,926 records of shared voter details - Who audits the IEBC database?</p>
</div>
<p class="m_1466784160998148781me67471MsoNormal"><u></u> <u></u></p>
<div>
<p class="m_1466784160998148781me67471MsoNormal">@Ronald </p>
<div>
<p class="m_1466784160998148781me67471MsoNormal">I suspect the offline nature of collection of data and biometric information might have resulted in multiple data points in cases of genuine ID number shared between more than one person (how that happens I have no clue) or trying to register more than once. If you ask me, What should have happened is for them to delete all repeating entries, and leave the burden of proof on the registrants. At least the database would at all times then be accurate.</p>
</div>
</div>
<div>
<p class="m_1466784160998148781me67471MsoNormal"><u></u> <u></u></p>
<div>
<p class="m_1466784160998148781me67471MsoNormal">On Tue, Jan 24, 2017 at 8:57 PM, Ronald Ojino via kictanet <<a href="mailto:kictanet@lists.kictanet.or.ke" target="_blank">kictanet@lists.kictanet.or.ke</a><wbr>> wrote:</p>
<blockquote style="border-width:medium medium medium 1pt;border-style:none none none solid;border-color:currentColor currentColor currentColor rgb(204,204,204);padding:0in 0in 0in 6pt;margin-right:0in;margin-left:4.8pt">
<div>
<p class="m_1466784160998148781me67471MsoNormal">My rather basic question is how is that database designed...it lacks data integrity (how did that happen?) ..could this be delibrate .</p>
<div>
<p class="m_1466784160998148781me67471MsoNormal">Regards,</p>
</div>
<div>
<p class="m_1466784160998148781me67471MsoNormal">Ronald Ojino</p>
</div>
</div>
<div>
<p class="m_1466784160998148781me67471MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<p class="m_1466784160998148781me67471MsoNormal">On 24-Jan-2017 8:06 PM, "John Kieti via kictanet" <<a href="mailto:kictanet@lists.kictanet.or.ke" target="_blank">kictanet@lists.kictanet.or.ke</a><wbr>> wrote:</p>
</div>
</div>
<blockquote style="border-width:medium medium medium 1pt;border-style:none none none solid;border-color:currentColor currentColor currentColor rgb(204,204,204);padding:0in 0in 0in 6pt;margin-right:0in;margin-left:4.8pt">
<div>
<div>
<div>
<p class="m_1466784160998148781me67471MsoNormal">IMHO, We need an early spotlight on the competences, capacities and integrity of people running IEBC's ICT functions. We cannot afford to have mediocrity being exhibited in the ICT profession, yet again.</p>
<div>
<p class="m_1466784160998148781me67471MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="m_1466784160998148781me67471MsoNormal"><u></u> <u></u></p>
</div>
</div>
<div>
<p class="m_1466784160998148781me67471MsoNormal"><u></u> <u></u></p>
<div>
<p class="m_1466784160998148781me67471MsoNormal">On Tue, Jan 24, 2017 at 7:03 PM, Barrack Otieno via kictanet <<a href="mailto:kictanet@lists.kictanet.or.ke" target="_blank">kictanet@lists.kictanet.or.ke</a><wbr>> wrote:</p>
<blockquote style="border-width:medium medium medium 1pt;border-style:none none none solid;border-color:currentColor currentColor currentColor rgb(204,204,204);padding:0in 0in 0in 6pt;margin-right:0in;margin-left:4.8pt">
<p class="m_1466784160998148781me67471MsoNormal">IEBC Chair Wafula Chebukati said that these cases of multiple<br>
registrations are attributed to data entry errors at the time of<br>
registration, possible use of one ID to register more than once,<br>
attempted registration of more than one person using same ID as well<br>
as shared National ID numbers. “The Commission is working closely with<br>
National Registration Bureau (NRB) to clean up all the shared IDs. In<br>
addition, a team of Registration officers and ICT operators are<br>
conducting further cleanup,” said Chebukati. He said that the<br>
provisional register will be availed to members of the public for<br>
verification once the voter enlistment exercise is over.<br>
Read more at: <a href="https://www.standardmedia.co.ke/article/2000231105/iebc-registry-shows-128-926-records-of-shared-voter-details" target="_blank">https://www.standardmedia.co.<wbr>ke/article/2000231105/iebc-<wbr>registry-shows-128-926-<wbr>records-of-shared-voter-<wbr>details</a><br>
<br>
Of particular interest is the following line : attempted registration<br>
of more than one person using same ID as well as shared National ID<br>
numbers, do we have competent people managing this important<br>
institution?<br>
<br>
Regards<br>
<br>
--<br>
Barrack O. Otieno<br>
<a href="tel:+254%20721%20325277" target="_blank">+254721325277</a><br>
<a href="tel:+254%20733%20206359" target="_blank">+254733206359</a><br>
Skype: barrack.otieno<br>
PGP ID: 0x2611D86A<br>
<br>
______________________________<wbr>_________________<br>
kictanet mailing list<br>
<a href="mailto:kictanet@lists.kictanet.or.ke" target="_blank">kictanet@lists.kictanet.or.ke</a><br>
<a href="https://lists.kictanet.or.ke/mailman/listinfo/kictanet" target="_blank">https://lists.kictanet.or.ke/<wbr>mailman/listinfo/kictanet</a><br>
Twitter: <a href="http://twitter.com/kictanet" target="_blank">http://twitter.com/kictanet</a><br>
Facebook: <a href="https://www.facebook.com/KICTANet/" target="_blank">https://www.facebook.com/<wbr>KICTANet/</a><br>
<br>
Unsubscribe or change your options at <a href="https://lists.kictanet.or.ke/mailman/options/kictanet/jkieti%40gmail.com" target="_blank">https://lists.kictanet.or.ke/<wbr>mailman/options/kictanet/<wbr>jkieti%40gmail.com</a><br>
<br>
The Kenya ICT Action Network (KICTANet) is a multi-stakeholder platform for people and institutions interested and involved in ICT policy and regulation. The network aims to act as a catalyst for reform in the ICT sector in support of the national aim of ICT enabled growth and development.<br>
<br>
KICTANetiquette : Adhere to the same standards of acceptable behaviors online that you follow in real life: respect people's times and bandwidth, share knowledge, don't flame or abuse or personalize, respect privacy, do not spam, do not market your wares or qualifications.</p>
</blockquote>
</div>
<p class="m_1466784160998148781me67471MsoNormal"><br>
</p>
<div>
<p class="m_1466784160998148781me67471MsoNormal"><u></u> <u></u></p>
</div>
<p class="m_1466784160998148781me67471MsoNormal">--</p>
<div>
<div>
<div>
<div>
<div>
<p class="m_1466784160998148781me67471MsoNormal"><br>
<span style="color:rgb(153,153,153)">John Kieti<br>
Phone: <a href="tel:+254%20735%20764242" target="_blank">+254-735-764242</a> // <a href="tel:+254%20722%20764242" target="_blank">+254-722-764242</a><br>
Twitter: @johnKieti // Skype: jkieti<br>
Blog: </span><a href="http://www.gmeltdown.com" target="_blank">gmeltdown.com</a><span style="color:rgb(51,102,102)"> // </span><span style="color:rgb(153,153,153)">LinkedIn: </span><a href="https://ke.linkedin.com/in/kieti" target="_blank"><span style="font-size:10.5pt">https://ke.linkedin.<wbr>com/in/<span style="font-weight:bold">kieti</span></span></a></p>
</div>
<div>
<div>
<p class="m_1466784160998148781me67471MsoNormal"><br>
<span style="color:rgb(153,153,153)">The ordinary just won't do</span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="m_1466784160998148781me67471MsoNormal" style="margin-bottom:12pt"><br>
______________________________<wbr>_________________<br>
kictanet mailing list<br>
<a href="mailto:kictanet@lists.kictanet.or.ke" target="_blank">kictanet@lists.kictanet.or.ke</a><br>
<a href="https://lists.kictanet.or.ke/mailman/listinfo/kictanet" target="_blank">https://lists.kictanet.or.ke/<wbr>mailman/listinfo/kictanet</a><br>
Twitter: <a href="http://twitter.com/kictanet" target="_blank">http://twitter.com/kictanet</a><br>
Facebook: <a href="https://www.facebook.com/KICTANet/" target="_blank">https://www.facebook.com/<wbr>KICTANet/</a></p>
</div>
</div>
<p class="m_1466784160998148781me67471MsoNormal">Unsubscribe or change your options at <a href="https://lists.kictanet.or.ke/mailman/options/kictanet/ronojinx%40gmail.com" target="_blank">https://lists.kictanet.or.ke/<wbr>mailman/options/kictanet/<wbr>ronojinx%40gmail.com</a><br>
<br>
The Kenya ICT Action Network (KICTANet) is a multi-stakeholder platform for people and institutions interested and involved in ICT policy and regulation. The network aims to act as a catalyst for reform in the ICT sector in support of the national aim of ICT enabled growth and development.<br>
<br>
KICTANetiquette : Adhere to the same standards of acceptable behaviors online that you follow in real life: respect people's times and bandwidth, share knowledge, don't flame or abuse or personalize, respect privacy, do not spam, do not market your wares or qualifications.</p>
</blockquote>
</div>
</div>
<p class="m_1466784160998148781me67471MsoNormal"><br>
______________________________<wbr>_________________<br>
kictanet mailing list<br>
<a href="mailto:kictanet@lists.kictanet.or.ke" target="_blank">kictanet@lists.kictanet.or.ke</a><br>
<a href="https://lists.kictanet.or.ke/mailman/listinfo/kictanet" target="_blank">https://lists.kictanet.or.ke/<wbr>mailman/listinfo/kictanet</a><br>
Twitter: <a href="http://twitter.com/kictanet" target="_blank">http://twitter.com/kictanet</a><br>
Facebook: <a href="https://www.facebook.com/KICTANet/" target="_blank">https://www.facebook.com/<wbr>KICTANet/</a><br>
<br>
Unsubscribe or change your options at <a href="https://lists.kictanet.or.ke/mailman/options/kictanet/arebacollins%40gmail.com" target="_blank">https://lists.kictanet.or.ke/<wbr>mailman/options/kictanet/<wbr>arebacollins%40gmail.com</a><br>
<br>
The Kenya ICT Action Network (KICTANet) is a multi-stakeholder platform for people and institutions interested and involved in ICT policy and regulation. The network aims to act as a catalyst for reform in the ICT sector in support of the national aim of ICT enabled growth and development.<br>
<br>
KICTANetiquette : Adhere to the same standards of acceptable behaviors online that you follow in real life: respect people's times and bandwidth, share knowledge, don't flame or abuse or personalize, respect privacy, do not spam, do not market your wares or qualifications.</p>
</blockquote>
</div>
<p class="m_1466784160998148781me67471MsoNormal"><br>
</p>
<div>
<p class="m_1466784160998148781me67471MsoNormal"><u></u> <u></u></p>
</div>
<p class="m_1466784160998148781me67471MsoNormal">--</p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="m_1466784160998148781me67471MsoNormal" style="margin-bottom:12pt">Regards,</p>
</div>
<p class="m_1466784160998148781me67471MsoNormal">Collins Areba, </p>
</div>
</div>
</div>
<div>
<p class="m_1466784160998148781me67471MsoNormal">Kilifi, Kenya.</p>
</div>
<div>
<p class="m_1466784160998148781me67471MsoNormal">Tel: +<span style="font-weight:bold"><span style="color:rgb(56,118,29)">254 707 750 788 </span></span>/ <span style="font-weight:bold"><span style="color:red">0731534124</span></span><br>
Twitter: @arebacollins.</p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="m_1466784160998148781me67471MsoNormal">Skype: arebacollins</p>
<p class="m_1466784160998148781me67471MsoNormal"><u></u> <u></u></p>
</div>
<div><u>______________________________<wbr>_________________</u></div>
<div>kictanet mailing list</div>
<div><a href="mailto:kictanet@lists.kictanet.or.ke" target="_blank">kictanet@lists.kictanet.or.ke</a></div>
<div><a href="https://lists.kictanet.or.ke/mailman/listinfo/kictanet" target="_blank">https://lists.kictanet.or.ke/<wbr>mailman/listinfo/kictanet</a></div>
<div>Twitter: <a href="http://twitter.com/kictanet" target="_blank">http://twitter.com/kictanet</a></div>
<div>Facebook: <a href="https://www.facebook.com/KICTANet/" target="_blank">https://www.facebook.com/<wbr>KICTANet/</a></div>
<div> </div>
<div>Unsubscribe or change your options at <a href="https://lists.kictanet.or.ke/mailman/options/kictanet/emailsignet%40mailcan.com" target="_blank">https://lists.kictanet.or.ke/<wbr>mailman/options/kictanet/<wbr>emailsignet%40mailcan.com</a></div>
<div> </div>
<div>The Kenya ICT Action Network (KICTANet) is a multi-stakeholder platform for people and institutions interested and involved in ICT policy and regulation. The network aims to act as a catalyst for reform in the ICT sector in support of the national aim of ICT enabled growth and development.</div>
<div> </div>
<div>KICTANetiquette : Adhere to the same standards of acceptable behaviors online that you follow in real life: respect people's times and bandwidth, share knowledge, don't flame or abuse or personalize, respect privacy, do not spam, do not market your wares or qualifications.</div>
</blockquote>
</div>
</div>
</div></div>
<br>______________________________<wbr>_________________<br>
kictanet mailing list<br>
<a href="mailto:kictanet@lists.kictanet.or.ke">kictanet@lists.kictanet.or.ke</a><br>
<a href="https://lists.kictanet.or.ke/mailman/listinfo/kictanet" rel="noreferrer" target="_blank">https://lists.kictanet.or.ke/<wbr>mailman/listinfo/kictanet</a><br>
Twitter: <a href="http://twitter.com/kictanet" rel="noreferrer" target="_blank">http://twitter.com/kictanet</a><br>
Facebook: <a href="https://www.facebook.com/KICTANet/" rel="noreferrer" target="_blank">https://www.facebook.com/<wbr>KICTANet/</a><br>
<br>
Unsubscribe or change your options at <a href="https://lists.kictanet.or.ke/mailman/options/kictanet/toilemgodwin%40gmail.com" rel="noreferrer" target="_blank">https://lists.kictanet.or.ke/<wbr>mailman/options/kictanet/<wbr>toilemgodwin%40gmail.com</a><br>
<br>
The Kenya ICT Action Network (KICTANet) is a multi-stakeholder platform for people and institutions interested and involved in ICT policy and regulation. The network aims to act as a catalyst for reform in the ICT sector in support of the national aim of ICT enabled growth and development.<br>
<br>
KICTANetiquette : Adhere to the same standards of acceptable behaviors online that you follow in real life: respect people's times and bandwidth, share knowledge, don't flame or abuse or personalize, respect privacy, do not spam, do not market your wares or qualifications.<br></blockquote></div></div>