I went one step back, because I realized, that the config tool tris to connect to the DB and doesn't get a connection.
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'