Tuesday, December 30, 2008

HSBC credit card gotcha

I have a HSBC gold credit card which I didnt use a single time. I got it as free card.
yday I got a credit card statement asking me to pay 2247, first shocked to see bill as I didnt do any shopping using this card. splitup was 2000 rs membership card fees and
247 as service tax on it. so I thought yday I will pay and will stop using this card. also felt cheated by the hsbc.

so discussed this with friends today but they said you just call up customer care and they will waive off the charges. and also mentioned that HSBC people add to your bill for various charges but you can waive it off by calling customer care. I called up customer care and they just waived it off.
so in case, you are having same problem, you dont need to pay it. just call customer care and waive it off.

The Zen and art of motorcycle maintenance - quotes

Blind Alley, though, If someone's ungrateful and you tell him he's ungrateful, okay,
you've called him a name. You haven't solved anything.

Woohooo... more than 100 posts on blog.

Enjoy

Sunday, December 28, 2008

Scripts to restart apache/mysql in windows

Currently I am working on 2 projects. both projects involves Apache and Mysql. but configuration used for each project is different and one project is using WAMP. So I was needed to start and stop services to switch between projects I am working. it was becoming quite tedious. so I tried to write a scripts to restart services whenever I was going to switch between projects. I am linux guy so like writing scripts but was new to writing script for restarting services on windows.
following are the scripts to start the services..

A.bat

sc stop Apache2
sc stop MySQL
pause
sc start wampapache
sc start wampmysqld


B.bat

sc stop wampapache
sc stop wampmysqld
pause
sc start Apache2
sc start MySQL


I first started using actually executables from bin directories from respective apps. but It was not working for stopping the service.

I used pause because didnt find sleep command on windows. these scripts I wrote using whatever help I got from windows help service. as I was working from home without internet.

if sc start/stop says service is not installed then you can install the service.
sc install servicename.

you have any better ways of doing this things let me know.

konneyy - who is this?

I turned my head with surprize...wanting to know from where question came.
"konneyy?" question in high pitch voice, repeated with mischivous smile on his face..
"Hrithik Roshan" I replied..
"Hitik roan" he repeated excitedly and kept repeating with playful smile.
"He" in this story is my 1 and 10 month year old nephew. I was quite surprized because he barely can talk now. and He wanted to know who is the smart guy on Coffee with Karan show. Amazing!!!

Friday, December 26, 2008

cant connect to mysql from client on remote machine, mysql running on aws

error messages you can get are
Error 2003: Can't Connect to MySQL server on 'hostname'

1) enable the firewall for amazon aws ec2 instance.
ec2-authorize default -p 3306
3306 is default port on which mysql runs. If you are running mysql on different port like 3307 or 3309 enable that.

2) in mysql/my.cnf which is mysql config file.

comment out following line which allows connection only from localhost.

bind_address=127.0.0.1


3) log on to mysql with root from local machine

GRANT ALL ON *.* TO 'user'@'ipadd' identified by 'pwd';

ipadd is ip address of machine from which you are trying to connect to mysql server
user and password are auth info.

useful links

http://forge.mysql.com/wiki/Error2003-CantConnectToMySQLServer

Monday, December 22, 2008

Tata indicom plug2 surf data card

yday bought Tata indicom wireless card, usb one ..from shop new baba mobile store in aundh near parihar chowk, near vishis cafe.

it cost me 2376 Rs for modem + sim.
I opted for recharge card worth 1000Rs with validity 6 months.

Tata indicom main office is opposite to Sancheti hospital, Shivajinagar.

In this rush I lost my Credit card. luckily blocked it before anyone misused it.

Thursday, December 11, 2008

Again winner of Collage competion at talentica




We, the winner team, Poushali, ryan, Nitin and Sandip, thats me ofcourse. unfortunately dont have photo of team.