Posted on

Upgrade Ubuntu 14.x server to Ubuntu 15.04

It’s already april again and that means that Canonical has updated Ubuntu. This one has the name Vivid Vervet and has the number 15.04.

It is very easy to upgrade this from a Ubuntu 14.04 or 14.10 server. It’s just the same as upgrading from 14.04 to 14.10 which we discussed earlier in this post.

Keep in mind that upgrading takes a couple of minutes and that you make sure you have a backup!

Requirements

  • Ubuntu 14.04/14.10 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 15.04

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

sudo do-release-upgrade -d

Follow the instructions on the screen. These can be different for your server and are therefor not discussed here.

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