ServiceDesk Plus MSP 10.5 Postgre SQL password

The latest release of ManageEngine ServiceDesk Plus MSP changes the default user and password of the Postgres SQL database.

Previously, the command to connect to the database was:

psql -U postgres -p 65432 -d servicedesk -h 127.0.0.1

The new change shows that there is a change in username and password as follows:

psql -U sdpadmin -p 65432 -d servicedesk -h 127.0.0.1

Username: sdpadmin

Password: sdp@123

ServiceDesk Plus MSP build 14620 and above

The default PostgreSQL database password will now be auto-generated for sdpadmin.

The auto-generated password can be retrieved  by invoking the following script:

  1. Windows: decryptPostgresPassword.bat
  2. Linux: decryptPostgresPassword.sh

When and how will the password be auto-generated?

  1. For existing setups, the password will be auto-generated during migration only if the default password was not updated previously.
  2. For fresh setups, the default password will be auto-generated when the server is started for the first time.
  3. For setups that switch to PostgreSQL database after migrating to 14620 or later, the database password will be auto-generated while executing changeDBServer.bat/.sh script.

The PostgreSQL password for sdpadmin cannot be retrieved after the database configuration is updated from bundled Postgres to external Postgres/MSSQL. Therefore, ensure the password is retrieved and stored in a secure location for future use. If the sdpadmin password is reset to the default password, the application will fail to start.

Change OpManager v11 PDF Report Footer

When generating reports in OpManager v11 and exporting as PDF, the footer contains ManageEngine OpManager Page : as the footer.

To change this, on your OpManager install, navigate to the installation path of OpManager and modify conf\randProps.properties file.  Add the following line, and customize accordingly.

pdfFooterText=Your Company or Whatever | email@yourdomain.com |  Page:

You do not need quotes surrounding the pdfFooterText variable.

Save the file and go generate a report and export to PDF.  Enjoy!

ManageEngine ServiceDesk Plus MSP – Bind to Specific IP

I’m testing out ManageEngine ServiceDesk Plus MSP and trying to get it to bind to a specific IP address on my Linux server to no avail.
Documentation from 2005, 2008, 2011 and 2014 all indicate to modify server/default/conf/TrayIconInfo.xml and add the following changes:

<SDP-PROPERTIES RequestScheme="http" WebPort="80" ipToBind="ww.xx.yy.zz"/>
 <ADDITIONALPARAMS ParamName="ipToBind" ParamValue="-bww.xx.yy.zz"/>

This doesn’t work and still listens on all interfaces causing my other services a conflict.
Eventually if I figure this out, I’ll put a note here for my future reference.

Installing ManageEngine on Linux 64bit

I came across this same error the last time I tried out Manage Engine’s software when installing on a 64bit Debian installation.  So here it is for me to remember now, in case it happens again.

root@xyzzy:~# ./ManageEngine_ServiceDesk_Plus_MSP.bin
InstallShield Wizard
Initializing InstallShield Wizard...
Searching for Java(tm) Virtual Machine...
.
Preparing Java(tm) Virtual Machine...
..................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
........

It just stops there.
The solution is to install libc6-i386.

apt-get install libc6-i386

Now I can run the installation making sure to pass -console since I do not have a DE/WM.