Page 1 of 1

Connecting to DB trough proxy

PostPosted: Sun Sep 16, 2012 2:58 pm
by ZoLToR
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...)

Re: Connecting to DB trough proxy

PostPosted: Mon Sep 17, 2012 1:56 pm
by Serge

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.

Re: Connecting to DB trough proxy

PostPosted: Mon Sep 17, 2012 5:13 pm
by ZoLToR
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?

Re: Connecting to DB trough proxy

PostPosted: Tue Sep 18, 2012 9:43 am
by Serge

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 :)

[DONE] Connecting to DB trough proxy

PostPosted: Tue Sep 18, 2012 11:48 am
by ZoLToR
Thank you very much! I will try your advises (especially about SSH tunnel)
port forwarding settings in proxy server are helped for me :D Thanks for idea!!!