Installation OpenSuSE Tumbleweed - 23.04 Problems

[hwcgdt]

Hi all,

I got some issues with the fresh installation of 23.04 on OpenSuSE Tumbleweed.
Some I could resolve:
- Installation of additional packages even with ignoring of some dependencies (wkhtmltopdf, mariadb-connector-python3 for example)
- Adding the mariadb as dbms in the dbcfg file to avoid a crash with 'sid' error

but now I try to type in the web server address and I get at the prompt an error saying:
"Please enter system.url (with protocol, e.g.: https://my.openemm.net)
> https://openemm.mydomain.mytld
TypeError: '>' not supported between instances of 'NoneType' and 'int'"

It looks like the program is using the prompt (">") as part of the input - which is obviously wrong.

Any hints?

Thanks
Hartmut

[Wkn]

For a quick Fix:
On Line 27 in /EMT_lib/ConfigurationMenu.py (usually located at /home/openemm/scripts/)

replace

Code: Select all

birtKeysExist = DbConnector.selectValue("SELECT COUNT(*) FROM config_tbl WHERE class = 'birt' and name = 'privatekey' AND value != '[to be defined]' AND (hostname IS NULL OR TRIM(hostname) = '' OR hostname = ?)", Environment.hostname) > 0

with:

Code: Select all

birtKeys = DbConnector.selectValue("SELECT COUNT(*) FROM config_tbl WHERE class = 'birt' and name = 'privatekey' AND value != '[to be defined]' AND (hostname IS NULL OR TRIM(hostname) = '' OR hostname = ?)", Environment.hostname)
birtKeysExist = birtKeys is not None and birtKeys > 0

[hwcgdt]

Doesn't work.
Still the same message.

[Wkn]

Could you please try it again with the command OMT.sh -debug and share the output?

[hwcgdt]

I went one step back, because I realized, that the config tool tris to connect to the DB and doesn't get a connection.
So step1 - trying to setup the DB (blank installation)

Code: Select all

=================================================
= OpenEMM Maintenance Tool (OMT) v23.04.000.205 =
=================================================
Debug mode: On
Hostname: server5
Free diskspace: 46.2 % (of 1860.39 GiB)
ERROR:root:Error in checkDbConnection
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 548, in checkDbConnection
    connection = openDbConnection()
                 ^^^^^^^^^^^^^^^^^^
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 299, in openDbConnection
    raise Exception("Invalid database type: " + dbcfgEntry["dbms"])
Exception: Invalid database type: 
OpenEMM Runtime Version: 23.04.000.205
OpenEMM Version: Unknown
ERROR:root:Error in checkDbConnection
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 548, in checkDbConnection
    connection = openDbConnection()
                 ^^^^^^^^^^^^^^^^^^
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 299, in openDbConnection
    raise Exception("Invalid database type: " + dbcfgEntry["dbms"])
Exception: Invalid database type: 
System-Url: Unknown

Invalid database vendor in dbcfg: 
No MTA (sendmail or postfix) is installed
Database Connection cannot be established. (Maybe database user or database connection parameters for OpenEMM were not configured)
Database is not running or host is invalid. Please configure.

Current menu: Change configuration of database connection

Database configuration for openemm:
 dbms = 
 host = localhost
 name = openemm
 password = 
 user = 

Please choose entry name to change (Blank => Back):
 > dbms
Please enter new value for key 'dbms' (Allowed values are 'mariadb', 'mysql'): 
 > mariadb
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/OMT.py", line 163, in <module>
    main()
  File "/home/openemm_2023-04/tomcat10/bin/OMT.py", line 154, in main
    menu.show()
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/Menu.py", line 48, in show
    intermediateStartMenu.show(startMenu)
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/Menu.py", line 48, in show
    intermediateStartMenu.show(startMenu)
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/Menu.py", line 167, in show
    self.actionParameters = self.action(self.actionParameters)
                            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbManagementMenu.py", line 150, in dbcfgMenuAction
    Environment.unsavedDbcfgChanges.pop("sid")
KeyError: 'sid'

Now trying to create a manual file with content like this:

Code: Select all

openemm: dbms=mariadb, host=localhost, user={MYADMINUSER}, password={MYPASSWDHASH}, name=openemm, jdbc-connect=jdbc:mariadb://localhost:3306/openemm?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=UTF-8

Now I go to step two, where the config program cannot connect to the DB - which exists and is connectable.

Code: Select all

=================================================
= OpenEMM Maintenance Tool (OMT) v23.04.000.205 =
=================================================
Debug mode: On
Hostname: server5
Free diskspace: 46.2 % (of 1860.39 GiB)
ERROR:root:Error in checkDbConnection
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 524, in checkDbConnection
    if not dbcfgEntry["jdbc-driver"] == "org.mariadb.jdbc.Driver":
           ~~~~~~~~~~^^^^^^^^^^^^^^^
KeyError: 'jdbc-driver'
OpenEMM Runtime Version: 23.04.000.205
OpenEMM Version: Unknown
ERROR:root:Error in checkDbConnection
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 524, in checkDbConnection
    if not dbcfgEntry["jdbc-driver"] == "org.mariadb.jdbc.Driver":
           ~~~~~~~~~~^^^^^^^^^^^^^^^
KeyError: 'jdbc-driver'
System-Url: Unknown

No MTA (sendmail or postfix) is installed
Database Connection cannot be established. (Maybe database user or database connection parameters for OpenEMM were not configured)
Basic configuration is missing. Please configure.

Current menu: Change basic configuration

SQL: INSERT INTO config_tbl (class, name, value, creation_date, change_date, description) VALUES (%s, %s, %s, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'Changed by Maintenance Tool')
Parameters: ('system', 'url', '[to be defined]')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/lib64/python3.11/site-packages/mariadb/cursors.py", line 314, in execute
    self._execute_binary()
mariadb.OperationalError: Unknown column 'creation_date' in 'field list'
SQL: INSERT INTO config_tbl (class, name, value, creation_date, change_date, description) VALUES (%s, %s, %s, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'Changed by Maintenance Tool')
Parameters: ('system', 'defaultRdirDomain', '[to be defined]')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/lib64/python3.11/site-packages/mariadb/cursors.py", line 314, in execute
    self._execute_binary()
mariadb.OperationalError: Unknown column 'creation_date' in 'field list'
SQL: INSERT INTO config_tbl (class, name, value, creation_date, change_date, description) VALUES (%s, %s, %s, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'Changed by Maintenance Tool')
Parameters: ('system', 'defaultMailloopDomain', '[to be defined]')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/lib64/python3.11/site-packages/mariadb/cursors.py", line 314, in execute
    self._execute_binary()
mariadb.OperationalError: Unknown column 'creation_date' in 'field list'
SQL: INSERT INTO config_tbl (class, name, value, creation_date, change_date, description) VALUES (%s, %s, %s, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'Changed by Maintenance Tool')
Parameters: ('birt', 'url', '[to be defined]')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/lib64/python3.11/site-packages/mariadb/cursors.py", line 314, in execute
    self._execute_binary()
mariadb.OperationalError: Unknown column 'creation_date' in 'field list'
SQL: INSERT INTO config_tbl (class, name, value, creation_date, change_date, description) VALUES (%s, %s, %s, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'Changed by Maintenance Tool')
Parameters: ('birt', 'privatekey', '[to be defined]')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/lib64/python3.11/site-packages/mariadb/cursors.py", line 314, in execute
    self._execute_binary()
mariadb.OperationalError: Unknown column 'creation_date' in 'field list'
SQL: INSERT INTO config_tbl (class, name, value, creation_date, change_date, description) VALUES (%s, %s, %s, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'Changed by Maintenance Tool')
Parameters: ('birt', 'publickey', '[to be defined]')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/lib64/python3.11/site-packages/mariadb/cursors.py", line 314, in execute
    self._execute_binary()
mariadb.OperationalError: Unknown column 'creation_date' in 'field list'
SQL: INSERT INTO config_tbl (class, name, value, creation_date, change_date, description) VALUES (%s, %s, %s, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'Changed by Maintenance Tool')
Parameters: ('webservices', 'url', '[to be defined]')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/lib64/python3.11/site-packages/mariadb/cursors.py", line 314, in execute
    self._execute_binary()
mariadb.OperationalError: Unknown column 'creation_date' in 'field list'
SQL: INSERT INTO config_tbl (class, name, value, creation_date, change_date, description) VALUES (%s, %s, %s, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'Changed by Maintenance Tool')
Parameters: ('mailaddress', 'bounce', '[to be defined]')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/lib64/python3.11/site-packages/mariadb/cursors.py", line 314, in execute
    self._execute_binary()
mariadb.OperationalError: Unknown column 'creation_date' in 'field list'
SQL: INSERT INTO config_tbl (class, name, value, creation_date, change_date, description) VALUES (%s, %s, %s, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'Changed by Maintenance Tool')
Parameters: ('mailaddress', 'error', '[to be defined]')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/lib64/python3.11/site-packages/mariadb/cursors.py", line 314, in execute
    self._execute_binary()
mariadb.OperationalError: Unknown column 'creation_date' in 'field list'
SQL: INSERT INTO config_tbl (class, name, value, creation_date, change_date, description) VALUES (%s, %s, %s, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'Changed by Maintenance Tool')
Parameters: ('mailaddress', 'feature_support', '[to be defined]')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/lib64/python3.11/site-packages/mariadb/cursors.py", line 314, in execute
    self._execute_binary()
mariadb.OperationalError: Unknown column 'creation_date' in 'field list'
SQL: INSERT INTO config_tbl (class, name, value, creation_date, change_date, description) VALUES (%s, %s, %s, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'Changed by Maintenance Tool')
Parameters: ('mailaddress', 'frontend', '[to be defined]')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/lib64/python3.11/site-packages/mariadb/cursors.py", line 314, in execute
    self._execute_binary()
mariadb.OperationalError: Unknown column 'creation_date' in 'field list'
SQL: INSERT INTO config_tbl (class, name, value, creation_date, change_date, description) VALUES (%s, %s, %s, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'Changed by Maintenance Tool')
Parameters: ('mailaddress', 'replyto', '[to be defined]')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/lib64/python3.11/site-packages/mariadb/cursors.py", line 314, in execute
    self._execute_binary()
mariadb.OperationalError: Unknown column 'creation_date' in 'field list'
SQL: INSERT INTO config_tbl (class, name, value, creation_date, change_date, description) VALUES (%s, %s, %s, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'Changed by Maintenance Tool')
Parameters: ('mailaddress', 'report_archive', '[to be defined]')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/lib64/python3.11/site-packages/mariadb/cursors.py", line 314, in execute
    self._execute_binary()
mariadb.OperationalError: Unknown column 'creation_date' in 'field list'
SQL: INSERT INTO config_tbl (class, name, value, creation_date, change_date, description) VALUES (%s, %s, %s, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'Changed by Maintenance Tool')
Parameters: ('mailaddress', 'sender', '[to be defined]')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/lib64/python3.11/site-packages/mariadb/cursors.py", line 314, in execute
    self._execute_binary()
mariadb.OperationalError: Unknown column 'creation_date' in 'field list'
SQL: INSERT INTO config_tbl (class, name, value, creation_date, change_date, description) VALUES (%s, %s, %s, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'Changed by Maintenance Tool')
Parameters: ('mailaddress', 'support', '[to be defined]')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/lib64/python3.11/site-packages/mariadb/cursors.py", line 314, in execute
    self._execute_binary()
mariadb.OperationalError: Unknown column 'creation_date' in 'field list'
SQL: INSERT INTO config_tbl (class, name, value, creation_date, change_date, description) VALUES (%s, %s, %s, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'Changed by Maintenance Tool')
Parameters: ('mailaddress', 'upload.database', '[to be defined]')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/lib64/python3.11/site-packages/mariadb/cursors.py", line 314, in execute
    self._execute_binary()
mariadb.OperationalError: Unknown column 'creation_date' in 'field list'
SQL: INSERT INTO config_tbl (class, name, value, creation_date, change_date, description) VALUES (%s, %s, %s, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'Changed by Maintenance Tool')
Parameters: ('mailaddress', 'upload.support', '[to be defined]')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/lib64/python3.11/site-packages/mariadb/cursors.py", line 314, in execute
    self._execute_binary()
mariadb.OperationalError: Unknown column 'creation_date' in 'field list'
SQL: INSERT INTO config_tbl (class, name, value, creation_date, change_date, description) VALUES (%s, %s, %s, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'Changed by Maintenance Tool')
Parameters: ('mailaddress', 'info.cleaner', '[to be defined]')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/lib64/python3.11/site-packages/mariadb/cursors.py", line 314, in execute
    self._execute_binary()
mariadb.OperationalError: Unknown column 'creation_date' in 'field list'
SQL: INSERT INTO config_tbl (class, name, value, creation_date, change_date, description) VALUES (%s, %s, %s, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'Changed by Maintenance Tool')
Parameters: ('mailout', 'ini.domain', '[to be defined]')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/lib64/python3.11/site-packages/mariadb/cursors.py", line 314, in execute
    self._execute_binary()
mariadb.OperationalError: Unknown column 'creation_date' in 'field list'
ERROR:root:Error in checkDbConnection
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 524, in checkDbConnection
    if not dbcfgEntry["jdbc-driver"] == "org.mariadb.jdbc.Driver":
           ~~~~~~~~~~^^^^^^^^^^^^^^^
KeyError: 'jdbc-driver'
Set essential configuration properties

Please enter system.url (with protocol, e.g.: https://my.openemm.net)
 > https://openemm.MYDOMAIN.TLD
SQL: SELECT COUNT(*) FROM config_tbl WHERE class = %s AND name = %s AND hostname = %s
Parameters: ('system', 'url', 'server5')
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/lib64/python3.11/site-packages/mariadb/cursors.py", line 311, in execute
    self._readresponse()
mariadb.OperationalError: Unknown column 'hostname' in 'where clause'
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/OMT.py", line 163, in <module>
    main()
  File "/home/openemm_2023-04/tomcat10/bin/OMT.py", line 154, in main
    menu.show()
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/Menu.py", line 48, in show
    intermediateStartMenu.show(startMenu)
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/Menu.py", line 48, in show
    intermediateStartMenu.show(startMenu)
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/Menu.py", line 167, in show
    self.actionParameters = self.action(self.actionParameters)
                            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/ConfigurationMenu.py", line 18, in configTableMenuAction
    DbConnector.updateConfigurationValueInDB("system", "url", choice, Environment.hostname)
  File "/home/openemm_2023-04/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'

So, where to start - I guess DB connection

[maschoff]

By now cou can download runtime 23.04.000.215. Does it fix your problem?

[hwcgdt]

I did download and restartet.
But I'm not sure if it really helps.

I got the first installation menu

Code: Select all

./OMT.sh
Checking python installation ...
Python version found: 3.11.5 (/usr/bin/python3)
Checking Zip installation ...
Zip version 3.0 found
Starting python ...
Do you want to activate a TLS certificate (https) for OpenEMM? (N/y, Blank => Cancel):
 > 

 
=================================================
= OpenEMM Maintenance Tool (OMT) v23.04.000.215 =
=================================================
Hostname: server5
Free diskspace: 44.9 % (of 1860.39 GiB)
OpenEMM Runtime Version: 23.04.000.215
OpenEMM Version: Unknown
System-Url: Unknown

Current menu: Configure basic environment (Java, Tomcat, Tomcat-Native, Wkhtml, Proxy)

Current webapp basic configuration:
 JAVA_HOME:     /usr/lib64/jvm/java
 CATALINA_HOME: /opt/agnitas.com/software/tomcat
 Tomcat-Native: None
 WKHTMLTOPDF:   /opt/agnitas.com/software/wkhtmltox/bin/wkhtmltopdf
 WKHTMLTOIMAGE: /opt/agnitas.com/software/wkhtmltox/bin/wkhtmltoimage
 PROXY:         None

Please choose entry to change (Blank => Back):
 > 

Then switch back to Main menu and selected the DB setup.
There I placed all values which seems to be taken correctly this time.
Then I answered the question about creation of a new database with "yes" and then it stopped working - the database was not created or filled.
And the following errors show that it doesn't find the correct tables/columns/fields, which is correct.

Code: Select all

=================================================
= OpenEMM Maintenance Tool (OMT) v23.04.000.215 =
=================================================
Debug mode: On
Hostname: myserver
Free diskspace: 25.0 % (of 100000.0 GiB)
SQL: SELECT data FROM license_tbl WHERE name = 'LicenseData'
Parameters: ()
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/lib64/python3.11/site-packages/mariadb/cursors.py", line 311, in execute
    self._readresponse()
mariadb.ProgrammingError: Table 'openemm.license_tbl' doesn't exist
OpenEMM Runtime Version: 23.04.000.215
OpenEMM Version: Unknown
SQL: SELECT value FROM config_tbl WHERE class = 'system' AND name = 'url' AND (hostname IS NULL OR TRIM(hostname) = '' OR hostname = %s)
Parameters: ('myserver',)
ERROR:root:executeSql
Traceback (most recent call last):
  File "/home/openemm_2023-04/tomcat10/bin/EMT_lib/DbConnector.py", line 413, in executeSql
    cursor.execute(sqlStatement, tuple(parameterList))
  File "/usr/lib64/python3.11/site-packages/mariadb/cursors.py", line 311, in execute
    self._readresponse()
mariadb.ProgrammingError: Table 'openemm.config_tbl' doesn't exist
System-Url: Unknown

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

Current menu: Change basic configuration

So I am not quite sure how to proceed. Should the pure database exist (blank but database there) with the user setup as a DB admin (all rights granted) so that it will be filled by that step, or should it exist from a step before? I also can't find any sql files that could setup a kickstart DB.

[aso]

There is a Problem in OpenEMM Runtime package with detecting the available OpenEMM tables in the database. It says there are tables where there are none.
This problem will be fixed in OpenEMM Runtime 23.10.000.216+ (and later)
It is available for tests at:
openemm-runtime-23.04.000.217.tar.gz
https://share.agnitas.de/index.php/s/A6 ... 7/download

[hwcgdt]

So I tried and it was a small success, because it can configure the database without crash and connect to create a new database. But the database is still empty, so every other point trying to write vales to the DB will fail.

[clox]

Same problems on a fresh CentOS Stream8 installation.

Is OpenEMM still in active development?

[JuergenB]

CentOS Stream 8 is not supported, try AlmaLinux 8.

With AlmaLinux 8.x 23.04 runs fine and installation can be done in a few minutes.
Even AlmaLinux 9.2 is fine, but needs some other settings.

[clox]

Thanks for your reply.
I tried again with alma8 (that was also my first installation try indeed).
But it fails at the same step as mentioned by OP. Do I need to apply the "quick fix" as suggested by @Wkn also on alma8? Or am i supposed to use the runtime v217?
Thanks again for clarification,
Christian

[JuergenB]

Hi,

the last installation that i used for installation was openemm-runtime-23.04.016.tar.gz
I have tried a few of the new release versions, but some have new and old problems.

i checked with my installation script for Almalinux 8.8.

23.04.016 and 23.04.000.217 will install fine.

I just tried to install with AlmaLinux 9.3 and mariadb 10.6.8 and runtime 23.10.000.131 is fine.

Thanks to aso

[hwcgdt]

Hi everybody

is there any news or updates available?

Thanks

Regards
Hartmut

[clox]

Hi,
I recommend you use 23.10
Installation on Alma much more smooth.
https://www.agnitas.de/en/services-supp ... m-runtime/ is valid for the new version though it says 23.04.

Cheers
Christian