• Installation OpenKM-6.3.6 on MariaDB 10.1.25

  • Problems with installing OpenKM? No problemo, the solution is closer than you think.
Problems with installing OpenKM? No problemo, the solution is closer than you think.
Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
 #45469  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
 #45476  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.
 #45536  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

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.