Imperva Cyber Community

communities_1.jpg
 View Only
  • 1.  mx-toolbox and DAM

    Posted 10-11-2020 22:12
    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
    ------------------------------


  • 2.  RE: mx-toolbox and DAM

    Posted 10-12-2020 07:30
    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
    ------------------------------



  • 3.  RE: mx-toolbox and DAM

    Posted 10-12-2020 08:02
    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
    ------------------------------



  • 4.  RE: mx-toolbox and DAM

    Posted 10-13-2020 11:43
    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
    ------------------------------



  • 5.  RE: mx-toolbox and DAM

    Posted 10-14-2020 15:03
    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
    ------------------------------



  • 6.  RE: mx-toolbox and DAM

    Posted 10-20-2020 14:42
    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
    ------------------------------



  • 7.  RE: mx-toolbox and DAM

    Posted 10-20-2020 14:48
    Edited by Brian Anderson 10-20-2020 14:54
    Can we get on a zoom to take a look at this together?  Can you reach out to me to let me know availability?

    ba@imperva.com