下載 openkm modified tomcat bundle

https://sourceforge.net/projects/openkm/files/common/

下載網址

https://www.openkm.com/en/download.html
download releases binary → war file

修改 OpenKM.cfg

uncomment following
hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

初次安裝

注意 OpenKM.cfg 下面是否為 create

hibernate.hbm2ddl=create

初次開啟網址後，

系統會建立資料庫表格，然後會自動將 hibernate.hbm2ddl 改為 none

修改 content.xml

Add

    <!-- OpenKM resources -->
    <ResourceLink global="jdbc/OpenKMDS" name="jdbc/OpenKMDS" type="javax.sql.DataSource"/>
    <ResourceLink global="mail/OpenKM" name="mail/OpenKM" type="javax.mail.Session"/>

modify server.xml

comment all others resource that are not used

<!-- <Resource name="jdbc/OpenKMDS" auth="Container" type="javax.sql.DataSource"
            maxTotal="100" maxIdle="30" maxWaitMillis="10000" validationQuery="select 1 from INFORMATION_SCHEMA.SYSTEM_USERS"
            username="sa" password="" driverClassName="org.hsqldb.jdbcDriver"
            url="jdbc:hsqldb:${catalina.home}/repository/okmdb"/> -->

Add

	<Resource name="jdbc/OpenKMDS" auth="Container" type="javax.sql.DataSource"
          maxActive="100" maxIdle="30" maxWait="10000" validationQuery="select 1"
          username="openkm" password="igen2egin" driverClassName="org.mariadb.jdbc.Driver"
          url="jdbc:mariadb://localhost:3306/okmdb?useSSL=false&amp;autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=UTF8"/>

modify port

    <Connector port="8080" address="0.0.0.0" protocol="HTTP/1.1"
               connectionTimeout="20000" redirectPort="8443" />

Add setenv.sh into \bin

JAVA_OPTS="$JAVA_OPTS -Xms256m -Xmx2048m -XX:+UseConcMarkSweepGC -Djava.awt.headless=true" JAVA_OPTS="$JAVA_OPTS -Dlog4j.configuration=file://$CATALINA_HOME/conf/log4j.properties" JAVA_OPTS="$JAVA_OPTS -Dfile.encoding=UTF-8 -Dsun.jnu.encoding=UTF-8 -Dmail.mime.ignoreunknownencoding=true" CATALINA_PID=$CATALINA_HOME/catalina.pid export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$CATALINA_HOME/lib/sigar

install mariadb

Creat user & database

CREATE USER 'openkm'@'localhost' IDENTIFIED BY 'MY_PASSWORD'; CREATE DATABASE okmdb DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_bin; GRANT ALL ON okmdb.* TO 'openkm'@'localhost' WITH GRANT OPTION;

import database

sudo mariadb -h localhost -u root -p okmdb < /path/to/restore/okmdb.sql

初次登入OpenKM

帳號：okmAdmin
密碼：admin

安裝mysql or mariadb

$ sudo apt-get install mysql-server
# or
$ sudo apt-get install mariadb-server

建立資料庫

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;

若JAVA 記憶體不足

修改 home/zon/tomcat-8.5.24/bin/setenv.sh

-Xmx2048m 加大-Xmx4096m

啟動tomcat

nohup /home/zon/tomcat-8.5.24/bin/startup.sh ＆

備份

mysql

mysqldump -u 'openkm' -p'd6g981a0' okmdb | gzip > /home/zon/db/openkm_db_$bakDates.gz

datastore

位置

/home/zon/tomcat-8.5.24/repository/datastore

{{% notice style="info" %}} 注意： 備份時，直接備份 tomcat-8.5.24 資料夾，上面修改部份就不需要做了 {{% /notice %}}

還原備份

mysql -u openkm -p okmdb < [sql_file]