This discussion is archived
2 Replies Latest reply: Apr 22, 2011 11:07 AM by 537950 RSS

Connect through Socks

user12205126 Newbie
Currently Being Moderated
Hi everybody,

do you know if it's possible to connect sqldeveloper to an instance through socks?

I can confirm that socks setup is working:

user01@gp-fs:~$ uname -a
Linux gp-fs 2.6.32-30-generic #59-Ubuntu SMP Tue Mar 1 21:30:21 UTC 2011 i686 GNU/Linux

user01@gp-fs:~$ socksify sqlplus SCOTT@ORCL

SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 12 12:12:16 2011

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Enter password:
u00000@hostsocks.mydomain.com.1080 sockspassword:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SCOTT@ORCL>

I have tried using socksify to launch sql developer but i got this error:

user01@gp-fs:~$ socksify /opt/sqldeveloper/sqldeveloper-3.0.04.34/sqldeveloper.sh

Oracle SQL Developer
Copyright (c) 1997, 2011, Oracle and/or its affiliates. All rights reserved.

/opt/sqldeveloper/sqldeveloper-3.0.04.34/sqldeveloper/bin/../../ide/bin/launcher.sh: line 544: 8042 Aborted ${JAVA} "${APP_VM_OPTS[@]}" ${APP_ENV_VARS} -classpath ${APP_CLASSPATH} ${APP_MAIN_CLASS} "${APP_APP_OPTS[@]}"

I have also tried passing as argument the standard socks parameters:

user01@gp-fs:~$ /opt/sqldeveloper/sqldeveloper-3.0.04.34/sqldeveloper.sh -DsocksProxyHost=hostsocks.mydomain.com -DsocksProxyPort=1080 -Djava.net.socks.username=u00000 -Djava.net.socks.password=password

Oracle SQL Developer
Copyright (c) 1997, 2011, Oracle and/or its affiliates. All rights reserved.

ARGS:-DsocksProxyHost=hostsocks.mydomain.com
ARGS:-DsocksProxyPort=1080
ARGS:-Djava.net.socks.username=u00000
ARGS:-Djava.net.socks.password=password

but I got this error:

The network adapter could not establish the connection. Vendor code 20

Does anybody has faced this problem?

Bye.

Edited by: user12205126 on Apr 12, 2011 5:37 AM
  • 1. Re: Connect through Socks
    Jim Smith Expert
    Currently Being Moderated
    I know nothing about socks, but anything 'non-standard' on the networking front generally requires the OCI/Thick JDBC driver. Try enabling it in Tools|Preferences|Database|Advanced.

    It will require a 11gR2 client installation.
  • 2. Re: Connect through Socks
    537950 Newbie
    Currently Being Moderated
    I was able to do the follow to connect a JDBC client with SQL Developer through a socks firewall on a Windows 7 machine.

    1. You must have admin rights to the Window 7 machine.
    2. Shutdown any SQL Developers currently running.
    3. On Windows 7 Navigate to SQL Developer "exe" Directory C:\Program Files (x86)\Oracle\SQL Developer\ide\bin.
    4. Backup file ide.conf by copying ide.conf to ide.conf.backup
    5. Add the following to the ide.conf

    AddVMOption -DsocksProxyHost=socks-out.cs.boeing.com
    AddVMOption -DsocksProxyPort=1080

    We don't require user authentication. However, it looks like you do for your configuration. Note that after the AddVMOption it's just straight -D jvm parameters, so I imagine your others will work.

    Good Luck.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points