Database connection via SSH

It would be cool if you add the possibility of connecting via SSH. Example you can see in Mac OS Sequel Pro. Thx!
7 people like
this idea
+1
Reply
  • Walter (Customer Support Representative) December 03, 2010 17:35
    That's definitely something we are interested in doing. Thanks for the suggestion!
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited kidding, amused, unsure, silly sad, anxious, confused, frustrated indifferent, undecided, unconcerned

  • 1
    I have already done this with iSSH. You have to set up port forwarding for port 3306 (mysql's port) for localhost and map it to the host name internally that you are trying to connect to and the port 3306. It works like a champ!
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited kidding, amused, unsure, silly sad, anxious, confused, frustrated indifferent, undecided, unconcerned

  • Walter (Customer Support Representative) June 11, 2011 15:47
    The latest version of DataGlass (version 4) now has support for creating an SSH tunnel in the Advanced properties of the connection. We are very interested in hearing your feedback on this feature.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited kidding, amused, unsure, silly sad, anxious, confused, frustrated indifferent, undecided, unconcerned

  • Good work! I just tried it and it did not work for me. I don't think it is DataGlass' fault though. I'm sure it will work fine for those using it in a corporate network setting via WiFi.

    I on the otherhand access a database over the Internet, and my full ASP (BlueHost) does not allow direct connection to that host directly to make a MySQL connection via port 3306. I'm thinking that is probably why the upgrade did not work for my circumstance when I tested it this morning.

    Basically what I do is open iSSH (another app) and set up port forwarding to 3306 and then in the DataGlass App I set up my host as localhost. It's the same way I do it on my computer. And then it connects right up.

    I did try to import a 128 bit DSA private key and I had some problems getting that to work. Even if I put the pass phrase in. Secondly, however, when I out in the password the test connection was successful.

    I'd be willing to work with DataGlass employees to beta test these features and alternate circumstances that I have. Just email me. Being a software developer myself, I am all about improving software where possible. Working together, I'm sure we can make this App hit a home run with all users!

    Thanks,
    Gene
    • Walter (Customer Support Representative) June 11, 2011 16:52
      So using password authentication from within DataGlass' SSH does work, but pasting in the DSA key does not work? Can you try editing your DSA key to replace newlines with a single whitespace and mailing that to yourself, and then pasting the key into the Key field in DataGlass? We've heard elsewhere that that may fix the problem. If not, can you post any error message that you get when trying to use the SSH key?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited kidding, amused, unsure, silly sad, anxious, confused, frustrated indifferent, undecided, unconcerned

  • I cannot get SSH tunneling to work. Any suggestions? I can use other MySQL clients using the same credentials so I know it's not on the server side. Thanks!
    • view 3 more comments
    • Is there any progress on this? I have DataGlass Version 4.2 (2011-07-09) for PostgreSQL.

      I'm trying to connect to postgresql on Mac OS X 10.7 server. The error I get is:
      Error connecting to database
      Password authentication failed.
      Authentication method password not supported by the server at this stage.

      I've copied the connection settings from my Navicat on Mac OS X, as that works. I can also SSH into that server via iSSH on the iPad.

      I think that I'll try using iSSH to do the port forwarding on the iPad. But, I'd rather keep things simple by letting the DataGlass software handle this.
    • Just to let you know:
      I've tried using iSSH for the port forwarding/tunneling and that works like a champ. As previous users specified, it would be great if this was working natively within DataGlass so I don't have to launch iSSH beforehand.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited kidding, amused, unsure, silly sad, anxious, confused, frustrated indifferent, undecided, unconcerned