Mysql with remote access using Amazon AMI (Without EBS)

I thought this would be easy however it took me a day and a little bit of digging around.
Here is the few simple steps to set up Mysql on Amazon (Without EBS)

* Pick a basic Fedora AMI
ami-5647a33f (http://aws.amazon.com/amis/AWS/517 , Basic Fedora Core 8)
* Start your machine, make sure you have a security group defined (let us call mysql-dev)

* ssh to the amazon box
* yum install mysql-server (install mysql)
* /etc/init.d/mysqld start (start mysql)


Steps to change password for root user (Highly Recommended)
* Login mysql -u root
* Change the root password
SET PASSWORD FOR root@localhost=PASSWORD('new_password');
SET PASSWORD FOR root@'127.0.0.1'=PASSWORD('new_password');
SET PASSWORD FOR root@'ip-*-*-*-*'=PASSWORD('new_password');
( Note here you need to set your internal ip from amazon)
* Restart mysql and test new password
* /etc/init.d/mysqld restart
* mysql -u root -p
* 'new_password'

Steps to set up remote access for root user
* To set up remote access from any host for root user
* update user set host='%' where user='root' and host='ip-*-*-*-*';
* flush priveleges;
* Enable 3306 port for the instance (I use elastic-fox for the given amazon instance)

Test the mysql remote access connection
* hostname :
* port: 3306
* user : root
* password : 'new_password'

NOTE : The hostname here is the public DNS name for your amazon box
Example:- It will be ec2-*-*-*-*.compute-1.amazonaws.

Hope this helps you in your mysql setup, let me know if you have questions/issues

Thanks
Ravi

San Francisco Parking Spots

From the open Government Initiative, Map of San Francisco Metered Parking Spots

Google Fusion Table Example

Tech Ramblings

It has been a long time since I have posted on my blog, Working as a Java Developer I get to play with and learn interesting tools/technologies and I wanted to share them with you.

This post is skewed towards version control, continuous integration and related areas. These areas interest me and I think the right choices/tools here help teams be more productive.

Here is the list

1) JSONP (JSON with Padding) : I like JSONP,the idea is to wrap the JSON response with a callback function.

Reference: JSON Wikipedia, Ajaxian,Oreily

At Citysearch we have been involved in building API's/ webservices to support Citygird.
Recently I worked with the consumer team to consume a citysearch webservice.
Support for JSONP from the webservice allowed us to get our work done in a quick and easy
manner. I do see the security concerns with JSONP, I think JSONP can also be used as a nice way for inter company web services to operate.


2) Hudson and CI : I worked on continous integration a long time ago (couple of years)
Recently I got an opportunity to set up CI for my team and we choose hudson :)
Hudson is super simple, intutive to use and easy to deploy. I like the maven2 support within hudson, the configuration for svn polling and periodic runs are also easy to use,
if you are looking for an easy to use, lightweight approach for CI I recommend hudson.

3) Svnrepo for SVN: Working at Nurall we decided to create a new SVN repository to
host the Java version of our site, we decided to use sourcerepo and their services have been
useful to help us get going on Nurall. We would need to play with this further to decide if we are going to use them for the long run, I do suggest them as an alternative to get you started quickly.

Few other technologies/tools I want to learn about, would love to hear your thoughts and feedback

GitHub and Git
Gerrit

Nurall Matching : How it Works

Hi All,
I am really excited to announce that we launched Nurall with Smart Matching.
Our Minimum Viable Product allows Mentors/Proteges to register and enter their preferences on Nurall. Once this is done Matching is as simple as 1-2-3

Step 1: The Nurall System Receives your Submission and starts working on smart matches.
An Automated Email is Sent to the Mentor/Protege with status updates on the matching.

Step 2: Once matches are found we get back to you with the profile information of the Mentor/Proteges. If you approve we proceed to the next step, note both the mentor/protege need to approve to connect with each other

Step 3: Once the approval is complete we allow the mentors and proteges to connect.

We have kept the process simple and we don't share your information without your consent/approval. We would love you to go ahead and try it out at http://nurall.com

As always we love to hear from you, tell us what you like/hate

Regards
Ravi

Validate Your Ideas Before Executing on Them

Most people would agree that both ideation and execution are critical for a successful organization. Working on the technical side of things I have focused on execution and executing efficiently. As I have started to work more on Nurall I have come to realize that it is critical for us to get our ideas validated before jumping in and building the product.

It is at this step that I have found the Customer Development Process to be extremely beneficial. The vision of Nurall is to connect Mentors with Visionary Proteges.
I see strong correlation in what we are doing at Nurall and the Customer Development Process. Our customers are mentors who can guide us to build a product that will satisfy their needs.
We seek to learn from the customers, if you are interested drop in at Nurall and Sign up with us.
We also see social tools like Nurall's FB Page, Nurall's TwitterAccount as means for us to engage and learn from users.

The challenge I see is incorporating the customer development process while we are in a mad rush to build the product. There are a bunch of questions that are running through my mind.

When do you decide that you have talked to enough customers?
Is there a magic number?
What do you do if you cannot get hold of enough people to talk?
How do you handle conflicting customer feedback?

As we go through the customer discovery and learning process at Nurall I will share my thoughts here. I hope this will be beneficial to Entrepreneurs and others who are engaged in a similar process. As always I love to hear from my readers. Feel free to let me know what you think.

Thanks
Ravi

Useful Books for Entrepreneurs

Recently I have been reading a bunch of books that are useful for Entrepreneurs.
I wanted to share my thoughts and get your feedback on it.

Here is the list

1) Purple Cow by Seth Godin

A must read if you are looking to build a product/service that is customer
oriented. I like the focus on the product in a marketing book. Also Seth clearly
instructs the concept of Sneezers/Early Adopters in his book

2) The Long Tail by Chris Anderson

I am reading this book, the concept of the long tail has been explained and made popular on the internet. I also see similar concepts with this book and Purple Cow. This book is useful to my role at Citysearch. At Citysearch I work on the Search Marketing Product.
I see how we can use the concepts of the long tail in monetizing search queries.
I was introduced to the concept of the long tail a couple of years ago while working at the Search Engine Marketing team at Citysearch. I finally got around to reading this book.
On the internet as we see economics of scale come into picture and the ability to provide almost infinite choice to consumers I feel this book will gain more and more value

3) The four steps to the Epiphany by Steve Blank

My co-founder at Nurall , Karthik recommended that I take a look at this book.
The book focuses on the Customer Development Methodology. The focus on customer discovery and customer learning is nice. Also the step by step approach helps start ups.
We have incorporated this approach and methodology to building Nurall.com.
The introduction of a well defined process to the chaotic world of internet startups is great.
A must read if you are going to start any new company

I have the following books that I am going to start reading soon

4) The Tipping Point by Malcolm Gladwell

I am interested in this book to explore further how an ideavirus grows and spreads.
A small groups of people can influence a majority. Is this true? How does it work?
How do you recognize these Sneezers/Early Users/Geeks?

5) The Art of the Innovation by Tom Kelley

I am looking to read this book with the following open questions
Is innovation an art? How can it be practiced?
Creativity: how to be creative?

These books have been useful to me as we are working on building Nurall.com
I feel lucky that I can learn and apply the principles in an internet start up company.
I am always looking to find more books/resources that would help entrepreneurs.
If you have recommendations I would love to hear your feedback. If you like/dislike my list let me know.

Thanks
Ravi