Real Software Forums

The forum for Real Studio and other Real Software products.
[ REAL Software Website | Board Index ]
It is currently Wed Nov 14, 2018 10:44 pm
xojo

All times are UTC - 5 hours




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: PostgreSQL over SSH tunnel
PostPosted: Wed Mar 13, 2013 12:22 pm 
Offline

Joined: Mon Dec 27, 2010 5:43 am
Posts: 55
Location: Switzerland
Evenin' (o;

I read somewhere lately that the new release of RealStudio support SSH tunneling for PostgreSQL connections, but don't see anything in the examples folder.

Does someone has a hint where to start?


thanx in advance
richard

_________________
Real Studio 2011 R4.3 Enterprise, iMac 27 3.4GHz i7, 16GB, OCZ Vertex-3


Top
 Profile  
Reply with quote  
 Post subject: Re: PostgreSQL over SSH tunnel
PostPosted: Wed Mar 13, 2013 1:49 pm 
Offline
User avatar

Joined: Fri Sep 30, 2005 11:48 am
Posts: 3554
Location: Lenexa, KS
It might be covered at http://docs.realsoftware.com/index.php/PostgreSQLDatabase.Connect. Looks like there are optional parameters in the connect method.

_________________
Bob K.

A blog about being a Real Studio/Xojo developer at http://www.bkeeneybriefs.com


Top
 Profile  
Reply with quote  
 Post subject: Re: PostgreSQL over SSH tunnel
PostPosted: Fri Mar 15, 2013 11:38 am 
Offline

Joined: Mon Dec 27, 2010 5:43 am
Posts: 55
Location: Switzerland
Hmm..this looks more like an encrypted SSL connection than a regular DB connection over a SSH tunnel...
So looks it is not possible at all then...

_________________
Real Studio 2011 R4.3 Enterprise, iMac 27 3.4GHz i7, 16GB, OCZ Vertex-3


Top
 Profile  
Reply with quote  
 Post subject: Re: PostgreSQL over SSH tunnel
PostPosted: Fri Mar 15, 2013 12:44 pm 
Offline
Real Software Engineer

Joined: Sat Dec 24, 2005 8:18 pm
Posts: 7858
Location: Canada, Alberta, Near Red Deer
You can manually set up a SSH tunnel but that's not the same as a direct SSL connection to a postgres db

_________________
Norman Palardy (Real Software)


Top
 Profile  
Reply with quote  
 Post subject: Re: PostgreSQL over SSH tunnel
PostPosted: Fri Mar 15, 2013 12:52 pm 
Offline

Joined: Mon Dec 27, 2010 5:43 am
Posts: 55
Location: Switzerland
Well setting up a SSH tunnel within RealStudio would be perfect (o;

Especially for multi-OS application where a SSH tunnel is not possible or no user intervention should be done...

Looks like there's http access the only way as I don't want to open port 5432 to everyone in a large corporation (o;

_________________
Real Studio 2011 R4.3 Enterprise, iMac 27 3.4GHz i7, 16GB, OCZ Vertex-3


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC - 5 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group