Submit a ticketCall us
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:45, 17 May 2017

Tags

Classifications

Public