Submit a ticketCall us

Welcome to the NEW Success Center. Search all resources (documentation, videos, training, knowledge base articles) or browse resources by product. If you are unable to find what you are looking for, please contact us at customersuccess@solarwinds.com

 

 

 

 

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
15:01, 13 Nov 2015

Tags

Classifications

Public