Can't open PureMessage Manage Quarantine

this is the output as pmx user (we are still on version 5.6)

$ env

MANPATH=/opt/pmx/man:/opt/pmx/sendmail/man:/opt/pmx/postfix/man
HOSTNAME=mail.xxxxx.xx
SHELL=/bin/bash
TERM=xterm
HISTSIZE=1000
TMPDIR=/var/tmp
NLS_LANG=AMERICAN_AMERICA.EL8ISO8859P7
LD_32_LIBRARY_PATH=/opt/pmx/lib
USER=pmx
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
LD_LIBRARY_PATH=/opt/oracle/oraclehome/lib
ORACLE_SID=
ORACLE_BASE=/opt/oracle
TNS_ADMIN=/opt/oracle/oraclehome/network/admin
MAIL=/var/spool/mail/pmx
PATH=/opt/pmx/bin:/opt/pmx/etc/init.d:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/opt/oracle/oraclehome/bin:/opt/oracle/oraclehome/lib
INPUTRC=/etc/inputrc
PWD=/opt/pmx/home
LANG=en_US.UTF-8
ORACLE_TERM=xterm
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SHLVL=1
HOME=/opt/pmx/home
LOGNAME=pmx
CVS_RSH=ssh
CLASSPATH=/opt/oracle/oraclehome/JRE:/opt/oracle/oraclehome/jlib:/opt/oracle/oraclehome/rdbms/jlib
LESSOPEN=|/usr/bin/lesspipe.sh %s
ORACLE_HOME=/opt/oracle/oraclehome
G_BROKEN_FILENAMES=1
_=/bin/env

$ ldd /opt/pmx/postgres/bin/psql

        linux-gate.so.1 =>  (0xffffe000)
        libpq.so.5 => not found
        libcrypt.so.1 => /lib/libcrypt.so.1 (0x006a4000)
        libdl.so.2 => /lib/libdl.so.2 (0xf7f6f000)
        libm.so.6 => /lib/libm.so.6 (0xf7f46000)
        libc.so.6 => /lib/libc.so.6 (0x00549000)
        /lib/ld-linux.so.2 (0x0052a000)

Ah,

OK, the LD_LIBRARY is missing from your environment settings. I would check the file .pmx_sh_vars and make sure that the following lines are listed.

if test -z "${LD_LIBRARY_PATH:-}"; then
    LD_LIBRARY_PATH="/opt/pmx/lib"
else
    LD_LIBRARY_PATH="/opt/pmx/lib:$LD_LIBRARY_PATH"
fi

if test -z "${LD_32_LIBRARY_PATH:-}"; then
    LD_32_LIBRARY_PATH="/opt/pmx/lib"
else
    LD_32_LIBRARY_PATH="/opt/pmx/lib:$LD_32_LIBRARY_PATH"
fi

I see that LD_32_LIBRARY_PATH is set in you environment but not LD_LIBRARY_PATH.  You could manually test it by setting the value at the shell to see if the database will start.

$ export LD_LIBRARY_PATH=/opt/pmx/lib

$ pmx-database start

-Jason

We tried the manual test

$ export LD_LIBRARY_PATH=/opt/pmx/lib

$ pmx-database sta

and now the quarantine is responding in queries

(but we see only quite old entries..) // edit - now we see fresh entries .

but the postgreSQL service is still shown as stopped

The manager should query the directory for postmaster.pid in /opt/pmx/postgres/var/data/.  This is the same as what should be found when doing a pmx status.

The permissions of the file should be 600 with ownership of pmx:pmx, it should contain the PID of the postmaster process.

-Jason

the permissions are right

we get results when searching quarantine, but

PostgreSQL service is still shown as stopped (and we can't get it started)

We have the same issue again..

PureMessage is working, but we can't access the quarantine, and the manual method we used on November don't work now..

we get this error when we try to query
Can't call method "prepare" on unblessed reference at /opt/pmx/lib/site_perl/5.8.7/PureMessage/MessageStore/pmdb/MessageSet.pm line 215.
at /opt/pmx/lib/manager/Quarantine/Manage/index.cgi line 1006

PostgreSQL Service remains stopped in the dashboard, no matter if we try to restart it.

Even when we try to manually restart it by command line, we get
this error ..

/opt/pmx/postgres/bin/pg_ctl: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory
/opt/pmx/postgres/bin/pg_ctl: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory