1. It would be interesting to know the errors you found in the doc.
mmh, maybe it was my fault. usally i install Python 3.8 (without DBMS module) first and then these files i should create at page 14 already exists.
So i changed the installation today and installed first Mariadb as described in chapter 5.1
The the files i should create do not exist (page 14).
Then i installed Python 3.8 and finally added the DBMS modul.
I still don´t understand, why the admin guide is jumping between the chapter, it would be much easier to have a linear installation guide.
Describe the installation of DBMS and then Python 3.8 with all requirements.
OK, so i did it againg and checked the installation order (first DBMS, then python 3.8 and last the DBMS python module).
2. We have two independent trainees who managed to install OpenEMM by following the guide.
Can they use a scratch AlmaLinux 8.5 with minimal software selection AND follow guide word by word?
3. We have migrated our servers to AlmaLinux and I can report that it is running fine.
a migration from CentOs Stream to 21.10 is fine for my installation, this works.
But not a clean installation, maybe try a installation from scratch.
4. I wonder how OpenEMM can state that MariaDB is not installed. Maybe you meant OMT? If so, which menu reports this with which wording?
Yes, you are right. It´s the OMT complaining about.
After following the admin guide 1.0.5 step by step and starting OMT i can configure the envirement (java, tomcat, etc. installs fine).
I can configure dbms but i can´t create the database.
OMT v21.10.044 give me this error message
Code: Select all
=============================================
= OpenEMM Maintenance Tool (OMT) v21.10.044 =
=============================================
Root mode: On
Hostname: localhost.localdomain
OpenEMM Runtime Version: 21.10.044
OpenEMM Version: Unknown
System-Url: Unknown
Database client (mariadb) is missing, therefore some menu items are not availabe
Changes saved.
Database and user do not exist and cannot be created. Please create database and user yourself.
i can execute mariadb or mysql at the shell and get the mariadb console
Any idea what is missing in the installation guide?
For 21.04 i always use the CentOs mariadb installation and no tarball.
If i upgrade to mariadb with the default installation to
Ver 15.1 Distrib 10.5.13--MariaDB
I have no errors in configuring OpenEMM with OMT.
Code: Select all
curl -LsS -O https://downloads.mariadb.com/MariaDB/mariadb_repo_setup
sudo bash mariadb_repo_setup --mariadb-server-version=10.5
sudo dnf repolist
sudo dnf -y module reset mariadb
sudo dnf install MariaDB-server MariaDB-client MariaDB-backup
sudo dnf info MariaDB-server
sudo systemctl enable --now mariadb
systemctl status mariadb
sudo systemctl restart mariadb
With mariadb 10.8 the installation fails during sql script execution
Code: Select all
Executing /home/openemm/webapps/emm/WEB-INF/sql/mysql/emm-mysql-messages.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mysql/emm-mysql-messages-deleted.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mysql/emm-mysql-messages-openemm.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mysql/emm-mysql-update-21.01.197-basic.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mysql/emm-mysql-update-21.01.420-basic.sql
ERROR 1060 (42S21) at line 11: Duplicate column name 'origin'
Error while executing /home/openemm/webapps/emm/WEB-INF/sql/mysql/emm-mysql-update-21.01.420-basic.sql
SQL database updates caused an error. Press any key to continue.
Thanks
Jürgen