Rock your everyday

One of my fav bangla song...

mone pore shei raater kotha
tumi ami nodi tire eka boshe
koto je gaan koto je shur koto je kotha
mone pore ki tomar o
bolo na amay tumi bolona hmm

mone pore shei diner kotha
kedechhile amito kokhono chaini
tomay koshto dite
tumi ki ta jano na
bolo na amay tumi bolona hmm

jani ami tumi je amar
tobu keno dishehara
bhabi ami timi je pashey
tobu keno achho dure
mone pore

jani ami emonee jibon
tobu jaage mone asha
hoyejabe shofol ey jibon
jodi tumi thako paashe

mone pore shei raater kotha
tumi ami nodi tire eka boshe
koto je gaan koto je shur koto je kotha
mone pore ki tomar'o
bolo na amay tumi bolona hmm

Known as kalboishakhi, the thunder storm...at its very best! love this wild side of nature...

While searching for drupal based application, I have found Open Atrium and it looks to me very useful for different team based works. Open Atrium is an intranet in a box that has group spaces to allow different teams to have their own conversations. It comes with six features - a blog, a wiki, a calendar, a to do list, a shoutbox, and a dashboard to manage it all. Enjoy drupal!

http://openatrium.com/features

Just being successful using GP Aloashbei 'SMS send' API with PHP. This API is in beta version and not released yet. This is really a nice and futuristic approach by grammenphone (in collaboration with Microsoft). SMS can be easily send to a gp number from a web application, all you need is to register your number at first at gp aloashbei site. I will upload my code and class soon. visit https://www.aloashbei.com.bd for details.

Just wrote a program to fetch image from Flickr using Flickr API and watermark text on it by PHP. There are many applications for transferring flickr images to facebook, but found no application for transferring facebook images to flickr. Soon going to work on it.

I have used a nice, simple script to export the rrd values into excel using PHP 5. You can find the script here:

http://code.google.com/p/php-excel/

Here is my code for the rrd export (here you'll find two functions - calculate_rrd() and format_bits(), these are described in my previous blog):

/*
Author: Md.Monjurul Hasan

Description
- RRD data exporter - output values into excel file
*/
/***************included files*******/

#include the export-xls.class.php file
require('export-xls.class.php');

$filename = 'rrd_export'.rand(0,10000).'.xls'; // a random filename chosen
#create an instance of the class
$xls = new ExportXLS($filename);

//read config file and get variables
$rrd_array = array ('rra/test1.rrd', 'rra/test2.rrd');
//export to excel
$header = " RRD Export"; // single first col text
$xls->addHeader($header);

#add blank line
$header = null;
$xls->addHeader($header);

#add 2nd header as an array of 3 columns
$header[] = "RRD Name";
$header[] = "Cur In";
$header[] = "";
$header[] = "Cur Out";
$header[] = "";
$header[] = "Avg In";
$header[] = "";
$header[] = "Avg Out";
$header[] = "";
$header[] = "Max In";
$header[] = "";
$header[] = "Max Out";
$header[] = "";
$header[] = "95% In";
$header[] = "";
$header[] = "95% Out";
$header[] = "";

$xls->addHeader($header);

$count = 0;
for ($c = 0; $c < count($rrd_array); $c++) {
$ret = calculate_rrd($rrd_array[$c], $graph_type); // graph type is daily/weekly/yearly and monthly
$row = array();
$row[] = $rrd_array[$c];
$result = format_bits($ret['current_in']);
$row[] = $result[0];
$row[] = $result[1];
$result = format_bits($ret['current_out']);
$row[] = $result[0];
$row[] = $result[1];
$result = format_bits($ret['average_in']);
$row[] = $result[0];
$row[] = $result[1];
$result = format_bits($ret['average_in']);
$row[] = $result[0];
$row[] = $result[1];
$result = format_bits($ret['max_in']);
$row[] = $result[0];
$row[] = $result[1];
$result = format_bits($ret['max_out']);
$row[] = $result[0];
$row[] = $result[1];
$result = format_bits($ret['percentile_in']);
$row[] = $result[0];
$row[] = $result[1];
$result = format_bits($ret['percentile_out']);
$row[] = $result[0];
$row[] = $result[1];
$xls->addRow($row);
}
//output the excel file
$xls->sendFile();

?>

I needed the rrd values in tabular format rather than graph. So i fetched the rrd values using rrd_fetch() function of PHP-RRDTool API. Then I calculated the required Current, Average, Max and 95th Percentile using the following function which may save time of others:

For percentile calculation, I followed the following article:
http://forums.cacti.net/post-95140.html&highlight=

To represent the values in bps/kbps/Mbps, you can use the following function:

/***
Function format value from bit to bps/kbps/Mbps

@input : bits
@output array: array[0] = value
array[1] = bps/kbps/Mbps

***/
function format_bits ($bits) {
$round_precision = 2;
if ($bits < 1000) {
$result[0] = round($bits,$round_precision);
$result[1] = "bps";
}
else if ($bits >= 1000 && $bits < 100000) {
$kbits = $bits/1000;
$result[0] = round($kbits,$round_precision);
$result[1] = "kbps";
}
else {
$mbits = $bits/(1000*1000);
$result[0] = round ($mbits, $round_precision);
$result[1] = "Mbps";
}
return $result;
}

Rupok (Ekti gaan)
Kotha: Rumman

Moner vitor juddho chole amar sharakhon
Neshar moto thomke thake
Klanto a jibon
Dhongsho smritir parey boshe amar ahoban
Dhukkho vule notun kore
Likhchi tomar a gaan

Michil vanga nirjonotay dariye eka
Alor nicher ondhokare smritir dekha
Char deyaler shobdo gula ekhon shudhoi chai
Meghe Dhaka shohor tate tui kebol nai
Moner vetor changa ghorar adim ayojon
Shunnotay dube thake amar sharakhon
Niyom vangar mogoz jure ekhon shudhoi chhok
Tepantor er nirbashone hariye geche rupok

Monei juddho amar nijer shathey lori
Smritir deyal chuye hazar murti gori
Chokher dekhay ja dekhi
Aar hoyni ja dekha
Ovimaaner nodir teer a
Datiye thaki eka

Vul jonme koshto amar lekhar aposhe
Odekha ek shorgo vashe ochena akashe
Moner vetor juddho ekhon
Amar shararaat
Ondhokarer kolahole dhorchi
Tomari haat

Ekla vishon amar ghore
Smritir hahakar
Aloy chaichhi niviye debo
Molin ondhokaar
Moner vetor juddho chole amar sharakhon
Mohakale miliye geli hothat kokhon

I found some nice videos on zdnet on web 2.0 concepts. Hope it will help others...
Web2.0 - http://news.zdnet.com/2422-13569_22-154425.html
Mashup - http://news.zdnet.com/2422-13569_22-152729.html
SOA - http://news.zdnet.com/2422-13569_22-155698.html

Yesterday I attended the facebook developer garage'09 in bangladesh. It was held in de ja vue cafe, gulshan. It was really good and inspiring!! Got 2 T-shirts and a pen n nicee notepad...labh hoise giya:-D.

It was a great tour with friends. We targeted the rainy weather of the sea beach. Although we didn't get the cats-n-dogs rain, it was not bad at all. We left dhaka on friday night (07/18/09) and came back from tour on tuesday morning(11/08/09). Mentionable places that we went other than sea beach were himchhari, inani beach and moheshkhali.

I got one brandnew MacBook Pro with Leopard 10.5.7 as Mac OS X. Installed windows vista in this Mac using bootcamp and cracked the vista with developer activation :-D. I can explore and copy the files of Mac OS from vista using HFSExplorer. From Mac OS, win vista partitions can be accessed by default with bootcamp. Working lyk charm!!

ek din, ghum vanga shohore
mayabi shondhay, chand jaga ek rat e...
ekti kishore chele, ekaki shopno dekhe,
hashi ar gaan e, shukher chobi ake
ahaa kije shukh..

shopnera hariye jay, shomoyer shagore e,
bethar abir e, kobita adhar e haray
vabonaro ful jhore jhore jay ahaaa
jiboner o gan hoyna surer kangal...

ekdin ghum vanga shohore..
mayabi shonday chand jaga rat eeee..
ekti kishor chhele, ekaki shopno dekhe....
hashi ar gan e .. shukher chobi akee..
ahaaaa kije shukh....

shoishob bimurto hoy, jay na bojha jayna
ashar jhorna payna shukher thiknaa
hotasha shudhu shathi hoye jaya ahaaa
she kishor ebar jibon chere palay

ekdin ghum vanga shohore

Although php date function should take the localtime of the server, seems it did not take last night. so I set the default timezone to "Asia/Dhaka" in my PHP code before calling the date function.

date_default_timezone_set("Asia/Dhaka");

also I needed to change the Asia/Dhaka timezone of SugarCRM in include/timezone/timezones.php file

'Asia/Dhaka' =>
 array (
   'gmtOffset' => 420, //previously it was 360
 )

We are working on the timezones of our Linux servers (RHEL, CentOS and Ubuntu) to update them for upcoming BD Daylight Saving. Also some java application runs on its own tzdata. So we updated those too. We put necessary task steps (for both windows and linux) in our official website so that people get benefit from us. Here's the link:

http://www.mango.com.bd/bd-dst.php

I kept on looking for E-recruitment Software, ofcourse open source and finally I have decided to work on Ants - an open source Applicant Tracking System. Although I need to customize it a lot. Its simple and built on PHP and MySQL. I got a recruitment module in OrangeHRM, an open source HR management software, which has limited features and can't give a complete e-recruitment solution in my opinion. Lets see how Ants work for me!

We (Our office management) have decided to give our 1 day salary for the 'aila' sufferers through Prothom Alo. Also I have donated today 2000 tk in a NGO. But nothing seems adequate to me. Lots of ppl are suffering. How can I contribute bigger to get them back to their normal life????

Usually we take mysql db/tables sql backup by mysqldump command or from phpmyadmin tool (my favorite). But if we need to take the binary backup, you can't do it . What you need to do, just simply copy all table files (*.frm, *.MYD, and *.MYI files). Usually these files are present in /var/lib/mysql directory in linux OS. If you want to check that you are getting the right data in tables you can use the following command

strings test.frm ,

say you are taking backup of test table. This command will show you all data in that table.

here's a useful link:
http://dev.mysql.com/doc/refman/5.0/en/backup.html

I was in need of a photo gallery - ofcourse open source, and I got two choices - Plogger and Gallery. Gallery2 will give you many features while plogger is really simple and worth for my small requirements. It has easy admin panel and also gives the basic features including slideshow - so I decided to rely on Plogger. I have modified the default theme and it worked fine.
First I removed the footer-text ('Powered by Plogger') from page (for that I commented out this line - print plogger_link_back(); in ploggerdir/themes/default/footer.php)
and
modified the css to decrease the search box width (added this line

#jump-search-container input[type=text] {
       width: 120px;
}

in ploggerdir/themes/default/gallery.css ).

Still working on it.

> When running Shell script, enable the debug mode with -x option.E.g. sh -x yourscript.sh
> When running Python script, import pdb - the Python debugger, call the set_trace() function and enter n in the console for next debug output. E.g.

#!/usr/bin/python
# epdb1.py -- experiment with the Python debugger, pdb
import pdb
def combine(s1,s2):      # define subroutine combine, which...
 s3 = s1 + s2 + s1    # sandwiches s2 between copies of s1, ...
 s3 = '"' + s3 +'"'   # encloses it in double quotes,...
 return s3            # and returns it.
a = "aaa"
pdb.set_trace()
b = "bbb"
c = "ccc"
final = combine (a,b)
print final