OpenEMM Support

looking at the OpenEMMInstaller.py file, starting at line 827 I see this:

827 if portStartIndex > 0:
828 port = int(host[portStartIndex + 1:])
829 host = host[0:portStartIndex]
830 else:
831 port = 3306
832
833 sqlUpdateReturnCode = os.system(Environment.dbClientPath + " -h " + host + " -P ...

From your output I see that you do not have defined the System URL like it is explained in the OpenEMM Wiki. Please do not skip steps described in the documentation.

Hello, thank you for your patience.

Setting the system url is in section 5 (configuration) of the install wiki. Since I'm getting ...

Do you really use "openemm_db_user" as DB user name? Please try "openemm" instead as mentioned in the OpenEMM Wiki.

I changed the database user name to "openemm" using the installer then ran option 4 again. I get the same error.

Unknown suffix 'p' used for variable 'port' (value 'port')
/opt/rh ...

Hello, here is the dbcfg file:

# cat 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_db_user, jdbc-driver=org.mariadb.jdbc.Driver, password=123456

I noticed on this forum post ( https://forum.openemm.org/viewtopic.php?f=2&t=5185 ) that someone has the same error, " Unknown suffix 'p' used for variable 'port' (value 'port') ".

The user says that it can be due to the mariadb version. I am running the version installed using "yum install rh ...

Hi, thank you for your assistance and patience.

There was some progress, but I still get errors with the database:

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


*** Error report for ...

I think you forget to install the OpenEMM backend and frontend. Have a look at section 4.4 of the OpenEMM Wiki: https://wiki.openemm.org/doku.php#frontend_and_backend_deployment

I did try that, but it doesn't work for me. Section 4.4 says to run the installer then choose menu 4 or 5.

I run the ...

Looks like there might be some files missing. The OpenEMMInstaller.py file references an sql file during the database setup:

fullDbScriptSuccess = Utilities.executeSqlScriptFile(Environment.applicationUserWebappsDirectory + "/emm/WEB-INF/sql/mysql/emm-mysql-fulldb-basic.sql")

But there is no such ...

Hi.

I'm using centos 7.7 and following the procedure in https://wiki.openemm.org/doku.php

I'm using mariadb and sendmail.

After downloading openemm-runtime-19.07.011.tar.gz and extracting it in /home/openemm, I run the OpenEMMInstaller.sh file in ~/bin.

I get prompted for the database setup info ...