Runtime 22.10.014 gives KeyError: 'openemm'

[JuergenB]

Hi,

i tried a clean installation with Runtime Release 22.10.014

I still get this error after starting OMT at AlmaLinux 9.1

Code: Select all

[root@localhost bin]# pwd
/home/openemm/bin
[root@localhost bin]# ./OMT.sh
Checking python installation ...
Python version found: 3.9.14 (/usr/bin/python3)
Checking Zip installation ...
Zip version 3.0 found
Starting python ...
KeyError: 'openemm'

I use a snapshot of the VM.
The next step (after the snapshot) in the installation is to unpack the runtime and start the OMT.sh script.

21.10.044 does not cause any problems.
Only the 22.10.*** does not work.

[maschoff]

OpenEMM does not support AlmaLinux 9 yet.

[JuergenB]

Hi,
i just checked with AlmaLinux 8.7 and CentOS 8.0 and i get the same error.

I use with AlmaLinux

Code: Select all

Python 3.8.13
pip 23.0 from /usr/local/lib/python3.8/site-packages/pip (python 3.8)
mysql  Ver 15.1 Distrib 10.3.35-MariaDB
openemm-runtime-22.10.014.tar.gz

openemm-runtime-22.04.008.tar.gz works fine with 8.7 and CentOs

[JuergenB]

Success ...

I started with openemm-runtime-22.04.008.tar.gz
After a complete setup with AlmaLinux 9.1 most of the update with 22.10.014 was ok.
Some Errors in OMT.sh during exiting of OMT, but finally it works with AlmaLinux 9.1

[aso]

Could you please start OMT in debug modus and tell me what is the response?
Use command:
OMT.sh -debug

[JuergenB]

New installation from scratch with AlmaLinux 9.1
I used openemm-runtime-22.10.014.tar.gz

[root@localhost bin]# ./OMT.sh -debug
Checking python installation ...
Python version found: 3.9.14 (/usr/bin/python3)
Checking Zip installation ...
Zip version 3.0 found
Starting python ...
Traceback (most recent call last):
File "/home/openemm/tomcat10/bin/OMT.py", line 158, in <module>
main()
File "/home/openemm/tomcat10/bin/OMT.py", line 81, in main
Environment.init()
File "/home/openemm/tomcat10/bin/EMT_lib/Environment.py", line 154, in init
Environment.readSystemValues()
File "/home/openemm/tomcat10/bin/EMT_lib/Environment.py", line 315, in readSystemValues
DbConnector.dbcfgEntry = DbConnector.dbcfgProperties[DbConnector.applicationDbcfgEntryName]
KeyError: 'openemm'

Same as openemm user

[openemm@localhost bin]$ ./OMT.sh -debug
Checking python installation ...
Python version found: 3.9.14 (/usr/bin/python3)
Checking Zip installation ...
Zip version 3.0 found
Starting python ...
Traceback (most recent call last):
File "/home/openemm/tomcat10/bin/OMT.py", line 158, in <module>
main()
File "/home/openemm/tomcat10/bin/OMT.py", line 81, in main
Environment.init()
File "/home/openemm/tomcat10/bin/EMT_lib/Environment.py", line 154, in init
Environment.readSystemValues()
File "/home/openemm/tomcat10/bin/EMT_lib/Environment.py", line 303, in readSystemValues
DbConnector.dbcfgEntry = DbConnector.dbcfgProperties[DbConnector.applicationDbcfgEntryName]
KeyError: 'openemm'

[maschoff]

Please post the content of your dbcfg file (without password).

[JuergenB]

This is the dbcfg in a clean installation

Code: Select all

emm: dbms=, host=localhost, user=, password=, name=openemm

[aso]

Problem is, that your system is missing the entry "openemm" in your dbcfg file which was generated initially.
To solve this you may change the name in dbcfg from "emm:" to "openemm:".

Alternativly you can wait for the following versions where the OMT will be fixed to come around this problem:
OpenEMM Version 22.10.000.192
OpenEMM Runtime Version 22.10.015

[JuergenB]

Thanks,
after changing this to openemm, i got another error

Code: Select all

=============================================
= OpenEMM Maintenance Tool (OMT) v22.10.014 =
=============================================
Debug mode: On
Root mode: On
Hostname: localhost.localdomain
SQL: SELECT data FROM license_tbl WHERE name = 'LicenseData'
Parameters: ()
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm/tomcat10/bin/EMT_lib/DbConnector.py", line 359, in executeSql
    connection = openDbConnection()
  File "/home/openemm/tomcat10/bin/EMT_lib/DbConnector.py", line 290, in openDbConnection
    raise Exception("Invalid database type: " + dbcfgEntry["dbms"])
Exception: Invalid database type:
Traceback (most recent call last):
  File "/home/openemm/tomcat10/bin/OMT.py", line 158, in <module>
    main()
  File "/home/openemm/tomcat10/bin/OMT.py", line 149, in main
    menu.show()
  File "/home/openemm/tomcat10/bin/EMT_lib/Menu.py", line 49, in show
    intermediateStartMenu.show(startMenu)
  File "/home/openemm/tomcat10/bin/EMT_lib/Menu.py", line 49, in show
    intermediateStartMenu.show(startMenu)
  File "/home/openemm/tomcat10/bin/EMT_lib/Menu.py", line 70, in show
    if License.getLicenseName() != None:
  File "/home/openemm/tomcat10/bin/EMT_lib/License.py", line 86, in getLicenseName
    return License.getLicenseValue("licenseHolder")
  File "/home/openemm/tomcat10/bin/EMT_lib/License.py", line 67, in getLicenseValue
    License.readLicenseValues()
  File "/home/openemm/tomcat10/bin/EMT_lib/License.py", line 17, in readLicenseValues
    data = DbConnector.selectValue("SELECT data FROM license_tbl WHERE name = 'LicenseData'")
  File "/home/openemm/tomcat10/bin/EMT_lib/DbConnector.py", line 349, in selectValue
    for row in select(sqlSelect, *parameters):
TypeError: 'NoneType' object is not iterable