[Squirrel-sql-users] check update doesn't support proxy?

Discussion:

xpdz (Jim Yin)

2008-12-09 09:13:48 UTC

Hi Gerd & Rob,

I have setup a proxy server and port in the 'proxy' tab of global options
dialog, and then switch to the 'update' tab, click the 'test connection'
button, it says 'can not download release.xml'.
Then, I check the log file (debug level was enabled), and found the
exception 'java.net.ConnectException: Connection refused: connect', so I
guess this function must not support proxy settings.
I also check the source code, indeed, no proxy arguments pass to the
HttpClient class (line 219 in file
net.sourceforge.squirrel_sql.fw.util.IOUtilitiesImpl)

And there is a inconsistence with the menu item of 'software update' in Help
munu, when I click it, it says my Squirrel is the latest version, although
the same exception occurred in log file.

please check it.
thanks.

-xpdz

Robert Manning

2008-12-09 10:57:10 UTC

Permalink

All true at the moment. I haven't wired in the proxy configuration to
HttpClient yet. And since SQuirreL cannot retrieve release.xml, it
can't know that it's not the latest version. In that case it assumes
that it is, since it cannot tell what artifacts it needs to retrieve.

Rob

On Tue, Dec 9, 2008 at 4:13 AM, xpdz (Jim Yin)

Post by xpdz (Jim Yin)
Hi Gerd & Rob,
I have setup a proxy server and port in the 'proxy' tab of global options
dialog, and then switch to the 'update' tab, click the 'test connection'
button, it says 'can not download release.xml'.
Then, I check the log file (debug level was enabled), and found the
exception 'java.net.ConnectException: Connection refused: connect', so I
guess this function must not support proxy settings.
I also check the source code, indeed, no proxy arguments pass to the
HttpClient class (line 219 in file
net.sourceforge.squirrel_sql.fw.util.IOUtilitiesImpl)
And there is a inconsistence with the menu item of 'software update' in Help
munu, when I click it, it says my Squirrel is the latest version, although
the same exception occurred in log file.
please check it.
thanks.
-xpdz
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Squirrel-sql-users mailing list
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Robert Manning

2008-12-13 16:46:30 UTC

Permalink

xpdz,

The most recent snapshot:

https://sourceforge.net/project/showfiles.php?group_id=28383&package_id=158128&release_id=646968

allows you to configure an HTTP proxy for retreiving updates.
SOCKS proxies are not supported for now as HttpClient does
not provide that functionality. I tested this by using privoxy
(www.privoxy.org) with no authentication credentials; though
it should still work if your HTTP proxy requires authentication
credentials.

Rob

On Tue, Dec 9, 2008 at 4:13 AM, xpdz (Jim Yin)

squirrel-user

2009-05-05 20:45:16 UTC

Permalink

I'm using Squirrel SQL Client 3.0.1 and it is behind a company proxy.
Despite giving correct user name, password, proxy server and port in Global
proxy setting, check for update still fails.

Extract from log file:

2009-05-05 16:33:13,953 [Thread-4] INFO
org.apache.commons.httpclient.auth.AuthChallengeProcessor - ntlm
authentication scheme selected
2009-05-05 16:33:13,953 [Thread-4] DEBUG
org.apache.commons.httpclient.auth.AuthChallengeProcessor - Using
authentication scheme: ntlm
2009-05-05 16:33:13,953 [Thread-4] DEBUG
org.apache.commons.httpclient.auth.AuthChallengeProcessor - Authorization
challenge processed
2009-05-05 16:33:13,953 [Thread-4] DEBUG
org.apache.commons.httpclient.HttpMethodDirector - Proxy authentication
scope: NTLM <any realm>@my-proxy-server:80
2009-05-05 16:33:13,953 [Thread-4] DEBUG
org.apache.commons.httpclient.HttpState - enter
HttpState.getProxyCredentials(AuthScope)
2009-05-05 16:33:13,953 [Thread-4] DEBUG
org.apache.commons.httpclient.HttpMethodDirector - Retry authentication
2009-05-05 16:33:13,953 [Thread-4] DEBUG
org.apache.commons.httpclient.HttpMethodBase - Resorting to protocol
version default close connection policy
2009-05-05 16:33:13,953 [Thread-4] DEBUG
org.apache.commons.httpclient.HttpMethodBase - Should NOT close connection,
using HTTP/1.1
2009-05-05 16:33:13,953 [Thread-4] DEBUG
org.apache.commons.httpclient.HttpConnection - enter
HttpConnection.isResponseAvailable()
2009-05-05 16:33:13,953 [Thread-4] DEBUG
org.apache.commons.httpclient.HttpConnection - enter
HttpConnection.releaseConnection()
2009-05-05 16:33:13,969 [Thread-4] DEBUG
org.apache.commons.httpclient.HttpConnection - Connection is locked. Call
to releaseConnection() ignored.
2009-05-05 16:33:13,969 [Thread-4] DEBUG
org.apache.commons.httpclient.HttpMethodDirector - Authenticating with NTLM
<any realm>@my-proxy-server:80
2009-05-05 16:33:13,969 [Thread-4] DEBUG
org.apache.commons.httpclient.HttpState - enter
HttpState.getProxyCredentials(AuthScope)
2009-05-05 16:33:13,969 [Thread-4] DEBUG
org.apache.commons.httpclient.auth.NTLMScheme - enter
NTLMScheme.authenticate(Credentials, HttpMethod)
2009-05-05 16:33:13,969 [Thread-4] ERROR
org.apache.commons.httpclient.HttpMethodDirector - Credentials cannot be
used for NTLM authentication:
org.apache.commons.httpclient.UsernamePasswordCredentials
org.apache.commons.httpclient.auth.InvalidCredentialsException: Credentials
cannot be used for NTLM authentication:
org.apache.commons.httpclient.UsernamePasswordCredentials
at
org.apache.commons.httpclient.auth.NTLMScheme.authenticate(NTLMScheme.java:332)
at
org.apache.commons.httpclient.HttpMethodDirector.authenticateProxy(HttpMethodDirector.java:320)
at
org.apache.commons.httpclient.HttpMethodDirector.authenticate(HttpMethodDirector.java:232)
at
org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170)
at
org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)
at
org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:323)
at
net.sourceforge.squirrel_sql.fw.util.IOUtilitiesImpl.downloadHttpFile(IOUtilitiesImpl.java:278)
at
net.sourceforge.squirrel_sql.client.update.UpdateUtilImpl.downloadHttpUpdateFile(UpdateUtilImpl.java:871)
at
net.sourceforge.squirrel_sql.client.update.UpdateUtilImpl.downloadCurrentReleaseHttp(UpdateUtilImpl.java:1051)
at
net.sourceforge.squirrel_sql.client.update.UpdateUtilImpl.downloadCurrentRelease(UpdateUtilImpl.java:200)
at
net.sourceforge.squirrel_sql.client.update.async.ReleaseFileUpdateCheckTask.getCurrentChannelXmlBean(ReleaseFileUpdateCheckTask.java:161)
at
net.sourceforge.squirrel_sql.client.update.async.ReleaseFileUpdateCheckTask.run(ReleaseFileUpdateCheckTask.java:110)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:619)

Post by Robert Manning
xpdz,
https://sourceforge.net/project/showfiles.php?group_id=28383&package_id=158128&release_id=646968
allows you to configure an HTTP proxy for retreiving updates.
SOCKS proxies are not supported for now as HttpClient does
not provide that functionality. I tested this by using privoxy
(www.privoxy.org) with no authentication credentials; though
it should still work if your HTTP proxy requires authentication
credentials.
Rob
On Tue, Dec 9, 2008 at 4:13 AM, xpdz (Jim Yin)

------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Squirrel-sql-users mailing list
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

--
View this message in context: http://www.nabble.com/check-update-doesn%27t-support-proxy--tp20911108p23395589.html
Sent from the squirrel-sql-users mailing list archive at Nabble.com.

Jørgen Nørgaard

2009-05-06 07:21:33 UTC

Permalink

Similar setup in my case, firewall does not need authentication, but
squirrelsql fails finding updates (http errorcode 407).

If it
is of any, help, this code snippet can read the URL:

    private void doit() {

    try {

    Proxy proxy=new Proxy(Proxy.Type.HTTP, new
InetSocketAddress("my-proxy.dk", 80));

        URL url=new
URL("http://www.squirrel-sql.net/updates/stable/release.xml");
            URLConnection
conn=url.openConnection(proxy);

    System.out.println("ok");

System.out.println("Length: " + conn.getContentLength());
            BufferedReader
in = new BufferedReader(new InputStreamReader(conn.getInputStream()));
            String
inputLine;


    while ((inputLine = in.readLine()) != null)

    System.out.println(inputLine);

        in.close();

        } catch (IOException e) {

e.printStackTrace();
        }
    }

Post by squirrel-user
I'm using Squirrel

SQL Client 3.0.1 and it is behind a company proxy.

Post by squirrel-user
Despite

giving correct user name, password, proxy server and port in
Global

Post by squirrel-user
proxy setting, check for update still fails.
2009-05-05

16:33:13,953 [Thread-4] INFO
org.apache.commons.httpclient.auth.AuthChallengeProcessor - ntlm

Post by squirrel-user
authentication scheme selected
2009-05-05 16:33:13,953

[Thread-4] DEBUG
org.apache.commons.httpclient.auth.AuthChallengeProcessor - Using

Post by squirrel-user
authentication scheme: ntlm
2009-05-05 16:33:13,953

[Thread-4] DEBUG
org.apache.commons.httpclient.auth.AuthChallengeProcessor -
Authorization

Post by squirrel-user
challenge processed
2009-05-05

16:33:13,953 [Thread-4] DEBUG
org.apache.commons.httpclient.HttpMethodDirector - Proxy
authentication

Post by squirrel-user
scope: NTLM <any
2009-05-05 16:33:13,953 [Thread-4]

DEBUG

Post by squirrel-user
org.apache.commons.httpclient.HttpState - enter

HttpState.getProxyCredentials(AuthScope)

Post by squirrel-user
2009-05-05 16:33:13,953

[Thread-4] DEBUG
org.apache.commons.httpclient.HttpMethodDirector - Retry
authentication

Post by squirrel-user
2009-05-05 16:33:13,953 [Thread-4] DEBUG
org.apache.commons.httpclient.HttpMethodBase - Resorting to

protocol

Post by squirrel-user
version default close connection policy

2009-05-05 16:33:13,953 [Thread-4] DEBUG
org.apache.commons.httpclient.HttpMethodBase - Should NOT close
connection,

Post by squirrel-user
using HTTP/1.1
2009-05-05 16:33:13,953

[Thread-4] DEBUG

Post by squirrel-user
org.apache.commons.httpclient.HttpConnection -

enter

Post by squirrel-user
HttpConnection.isResponseAvailable()
2009-05-05

16:33:13,953 [Thread-4] DEBUG
org.apache.commons.httpclient.HttpConnection - enter
HttpConnection.releaseConnection()

Post by squirrel-user
2009-05-05 16:33:13,969

[Thread-4] DEBUG

Post by squirrel-user
org.apache.commons.httpclient.HttpConnection -

Connection is locked.

Post by squirrel-user
Call
to releaseConnection()

ignored.

Post by squirrel-user
2009-05-05 16:33:13,969 [Thread-4] DEBUG

org.apache.commons.httpclient.HttpMethodDirector - Authenticating with

Post by squirrel-user
NTLM

2009-05-05 16:33:13,969 [Thread-4] DEBUG
org.apache.commons.httpclient.HttpState - enter
HttpState.getProxyCredentials(AuthScope)

Post by squirrel-user
2009-05-05 16:33:13,969

[Thread-4] DEBUG

Post by squirrel-user
org.apache.commons.httpclient.auth.NTLMScheme

- enter

Post by squirrel-user
NTLMScheme.authenticate(Credentials, HttpMethod)
2009-05-05 16:33:13,969 [Thread-4] ERROR

org.apache.commons.httpclient.HttpMethodDirector - Credentials cannot
be
org.apache.commons.httpclient.UsernamePasswordCredentials
org.apache.commons.httpclient.auth.InvalidCredentialsException:
Credentials
org.apache.commons.httpclient.UsernamePasswordCredentials

Post by squirrel-user
at

org.apache.commons.httpclient.auth.NTLMScheme.authenticate(NTLMScheme.java:332)

Post by squirrel-user
at

org.apache.commons.httpclient.HttpMethodDirector.authenticateProxy(HttpMethodDirector.java:320)

Post by squirrel-user
at

org.apache.commons.httpclient.HttpMethodDirector.authenticate(HttpMethodDirector.java:232)

Post by squirrel-user
at

org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170)

Post by squirrel-user
at

org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)

Post by squirrel-user
at

org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:323)

Post by squirrel-user
at

net.sourceforge.squirrel_sql.fw.util.IOUtilitiesImpl.downloadHttpFile(IOUtilitiesImpl.java:278)

Post by squirrel-user
at

net.sourceforge.squirrel_sql.client.update.UpdateUtilImpl.downloadHttpUpdateFile(UpdateUtilImpl.java:871)

Post by squirrel-user
at

net.sourceforge.squirrel_sql.client.update.UpdateUtilImpl.downloadCurrentReleaseHttp(UpdateUtilImpl.java:1051)

Post by squirrel-user
at

net.sourceforge.squirrel_sql.client.update.UpdateUtilImpl.downloadCurrentRelease(UpdateUtilImpl.java:200)

Post by squirrel-user
at

net.sourceforge.squirrel_sql.client.update.async.ReleaseFileUpdateCheckTask.getCurrentChannelXmlBean(ReleaseFileUpdateCheckTask.java:161)

Post by squirrel-user
at

net.sourceforge.squirrel_sql.client.update.async.ReleaseFileUpdateCheckTask.run(ReleaseFileUpdateCheckTask.java:110)

Post by squirrel-user
at

net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)

Post by squirrel-user
at java.lang.Thread.run(Thread.java:619)

Post by Robert Manning
xpdz,

https://sourceforge.net/project/showfiles.php?group_id=28383&package_id=158128&release_id=646968