QueueMetrics > QueueMetrics installation
QueueMetrics running international charset
(1/1)
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:
&useUnicode=true&characterEncoding=utf8&characterSetResults=utf8
After this modification you should have something like:
<param-value>jdbc:mysql://10.10.3.100/queuemetrics?zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=ldap&password=ldappo&useUnicode=true&characterEncoding=utf8&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
Navigation
[0] Message Index
Go to full version