Install issues

[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]

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]

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]

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]

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]

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.

[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]

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

[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]

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]

You use Python 3.6.x, but for OpenEMM 20.04 you need Python 3.8 or later.

[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]

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]

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]

Which version of the installer do you use?