Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Web Help Desk (WHD) > Migrate data from Windows to Linux/VA

Migrate data from Windows to Linux/VA

Table of contents
No headers

1. Connect to the Virtual Appliance (VA)/Linux machine via SSH as user 'admin' 

2. Once connected, change to the user 'root': type 'sudo su' 

3. Stop WHD > type 'service webhelpdesk stop' 

4. Configure PostgreSQL to allow connection from all interface by editing 'postgresql.conf'  

vi /usr/local/webhelpdesk/bin/pgsql/var/lib/pgsql/9.2/data/postgresql.conf

Scroll through the lines and look for:

#listen_addresses = 'localhost'

then PRESS 'a' key to enter into edit mode and change the previous line to:
listen_addresses = '*'

Note: '#' has been removed to uncomment the line

Save the file pressing SHIFT + 'ZZ' (two 'z' keys)

5. Switch to PostgreSQL user: su - postgres

6. Start PostgreSQL manually using the following command and do not close the SSH window:

/usr/local/webhelpdesk/bin/pgsql/usr/pgsql-9.2/bin/postmaster -p 20293 -D /usr/local/webhelpdesk/bin/pgsql/var/lib/pgsql/9.2/data

7. In the Windows WHD, 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'

11. Run pgAdmin3

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

13. Add the following:

Name: WHDDB
Host: [the VA IP]
Port: 20293
Maintenance DB: postgres
Username: whd
Password: <enter the password you have used originally>

14. Expand 'Databases' > right-click 'whd' and select 'Delete/Drop' from the menu

15. Click 'Yes'

16. Create a new database, right-click on 'Databases'

17. Select 'New Database' and set the following:

Name: whd
Owner: whd

18. Right-click on 'whd' then select 'Restore'

19. Search for the backup file of the PostgreSQL DB. It is usually in 'C:\Program Files\WebHelpDesk\pgsql9\Backups\'. However, you might have possibly changed this path from WHD webconsole > Setup > General > Database'.

20. Click 'Restore'.

21. Once the restore is done and successful, go back to the SSH Window connected to the VA/Linux

22. Do a 'CTRL + C' to stop PostgreSQL from running and type 'exit' to switch back to user 'root'

23. Start WHD on the VA/Linux: service webhelpdesk start

Last modified

Tags

Classifications

Public