Skip to content
  • There are no suggestions because the search field is empty.

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

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
  1. 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
 
  1. 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.


Internal Comments

UserName:shurtj
5/7/2014 4:45:39 PM - Modified Statements
Modified and added statements to abide by Primus best practices.

Product Details

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

Approval Reviewer Queue

RSA NetWitness Suite Approval Queue