Skip to main content

Posts

Showing posts from April, 2012

Configure Master / Slave Replication MySQL XAMPP

Mysql Master Server Configuration First Lets go to Replication panel on XAMPP.

Mobiles in INDIA - Google Trends and Google Public Data

I was looking into the Mobile Trends in INDIA.  There are as many as 650 million Mobile user in India.  We are adding 9 million(approx) new users every month.  Below is a look at how INDIA Mobile market fairs according to Google Trends and Google Public Data. First Lets start at looking in to Mobile Phones in India. Below are the details I got from my friend. GSM SUBSCRIBER FIGURES FEBRUARY-2012 Total number of GSM Subs  as of February 2012 - 656.86 million Total number of GSM Subs  additions in February 2012 -   8.77 million with 1.35% increase from previous month Maximum GSM Subs addition in the month of February by - Idea - 2.58 million Maximum GSM Subs addition in the month of February in - Maharashtra - 1,002,729 i.e 11.42% of the total Subscriber additions in February Maximum GSM Subs  - Airtel - 178.78 Million Lets Look into Google Public Data to see How INDIA has faired in the last few years against China. US has reached its Saturation Point now as m

NFCs and GeoFencing

Well I was looking into Potential NFC Benefits or use cases which we can use it for. Few of the first primary target is the Financial Sector. Most of the usecase are about Mobile Money. (like the Google Wallet). First I was very much interested/excited in the Mobile Money kind proposition, slowly came to realization that it has too many overheads. You need to sync up with a BANK, then Involve Retailers, etc etc too much of hassle if you take the INDIAN Market. Here are few things which I think can be used other than Financial Sector. - NFC card for getting into your hotel room.  - NFC enabled Phone as your car keys.  - your business card. - your public transportation. - concert, sports or other event tickets. - your boarding pass for getting on a plane.  - coupons and Many more. Then I came across an article, quite interesting. http://www.techcentral.co.za/sa-banks-nfc-trials-farcical/28336/ " Well-known entrepreneur and investor and former Google SA

Installing OpneNMS on CentOS - using RPM.

As from my previous post. This again is for the IT Team. Was helping them setup and network Monitoring tool. Here are the step to follow to install OpenNMS. Step 1: configure the OpenNMS Repository RPM ]# yum install yum-fastestmirror ]# rpm -Uvh http://yum.opennms.org/repofiles/opennms-repo-stable-rhel5.noarch.rpm Step 2: Install the Prerequisite Package: Java To install java you would download “ jdk-7u3-linux-x64.rpm “from http://www.oracle.com/technetwork/java/javase/downloads/jdk-7u3-download-1501626.html   and place it in your current working directory then run bellow command ]$ sudo rpm -ivh jdk-7u3-linux-x64.rpm Step 2: Install the Prerequisite Package: PostgreSQL To install PostgreSQL follow bellow commands ]$ sudo yum -y install postgresql-server (OR use the installer from http://www.enterprisedb.com/products-services-training/pgdownload ) ]# /etc/init.d/postgresql start ]# /sbin/chkconfig postgresql on Configure Po

Installation OTRS 3.1 on CentOS 6.2 Running PostGreSQL 9.1

I was working on getting and Ops tools for our IT Department, I had heard a lot about OTRS, so though to try it out. I have installed OTRS in CentOS 6.2 Running PostGreSQL 9.1 Below are the steps to get it up and running. Lets Start then. System Information: [ahmed@localhost ~]$ uname -a Linux localhost.localdomain 2.6.32-220.7.1.el6.x86_64 #1 SMP Wed Mar 7 00:52:02 GMT 2012 x86_64 x86_64 x86_64 GNU/Linux [ahmed@localhost ~]$ cat /etc/redhat-release CentOS release 6.2 (Final) Lets start by updating system (Optional) [ahmed@localhost Downloads]$ sudo yum update [ahmed@localhost Downloads]$ sudo yum update yum Installing httpd [ahmed@localhost Downloads]$ sudo yum install httpd (Below command Optional - if already exsists) [ahmed@localhost Downloads]$ sudo yum update httpd Now lets Install PostgreSQL - Downloaded this from the below link. http://www.enterprisedb.com/products-services-training/pgdownload [ahmed@localhost Downloads]$ ls OpenNMS-1.2.

SVN Incremental and Full Backup - with Email Notification

To start of with lets do a Incremental back up for every commit and then lets look in to taking a full back for all our repositories. (Files Attached Below) Incremental Backup. SVN Incremental for every commit can be done using post-commit hook this file is in REPOS_DIR/hooks/post-commit. tmpl you can copy it as post-commit and change permissions. $ cp post-commit.tmpl post-commit $ chmod 755 post-commit NOTE Important links: For rsync refer this link For mutt configuration refer this link. For Running Crontab. To Know about SVN backups you can go here. Here is the information which needs to be in post-commit hook in SVN. # # PreDefined Information # REPOS="$1" REV="$2" # # Change below parameters as Required. # LOCAL_BACKUP_PATH=/home/ahmed/ SVNREPOS_TEST/test_backup_ incremental REMOTE_BACKUP_PATH=/home/ ahmed/SVNREPOS_TEST/test_ backup_full LOCAL_MOUNT_BACKUP_PATH=/home/ ahmed/SVNREPOS_TEST/test_ backup_full REMOTE_USER="backup_t

Weekend Project - High Performance Free Flow Exhaust for Yamaha FZ16

Before I Start here is a disclaimer -  I am not a professional CAD or Mechanical Engineer to know much about this.  Also, All information I have is from the internet and have NO practical knowledge. Here we go then. I am currently working on building a High Performance Free Flow Exhaust for my Bike (Yamaha FZ16).  Attached is the CAD design I made for the Exhaust (I am not a professional CAD designer but do it as a Hobby - by the way this is my first CAD Drawing).  I was looking in to Details about how to make a FFE. I got a formula to develop a FFE.   Here is the link to Document which gives details on how to calculate the Diameter/Length of the pipe.  http://www.bgideas.demon.co.uk/tmanual/Tm_Ch4.pdf Using the above formula I get the Diameter, Length of the header pipe, secondary cone etc. When I calculate the formula I got Diameter of the Primary Pipe around 30mm.  I took 35mm as I will have bend just after the Gases Come out of the Exhaust Port. (Bend After 60mm fro

Backup PostGRE Database and 'rsync' to Another Server with Password-less Entry

We had a requirement that we need to create a backup of postGre Database, And rsync it to Another server. Here is How we did it. BACK UP DATABASE Here is the script to take backup of PostgreSQL Database. BACKUP_DIR_PATH="/backup/myDB/Here" PGUSER_DB="username" export PGPASSWORD="password" time=`date '+%d'-'%m'-'%H':'%M':'%S' ` /usr/pgsql-9.0/bin/pg_dump --host localhost --port 5432 --username $PGUSER_DB --format custom --blobs --verbose --file "$BACKUP_DIR_PATH/backup-databaseName-$time.backup" "database_name_here" 'rsync' DATA TO ANOTHER SERVER Here is the script to sync backed-up data to another Server DIR_LOCAL="/backup/myDB/Here" DIR_REMOTE=" /home/user/db_backup_from_dev " REMOTE_USER="username" REMOTE_SERVER="192.168.0.8" rsync -avzh -e ssh $DIR_LOCAL  $REMOTE_USER@$REMOTE_SERVER:$ DIR_REMOTE To C