Jump to content

CO11WRX

Members
  • Posts

    4
  • Joined

  • Last visited

Everything posted by CO11WRX

  1. Thank you! I was able to get the installer to complete and now have a functioning ESMC server! I marked your last post as the answer; however, there were two different issues that were causing the installer to fail. Below is a quick summary of the issues and their resolution: 1. As you suggested in a previous post, setting SELINUX to "Permissive" resolved the issue where the installer script was returning the following message: "Error: Unknown database driver or data source name (DSN)" After setting SEL to permissive and rebooting, this error went away. 2. After resolving issue #1, the installer script returned a different error "User login failed (invalid credentials provided)" It turns out one of the variables in my installer script was using a password containing the "@" symbol. I removed this character from the password an re-ran the script. It completed without any problems. At this point I am good to go! Thanks to both Marcos and MartinK for your help in getting my issues resolved!
  2. Alright, it looks like we may be getting somewhere! I set SELINUX to permissive mode and now it looks like the Server installation is able to connect to the MySQL DB; however, I am getting a different error now (User Login Failed invalid credentials provided). I assume this is in reference to the MySQL user account. I am able to connect to the MySQL database using the same credentials I provided in the script so I am not sure what is gong on. For example, using the command mysql -u root -p allows me to connect to the MySQL instance without issue. Do I need to create a separate DB user and use those credentials in the Server installation script? I have also included the contents of the ERAServerInstaller log file. Extracting archive, please wait... Archive extracted to /tmp/tmp.ODmf2NxF1y. 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: User login failed (invalid credentials provided) 2020-11-08 03:07:41 Information: GetDatabaseServerConnectionStringWithoutEscape: Created connection string: 'Driver=MySQL;Server=hostname.com;Port=3306;User=******;Password={******};CharSet=utf8;NO_LOCALE=1;NO_SSPS=1;' 2020-11-08 03:07:41 Information: Entering function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const string&, Era::Setup::Common::Database::Framework::ConnectOptions) 2020-11-08 03:07:41 Information: Leaving function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const string&, Era::Setup::Common::Database::Framework::ConnectOptions) 2020-11-08 03:07:41 Information: Exception thrown while connecting to the specific database as a user.. Error code: 1045, DB specific error code: 1045, error message: [unixODBC][MySQL][ODBC 5.3(w) Driver]Access denied for user 'root'@'localhost' (using$ 2020-11-08 03:07:41 Information: Entering function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const string&, Era::Setup::Common::Database::Framework::ConnectOptions) 2020-11-08 03:07:41 Information: Leaving function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const string&, Era::Setup::Common::Database::Framework::ConnectOptions) 2020-11-08 03:07:41 Information: Exception thrown while connecting to the database SERVER as a user.. Error code: 1045, DB specific error code: 1045, error message: [unixODBC][MySQL][ODBC 5.3(w) Driver]Access denied for user 'root'@'localhost' (using p$ 2020-11-08 03:07:41 Information: DbCheckConnection: Set output property: P_DB_CONNECTION_STATUS = 1045 2020-11-08 03:07:41 Information: DbCheckConnection: Return code: 0 2020-11-08 03:07:41 Information: Installer: User login failed (invalid credentials provided) 2020-11-08 03:07:41 Information: Installer: Error: User login failed (invalid credentials provided)
  3. Thanks! I did indeed follow the instructions in your first link. For the ODBC connector, I could not find any actual step by step instructions for installing the connector. I just went to the MYSQL Community Downloads site and downloaded the ODBC 5.3.10 version. I used the RPM -i command to install the package. This is where I received an error regarding the dependencies. Thank you for the info! I checked that log file and below is what is displayed. NOTE: I edited the hostname for privacy purposes. From what I can tell the error message is similar to what is shown on screen when I try to run my install script. As you suggested, I will try to switch SELinux to permissive mode then test again. 2020-11-07 00:36:24 Information: DbCheckConnection: Set output property: P_DB_CONNECTION_STATUS = 2020-11-07 00:36:24 Information: DbCheckConnection: Set output property: P_DB_STATUS = 2020-11-07 00:36:24 Information: DbCheckConnection: Set output property: P_DB_UPGRADE = 2020-11-07 00:36:24 Information: DbCheckConnection: Set output property: P_DB_USE_FIRST_USER = 2020-11-07 00:36:24 Information: DbCheckConnection: Set output property: P_DB_PORT = 3306 2020-11-07 00:36:24 Information: GetDatabaseServerConnectionStringWithoutEscape: Created connection string: 'Driver=[MySQL];Server=serverhostname.com;Port=3306;User=******;Password={******};CharSet=utf8;NO_LOCALE=1;NO_SSPS=1;' 2020-11-07 00:36:24 Information: Entering function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const string&, Era::Setup::Common::Database::Framework::ConnectOptions) 2020-11-07 00:36:24 Information: Leaving function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const string&, Era::Setup::Common::Database::Framework::ConnectOptions) 2020-11-07 00:36:24 Information: Exception thrown while connecting to the specific database as a user.. Error code: 0, DB specific error code: 0, error message: 2020-11-07 00:36:24 Information: DbCheckConnection: Set output property: P_DB_CONNECTION_STATUS = 0 2020-11-07 00:36:24 Information: DbCheckConnection: Return code: 0 2020-11-07 00:36:24 Information: Installer: Unknown database driver or data source name (DSN) 2020-11-07 00:36:24 Information: Installer: Error: Unknown database driver or data source name (DSN)
  4. Hi everyone I have been frustratingly trying to get the ESMC server installed on CentOS 7. I think I was eventually able to get through the instructions but I am running into a problem I cannot seem to fix. I am attempting to run the following installation script (I have sanitized it by removing my hostname and IP) sudo ./server-linux-x86_64.sh \ --skip-license \ --db-driver=MySQL \ --db-hostname=my.hostname.com \ --db-port=3306 \ --db-admin-username=root \ --db-admin-password=mypass \ --server-root-password=mypass \ --db-user-username=root \ --db-user-password=mypass \ --cert-hostname="my.hostname.com;111.111.111.111" The output of the script is below: ESET Security Management Center Server Installer (version: 7.2.2236.0), Copyright © 1992-2020 ESET, spol. s r.o. - All rights reserved. Extracting archive, please wait... Archive extracted to /tmp/tmp.1MuOANeZHX. 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) I assume this error is a result of my /etc/odbcinst.ini settings but for the life of me I cannot figure out how to fix it. For reference, here are the settings in my odbcinst.ini file. [MySQL] Description = ODBC for MySQL Driver=/usr/lib64/libmyodbc5w.so Setup=/usr/lib/libodbcmyS.so FileUsage = 1 Unfortunately the instructions I am using don't really go over how to install the ODBC connector so I tried to figure this out on my own. When I downloaded the ODBC connector RPM and tried to install, I received an error regarding dependencies. I found a site that said to use the --nodeps flag to bypass this. I am wondering if this is where I went wrong. Does anyone have any recommendations on how to resolve this issue? Alternatively, can someone point me to an Eset article on how to actually install the ODBC connector? I found the steps to configure it, but I think the installation part is where I screwed up. Any help would be greatly appreciated. Thanks!
×
×
  • Create New...