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

Document created by RSA Customer Support Employee on Jun 14, 2016•Last modified by RSA Customer Support on Sep 23, 2019
Version 3Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000026822
Applies ToRSA 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
IssueWhen 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.

Legacy Article IDa65408

Attachments

    Outcomes