Page 1 of 1

5.3 Frontend and Backend Deployment - fails MySQLdb exceptions

Posted: Mon Jun 15, 2020 3:45 pm
by JuergenB
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

Re: 5.3 Frontend and Backend Deployment - fails MySQLdb exceptions

Posted: Fri Aug 28, 2020 11:09 am
by Manoj Sreepada
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.

Re: 5.3 Frontend and Backend Deployment - fails MySQLdb exceptions

Posted: Fri Aug 28, 2020 11:14 am
by maschoff
The error message "Table 'openemm.config_tbl' doesn't exist" indicates, that the OpenEMM DB was not set up.

Re: 5.3 Frontend and Backend Deployment - fails MySQLdb exceptions

Posted: Fri Aug 28, 2020 11:45 am
by Manoj Sreepada
How to fix this Error?

Re: 5.3 Frontend and Backend Deployment - fails MySQLdb exceptions

Posted: Fri Aug 28, 2020 2:40 pm
by Manoj Sreepada
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,