[SOLUTION FOUND] Can't install with external Postgres DB

Solution

http://blog.1e3.ru/2015/04/zoho-manageengine-servicedesk-plus-external-postgresql-database/

1) Install ServiceDesk Plus and run at first time with internal DB (./bin/run.sh);

2) login ServiceDesk Plus and add task, for example and logout;

3) shutdown ServiceDesk Plus (./bin/shutdown.sh -S)

) run ./bin/changeDBserver.sh and save new settings

4) run startDB and dump internal DB ( ./pgsql/bin/pg_dump -h localhost -p 65432 -U postgres -w servicedesk -f dump.sql ) after stopDB.sh

5) restoring dump in external DB

sudo -u postgres bash

psql -U postgres —password —dbname servicedesk -f dump.sql

6)change in /server/default/conf/nms-service.xml

StartDBServer false

7) see /server/default/deploy/postgres-ds.xml to right preferences

8) run

***********************************************

Found this post

But PostgreSQL does not work with an external database

What to do?

[ls@centos bin]$ ./run.sh

Not exists

================================================================================

JBoss Bootstrap Environment

JBOSS_HOME: /home/ls/ManageEngine/ServiceDesk

JAVA: ./../jre/bin/java

JAVA_OPTS: -server -Xms128m -Xmx512m -XX:PermSize=64m -XX:MaxPermSize=128m -Dprogram.name=run.sh -Djboss.server.type=com.adventnet.j2ee.deployment.system.AdventNetServerImpl -Djboss.deploy.localcopy=true -Djboss.boot.library.list=log4j-boot.jar,jboss-common.jar,jboss-system.jar,AdventNetDeploymentSystem.jar,commons-logging.jar -Dsdp.java.gc=false -Ddb.home=./../pgsql -Dserver.dir=/home/ls/ManageEngine/ServiceDesk -Dorg.jboss.logging.Log4jService.catchSystemOut=false -Dorg.jboss.logging.Log4jService.catchSystemErr=false -Djava.util.logging.manager=com.adventnet.logging.LogManager -Djava.util.logging.config.file=/home/ls/ManageEngine/ServiceDesk/server/default/conf/logging.xml -Djava.util.logging.config.class=com.adventnet.logging.LoggingScanner -Dlog.dir=/home/ls/ManageEngine/ServiceDesk/server/default -Dtier-type=BE -Dtier-id=BE1 -Djava.library.path=/home/ls/ManageEngine/ServiceDesk/lib/native -Dfile.encoding=UTF-8 -Duser.language=en -Duser.region=US -Djava.awt.headless=true

CLASSPATH: /home/ls/ManageEngine/ServiceDesk/bin/run.jar:./../jre/lib/tools.jar:/home/ls/ManageEngine/ServiceDesk/lib/AdventNetLogging.jar:/home/ls/ManageEngine/ServiceDesk/lib/AdventNetNPrevalent.jar:/home/ls/ManageEngine/ServiceDesk/lib:/home/ls/ManageEngine/ServiceDesk/lib/AdventNetUpdateManagerInstaller.jar

================================================================================

Server is starting. This may take a couple of minutes ...

This evaluation copy is valid for 29 days

Problem while statrting database. Please check pgsql/data/pg_log/ for more details.

[ls@centos bin]$cat ../pgsql/data/pg_log

LOG: database system was shut down at 2014-01-07 09:13:13 GMT

LOG: database system is ready to accept connections

LOG: autovacuum launcher started

LOG: received fast shutdown request

LOG: aborting any active transactions

LOG: autovacuum launcher shutting down

LOG: shutting down