the installer in our case does create the DB user an the DB itself, but it does not create the DB structure and content. The DB remains empty. We tried everything without success.
Any help appreciated. Thanks in advance!
Code: Select all
==========================
= OpenEMM Installer v2.7 =
==========================
Host: XXXXXXX.de
Runtime Version: 19.10.004
Manual Version: Unknown
OpenEMM Version: 19.04.000.482
System-Url: http:// XXXXXXX.de
OpenEMMBackend Version: 19.04.000.441
Code: Select all
SQL files available:
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/userrights.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-create-initial-password.sh
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-create-database.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-create-user.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-execute-missing-updates.sh
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-fulldb-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-messages.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-messages-deleted.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-messages-openemm.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-18.10.039-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-18.10.041-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-18.10.060-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-18.10.068-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-18.10.074-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-18.10.111-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-18.10.134-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-18.10.146-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-18.10.147-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-18.10.180-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-18.10.199-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-18.10.263-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-18.10.268-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-18.10.286-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-18.10.357-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-18.10.369-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-18.10.381-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-18.10.415-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-18.10.461-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-18.10.474-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-18.10.490.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-18.10.493-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-19.01.013-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-19.01.038-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-19.01.140-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-19.01.155-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-19.01.234-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-19.01.241-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-19.01.243-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-19.01.255-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-19.01.303-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-19.01.432-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-19.01.433-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-19.01.545-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-19.01.550-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-19.04.000.325-basic.sql
/home/openemm/release/emm/openemm-gui-19.04.000.482/WEB-INF/sql/mysql/emm-mysql-update-19.04.000.365-basic.sql
Or can we import those files manually? In which order?
System: CentOS Linux release 7.7.1908 (Core)
DB: rh-mariadb102-mariadb-server or rh-mariadb103-mariadb-server (same result)
/home/openemm/etc/dbcfg:
openemm: dbms=mariadb, name=openemm, jdbc-connect=jdbc:mariadb://127.0.0.1/openemm?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=UTF-8, host=127.0.0.1, user=openemm, jdbc-driver=org.mariadb.jdbc.Driver, password=XXXXXXX