database connect via "as anonymous"

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

Moderator: moderator

webflow
Posts: 2
Joined: Mon Aug 19, 2019 3:26 pm

database connect via "as anonymous"

Post by webflow » Mon Aug 19, 2019 3:36 pm

Hello,

I have problems with the databse connection.

By running the update with OpenEMMInstaller.sh :: Install or update package from local file
it seems the application is not using the password.

Logfile mariadb:
----
...
Connect openemm@localhost as anonymous on openemm
...
----

Stored configuration is:
----
Database configuration for openemm:
dbms = mariadb
host = 127.0.0.1
jdbc-connect = jdbc:mariadb://127.0.0.1/openemm?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=UTF-8
jdbc-driver = org.mariadb.jdbc.Driver
name = openemm
password = **********
user = openemm
----

Seems like I have done something wrong in the installation process.

Many thanks in advance

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

Re: database connect via "as anonymous"

Post by maschoff » Tue Aug 20, 2019 4:42 pm

Your stored configuration looks fine. If you select menu 1, do you get any error reports?
OpenEMM Maintainer

webflow
Posts: 2
Joined: Mon Aug 19, 2019 3:26 pm

Re: database connect via "as anonymous"

Post by webflow » Wed Aug 21, 2019 2:25 pm

errors are:
----
Jobqueue status: 8 errorneous jobs (BirtReports, LoginTrackTableCleaner, CalendarCommentMailingService, ...)
----


full output:
----
OpenEMM status:
OS version: CentOS Linux release 7.6.1810 (Core)
Python version: 2.7.5 (default, Jun 20 2019, 20:27:34) [GCC 4.8.5 20150623 (Red Hat 4.8.5-36)]
Postfix Version: 2.10.1
DB client version: /usr/local/bin/mysql Ver 15.1 Distrib 10.2.22-MariaDB, for Linux (x86_64) using EditLine wrapper
Database Connection: OK
Database version: MariaDB 10.2.22-MariaDB-log
OpenEMM database structure exists (Version 18.07.640)
Currently running database threads ratio (Current: 1, Maximum: 4): 0.25
Database table emm_db_errorlog_tbl: OK
Jobqueue status: 8 errorneous jobs (BirtReports, LoginTrackTableCleaner, CalendarCommentMailingService, ...)
No DKIM keys
Java version: 1.8.0_222 (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 running (Tomcat ProcessID: 31384, started at: 15:20 3:44)
----

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

Re: database connect via "as anonymous"

Post by maschoff » Thu Aug 22, 2019 9:55 am

The output of the backend status is missing. Do you use an older version of the runtime package/OpenEMMInstaller?
OpenEMM Maintainer

Post Reply