I'm (currently) a VPN newby.
I have a VPS with a few websites on it, hosted by liquid web. I have installed a medical records package (openEMR) in a sub-domain, in its own cPanel account. I intend to use the free VPN that liquid web provide, to secure this account; I understand this means installing a VPN client in all PCs/laptops/mobiles that want to use openEMR. (I'm open to advice here as well).
I will also have a public appointment management app (probably easy!appointments), in a separate account, which for security reasons will not link to openEMR. But users are asked to complete a questionnaire when they first book an appointment. This is my problem.
I want to find way to transfer this questionnaire data securely to the openEMR MySQL database. I am looking for suggestions on how to achieve that please?
(I wondered, ignorantly, if it was possible to have a data transfer app running in the appointments account, that could be 'woken-up' on data submit, connect with the VPN, transfer the data out of the appointment apps database, and delete the source data after confirmation ... )
I've been working with a php developer who is suggesting using a php socket over ssh to tunnel between the databases, thus enabling the data to be transmitted immediately.
How secure is this please? What I've read doesn't make it very clear ....