How to check the ActiveMQ status for CP4S env

Steps

To check the activeMQ status,  run the following:

-get the password for activeMQ:

     oc get secrets activemq-postgres-user -o yaml

-get the password decoded for the yaml file:

    echo "password" | base64 --decode 

-access this pod, where is the DB running:

    oc rsh soar-cluster-1

-run the query, and it will ask for the password that previously decoded

   psql -U activemq -d activemq -h localhost -p 5432 -c "select container, count(*) from activemq_msgs group by container order by container;"

Example of the result:

$ psql -U activemq -d activemq -h localhost -p 5432 -c "select container, count(*) from activemq_msgs group by container order by container;"


Password for user activemq:

                 container                 | count
-------------------------------------------+-------
 queue://actions.201.fn_qradar_integration |     1142

-to delete the pending messages run

psql -U activemq -d activemq -h localhost -p 5432 -c "DELETE FROM activemq_msgs WHERE container ='queue://actions.201.fn_qradar_integration’”