Page 1 of 1

Installation OpenKM-6.3.6 on MariaDB 10.1.25

PostPosted:Sat Mar 17, 2018 12:40 pm
by fhoernchen
Hi Community,

I'm going to install the OpenKM on my raspberry (Ubuntu 17.10). On the server I have 3 different MariaDB instances, 2 are not relevant for this toppic and a third instance is for openkm and is running on port 3309:
mysqld_multi report
Code: Select all
Reporting MariaDB servers
MariaDB server from group: mysqld3307 is running
MariaDB server from group: mysqld3308 is running
MariaDB server from group: mysqld3309 is running
I did the preparation steps mentioned in the documentation and the I'm going to install OpenKM with the installer resulting in the error:
java -jar OKMInstaller.jar
Code: Select all
Running in Linux: 0.9.5-CE (build: 7363361)
Linux distro: ubuntu (Ubuntu - 17.10)
Local host: Raspberry (127.0.1.1)
Java version: 1.8.0_151
Free disk size: 7.7 GB
RAM size: 925.5 MB
CPU cores: 4
Current directory: /home/openkm

Database [h2]: openkm
Database host [localhost]: 
Database name [okmdb]: 
Database user [openkm]: 
Database password [jGxZM0gYlTiw]: 
---------------------------
- Database: openkm
- Database host: localhost
- Database name: okmdb
- Database user: openkm
- Database password: jGxZM0gYlTiw
- Install version: 6.3.6
---------------------------
Start install process? [y/N]: y
[color=#FF0000]ERROR: Unsupported database: openkm[/color]
Why is my database not supported?

Thanks

Re: Installation OpenKM-6.3.6 on MariaDB 10.1.25

PostPosted:Sun Mar 18, 2018 6:59 pm
by jllort
You should write "mariadb" or "mysql", really when you choose it, what really happens in background is the installer modify server.xml with your database setting, nothing else. You can always edit manually the file ( $TOMCAT_HOME/conf/server.xml ) to change these values.

Re: Installation OpenKM-6.3.6 on MariaDB 10.1.25

PostPosted:Mon Mar 26, 2018 12:29 pm
by fhoernchen
Hi and thanks for the reply,

but I'm not at the point having a $TOMCAT_HOME/conf/server.xml. I'm at the initial step of installing the system:

Create Database is done:
Code: Select all
CREATE DATABASE okmdb DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_bin;
CREATE USER openkm@localhost IDENTIFIED BY 'password';
GRANT ALL ON okmdb.* TO openkm@localhost WITH GRANT OPTION;
Database is up and running on Port 3309!

So I'm going to install the sytem with
Code: Select all
java -jar OKMInstaller.jar
After completing the questions of the installer I get the error message:
Code: Select all
---------------------------
- Database: openkm
- Database host: localhost
- Database name: okmdb
- Database user: openkm
- Database password: pass
- Install version: 6.3.6
---------------------------
Start install process? [y/N]: y
ERROR: Unsupported database: openkm

Re: Installation OpenKM-6.3.6 on MariaDB 10.1.25

PostPosted:Wed Mar 28, 2018 3:25 pm
by jllort
Database might be "mariadb" or "mysql", you have set "Database : openkm" what is wrong type.

Re: Installation OpenKM-6.3.6 on MariaDB 10.1.25

PostPosted:Wed Mar 28, 2018 5:50 pm
by fhoernchen
oh damn, thanks!

Re: Installation OpenKM-6.3.6 on MariaDB 10.1.25

PostPosted:Thu Mar 29, 2018 8:58 am
by pavila
Please, take a look at the documentation https://docs.openkm.com/kcenter/view/ok ... aller.html

Regards.