Problem installing code packages 23.10

[wupperi]

This is my status:

Operating System (OS): Alma 9
Python version: 3.9.18
DBCFG: OK
Postfix Version: 3.5.9
Database client version: /usr/bin/mariadb Ver 15.1 Distrib 10.6.16-MariaDB, for Linux (x86_64) using EditLine wrapper
Database Connection: OK
System-Time: 2024-01-24 15:09:53
System-Time-DB: 2024-01-24 15:09:53
Database version: MariaDB 10.6.16-MariaDB
OpenEMM database structure does NOT exist
Java version: 17.0.8 (Oracle)
Tomcat version: 10.1.15.0
Tomcat-Native version: Undefined
Wkhtml version:
OpenEMM Application is NOT running
Frontend application integrity: ERROR
Statistics application integrity: ERROR
Webservices application integrity: ERROR

When selecting menu item 5, the maintenace tool downloads the package, but then after npm install stops with exceptions:

SQL: SELECT COUNT(*) FROM release_log_tbl WHERE application_name = 'EMM'
Parameters: ()
ERROR:root:executeSql
Traceback (most recent call last):
File "/home/openemm/tomcat10/bin/EMT_lib/DbConnector.py", line 425, in executeSql
cursor.execute(sqlStatement, tuple(parameterList))
File "/usr/local/lib64/python3.9/site-packages/mariadb/cursors.py", line 311, in execute
self._readresponse()
mariadb.ProgrammingError: Table 'openemm.release_log_tbl' doesn't exist
SQL: SELECT COUNT(*) FROM release_log_tbl WHERE application_name = %s AND version_number REGEXP CONCAT('^0*', %s, '.0*', %s, '.000(.[0-9]+)*$')
Parameters: ('EMM', 23, 10)
ERROR:root:executeSql
Traceback (most recent call last):
File "/home/openemm/tomcat10/bin/EMT_lib/DbConnector.py", line 425, in executeSql
cursor.execute(sqlStatement, tuple(parameterList))
File "/usr/local/lib64/python3.9/site-packages/mariadb/cursors.py", line 311, in execute
self._readresponse()
mariadb.ProgrammingError: Table 'openemm.release_log_tbl' doesn't exist
SQL: SELECT COUNT(*) FROM release_log_tbl WHERE application_name = %s AND version_number REGEXP CONCAT('^0*', %s, '.0*', %s, '.000(.[0-9]+)*$')
Parameters: ('EMM', 23, 4)
ERROR:root:executeSql
Traceback (most recent call last):
File "/home/openemm/tomcat10/bin/EMT_lib/DbConnector.py", line 425, in executeSql
cursor.execute(sqlStatement, tuple(parameterList))
File "/usr/local/lib64/python3.9/site-packages/mariadb/cursors.py", line 311, in execute
self._readresponse()
mariadb.ProgrammingError: Table 'openemm.release_log_tbl' doesn't exist
ERROR:root:Error while deploying update package (Log: /root/release/log/update_2024-01-24_15-14-26.log)
Traceback (most recent call last):
File "/home/openemm/tomcat10/bin/EMT_lib/InstallAndUpdateMenu.py", line 2103, in installFileFromWebsite
installFile(downloadDestinationFilePath, logfile, interactive)
File "/home/openemm/tomcat10/bin/EMT_lib/InstallAndUpdateMenu.py", line 227, in installFile
installFile(temporaryExtractionDirectory + "/" + listedFile, logfile, interactive)
File "/home/openemm/tomcat10/bin/EMT_lib/InstallAndUpdateMenu.py", line 1017, in installFile
EMTUtilities.createLink(updatedApplicationDirectoryPath, "/home/openemm/webapps/emm", "openemm")
File "/home/openemm/tomcat10/bin/EMT_lib/EMTUtilities.py", line 141, in createLink
os.symlink(referencedPath, linkPath)
FileExistsError: [Errno 17] File exists: '/home/openemm/release/emm/openemm-gui-23.10.000.152' -> '/home/openemm/webapps/emm'
Traceback (most recent call last):
File "/home/openemm/tomcat10/bin/OMT.py", line 187, in <module>
main()
File "/home/openemm/tomcat10/bin/OMT.py", line 178, in main
menu.show()
File "/home/openemm/tomcat10/bin/EMT_lib/Menu.py", line 209, in show
availableSubMenus[choice - 1].show()
File "/home/openemm/tomcat10/bin/EMT_lib/Menu.py", line 167, in show
self.actionParameters = self.action(self.actionParameters)
File "/home/openemm/tomcat10/bin/EMT_lib/InstallAndUpdateMenu.py", line 1643, in siteUpdateMenuAction
installFileFromWebsite(True)
File "/home/openemm/tomcat10/bin/EMT_lib/InstallAndUpdateMenu.py", line 2103, in installFileFromWebsite
installFile(downloadDestinationFilePath, logfile, interactive)
File "/home/openemm/tomcat10/bin/EMT_lib/InstallAndUpdateMenu.py", line 227, in installFile
installFile(temporaryExtractionDirectory + "/" + listedFile, logfile, interactive)
File "/home/openemm/tomcat10/bin/EMT_lib/InstallAndUpdateMenu.py", line 1017, in installFile
EMTUtilities.createLink(updatedApplicationDirectoryPath, "/home/openemm/webapps/emm", "openemm")
File "/home/openemm/tomcat10/bin/EMT_lib/EMTUtilities.py", line 141, in createLink
os.symlink(referencedPath, linkPath)
FileExistsError: [Errno 17] File exists: '/home/openemm/release/emm/openemm-gui-23.10.000.152' -> '/home/openemm/webapps/emm'

Corresponding logfile:

Update started at: 2024-01-24_15:14:26
Update package url: https://share.agnitas.de/index.php/s/Mz ... x/download
Update package file: openemm-runtime-23.10.000.150.tar.gz
Declined installation of version '23.10.000.150' for application 'runtime'
Update package url: https://share.agnitas.de/index.php/s/6B ... 7/download
Update package file: openjdk-java-17.0.8-linux-x64.tar.gz
Declined installation of version '17.0.8' for application 'java'
Update package url: https://share.agnitas.de/index.php/s/Nd ... y/download
Update package file: apache-tomcat-10.1.15.tar.gz
Declined installation of version '10.1.15' for application 'tomcat'
Update package url: https://share.agnitas.de/index.php/s/dx ... A/download
Update package file: openemm-code-23.10.000.152.tar.gz
Removed already existing file '/tmp/openemm-code-23.10.000.152.tar.gz'
Downloaded to file '/tmp/openemm-code-23.10.000.152.tar.gz'
Installing "/tmp/openemm-code-23.10.000.152.tar.gz"
Installing "/tmp/Emm_2024-01-24_15-15-16/openemm-gui-23.10.000.152.tar.gz"
Removed already existing directory '/home/openemm/release/emm/openemm-gui-23.10.000.152'
Removed already existing file '/home/openemm/release/emm/openemm-gui-23.10.000.152.tar.gz'
Extracted file '/home/openemm/release/emm/openemm-gui-23.10.000.152.tar.gz' in path '/home/openemm/release/emm/openemm-gui-23.10.000.152'
Updated npm packages
Error while deploying update package (Log: /root/release/log/update_2024-01-24_15-14-26.log)
Update ended at: 2024-01-24_15:16:31

apparently there is an issue with symbolic link creation, but not entirely sure. find / grep on links did't show any links at all.
Stuck at this point and no idea.
Any help is appreciated.

[wupperi]

ok. Found the solution: Problably due to an older, stalled install, I had the path /home/openemm/webapps/emm in my install dir.
This should not be there.

removing the path solved the issue.

[maschoff]

Thanks for posting the solution!