QueueMetrics running international charset

[marcos]

Hi All,
for all interested People, I post here my experience with QueueMetrics using international charset. This lets possible to use international chars in agents, queues alias agaw messages and so on.

Here are the steps:

1. Run the following commands on all tables of the database but the queue_log table:

ALTER TABLE `agaw_alarms` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `agaw_dati` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `agaw_logs` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `agaw_runs` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `agenti_noti` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `arch_classes` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `arch_syslog` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `arch_users` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `broadcast_msg` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `call_status` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `code_possibili` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `dbversion` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `locations` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `oq_calls` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `oq_notes` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `oq_queues` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `pause_codes` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `qa_data` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `qa_forms` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `qa_forms_items` CONVERT TO CHARACTER SET utf8;

2. Open the QueueMetrics web.xml and modify the connection string adding, before the </param-value> tag, the string:

&amp;useUnicode=true&amp;characterEncoding=utf8&amp;characterSetResults=utf8

After this modification you should have something like:
<param-value>jdbc:mysql://10.10.3.100/queuemetrics?zeroDateTimeBehavior=convertToNull&amp;jdbcCompliantTruncation=false&amp;user=ldap&amp;password=ldappo&amp;useUnicode=true&amp;characterEncoding=utf8&amp;characterSetResults=utf8</param-value>

3. Then download the latest MySQL java connector binary package you can find at the link:
http://dev.mysql.com/downloads/connector/j/5.1.html

Extract the mysql-connector-java-5.1.7-bin.jar file and copy it on your QueueMetrics box, placing in the folder /usr/share/java.
Replace the symbolic link you can find in the /usr/local/queuemetrics/webapps/queuemetrics-1.5.x/WEB-INF/lib in order to have it pointing to new connector.

4. Restart the QueueMetrics service issuing a /etc/init.d/queuemetrics restart

This sould enable the utf8 support.

Regards,
Marco