QueueMetrics - Advanced Configuration Manual

Loway

Revision History
Revision $Revision: 1.14 $$Date: 2013/05/06 09:17:26 $L

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
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
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