How do I troubleshoot an "ODBC: Connection Failed" error when starting lsfpollerd and licpollerd?

When starting licpollerd or lsfpollerd you received the following error message : ODBC: Connection Failed:0 -1 IM002 0 [unixODBC][Driver Manager]Data source name not found, and no default driver specified.

About this task

This issue is caused by the unixODBC package being reinstalled after the RTM installation. If you reinstall unixODBC after you installed RTM, a couple of files, including /etc/odbc.ini and /etc/odbcinst.ini, are modified.

To fix this issue, perform the following steps:

1. Copy the following contents into # cat /etc/odbc.ini

   [cacti]
   Description     = Data Source for IBM Spectrum RTM.
   Driver          = MySQL RTM 

2. Copy the following contents into # cat /etc/odbcinst.ini

   # Example driver definitions
   
   # Driver from the postgresql-odbc package # Setup from the unixODBC package [PostgreSQL]
   Description     = ODBC for PostgreSQL
   Driver          = /usr/lib/psqlodbc.so
   Setup           = /usr/lib/libodbcpsqlS.so
   Driver64        = /usr/lib64/psqlodbc.so
   Setup64         = /usr/lib64/libodbcpsqlS.so
   FileUsage       = 1
   
   
   # Driver from the mysql-connector-odbc package # Setup from the unixODBC package [MySQL]
   Description     = ODBC for MySQL
   Driver          = /usr/lib/libmyodbc5.so
   Setup           = /usr/lib/libodbcmyS.so
   Driver64        = /usr/lib64/libmyodbc5.so
   Setup64         = /usr/lib64/libodbcmyS.so
   FileUsage       = 1
   [MySQL RTM]
   Description     = Mysql ODBC Driver for IBM Spectrum RTM.
   Driver64        = /usr/lib64/libmyodbc5.so
   Setup64         = /usr/lib64/libodbcmyS.so
   UsageCount      = 1
   CPTimeout       =
   CPReuse         =