I was able to complete the setup of Postgres DB and configure it to CUPS (for Persistant chat) as per the steps mentioned in the link given below.
Database Setup Guide for Cisco Unified Presence Release 8.0, 8.5 and 8.6 - Configuring an External Database on Cisco Uni…
I see that the checks 'Ping External DB' and ' Connectivity to External DB' both pass. I also see the tables created in the postgres database schema.
The issue I am facing is that the insert statements that persist the chat messages are failing (invalid syntax as per the postgres DB logs).
The sql statement looks like:
INSERT INTO tc_msgarchive(msg_id, to_jid, from_jid, nick_jid, sent_date, msg_type, body_len, message_len, body_string, message_string, body_text, MESSAGE_TEXT, subject)
'<message from=\'email@example.com/jabber_1111\' id=\'uid:5359230a:000049ec:00000679\' to=\'firstname.lastname@example.org\' type=\'groupchat\' xml:lang=\'en\'><body>test</body><html xmlns=\'http://jabber.org/protocol/xhtml-im\'>..........</message>'
ERROR: syntax error at or near "user1" at character 417
The error is because of the '\' (backslash) which is escaping the " ' " single quote in the <message> tag.
If I change the '\' backslash to " ' " , the insert query works fine.
Is anyone facing this issue with postgres DB for chat persistance setup? Is there a way to tell CUPS to use " ' " (single quotes) instead of '/' (backslash).
Go to Solution.
You need to edit the postgressql.conf for the following attribute
escape_string_warning = off
And maybe this as well
backslash_quote = on/off
View solution in original post
Yes I found the information in the link, forgot to update the message.
Instant Messaging Compliance Guide for Cisco Unified Presence Release 8.0, 8.5 and 8.6 - Planning for IM Compliance [Cis…
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: