Install ERA on Linux with MYSQL failed

[jinlei801011 2]

Tried to install ERA on Centos with MYSQL, encounter error

2017-12-07 05:22:18 Information: DbCheckConnection: Set output property: P_DB_CONNECTION_STATUS =

2017-12-07 05:22:18 Information: DbCheckConnection: Set output property: P_DB_STATUS =

2017-12-07 05:22:18 Information: DbCheckConnection: Set output property: P_DB_UPGRADE =

2017-12-07 05:22:18 Information: DbCheckConnection: Set output property: P_DB_USE_FIRST_USER =

2017-12-07 05:22:18 Information: DbCheckConnection: Set output property: P_DB_PORT = 3306

2017-12-07 05:22:18 Information: GetDatabaseServerConnectionStringWithoutEscape: Created connection string: 'Driver=MySQL;Server=127.0.0.1;Port=3306;User=******;Password={******};CharSet=utf8;NO_LOCALE=1;'

2017-12-07 05:22:18 Information: Entering function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const string&, bool)

2017-12-07 05:22:18 Information: Leaving function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const string&, bool)

2017-12-07 05:22:18 Information: Exception thrown while connecting to the specific database as a user.. Error code: 0, DB specific error code: 0, error message: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed

2017-12-07 05:22:18 Information: DbCheckConnection: Set output property: P_DB_CONNECTION_STATUS = 0

2017-12-07 05:22:18 Information: DbCheckConnection: Return code: 0

2017-12-07 05:22:18 Information: Installer: Unknown database driver or data source name (DSN)

2017-12-07 05:22:18 Information: Installer: Error: Unknown database driver or data source name (DSN)

 

[MartinK 378]

It seems like problem with MySQL ODBC driver. What version of MySQL driver you are using? How did you installed it? We were using official MySQL drivers in our ERA appliances based on CentOS6/CentOS7. Could you verify that MySQL drivers is installed correctly in /etc/odbcinst.ini -> it should be defined in section [MySQL] as you defined this in installation parameters.

[dfurtado 0]

On 12/7/2017 at 8:36 PM, MartinK said:

It seems like problem with MySQL ODBC driver. What version of MySQL driver you are using? How did you installed it? We were using official MySQL drivers in our ERA appliances based on CentOS6/CentOS7. Could you verify that MySQL drivers is installed correctly in /etc/odbcinst.ini -> it should be defined in section [MySQL] as you defined this in installation parameters.

HAving this error message

ESET Remote Administrator Server Installer (version: 6.5.417.0), Copyright © 1992-2017 ESET, spol. s r.o. - All rights reserved.

Extracting archive, please wait...
Archive extracted to /tmp/tmp.xzSa3Uu8Ce.
Checking OpenSSL ... done [OpenSSL 1.0.2k-fips 26 Jan 2017]
Reading previous installation settings ... failure
Checking installed version... done
Status of current installation is: NEW
Checking database connection ... failure

Error: Unknown database driver or data source name (DSN)
[root@Inf-off-antv05 ~]#

 

After running the script I came across this error, can someone help me as I have no clue what I might be doing wrong? 

ODBC copied from here so it should be fine

Cant find this files as shown in hxxp://help.eset.com/era_install/65/en-US/index.html?mysql_configuration.htm

[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
FileUsage = 1

 

By default, my system placed the files under /usr/lib64 i am using cento7

Thanks any light would be great

[dfurtado 0]

Sorted found the error