Scampicfx 0 Posted July 5, 2015 Posted July 5, 2015 (edited) Dear folks, when i try to run my ESET Remote Administrator installation script in command shell (Ubuntu 14), I receive the following error message: [...] Checking database connection . . . failure Error: Admin connection not working. Unable to continue. According to the manual, the user is requested to install unixODBC_23 instead of the normal unixODBC. Is this accomplished by apt-get install unixodbc libmyodbc (which is stated in the manual?)? In the installation script the option --db-driver shows the value "MySQL ODBC 5.3 ANSI Driver". I'm not quite sure if this is correct? After googling, I tried this tutorial hxxp://www.kaffeetalk.de/how-to-setup-and-configure-mysql-with-unixodbc-under-ubuntu-14-04/ and that one https://help.ubuntu.com/community/ODBC . My /etc/odbc.ini is looking like this: [myodbc_mysql_dsn] Description = MySQL database Datenbankname Driver = myodbc_mysql Server = localhost Database = Port = 3306 Socket = /var/run/mysqld/mysqld.sock Option = 3 ReadOnly = No My etc/odbinst.ini shows: [myodbc_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 UsageCount = 8 I installed them using... odbcinst -i -d -f /etc/odbcinst.ini odbcinst -i -s -l -f /etc/odbc.ini .. and ... isql -v myodbc_mysql_dsn MYSQLUSER MYSQLUSERPASSWORD ... is showing "Connected!". However, I'm not sure if the tutorials are suited to solve this problem? Do you know any tutorials describing the correct installation of the odbc driver? Any help is highly appreciated. Edited July 5, 2015 by Scampicfx
Scampicfx 0 Posted July 5, 2015 Author Posted July 5, 2015 The logfile: 2015-07-05 23:15:18 Information: Installer: Checking database connection ... 2015-07-05 23:15:18 Information: DbCheckConnection: Action invoked with: --db-admin-password ********** --db-admin-username root --db-connectors-dir /tmp/tmp.oQFclRv17X/setup --db-driver myodbc_mysql_dsn --db-hostname localhost --db-name era_db --db-port 3306 --db-type MySQL Server --db-user-password ********** --db-user-username era_db_user --silent-reinstall "" 2015-07-05 23:15:18 Information: DbCheckConnection: Set output property: P_DB_PORT = 3306 2015-07-05 23:15:18 Information: GetDatabaseServerConnectionStringWithoutEscape: Created connection string: 'Driver=myodbc_mysql_dsn;Server=localhost;Port=3306;User=root;Password={******};CharSet=utf8;' 2015-07-05 23:15:18 Information: Entering function: void Era::Setup::Common::CustomActions::CDatabaseReader::TryUserConnectionForDBServer(const string&, const string&, const string&) 2015-07-05 23:15:18 Information: Entering function: void Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const string&, bool) 2015-07-05 23:15:18 Information: DbCheckConnection: Set output property: P_DB_ADMIN_CONNECTION_STATUS = 0 2015-07-05 23:15:18 Information: ERROR: DatabaseException with error code '0' and message - [unixODBC][Driver Manager]Data source name not found, and no default driver specified 2015-07-05 23:15:18 Information: DbCheckConnection: Return code: 0 2015-07-05 23:15:18 Information: Installer: Admin connection check failed. Unable to continue. 2015-07-05 23:15:18 Information: Installer: Error: Admin connection not working. Unable to continue.
ESET Staff michalp 20 Posted July 9, 2015 ESET Staff Posted July 9, 2015 You have put DSN into driver name parameter: --db-driver myodbc_mysql_dsn . Change it to: --db-driver myodbc_mysql
Recommended Posts