5.3 Frontend and Backend Deployment - fails MySQLdb exceptions

Use this forum for questions regarding installation, upgrading and configuration of OpenEMM

Moderator: moderator

JuergenB
Posts: 72
Joined: Thu Dec 05, 2019 9:03 pm

5.3 Frontend and Backend Deployment - fails MySQLdb exceptions

Post by JuergenB » Mon Jun 15, 2020 3:45 pm

I tired the installation with CentOS 8 and 20.04 runtime.

i installed the base parts and python3-devel for the mariadb mysqlclient (python3 -m pip install mysqlclient).
thas was ok, later i compiled the Python 3.8

I did the runtime deployment 5.2 as openemm user.
I configured the environment and the dbms settings.

next i startet the OpenEMMInstaller.sh as root.
I get this error message ( may i don´t get the correct order from admin guide 1.3.2)

Has anyone an idea in which order we need python3, dbms, runtime config, installer etc. ?

[root@emm Python-3.8.3]# /home/openemm/bin/OpenEMMInstaller.sh
Checking python installation ...
Python version found: 3.8.3
Checking MariaDB/MySQL installation ...
DB version found: mysql Ver 15.1 Distrib 10.3.17-MariaDB, for Linux (x86_64) using readline 5.1
Checking Zip installation ...
Zip version 3.0 found
Starting python ...
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'openemm.config_tbl' doesn't exist")

base components ....

Code: Select all

sudo - root

dnf -y install net-tools wget nano zip tar
dnf -y update
dnf -y install gcc make
dnf -y install java-11-openjdk-devel
dnf -y install xorg-x11-fonts-75dpi zlib fontconfig freetype libX11 libXext libXrender urw-fonts
dnf -y install python3-devel

dnf  -y install mariadb-server
sudo systemctl enable mariadb
sudo systemctl start mariadb

dnf -y install mariadb-devel
python3 -m pip install mysqlclient
If i install only python3 (dnf -y install python3) i can`t use

Code: Select all

python3 -m pip install mysqlclient

Manoj Sreepada
Posts: 21
Joined: Thu Aug 06, 2020 1:32 pm

Re: 5.3 Frontend and Backend Deployment - fails MySQLdb exceptions

Post by Manoj Sreepada » Fri Aug 28, 2020 11:09 am

Hello,

I tired the installation with 20.04 runtime. We get the following Error:

[root@mail1 bin]# ./OpenEMMInstaller.sh
Checking python installation ...
Python version found: 3.8.2
Checking MariaDB/MySQL installation ...
DB version found: mysql Ver 15.1 Distrib 10.3.17-MariaDB, for Linux (x86_64) using readline 5.1
Checking Zip installation ...
Zip version 3.0 found
Starting python ...
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'openemm.config_tbl' doesn't exist")

What can we do?

What can we do?

Thanks Please Advice for any help.

maschoff
Site Admin
Posts: 2493
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: 5.3 Frontend and Backend Deployment - fails MySQLdb exceptions

Post by maschoff » Fri Aug 28, 2020 11:14 am

The error message "Table 'openemm.config_tbl' doesn't exist" indicates, that the OpenEMM DB was not set up.
OpenEMM Maintainer

Manoj Sreepada
Posts: 21
Joined: Thu Aug 06, 2020 1:32 pm

Re: 5.3 Frontend and Backend Deployment - fails MySQLdb exceptions

Post by Manoj Sreepada » Fri Aug 28, 2020 11:45 am

How to fix this Error?

Manoj Sreepada
Posts: 21
Joined: Thu Aug 06, 2020 1:32 pm

Re: 5.3 Frontend and Backend Deployment - fails MySQLdb exceptions

Post by Manoj Sreepada » Fri Aug 28, 2020 2:40 pm

We get the following Error how to fix this:

[root@mail1 bin]# ./OpenEMMInstaller.sh
Checking python installation ...
Python version found: 3.8.2
Checking MariaDB/MySQL installation ...
DB version found: mysql Ver 15.1 Distrib 10.3.17-MariaDB, for Linux (x86_64) using readline 5.1
Checking Zip installation ...
Zip version 3.0 found
Starting python ...
MySQLdb._exceptions.OperationalError: (1054, "Unknown column 'class' in 'where clause'")

Thanks,

Post Reply