This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Migrating pmx_quarantine database problem

Dear colleagues,

 Recently, i'm migrating the pmx_quarantine database from old machines to new machines.

 After migration process completed, I was unable to open my old quarantine messages when i want to view the full message header. It seems to happen on my old quarantine messages and not the latest one. We have turn off the quarantine messages expire in local services. We are using PMX version 5.5.9 and PostgreSQL database 8.3.3.

Full error:

> Unable to retrieve message for preview. Please ensure that the Manager service is running on your mail filtering

> server(s) and check the PureMessage log for more information about the actual cause of the error.

I checked the pmx_log in /opt/pmx/var/log, and I see the following:

Request https://puremessage.ytlps.my:18080/unauthenticated/pmx-qmeta-index.cgi?global_id=1784688-1&insert_body=1&insert_hits= failed: Unable to instantiate local message object for global id 1784688-1 Content-type: text/plain failure
2 2010-08-05T14:39:21 [11149,milter] 4C5A5C99_11149_1248_1: accepted

:5157


This thread was automatically locked due to age.
  • This particular issue was resolved by manually updating the following files:

    1. pmdb.conf
    2. db.conf
    3. location.conf

    followed by a re-index of the quarantine:

    $ pmx-quarantine reindex
    $ pmx-qindex
    $ pmx-qmeta-index

    For migrating PMX to a new server, we would recommened that you contact Technical Support first for specific instructions for your scenario.

    :5238