Installation OpenSuSE Tumbleweed - 23.04 Problems

Use this forum for questions regarding installation, upgrading and configuration of OpenEMM

Moderator: moderator

hwcgdt
Posts: 14
Joined: Tue Aug 13, 2019 2:48 pm

Installation OpenSuSE Tumbleweed - 23.04 Problems

Post by 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
"Most of the time the problem is 1 meter in front of the screen" (unknown support center employee) :D
Wkn
Posts: 4
Joined: Fri Jan 27, 2023 3:30 pm

Re: Installation OpenSuSE Tumbleweed - 23.04 Problems

Post by 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
Posts: 14
Joined: Tue Aug 13, 2019 2:48 pm

Re: Installation OpenSuSE Tumbleweed - 23.04 Problems

Post by hwcgdt »

Doesn't work.
Still the same message.
"Most of the time the problem is 1 meter in front of the screen" (unknown support center employee) :D
Wkn
Posts: 4
Joined: Fri Jan 27, 2023 3:30 pm

Re: Installation OpenSuSE Tumbleweed - 23.04 Problems

Post by Wkn »

Could you please try it again with the command OMT.sh -debug and share the output?
hwcgdt
Posts: 14
Joined: Tue Aug 13, 2019 2:48 pm

Re: Installation OpenSuSE Tumbleweed - 23.04 Problems

Post by 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
"Most of the time the problem is 1 meter in front of the screen" (unknown support center employee) :D
maschoff
Site Admin
Posts: 2591
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Installation OpenSuSE Tumbleweed - 23.04 Problems

Post by maschoff »

By now cou can download runtime 23.04.000.215. Does it fix your problem?
OpenEMM Maintainer
hwcgdt
Posts: 14
Joined: Tue Aug 13, 2019 2:48 pm

Re: Installation OpenSuSE Tumbleweed - 23.04 Problems

Post by 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.
"Most of the time the problem is 1 meter in front of the screen" (unknown support center employee) :D
aso
Posts: 32
Joined: Fri Jun 19, 2015 12:43 pm

Re: Installation OpenSuSE Tumbleweed - 23.04 Problems

Post by 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
Posts: 14
Joined: Tue Aug 13, 2019 2:48 pm

Re: Installation OpenSuSE Tumbleweed - 23.04 Problems

Post by 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.
"Most of the time the problem is 1 meter in front of the screen" (unknown support center employee) :D
clox
Posts: 3
Joined: Fri Dec 08, 2023 10:20 am

Re: Installation OpenSuSE Tumbleweed - 23.04 Problems

Post by clox »

Same problems on a fresh CentOS Stream8 installation.

Is OpenEMM still in active development?
JuergenB
Posts: 136
Joined: Thu Dec 05, 2019 9:03 pm

Re: Installation OpenSuSE Tumbleweed - 23.04 Problems

Post by 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
Posts: 3
Joined: Fri Dec 08, 2023 10:20 am

Re: Installation OpenSuSE Tumbleweed - 23.04 Problems

Post by 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
Posts: 136
Joined: Thu Dec 05, 2019 9:03 pm

Re: Installation OpenSuSE Tumbleweed - 23.04 Problems

Post by 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 :D
hwcgdt
Posts: 14
Joined: Tue Aug 13, 2019 2:48 pm

Re: Installation OpenSuSE Tumbleweed - 23.04 Problems

Post by hwcgdt »

Hi everybody

is there any news or updates available?

Thanks

Regards
Hartmut
"Most of the time the problem is 1 meter in front of the screen" (unknown support center employee) :D
clox
Posts: 3
Joined: Fri Dec 08, 2023 10:20 am

Re: Installation OpenSuSE Tumbleweed - 23.04 Problems

Post by 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
Post Reply