Install issues

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

Moderator: moderator

lamb
Posts: 30
Joined: Thu Jun 04, 2020 6:05 pm

Install issues

Post by lamb »

Hiya All,

Ive been busting my mind over this !

Centos 7 ive followed all the guides...

i ran the install script with --debug and i get this output:

[root@lin-vps-man-05 /]# /home/openemm/bin/OpenEMMInstaller.sh --debug
Checking python installation ...
Python version found: 3.6.8
Checking MariaDB/MySQL installation ...
DB version found: mysql Ver 15.1 Distrib 5.5.65-MariaDB, for Linux (x86_64) using readline 5.1
Checking Zip installation ...
Zip version 3.0 found
Starting python ...
ERROR:root:Cannot detect PostfixVersion
Traceback (most recent call last):
File "/home/openemm/tomcat9/bin/OpenEMMInstaller_3.py", line 1991, in getPostfixVersion
postfixVersion = subprocess.check_output("postconf -d mail_version 2>/dev/null", shell=True).decode("UTF-8")
File "/usr/lib64/python3.6/subprocess.py", line 356, in check_output
**kwargs).stdout
File "/usr/lib64/python3.6/subprocess.py", line 438, in run
output=stdout, stderr=stderr)
subprocess.CalledProcessError: Command 'postconf -d mail_version 2>/dev/null' returned non-zero exit status 127.
Invalid db type:
[root@lin-vps-man-05 /]#



MariaDB is installed and running

seems to stop at invalid db type

any help / pointers ?

thanks
lamb
Posts: 30
Joined: Thu Jun 04, 2020 6:05 pm

Re: Install issues

Post by lamb »

scrap that... i got a bit further...

Starting OpenEMM Update ...

Package contains new application 'tomcat-native'
Initial update is canceled. Please install manually for first time

Installation failed. Please install and configure the optional Apache Tomcat Native for Apache Tomcat 9 application manually.
See OpenEMM's "Admin and Install Guide" for help.
Do NOT use command 'yum install tomcat-native', because it installs Apache Tomcat Native for Apache Tomcat 7, which is not compatible with OpenEMM.


I dont get it - if its optional., why is it failing ?
MikaLaurer
Posts: 35
Joined: Thu Apr 02, 2020 9:18 am

Re: Install issues

Post by MikaLaurer »

Did you install Python3 with "yum install python3.6"? If so use the admin guide to install Python3.8 an compile it yourself as I think it is nessecary for OpenEMM.

Best regards,
Mika
lamb
Posts: 30
Joined: Thu Jun 04, 2020 6:05 pm

Re: Install issues

Post by lamb »

Thanks Mika

i have got a little further now

Do you want to install the included Tomcat-Native application now? (Y/n, Blank => Yes):
> y
Starting OpenEMM Update ...

Package contains new application 'tomcat-native'
Initial update is canceled. Please install manually for first time

Installation failed. Please install and configure the optional Apache Tomcat Native for Apache Tomcat 9 application manually.
See OpenEMM's "Admin and Install Guide" for help.
Do NOT use command 'yum install tomcat-native', because it installs Apache Tomcat Native for Apache Tomcat 7, which is not compatible with OpenEMM.
[root@lin-vps-man-05 /]#
lamb
Posts: 30
Joined: Thu Jun 04, 2020 6:05 pm

Re: Install issues

Post by lamb »

and now somehow back to square one...

[root@lin-vps-man-05 etc]# /home/openemm/bin/./OpenEMMInstaller.sh --debug
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 ...
ERROR:root:Cannot detect PostfixVersion
Traceback (most recent call last):
File "/home/openemm/tomcat9/bin/OpenEMMInstaller_3.py", line 1991, in getPostfixVersion
postfixVersion = subprocess.check_output("postconf -d mail_version 2>/dev/null", shell=True).decode("UTF-8")
File "/home/openemm/opt/python3/lib/python3.8/subprocess.py", line 411, in check_output
return run(*popenargs, stdout=PIPE, timeout=timeout, check=True,
File "/home/openemm/opt/python3/lib/python3.8/subprocess.py", line 512, in run
raise CalledProcessError(retcode, process.args,
subprocess.CalledProcessError: Command 'postconf -d mail_version 2>/dev/null' returned non-zero exit status 127.
Invalid db type:
[root@lin-vps-man-05 etc]#


i compiled python 3.8.2 and it detects so when running the installer nbut it quits out witj invalid db type
maschoff
Site Admin
Posts: 2597
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Install issues

Post by maschoff »

Mika is right, you need Python 3.8.x.

But from the ouput of the installer it looks like no MTA (Postfix or Sendmail) is installed on your server.
OpenEMM Maintainer
lamb
Posts: 30
Joined: Thu Jun 04, 2020 6:05 pm

Re: Install issues

Post by lamb »

thanks for the reply... i have that version of pyhtton installed, the script confirms this:

Checking python installation ...
Python version found: 3.8.2


I have sendmail installed and running:

[root@lin-vps-man-05 etc]# rpm -qi sendmail | grep Version
Version : 8.15.2


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

Re: Install issues

Post by maschoff »

Did you install Sendmail with yum? Otherwise it could be in a different directory and the installer did not find it.

And did you switch the default MTA to Sendmail with

# alternatives --set mta /usr/sbin/sendmail.sendmail
OpenEMM Maintainer
lamb
Posts: 30
Joined: Thu Jun 04, 2020 6:05 pm

Re: Install issues

Post by lamb »

hiya

yes alternatives --set mta /usr/sbin/sendmail.sendmail

was ran...

do you want to earn some money to get it installed for me ? send me a PM
lamb
Posts: 30
Joined: Thu Jun 04, 2020 6:05 pm

**NOW URGENT**Re: Install issues

Post by lamb »

Hi, after 3 days, i get a little further...

i run [root@lin-vps-man-04 bin]# ./OpenEMMInstaller.sh -debug

and output is

Code: Select all

[root@lin-vps-man-04 bin]# ./OpenEMMInstaller.sh -debug
Checking python installation ...
Python version found: 3.6.8
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 ...
ERROR:root:Cannot detect PostfixVersion
Traceback (most recent call last):
  File "/home/openemm/tomcat9/bin/OpenEMMInstaller_3.py", line 1991, in getPostfixVersion
    postfixVersion = subprocess.check_output("postconf -d mail_version 2>/dev/null", shell=True).decode("UTF-8")
  File "/usr/lib64/python3.6/subprocess.py", line 356, in check_output
    **kwargs).stdout
  File "/usr/lib64/python3.6/subprocess.py", line 438, in run
    output=stdout, stderr=stderr)
subprocess.CalledProcessError: Command 'postconf -d mail_version 2>/dev/null' returned non-zero exit status 127.
Invalid db type:
So, INVALID DB TYPE

So, if i create my own dbcfg file.... i get:

Code: Select all

[root@lin-vps-man-04 bin]# ./OpenEMMInstaller.sh -debug
Checking python installation ...
Python version found: 3.6.8
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 ...
ERROR:root:Cannot detect PostfixVersion
Traceback (most recent call last):
  File "/home/openemm/tomcat9/bin/OpenEMMInstaller_3.py", line 1991, in getPostfixVersion
    postfixVersion = subprocess.check_output("postconf -d mail_version 2>/dev/null", shell=True).decode("UTF-8")
  File "/usr/lib64/python3.6/subprocess.py", line 356, in check_output
    **kwargs).stdout
  File "/usr/lib64/python3.6/subprocess.py", line 438, in run
    output=stdout, stderr=stderr)
subprocess.CalledProcessError: Command 'postconf -d mail_version 2>/dev/null' returned non-zero exit status 127.
Traceback (most recent call last):
  File "/home/openemm/tomcat9/bin/OpenEMMInstaller_3.py", line 5488, in <module>
    Environment.init()
  File "/home/openemm/tomcat9/bin/OpenEMMInstaller_3.py", line 486, in init
    wkhtmltopdfFromDb = Utilities.readConfigurationValueFromDB("system", "wkhtmltopdf")
  File "/home/openemm/tomcat9/bin/OpenEMMInstaller_3.py", line 1402, in readConfigurationValueFromDB
    cursor.execute("SELECT class, name, hostname, value FROM config_tbl WHERE (hostname IS NULL OR TRIM(hostname) = '' OR hostname = %s) AND class = %s AND name = %s", (Environment.hostname, configClass, configName))
  File "/usr/local/lib64/python3.6/site-packages/MySQLdb/cursors.py", line 209, in execute
    res = self._query(query)
  File "/usr/local/lib64/python3.6/site-packages/MySQLdb/cursors.py", line 315, in _query
    db.query(q)
  File "/usr/local/lib64/python3.6/site-packages/MySQLdb/connections.py", line 239, in query
    _mysql.connection.query(self, query)
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'openemm.config_tbl' doesn't exist")
[root@lin-vps-man-04 bin]#

So the script hasnt created the tables, the db is blank.

what am i doing wrong please ?
maschoff
Site Admin
Posts: 2597
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Install issues

Post by maschoff »

You use Python 3.6.x, but for OpenEMM 20.04 you need Python 3.8 or later.
OpenEMM Maintainer
lamb
Posts: 30
Joined: Thu Jun 04, 2020 6:05 pm

Re: Install issues

Post by lamb »

iok... i have wiped and reinstalled everything... i am now useing the suggested python version, and i am back to the same point:


[root@lin-vps-man-04 bin]# ./OpenEMMInstaller.sh --debug
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 ...
ERROR:root:Cannot detect PostfixVersion
Traceback (most recent call last):
File "/home/openemm/tomcat9/bin/OpenEMMInstaller_3.py", line 1991, in getPostfixVersion
postfixVersion = subprocess.check_output("postconf -d mail_version 2>/dev/null", shell=True).decode("UTF-8")
File "/home/openemm/opt/python3/lib/python3.8/subprocess.py", line 411, in check_output
return run(*popenargs, stdout=PIPE, timeout=timeout, check=True,
File "/home/openemm/opt/python3/lib/python3.8/subprocess.py", line 512, in run
raise CalledProcessError(retcode, process.args,
subprocess.CalledProcessError: Command 'postconf -d mail_version 2>/dev/null' returned non-zero exit status 127.
Invalid db type:
[root@lin-vps-man-04 bin]#
Please please can someone help...
MikaLaurer
Posts: 35
Joined: Thu Apr 02, 2020 9:18 am

Re: Install issues

Post by MikaLaurer »

Hello,

seems like something is wrong with your postfix install. Did you run these commands when installing postfix?

# systemctl stop sendmail
# yum remove sendmail
# yum install postfix sendmail-milter procmail
# alternatives --set mta /usr/sbin/sendmail.postfix

Or do you want to use sendmail? If so ... have a look at the admin guide. It explains everything regarding the installation of either sendmail or postfix.

Best regards,
Mika
lamb
Posts: 30
Joined: Thu Jun 04, 2020 6:05 pm

Re: Install issues

Post by lamb »

Why would that cause an invalid dB error?

I’ll check it though

Would you be willing to take a look if I gave u access !?
maschoff
Site Admin
Posts: 2597
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Install issues

Post by maschoff »

Which version of the installer do you use?
OpenEMM Maintainer
Post Reply