Hide this message
Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.
When attempting to use SAM component monitors and templates with a CentOS Linux-based computer, you may receive the following error: Data source name not found and no default driver specified. The Linux-based computer being monitored may not have the required ODBC or MySQL drivers installed on the system. For full details for Linux configurations, see Linux system configurations for Component Monitors.
To resolve, verify if the correct drivers are installed and defined and the user account and credentials are assigned to the component monitors.
The Linux-based computer being monitored by SAM may not have the correct drivers installed and configured or the credentials may not be assigned to the component monitors.
Locating the issue may require investigating:
Verify the CentOS system has the mysql-connector-odbc installed. Use the following command to receive a package and version name on the target Linux-based computer:
rpm -q mysql-connector-odbc
Verify you have the appropriate credentials assigned for each component monitor.
If you continue to encounter issues, verify the appropriate driver is defined on the CentOS system to match the connection string.
cat /etc/odbcinst.ini [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=1 [MySQL ODBC 5.3 Unicode Driver] Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so Setup=/usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so UsageCount=1
Attempt running SQL commands using a Command Line Interface on the CentOS system with a command that specifies the driver, credentials, and database. If the command works locally on the CentOS system, you can verify those settings in SAM for the component monitors.