Hi
I found what is a reason.
When i run this script from gw or mx from CLI it's works. I have all tables in influxdb ang grafana looks good.
Problem is when this script is running from cron.
Cron gets errors:
Traceback (most recent call last):
File "/opt/SecureSphere/etc/impctl/bin/impctl", line 13, in <module>
import PCEXmlConvertor, PCECommandsControl, PCEDefs
ImportError: No module named PCEXmlConvertor
But I still don't know how to fix this.
Best regards
------------------------------
Lukasz Sirega
------------------------------
Original Message:
Sent: 10-14-2020 15:02
From: Lukasz Sirega
Subject: mx-toolbox and DAM
As I wrote I took last version from github. This version was update 20 days ago. Could you tell me whitch logs or where should I look ?
And I think not all data are send to influxdb. For example the graf " MX Network Statistic" - Total Packet select data from rx_packet column from imperva_mx_net but in my table I don't see this column.
> select * from imperva_mx_net limit 1
name: imperva_mx_net
time collisions interface ipaddress mxname rx_bytes source tx_bytes uptime
---- ---------- --------- --------- ------ -------- ------ -------- ------
------------------------------
Lukasz Sirega
Original Message:
Sent: 10-13-2020 11:43
From: Brian Anderson
Subject: mx-toolbox and DAM
Hi,
Have we ensured that we are using the latest version of the scripts? Also, do the logs tell us anything? Please let me know if you would like to set up a zoom session, and I will be happy to look at this with you.
ba@imperva.com
- Brian
------------------------------
Brian Anderson
Original Message:
Sent: 10-12-2020 08:01
From: Lukasz Sirega
Subject: mx-toolbox and DAM
Hi Paul
I have last version from github.
This is table from influx , and base doesn't contain imperva_mx_sys and imperva_gw_sys.
> show measurements
name: measurements
name
----
imperva_agents
imperva_audit_policies
imperva_gw
imperva_gw_cpuload
imperva_gw_disk
imperva_gw_hades
imperva_gw_meminfo
imperva_gw_net
imperva_gw_sar_cpu
imperva_gw_top_cpu
imperva_gw_workers
imperva_mx
imperva_mx_disk
imperva_mx_net
imperva_mx_sar_cpu
imperva_mx_top_cpu
imperva_sg
------------------------------
Lukasz Sirega
Original Message:
Sent: 10-12-2020 07:29
From: Paul Hammons
Subject: mx-toolbox and DAM
Lukasz,
I know these scripts were updated last week with some fixes, support for our new models, etc. Can you confirm that you have the latest versions?
------------------------------
Paul Hammons
Imperva Senior Sales Engineer
Cape Coral, Florida
Original Message:
Sent: 10-09-2020 17:27
From: Lukasz Sirega
Subject: mx-toolbox and DAM
Hi All
After AMA with DAM I became interested about mx-toolbox with Grafana.
So I decided to install performance monitoring to DAM and it looks greate, but not all graphs displays data.
When I checked the json scripts I found some mistakes.
Scripts on mx and gw "get_mx_stats.py" and "get_gateway_stats.py" create a table with name "imperva_mx" , "imperva_gw" , but scripts for grafana have "imperva_mx_sys" and "imperva_gw_sys"
This was reason why grafana can't get data from database.
Next mistake I cant find "uptime" column in this table.
Someone had the same problem like me ?
#DatabaseActivityMonitoring
------------------------------
Lukasz Sirega
------------------------------