search

exasol / nagios-monitoring

Docker container with installed and configured Nagios software for EXASOL DB monitoring.
MIT License
10 stars 11 forks source link

RHEL6: check_db_performance.py does not work #9

Closed daugustin closed 6 years ago

daugustin commented 6 years ago

Hi,

when I try to call check_db_performance.py on RHEL6 with pyodbc and unixODBC installed, I get the following error:

./check_db_performance.py -H <somehost> -u monitoring -p <somepw> -d <somedb> -l sys -a <somepw> 
('IM002', '[IM002] [unixODBC][Driver Manager]Data source name not found, and no default driver specified (0) (SQLDriverConnectW)')

The Exasol ODBC driver is at

/opt/exasol/EXASOL_ODBC-6.0.0/lib/linux/x86_64/libexaodbc-uo2214lv2.so

and ldd shows no error about libs.

florian-reck commented 6 years ago

Hi,

We'll check that and come back to you as soon as we can provide results for this.

florian-reck commented 6 years ago

I tried it in a fresh CentOS 6.9 with EPEL (unixODBC + pyODBC installed). You need to add the following lines to your /etc/odbcinst.ini file:

[exasolution-uo2214lv2_64]
DRIVER = /opt/exasol/EXASOL_ODBC-6.0.4/lib/linux/x86_64/libexaodbc-uo2214lv2.so

[exasolution-uo2214lv2_64-debug]
DRIVER = /opt/exasol/EXASOL_ODBC-6.0.4/lib/linux/x86_64/libexaodbc-uo2214lv2.so
EXALOGFILE = /opt/exasol/EXASOL_ODBC-6.0.4/exaodbc.log
LOGMODE = verbose

You may need to correct the path to your ODBC driver libraries. The second entry is optional and only interessting if you need ODBC log files from the ODBC driver.

With the new version 17.11.2 of the check_db_performance.py plugin a new parameter has been introduced: -o

The following command should work for you:

./check_db_performance.py -H <somehost> -u monitoring -p <somepw> -d <somedb> -l sys -a <somepw> -o "exasolution-uo2214lv2_64"

Please give us some feedback, if this fixes your problem or not.

Kind regards, Flo

daugustin commented 6 years ago

The check works now. Thank you.