Tech Tips and Tricks
When accessing EC2 amazon cloud, you would receive a .pem file to login to the shell. Putty does not use .pem file and you would need to convert that file to .ppk file which putty uses. In order to convert Continue reading Access AWS with Putty
The easiest way to export is use syntax in command prompt (cmd): mysqldump -u USER -p PASSWORD DATABASE > filename.sql To import the same file, the syntax is: mysql -u USER -p PASSWORD DATABASE < filename.sql
For Windows machine running WAMPServer: 1) Install PDT plugin on your eclipse 2) Download XDebug to match your php 3) Install XDebug – save XDebug dll to wamp_path/bin/php/php5.3.5/ext folder 4) Enable XDebug – update php.ini file 4a) comment zend debugger Continue reading Enable XDebug on WAMP using Eclipse
While importing a mysql dump file, I was receiving an error “MySQL server has gone away”. The reason is that the maximum allowed packet size was less than the dump file size. Edit “my.ini” file and update the value for Continue reading MySQL server has gone away
When opening a csv file in excel, leading zero’s are displaced as below: if the CSV file has “010101”, when opened in excel, it becomes “10101”. To overcome this issue, store data in CSV file as =”010101″ (add ‘equals’ sign Continue reading CSV to Excel – keep leading zeros
Following are the steps to create an real SSL certificate (verified by VeriSign/Thawte etc.) for Tomcat: 1. Creation of keystore keytool -genkey -alias XXX -keyalg RSA -keystore ./XXX.keystore 2. Generation of CSR keytool -certreq -alias XXX -file XXX.csr -keystore ./XXX.keystore Continue reading Generate SSL certificate for Tomcat
In case you need a list of countries, here is the file
I have been trying to configure apache/tomcat is such a way that apache comes on the front-end so that I can have all the features of apache like URL rewriting, virtual hosts, PHP etc. and forward only certain requests to Continue reading Integrate Apache 2 with Tomcat 6
If you want to increase the limit of open files for the current session, simply run ulimit -n 2048 If you want to increase it by default, edit /etc/security/limits.conf and add * hard nofile 2048 * soft nofile 2048 Continue reading Increase maximum limit of open files per user
There is a bug in IE 6 where following code does not work var newUrl = “http://www.google.com/”; window.location = newUrl; // This also doesn’t work! // window.location.href = newUrl; After a scratching head for couple of hours, found the solution Continue reading IE 6 bug in window.location