Issue while connecting to external postgres database.

Issue Description :

If we are tyring to connect to external postgres located in any other machine or Amazon RDS, once we provide the relevant host name and instance name and credentials in Database Setup Wizard it will show connection established and database created but while starting the application it will throw error.

 

Error in wrapper.log

INFO   | jvm 1    | 2016/02/03 12:13:08 | Trying to start PostgresSQL server failed
ERROR  | wrapper  | 2016/02/03 12:13:09 | JVM exited unexpectedly.
STATUS | wrapper  | 2016/02/03 12:13:14 | Launching a JVM…
INFO   | jvm 2    | 2016/02/03 12:13:14 | WrapperManager: Initializing…

 

Solution :

Edit the file postgres-ds which is located under <ServiceDeskPlus MSP_Home>/server/default/deploy  and change the username and password of the new database instance.

<user-name>New username</user-name>
<password>New password</password>

 

Edit the file nms-service which is located under <ServiceDeskPlus MSP_Home>/server/default/conf, change the “StartDBServer” value from true to false

<attribute name=”JndiName”>persistence</attribute>
<attribute name=”StartDBServer”>false</attribute>
<attribute name=”OperationHandler”>

 

Please try to start the application now and it should work.
 

 

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500