OpenEMM Technical Support Forum

The purpose of these forums is to get and give free technical support for OpenEMM. Spammers and their posts will be removed without prior warning.
https://forum.openemm.org/

Installer does not create DB structure & content

https://forum.openemm.org/viewtopic.php?t=5224

Page 1 of 1

Installer does not create DB structure & content

Posted: Wed Oct 23, 2019 2:40 pm
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

Re: Installer does not create DB structure & content

Posted: Wed Oct 23, 2019 4:19 pm
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.

Re: Installer does not create DB structure & content

Posted: Thu Oct 24, 2019 12:42 pm
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!
All times are UTC+01:00
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited