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
database connect via "as anonymous"
Moderator: moderator
-
- Site Admin
- Posts: 2628
- Joined: Thu Aug 03, 2006 10:20 am
- Location: Munich, Germany
- Contact:
Re: database connect via "as anonymous"
Your stored configuration looks fine. If you select menu 1, do you get any error reports?
OpenEMM Maintainer
Re: database connect via "as anonymous"
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)
----
----
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)
----
-
- Site Admin
- Posts: 2628
- Joined: Thu Aug 03, 2006 10:20 am
- Location: Munich, Germany
- Contact:
Re: database connect via "as anonymous"
The output of the backend status is missing. Do you use an older version of the runtime package/OpenEMMInstaller?
OpenEMM Maintainer