2 Replies Latest reply: Apr 22, 2011 1:07 PM by 537950 RSS

    Connect through Socks

    user12205126
      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
          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
            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.