Author's posts

How to Install Cassandra on Ubuntu

Steps to install cassandra on Ubuntu: 1) First check which version of Java is installed by running the following command in a terminal (Oracle JRE is recommended), java -version 2) Install curl using the following command sudo apt-get install curl 3) Add the DataStax Community repository to the aptitude repository source list file (/etc/apt/sources.list). sudo …

Continue reading

Permanent link to this article: https://blog.openshell.in/2015/04/how-to-install-cassandra-on-ubuntu/

YII Command tool not working

Problem: YII Command tool was not working in the newly created YII application, While using the below command in the command prompt not getting any respond, but normally its work with other YII application. Every path has been configured correctly and not getting any errors. /var/www/yii-1.1.16/framework/yiic shell Screenshot: Solution: This caused due to access rules …

Continue reading

Permanent link to this article: https://blog.openshell.in/2015/03/yii-command-tool-not-working/

How to setup Cordova on Ubuntu for Android app development

Follow the belows steps to configure cordova with Android SDK on Ubuntu machine: Install Java & ANT: First, check you’ve got Java and Ant installed – you’ll need those later: sudo apt-get install default-jre sudo apt-get install default-jdk sudo apt-get install ant Install Nodejs: Run the following command to install NodeJS: sudo apt-get install nodejs …

Continue reading

Permanent link to this article: https://blog.openshell.in/2014/12/how-to-setup-cordova-on-ubuntu-for-android-app-development/

Node.js on Express Framework Installation with mysql(UBUNTU)

Step1: Download the node setup: curl -sL https://deb.nodesource.com/setup | sudo bash – Step2: Install Node.js sudo apt-get install -y nodejs Step3: Install npm and essential Add ons: Note: npm is the default package manager for Node.js. As of Node.js version 0.6.3, npm is bundled and installed automatically with the environment. npm runs through the command …

Continue reading

Permanent link to this article: https://blog.openshell.in/2014/11/node-js-on-express-framework-installation-with-mysql/

MySQL Error, “java.sql.SQLException: Value ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp” on ColdFusion 11

Issue: Queries to MySQL may return the error, “java.sql.SQLException: Value ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp” or similar. This error appears when using the Adobe ColdFusion MySQL 5 JDBC driver. Reason: This error occurs when the MySQL Date or DateTime columns have a value of all zeros (for example, ‘0000-00-00 00:00:00’). The default …

Continue reading

Permanent link to this article: https://blog.openshell.in/2014/11/mysql-error-java-sql-sqlexception-value-0000-00-00-000000-can-not-be-represented-as-java-sql-timestamp-on-coldfusion-11/

How to install MongoDB in Ubuntu14.04

Follow the below steps to install MongoDB in Ubuntu: 1. Import the MongoDB public key Ubuntu package manager use this key to check the consistency and authenticity of the packages sudo apt-key adv –keyserver hkp://keyserver.ubuntu.com:80 –recv 7F0CEB10 2. Generate a file with the MongoDB repository url echo ‘deb http://downloads-distro.mongodb.org/repo/ubuntu-upstart dist 10gen’ | sudo tee /etc/apt/sources.list.d/mongodb.list …

Continue reading

Permanent link to this article: https://blog.openshell.in/2014/11/how-to-install-mongodb-in-ubuntu14-04/

Attachment Failed on Gmail using Firefox 32

Recently I was faced problem while attaching document on gmail using firefox browser. I was followed the below steps to resolve the problem in my firefox v32.0.3 browser. Step 1: In Firefox address bar, type “about:config”. Step 2: Agree to warranty warning. Step 3: In search area type “network.http.spdy”, It will list the filtered result …

Continue reading

Permanent link to this article: https://blog.openshell.in/2014/10/attachment-failed-on-gmail-using-firefox-32/

How to read large XML files efficiently using PHP?

Recently I was faced problem of parsing large XML file using PHP. While parsing small files are no problem and all its quickly parsed, an attempt to parse larger files often causes time-out or Internal Sever Error. We will not able to use DOM or SimpleXML extension to parse the large XML documents in PHP. …

Continue reading

Permanent link to this article: https://blog.openshell.in/2014/09/how-to-read-large-xml-files-efficiently-using-php/

How to remove Ubuntu option on the Windows Boot Manager menu?

Recently I have installed ubuntu using Wubi (Ubuntu installer) side by side with windows 7, After that I have uninstalled ubuntu successfully. However when I boot my machine, the Windows Boot Manager will displayed both Windows and Ubuntu. I have followed the below steps to remove Ubuntu from the Windows Boot Manager option: Step 1: …

Continue reading

Permanent link to this article: https://blog.openshell.in/2014/09/how-to-remove-ubuntu-option-on-the-windows-boot-manager-menu/

MySQL zerofill and lpad – Shape digits in DB

I’m working with an application to have the item code. Item code column is set as an INT(5) but not all the item code values are 5 digits. So I need to round off the item code based on 5-digits. If the item code is 199, it should be display as 00199. How to make …

Continue reading

Permanent link to this article: https://blog.openshell.in/2014/09/mysql-zerofill-and-lpad-shape-digits-in-db/