Installation OpenKM-6.3.6 on MariaDB 10.1.25

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.
Post Reply
fhoernchen
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: Sat Mar 17, 2018 12:28 pm

Installation OpenKM-6.3.6 on MariaDB 10.1.25

Post by fhoernchen » Sat Mar 17, 2018 12:40 pm

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

jllort
Moderator
Moderator
Posts: 9896
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: Installation OpenKM-6.3.6 on MariaDB 10.1.25

Post by jllort » Sun Mar 18, 2018 6:59 pm

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.

fhoernchen
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: Sat Mar 17, 2018 12:28 pm

Re: Installation OpenKM-6.3.6 on MariaDB 10.1.25

Post by fhoernchen » Mon Mar 26, 2018 12:29 pm

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

jllort
Moderator
Moderator
Posts: 9896
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: Installation OpenKM-6.3.6 on MariaDB 10.1.25

Post by jllort » Wed Mar 28, 2018 3:25 pm

Database might be "mariadb" or "mysql", you have set "Database : openkm" what is wrong type.

fhoernchen
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: Sat Mar 17, 2018 12:28 pm

Re: Installation OpenKM-6.3.6 on MariaDB 10.1.25

Post by fhoernchen » Wed Mar 28, 2018 5:50 pm

oh damn, thanks!

pavila
Moderator
Moderator
Posts: 3045
Joined: Tue Dec 11, 2007 6:02 pm
Location: Alicante, Spain
Contact:

Re: Installation OpenKM-6.3.6 on MariaDB 10.1.25

Post by pavila » Thu Mar 29, 2018 8:58 am

Please, take a look at the documentation https://docs.openkm.com/kcenter/view/ok ... aller.html

Regards.

Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests