I am very new to SQL, and find SQLeo a very useful tool. I run mariaDB (v5) on a SynologyDS.
MariaDB, via phpmyadmin, can demand that login connections are done through SSL, or other secure systems.
Does SQLeo have a mechanism to initiate a secure link?
At the moment, I just use SQLeo in the same physical location as the server, but I soon want to open the data up to other users who are not on-site, and the data is potentially sensitive (and definitely should be treated as such).
Thanks,
David Fong.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
@Pascal - In the second link above, there is an example where ssh tunnelling can be done in Java using http://www.jcraft.com/jsch/ , Do you think we can try to integrate this library in SQLeo and support ssh ? I still have doubt if it still works as 1) it may need client side security certificate for establishing trust 2) client's firewall should unblock the port forwarding etc..
Regards
Anudeep
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
View and moderate all "Technical questions" comments posted by this user
Mark all as spam, and block user from posting to "Discussion"
I am very new to SQL, and find SQLeo a very useful tool. I run mariaDB (v5) on a SynologyDS.
MariaDB, via phpmyadmin, can demand that login connections are done through SSL, or other secure systems.
Does SQLeo have a mechanism to initiate a secure link?
At the moment, I just use SQLeo in the same physical location as the server, but I soon want to open the data up to other users who are not on-site, and the data is potentially sensitive (and definitely should be treated as such).
Thanks,
David Fong.
Hello,
Thank you for using SQLeo.
There nothing in SQLeo to perform secured connections, but you can use what is provided by MariaDB like described here:
https://mariadb.com/blog/connecting-mariadb-through-ssh-tunnel
View and moderate all "Technical questions" comments posted by this user
Mark all as spam, and block user from posting to "Discussion"
Yes SQLeo currently doesn't perform secure connections.
Basically you need to establish ssh tunnel between your local and remote machine and then use local from SQLeo
See http://stackoverflow.com/questions/859218/can-i-ssh-to-mysql-with-the-gui-tools
http://stackoverflow.com/questions/1968293/connect-to-remote-mysql-database-through-ssh-using-java
@Pascal - In the second link above, there is an example where ssh tunnelling can be done in Java using http://www.jcraft.com/jsch/ , Do you think we can try to integrate this library in SQLeo and support ssh ? I still have doubt if it still works as 1) it may need client side security certificate for establishing trust 2) client's firewall should unblock the port forwarding etc..
Regards
Anudeep
May be latter ...
When we will have many developers working in the project
and at the condition of keeping the jar file small
Regards
PAscal