runtime 23.04.024 , 23.04.000.205 AND 23.04.000.213 are messed up

[JuergenB]

I tested the new runtime version openemm-runtime-23.04.000.213 today.
It fails even with the simplest configuration steps.
After configuring the environment variables, the database is created.
The next step would be to create the basic configuration.

But this is where the runtime version falls flat on its face.

I get the following error message after the database is created and the runtime would process to the next step

Code: Select all

=================================================
= OpenEMM Maintenance Tool (OMT) v23.04.000.213 =
=================================================
Root mode: On
Hostname: localhost.localdomain
Free diskspace: 89.6 % (of 27.78 GiB)
OpenEMM Runtime Version: 23.04.000.213
OpenEMM Version: Unknown
System-Url: Unknown

Current configuration changes or updates need the OpenEMM system to be restarted.

Current menu: Change basic configuration

TypeError: '>' not supported between instances of 'NoneType' and 'int'
[root@localhost native]#

Well, version 23.04.04 worked at least to some extent.
Even if the creation of the server.xml with the certificates failed.

Here is the debug ..

Code: Select all

[root@localhost bin]# ./OMT.sh -debug
Checking python installation ...
Python version found: 3.9.16 (/usr/bin/python3)
Checking Zip installation ...
Zip version 3.0 found
Starting python ...
ERROR:root:Cannot detect SendmailVersion
Traceback (most recent call last):
  File "/home/openemm/tomcat10/bin/EMT_lib/EMTUtilities.py", line 529, in getSendmailVersion
    allSendmailVersions = subprocess.check_output("rpm -qa | grep -i sendmail 2>/dev/null", shell=True).decode("UTF-8")
  File "/usr/lib64/python3.9/subprocess.py", line 424, in check_output
    return run(*popenargs, stdout=PIPE, timeout=timeout, check=True,
  File "/usr/lib64/python3.9/subprocess.py", line 528, in run
    raise CalledProcessError(retcode, process.args,
subprocess.CalledProcessError: Command 'rpm -qa | grep -i sendmail 2>/dev/null' returned non-zero exit status 1.
SQL: SELECT COUNT(*) FROM agn_dbversioninfo_tbl WHERE 1 = 0
Parameters: ()
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/local/lib64/python3.9/site-packages/mariadb/cursors.py", line 307, in execute
    self._readresponse()
mariadb.ProgrammingError: Table 'openemm.agn_dbversioninfo_tbl' doesn't exist
SQL: SELECT class, name, hostname, value FROM config_tbl WHERE (hostname IS NULL OR TRIM(hostname) = '' OR hostname = %s) AND class = %s AND name = %s
Parameters: ('localhost.localdomain', 'system', 'wkhtmltopdf')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/local/lib64/python3.9/site-packages/mariadb/cursors.py", line 307, in execute
    self._readresponse()
mariadb.ProgrammingError: Table 'openemm.config_tbl' doesn't exist
ERROR:root:Error in readConfigurationValueFromDB
Traceback (most recent call last):
  File "/home/openemm/tomcat10/bin/EMT_lib/DbConnector.py", line 763, in readConfigurationValueFromDB
    for row in result:
TypeError: 'NoneType' object is not iterable
SQL: SELECT class, name, hostname, value FROM config_tbl WHERE (hostname IS NULL OR TRIM(hostname) = '' OR hostname = %s) AND class = %s AND name = %s
Parameters: ('localhost.localdomain', 'system', 'wkhtmltoimage')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/local/lib64/python3.9/site-packages/mariadb/cursors.py", line 307, in execute
    self._readresponse()
mariadb.ProgrammingError: Table 'openemm.config_tbl' doesn't exist
ERROR:root:Error in readConfigurationValueFromDB
Traceback (most recent call last):
  File "/home/openemm/tomcat10/bin/EMT_lib/DbConnector.py", line 763, in readConfigurationValueFromDB
    for row in result:
TypeError: 'NoneType' object is not iterable
SQL: SELECT COUNT(*) FROM config_tbl WHERE class = %s AND name = %s AND hostname = %s
Parameters: ('system', 'wkhtmltopdf', 'localhost.localdomain')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/local/lib64/python3.9/site-packages/mariadb/cursors.py", line 307, in execute
    self._readresponse()
mariadb.ProgrammingError: Table 'openemm.config_tbl' doesn't exist
Traceback (most recent call last):
  File "/home/openemm/tomcat10/bin/OMT.py", line 163, in <module>
    main()
  File "/home/openemm/tomcat10/bin/OMT.py", line 89, in main
    Environment.init()
  File "/home/openemm/tomcat10/bin/EMT_lib/Environment.py", line 155, in init
    Environment.readSystemValues()
  File "/home/openemm/tomcat10/bin/EMT_lib/Environment.py", line 827, in readSystemValues
    DbConnector.updateConfigurationValueInDB("system", "wkhtmltopdf", Environment.wkhtmltopdf, Environment.hostname)
  File "/home/openemm/tomcat10/bin/EMT_lib/DbConnector.py", line 785, in updateConfigurationValueInDB
    itemExists = selectValue("SELECT COUNT(*) FROM config_tbl WHERE class = ? AND name = ? AND hostname = ?", configClass, configName, hostname) > 0
TypeError: '>' not supported between instances of 'NoneType' and 'int'

and openemm-runtime-23.04.000.205.tar.gz is not any better

Code: Select all

Please choose entry name to change (Blank => Back):
 > dbms
Please enter new value for key 'dbms' (Allowed values are 'mariadb', 'mysql'):
 > mariadb
KeyError: 'sid'
[root@localhost native]#

At least 23.04.024 works somehow.
certificate and server.xml are not proper

[hwcgdt]

How you get the version 23.04.04 - or in common - how can you download one special version? I only have the chance to download from the link, no repository to select a special version?

Yes, 23.04.000.205 is buggy with the URL.
Where are the config files placed and can you post examples (mask the values with example strings)?

Would be nice to be at least able to start the system and search errors in the system instead of sitting with a "not even configurable" piece of python software.

[JuergenB]

I don´t download a special version.

I started with a 21.0x Release in the past and everytime there is an upgrade available
i copy these from the release folder of my working instance to a backup folder.

So i got some runtime release to start testing.

Release 23.04.024 can be used to install a base system.
But the tomcat server.xml has errors, after correcting these the system is up an running.

23.10 is a beta and might not be able to be used for a reinstallation.

The last installer has faulty server.xml.template

[maschoff]

Thanks for reporting, we will look into that.

[Wkn]

Hello, the bug with the invalid entries in the server.xml should be fixed with the version 23.04.000.214