Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

Home > Success Center > Web Help Desk (WHD) > WHD - Knowledgebase Articles > 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