Empty Database after installing OpenEMM 2019

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

Moderator: moderator

moechsner
Posts: 11
Joined: Wed Apr 17, 2013 12:15 am

Empty Database after installing OpenEMM 2019

Post by moechsner »

After installing the OpenEMM 2019 and configurate, i cant login. Then i look at the Database and see that there a 165 tables but the most are empty only the messages_tbl have 5340 and some others have 1-143 but the most are empty.

Have you a Example sql that i can install so i can login?

with the OpenEMMInstaller menu 2 and than sub-menu 7 it find no Client ID

Thank you
maschoff
Site Admin
Posts: 2597
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Empty Database after installing OpenEMM 2019

Post by maschoff »

It is ok that most table are empty initially.

Does file dbcfg exist in ~/etc with correct values?

Check Tomcat's log catalina.out for any error messages at startup time.

If there are error messages and it is not clear to you, what went wrong, post the messages here and provide the numbers of the runtime and frontend version of OpenEMM you use.
OpenEMM Maintainer
moechsner
Posts: 11
Joined: Wed Apr 17, 2013 12:15 am

Re: Empty Database after installing OpenEMM 2019

Post by moechsner »

Thank you.

When some table are empty ok, but here are the admin_tbl, client_tbl, all company..._tbl are empty. How i can login when this are empty?
Have you a example that i can fill this?

dbcfg exists and is correct.

The Versions are:
openemm-runtime-19.04.086.tar.gz
Frontend: 19.04.000.315

In Tomcat i see no errors only WARN and Info:

09-Jun-2019 22:56:06.594 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [:/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib]
09-Jun-2019 22:56:06.812 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
09-Jun-2019 22:56:06.851 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]
09-Jun-2019 22:56:06.858 INFO [main] org.apache.catalina.startup.Catalina.load Server initialization in [1,006] milliseconds
09-Jun-2019 22:56:06.896 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
09-Jun-2019 22:56:06.896 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat]
09-Jun-2019 22:56:09.152 INFO [main] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
2019-06-09 22:56:34,564: WARN [main] com.agnitas.emm.core.report.generator.factory.TableGeneratorFactory - TableGenerator [CSV_GENERATOR] already registered and will be ignored
2019-06-09 22:56:34,567: WARN [main] com.agnitas.emm.core.report.generator.factory.TableGeneratorFactory - TableGenerator [TXT_GENERATOR] already registered and will be ignored
09-Jun-2019 22:56:36.521 INFO [main] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
09-Jun-2019 22:57:11.233 INFO [main] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
09-Jun-2019 22:57:21.292 SEVERE [main] org.apache.catalina.core.StandardContext.startInternal One or more Filters failed to start. Full details will be found in the appropriate container log file
09-Jun-2019 22:57:21.292 SEVERE [main] org.apache.catalina.core.StandardContext.startInternal Context [/birt] startup failed due to previous errors
09-Jun-2019 22:57:21.336 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
09-Jun-2019 22:57:21.345 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"]
09-Jun-2019 22:57:21.347 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in [74,488] milliseconds

When i look for Status, OpenEMM is stoped, in OpenEMMInstaller then i get this Output:

OpenEMM status:
OS version: CentOS Linux release 7.6.1810 (Core)
Python version: 2.7.5 (default, Apr 9 2019, 14:30:50) [GCC 4.8.5 20150623 (Red Hat 4.8.5-36)]
Postfix Version: 2.10.1
DB client version: /bin/mysql Ver 15.1 Distrib 10.3.15-MariaDB, for Linux (x86_64) using readline 5.1
Database Connection: OK
Database version: MariaDB 10.3.15-MariaDB
OpenEMM database structure exists (Version 19.01.550)
Currently running database threads ratio (Current: 6, Maximum: 6): 1.0
Database table emm_db_errorlog_tbl: OK
Jobqueue status: OK
No DKIM keys
Java version: 1.8.0_212 (OpenJDK)
Java JCE Unlimited-Key-Strength: OK
Tomcat version: 9.0.16.0
Wkhtml version: wkhtmltopdf 0.12.5 (with patched qt)
OpenEMM-Application is NOT running


Thanks and best regards Michael
moechsner
Posts: 11
Joined: Wed Apr 17, 2013 12:15 am

Re: Empty Database after installing OpenEMM 2019

Post by moechsner »

ok I have found the error and solved the user problem with the password.

There are no Informations in your Installation and the SQL for admin or the other Tables

So I logged in directly to the database and created 2 admins and filled the tables:
admin_tbl, admin_permission_tbl and the company_tbl with some data i have from the OpenEMM 2015 after this i was able to change the PW and loged in.
But there are a lot other tables, new one, that i dont know how to fill, have you a documentation for thie?

Thanks and best regards.

Michael
maschoff
Site Admin
Posts: 2597
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Empty Database after installing OpenEMM 2019

Post by maschoff »

This line shows that there is something wrong with your Tomcat installaton:

Code: Select all

09-Jun-2019 22:57:21.292 SEVERE [main] org.apache.catalina.core.StandardContext.startInternal One or more Filters failed to start. Full details will be found in the appropriate container log file
Did you install Tomcat with OpenEMMInstaller? Or do you have your own installation? If so, which version?

There is absolutely no need to fill the database manually. Did you create an initial password for main user “emm-master” in menu “3 Security”?
OpenEMM Maintainer
moechsner
Posts: 11
Joined: Wed Apr 17, 2013 12:15 am

Re: Empty Database after installing OpenEMM 2019

Post by moechsner »

Hy, thank you.

yes i installed it with the OpenEMMInstaller on a total new System.

I create a initial Password for emm-master but the Problem was that the admin_tbl was empty so it dont save it.

I think the problem was the mariadb because i have the 10.3 and your system have Problems with the mysql.prev i saw this when i want to install some of your sql per phpmyadmin. I think it would be better when you write that to do the steps for MariaDB DBMS only if you have no mariadb. After mysql_upgrade the prev was no problem.

I have now install the OpenEMM new, i have renamed the database and the folder openemm.
In the Database everythink is now ok, but when i will go to OpenEMM i get only the Apache Tomcat page.

When i find the error i will tell it to you.

Thanks and best regards

Michael
moechsner
Posts: 11
Joined: Wed Apr 17, 2013 12:15 am

Re: Empty Database after installing OpenEMM 2019

Post by moechsner »

ok now i made a new installation on a new blank Server with Centos 7.6 Apache php 7.3 mariadb 10.3 postfix and froxlor.
from your wiki i install only gcc, python, java, xorg-x11-fonts-75dpi zlib fontconfig freetype libX11 libXext libXrender urw-fonts, MySQL-python, wkhtmltox

i made the changes for the main.cf and master.cf for postfix

Than i install your OpenEMM and now everything is running fine.
I have all tables have the admin.....

So it is important that you either take an empty system and install everything according to your plan,
but then only the OpenEMM will run on the server.

When you will install OpenEMM on a server that is also used differently, it is important that you install all extra and in the Firewall dont take the forward from port 80 to 8080
Post Reply