QueueMetrics - Advanced Configuration Manual

Loway

Revision History
Revision 18.04 - covers QueueMetrics 18.042018/04/20L

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. Monitoring and fixing "slow queries" in MySQL
9.1. Prerequisites
9.2. Changes to QueueMetrics
10. Moving QueueMetrics to a different server
10.1. Prerequisites
10.2. Required steps
11. Moving the queue_log table to InnoDB
11.1. Prerequisites
11.2. Changes to MySQL
11.3. Changes to QueueMetrics
12. Using Master-master database replication for strong high-availability
12.1. Prerequisites
12.2. Changes to MySQL
12.3. Changes to QueueMetrics
13. Native MySQL logging of queue_log data
13.1. Prerequisites
14. Separating audio recordings in a daily folder
14.1. Prerequisites
14.2. Archiving script
14.3. Changes to QueueMetrics
14.4. Making older files accessible
15. Show ringing phones in the realtime page
16. Using pre-purchased keys (PPK)
16.1. Terminology used
16.2. Converting a PPK into a License key
16.3. Upgrading / downgrading a PPK
17. Enabling log rotation in Tomcat
17.1. Prerequisites
17.2. The rotation file
17.3. Misc changes
17.4. Changes to QueueMetrics
17.5. For further reading
18. Tuning QueueMetrics memory settings
18.1. Prerequisites
18.2. Usage scenario
18.3. Monitoring basics: Java Visual VM
18.4. Troubleshooting: taking thread and memory dumps
18.5. Final Settings
18.6. Quick JVM cheatsheet
19. CRM Integration with QueueMetrics
19.1. Prerequisites
19.2. Integration with SugarCRM
19.3. Integration with VTigerCRM
20. Securing QueueMetrics (Tomcat) With A SSL Certificate
20.1. Introduction
20.2. Instructions
20.3. Removing obsolete Diffie-Hellman ciphers
21. Offlining a part of the queue_log table
21.1. Prerequisites
21.2. Moving data to a temporary table
21.3. Backing up the temporary table
21.4. Restoring data
22. Removing duplicate rows from the queue_log table
22.1. Prerequisites
22.2. Reality check
22.3. Loading unique rows
22.4. 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. Understanding MySQL storage and clustering
31. Enabling MySQL storage
31.1. Understanding MySQL storage
31.2. Installing Qloaderd
31.3. Setting up QueueMetrics
32. Running QueueMetrics to monitor a cluster of Asterisk servers
32.1. Installing Qloaderd on the Asterisk servers
32.2. Setting up QueueMetrics
33. Tips and tricks for Qloaderd
33.1. Checking how much data is in the database on a daily basis
33.2. Optimizing queue_log access time
34. Getting help