Specialised Servers - LogicalDOC

Proven on:

12 (bookworm)

LogicalDOC is a document Management System...

It seems to be fairly functional & useful.  Sadly, the documentation has a few issues.

So...

Here goes a functional set installation instructions.

(NOTE: Due to the complexity of this install, I'll be doing it logged in as root.)

Prerequisites

You'll need a database, Java & a handful of other applications.

For Java, Let's install an up-to date version:

• apt install openjdk-17-jdk

We'll use MariaDB since I'm doing this on Debian (using the procedure outlined here):

• apt install mariadb-server mariadb-client php-mysql
• mysql_secure_installation

And the rest of the stuff they say you'll need:

• apt install libreoffice imagemagick ghostscript tesseract-ocr xpdf openssl clamav

Database setup

• vi /etc/mysql/my.cnf

and add in:

[mysql]
default-character-set = utf8

[mysqld]
character-set-server = utf8
collation-server = utf8_bin
default-storage-engine = INNODB

Then set up the user & the database itself:

• mysqladmin -u root

CREATE DATABASE logicaldoc;
CREATE USER logicaldoc;
SET PASSWORD FOR logicaldoc@'%'=PASSWORD('password');
GRANT ALL PRIVILEGES ON logicaldoc.* TO logicaldoc@'%' identified by 'password';
quit

The actual install

Unless you are PAYING for the open-source software, you'll want the CE version.  (The following URL will likely change at some point & my require searching again...)

• wget https://cytranet.dl.sourceforge.net/project/logicaldoc/distribution/LogicalDOC%20CE%208.7/logicaldoc-community-installer-8.7.3.zip
• unzip logicaldoc-community-installer-8.7.3.zip
• java -jar logicaldoc-installer.jar -console

Pretty much defaults all the way through will get you up & running.

BUT!

When you see: "[ ] Manual specification of the database connection URL"

Choose DESELECT

Post-Install

Their post install instructions don't work as they tell you to copy a file that they failed to provide...

Working on that part...