I have the HA configuration on a new secondary server, per documentation, and have also corrected permission errors on the directories after the hapack install.
However, when starting pmp-service on the secondary server, it returns the following 'could not create connection' error, and then postgres shuts down.
I could use some help resolving this HA config issue.
[21:03:37:783]|[08-03-2016]|[com.adventnet.mfw.Server]|[SEVERE]|[16]: STACK TRACE|
java.lang.Exception: Exception while initializing DB.
at com.adventnet.persistence.PersistenceInitializer.initialize(PersistenceInitializer.java:330)
at com.adventnet.mfw.Server.startServer(Server.java:151)
at com.adventnet.mfw.Starter.start(Starter.java:334)
at com.adventnet.mfw.Starter.main(Starter.java:447)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:290)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException: Could not create connection; - nested throwable: (org.postgresql.util.PSQLException: The connection attempt failed.); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.postgresql.util.PSQLException: The connection attempt failed.))
at com.adventnet.persistence.PersistenceInitializer.printErrorMsgAndHalt(PersistenceInitializer.java:976)
at com.adventnet.persistence.PersistenceInitializer.startDB(PersistenceInitializer.java:875)
at com.adventnet.persistence.PersistenceInitializer.startDB(PersistenceInitializer.java:773)
at com.adventnet.persistence.PersistenceInitializer.initializeDB(PersistenceInitializer.java:429)
at com.adventnet.persistence.PersistenceInitializer.initialize(PersistenceInitializer.java:326)
... 9 more
[21:03:37:784]|[08-03-2016]|[com.adventnet.db.adapter.Jdbc20DBAdapter]|[INFO]|[16]: splitConnectionURL :: {Port=2345, url_props_delimiter=&, urlWithoutProps=jdbc:postgresql://localhost:2345/PassTrix, jdbcurl_props_separator=?, DBName=PassTrix, Server=localhost}|
[21:03:37:796]|[08-03-2016]|[com.adventnet.db.adapter.Jdbc20DBAdapter]|[INFO]|[16]: splitConnectionURL :: {Port=2345, url_props_delimiter=&, urlWithoutProps=jdbc:postgresql://localhost:2345/PassTrix, jdbcurl_props_separator=?, DBName=PassTrix, Server=localhost}|
[21:03:37:797]|[08-03-2016]|[com.adventnet.db.adapter.AbstractBackupHandler]|[INFO]|[16]: BackUp/Restore Version handler :::: null|
[21:03:37:797]|[08-03-2016]|[com.adventnet.db.adapter.Jdbc20DBAdapter]|[INFO]|[16]: splitConnectionURL :: {Port=2345, url_props_delimiter=&, urlWithoutProps=jdbc:postgresql://localhost:2345/PassTrix, jdbcurl_props_separator=?, DBName=PassTrix, Server=localhost}|
[21:03:37:802]|[08-03-2016]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[16]: Going to stop the DBServer|
[21:03:37:803]|[08-03-2016]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[16]: Template replaced url :: jdbc:postgresql://localhost:2345/PassTrix?ssl=true|
[21:03:37:803]|[08-03-2016]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: /opt/ManageEngine/PMP/bin/../pgsql/bin/pg_isready isExists :: true|
[21:03:37:803]|[08-03-2016]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Stopping PgSQL Server ...|
[21:03:37:803]|[08-03-2016]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Command to be executed [/opt/ManageEngine/PMP/bin/../pgsql/bin/pg_isready, --host, localhost, --port, 2345, --username, postgres] |
[21:03:37:807]|[08-03-2016]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: pg_isready returning status :: 2|
[21:03:37:807]|[08-03-2016]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Database server not running.|
[21:03:37:808]|[08-03-2016]|[SYSOUT]|[INFO]|[47]: localhost:2345 - no response|