Search found 65 matches

by JuergenB
Sat Feb 27, 2021 8:21 pm
Forum: Installation & Upgrades
Topic: Foreign key constraint is incorrectly formed
Replies: 3
Views: 251

Re: Foreign key constraint is incorrectly formed

Thanks, i did a DB dump at 20.10 installation and modified the dump process in 20.04. So i was able to dump a database from 20.04 release. Next i dumped the 20.04 database and imported the 20.04 dump within mariadb @ the 20.10 system. I started the rutime 20.10 and did a full reinstall of the backen...
by JuergenB
Mon Feb 22, 2021 4:30 pm
Forum: Installation & Upgrades
Topic: Foreign key constraint is incorrectly formed
Replies: 3
Views: 251

Re: Foreign key constraint is incorrectly formed

I tried again with backup and restore from 20.04 into 20.10 i droped the live db 20.10 and created a empty one to /root/... Next i tried to restore, this failed with an error, so i used the shell and this command. [root@localhost bin]# mysql -u openemm -h localhost openemm -p'********' < /root/opene...
by JuergenB
Mon Feb 22, 2021 3:59 pm
Forum: Installation & Upgrades
Topic: Foreign key constraint is incorrectly formed
Replies: 3
Views: 251

Foreign key constraint is incorrectly formed

Hello, if i want to backup/dump from 20.04 and restore to 20.10 i get this erro message during restore. Foreign key constraint is incorrectly formed Any idea how to fix 20.04 database? ERROR 1005 (HY000) at line 35: Can't create table `openemm`.`actop_content_view_tbl` (errno: 150 "Foreign key ...
by JuergenB
Mon Feb 22, 2021 1:07 pm
Forum: Installation & Upgrades
Topic: OpenEmm 20.10, empty Logfiles in AdministrationSystem StatusShow EMM Logfile
Replies: 1
Views: 263

OpenEmm 20.10, empty Logfiles in AdministrationSystem StatusShow EMM Logfile

Hi,

after a clean Install of 20.04 and Upgrade to 20.10 with CentOs 8 and Java 11 i only see an empty Logfile Screen.

AdministrationSystem -> StatusShow -> EMM Logfile

Is this by design?
by JuergenB
Mon Feb 22, 2021 12:26 pm
Forum: Installation & Upgrades
Topic: Upgrade 20.04 to 20.10 breaks OpenEMM, Overall Status & Jobqueue (RED) / Java Exceptions
Replies: 1
Views: 195

Upgrade 20.04 to 20.10 breaks OpenEMM, Overall Status & Jobqueue (RED) / Java Exceptions

Hi, i have a clean 20.04 Installation on CentOS8 with Python 3.9.0 and Java 11. Fresh Install, no Configration in Web Gui Done and not mailings sent yes. The 20.04 shows Overall Status green and after Upgrading to 20.10 the Overall Status and Jobqueue Status is RED. If i do a clean install of 20.10 ...
by JuergenB
Thu Dec 10, 2020 5:35 pm
Forum: Installation & Upgrades
Topic: New Install openemm-runtime-20.10.070 - Python3 Error
Replies: 15
Views: 1003

Re: New Install openemm-runtime-20.10.070 - Python3 Error

Hi ray, i have a running CentOs 8 with Python 3.9.0, Java 11, MariaDB and OpenEMM 20.10.* I started with the old 19.x Release and migrated / upgraded several times. Most of the time i did a fresh install on a clean evironment. I must admit, that i worked through the Admin Guide 1.3.2 for 20.04 and i...
by JuergenB
Thu Dec 10, 2020 11:21 am
Forum: Installation & Upgrades
Topic: New Install openemm-runtime-20.10.070 - Python3 Error
Replies: 15
Views: 1003

Re: New Install openemm-runtime-20.10.070 - Python3 Error

Hi,

can you try to install with dnf ?

It is the default package manager of Fedora 22, CentOS8 and RHEL8. DNF is the next generation version of YUM and intended to be the replacement for YUM in RPM-based systems.

I have no problems with my script and CentOs 8 so far.
by JuergenB
Fri Dec 04, 2020 8:35 pm
Forum: Installation & Upgrades
Topic: Upgrade from 20.04 to 20.10.070 ('openemm.admin_to_group_tbl' doesn't exist)
Replies: 9
Views: 652

Re: Upgrade from 20.04 to 20.10.070 ('openemm.admin_to_group_tbl' doesn't exist)

Update, i installed a new OpenEMM 20.04 from scratch on a clean CentOs 8. Here i restored the mariadb Dump from my production CentOS 7 VM. After all was checked, i restartet the services. Only the Overall Status and Jobqueue Status had errors. So reinstalled the 20.04 modules and addons. Finally the...
by JuergenB
Fri Dec 04, 2020 8:31 pm
Forum: Installation & Upgrades
Topic: New Install openemm-runtime-20.10.070 - Python3 Error
Replies: 15
Views: 1003

Re: New Install openemm-runtime-20.10.070 - Python3 Error

You could try this bash script (not perfect, but i works) with CentOS 8.2 minimum features. It should get you just before the download and install of OpenEMM 20.10 # Before using / starting this script # Install a minimal CentOs from CCentOS-8.2.2004-x86_64-boot.iso # Modify passwords used in this s...
by JuergenB
Thu Dec 03, 2020 9:16 pm
Forum: Installation & Upgrades
Topic: Upgrade from 20.04 to 20.10.070 ('openemm.admin_to_group_tbl' doesn't exist)
Replies: 9
Views: 652

Re: Upgrade from 20.04 to 20.10.070 ('openemm.admin_to_group_tbl' doesn't exist)

Hi, SELinux is not active, the installation of 20.04 works fine. Only the upgrade fails. I recreated a new CentOS 8 OpenEMM 20.04 installation, migrated the database from the "bad" system. I did some tests and a 20.10 upgrade, this worked fine, and no errors during the upgrade. Only the sy...
by JuergenB
Thu Dec 03, 2020 6:16 pm
Forum: Installation & Upgrades
Topic: Upgrade from 20.04 to 20.10.070 ('openemm.admin_to_group_tbl' doesn't exist)
Replies: 9
Views: 652

Re: Upgrade from 20.04 to 20.10.070 ('openemm.admin_to_group_tbl' doesn't exist)

Thanks, 20.10.000.103 is some way better, db udpate if fine. But it breaks tomcat and some ACL´s during installation. I get this errors during upgrade *** Error report for sanity check *** File: /home/openemm/bin/smctrl expected to have user id 0 (0) but has 1000 File: /home/openemm/bin/smctrl issui...
by JuergenB
Thu Dec 03, 2020 4:22 pm
Forum: Installation & Upgrades
Topic: Upgrade from 20.04 to 20.10.070 ('openemm.admin_to_group_tbl' doesn't exist)
Replies: 9
Views: 652

Re: Upgrade from 20.04 to 20.10.070 ('openemm.admin_to_group_tbl' doesn't exist)

Hi, Currently i have a 98% Script that installs OpenEMM 20.04 or 20.10 from Scratch in a CentOS 8 OS including SSL. The system i want to upgrade is a OpenEMM 20.04 OVA that i converted to Hyper-V. OpenEMM status: Operating System (OS): CentOS 7 Python version: 3.8.3 (default, Jul 2 2020, 21:47:18) [...
by JuergenB
Thu Dec 03, 2020 2:06 pm
Forum: Installation & Upgrades
Topic: Upgrade from 20.04 to 20.10.070 ('openemm.admin_to_group_tbl' doesn't exist)
Replies: 9
Views: 652

Re: Upgrade from 20.04 to 20.10.070 ('openemm.admin_to_group_tbl' doesn't exist)

Hi, thanks i upgraded to OMT and this is the new error i get now... these are the modules that are updates/installed Runtime 20.10.070 Code 20.10.000.097 and the error message Executing /home/openemm/webapps/emm/WEB-INF/sql/mysql/emm-mysql-messages.sql Executing /home/openemm/webapps/emm/WEB-INF/sql...
by JuergenB
Wed Dec 02, 2020 4:47 pm
Forum: Installation & Upgrades
Topic: Upgrade from 20.04 to 20.10.070 ('openemm.admin_to_group_tbl' doesn't exist)
Replies: 9
Views: 652

Upgrade from 20.04 to 20.10.070 ('openemm.admin_to_group_tbl' doesn't exist)

Hello, i would like to upgrade a running 20.04 system to the new release 20.10.000.097 / 20.10.000.092 During Upgrading i get this error during the upgrade phase .. Your current version is '20.04.000.200'. .. DB already contains version 20.07.383 DB already contains version 20.07.492 ... Executing /...
by JuergenB
Thu Jun 25, 2020 7:15 pm
Forum: Installation & Upgrades
Topic: error in 20.04 sql upgrade script - userrights.sql
Replies: 6
Views: 1075

Re: error in 20.04 sql upgrade script - userrights.sql

Thanks aso, the new release works fine, i had no problems during an upgrade from 19.10 to 20.04 with the new runtime. Thanks! :D :D Now, i`ll try to upgrade CentOS 7 to 8 or move mariadb and all config to a new VM ... 8) Didn´t worked well, got some problems after upgrade. Much easier to install 20....