Bruno, the Bear!

Nope. You were not the brightest one in the litter. You were not even the biggest. Nor the most dominant. Yeah, that was your sister, remember seeing her trying to chew off your little ear. There was something about you. The most adorable little cub I had ever seen, you were like a little bear, with them big furry paws, little teeth and barely open eyes. So we get you home, give you some milk soaked bread (which you don't bother to eat much), and place you on the floor.. and what do you do?? you lazy old bum! you spread all four leg and start napping like a baby.. still remember that day like yesterday, even after 7 years had come to pass.

Bruno Gunner of Silverfern, that was your given name, don't think you ever gave a damn about that, I bet you remember all them trash names I used to call you with.. Balla, Buchi, Baba, Modaya, Haraka, Thalapatha, Rotiya.. and most of the time.. Putha.. Ring any Bells?

As time came to pass you grew in to a HULK of a dog, for most people you were a HUMONGOUS dog. Weighing at more than 70 Kg, you were quite a handful and hands down the biggest Rottweiler I've ever known. You were always a gentle giant though, the innocent, yet jealous as heck type. You loved everyone! And I mean everyone, People would pea in their pants when you got near, noo.. that is not because you were fierce.. thats just because you were tremendous. Maaan! Food was your passion... you greedy Pig! You were the king of munch town. :) :) and exactly the right fit for our family. Bruno Yatawara. Haha!

We had our ups and downs, I still yield the scars from all those battles we had, all those times you tried to chew off my hand, remember I even got vaccinated once after you bit my arm (was it the arm, I don't remember) I miss all them fights, I miss that fierceness, both of us... we were two peas off the same pod. We liked it rough... the violence we exhibited our anger flaring... that was a fundamental part of our relationship.. you would growl at me, and I would growl at you, 5 minutes we would fighting.. and in another 5 minutes, you would be lying on the ground with all 4 paws up, looking at me with that weird grin in your face, tongue sticking out, while I rubbed your tummy... those were the days my friend. Those were the days.

I don't think anybody would understand what we had, and I don't expect them to.. I'm writing this because I was not able to be at your side, in your dying hour. This is the speech that I always wanted you to hear from me. And this is the speech I never got to give you. Rest in peace my Son!. May you attain a better life, a better family that would give you all the fried fish and corned mutton, and crunchy chewy stuff you liked all so much. Farewell Boy! Hope we meet again, in this life or the next.

Driving Fast

Why do people drive fast? Well.. If we leave out get away situations and emergencies.. People do it generally for the thrill they get out of it, or because they want to prove something, or simply because they are just inconsiderate morons looking for trouble.

Then again this this post is not about other people. It's about why I do it. So here goes.


Its about the RUSH. The same rush a junkee would get from sniffing coke. 

Its an ecstatic feeling. Makes you feel nothing else in the world matters. All your worries, troubles hopes, dreams, commitments disappear for that brief moment. Your senses on full alert. Adrenaline rushing through your system. Because you know, you are taking the vehicle to the absolute limit, and no matter what safety precaution your car came packed with, if you make a mistake it's going to end badly, either for you or for someone on the road. Life hangs in the balance. The beauty of the situation is that, in this chaos you find clarity, absolute focus. It's so pristine and otherworldly that you just lose yourself in the indulgence, and give in; For, that brief moment in time, You are alive and free.




All that being said, going fast and reckless on public roads is just plain wrong.

How to configure WSO2 Api Manager with PostgreSQL

Most Enterprise level application developers tend to use PostgreSQL over MySql as their open source Database of choice, due to it's close compliance with SQL standards, compared to the former. What this means is, if at some point the application owner chooses to go ahead with a closed-source solution such as Oracle for its database, the swap can be accomplished with much of a hassle.

This article will discuss the installation of PostgreSQL and configuration of the same with WSO2 Api Manager, on a linux Debian distribution.

Please note that if you have several installations of PostgreSQL locally or have had trouble getting it to work due to corrupt installations and etc. I would suggest starting off with a clean slate. Hence, you may run the commands listed below to completely uninstall PostgreSQL from your system.

apt-get --purge remove postgresql\*

Now lets delete all configurations.

rm -r /etc/postgresql*
rm -r /var/lib/postgresql*
userdel -r postgres
groupdel postgres

So lets start with the installation. Just type the following command.

sudo apt-get install postgresql

Ok, now that you have installed PostgreSQL, lets set it up. At the time of installation PostgreSQL will create a user by the name "postgres". Executing the following command will log you in to the PSQL admin console

sudo -u postgres psql

Enter the admin user password and you should see a prompt indicating "postgres=#".
Now lets go ahead and create two databases. One for the API Manager specific tables, lets call it "am_db". Another for the WSO2 Carbon tables, lets call it "carbon_db". Remember, even if you use upper case to create the databases, the persisted database name will comprise of only lowercase characters, hence might as well go with lower case at the time of creation.

create database am_db;

create database carbon_db;

Now, we need to create the tables. The API Manager pack comes with the scripts to create each set of tables they can be found inside the "dbscripts" folder of the AM zip.

The carbon DB script is at <AM_home>/dbscripts/postgresql.sql
The carbon DB script is at <AM_home>/dbscripts/apimgt/postgresql.sql

Remember what we learned earlier about the user "postgres" you will need be logged in as this user to execute whatever PostgreSQL scripts that you may wish to run.

Before attempting that, lets change the password of the 'postgres' user. I found it easier to do, rather that scour the internet  to find what the default password was. Just login as admin user and change it to a desirable value via the following command.

passwd postgres;

Lets login as 'potgres' via;

su - postgres;

and execute the two table creation scripts against each Database;

psql -d am_db -a -f <path_to_am_script>/postgresql.sql 

psql -d carbon_db -a -f <path_to_carbon_script>/postgresql.sql 

Voila! now you have the two databases setup. What's left is to configure the "master-datasources.xml" inside <AM_HOME>/repository/conf/datasources/, add the PSQL driver and start the server.

You will need to change the WSO2_CARBON_DB and WSO2AM_DB data sources in the master-datasources file as follows.

 WSO2_CARBON_DB
 The datasource used for registry and user manager
 
  jdbc/WSO2CarbonDB
 
 
  
   jdbc:postgresql://localhost:5432/carbon_db
   postgres
   postgres
   org.postgresql.Driver
   50
   60000
   true
   SELECT 1
   30000
  
 



 WSO2AM_DB
 The datasource used for registry and user manager
 
  jdbc/WSO2AM_DB
 
 
  
   jdbc:postgresql://localhost:5432/am_db
   postgres
   postgres
   org.postgresql.Driver
   50
   60000
   true
   SELECT 1
   30000
  
 

Done? great. Download the PostgreSQL driver relevant for your version from here, and copy the .jar file to the the following location inside the AM Pack.

<AM_HOME>/repository/components/lib/

That's it! go and start API Manager by running "./wso2server.sh" from inside of  <AM_HOME>/bin.