Installer does not create DB structure & content

Use this forum for questions regarding installation, upgrading and configuration of OpenEMM

Moderator: moderator

GOT intermedia
Posts: 22
Joined: Wed Oct 23, 2019 11:10 am

Installer does not create DB structure & content

Post by GOT intermedia »

Hi there,

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
How do we get the installer to import the correct SQL files in correct order?
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
maschoff
Site Admin
Posts: 2596
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Installer does not create DB structure & content

Post by maschoff »

When you install a frontend package with the OpenEMMInstaller, the database content is checked and missing SQL files are executed.

If you are in doubt, simply re-install the frontend package and watch the CLI output.
OpenEMM Maintainer
GOT intermedia
Posts: 22
Joined: Wed Oct 23, 2019 11:10 am

Re: Installer does not create DB structure & content

Post by GOT intermedia »

maschoff wrote: Wed Oct 23, 2019 4:19 pm When you install a frontend package with the OpenEMMInstaller, the database content is checked and missing SQL files are executed.

If you are in doubt, simply re-install the frontend package and watch the CLI output.
Re-installing the frontend did the job perfectly. Thanks alot!
Post Reply