Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

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
12:51, 16 Aug 2017

Tags

Classifications

Public