search cancel

Reports showing 0% processing on central manager

book

Article ID: 215081

calendar_today

Updated On:

Products

Security Analytics

Issue/Introduction

After configuring the Security Analytics central manager and connecting all sensors successfully, reports are not completing.  All sensor reports show 0% processing and never complete.  Sensors reports work just fine when directly connected. 

Cause

There is a connectivity or authentication issue between the central manager and the sensors.

Resolution

To see exactly what is going on between the central manager and the sensor, run the following command as root from the both the central manager and the sensor and look for any errors.

scm cmc test_connection

If the problem is not evident in the output, contact technical support for additional troubleshooting help.

Additional Information

The following is output that you will see from the scm cmc test_connection commands:

Output from central manager:

scm cmc test_connection
OpenVPN status
-------------------------------------------------
OpenVPN is on
Connection successful
-------------------------------------------------
Testing Connectivity to all the Sensors
CA Connections
7: (dot53) Virtual 10.8.0.30 - Real 10.47.198.53:34279 - Success
8: (dot50) Virtual 10.8.0.34 - Real 10.47.198.50:57065 - Success


-------------------------------------------------
-------------------------------------------------
/etc/pgbouncer/additional.ini
listen_addr = 10.8.0.1
listen_port = 6432

-------------------------------------------------
/etc/pgbouncer/database.ini
dsweb = dbname=dsweb pool_size=5000 max_db_connections=150 pool_mode=transaction user=dsweb 

-------------------------------------------------
/etc/pgbouncer/userlist.txt
"dsweb" "sha256ab0ff9ec83509c3eb9c321b216b93f39d7934ce1a5d1220e4955b492b938b368"
"dsweb-10.8.0.1" "sha2563e8b7ca054abb1af09165fe9d3de861428d325310dfd92e37826d56d88dfdd84"

 

The following is sample output that you will see from the sensors:

scm cmc test_connection
OpenVPN status
-------------------------------------------------
OpenVPN is on
Connection successful
-------------------------------------------------
Testing Connectivity to all the CMCs
CA IP:  10.8.0.30
0: Virtual: 10.8.0.1 Real 10.47.198.55 - Success
-------------------------------------------------
/etc/pgbouncer/additional.ini
listen_addr = 127.0.0.1
listen_port = 6432

-------------------------------------------------
/etc/pgbouncer/database.ini
dsweb-10.8.0.1 = dbname=dsweb pool_size=50 max_db_connections=5 pool_mode=transaction host=10.8.0.1 port=6432 

-------------------------------------------------
/etc/pgbouncer/userlist.txt
"dsweb-10.8.0.1" "sha2563e8b7ca054abb1af09165fe9d3de861428d325310dfd92e37826d56d88dfdd84"


-------------------------------------------------
Testing pgbouncer connection to each cmc

Testing cmc pgbouncer connection
Db params: host=10.8.0.1 port=6432 dbname=dsweb 
Connected to PGBouncer

Testing local pgbouncer connection
Db params: host=localhost port=6432 dbname=dsweb-10.8.0.1 
Connected to PGBouncer