000026822 - How to test an ODBC connection from a Log Collector directly without using RSA Security Analytics Interface

Document created by RSA Customer Support Employee on Jun 14, 2016•Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000026822
Applies ToRSA Security Analytics
RSA Security Analytics Log Collector
Microsoft ODBC
IssueHow to test an ODBC connection from a Log Collector directly without using RSA Security Analytics Interface.
How do I test my ODBC connection directly from a Log Collector appliance without using the SA UI?
Resolution

To test an ODBC connection on a Log Collector appliance, follow the steps below.


  1. Install the nwlogcollectortools package with the command rpm -Uvh nwlogcollectortools if it is not already installed.
  2. After the install completes, set the following environment variables:

    1. export LD_LIBRARY_PATH=/opt/netwitness/odbc/lib:/usr/lib64 LD_LIBRARY_PATH
    2. export ODBCINI=/etc/netwitness/ng/odbc.ini
    3. export ODBCINST=/opt/netwitness/odbc/odbcinst.ini
  4. 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