unable to authentication login/password through proxy in OpenOffice

[c***@openmailbox.org]

Hi,

I found the following mail-archive about authentication login/password
through proxy in OpenOffice:
<https://www.mail-archive.com/***@framework.openoffice.org/msg01085.html>

I'm facing the same problem that described:

I would like to get geocode by web service Google API, my macro works at
home (without proxy) but not at work (through proxy).

At work (Windows 7, LibO 4.0.5.2) , when I launch my macro, LibO freeze
any seconds and replay "Error 1: Une exception s'est produite : Type:
com.sun.star.ucb.InteractiveNetworkConnectException Message: . (line :
194)"

I guess that is a problem with the proxy...

Firefox have access to Internet. I have configured OpenOffice proxy on
MANUAL and after that on SYSTEM, I can not set login/password for
authentication.

I unfortunately have nothing found about this on internet. Does somebody
can help me ?

Thanks by advance.
Regards,

[Mark Bourne]

Post by c***@openmailbox.org
Hi,
I found the following mail-archive about authentication login/password
I would like to get geocode by web service Google API, my macro works at
home (without proxy) but not at work (through proxy).
At work (Windows 7, LibO 4.0.5.2) , when I launch my macro, LibO freeze
194)"
I guess that is a problem with the proxy...
Firefox have access to Internet. I have configured OpenOffice proxy on
MANUAL and after that on SYSTEM, I can not set login/password for
authentication.
I unfortunately have nothing found about this on internet. Does somebody
can help me ?

...

Not entirely sure if this will work, but try:

- In LibreOffice menu Tools > Options > Internet > Proxy, set "Proxy
server" to "System" (I guess this is what you've tried above). This
tells LibreOffice to use the system proxy settings.

- To check/set the system proxy settings, in Windows' Control Panel
(Start > Control Panel) find the Internet Options (it's probably easier
to find with the control panel in Classic View rather than category
view). On the Connections tab, click "LAN settings" and ensure your
proxy is set up there.

- Open Internet Explorer (which always uses the system proxy settings;
Firefox may or may not depending how its configured). Navigate to a
random web site (e.g. www.google.com) and enter any passwords needed for
the proxy. This is often enough to open up the proxy for other
applications to use.

- Now try accessing the web service from LibreOffice.

Another possibility is that the service is blocked by your proxy. Are
you able to access it from work through any other means to test? e.g.
another application, by manually connecting to it (if you know what
you're doing and it uses a plain-text protocol, you can connect a telnet
session via "telnet <address> <port>" from a command prompt, and then
type the requests and see if you get a response back).

It may be worth asking your IT department what you might need to do to
get through their proxy; the rest of us can only guess at how it might
be configured. Some are more aggressive than others in blocking certain
types of traffic.

Mark.

[c***@openmailbox.org]

[...]

Post by Mark Bourne

Post by c***@openmailbox.org
I would like to get geocode by web service Google API, my macro works at
home (without proxy) but not at work (through proxy).
At work (Windows 7, LibO 4.0.5.2) , when I launch my macro, LibO freeze
194)"

[...]
[Snip the explanations I've followed letter by letter]

Post by Mark Bourne
- Now try accessing the web service from LibreOffice.

Doesn't work :-(

Post by Mark Bourne
Another possibility is that the service is blocked by your proxy. Are
you able to access it from work through any other means to test? e.g.
another application, by manually connecting to it (if you know what
you're doing and it uses a plain-text protocol, you can connect a
telnet session via "telnet <address> <port>" from a command prompt,
and then type the requests and see if you get a response back).

I would like to use a Google geocoding service.

It works with my/your favorite browser (through proxy):
<http://maps.googleapis.com/maps/api/geocode/xml?sensor=true&address=grand\%27place+Brussels+Belgium>
return a xml including location coordinates. My webbrowser ask me the
proxy's login/passwd.

It works with wget through proxy (Cygwin installed, .wgetrc configured
with proxy's login/passwd).

To use the google service with LibO, I have found the following webpage:
<http://www.tuicool.com/articles/IN7zEb>. It works on a connection
without proxy but not trough proxy.

I've tried the following macro in LibO (simplier) -> same result: works
without proxy, not with proxy!

Sub Macro1
open "http://www.google.com" for input as #1
line input #1, texte
close #1
print texte
End Sub

LibO want not to pass trough proxy!

Does it exist an another way to use webservices into LibO (pluggin, or
something like that ?)

Post by Mark Bourne
It may be worth asking your IT department what you might need to do to
get through their proxy; the rest of us can only guess at how it might
be configured. Some are more aggressive than others in blocking
certain types of traffic.

I'll see with him.

Thanx you very much for your help. We keep in touch.

Post by Mark Bourne
Mark.

Bruno.

[Carlo Strata]

Ciao Bruno!

Have you tried to put credentials on proxy URLs in LibreOffice proxy
settings (Tools -> Options -> Internet -> Proxy -> Manual)?

I mean something like this:
Proxy HTTP:
http://proxy_user:***@proxy.server.com:proxy_port/ (or with
the proxy port only in the LibreOffice proxy port field)
Proxy HTTPS:
https://proxy_user:***@proxy.server.com:proxy_port/ (ibidem)
Proxy FTP: ftp://proxy_user:***@proxy.server.com:proxy_port/
(ibidem)

And so on...

Have a sunny day,

Carlo

p.s. Webgrafia:
http://www.gnu.org/software/wget/manual/html_node/Proxies.html
http://stackoverflow.com/questions/34079/how-to-specify-an-authenticated-proxy-for-a-python-http-connection
<- from this you can get some further ideas for your macros...

--
ing. Carlo Strata
-
via Botticelli 1/4
30031 Dolo - VE
Italia - Italy
-
tel./fax [phone]
cell. +39.347.85.69.824
Skype carlo.strata
Google carlo.strata.69
-

Post by c***@openmailbox.org
[...]

Post by Mark Bourne

Post by c***@openmailbox.org
I would like to get geocode by web service Google API, my macro works at
home (without proxy) but not at work (through proxy).
At work (Windows 7, LibO 4.0.5.2) , when I launch my macro, LibO freeze
194)"

[...]
[Snip the explanations I've followed letter by letter]

Post by Mark Bourne
- Now try accessing the web service from LibreOffice.

Doesn't work :-(

Post by Mark Bourne
Another possibility is that the service is blocked by your proxy. Are
you able to access it from work through any other means to test? e.g.
another application, by manually connecting to it (if you know what
you're doing and it uses a plain-text protocol, you can connect a
telnet session via "telnet <address> <port>" from a command prompt,
and then type the requests and see if you get a response back).

I would like to use a Google geocoding service.
<http://maps.googleapis.com/maps/api/geocode/xml?sensor=true&address=grand\%27place+Brussels+Belgium>
return a xml including location coordinates. My webbrowser ask me the
proxy's login/passwd.
It works with wget through proxy (Cygwin installed, .wgetrc configured
with proxy's login/passwd).
To use the google service with LibO, I have found the following
webpage: <http://www.tuicool.com/articles/IN7zEb>. It works on a
connection without proxy but not trough proxy.
works without proxy, not with proxy!
Sub Macro1
open "http://www.google.com" for input as #1
line input #1, texte
close #1
print texte
End Sub
LibO want not to pass trough proxy!
Does it exist an another way to use webservices into LibO (pluggin, or
something like that ?)

Post by Mark Bourne
It may be worth asking your IT department what you might need to do to
get through their proxy; the rest of us can only guess at how it might
be configured. Some are more aggressive than others in blocking
certain types of traffic.

I'll see with him.
Thanx you very much for your help. We keep in touch.

Post by Mark Bourne
Mark.

Bruno.

...

[c***@openmailbox.org]

Post by Carlo Strata
Ciao Bruno!
Have you tried to put credentials on proxy URLs in LibreOffice proxy
settings (Tools -> Options -> Internet -> Proxy -> Manual)?
the proxy port only in the LibreOffice proxy port field)
(ibidem)
(ibidem)
And so on...
Have a sunny day,
Carlo

Ohw, it's a pretty solution... I like! But it doesn't work! ;-)
The problem wasn't about LibO, I had to connect to the Novell login
before (a subtlety of the local network)

Thanx Marc,
Thanx Carlo