LinOSX TechnoMash

Being involved in Startup Saturday Delhi, I have come across a lot of entrepreneurs building Internet applications. Most of them being India centric. The problem, which has been discussed and reported numerous times is that broadband penetration is a miniscule 3% of the whole population. There are roughly 3 million broadband subscribers in India.

Airtel 8Mbps with 4GB Cap

India being a highly price conscious country, I find it amazing that telcos like Airtel are busy hiking the price of metered “broadband” while degrading service levels. The latest move by Airtel has been to increase the price of their “unlimited” 512k connection to Rs. 1,599 (USD 34) per month. The real kicker is that the speed degraded to 256k after you’ve hit downloads totaling 100GB.

Airtel 512k with 100GB Cap

At the same time, they are introducing 16Mbps connections for Rs. 2,999 (USD 64) per month that have download caps of 20GB. A single Linux distro download is 4GB. A point upgrade to OS X is generally around 500MB. Buying and downloading a few shows from iTunes or watching a few videos on YouTube and I’ll blow right thru my 20GB limit in a week. If I download roughly 40GB of data in a given month, my Internet access will cost me upwards of Rs. 12,000 (USD 255) per month.

Airtel 16Mbps with 20GB cap

If indian telcos like Airtel were to offer unlimited 1Mbps connections at Rs. 999 (USD 21) and unlimited 2Mbps at Rs. 1,599 (USD 34), the willingness of Indians to spend on Internet access would be much more palatable. Other than those whose careers in some way, shape, or form are connected to the Internet, very few people are willing to spend more than Rs. 999 per month on Internet access. Those that spend Rs. 999 or less per month, get an experience that basically sucks. They are frustrated and completely turned off by the fact that it takes 20 minutes to load a 3 minute video on YouTube.

India will never be a country of mass Internet adoption while the government agencies like TRAI and DoT don’t adopt a definition of broadband that is more inline with shifts in Internet usage. Indian telcos continue to provide subpar speeds at exorbitant prices when compares to the rest of the world. India, touting itself, as the technology center of the 21st Century, must adopt an infrastructure and a coherent policy around broadband deployment and usage. Only with the government mandating the need for widespread Internet adoption, at feasible price points, will there be widespread broadband adoption by non-techies.

However, relying on the government to be so forward thinking is a pipe-dream. What the Indian telcos should do is adopt a model that was instrumental in driving mobile usage in India. Drop the price points so that even the average person (living on Rs. 100 per day), would find Internet usage compelling, useful, and not frustrating. If they were to adopt a mass usage policy and not price their broadband products based on margins, I believe that in 5 years, India could have at least 100 million broadband users (via DSL, cable modem, Mobile 3G, wiMax, etc.) Is it too much to ask the Indian telcos like Airtel, MTNL, BSNL, Tata Communications, Reliance, etc. to push the envelope of adoption? Unfortunately, I think it might be.

Startup Saturday Delhi is just around the corner. We’re holding our next event on the 14th of March at the American Center from 2pm to 6pm. The goal of Startup Saturday is to give startups a place where they can showcase their products and their businesses. Our goal is to also allow entrepreneurs and those considering a life as entrepreneurs to share information, learn from each other, and be a part of building the entrepreneurial ecosystem in India.

If you’re a startup or know of any Indian startups that would like to publicize their products/services, please fill out the Demo Nomination form so we can get you on the Startup Saturday Delhi agenda.

Looking forward to seeing you at Startup Saturday Delhi!

This is a little tip on how to get Perl(32bit) working with a 64bit version of MySQL on OS X Leopard.

I was working on a small project today that required MySQL 5.067 and I opted to do it in Perl 5.10. You may remember a post that I put up in August describing how to compile MySQL 64 bit for OS X Leopard. Well, since then I also compiled and installed Perl 5.10 (not replacing Apple’s system install of Perl). I wanted to take advantage of some of the Perl 6 features that have been backported to Perl 5.10 (the first Perl release in two years).

Back to today’s project, I decided to use the awesome Class::DBI Perl module to do my little project. I wrote all my code and began to run it in the perl debugger and realized that I need to install the DBD::mysql module. During the installation process for DBD::mysql, the Perl module is compiled using the mysql libraries and header files. Compilation wasn’t a problem. It’s when we got to the ‘make test’ step that all hell broke loose.

To cut a very long story short, I kept getting the error below:


# Failed test 'use DBD::mysql;'
# at t/00base.t line 21.
# Tried to use 'DBD::mysql'.
# Error: Can't find 'boot_DBD__mysql' symbol in /Users/pankaj/.cpanplus/5.10.0/build/DBD-mysql-4.010/blib/arch/auto/DBD/mysql/mysql.bundle


I dug around a bit and decided to run the installation manually. The problem here has to do with compiler flags that were used for mysql. MySQL was compiled as a 64 bit Leopard binary. However, Perl 5.10 was compiled as a 32bit binary because many Perl modules don’t support 64 bit out of the box.

To solve the problem, I had to recompile the mysql client libraries:


--($:~/src/mysql-5.0.67)-- export ARCHFLAGS="-arch i386"
--($:~/src/mysql-5.0.67)-- CC=gcc CFLAGS="-O3 -fno-omit-frame-pointer" CXX=gcc CXXFLAGS="-O3 -fno-omit-frame-pointer -felide-constructors \
-fno-exceptions -fno-rtti" ./configure --prefix=/usr/local/mysql.32 --without-server --with-extra-charsets=complex --enable-thread-safe-client --enable-local-infile --enable-shared
--($:~/src/mysql-5.0.67)-- make
--($:~/src/mysql-5.0.67)-- make test
--($:~/src/mysql-5.0.67)-- sudo make install


Once the mysql client libs were done compiling and installed into /usr/local/mysql.32, I changed my PATH to ensure that the newly compiled mysql libraries and binaries were picked up before anything else.


export PATH=/usr/local/mysql.32/bin:${PATH}


Once that was done, I went back to my DBD::mysql source directory and built it using the following commands:


--($:~/src/DBD-mysql-4.010)-- perl Makefile.PL --libs="-L/usr/local/mysql.32/lib/mysql -lmysqlclient -lz -lm" --cflags="-I/usr/local/mysql.32/include/mysql"
--($:~/src/DBD-mysql-4.010)-- make
--($:~/src/DBD-mysql-4.010)-- make test
--($:~/src/DBD-mysql-4.010)-- sudo make install


This time, make test ran beautifully with a few minor exceptions because I didn’t actually give it a mysql db to connect to.

The mysql 32bit client can easily connect to the 64 bit server. Perl, Class:DBI are now very happy and the application is running as planned.

Here are a few recent posts on Teknatus.

• Saul Klein’s European Venture Scene and surprises about New Delhi
• A To-Do List for Startups
• Hiring and Firing at a Startup
• Perl for Beginners from BarCamp Delhi
• The Financial Crisis and India a presentation I gave at BarCamp Delhi

OSSCamp is gearing up for another meet on September 27th and 28th in Delhi. The volunteers have just spent a great deal of time and energy rebuilding the OSSCamp.in site and it looks great. Take a look at the site, sign up, think of a way to participate and join us on the 27th and 28th for some great talks on Open Source technologies and meet some really cool geeks

I’ve recently gotten back into some development and needed to run MySQL on my Leopard computers. The easy way out was downloading and running MAMP (a great pre-built package of Apache and MySQL). Unfortunately, I hated starting the Apache and MySQL daemons manually.

I created OS X launchctl scripts to start Apache and MySQL but I hated the fact that I was maintaining two installations of Apache (the one that comes with OS X and the MAMP one). I wanted one simple installation of everything that would start automatically. Also, occasionally, weird things would happen with permissions and I’d have to shut everything down and restart again.

It’s been some time since I compiled my own software so I was looking forward to compiling MySQL from scratch. The first thing I found was this great post on Hivelogic about compiling MySQL. I’m not going to regurgitate what’s in the post but I’m going to highlight the configure flags for Leopard. Most times, when compiling applications, getting all the flags right is the only way to ensure your specific OS and architecture are properly supported in the compilation process and it’s the only way to squeeze out the best performance.


CC=gcc CFLAGS="-O3 -fno-omit-frame-pointer" CXX=gcc \
CXXFLAGS="-O3 -fno-omit-frame-pointer -felide-constructors \
-fno-exceptions -fno-rtti" \
./configure --prefix=/usr/local/mysql \
--with-extra-charsets=complex --enable-thread-safe-client \
--enable-local-infile --enable-shared


Make sure you change your root (data base administrator password) by running:

/usr/local/mysql/bin/mysqladmin -u root password 'new-password'
/usr/local/mysql/bin/mysqladmin -u root -h localhost password 'new-password'

Don’t forget to secure your server as indicated on HiveLogic.

My plist file for automatically launching MySQL under MAMP is here. Feel free to compare it to the post at HiveLogic or change it to suit your needs. If you have any suggestions on how to improve it, please let me know.

It’s great to finally hear that MSFT is beginning to see the light and getting involved in open source projects like Apache.  I just hope the right hand knows what the left hand is doing and this continues.

Read more about MSFT donatine cash to the Apache Foundation and pledging to open up some of their communications software and protocols. 

BBC NEWS | Technology | Microsoft backs open source work

Here are some screenshots of apps I have downloaded from the Apple App store. All the apps are running on a 1st generation 8gb iPhone that was recently upgraded to the 2.0 firmware. My carrier is Airtel in New Delhi and this post is being made with the Wordpress app for the iPhone.

This is my first post using the new Wordpress App from the iTunes App Store. Pretty good so far and really easy to use.

So far the Indian government looks like it will stay in power. What does that mean for the Indo-US nuclear pact? It looks good. What does it mean for the Indian economy? More of the same once the initial euphoria of the government not falling wears off.

A great post from Nik Cubrilovic on those of us forgetting about our FOSS ideals by falling victim to the consumerist attitudes that the shiniest, sexiest gadgets in the playground evoke.

TechCrunchIT » Blog Archive » The New Apple Walled Garden