Posted on

Upgrade Ubuntu 14.04 LTS server to Ubuntu 14.10

It is october again, so that means Canonical has released a new version of Ubuntu. This time the gave it the name Ubuntu 14.10 Utopic Unicorn. This release does not have so many changes. But if you’d like to upgrade to Ubuntu 14.10 there is a simple tutorial. Keep in mind that upgrading takes a couple of minutes and that you make sure you have a backup!

Requirements

  • Ubuntu 14.04 LTS server
  • SUDO-rights

1. Update-manager-core

Make sure you have update-manager-core by trying to install it. If your server already has update-manager-core installed there will be no problem.

sudo apt-get install update-manager-core

2. Edit release-upgrades file

Use nano or vi(m) to edit the file /etc/update-manager/release-upgrades

sudo nano /etc/update-manager/release-upgrades

The file will open and in the bottom you’ll find Prompt=lts, change it to Prompt=normal

You can save in nano by pressing ctrl+o and hitting enter. You can close nano by pressing ctrl+x.

This way the update manager will look for every new version that came out, not only the LTS-versions.

3. Upgrade the system to Ubuntu 14.10

Execute the following command, it will upgrade your server to Ubuntu 14.10

sudo do-release-upgrade -d

Follow the instructions on the screen.

Posted on

Install Elasticsearch with JDBC driver on Ubuntu 14.04 LTS

In this tutorial we will be discussing how to install elasticsearch with a jdbc river on a Ubuntu 14.04 LTS server.

Prequisites

For this tutorial you will need:

  • A Ubuntu 14.04 LTS installation
  • SSH access
  • A logged in root user or a user with sudo rights
  • MySQL installed
  • Unzip installed (apt-get install unzip)

Install Oracle Java

sudo add-apt-repository ppa:webupd8team/java

and press enter when asked

apt-get update

sudo apt-get install oracle-java7-installer

You can test your java installation by checking what is the output of

java –version

Download Elasticsearch

First go to /home by using
cd /home

Now download the Elasticsearch Debian Package
wget https://download.elasticsearch.org/elasticsearch/elasticsearch/elasticsearch-1.3.4.deb
(Check if this version is still the latest by visiting http://www.elasticsearch.org/overview/elkdownloads/)

Install the Debian package by using
dpkg -i elasticsearch-1.3.4.deb

Start Elasticsearch by running
Service elasticsearch start

Wait some seconds and then visit
Your.servers.ip:9200
or use the command
curl -X GET 'http://localhost:9200'

It should say something like ‘status: 200’ and some other information.

You just installed Elasticsearch!

Install MySQL JDBC driver

Now you need to install the MySQL JDBC driver. This lets MySQL, JDBC river and Elasticsearch communicate.

Install the JDBC driver
./bin/plugin --install jdbc --url http://xbib.org/repository/org/xbib/elasticsearch/plugin/elasticsearch-river-jdbc/1.3.4.4/elasticsearch-river-jdbc-1.3.4.4-plugin.zip

Download the MySQL JDBC driver to your current directory by using
curl -o mysql-connector-java-5.1.28.zip -L 'http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.28.zip/from/http://cdn.mysql.com/'

Unzip the zip file by using
unzip mysql-connector-java-5.1.28.zip

Add the jar to the JDBC river plugin directory and give it permissions.
cp mysql-connector-java-5.1.28/mysql-connector-java-5.1.28-bin.jar plugins/jdbc/
chmod 644 plugins/jdbc/

Restart Elasticsearch by using
service elasticsearch restart

Make sure you only have 1 (ONE!) mysql-connector-java-5.1.28-bin.jar in your elasticsearch folder! It should be in plugins/jdbc.

Your first JDBC river

Now you can start using JDBC river with SQL like this