QueueMetrics - Advanced Configuration Manual

Loway

Revision History
Revision 19.04 - covers QueueMetrics 19.042019/04/02L

Table of Contents

1. Acknowledgements
2. ViciDial integration
2.1. Prerequisites
2.2. Changes to QueueMetrics database
2.3. Changes to ViciDial
2.4. Changes to QueueMetrics
3. Serving QueueMetrics through Apache
3.1. Prerequisites
3.2. Installing mod_jk
3.3. Configuration of Apache and mod_jk
3.4. Virtual host configuration
3.5. Creating Virtualhosts in Tomcat
3.6. Troubleshooting
4. Serving QueueMetrics over Apache/SSL
4.1. Prerequisites
4.2. Configure the Name-Based SSL Virtual Hosts
4.3. Install the Apache HTTP Server and its SSL/TLS Module
4.4. Configure the global Apache Settings
4.5. Configure the global SSL/TLS Settings
4.6. Create DNS records
4.7. Create the Application Directories
4.8. Install the CRT, CSR, and KEY files
4.9. Configure the Virtual Hosts
4.10. Verify the Configuration
4.11. Setup the service for automated startup
4.12. Troubleshooting
4.13. Summary of Log Files used by Apache
4.14. Notes
4.15. Sources
5. Installing QM as a ROOT webapp
5.1. Prerequisites
5.2. Model 1: using a ROOT webapp
5.3. Model 2: defining a root context
5.4. Changes to QueueMetrics
6. Enabling GZIP compression in Tomcat
6.1. Prerequisites
6.2. Changes to Tomcat
6.3. Changes to QueueMetrics
6.4. For further reading
7. Advanced QueueMetrics monitoring
7.1. Prerequisites
7.2. Assessing memory problems
7.3. Remote monitoring with VisualVM
8. Database connection pooling
8.1. Prerequisites
8.2. Changes to the MySQL server
8.3. Changes to QueueMetrics
8.4. Changes to Tomcat
9. Moving QueueMetrics to a different server
9.1. Prerequisites
9.2. Required steps
10. Moving the queue_log table to InnoDB
10.1. Prerequisites
10.2. Changes to MySQL
10.3. Changes to QueueMetrics
11. Using Master-master database replication for strong high-availability
11.1. Prerequisites
11.2. Changes to MySQL
11.3. Changes to QueueMetrics
12. Native MySQL logging of queue_log data
12.1. Prerequisites
13. Separating audio recordings in a daily folder
13.1. Prerequisites
13.2. Archiving script
13.3. Changes to QueueMetrics
13.4. Making older files accessible
14. Show ringing phones in the realtime page
15. Using pre-purchased keys (PPK)
15.1. Terminology used
15.2. Converting a PPK into a License key
15.3. Upgrading / downgrading a PPK
16. Enabling log rotation in Tomcat
16.1. Prerequisites
16.2. The rotation file
16.3. Misc changes
16.4. Changes to QueueMetrics
16.5. For further reading
17. Tuning QueueMetrics memory settings
17.1. Prerequisites
17.2. Usage scenario
17.3. Monitoring basics: Java Visual VM
17.4. Troubleshooting: taking thread and memory dumps
17.5. Final Settings
17.6. Quick JVM cheatsheet
18. CRM Integration with QueueMetrics
18.1. Prerequisites
18.2. Integration with SugarCRM
18.3. Integration with VTigerCRM
19. Securing QueueMetrics (Tomcat) With A SSL Certificate
19.1. Introduction
19.2. Instructions
19.3. Removing obsolete Diffie-Hellman ciphers
20. Offlining a part of the queue_log table
20.1. Prerequisites
20.2. Moving data to a temporary table
20.3. Backing up the temporary table
20.4. Restoring data
21. Removing duplicate rows from the queue_log table
21.1. Prerequisites
21.2. Reality check
21.3. Loading unique rows
21.4. Cleaning up
22. Fixing broken indexes on the queue_log table
22.1. Does this apply to you?
22.2. Prerequisites
22.3. How it works
22.4. Procedure
22.5. Cleaning up
23. Printing all QueueMetrics users and agents in one go
24. Bulk renaming audio files
24.1. Removing the initial character in new files
24.2. Renaming old files to remove the plus character
25. Using the WebRTC softphone on the Icon agent page
25.1. Prerequisites
25.2. Installing Asterisk 12.3.0
25.3. Install QueueMetrics
25.4. Configuring Asterisk
25.5. Configuring QueueMetrics
26. QueueMetrics running with UTF-8 charset
27. Running post-call satisfaction IVRs and pushing their results to QM
27.1. Prerequisites
27.2. Implementation
28. Setting up a QueueMetrics WebRTC Softphone
28.1. 1. Introduction
28.2. 2. Asterisk Setup
28.3. 3. Secure Calling (TLS)
28.4. 4. Asterisk Configuration
28.5. 5. QueueMetrics Configuration
28.6. 6. Enabling QueueMetrics HTTPS Connections
28.7. 7. TroubleShooting
29. Keeping track of current client IP for VNC monitoring
29.1. Prerequisites
29.2. Required steps
30. Serving QueueMetrics through a NGINX proxy
30.1. Prerequisites
30.2. NGINX configuration
30.3. Self-signed ssl certificate
30.4. Redirect the requests from Tomcat to Nginx
30.5. Troubleshooting
30.6. Further developments
31. Understanding MySQL storage and clustering
32. Enabling MySQL storage
32.1. Understanding MySQL storage
32.2. Installing Qloaderd
32.3. Setting up QueueMetrics
33. Running QueueMetrics to monitor a cluster of Asterisk servers
33.1. Installing Qloaderd on the Asterisk servers
33.2. Setting up QueueMetrics
34. Tips and tricks for Qloaderd
34.1. Checking how much data is in the database on a daily basis
34.2. Optimizing queue_log access time
35. Getting help