OpenEMM Support

I try to install OpenEMM 2019 on CentOS 7 in VPS of OVH. I follow all the process of https://wiki.openemm.org/lib/exe/fetch. ... _1.0.3.pdf in combination with this https://wiki.openemm.org/doku.php. When I start OpenEMMInstaller.sh, don't detect the DB.I use MariaDB for DB and SendMail for MTA.

Anyone knows why I have this Error?
Thanks

I have three errors.

Image -> https://drive.google.com/file/d/1-BeWfh ... sp=sharing


When I run OpenEMMInstaller.sh for first time, I dont have any error and it works correctly, but when I try to change options, i can't do anything.
OpenEMM configure automaticaly the name of DB to openemm but no create the structure. All time I have error in configuration of db and MARK in red the host (127.0.0.1). I only know how to create the structure of db, import it or anything only for continue in the installation.
emmProperties error I don't know why i have it. I don't have information of this in wiki.

Thank you!

Now you can see the image.
Sorry

Hello again,
I try to do it another time but I have one error now. Can I do anything for copy of anysite the structure of DB? Is the only error what I have.

https://drive.google.com/file/d/1q9K5_T ... sp=sharing

Can you help me?
Rewards

Hossa™

I had the problem yesterday with the latest installer too.
The database was set up correctly and the user had full access to the DB.
But he did NOT create the database structure when installing.
There was an error that -p is a wrong argument and therefore the installation of the structure is aborted.
When I then wanted to import the SQL files manually he issued a syntax error at csv_import_tbl and at another table a , was missing.
The last one I could solve by setting the missing one.

In the end the installation didn't work because the database wasn't filled properly.

Please provide the exact error message you get and the name and version of the database software you use.

Currently I have deleted the installation.
I will try again this weekend.
Then collect all error messages and post them here.

Hi,

I have the same failure for OpenEMM 2019 on CentOS 7 in VPS with only CWP installed on it. I follow the instructions of "Install & Admin Guide
for OpenEMM 2019 (19.04.000)"
I get those errors when I select "Show OpenEMM status" from the main menu of the installer:
I==========================
= OpenEMM Installer v2.7 =
==========================
Root mode: On
Host: mail.mydomain.com
Runtime Version: 19.10.004
Manual Version: Unknown
OpenEMM Version: 19.04.000.482
System-Url: http://mail.mydomain.com:8080
OpenEMMBackend Version: 19.04.000.462

Current menu: Show OpenEMM status

OpenEMM status:
Command 'backend.sh status' returned non-zero exit status 127
Operating System (OS): CentOS 7
Python version: 2.7.5 (default, Aug 7 2019, 00:51:29) [GCC 4.8.5 20150623 (Red Hat 4.8.5-39)]
Postfix Version: 2.10.1
DB client version: /usr/bin/mysql Ver 15.1 Distrib 10.1.41-MariaDB, for Linux (x86_64) using readline 5.1
Database Connection: OK
Database version: MariaDB 10.1.41-MariaDB
OpenEMM database structure does NOT exist
Currently running database threads ratio (Current: 1, Maximum: 2): 0.5
Java version: 1.8.0_222 (OpenJDK)
Java JCE Unlimited-Key-Strength: OK
Tomcat version: 9.0.24.0
Wkhtml version: wkhtmltopdf 0.12.5 (with patched qt)
OpenEMMApplication is running (Tomcat ProcessID: 21094, started at: أكت08 4:09)
Error while checking for Backend running
Exception: Command 'backend.sh status' returned non-zero exit status 127
Error: <class 'subprocess.CalledProcessError'>

and when i try to install the frontend from the installer I get this error message:

"Creating basic database structure ...
Unknown suffix 'p' used for variable 'port' (value 'port')
/bin/mysql: Error while setting value 'port' to 'port'"

any idea?
Thank you

Did you create file dbcfg like desscribed in the OpenEMM wiki? If so, could you post its content here (without your password)?

yes the dbcfg is filled as described below

Current menu: Change database configuration (dbcfg)

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 = xxxxxxxxx
user = user

with user have All MySQL privileges .

regards

Hello,

What version of the mysql client software do you use?
Detect it with:
# mysql -V

The parameter -p is used for the password as parameter when calling mysql to execute the fullldb sql script to create the database structure.

Older versions of mysql do not allow this parameter for security reasons and demand password user input via console, which is not supported by our OpenEMMInstaller tool by now.

Thank you for your answer,
below is tha answer concerning the mysql client software:
# mysql -V
mysql Ver 15.1 Distrib 10.1.41-MariaDB, for Linux (x86_64) using readline 5.1

if it's the case of Older versions of mysql, have you any suggestion ? MariaDB 10.1 is supported according to Install & Admin Guide
for OpenEMM 2019 (19.04.000).

Thank you

This version should do.
So there is another point: Does your password include an "'" (apostrophe) ?
because the syntax of the mysql client is as follows:
mysql -u <username> -p'<password>' <dbname>
Maybe you could change your password to something more simple, just for some testing?

hi,

I've imported manually the sql files to the openemm DB, actually openemm works fine except the statistic field: when I open the page the down frame show this message: "Not Found The requested URL /birt/run was not found on this server." for all the statistic tasks available in this field.

note that in the Dashbord the "Statistics Overview" works fine...

have you any idea about this problem?

regards