How to test an ODBC connection from a Log Collector in RSA Security Analytics / NetWitness Platform

[#1]

Article Number

000001380

Applies To

RSA Product Set: Security Analytics, NetWitness Logs & Network
RSA Product/Service Type: Log Collector (ODBC Collection)
RSA Version/Condition: 10.x, 11.x
Platform: CentOS
O/S Version: EL6, EL7

Issue

When troubleshooting ODBC collection in RSA Security Analytics / NetWitnesss Logs & Network, it is useful to test the ODBC connection directly on the Log Collector.

Resolution

1. Verify that the Log Collector tools package has been installed:

On 10.X:

rpm -qa nwlogcollectortools

 

On 11.X:

rpm -qa rsa-nw-logcollector-tools

 

If nothing is returned, then the package has not been installed. Install the package:

On 10.X:

yum -y install nwlogcollectortools

On 11.X:

yum -y install rsa-nw-logcollector-tools

2. Set the following environment variables:

export LD_LIBRARY_PATH=/opt/netwitness/odbc/lib:/usr/lib64 LD_LIBRARY_PATH
export ODBCINI=/etc/netwitness/ng/odbc.ini
export ODBCINST=/opt/netwitness/odbc/odbcinst.ini

 

3. Test the ODBC connection with the following command:

NwOdbcExample --dsn=<DSN> --username=<USER> --password=<PASSWORD>

 

If you are unsure about any of the steps above or are experiencing issues, contact RSA Support and quote this article ID for further assistance.