TeamWorks Postgres appliance unable to access phpPgAdmin if PostgreSQL port has been changed

  • 7024412
  • 06-Feb-2020
  • 27-Feb-2020

Environment

GroupWise Teamworks

Situation

To change the port on the Postgres server, login to the PostgreSQL appliance > Configure PostgreSQL > change port to 5433 (or something other than 5432) > Submit.
  Now from the main 9443 PostgreSQL Appliance Tools page select phpPgAdmin > click on PostgreSQL in the left column > attempt to login with valid credentials.  The authentication will fail because phpPgAdmin config is not updated with the changed port.

Resolution

To resolve, update the port in this file:
/opt/novell/srv/www/htdocs/phpPgAdmin/conf/config.inc.php

        // Database port on server (5432 is the PostgreSQL default)
        $conf['servers'][0]['port'] = 5432;

Cause

This problem has been reported to development. If you need to change the port please use this workaround to manually update the  config file.