Difference between revisions of "Installation using MariaDB"

From LogicalDOC Community Wiki
Jump to navigationJump to search
(Install MariaDB)
Line 29: Line 29:
 
</source>
 
</source>
  
== Install MariaDB ==  
+
== Install MariaDB ==
 +
 
 +
Brief introduction
 +
MariaDB 5.5 corresponds to version 5.5 of MySQL, MariaDB 10 instead corresponds essentially to the 5.6 version of MySQL.
 +
Initially we had thought to install on the system MariaDB version 5.5 using the instructions published at this address https://www.liquidweb.com/kb/how-to-install-mariadb-5-5-on-ubuntu-14-04-lts/
 +
Afterwards, having verified the availability of newer versions we opted to install MariaDB 10.1 following the instructions published by this other address https://www.vultr.com/docs/install-mariadb-on-ubuntu-14-04
 +
 
 +
Add the MariaDB Repository
 +
 
 +
sudo apt-get install software-properties-common
 +
 
 +
To find which repo you should use with the [https://downloads.mariadb.org/mariadb/repositories/ MariaDB repository generator]. We’re going to add the Ubuntu 14.04 “trusty” MariaDB 10.1 repository.
 +
 
 +
Import the public key and add the MariaDB repository:
 +
 
 +
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
 +
sudo add-apt-repository 'deb http://mirror.jmu.edu/pub/mariadb/repo/10.1/ubuntu trusty main'
 +
 
 +
Install MariaDB
 +
 
 +
Once the key is imported and the repository added you can install MariaDB with:
 +
 
 +
sudo apt-get update
 +
sudo apt-get install mariadb-server
 +
 
 +
Verify that MariaDB is operational
 +
 
 +
After installation, run mysql -u root -p. Enter your password when prompted. You will see output similar to the following:
 +
 
 +
<pre>
 +
Welcome to the MariaDB monitor.  Commands end with ; or \g.
 +
Your MariaDB connection id is XXXX
 +
Server version: 5.5.X
 +
 
 +
 
 +
Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.
 +
 
 +
 
 +
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 +
 
 +
 
 +
MariaDB [(none)]>
 +
</pre>
 +
Congratulations, you have successfully installed MariaDB. If you instead received an error, retry by running the following command:
 +
 
 +
service mysql start
 +
 
 
== Install Third Parties Components ==  
 
== Install Third Parties Components ==  
 
== Install LogicalDOC ==  
 
== Install LogicalDOC ==  
 
== Configure Service for Reboot ==
 
== Configure Service for Reboot ==

Revision as of 07:58, 9 September 2016

LogicalDOC CE 7.5.1 has been successfully installed on Ubuntu 14.04 Server using MariaDB 10.1.
This install was on a vanilla install of Ubuntu 14.04 LTE 64bit Server. The steps below follow what I did to configure Ubuntu for LogicalDOC.

Update Current Packages

It is assumed that the user is logged in and has sudo privilege. These steps are performed from the command line.

sudo apt-get update

Setup Oracle Java 8

These simple steps have been retrieved from: How to Install Oracle Java 8 on Ubuntu 14.04 LTS

Add the WebUpd8 Team Personal Package Archive (PPA)

Add the PPA:

sudo apt-add-repository ppa:webupd8team/java

The Installation

sudo apt-get update
sudo apt-get install oracle-java8-installer

Check Installation

java -version

Install MariaDB

Brief introduction MariaDB 5.5 corresponds to version 5.5 of MySQL, MariaDB 10 instead corresponds essentially to the 5.6 version of MySQL. Initially we had thought to install on the system MariaDB version 5.5 using the instructions published at this address https://www.liquidweb.com/kb/how-to-install-mariadb-5-5-on-ubuntu-14-04-lts/ Afterwards, having verified the availability of newer versions we opted to install MariaDB 10.1 following the instructions published by this other address https://www.vultr.com/docs/install-mariadb-on-ubuntu-14-04

Add the MariaDB Repository

sudo apt-get install software-properties-common

To find which repo you should use with the MariaDB repository generator. We’re going to add the Ubuntu 14.04 “trusty” MariaDB 10.1 repository.

Import the public key and add the MariaDB repository:

sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db sudo add-apt-repository 'deb http://mirror.jmu.edu/pub/mariadb/repo/10.1/ubuntu trusty main'

Install MariaDB

Once the key is imported and the repository added you can install MariaDB with:

sudo apt-get update sudo apt-get install mariadb-server

Verify that MariaDB is operational

After installation, run mysql -u root -p. Enter your password when prompted. You will see output similar to the following:

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is XXXX
Server version: 5.5.X


Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


MariaDB [(none)]> 

Congratulations, you have successfully installed MariaDB. If you instead received an error, retry by running the following command:

service mysql start

Install Third Parties Components

Install LogicalDOC

Configure Service for Reboot