Database Connection (Ubuntu)

[Scampicfx 0]

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]

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.

[michalp 20]

You have put DSN into driver name parameter: --db-driver myodbc_mysql_dsn . Change it to: --db-driver myodbc_mysql

[Scampicfx 0]

ahhh thanks a lot!