[Your Linux Guides are Extremely Confusing and Frustrating]

Also attached is my install script

ESMC_install_script.txt

[Your Linux Guides are Extremely Confusing and Frustrating]

Sorry, I think the previous log was incomplete. Attached is the complete copy of the installer log.

I think this line is of interest:

Exception thrown while connecting to the database SERVER as a user.. Error code: 65535, DB specific error code: 1698, error message: [unixODBC][MySQL][ODBC 5.3(w) Driver]Access denied for user 'root'@'localhost'

 

EraServerInstaller.log

[Your Linux Guides are Extremely Confusing and Frustrating]

Here is the installer log:

2020-10-22 16:14:31 Information: DbCheckConnection: Set output property: P_DB_PORT = 3306
2020-10-22 16:14:31 Information: GetDatabaseServerConnectionStringWithoutEscape: Created connection string: 'Driver=MySQL ODBC 8.0 Driver;Server=127.0.0.1;Port=3306;User=******;Password={*$
2020-10-22 16:14:31 Information: Entering function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const string&, Era::Setup::Common::Database::Framework::ConnectO$
2020-10-22 16:14:31 Information: Leaving function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const string&, Era::Setup::Common::Database::Framework::ConnectOp$
2020-10-22 16:14:31 Information: Exception thrown while connecting to the specific database as a user.. Error code: 65535, DB specific error code: 1698, error message: [unixODBC][MySQL][OD$
2020-10-22 16:14:31 Information: Entering function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const string&, Era::Setup::Common::Database::Framework::ConnectO$
2020-10-22 16:14:31 Information: Leaving function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const string&, Era::Setup::Common::Database::Framework::ConnectOp$
2020-10-22 16:14:31 Information: Exception thrown while connecting to the database SERVER as a user.. Error code: 65535, DB specific error code: 1698, error message: [unixODBC][MySQL][ODBC$
2020-10-22 16:14:31 Information: DbCheckConnection: Set output property: P_DB_CONNECTION_STATUS = 1698
2020-10-22 16:14:31 Information: DbCheckConnection: Return code: 0
2020-10-22 16:14:31 Information: Installer: An error occurred while trying to connect to the database. Error code: (1698). Unable to continue.
2020-10-22 16:14:31 Information: Installer: Error: An error occurred while trying to connect to the database. Error code: (1698). Unable to continue.

[Your Linux Guides are Extremely Confusing and Frustrating]

Can you please tell me, when I try to run the installation script:

sudo ./server-linux-x86_64.sh \
--skip-license \
--db-type="MySQL Server" \
--db-driver="MySQL ODBC 8.0 Driver" \
--db-hostname=127.0.0.1 \
--db-port=3306 \
--db-admin-username=root \
--db-admin-password=password \
--server-root-password=password \
--db-user-username=root \
--db-user-password=password \
--cert-hostname="localhost"

I get the following error message:

Extracting archive, please wait...
Archive extracted to /tmp/tmp.WkyFyNr1dO.
Checking OpenSSL ... done [OpenSSL 1.0.2g 1 Mar 2016]
Reading previous installation settings ... failure
Checking installed version... done
Status of current installation is: NEW
Checking database connection ... failure

Error: An error occurred while trying to connect to the database. Error code: (1698). Unable to continue.

 

I can login to the database succesfully using: sudo mysql -u root -p

So i know the username/password is correct.

Is there something else causing the database connection to fail?

[Your Linux Guides are Extremely Confusing and Frustrating]

I have been trying for 2 days to get ESMC going on Ubuntu 16. I am constantly running into issues. I get a few steps ahead and then run into an error, then have to spend hours researching it.

For example, on the step: 

1.Run the following command to open the my.cnf (my.ini for Windows installation) file in a text editor: 

sudo nano /etc/mysql/my.cnf 

If the file is not present, try /etc/my.cnf or /etc/my.cnf.d/community-mysql-server.cnf

None of those locations are correct. The file is actually located in /etc/mysql/mysql.conf.d/mysqld.cnf

and i had to Google that! (https://askubuntu.com/questions/829772/mysql-failed-to-restart-on-ubuntu-16-04)

Another example:

2.Download the ODBC connector:

•Ubuntu 16: wget https://downloads.mysql.com/archives/get/p/10/file/mysql-connector-odbc-8.0.17-linux-ubuntu16.04-x86-64bit.tar.gz

But then on the requirements page (https://help.eset.com/esmc_install/72/en-US/database_requirements.html)

 

Warning

MySQL ODBC driver versions 5.3.11 and later, 8.0.0 – 8.0.15 and 8.0.18 and later are not supported.

So you provided the instructions to install a version of ODBC that isn't supported.

Instructions should be clear and concise, and these instructions are incredibly confusing and frustrating.

 

[install ESMC sur LINUX UBUNTU]

Hello,

I have tried following the instructions. The part I get stuck on is step 8.

8. sudo myodbc-installer -a -d -n "MySQL ODBC 8.0 Driver" -t "Driver=/usr/local/lib/libmyodbc8w.so"

An error message returns saying -> myodbc-installer: command not found