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