gmar84

Also attached is my install script ESMC_install_script.txt

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

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.

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?

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.

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