i installed successfully Openemm 19.04 on a CentOS System. Now i'm struggling with the upgrade to the latest version. I'm running the OpenEMMInstaller and now im get the following Output on Startup the script
Code: Select all
================================
= OpenEMM Installer v20.10.018 =
================================
Root mode: On
Host: vm5031206.psmanaged.com
License: OpenEMM (ID: 0)
Runtime Version: 20.10.028
Manual Version: Unknown
OpenEMM Version: 20.10.000.049
System-Url: Unknown
OpenEMMBackend Version: 20.10.000.047
But on Startup i get following error:
Code: Select all
Traceback (most recent call last):
File "/home/openemm/scripts/service3.py", line 23, in <module>
from agn3.config import Config
File "/home/openemm/release/backend/V20.10.000.047/scripts/agn3/config.py", line 22, in <module>
from .dblite import DBLite
File "/home/openemm/release/backend/V20.10.000.047/scripts/agn3/dblite.py", line 17, in <module>
from ._db.sqlite import Layout, SQLite3
ImportError: cannot import name 'Layout' from 'agn3._db.sqlite' (/home/openemm/release/backend/V20.10.000.047/scripts/agn3/_db/sqlite.py)
Starting ...
Traceback (most recent call last):
File "/home/openemm/scripts/service3.py", line 23, in <module>
from agn3.config import Config
File "/home/openemm/release/backend/V20.10.000.047/scripts/agn3/config.py", line 22, in <module>
from .dblite import DBLite
File "/home/openemm/release/backend/V20.10.000.047/scripts/agn3/dblite.py", line 17, in <module>
from ._db.sqlite import Layout, SQLite3
ImportError: cannot import name 'Layout' from 'agn3._db.sqlite' (/home/openemm/release/backend/V20.10.000.047/scripts/agn3/_db/sqlite.py)
Using /home/openemm/bin/setenv.sh
Using additional properties: /home/openemm/tomcat9/bin/emm.sh.additional.properties
Checking backend directories
Traceback (most recent call last):
File "/home/openemm/scripts/activator3.py", line 19, in <module>
from agn3.dblite import DBLite, Layout
File "/home/openemm/release/backend/V20.10.000.047/scripts/agn3/dblite.py", line 17, in <module>
from ._db.sqlite import Layout, SQLite3
ImportError: cannot import name 'Layout' from 'agn3._db.sqlite' (/home/openemm/release/backend/V20.10.000.047/scripts/agn3/_db/sqlite.py)
Service sanity is marked as inactive.
Code: Select all
2020-10-05 11:06:30,606: ERROR [main] org.agnitas.emm.core.commons.util.ConfigService - Cannot refresh config data from database
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [DELETE FROM license_tbl WHERE change_date < ? OR change_date IS NULL]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'change_date' in 'where clause'
I reinstalled the forntend/backend and get no errors from the update.log
Code: Select all
Sql db update scripts successfully executed
DB update executed
Installing "/tmp/Emm_2020-10-05_10-24-35/openemm-statistics-20.10.000.049.tar.gz"
Removed already existing directory '/home/openemm/release/statistics/openemm-statistics-20.10.000.049'
Removed already existing file '/home/openemm/release/statistics/openemm-statistics-20.10.000.049.tar.gz'
Extracted file '/home/openemm/release/statistics/openemm-statistics-20.10.000.049.tar.gz' in path '/home/openemm/release/statistics/openemm-statistics-20.10.000.049'
Created new application link 'statistics'
Installing "/tmp/Emm_2020-10-05_10-24-35/openemm-webservices-20.10.000.049.tar.gz"
Removed already existing directory '/home/openemm/release/webservices/openemm-webservices-20.10.000.049'
Removed already existing file '/home/openemm/release/webservices/openemm-webservices-20.10.000.049.tar.gz'
Extracted file '/home/openemm/release/webservices/openemm-webservices-20.10.000.049.tar.gz' in path '/home/openemm/release/webservices/openemm-webservices-20.10.000.049'
Created new application link 'webservices'
Installing "/tmp/Emm_2020-10-05_10-24-35/openemm-backend-20.10.000.047.tar.gz"
Extracted file '/home/openemm/release/backend/openemm-backend-20.10.000.047.tar.gz' in path '/home/openemm/release/backend/V20.10.000.047'
Created new backend symlinks
Update ended at: 2020-10-05_10:24:54