#1453 Proxy setting in Squirrel tool

[kalyani]

Hi
I am using squirrel 4.1.0 and trying to connect to aws redshift database(private) using federated access. I have to use proxy server and when i have given proxy details in the global preferences--> http proxy the proxy server details, its not working. Our proxy team checked and said that my request is not going through the proxy server i mentioned in the tool? How i can force the tool to use proxy server to make a connection?

[Gerd Wagner]

Sorry, I don't have the chance to test a JDBC connection via a proxy myself.

If you know a bit of Java you could try out the following:
Configure your proxy using
java.lang.System.getProperties().put("proxySet", "true");
java.lang.System.getProperties().put("http.proxyHost", "<yourproxyhost>");
java.lang.System.getProperties().put("http.proxyPort", "<yourproxyport>");
java.lang.System.getProperties().put("http.nonProxyHosts", "<yournonproxyhosts>");
java.lang.System.getProperties().put("http.proxyPort", "<yourproxyport>");
java.lang.System.getProperties().put("http.nonProxyHosts", "<yournonproxyhosts>");</yournonproxyhosts></yourproxyport></yournonproxyhosts></yourproxyport></yourproxyhost>

and if you use SOCKS Proxy
java.lang.System.getProperties().put("socksProxyHost", "<yoursocksproxyhost>");
java.lang.System.getProperties().put("socksProxyPort", "<yoursocksproxyport>");</yoursocksproxyport></yoursocksproxyhost>

Then try to open a JDBC connection to your database. If this doesn't work either the problem is not due to SQuirreL.