write ssh tunnel to bugaboo

[oschulte]

Hi Wolfgang,

thank you for changing the timeout settings, that’s great. @ZhenSong: please try running the job again.

As for the ssh, we usually work on Mac and Windows. I looked at https://en.wikipedia.org/wiki/Plink and they said Plink was like ssh. So I tried replacing Plink by ssh and it does seem to work!! Specifically, I said

ssh -L 127.0.0.1:3306:db3:3306 -v -l functor -N bugaboo.westgrid.ca

Then I was able to connect to my local host 127.0.0.1 using Mysql workbench and it shows me my db3 files. The only thing I wasn’t able to run mysql from the command line. But I suspect that may just the difficulty of entering the db3 password manually on the command line.

localhost:~ oschulte1$ mysql -h127.0.0.1 -P 3306 -u functor -p
Enter password:
ERROR 1045 (28000): Access denied for user 'functor'@'172.18.1.0' (using password: YES)
localhost:~ oschulte1$

We will try the JDBC connection using the local port forwarding, if that works then we can run our code locally against db3.

@ZhenSong: can you please try if you can first forward the local port to bugaboo, then run BayesBase pointing it to the local port?

Thank you for your patience!