March 2013 - skunkworks - Skunkworks Site

Senator introducing bill to legalize phone unlocking
by Leonard Kore 06 Mar '13

06 Mar '13

Some good news http://www.slashgear.com/senator-introducing-bill-to-legalize-phone-unlocki… -- Leonard Kore

1 0

140 million rand (1.4 billion KES/ ~= 20 million USD) website
by Laban Mwangi 06 Mar '13

06 Mar '13

Hi, It seems that SA is also getting a severe affliction of corruption. A wordpress based website was conjured that cost the government 140 million rand. http://mygaming.co.za/forum/showthread.php/29899-SA-government-blows-R140-m… Here it is in all it's glory: http://themeforest.net/item/london-live-3-in-1-news-magazine-and-blog/154462 http://www.freestateonline.fs.gov.za/ Regards, Laban

1 0

Re: [Skunkworks] [ISOC_KE] Kenyas Elections; Where Has The Technology Hype (and Internet) Gone To
by Barrack Otieno 06 Mar '13

06 Mar '13

Hi Wangari, Technology is not an end in itself but a means to an end, what matters is deployment. For a long time Gartner has always indicated that approximately 70 % of all major ICT projects fail, there are many factors related to the ecosystem within which the system operates that can ensure the success of any technological intervention. It takes people+processes+technology to achieve results, if this there key players are not in synch then you end up with a problem. We are all aware of the challenges IEBC went through while trying to acquire the technology, given the short span of time i did not expect a miracle out of the KITS. Globally only India and Brazil have done well in using electronic voting (i stand to be corrected), nonetheless, there are great lessons to be learn from this election. Finally congratulations to all who voted, let us maintain peace and respect the rule of the law, love your neighbour as you love yourself. Best Regards On Tue, Mar 5, 2013 at 1:14 PM, WANGARI KABIRU <wangarikabiru(a)yahoo.co.uk>wrote: > Baraka na amani tele nchini msimu huu na siku zijazo! > > On a light note; Baby born at the voting queue has been named Ballot-eli > > We have made great strides as a Nation during this National Elections. > Neighbors went out in droves. > > Perhaps our ICT savvy colleagues may enlighten us on why the Technology > invested in seems not to be up to the game; a good number of the voter > identification kits were not working or used (I did not run my finger on > any), some names were not traced in the computer etc. > > It just doesnt work for the citizenry when told that 'mtambo haufanyi > kazi", and the manual register is used just as in the past elections. A lot > of hype had gone into the need and role of the advanced Technology this > time round. > > There is a lot of hype on Technology being the turnaround for the Country > as an industry and also in other sectors. > > I do expect that in subsequent elections, the investment (financial, > human, time) in Technology will even be higher and this is a good point to > check how to up the game. > > Have a pleasant day. > > Regards/Wangari > > --- > Pray God Bless. 2013Wangari circa - "Being of the Light, We are Restored > Through Faith in Mind, Body and Spirit; We Manifest The Kingdom of God on > Earth". > > > --- On *Sat, 2/3/13, Daniel Otieno Omondi <dottocomp(a)yahoo.com>* wrote: > > > From: Daniel Otieno Omondi <dottocomp(a)yahoo.com> > Subject: [ISOC_KE] Fw: Sustained Global Broadband Demand but Africa Still > Lags Behind > To: "isoc(a)lists.my.co.ke" <isoc(a)lists.my.co.ke>, "KICTAnet ICT Policy > Discussions" <kictanet(a)lists.kictanet.or.ke>, "skunkworks(a)lists.my.co.ke" > <skunkworks(a)lists.my.co.ke> > Date: Saturday, 2 March, 2013, 12:14 > > > > > ----- Forwarded Message ----- > *From:* ICT Africa <info(a)ictafrica.info> > *To:* isoc(a)lists.my.co.ke > *Sent:* Friday, March 1, 2013 5:35 AM > *Subject:* [ISOC_KE] Sustained Global Broadband Demand but Africa Still > Lags Behind > > [image: ICT Africa]<http://r20.rs6.net/tn.jsp?e=001guENyk32nR4Enc70IJ3Pgh6IUSAsypacQTKXHFtNt-MD…> > > *February 28, 2013* > > *Sustained Global Broadband Demand but Africa Still Lags Behind* > On February 27, 2013, the International Telecommunication Union (ITU) > released figures that show a strong increase in demand for global broadband > services. Growth in demand is attributed to falling Internet access prices. > But despite all the gains that Africa has experienced, especially through > the growth of mobile broadband access, the figures indicate that the > digital divide between Africa and the rest of the world continues unabated. Read > more...<http://r20.rs6.net/tn.jsp?e=001guENyk32nR63YsxqWeTrxwsSPNlaS4sDupwqICshrLD-…> > > *Electronic Voting Systems in Africa* > In a previous article, we discussed how ICT can be effectively used in > elections in Africa. Our article focused primarily on Zimbabwe where > election disputes have been a major issue. We also pointed out that a > number of African countries had implemented some form of emerging > technologies in their election process - including biometric voter > registration. Read more...<http://r20.rs6.net/tn.jsp?e=001guENyk32nR4JGUQUIjmohgwAjzS2rsuZNb2VhuDvAHCO…> > > *ICT in Africa on Internet Radio* > The ICT buzz in Africa - the mobile boom, deployment of submarine cables, > widespread deployment of terrestrial fibre optic networks and new > innovations such as mobile money - has caught the attention of many people, > including an Internet radio DJ. Read more...<http://r20.rs6.net/tn.jsp?e=001guENyk32nR797GgyRjL7RN2pmB6nkHFtGhsh2Cm8AnL6…> > > *Cable theft and vandalism to telecom property - Africans are shooting > themselves in the feet.* > You ask most Africans about the shambolic state of their economies, and > the response is always quick - it is the government's fault. While > governments ultimately bear the responsibility for the performance of their > economies, some of the members of the African public have done a lot to > destroy their economies. The theft of cable and destruction of > telecommunication equipment is one area where some members of the African > public are helping to bring their economies down. Read more...<http://r20.rs6.net/tn.jsp?e=001guENyk32nR5Z6ZSXrFxUwsD-t3ma104P1-WWvre4-9b6…> > > Featured Jobs > > Senior Manager Campaign Management at Telkom SA Limited<http://r20.rs6.net/tn.jsp?e=001guENyk32nR6tBj2lmykLm3WT5ux3jcQMDbnQRFOYH-ON…> > > Site Support & Colocation Officer<http://r20.rs6.net/tn.jsp?e=001guENyk32nR5wQIZh3SKes2kcMwbmowhvedMSdhyRi_22…> > > Information Technology Officer<http://r20.rs6.net/tn.jsp?e=001guENyk32nR4bEyHdG_jK4Iu2ZQRrnFXzSSD-kf58O3S2…> > > Software Developer<http://r20.rs6.net/tn.jsp?e=001guENyk32nR4V4MLbBaqhQgjsO12DuqFSD3aj-r2Va82z…> > > *Don't miss any important ICT information or events in Africa* > > Register<http://r20.rs6.net/tn.jsp?e=001guENyk32nR44imVkNwC06f34kl_fPJIVN3LYGL9LNYZV…>for our weekly newsletter for updates > *Stay Connected* > Forward this email<http://ui.constantcontact.com/sa/fwtf.jsp?llr=sp8euwbab&m=1101344697842&ea=…> > > <http://visitor.constantcontact.com/do?p=un&mse=001_D6q8SmIH1qVN0ZzV_waQ__Il…> <http://www.constantcontact.com/index.jsp?cc=PM_B2BA> > This email was sent to isoc(a)lists.my.co.ke by info(a)ictafrica.info<http://mc/compose?to=info@ictafrica.info> | > > Update Profile/Email Address<http://visitor.constantcontact.com/do?p=oo&mse=001_D6q8SmIH1qVN0ZzV_waQ__Il…> > | Instant removal with SafeUnsubscribe<http://visitor.constantcontact.com/do?p=un&mse=001_D6q8SmIH1qVN0ZzV_waQ__Il…>™ > | Privacy Policy<http://ui.constantcontact.com/roving/CCPrivacyPolicy.jsp> > . > ICT Africa | 1073 Sing Sing Road | Horseheads | NY | NY | 14845 > > _______________________________________________ > isoc mailing list > isoc(a)lists.my.co.ke <http://mc/compose?to=isoc@lists.my.co.ke> > http://lists.my.co.ke/cgi-bin/mailman/listinfo/isoc > > > > -----Inline Attachment Follows----- > > _______________________________________________ > isoc mailing list > isoc(a)lists.my.co.ke <http://mc/compose?to=isoc@lists.my.co.ke> > http://lists.my.co.ke/cgi-bin/mailman/listinfo/isoc > > > _______________________________________________ > isoc mailing list > isoc(a)lists.my.co.ke > http://lists.my.co.ke/cgi-bin/mailman/listinfo/isoc > > -- Barrack O. Otieno +254721325277 +254-20-2498789 Skype: barrack.otieno http://www.otienobarrack.me.ke/

1 0

Re: [Skunkworks] IEBC Systems
by joe mwirigi 06 Mar '13

06 Mar '13

Kudos to those who could use a desktop to blissfully implement such a system! Whereby 'desktop' I guess its a small form factor 2.4 Ghz/2Gb/40 Gb evo something! My guess is design is critical though, I have been a magician on a number of implementations following bad design where the contract suddenly dissapears And slowly and painfully learn that sometimes you need not just a coder but sorts of an architect. >From the field, I gathered that POs tried to login the whole night without success.(those mysql has gone away moments :)). And yes we need to speculate! U expect the IEBC to give alog of errors? In fact all you need to tell your client is stuff like its a connection issue and they will go to the press with that. Well lets wait, *_______________________________________________________________ We must Keep on, * On Wed, Mar 6, 2013 at 1:27 PM, Steve Obbayi <steve(a)sobbayi.com> wrote: > And what's wrong with using Windows as a mission critical system? Because > from where I stand you probably need a mentor to guide you > > > ------------------------------ > > *From: *"Alex Nyalita" <nyalita(a)gmail.com> > > *To: *"Skunkworks Mailing List" <skunkworks(a)lists.my.co.ke> > *Sent: *Miércoles, 6 de Marzo 2013 9:46:59 > > *Subject: *Re: [Skunkworks] IEBC Systems > > Wait... a Windows platform for a mission critical system? SMDH!!! > > ---- > > Kind Regards, > > Alex Nyalita > > > > On Wed, Mar 6, 2013 at 12:23 PM, Patrick Kariuki < > patrick.kariuki(a)gmail.com> wrote: > >> Where the experiential learning cycle comes in, when you've got all the >> time in the world; >> 1. What happened to the system? (we have little or no idea) >> 2. What was experienced by the end user? (some error message) >> 3. Why did this happen? (come up with all kinds of possible assumptions >> on what happened - based on similar error messages you've had with >> different production systems) >> 4. What is to be done to avoid future occurrences?(give free advise, we >> know they're reading this - wait, isn't someone getting paid to do all >> these??) >> >> On Wed, Mar 6, 2013 at 12:00 PM, Bernard Mwagiru <bmwagiru(a)gmail.com>wrote: >> >>> What I've noticed I'm my short experience is decimation of lessons >>> learnt. Between us we have years of technical hands-on, >>> get-your-hands-dirty experience. >>> What we should discuss in this thread, IMHO, is potential design flaws. >>> Without quoting any press on who said what or where. Whiteafrican has a >>> high level call flow on the various interconnecting elements. >>> We can use that for starters. >>> >>> http://iebctechkenya.tumblr.com/ >>> >>> ./bernard >>> On Mar 6, 2013 10:18 AM, "Tech List Kenya" <techlistkenya(a)gmail.com> >>> wrote: >>> >>> It's our professional duty and responsibility to question this. In as >>> much as IEBC needs time to sort themselves, and inasmuch as we acknowledge >>> that things go wrong, we cannot just sweep it under the carpet and shrug it >>> off. Sorry to say, that's just plain irresponsible. >>> >>> Most of you know how much clients ride you to deliver, even clients who >>> don't pay. Especially these ones. Now imagine a client paying 9b! I am >>> always amused at how much slack we want to cut guys who undercut us. >>> >>> Anyway, back to issue at hand. >>> >>> @Mwagiru, can you lead a virtual team to conceptualize a proper voting >>> >>> @Hans, the doc you posted shows the RFP as of Dec. With screenshots from >>> both mobile and desktop apps. This means the system had already been >>> developed. So what is the point of failure? If we say the failure is not in >>> transmission but rather in processing, does that mean the data is already >>> at IEBC servers? >>> What would be the technological reason for the system to stop processing >>> (this is a very ambiguous term). Data visualization is being done by google >>> from IEBC servers. >>> >>> So what exactly is failing? >>> >>> >>> >>> >>> >>> >>> On Wed, Mar 6, 2013 at 9:55 AM, Shadrack Mwaniki < >>> shadrack_mwaniki(a)yahoo.com> wrote: >>> >>>> Dear Skunks, >>>> Pole for the delay in results. >>>> These are the kind of things that make people suspicious and not trust >>>> local ICT professionals. >>>> The public has no idea if th system is foreign or local. All they know >>>> is that 9b of their money was spent >>>> on the systems. >>>> The transactions being managed by IEBC are so small that they can be >>>> managed by a powerful desk top on any >>>> relational database. doin't even talk of concurrent submission of >>>> results because all that is need is a good queue >>>> management algorith. >>>> A separate desktop would handle the incoming traffic from polling >>>> stations >>>> As have always said, the problem is instead of providing a solution, >>>> systems are provided instead. >>>> >>>> Regards >>>> shad >>>> >>>> >>>> ------------------------------ >>>> *From:* Njoroge Tito <titonjoroge(a)gmail.com> >>>> >>>> *To:* Skunkworks Mailing List <skunkworks(a)lists.my.co.ke> >>>> *Sent:* Wednesday, March 6, 2013 9:41 AM >>>> >>>> *Subject:* Re: [Skunkworks] IEBC Systems >>>> >>>> Put in perspectives: >>>> >>>> The data set: >>>> about 33,000 polling stations. >>>> 6 positions being contested for. >>>> Presidential race had 8 candidates. >>>> >>>> Just for presidential race, thats about 270,000 unique results to be >>>> populated in a database. 270,000 in 2 days and we have had significant >>>> failure. >>>> >>>> Even if you multiply that number by 6 for other positions, assuming an >>>> average of 8 contestants per seat, that number comes to less than 2m >>>> entries in a database. >>>> >>>> Equity bank has more than 5m customers. Safaricom has 15m subscribers >>>> on mpesa. >>>> >>>> Even when you think about it in terms of transactions, the number of >>>> transactions goes down significantly. >>>> >>>> This is a real shame for IEBC. >>>> >>>> >>>> >>>> >>>> >>>> >>>> On 6 March 2013 09:09, Erik Hersman <erik(a)zungu.com> wrote: >>>> >>>> http://iebctechkenya.tumblr.com/ >>>> >>>> Erik Hersman >>>> >>>> www.ushahidi.com | www.iHub..co.ke <http://www.ihub.co.ke/> >>>> www.whiteafrican.com <http://www.afrigadget.com/> | @whiteafrican<http://twitter.com/whiteafrican> >>>> >>>> On Mar 6, 2013, at 8:59 AM, Patrick Kariuki <patrick.kariuki(a)gmail.com> >>>> wrote: >>>> >>>> Who said scaling MYSQL is necessary when the cheque and traffic comes >>>> once every 4 years? >>>> >>>> >>>> On 3/6/13, joe mwirigi <joemwirigi(a)gmail.com> wrote: >>>> >>>> Lets just say its a KES 9B lesson to the government that hires 'foreign >>>> companies' because they are 'big' >>>> >>>> I hear, the 'weed' tells me one had to login to the same >>>> server(database) >>>> to send the results. Am not sure they did run tests >>>> with 30,000 concurrent users so the db kept giving way, halafu mnajua >>>> zile >>>> logs za mysql on error. They filled the >>>> disk like crazy! -- just speculating -- I in no way know these guys! >>>> Then I >>>> can imagine the conversation >>>> >>>> Boss: vhat is happening Signh (shaking his head) >>>> Signh: donno databes only 10 MEg. Just chekin. >>>> Boss: Vy data not coming in u nno. >>>> Signh: dh -f >>>> >>>> $ unknown command >>>> $ df -h >>>> >>>> Filesystem Size Used Avail Use% Mounted on >>>> >>>> /dev/sdb1 2000G 1999.2G 0.6G 99% / >>>> varrun 393M 144k 393M 1% /var/run >>>> varlock 393M 0 393M 0% /var/lock >>>> procbususb 393M 123k 393M 1% /proc/bus/usb >>>> udev 393M 123k 393M 1% /dev >>>> >>>> Signh: They send too much, too much data, see >>>> Boss: Yeah, too much sending 2Tb full already, patel, vhere is that >>>> 4 >>>> Tb disk! just plug it and ve ar in business! >>>> Signh: >$sudo /etc/init.d/mysql restart >>>> >>>> $password: ** >>>> $ wrong password try again:*** >>>> $ ERROR 2002 (HY000): Can't connect to local MySQL server >>>> >>>> through socket '/var/lib/mysql/mysql.sock' (2) >>>> >>>> $ >>>> >>>> >>>> On a lighter note though >>>> *_______________________________________________________________ >>>> We must Keep on, >>>> * >>>> >>>> >>>> >>>> On Tue, Mar 5, 2013 at 11:05 PM, Dickson <dhikims(a)gmail.com> wrote: >>>> >>>> Still the data amount is small even for processing. What amount of data >>>> does say bank systems process on a normal working day. Its bigger than >>>> what >>>> IEBC will process. >>>> >>>> I believe we have skills that can handle that system. Let's give IEBC >>>> benefit of patience they sort themselves out. >>>> Best Regards, >>>> >>>> Dickson. >>>> >>>> ---- >>>> http://qhim.wordpress.com >>>> >>>> Sent from my BlackBerry® >>>> >>>> -----Original Message----- >>>> From: Patrick Karanja <wabethi(a)gmail.com> >>>> Sender: skunkworks-bounces(a)lists.my.co.ke >>>> Date: Tue, 5 Mar 2013 22:48:50 >>>> To: Skunkworks Mailing List<skunkworks(a)lists.my.co.ke> >>>> Reply-To: Skunkworks Mailing List <skunkworks(a)lists.my.co.ke<skunkworks@lists.my..co.ke> >>>> > >>>> Subject: Re: [Skunkworks] IEBC Systems >>>> >>>> _______________________________________________ >>>> skunkworks mailing list >>>> skunkworks(a)lists.my.co.ke >>>> ------------ >>>> List info, subscribe/unsubscribe >>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>> ------------ >>>> >>>> Skunkworks Rules >>>> http://my..co.ke/phpbb/viewtopic.php?f=24&t=94<http://my.co.ke/phpbb/viewtopic.php?f=24&t=94> >>>> >>>> ------------ >>>> Other services @ http://my.co.ke >>>> _______________________________________________ >>>> skunkworks mailing list >>>> skunkworks(a)lists.my.co.ke >>>> ------------ >>>> List info, subscribe/unsubscribe >>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>> ------------ >>>> >>>> Skunkworks Rules >>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>> ------------ >>>> Other services @ http://my.co.ke >>>> >>>> >>>> _______________________________________________ >>>> skunkworks mailing list >>>> skunkworks(a)lists.my.co.ke >>>> ------------ >>>> List info, subscribe/unsubscribe >>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks<http://orion..my.co.ke/cgi-bin/mailman/listinfo/skunkworks> >>>> ------------ >>>> >>>> Skunkworks Rules >>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>> ------------ >>>> Other services @ http://my.co.ke >>>> >>>> >>>> >>>> _______________________________________________ >>>> skunkworks mailing list >>>> skunkworks(a)lists.my.co.ke >>>> ------------ >>>> List info, subscribe/unsubscribe >>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>> ------------ >>>> >>>> Skunkworks Rules >>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>> ------------ >>>> Other services @ http://my.co.ke >>>> >>>> >>>> >>>> _______________________________________________ >>>> skunkworks mailing list >>>> skunkworks(a)lists.my.co.ke >>>> ------------ >>>> List info, subscribe/unsubscribe >>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>> ------------ >>>> >>>> Skunkworks Rules >>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>> ------------ >>>> Other services @ http://my.co.ke >>>> >>>> >>>> _______________________________________________ >>>> skunkworks mailing list >>>> skunkworks(a)lists.my.co.ke >>>> ------------ >>>> List info, subscribe/unsubscribe >>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>>> ------------ >>>> >>>> Skunkworks Rules >>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>>> ------------ >>>> Other services @ http://my.co..ke <http://my.co.ke> >>>> >>> >>> >>> _______________________________________________ >>> skunkworks mailing list >>> skunkworks(a)lists.my.co.ke >>> ------------ >>> List info, subscribe/unsubscribe >>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>> ------------ >>> >>> Skunkworks Rules >>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>> ------------ >>> Other services @ http://my.co..ke <http://my.co.ke> >>> >>> >>> _______________________________________________ >>> skunkworks mailing list >>> skunkworks(a)lists.my.co.ke >>> ------------ >>> List info, subscribe/unsubscribe >>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >>> ------------ >>> >>> Skunkworks Rules >>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >>> ------------ >>> Other services @ http://my.co..ke <http://my.co.ke> >>> >> >> >> _______________________________________________ >> skunkworks mailing list >> skunkworks(a)lists.my.co.ke >> ------------ >> List info, subscribe/unsubscribe >> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >> ------------ >> >> Skunkworks Rules >> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >> ------------ >> Other services @ http://my.co..ke <http://my.co.ke> >> > > > _______________________________________________ > skunkworks mailing list > skunkworks(a)lists.my.co.ke > ------------ > List info, subscribe/unsubscribe > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > ------------ > > Skunkworks Rules > http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > ------------ > Other services @ http://my.co.ke > > > > _______________________________________________ > skunkworks mailing list > skunkworks(a)lists.my.co.ke > ------------ > List info, subscribe/unsubscribe > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > ------------ > > Skunkworks Rules > http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > ------------ > Other services @ http://my.co.ke >

2 1

Internet Connectivity In Upper Hill 3rd Ngong Avenue
by Joseph Maina 06 Mar '13

06 Mar '13

Guys I need internet connectivity around this area for an office with 10 people. With a good speed at a good price Maina

1 0

Connectivity
by Harry Delano 06 Mar '13

06 Mar '13

Is it just me, or some undersea cable serving a cross-section of ISP's has gone under..? Again, it might be just me.. or the election mood has truly descended.. Harry

1 0

Re: [Skunkworks] IEBC Systems
by MotoBaridi 06 Mar '13

06 Mar '13

Still wonder how much disk space they had to begin with. It sure can't be a lack of funds - KES 9B will get you several shiploads of HDDs. Someone slapped in a 320GB disk and sent them a KES 2B invoice for "storage". All kidding aside, that was one big lapse in resource planning. Can't wait to hear the full story. On Wed, Mar 6, 2013 at 12:10 PM, Steve Obbayi <steve(a)sobbayi.com> wrote: > @Bernard this has nothing to do with open or closed systems but one thing > I must point out is that it seems you need to understand a little more > about how the MySQL internals work. That database error you talk about can > be caused by no disk space (Linux installs have a lightly different > message). No disk space can actually shut down MySQL hence the reason you > get the unable to connect to database. > > So IEBC's claims of running out of disk space is quite valid and depending > on how the server is setup it actually happens more often out in the real > world than you think. > > If you dont know what you are doing when setting up your database you will > be shocked to find out that merely deleting logs will not free up this > space. It is still possible to clean up this space but its a headache and > the server would have to be brought down, assuming MySQL actually owns the > space. A simpler method of optimizing is to set up the server with > innodb_file_per_table option. > > All-in-all we can just speculate for now. > > Steve > > ------------------------------ > > *From: *"Rad!" <conradakunga(a)gmail.com> > > *To: *"Skunkworks Mailing List" <skunkworks(a)lists.my.co.ke> > *Sent: *Miércoles, 6 de Marzo 2013 7:40:11 > > *Subject: *Re: [Skunkworks] IEBC Systems > > As usual - any technical debate eventually loses issues and descends to > open source vs closed source. > > It is not in order to allege the issue is the openness of the code or the > operating system in use without knowing the facts. > > On Wednesday, March 6, 2013, Bernard Owuor wrote: > >> Erik, thanks for the link. >> (And great job with the http://results.uchaguzi.co.ke/index.php/senator.) >> >> This can never be a disk space issue... the error gives it away: >> "Database Error: Unable to connect to the database:Could not connect to >> MySQL" >> >> It's a case of using Windows 2008 server - without tweaking - when a >> LAMP server would work out of the box :) >> Which points to the bigger problem of using closed source systems for >> public interest software. >> After paying KES 9B (or some happy figure) for it, and with the very >> detailed RFP in the public domain, IEBC should be able to own the software. >> They should open-source it - since it's paid for with public money. (I >> understand it is still proprietary to IFES) >> >> For such a system, the cost of implementing the solution far outweighs >> the price of the software, so IEBC will still pay a lot of money for it. >> However, we get better quality, future-proofing and some savings (in future >> elections). Biggest payoff is the trust engendered by openness. >> >> >> ------------------------------ >> *From:* Erik Hersman <erik(a)zungu.com> >> *To:* Skunkworks Mailing List <skunkworks(a)lists.my.co.ke> >> *Sent:* Wednesday, March 6, 2013 9:09 AM >> *Subject:* Re: [Skunkworks] IEBC Systems >> >> http://iebctechkenya.tumblr.com/ >> >> Erik Hersman >> >> www.ushahidi.com | www.iHub..co.ke <http://www.ihub.co.ke/> >> www.whiteafrican.com <http://www.afrigadget.com/> | @whiteafrican<http://twitter.com/whiteafrican> >> >> On Mar 6, 2013, at 8:59 AM, Patrick Kariuki <patrick.kariuki(a)gmail.com> >> wrote: >> >> Who said scaling MYSQL is necessary when the cheque and traffic comes >> once every 4 years? >> >> >> On 3/6/13, joe mwirigi <joemwirigi(a)gmail.com> wrote: >> >> Lets just say its a KES 9B lesson to the government that hires 'foreign >> companies' because they are 'big' >> >> I hear, the 'weed' tells me one had to login to the same server(database) >> to send the results. Am not sure they did run tests >> with 30,000 concurrent users so the db kept giving way, halafu mnajua zile >> logs za mysql on error. They filled the >> disk like crazy! -- just speculating -- I in no way know these guys! Then >> I >> can imagine the conversation >> >> Boss: vhat is happening Signh (shaking his head) >> Signh: donno databes only 10 MEg. Just chekin. >> Boss: Vy data not coming in u nno. >> Signh: dh -f >> >> $ unknown command >> $ df -h >> >> Filesystem Size Used Avail Use% Mounted on >> >> /dev/sdb1 2000G 1999.2G 0.6G 99% / >> varrun 393M 144k 393M 1% /var/run >> varlock 393M 0 393M 0% /var/lock >> procbususb 393M 123k 393M 1% /proc/bus/usb >> udev 393M 123k 393M 1% /dev >> >> Signh: They send too much, too much data, see >> Boss: Yeah, too much sending 2Tb full already, patel, vhere is that 4 >> Tb disk! just plug it and ve ar in business! >> Signh: >$sudo /etc/init.d/mysql restart >> >> $password: ** >> $ wrong password try again:*** >> $ ERROR 2002 (HY000): Can't connect to local MySQL server >> >> through socket '/var/lib/mysql/mysql.sock' (2) >> >> $ >> >> >> On a lighter note though >> *_______________________________________________________________ >> We must Keep on, >> * >> >> >> >> On Tue, Mar 5, 2013 at 11:05 PM, Dickson <dhikims(a)gmail.com> wrote: >> >> Still the data amount is small even for processing. What amount of data >> does say bank systems process on a normal working day. Its bigger than >> what >> IEBC will process. >> >> I believe we have skills that can handle that system. Let's give IEBC >> benefit of patience they sort themselves out. >> Best Regards, >> >> Dickson. >> >> ---- >> http://qhim.wordpress.com >> >> Sent from my BlackBerry® >> >> -----Original Message----- >> From: Patrick Karanja <wabethi(a)gmail.com> >> Sender: skunkworks-bounces(a)lists.my.co.ke >> Date: Tue, 5 Mar 2013 22:48:50 >> To: Skunkworks Mailing List<skunkworks(a)lists.my.co.ke> >> Reply-To: Skunkworks Mailing List <skunkworks(a)lists.my.co.ke> >> Subject: Re: [Skunkworks] IEBC Systems >> >> _______________________________________________ >> skunkworks mailing list >> skunkworks(a)lists.my.co.ke >> ------------ >> List info, subscribe/unsubscribe >> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >> ------------ >> >> Skunkworks Rules >> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >> ------ >> >> > _______________________________________________ > skunkworks mailing list > skunkworks(a)lists.my.co.ke > ------------ > List info, subscribe/unsubscribe > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > ------------ > > Skunkworks Rules > http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > ------------ > Other services @ http://my.co.ke > > > > _______________________________________________ > skunkworks mailing list > skunkworks(a)lists.my.co.ke > ------------ > List info, subscribe/unsubscribe > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > ------------ > > Skunkworks Rules > http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > ------------ > Other services @ http://my.co.ke > -- ----------------------------------------------------------------------------------------------------- //when i say "honey", i mean the sweet, sticky stuff that bees make... -----------------------------------------------------------------------------------------------------

1 0

Re: [Skunkworks] skunkworks Digest, Vol 37, Issue 44
by Francis Njenga 06 Mar '13

06 Mar '13

@Bwana Lawi you can count me in. Great suggestion. Ps. Not trying to spam but it seems the messages are spawning new threads when I try to reply. My Sincerest apologies! In Kinda new to contribution. On Wed, Mar 6, 2013 at 11:59 AM, <skunkworks-request(a)lists.my.co.ke> wrote: > Send skunkworks mailing list submissions to > skunkworks(a)lists.my.co.ke > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > or, via email, send a message with subject or body 'help' to > skunkworks-request(a)lists.my.co.ke > > You can reach the person managing the list at > skunkworks-owner(a)lists.my.co.ke > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of skunkworks digest..." > > > Today's Topics: > > 1. Re: IEBC Systems (Bwana Lawi) > 2. Re: IEBC Systems (Bernard Owuor) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 6 Mar 2013 11:53:19 +0300 > From: Bwana Lawi <mail2lawi(a)gmail.com> > To: Skunkworks Mailing List <skunkworks(a)lists.my.co.ke> > Subject: Re: [Skunkworks] IEBC Systems > Message-ID: > <CAF_-2vr7B=_jiS1PXpx= > Zi7vLWNxav8tKZ2vR05aGNbZ-84NgA(a)mail.gmail.com> > Content-Type: text/plain; charset="iso-8859-1" > > The IEBC system for 2013 election system is done. Let's focus on system for > 2018. Shadrack, we should team up. > > If we dont get the tender in Kenya (thanks to Davis' reality check) we can > sell in Rwanda, Tz, etc. From their perspective, we will be "outsourced" > > > On Wed, Mar 6, 2013 at 11:25 AM, Erik Hersman <erik(a)zungu.com> wrote: > > > This is true, wise words from Rad: > > > > Nobody knows what the issue is ... That is the point, we do not > > have sufficient information to make any calls. It could be a database > > issue. It could be a code issue. It could be a network issue. It could be > > that SIM cards don't have airtime. It could be a process issue. It could > be > > a load issue. We don't know. > > > > > > Right now our main focus should be trying to fully understand how the > > system was supposed to work, followed by getting a real answer from the > > IEBC on what actually went wrong. The bigger issue is clear > communication > > on the problem itself, which no one is talking about. > > > > Erik Hersman > > > > www.ushahidi.com | www.iHub.co.ke <http://www.ihub.co.ke/> > > www.afrigadget.com | www.whiteafrican.com <http://www.afrigadget.com/> | > > @whiteafrican <http://twitter.com/whiteafrican> > > > > On Mar 6, 2013, at 11:21 AM, Bernard Owuor wrote: > > > > You seem to agree that the issue is "we do not know." > > And I've proposed a fix for this going forward. > > I am probably biased, so feel free to propose anything as it comes to > > mind. > > ------------------------------ > > *From:* Rad! <conradakunga(a)gmail.com> > > *To:* Skunkworks Mailing List <skunkworks(a)lists.my.co.ke> > > *Sent:* Wednesday, March 6, 2013 11:07 AM > > *Subject:* Re: [Skunkworks] IEBC Systems > > > > Nobody knows what the issue is ... That is the point, we do not > > have sufficient information to make any calls. It could be a database > > issue. It could be a code issue. It could be a network issue. It could be > > that SIM cards don't have airtime. It could be a process issue. It could > be > > a load issue. We don't know. > > > > Ergo it is premature to start throwing stones. > > > > On Wednesday, March 6, 2013, Bernard Owuor wrote: > > > > Rad, > > So what is the heart of the issue? And how would you fix it? > > Don't waste time with the technical problem - which none of us > > noise-makers have any opportunity to fix - and would be speculation at > best. > > > > Try to focus on fixing the bigger picture. We've had similar large > > failures on publicly procured systems, yet most privately built systems > eg > > mobile banking, agency banking etc cost 1/1000 times the price and carry > a > > million times the load and value. > > > > Don't get side-tracked by the windows 2008 server bashing either.... I'm > > using a windows machine to type this email :) > > > > > > ------------------------------ > > *From:* Rad! <conradakunga(a)gmail.com> > > *To:* Skunkworks Mailing List <skunkworks(a)lists.my.co.ke> > > *Sent:* Wednesday, March 6, 2013 10:40 AM > > *Subject:* Re: [Skunkworks] IEBC Systems > > > > As usual - any technical debate eventually loses issues and descends to > > open source vs closed source. > > > > It is not in order to allege the issue is the openness of the code or the > > operating system in use without knowing the facts. > > > > On Wednesday, March 6, 2013, Bernard Owuor wrote: > > > > Erik, thanks for the link. > > (And great job with the http://results.uchaguzi.co.ke/index.php/senator > .) > > > > This can never be a disk space issue... the error gives it away: > > "Database Error: Unable to connect to the database:Could not connect to > > MySQL" > > > > It's a case of using Windows 2008 server - without tweaking - when a > LAMP > > server would work out of the box :) > > Which points to the bigger problem of using closed source systems for > > public interest software. > > After paying KES 9B (or some happy figure) for it, and with the very > > detailed RFP in the public domain, IEBC should be able to own the > software. > > They should open-source it - since it's paid for with public money. (I > > understand it is still proprietary to IFES) > > > > For such a system, the cost of implementing the solution far outweighs > the > > price of the software, so IEBC will still pay a lot of money for it. > > However, we get better quality, future-proofing and some savings (in > future > > elections). Biggest payoff is the trust engendered by openness. > > > > > > ------------------------------ > > *From:* Erik Hersman <erik(a)zungu.com> > > *To:* Skunkworks Mailing List <skunkworks(a)lists.my.co.ke> > > *Sent:* Wednesday, March 6, 2013 9:09 AM > > *Subject:* Re: [Skunkworks] IEBC Systems > > > > http://iebctechkenya.tumblr.com/ > > > > Erik Hersman > > > > www.ushahidi.com | www.iHub.co.ke <http://www.ihub.co.ke/> > > www.whiteafrican.com <http://www.afrigadget.com/> | @whiteafrican< > http://twitter.com/whiteafrican> > > > > On Mar 6, 2013, at 8:59 AM, Patrick Kariuki <patrick.kariuki(a)gmail.com> > > wrote: > > > > Who said scaling MYSQL is necessary when the cheque and traffic comes > > once every 4 years? > > > > > > On 3/6/13, joe mwirigi <joemwirigi(a)gmail.com> wrote: > > > > Lets just say its a KES 9B lesson to the government that hires 'foreign > > companies' because they are 'big' > > > > I hear, the 'weed' tells me one had to login to the same server(database) > > to send the results. Am not sure they did run tests > > with 30,000 concurrent users so the db kept giving way, halafu mnajua > zile > > logs za mysql on error. They filled the > > disk like crazy! -- just speculating -- I in no way know these guys! > Then I > > can imagine the conversation > > > > Boss: vhat is happening Signh (shaking his head) > > Signh: donno databes only 10 MEg. Just chekin. > > Boss: Vy data not coming in u nno. > > Signh: dh -f > > > > $ unknown command > > $ df -h > > > > Filesystem Size Used Avail Use% Mounted on > > > > /dev/sdb1 2000G 1999.2G 0.6G 99% / > > varrun 393M 144k 393M 1% /var/run > > varlock 393M 0 393M 0% /var/lock > > procbususb 393M 123k 393M 1% /proc/bus/usb > > udev 393M 123k 393M 1% /dev > > > > Signh: They send too much, too much data, see > > Boss: Yeah, too much sending 2Tb full already, patel, vhere is that 4 > > Tb disk! just plug it and ve ar in business! > > Signh: >$sudo /etc/init.d/mysql restart > > > > $password: ** > > $ wrong password try again:*** > > $ ERROR 2002 (HY000): Can't connect to local MySQL server > > > > through socket '/var/lib/mysql/mysql.sock' (2) > > > > $ > > > > > > On a lighter note though > > *__ > > > > ------------ > > Other services @ http://my.co.ke > > > > > > _______________________________________________ > > skunkworks mailing list > > skunkworks(a)lists.my.co.ke > > ------------ > > List info, subscribe/unsubscribe > > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > > ------------ > > > > Skunkworks Rules > > http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > > ------------ > > Other services @ http://my.co.ke > > > > _______________________________________________ > > skunkworks mailing list > > skunkworks(a)lists.my.co.ke > > ------------ > > List info, subscribe/unsubscribe > > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > > ------------ > > > > Skunkworks Rules > > http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > > ------------ > > Other services @ http://my.co.ke > > > > > > > > _______________________________________________ > > skunkworks mailing list > > skunkworks(a)lists.my.co.ke > > ------------ > > List info, subscribe/unsubscribe > > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > > ------------ > > > > Skunkworks Rules > > http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > > ------------ > > Other services @ http://my.co.ke > > >

1 0

Sample oracle 11g Schema
by Calvin Omari 06 Mar '13

06 Mar '13

Hi Techies, as you await the iebc announcement i have an issue with my oracle 11g release 2 database, I did my installation fine but did not check 'install sample schema' anyboy with an idea on how i can do the same including scripts to run to create the schemas thanks and peaceful moments -- ./Cal “ *Copy and paste is a design error.* ” - David Parnas System Software Developer/Analyst @calvinebarongo

2 1

Re: [Skunkworks] IEBC Systems
by Francis Njenga 06 Mar '13

06 Mar '13

> Nobody knows what the issue is ... That is the point, we do not > have sufficient information to make any calls. It could be a database > issue. It could be a code issue. It could be a network issue. It could be > that SIM cards don't have airtime. It could be a process issue. It could be > a load issue. We don't know. > > Ergo it is premature to start throwing stones. > > On Wednesday, March 6, 2013, Bernard Owuor wrote: > > That is precisely the biggest problem!!! :) -- Kore Francis Njenga Running and Walking are only breaths apart.

2 1