Connecting to DB trough proxy

Note: please leave bug reports and feature requests on

Connecting to DB trough proxy

Postby ZoLToR » Sun Sep 16, 2012 2:58 pm

Hello.
Is it possible to working with DBeaver through proxy? Need to enter HTTP proxy details to connect to necessary Oracle DB.
I found one proxy setting and configured it in DBeaver settings but it not helped.

Also tryed to enter proxy details in java Network Settings (in windows Control Panel) but it not affected too.

Is it possible to connect to DB from DBeaver through proxy without other tools? (calling "proxyfier" or some else...)
Sorry for my english! :oops:
ZoLToR
 
Posts: 8
Joined: Sun Sep 16, 2012 2:48 pm
Location: Minsk, BY

Re: Connecting to DB trough proxy

Postby Serge » Mon Sep 17, 2012 1:56 pm

Hi,

Do you mean HTTP tunnelling? Currently DBeaver supports only SSH tunnels.
Or do you mean SOCKS proxy?

Generally HTTP proxy won't work in case of database connections. Because HTTP is request based protocol while JDBC requires statefull connection.
As I know some JDBC drivers supports HTTP tunneling (Oracle don't) and some UI clients (like Navicat) have "HTTP Proxy" feature. In fact they require to deploy some software on your server to make such proxies work. At my point of view it is very unsafe and unstable solution.
However in same cases (like LAMP) it might work well because MySQL usually works in non-transactional environment, doesn't lock tables/rows and security is not so important.
But Oracle is a very different story ;)

Anyway we don't have this feature in nearest plans. So, if you do not have SSH access to your firewalled network (where database lives) but still want to acess it I'd suggest to use some third party software for proxy.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Connecting to DB trough proxy

Postby ZoLToR » Mon Sep 17, 2012 5:13 pm

Thank you for your answer!

It too bad for me :(

I have so chain: my computer -> Virtual Machine With connected VPN on it -> Customer Oracle database server. I installed on VM proxy server, I thought that it helped. It enough for access to customer site (I has configured browser to working through HTTP proxy - and it works). We must using VPN to access for customer resources but VPN have restriction: one connection per external IP address. And we using now VM via RDC to get accessing to customer services, but it not comfortable :( So I decided to install a proxy server for solving this problem, but it's no good, as it turned. Maybe you can advise some simple solution in that situation?
Sorry for my english! :oops:
ZoLToR
 
Posts: 8
Joined: Sun Sep 16, 2012 2:48 pm
Location: Minsk, BY

Re: Connecting to DB trough proxy

Postby Serge » Tue Sep 18, 2012 9:43 am

Hello,

As I understood you want to run DBeaver on your local machine while Oracle can be accessed only thru VPN which configured on your VM.
It looks like you need a tunnel on your VM. Or SOCKS proxy. Unfortunatelly DBeaver doesn't support SOCKS proxy but we are going to add this feature in one of next versions.

If you have SSH access to Oracle server then you may setup SSH tunnel on your VM (for example you may use Putty to forward 1521 port , )
Then just configure DBeaver to connect directly to your VM (to the forwarded port).

If you do not have SSH access to Oracle then you may try to use some 3rd party proxy server to forward 1521 port from Oracle host. In fact I'm not very competent in proxy software. But I believe Proxifier will solve the problem :)
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

[DONE] Connecting to DB trough proxy

Postby ZoLToR » Tue Sep 18, 2012 11:48 am

Thank you very much! I will try your advises (especially about SSH tunnel)
Upd:
port forwarding settings in proxy server are helped for me :D Thanks for idea!!!
Sorry for my english! :oops:
ZoLToR
 
Posts: 8
Joined: Sun Sep 16, 2012 2:48 pm
Location: Minsk, BY


Return to Support



Who is online

Users browsing this forum: Google [Bot] and 15 guests