SSH tunneling

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

SSH tunneling

Post by tford »

Has anyone used SSH tunneling to connect AwareIM to an existing external database on a remote server?
Tom - V8.8 build 3137 - MySql / PostGres
gernotlg
Posts: 80
Joined: Fri Aug 27, 2021 1:24 am

Re: SSH tunneling

Post by gernotlg »

I had something set up just over a year ago (but I will have to re-learn how to do it, when I finally launch this thing I'm building), when I was seeing if it all was gonna work... and it did work. Worked really well.. but I didn't have AwareIM connecting to the remote Database itself. I had a local database (on the server running AwareIM), MySQL, and the remote database was MySQL.

They spoke to and updated each other using some Federated Tables and SSH tunneling. It worked fine.

I used the Federated Tables in combination with some triggers and scheduling in the Local database, and also on the remote one, so that if and when the SSH connection was down, the AwareIM server would keep operating and the users would be oblivious to a temporary connection issue.
V8.8 / Windows / MySQL
Post Reply