Message-ID: <gh-pgjdbc-pgjdbc-975-c334477801@github.com>
From: "jgangemi (@jgangemi)" <noreply+jgangemi@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Thu, 05 Oct 2017 14:14:10 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #975: Version from 42.1.0 can't connect to 127.0.0.1 with System SOCKS proxy
In-Reply-To: <gh-pgjdbc-pgjdbc-975@github.com>
References: <gh-pgjdbc-pgjdbc-975@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: jgangemi
X-GitHub-Comment-Id: 334477801
X-GitHub-Comment-Type: issue_comment
X-GitHub-Edited-At: 2017-10-05T14:15:16Z
X-GitHub-Issue: 975
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/975#issuecomment-334477801
Content-Type: text/plain; charset=utf-8

seeing this same behavior with version `42.1.4`.
```
[HikariPool-1 connection adder] ERROR org.postgresql.ds.common.BaseDataSource - Failed to create a Non-Pooling DataSource from PostgreSQL JDBC Driver 42.1.4 for fwptools at jdbc:postgresql://172.16.3.128:32774/fwptools?loginTimeout=30: org.postgresql.util.PSQLException: The connection attempt failed.
[HikariPool-1 connection adder] ERROR org.postgresql.Driver - Connection error: 
org.postgresql.util.PSQLException: The connection attempt failed.
	at org.postgresql.Driver$ConnectThread.getResult(Driver.java:401)
	at org.postgresql.Driver.connect(Driver.java:259)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:247)
	at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:94)
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:375)
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:204)
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:445)
	at com.zaxxer.hikari.pool.HikariPool.access$200(HikariPool.java:72)
	at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:632)
	at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:618)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.net.UnknownHostException: 172.16.3.128
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:184)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
	at java.net.Socket.connect(Socket.java:589)
	at org.postgresql.core.PGStream.<init>(PGStream.java:68)
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
	at org.postgresql.Driver.makeConnection(Driver.java:450)
	at org.postgresql.Driver.access$100(Driver.java:60)
	at org.postgresql.Driver$ConnectThread.run(Driver.java:360)
	... 1 more
```
in this case `172.16.3.128` is the ip of my docker vm that the jvm is told to ignore via
```
-DsocksProxyHost=127.0.0.1 -DsocksProxyPort=9998 -DsocksNonProxyHosts=172.16.3.128
```
the last driver version that works w/ this configuration is `42.0.0`

looking through the changelog history, i see a reference to #774 which i am guessing is the cause of this behavior.