Presence IM Logging - tables not updating

[danhoffmann2010]

I am at my wits ends here....

I had a workign configuration 2 days ago, then I upgraded my Ubuntu desktop to 11.10, which updated my postgresql database.  Long story-short, I redid my postgresql external database.  It is now an Umbuntu desktop 11.10, postgresql 9.1 and I have pgAdmin3 v1.14.

It is showing connected through Cisco presence and the Cisco tc tables do exist. My problem is the tables are not updating.  I am verifying this through pgAdmin using the provided Cisco SQL scripts.  I have restarted the postgresql service, rebooted the postgre server and restarted the Cisco presence server.

What step am I missing?

Dan

[Christos Georgiadis · Accepted solution]

Hi Dan,

There are some changes done in postgresql 9.1 and you will need to add the following lines in the postgresql.conf

escape_string_warning = off

standard_conforming_strings = off

Can you give it a try and restart the sql service ?

HTH,

Christos

[danhoffmann2010]

Perfect!

Thank you very much

Dan