FanaticZine

07th Feb 2011 Closing up for the day.. thought I should mention about flood effected people in SL

I know I’ve being  so busy for the last few months and I could not post anything much on my blog. well I’m considering to cut down some of my extra curriculum activities and spend sometime in writing on this.

And yes, I have an idea of making the Mix Master Lab alive again, it’s being a while since I even logged into the  site.. it’s 2011, I hope it’s gonna be a wonderful year for everybody.. I have a lot of ideas.. we’ll see how things will fall into places..

Today was the first day at work for 2011.. so wish me luck in my project and I wish you all the best for this new year…

Love found in sympathy is like your running nose, it starts with a small germ, and then it makes you to sneeze your chest out for a week. You can’t work, you can’t sleep, you can’t talk with anybody and after all that trouble, finally it dries out leaving you with a body pain and feeling wasted… never fall in love coz you feel sorry for somebody that will be THE END of your peace in mind.

This a remake of the nursery rhyme, “Are you sleeping ? brother john” Hope you’ll like it. Your comments are most welcome…

Hey  Guys, Have you ever wondered how to get a copy of your production database, may be to setup your local development environment to look like your production ? biggest problem that you will face is deploying your database to  reflect your production database, because sometimes it might want to downloading Gigabytes to download a copy of your production database. The solution is for this is simple get a minimized copy or a version of the database where it gives you all the tables with a limited number of rows in each of them. sounds good ?

Okay then here is the trick..

We all know in MySQL there is an command line tool mysqldump where we can provide a few parameters into it and get a copy of any database. what we have to do is give it a little more parameters, then it will limit the number of rows copied from each table into your dump. so here is the command..

mysqldump  -u  {Username}  -p       –opt  –where=”true LIMIT 500″ {databasename} > {dumpfilename.sql}

once you press enter, it will ask you for the database password in the next line, provide the password.. you are done

Please note that mysqldump is located in the /bin folder of your mysql installation.

Are you experiencing the same problem as the title ? are you working with a MySQL DB server. Then the cause for this problem is. The MySQL driver remove it’s connection from the connection pool due to inactivity after few hours if the server is not processing anything though the db connection.

There is a solution introduced in the Pentaho forum for this, you can find the thread with the following link.

http://forums.pentaho.com/showthread.php?54939-Pentaho-Server-falls-each-night-..&p=178067#post178067

But above forum post is based on the JBoss server. My intention with this post is to implement the same on the tomcat server since the file structure is a bit different. Ok without further due, let get into action.

01.    Download the C3P0 driver from SourceForge
02.    Extract the  c3p0-0.9.1.2.jar file into \biserver-ce\tomcat\common\lib\
03.    Open the mysql5.hibernate.cfg.xml XML file in the \biserver-ce\pentaho-solutions\system\hibernate\ folder
04.    Add the following code into the file

<!— hibernate c3p0 settings —>

<property name=”connection.provider_class”>org.hibernate.connection.C3P0ConnectionProvider</property>
<property name=”hibernate.c3p0.acquire_increment”>3</property>
<property name=”hibernate.c3p0.idle_test_period”>10</property>
<property name=”hibernate.c3p0.min_size”>5</property>
<property name=”hibernate.c3p0.max_size”>75</property>
<property name=”hibernate.c3p0.max_statements”>0</property>
<property name=”hibernate.c3p0.timeout”>25200</property>
<property name=”hibernate.c3p0.preferredTestQuery”>select 1</property>
<property name=”hibernate.c3p0.testConnectionOnCheckout”>true</property>

05.    Save and Restart the B.I Server or Service

That should do the trick…

( When you are editing the XML file, please be careful with the quotation characters )

Newest Upgrade to my work, this an unboxing review of the Behringer PodCast Studio Firewire Version. Hope you guys will find this useful and please leave any questions as I would be happy to answer. And Pros please leave comments with Tips & Tricks as I would like to learn from you Thanks

**** Please make sure you install the latest drivers for the firewire interface from the Behringer site.

Behringer product page for this package.
http://www.behringer.com/EN/Products/PODCASTUDIO-FIREWIRE.aspx

This human body, It’s blood and flesh,
one day will have to leave it into dust and leave this place ,
till that day it’s a short ride and why all these hating, separatism  and complications ?…
enjoy the journey with the small things you have, rather worrying about big things that you cant have…

Live your dream, enjoy working  hard for it, but do not make your own  dream your suffering…. and stand straight when challenged..

(Thank you Mome.. for teaching that to me… you are my biggest inspiration  )

it’s almost 1:00 AM in the morning.. Just thought to let you guys know that I will not be able to upload my mixdownz on YouTube, since YouTube doesn’t like uploading copyright stuff.. so for now i’m stopping uploading them here.. but later somewhere in a corner on the internet.. you’ll be able hear them..

Hey Guys,
Couldn’t write anything new, since I was busy for the last few days. well could not try much things as well because of the same reason. I was back at home a few days back and I came across this  little incident, so I caught that with my phone. bunch of ants trying get their “just found” food  home. I know this is just a normal thing, but it’s still amusing to look at it. and I accept ants could be very painful insects, but very encouraging creatures as well. check it out…