November 2014 archive

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/