Difference between revisions of "Specialised Servers - LogicalDOC"

From Da Nerd Mage Wiki
Jump to navigation Jump to search
 
(6 intermediate revisions by the same user not shown)
Line 15: Line 15:


Here goes a functional set installation instructions.
Here goes a functional set installation instructions.
In my test case, I'm installing to an LXC container on a Proxmox server.  (Could be just a basic minimal Debian install)
'''Specs:'''
* 8GB boot drive
* 4 cores
* 8GB of RAM
* Debian 12


<span style="color: rgb(224, 62, 45);">('''NOTE''': Due to the complexity of this install, I'll be doing it logged in as '''root'''.)</span>
<span style="color: rgb(224, 62, 45);">('''NOTE''': Due to the complexity of this install, I'll be doing it logged in as '''root'''.)</span>
Line 30: Line 38:


* <code>apt install libreoffice imagemagick ghostscript tesseract-ocr xpdf openssl clamav</code>
* <code>apt install libreoffice imagemagick ghostscript tesseract-ocr xpdf openssl clamav</code>
= Database setup =
* <code>vi /etc/mysql/my.cnf</code>
and add in:
<pre>
[mysql]
default-character-set = utf8
[mysqld]
character-set-server = utf8
collation-server = utf8_bin
default-storage-engine = INNODB
</pre>
Then set up the user & the database itself:
* <code>mysqladmin -u root</code>
<pre>
CREATE DATABASE logicaldoc;
CREATE USER logicaldoc;
SET PASSWORD FOR logicaldoc@'%'=PASSWORD('password');
GRANT ALL PRIVILEGES ON logicaldoc.* TO logicaldoc@'%' identified by 'password';
quit
</pre>
= The actual install =
Unless you are PAYING for the open-source software, you'll want the CE version.&nbsp; (The following URL will likely change at some point & my require searching again...)
* <code>wget https://cytranet.dl.sourceforge.net/project/logicaldoc/distribution/LogicalDOC%20CE%208.7/logicaldoc-community-installer-8.7.3.zip</code>
* <code>unzip logicaldoc-community-installer-8.7.3.zip </code>
* <code>java -jar logicaldoc-installer.jar -console</code>
Pretty much defaults all the way through will get you up & running.
<span style="text-decoration: underline; font-size: 18pt;" >'''BUT!'''</span>
When you see: "'''[ ] Manual specification of the database connection URL'''"
Choose '''DESELECT'''
= Post-Install (WIP) =
Their post install instructions don't work as they tell you to copy a file that they failed to provide...
[[labnotes:SBN - LogicalDOC{{!}}Working on that part...]]
For the moment, there is a script installed...
Starting the service:
* <code>/LogicalDOC-Community/bin/logicaldoc.sh start</code>
Stopping the service:
* <code>/LogicalDOC-Community/bin/logicaldoc.sh stop</code>
Restarting the service:
* <code>/LogicalDOC-Community/bin/logicaldoc.sh restart</code>
= Usage =
Browse to http://'''YOURSERVERADDRESS''':8080
and sign in as '''admin''' with the password '''admin'''<p class="mwt-heading" >And follow [https://docs.logicaldoc.com/en/ their documentation] to get going.</p>
= Uninstallation =
Shutdown the service:
* <code>/LogicalDOC-Community/bin/logicaldoc.sh stop</code>
Delete the file (which doesn't exist...):
* <code>/etc/init.d/logicaldoc</code>
Delete the install directory
* <code>rm -r /LogicalDOC-Community</code>

Latest revision as of 20:35, 20 August 2023

Proven on:
Logo Debian.png
 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.

In my test case, I'm installing to an LXC container on a Proxmox server. (Could be just a basic minimal Debian install)

Specs:

  • 8GB boot drive
  • 4 cores
  • 8GB of RAM
  • Debian 12

(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...)

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 (WIP)

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

Working on that part...

For the moment, there is a script installed...

Starting the service:

  • /LogicalDOC-Community/bin/logicaldoc.sh start

Stopping the service:

  • /LogicalDOC-Community/bin/logicaldoc.sh stop

Restarting the service:

  • /LogicalDOC-Community/bin/logicaldoc.sh restart

Usage

Browse to http://YOURSERVERADDRESS:8080

and sign in as admin with the password admin

And follow their documentation to get going.

Uninstallation

Shutdown the service:

  • /LogicalDOC-Community/bin/logicaldoc.sh stop

Delete the file (which doesn't exist...):

  • /etc/init.d/logicaldoc

Delete the install directory

  • rm -r /LogicalDOC-Community
Retrieved from ‘https://wiki.nerdmage.ca/index.php?title=Specialised_Servers_-_LogicalDOC&oldid=1797’