Re: SSH Tunneling implementation

On Fri, Jul 6, 2012 at 3:29 PM, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> On Fri, Jul 6, 2012 at 4:26 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>> Hi
>>
>> On Thu, Jul 5, 2012 at 2:07 PM, Akshay Joshi
>> <akshay(dot)joshi(at)enterprisedb(dot)com> wrote:
>>> Hi All
>>>
>>> I have implemented SSH tunneling using libssh2 library and added the logic
>>> into pgAdmin3. With current implementation SSH tunnel will be created using
>>> password as authentication mode. I'll work on the certificate based
>>> authentication. I have attached two patch files 1) SSHTunnel.patch 2)
>>> vcxproj.patch (Only for Windows).
>>>
>>> Below are the steps to build pgadmin
>>>
>>> Download libssh2 source code from http://www.libssh2.org/
>>>
>>> On Windows:-
>>>
>>> Compile libssh2 library on Windows
>>>
>>> "libssh2.dsw" file is available in win32 folder.
>>> Specify path of the OpenSSL's include folder in
>>> "Properties->C++->General->Additional Include Directories"
>>> Specify path of the OpenSSL and Zlib's lib folder in
>>> "Properties->Linker->General->Additional Library Directories"
>>>
>>> Create new environment variable LIBSSH2 and set the path of the libssh2
>>> folder.
>>> Compile pgAdmin3.
>>>
>>> On Linux:-
>>>
>>> To compile libssh2 run ./configure, make and make install.
>>> Compile pgAdmin3.
>>
>> OK, a few issues when testing on Mac:
>
> I haven't actually tested it, but I have a question based on the
> review by dave :-)
>
>> - The Certificate/Password options should align with the text boxes,
>> and have a title. Eg.
>>
>> Authentication (*) Password ( ) Certificate
>
> Is that actually certificate authentication? Is it not ssh public key
> authentication?

Good point. Yes it is.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company