Install LogicalDOC Community Edition with MariaDB on Ubuntu 16.04 | 18.04 LTS

LogicalDOC is a proprietary document management and collobration system, developed using JAVA to handle and share documents within an organization. It can be used as a document repostory to manage company’s workflows and a set of automatic import procedures.

This brief tutorial shows students and new users how to install LogicalDOC on Ubuntu 16.04 | 18.04 LTS systems.

LogicalDOC requires JAVA to be installed on the systems. which we’ll describe how to do below. When you’re ready, continue with the steps below to get LogicalDOC installed and ready to use on Ubuntu.

Step 1: Install and configure JAVA

Since LogicalDOC requires JAVA, use the steps below to get JAVA installed.

The easiest way to install Oracle Java JDK 8 on Ubuntu is via a third party PPA… To add that PPA, run the commands below.

sudo add-apt-repository ppa:webupd8team/java

After running the commands above, you should see a prompt to accept the PPA key onto Ubuntu… accept and continue

Now that the PPA repository has been added to Ubuntu, run the commands below to download Oracle Java 8 installer…. the installer should install the latest Java JDK 8 on your Ubuntu machines.

sudo apt update
sudo apt install oracle-java8-installer

When you run the commands above you’ll be prompted to access the license terms of the software… accept and continue.

Set Oracle JDK8 as default, to do that, install the oracle-java8-set-default package. This will automatically set the JAVA env variable.

sudo apt install oracle-java8-set-default

Now that JAVA is installed, run the commands below to set its home directory.

sudo nano /etc/environment

Then copy and paste the hightlighted line below and save the file.

PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games"
JAVA_HOME=/usr/lib/jvm/java-8-oracle
export JAVA_HOME

After that run the commands below.

source /etc/environment

When you run echo $JAVA_HOME  you should now see Java home directory.

Step 2: Install MariaDB

Now that Java installed, run the commands below to install MariaDB.

sudo apt-get install mariadb-server mariadb-client

After installing MariaDB, the commands below can be used to stop, start and enable MariaDB service to always start up when the server boots.

Run these on Ubuntu 16.04 LTS

sudo systemctl stop mysql.service
sudo systemctl start mysql.service
sudo systemctl enable mysql.service

Run these on Ubuntu 18.04 and 18.10 LTS

sudo systemctl stop mariadb.service
sudo systemctl start mariadb.service
sudo systemctl enable mariadb.service

After that, run the commands below to secure MariaDB server by creating a root password and disallowing remote root access.

sudo mysql_secure_installation

When prompted, answer the questions below by following the guide.

  • Enter current password for root (enter for none): Just press the Enter
  • Set root password? [Y/n]: Y
  • New password: Enter password
  • Re-enter new password: Repeat password
  • Remove anonymous users? [Y/n]: Y
  • Disallow root login remotely? [Y/n]: Y
  • Remove test database and access to it? [Y/n]:  Y
  • Reload privilege tables now? [Y/n]:  Y

Restart MariaDB server

Step 3: Create LogicalDOC Database

After installing MariaDB, use the guide below to create a database and user for LogicalDOC.

To logon to MariaDB database server, run the commands below.

sudo mysql -u root -p

Then create a database called logicaldoc

CREATE DATABASE logicaldoc;

Create a database user called logicaldocuser with new password

CREATE USER 'logicaldocuser'@'localhost' IDENTIFIED BY 'new_password_here';

Then grant the user full access to the database.

GRANT ALL ON logicaldoc.* TO 'logicaldocuser'@'localhost' IDENTIFIED BY 'user_password_here' WITH GRANT OPTION;

Finally, save your changes and exit.

FLUSH PRIVILEGES;
EXIT;

Next, run the commands below to open MariaDB configuration file.

sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

Then make the highlighted changes and save the file.

# this is only for the mysqld standalone daemon

[mysqld]

#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
character-set-server = utf8
collation-server = utf8_bin
default-storage-engine = INNODB

Restart MariaDB by running the commands below:

sudo systemctl restart mariadb.service

Step 3: Download LogicalDOC Package

Before installing LogicalDOC, please install these require packages.

sudo apt-get install libreoffice imagemagick ghostscript tesseract-ocr xpdf

After preparing your systems, run the commands below to download LogicalDOC package.

cd /tmp
wget wget 
unzip logicaldoc-installer-8.1.zip

Finally, run the commands below to install

sudo java -jar logicaldoc-installer.jar

Follow the wizard to answer the prompts when using the command line. For desktop user, you should see a GUI wizard.

LogicalDOC Ubuntu Install

Select a location to install LogicalDOC

LogicalDOC Ubuntu Install

Then type info about your company

LogicalDOC Ubuntu setup

Next, select MySQL connection and enter the database info you created above.

LogicalDOC Ubuntu installation

When you’re done, LogicalDOC should be installed and ready to use.

Open your browser and browse to the server hostname or IP address.

Login with:

Username: admin
Password: admin

LogicalDOC Ubuntu login page

Enjoy!

You can use the commands below to create a service account.

sudo cp /LogicalDOC/bin/logicaldoc-all.service /etc/systemd/system
sudo systemctl daemon-reload

Then use these commands to stop, start, and enable the service.

sudo systemctl stop logicaldoc-all
sudo systemctl start logicaldoc-all
sudo systemctl enable logicaldoc-all

You may also like the post below: