In the atempt to descontinue the use of the selfsigned certificate of PMP to use our own SSL certificate, we followed the instructions provided in this link (OpenSSL method) and managed to successfully get it working.

After some tests, we noticed that the RDP Console was still using a selfsigned certificate.

On some of our first requests for support on PMP, we asked about the SSL certificate change and were also given instructions on how to do it for the RDP Gateway, as can be found on the document attached.

As the instructions on the link and the ones on the word document are practically the same, we thought that the only remaining step to follow was the last instruction on step "4" of the document, which is replacing the store password on the following line of the " wrapper.conf" file:

1. wrapper.java.additional.22=-Djavax.net.ssl.keyStorePassword=passtrix

After trying to restart the server, it could not start anymore. Changing the store password back to "passtrix" made the server being able to start again. We went trough the try and figure out the cause of the error, but to no avail. But we managed to notice the recurrent output on the diferent log files:

1. INFO   | jvm 1    | 2015/01/09 10:08:54 | 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.))
3. [10:08:52:662]|[01-09-2015]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Stopping PgSQL Server ...|
4. [10:08:52:662]|[01-09-2015]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Going to stop DB server using pg_ctl utility.|
5. [10:08:52:662]|[01-09-2015]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Command to be executed [C:\ManageEngine\PMP\pgsql\bin\pg_ctl.exe, -D, C:\ManageEngine\PMP\pgsql\data, -o, "-p2345", stop, -s, -m, fast] |
6. [10:08:53:692]|[01-09-2015]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Command to be executed [C:\ManageEngine\PMP\pgsql\bin\pg_ctl.exe, status, -D, C:\ManageEngine\PMP\pgsql\data] |
7. [10:08:53:723]|[01-09-2015]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Server status :: pg_ctl: no server running|
8. [10:08:54:737]|[01-09-2015]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: isServerStopped :: going to return :: true|
9. [10:08:54:737]|[01-09-2015]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: is DB registered as a service ::: false|
10. [10:08:54:737]|[01-09-2015]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: Check PID status default timeout |
11. [10:08:54:737]|[01-09-2015]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: postmaster.pid file doesn't exist.|
12. [10:08:54:737]|[01-09-2015]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[16]: isServerStopped method returning status ::: true|
13. [10:08:54:737]|[01-09-2015]|[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.))|
14. [10:08:54:737]|[01-09-2015]|[SYSERR]|[INFO]|[16]: java.lang.Exception: Exception while initializing DB.|
15. [10:08:54:737]|[01-09-2015]|[SYSERR]|[INFO]|[16]: at com.adventnet.persistence.PersistenceInitializer.initialize(PersistenceInitializer.java:321)|
16. [10:08:54:737]|[01-09-2015]|[SYSERR]|[INFO]|[16]: at com.adventnet.mfw.Server.startServer(Server.java:130)|
17. [10:08:54:737]|[01-09-2015]|[SYSERR]|[INFO]|[16]: at com.adventnet.mfw.Starter.start(Starter.java:319)|
18. [10:08:54:737]|[01-09-2015]|[SYSERR]|[INFO]|[16]: at com.adventnet.mfw.Starter.main(Starter.java:368)|
19. [10:08:54:737]|[01-09-2015]|[SYSERR]|[INFO]|[16]: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)|
20. [10:08:54:737]|[01-09-2015]|[SYSERR]|[INFO]|[16]: at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)|
21. [10:08:54:737]|[01-09-2015]|[SYSERR]|[INFO]|[16]: at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)|
22. [10:08:54:737]|[01-09-2015]|[SYSERR]|[INFO]|[16]: at java.lang.reflect.Method.invoke(Unknown Source)|
23. [10:08:54:737]|[01-09-2015]|[SYSERR]|[INFO]|[16]: at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:290)|
24. [10:08:54:737]|[01-09-2015]|[SYSERR]|[INFO]|[16]: at java.lang.Thread.run(Unknown Source)|
25. [10:08:54:737]|[01-09-2015]|[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.))|
26. [10:08:54:737]|[01-09-2015]|[SYSERR]|[INFO]|[16]: at com.adventnet.persistence.PersistenceInitializer.printErrorMsgAndHalt(PersistenceInitializer.java:864)|
27. [10:08:54:753]|[01-09-2015]|[SYSERR]|[INFO]|[16]: at com.adventnet.persistence.PersistenceInitializer.startDB(PersistenceInitializer.java:789)|
28. [10:08:54:753]|[01-09-2015]|[SYSERR]|[INFO]|[16]: at com.adventnet.persistence.PersistenceInitializer.initializeDB(PersistenceInitializer.java:391)|
29. [10:08:54:753]|[01-09-2015]|[SYSERR]|[INFO]|[16]: at com.adventnet.persistence.PersistenceInitializer.initialize(PersistenceInitializer.java:317)|
30. [10:08:54:753]|[01-09-2015]|[SYSERR]|[INFO]|[16]: ... 9 more|
31. [10:08:54:753]|[01-09-2015]|[com.adventnet.mfw.Server]|[SEVERE]|[16]: STACK TRACE| 
32. java.lang.Exception: Exception while initializing DB.
33. at com.adventnet.persistence.PersistenceInitializer.initialize(PersistenceInitializer.java:321)
34. at com.adventnet.mfw.Server.startServer(Server.java:130)
35. at com.adventnet.mfw.Starter.start(Starter.java:319)
36. at com.adventnet.mfw.Starter.main(Starter.java:368)
37. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
38. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
39. at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
40. at java.lang.reflect.Method.invoke(Unknown Source)
41. at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:290)
42. at java.lang.Thread.run(Unknown Source)
43. 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.))
44. at com.adventnet.persistence.PersistenceInitializer.printErrorMsgAndHalt(PersistenceInitializer.java:864)
45. at com.adventnet.persistence.PersistenceInitializer.startDB(PersistenceInitializer.java:789)
46. at com.adventnet.persistence.PersistenceInitializer.initializeDB(PersistenceInitializer.java:391)
47. at com.adventnet.persistence.PersistenceInitializer.initialize(PersistenceInitializer.java:317)
48. ... 9 more

Did we miss something? Should we run trough all the steps on the "SSL certificate for RDP Gateway" document? We don't think so because we already have signed certificate issued for our PMP.

Thanks & regards

Mércio