Submit a ticketCall us

Quickly Address Software Vulnerabilities
Patch Manager is an intuitive patch management software which extends the capabilities of WSUS and SCCM to not only patch Windows® servers and workstations, and Microsoft® applications, but also other 3rd-party applications which are commonly exploited by hackers. Learn more about our patch management solution.

 

Home > Success Center > Web Help Desk (WHD) > Migrate WHD with embedded PostgreSQL from Windows to SolarWinds WHD VA or to any Linux machine

Migrate WHD with embedded PostgreSQL from Windows to SolarWinds WHD VA or to any Linux machine

Table of contents
No headers
Created by Interspire Import, last modified by Steve.Hawkins on Oct 28, 2016

Views: 50 Votes: 0 Revisions: 6

To migrate WHD with embedded PostgreSQL from Windows to SolarWinds Web Help Desk VA or to any Linux machine:

1. Connect to the VA/Linux machine via SSH as user admin.
Note
: The default password admin. If you have changed the password, use that instead.

2. Once connected, change to the user rootsudo su -

3. Stop the WHDservice: webhelpdesk stop

4. Configure PostgreSQL to allow connection from all interfaces. Edit the postgresql.conf file.

  1. vi /usr/local/webhelpdesk/bin/pgsql/var/lib/pgsql/9.2/data/postgresql.conf
  2. Press A on your keyboard.
  3. Look for the line #listen_addresses = 'localhost' and change it to listen_addresses = '*'
    Note: The # has been removed to uncomment the line.
  4. Save the file by pressing SHIFT + Z + Z.

5. Start PostgreSQL manually using the following command:

/usr/local/webhelpdesk/bin/pgsql/etc/rc.d/init.d/postgresql-9.2 start

6. Switch to PostgreSQL user:su - postgres

7. In the WHD in Windows, go to Setup > General > Database.

8. Click Backup Now.

9. Stop WHD once the backup is done on the Windows machine.

10. Browse to C:\Program Files\WebHelpDesk\pgsql9\bin and run pgAdmin3.

12. In the pgAdmin III window, go to File > Add Server.

13. Add the following:

Name: WHDDB
Host: [the VA/Linux machine's IP Address]
Port: 20293
Maintenance DB: postgres
Username: whd
Password: whd

14. Expand Databases.

15. Right-click whd, select Delete/Drop from the menu and click Yes.

17. Create a new DB. Right-click Databases and select New Database.

18. Set the following:

Name: whd
Owner: whd

19. Right-click whd then select Restore.

20. Search for the backup file of the PostgreSQL DB.

21. Click Restore.

22. Once the restore is done and successful, return to the SSH Window connected to the VA/Linux machine and press CTRL + C to stop PostgreSQL from running.

23. Type exit to switch back to user root.

24. Start Web Help Desk on the VA/Linux machineservice: webhelpdesk start

Last modified
12:27, 28 Oct 2016

Tags

Classifications

Public