Password manager pro won't restart after certificate change
Hi,
Our PMP primary instance wont start after a reboot of the system. We have ran into this problem after we changed the default certificate for a self signed certificate.
We changed the cert via the web interface: admin > server settings. After we initially changed the cert we had no problems and the webbrowser showed that the new cert was being used.
NOTE: we didn't reboot the system after replacing the cert.
Two weeks after replacing the certificate we rebooted the entire system and found out that PMP won't start anymore.
Could you help us with this issue?
some logging:
Wrapper.log:
STATUS | wrapper | 2017/04/05 11:48:49 | --> Wrapper Started as DaemonSTATUS | wrapper | 2017/04/05 11:48:49 | Java Service Wrapper Professional Edition 64-bit 3.5.25STATUS | wrapper | 2017/04/05 11:48:49 | Copyright (C) 1999-2014 Tanuki Software, Ltd. All Rights Reserved.STATUS | wrapper | 2017/04/05 11:48:49 | http://wrapper.tanukisoftware.comSTATUS | wrapper | 2017/04/05 11:48:49 | Licensed to Zoho Corporation Pvt. Ltd. for Password Manager ProSTATUS | wrapper | 2017/04/05 11:48:49 |WARN | wrapper | 2017/04/05 11:48:49 | The value of wrapper.java.command does not appear to be a java binary.WARN | wrapper | 2017/04/05 11:48:49 | The use of scripts is not supported. Trying to continue, but some features may not work correctly..STATUS | wrapper | 2017/04/05 11:48:49 | Launching a JVM...INFO | jvm 1 | 2017/04/05 11:48:49 | WrapperManager: Initializing...INFO | jvm 1 | 2017/04/05 11:48:50 | Starting Server from location: /home/pmp/ManageEngine/PMPINFO | jvm 1 | 2017/04/05 11:48:50 | This copy is licensed toINFO | jvm 1 | 2017/04/05 11:48:50 |INFO | jvm 1 | 2017/04/05 11:48:53 | 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.))INFO | jvm 1 | 2017/04/05 11:48:53 |INFO | jvm 1 | 2017/04/05 11:48:53 | System haltedINFO | jvm 1 | 2017/04/05 11:48:53 |INFO | jvm 1 | 2017/04/05 11:48:53 |INFO | jvm 1 | 2017/04/05 11:48:53 | Problem while Starting Server
Serverout0.txt
[11:50:03:303]|[04-05-2017]|[com.adventnet.mfw.logging.LoggerUtil]|[INFO]|[16]: Reinitializing logging.properties|[11:50:03:327]|[04-05-2017]|[com.adventnet.mfw.logging.LoggerUtil]|[INFO]|[16]: Properties files merged. Merged file created at ::: ../conf/merged-logging.properties|[11:50:03:610]|[04-05-2017]|[com.adventnet.mfw.Server]|[INFO]|[16]: Creating new Server instance|[11:50:04:159]|[04-05-2017]|[com.adventnet.persistence.ConfigurationParser]|[INFO]|[16]: Processing /home/pmp/ManageEngine/PMP/bin/../conf/product-config.xml|[11:50:04:166]|[04-05-2017]|[com.adventnet.persistence.ConfigurationParser]|[INFO]|[16]: Processing /home/pmp/ManageEngine/PMP/bin/../conf/customer-config.xml|[11:50:04:365]|[04-05-2017]|[com.zoho.net.handshake.HandShakeServer]|[INFO]|[18]: Starting HandShakeServer...|[11:50:04:367]|[04-05-2017]|[com.zoho.net.handshake.HandShakeServer]|[INFO]|[18]: Writing HandShakeServer port [42642] in .lock file|[11:50:04:368]|[04-05-2017]|[com.zoho.net.handshake.HandShakeServer]|[INFO]|[18]: HandShakeServer listening port :: 42642|[11:50:04:368]|[04-05-2017]|[com.zoho.net.handshake.HandShakeServer]|[INFO]|[18]: Waiting for client connection...|[11:50:04:496]|[04-05-2017]|[com.adventnet.persistence.ConfigurationParser]|[INFO]|[16]: Processing /home/pmp/ManageEngine/PMP/bin/../conf/product-config.xml|[11:50:04:502]|[04-05-2017]|[com.adventnet.persistence.ConfigurationParser]|[INFO]|[16]: Processing /home/pmp/ManageEngine/PMP/bin/../conf/customer-config.xml|[11:50:04:598]|[04-05-2017]|[com.zoho.framework.utils.crypto.EnDecrypt]|[SEVERE]|[16]: Encryption failed|[11:50:04:604]|[04-05-2017]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[16]: Reading ./../conf/database_params.conf |[11:50:04:605]|[04-05-2017]|[com.zoho.framework.utils.crypto.EnDecrypt]|[SEVERE]|[16]: Encryption failed|[11:50:04:681]|[04-05-2017]|[SYSERR]|[INFO]|[16]: SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".|[11:50:04:681]|[04-05-2017]|[SYSERR]|[INFO]|[16]: SLF4J: Defaulting to no-operation (NOP) logger implementation|[11:50:04:682]|[04-05-2017]|[SYSERR]|[INFO]|[16]: SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.|[11:50:04:688]|[04-05-2017]|[com.adventnet.ds.DefaultDataSourcePlugIn]|[INFO]|[16]: ConnectionPoolParams :: minSize :: [20], maxSize :: [1], idleTimeout :: [1,800 seconds], blockingTimeout :: [30 seconds]|[11:50:04:802]|[04-05-2017]|[com.adventnet.ds.DefaultDataSourcePlugIn]|[INFO]|[16]: DataSourceorg.jboss.resource.adapter.jdbc.WrapperDataSource@10554f8b|[11:50:04:855]|[04-05-2017]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[16]: Archive Adapter class ::: com.adventnet.db.archive.DefaultArchiveAdapter|[11:50:04:855]|[04-05-2017]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[16]: Storage Adapter class ::: null|[11:50:04:869]|[04-05-2017]|[com.adventnet.db.api.RelationalAPI]|[SEVERE]|[16]: haltjvm.on.dbcrash is set to [true]|[11:50:04:870]|[04-05-2017]|[com.adventnet.db.adapter.Jdbc20DBAdapter]|[INFO]|[16]: shutDownStrings :: []|[11:50:04:870]|[04-05-2017]|[com.adventnet.persistence.PersistenceInitializer]|[SEVERE]|[16]: DBCrashHandler [com.adventnet.passtrix.PMPDBCrashHandler] has been set to RelationalAPI.|[11:50:04:879]|[04-05-2017]|[com.adventnet.db.adapter.Jdbc20DBAdapter]|[INFO]|[16]: Loading the function patterns from the file :: [../conf/Persistence/postgres_functionpatterns.txt]|[11:50:04:880]|[04-05-2017]|[com.adventnet.db.adapter.Jdbc20DBAdapter]|[WARNING]|[16]: Identifier [pgsql_identifiers.txt] file not exist for this database|[11:50:04:881]|[04-05-2017]|[com.adventnet.db.adapter.Jdbc20DBAdapter]|[INFO]|[16]: isDBMigration running :: false|[11:50:04:881]|[04-05-2017]|[com.adventnet.db.adapter.Jdbc20DBAdapter]|[INFO]|[16]: isDBMigration dest DB :: false|[11:50:04:881]|[04-05-2017]|[com.adventnet.db.adapter.postgres.PostgresSQLGenerator]|[INFO]|[16]: Encryption algorithm used :: [aes256]|[11:50:04:882]|[04-05-2017]|[com.adventnet.db.adapter.postgres.PostgresSQLGenerator]|[INFO]|[16]: Encryption s2k-mode used :: [1]|[11:50:04:887]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: db.home ::: ../pgsql|[11:50:04:888]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: dataDirectory :: /home/pmp/ManageEngine/PMP/pgsql/data|[11:50:04:896]|[04-05-2017]|[com.adventnet.db.adapter.AbstractRestoreHandler]|[INFO]|[16]: Restore process fully completed.|[11:50:04:898]|[04-05-2017]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[16]: Template replaced url :: jdbc:postgresql://localhost:2345/PassTrix?ssl=true|[11:50:04:899]|[04-05-2017]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[16]: Reading ./../conf/database_params.conf |[11:50:04:905]|[04-05-2017]|[com.adventnet.db.adapter.postgres.PostgresDBAdapter]|[INFO]|[16]: port not specified in ../pgsql/data/postgresql.conf returning default port 5432|[11:50:04:905]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: /home/pmp/ManageEngine/PMP/bin/../pgsql/bin/pg_isready isExists :: true|[11:50:04:906]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Command to be executed [/home/pmp/ManageEngine/PMP/bin/../pgsql/bin/pg_isready, --host, localhost, --port, 2345, --username, postgres] |[11:50:04:923]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: pg_isready returning status :: 2|[11:50:04:924]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Checking for IPV6 support|[11:50:04:925]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Resolved address of host [localhost] is [localhost/127.0.0.1]|[11:50:04:925]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Going to start DB server using pg_ctl utility.|[11:50:04:926]|[04-05-2017]|[SYSOUT]|[INFO]|[22]: localhost:2345 - no response|[11:50:04:931]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Command to be executed [/home/pmp/ManageEngine/PMP/pgsql/bin/pg_ctl, -w, -D, /home/pmp/ManageEngine/PMP/pgsql/data, -o, "-p2345", start] |[11:50:04:939]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: is DB registered as a service ::: false|[11:50:04:940]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Command to be executed [/home/pmp/ManageEngine/PMP/bin/../pgsql/bin/pg_isready, --host, localhost, --port, 2345, --username, postgres] |[11:50:04:947]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: pg_isready returning status :: 2|[11:50:04:948]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: isServerRunning :: false|[11:50:04:948]|[04-05-2017]|[SYSOUT]|[INFO]|[27]: localhost:2345 - no response|[11:50:05:948]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Command to be executed [/home/pmp/ManageEngine/PMP/bin/../pgsql/bin/pg_isready, --host, localhost, --port, 2345, --username, postgres] |[11:50:05:984]|[04-05-2017]|[SYSOUT]|[INFO]|[29]: localhost:2345 - accepting connections|[11:50:05:996]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: pg_isready returning status :: 0|[11:50:05:997]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Validating data_directory path with running server.|[11:50:05:998]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: hostAddress of localhost is 127.0.0.1|[11:50:05:998]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Command to be executed :::: [/home/pmp/ManageEngine/PMP/pgsql/bin/psql, -U, postgres, -p, 2345, -h, 127.0.0.1, -c, SHOW data_directory, -d, postgres, -w] |[11:50:05:999]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Command to be executed [/home/pmp/ManageEngine/PMP/pgsql/bin/psql, -U, postgres, -p, 2345, -h, 127.0.0.1, -c, SHOW data_directory, -d, postgres, -w] |[11:50:06:043]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: dataDirectory path from server :: /home/pmp/ManageEngine/PMP/pgsql/data|[11:50:06:045]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: isServerStarted :: going to return :: true|[11:50:06:045]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Checking is DB server ready to accept connection...|[11:50:06:046]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: hostAddress of localhost is 127.0.0.1|[11:50:06:046]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Command to be executed :::: [/home/pmp/ManageEngine/PMP/pgsql/bin/psql, -U, postgres, -p, 2345, -h, 127.0.0.1, -c, SELECT 1, -d, postgres, -w] |[11:50:06:047]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Command to be executed [/home/pmp/ManageEngine/PMP/pgsql/bin/psql, -U, postgres, -p, 2345, -h, 127.0.0.1, -c, SELECT 1, -d, postgres, -w] |[11:50:06:083]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Database server responsing...Database server is now READY to accept connections!!!|[11:50:06:085]|[04-05-2017]|[com.adventnet.db.adapter.postgres.PostgresDBAdapter]|[INFO]|[16]: isDBReadyToAcceptConnection returns ::: true|[11:50:06:085]|[04-05-2017]|[com.adventnet.db.adapter.postgres.PostgresDBAdapter]|[INFO]|[16]: Database server sucessfully started.|[11:50:06:086]|[04-05-2017]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[16]: Template replaced url :: jdbc:postgresql://localhost:2345/PassTrix?ssl=true|[11:50:06:086]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: hostAddress of localhost is 127.0.0.1|[11:50:06:087]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Command to be executed :::: [/home/pmp/ManageEngine/PMP/pgsql/bin/psql, -U, postgres, -p, 2345, -h, 127.0.0.1, -c, CREATE DATABASE "PassTrix", -d, postgres, -w] |[11:50:06:087]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Command to be executed [/home/pmp/ManageEngine/PMP/pgsql/bin/psql, -U, postgres, -p, 2345, -h, 127.0.0.1, -c, CREATE DATABASE "PassTrix", -d, postgres, -w] |[11:50:06:122]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: ErrorStream ::: ERROR: database "PassTrix" already exists|[11:50:06:123]|[04-05-2017]|[com.adventnet.db.adapter.postgres.PostgresDBAdapter]|[INFO]|[16]: createDB returns ::: true|[11:50:06:908]|[04-05-2017]|[com.adventnet.persistence.PersistenceInitializer]|[SEVERE]|[16]: 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.))|org.jboss.util.NestedSQLException: 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 org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:106)at com.adventnet.persistence.PersistenceInitializer.startDB(PersistenceInitializer.java:826)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)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: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.postgresql.util.PSQLException: The connection attempt failed.)at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:168)at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:508)at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:207)at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:534)at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:444)at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:298)at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)at com.adventnet.ds.DefaultDataSourcePlugIn$ConnectionManagerProxy.allocateConnection(DefaultDataSourcePlugIn.java:179)at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)... 13 moreCaused by: org.postgresql.util.PSQLException: The connection attempt failed.at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:150)at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:30)at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)at org.postgresql.Driver.makeConnection(Driver.java:393)at org.postgresql.Driver.connect(Driver.java:267)at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:158)... 21 moreCaused by: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested targetat sun.security.ssl.Alerts.getSSLException(Alerts.java:192)at sun.security.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1916)at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:279)at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:273)at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1472)at sun.security.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:213)at sun.security.ssl.Handshaker.processLoop(Handshaker.java:913)at sun.security.ssl.Handshaker.process_record(Handshaker.java:849)at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:1035)at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1344)at sun.security.ssl.SSLSocketImpl.writeRecord(SSLSocketImpl.java:721)at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:122)at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)at org.postgresql.core.PGStream.flush(PGStream.java:523)at org.postgresql.core.v3.ConnectionFactoryImpl.sendStartupPacket(ConnectionFactoryImpl.java:257)at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:105)... 30 moreCaused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested targetat sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:385)at sun.security.validator.PKIXValidator.engineValidate(PKIXValidator.java:292)at sun.security.validator.Validator.validate(Validator.java:260)at sun.security.ssl.X509TrustManagerImpl.validate(X509TrustManagerImpl.java:326)at sun.security.ssl.X509TrustManagerImpl.checkTrusted(X509TrustManagerImpl.java:231)at sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(X509TrustManagerImpl.java:126)at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1454)... 42 moreCaused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested targetat sun.security.provider.certpath.SunCertPathBuilder.engineBuild(SunCertPathBuilder.java:196)at java.security.cert.CertPathBuilder.build(CertPathBuilder.java:268)at sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:380)... 48 more
[11:50:06:909]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: /home/pmp/ManageEngine/PMP/bin/../pgsql/bin/pg_isready isExists :: true|[11:50:06:909]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Stopping PgSQL Server ...|[11:50:06:910]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Command to be executed [/home/pmp/ManageEngine/PMP/bin/../pgsql/bin/pg_isready, --host, localhost, --port, 2345, --username, postgres] |[11:50:06:925]|[04-05-2017]|[SYSOUT]|[INFO]|[38]: localhost:2345 - accepting connections|[11:50:06:925]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: pg_isready returning status :: 0|[11:50:06:925]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Going to stop DB server using pg_ctl utility.|[11:50:06:926]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Command to be executed [/home/pmp/ManageEngine/PMP/pgsql/bin/pg_ctl, -w, -D, /home/pmp/ManageEngine/PMP/pgsql/data, -o, "-p2345", stop, -s, -m, fast] |[11:50:06:929]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Command to be executed [/home/pmp/ManageEngine/PMP/bin/../pgsql/bin/pg_isready, --host, localhost, --port, 2345, --username, postgres] |[11:50:06:941]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: pg_isready returning status :: 1|[11:50:06:942]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: isServerRunning :: false|[11:50:06:942]|[04-05-2017]|[SYSOUT]|[INFO]|[43]: localhost:2345 - rejecting connections|[11:50:07:942]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Command to be executed [/home/pmp/ManageEngine/PMP/bin/../pgsql/bin/pg_isready, --host, localhost, --port, 2345, --username, postgres] |[11:50:07:949]|[04-05-2017]|[SYSOUT]|[INFO]|[45]: localhost:2345 - no response|[11:50:07:951]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: pg_isready returning status :: 2|[11:50:07:952]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: isServerStopped :: going to return :: true|[11:50:07:952]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: is DB registered as a service ::: false|[11:50:07:953]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: isServerStopped method returning status ::: true|[11:50:07:953]|[04-05-2017]|[com.adventnet.persistence.PersistenceInitializer]|[SEVERE]|[16]: Problem while starting Database due to: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.))|[11:50:07:955]|[04-05-2017]|[SYSERR]|[INFO]|[16]: java.lang.Exception: Exception while initializing DB.|[11:50:07:955]|[04-05-2017]|[SYSERR]|[INFO]|[16]: at com.adventnet.persistence.PersistenceInitializer.initialize(PersistenceInitializer.java:330)|[11:50:07:955]|[04-05-2017]|[SYSERR]|[INFO]|[16]: at com.adventnet.mfw.Server.startServer(Server.java:151)|[11:50:07:956]|[04-05-2017]|[SYSERR]|[INFO]|[16]: at com.adventnet.mfw.Starter.start(Starter.java:334)|[11:50:07:956]|[04-05-2017]|[SYSERR]|[INFO]|[16]: at com.adventnet.mfw.Starter.main(Starter.java:447)|[11:50:07:956]|[04-05-2017]|[SYSERR]|[INFO]|[16]: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)|[11:50:07:957]|[04-05-2017]|[SYSERR]|[INFO]|[16]: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)|[11:50:07:957]|[04-05-2017]|[SYSERR]|[INFO]|[16]: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)|[11:50:07:958]|[04-05-2017]|[SYSERR]|[INFO]|[16]: at java.lang.reflect.Method.invoke(Method.java:606)|[11:50:07:958]|[04-05-2017]|[SYSERR]|[INFO]|[16]: at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:290)|[11:50:07:958]|[04-05-2017]|[SYSERR]|[INFO]|[16]: at java.lang.Thread.run(Thread.java:745)|[11:50:07:959]|[04-05-2017]|[SYSERR]|[INFO]|[16]: 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.))|[11:50:07:959]|[04-05-2017]|[SYSERR]|[INFO]|[16]: at com.adventnet.persistence.PersistenceInitializer.printErrorMsgAndHalt(PersistenceInitializer.java:976)|[11:50:07:960]|[04-05-2017]|[SYSERR]|[INFO]|[16]: at com.adventnet.persistence.PersistenceInitializer.startDB(PersistenceInitializer.java:875)|[11:50:07:960]|[04-05-2017]|[SYSERR]|[INFO]|[16]: at com.adventnet.persistence.PersistenceInitializer.startDB(PersistenceInitializer.java:773)|[11:50:07:960]|[04-05-2017]|[SYSERR]|[INFO]|[16]: at com.adventnet.persistence.PersistenceInitializer.initializeDB(PersistenceInitializer.java:429)|[11:50:07:961]|[04-05-2017]|[SYSERR]|[INFO]|[16]: at com.adventnet.persistence.PersistenceInitializer.initialize(PersistenceInitializer.java:326)|[11:50:07:961]|[04-05-2017]|[SYSERR]|[INFO]|[16]: ... 9 more|[11:50:07:961]|[04-05-2017]|[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
[11:50:07:962]|[04-05-2017]|[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}|[11:50:07:982]|[04-05-2017]|[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}|[11:50:07:983]|[04-05-2017]|[com.adventnet.db.adapter.AbstractBackupHandler]|[INFO]|[16]: BackUp/Restore Version handler :::: null|[11:50:07:983]|[04-05-2017]|[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}|[11:50:07:995]|[04-05-2017]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[16]: Going to stop the DBServer|[11:50:07:996]|[04-05-2017]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[16]: Template replaced url :: jdbc:postgresql://localhost:2345/PassTrix?ssl=true|[11:50:07:996]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: /home/pmp/ManageEngine/PMP/bin/../pgsql/bin/pg_isready isExists :: true|[11:50:07:997]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Stopping PgSQL Server ...|[11:50:07:997]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Command to be executed [/home/pmp/ManageEngine/PMP/bin/../pgsql/bin/pg_isready, --host, localhost, --port, 2345, --username, postgres] |[11:50:08:004]|[04-05-2017]|[SYSOUT]|[INFO]|[47]: localhost:2345 - no response|[11:50:08:005]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: pg_isready returning status :: 2|[11:50:08:005]|[04-05-2017]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Database server not running.|[11:50:08:008]|[04-05-2017]|[SYSERR]|[INFO]|[16]: java.lang.Exception: Exception while initializing DB.|[11:50:08:008]|[04-05-2017]|[SYSERR]|[INFO]|[16]: at com.adventnet.persistence.PersistenceInitializer.initialize(PersistenceInitializer.java:330)|[11:50:08:009]|[04-05-2017]|[SYSERR]|[INFO]|[16]: at com.adventnet.mfw.Server.startServer(Server.java:151)|[11:50:08:009]|[04-05-2017]|[SYSERR]|[INFO]|[16]: at com.adventnet.mfw.Starter.start(Starter.java:334)|[11:50:08:009]|[04-05-2017]|[SYSERR]|[INFO]|[16]: at com.adventnet.mfw.Starter.main(Starter.java:447)|[11:50:08:010]|[04-05-2017]|[SYSERR]|[INFO]|[16]: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)|[11:50:08:010]|[04-05-2017]|[SYSERR]|[INFO]|[16]: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)|