On Sat, Jul 31, 2010 at 8:17 PM, Norman Branitsky <nor...@cherniaksoftware.com> wrote: > After the July 31 update and sipxcs restart to restore the Admin GUI, > I find that Instant Messaging server won't start. > /var/log/sipxpbx/openfire/error.log has messages like this for each of > my users: > Error storing offline presence of user: dennis > org.postgresql.util.PSQLException: > ERROR: duplicate key violates unique constraint "ofpresence_pk"
Here's what I would suggest. all these commands as root 1. shutdown sipxecs /etc/init.d/sipxecs stop 2. drop openfire db, it will be created on next startup dropdb -U postgres openfire 3. force a log rotate, assuming you're ok w/losing 6 day old logs /usr/sbin/logrotate -f /etc/logrotate.conf 4. start sipxecs (or even better restart your system) /etc/init.d/sipxecs start 5.If you still see problems, run sipx-snapshot and you can email me the snapshot (the sipx-configuration-*.tar.gz file) or make it available somewhere. _______________________________________________ sipx-users mailing list sipx-users@list.sipfoundry.org List Archive: http://list.sipfoundry.org/archive/sipx-users/