Ubuntu 14.04 - Install MongoDB

In this tutorial, you will be introduce how to install MongoDB on Ubuntu Server 14.04 Step 1: make sure your server is up-to-date 1 2 apt-get update apt-get dist-upgrade Step 2: install MongoDB 1 apt-get install -y mongodb After installing, MongoDB service automatically starts. You can check by typing: 1 ps aux | grep mongodb And the screen will display: 1 mongodb 2163 0.8 1.1 382048 46256 ? Ssl 15:36 0:03 /usr/bin/mongod --config /etc/mongodb.conf More 1. Start MongoDB Issue the following command to...

Read More

Ubuntu Server 14.04 - Install Nodejs

In this tutorial, you will be introduced how to install Nodejs by using Distro-Stable Version or a PPA (personal package archive). How To Install the Distro-Stable Version First, you should refresh your local package index prior and then install from the repositories: 1 2 sudo apt-get update sudo apt-get install nodejs Then, you should install npm (Node Package Manager) because by default Ubuntu Server 14.04 does not include npm package in nodejs package 1 sudo apt-get install npm How To Install Using a PPA from NodeSource The versions...

Read More

Ubuntu Server 14.04 - Enable SSH root access

Be default, Ubuntu does not allow to access ssh through root user. To do this, following steps: Step 1: set password for root user. See details at Change root user password Step 2: edit file "/etc/ssh/sshd_config" 1 vi /etc/ssh/sshd_config Step 3: comment and add new line like this 1 2 #PermitRootLogin without-password PermitRootLogin yes Step 4: restart SSH 1 service ssh restart ...

Read More

Ubuntu Server 14.04 - Config static IP address

Ubuntu 14.04 no longer allows you to edit "/etc/resolv.conf directly". Instead, you have to modify "/etc/resolvconf/resolv.conf.d/" head or tail. But it will be easiest to set this along side your ethernet config, in my opinion. You need to edit the file "/etc/network/interfaces": 1 sudo vi /etc/network/interfaces Then change to include the following: 1 2 3 4 5 6 7 8 9 10 11 12 13 # The loopback network interface auto lo iface lo inet loopback # The primary network interface auto eth0 #iface lo inet interface iface eth0 inet...

Read More

Ubuntu Server 14.04 - Change password

To do it command line: To change the root password: 1 sudo passwd To change your user password: 1 passwd To change other users password: 1 sudo passwd USERNAME ...

Read More

Ubuntu Server 14.04 - MySQL 5.5 installation and configuration

A. Installation: 1. Install MySQL 1 root@ubuntu:~# apt-get install mysql-server  By default MySQL 5.5 will be installed. 2. Install MySQL Connector JAR file 1 root@ubuntu:~# apt-get install mysql-connector-java* B. Configuration: 1. Set password for root user: 1 root@ubuntu:~# mysqladmin -u root -p'<your_password_here>' password $mysqlpassword 2. Remove unneccessary information from log and STDOUT 1 root@ubuntu:~# mysqladmin -u root 2>&1 >/dev/null 3.Start / Stop / Restart MySQL 1 2 3 root@ubuntu:~#...

Read More

Ubuntu Server 14.04 - Install Oracle JDK 1.7.x directly from PPA

Here is the codes that you can use to install Oracle JDK 1.7.x directly from PPA 1 2 3 sudo add-apt-repository ppa:webupd8team/java sudo apt-get update sudo apt-get install oracle-java7-installer ...

Read More

Pivot and Unpivot operations in Oracle 11g Release 2

(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) })(window,document,'script','//www.google-analytics.com/analytics.js','ga'); ga('create', 'UA-51418703-1', 'ittektalk.blogspot.com'); ga('send', 'pageview'); This article shows how to use the new PIVOT and UNPIVOT operators in 11g release 2. PIVOT For starting, we need some data 1 2 3 4 5 ...

Read More