topic Google Maps - Proxy Server in QlikView

Google Maps - Proxy Server

pkelly — Thu, 07 Oct 2010 15:14:33 GMT

Hi All,

Trying to implement a Google Maps report.

The issue I have is that I cannot get the map to display.

Took my PC off my network and connected directly to a broadband connection and the map appears okay which suggests that the report is OKAY.

To connect to the internet we go through a proxy server.

Reading other forums on this subject suggest that some work needs to be done on the QlikView server.

Could someone please give me simple instructions on what I should be doing?

Many Thanks

Paul

Google Maps - Proxy Server

Thu, 07 Oct 2010 16:02:45 GMT

HI,

have you tried set the internet connections options of the Server to use your proxy?

Is the user you use to run your server able to connect to the internet?

- Trouble shoot connecting to the server with the same user you run the qlikview server (admin maybe?)

- Open IE

- Paste the same internet address your report has produced.

Cheers

Google Maps - Proxy Server

pkelly — Thu, 07 Oct 2010 18:22:33 GMT

Where do I do this on the server?

Google Maps - Proxy Server

pkelly — Thu, 07 Oct 2010 20:53:33 GMT

Any guidance on where the setting is?

Re: Google Maps - Proxy Server

Julie_Main — Tue, 10 May 2011 08:40:32 GMT

Did you ever get this resolved? I'm looking into the same issue and therefore would find the answer helpful. Thanks, Julie

Re: Google Maps - Proxy Server

Tue, 10 May 2011 09:45:29 GMT

Hi,

It is quite counter-intuitive that the server-settings for QVS have to be configured in Internet Explorer's settings page, using the same account that is used to run QVS service. Not to mention that whenever the account decides to configure itself as "roaming profile", or the domain policy for Internet explorer is changed, or .. the settings are lost = maps don't work.

Here is another way , where there is a local Apache web server running PHP and acting getting the Google maps thry the same proxy that is configured in Internet Explorer. It uses Windows authentication for the proxy server.

Probaly you can write the equivalent in other webserver (ex IIS ) and other programming language .

<?php

$usr = 'user:password';

$proxy = '10.11.12.13:8080';

//force header to JPEG

header("Content-type: image/jpeg\n\n");

//same GET parameters as with Google Maps

$url = 'http://maps.google.com/staticmap?center=' . $_GET['center'] .

'&zoom=' . $_GET['zoom'] .

'&maptype=' . $_GET['maptype'] .

'&size=' . $_GET['size'] .

'&key=' . $_GET['key'];

// create a new cURL resource

$ch = curl_init();

// set URL and other appropriate options

curl_setopt($ch, CURLOPT_URL, $url);

curl_setopt($ch, CURLOPT_HEADER, 0);

//curl_setopt($ch, CURLOPT_HTTPPROXYTUNNEL, TRUE);

curl_setopt($ch, CURLOPT_PROXYAUTH, CURLAUTH_NTLM);

curl_setopt($ch, CURLOPT_PROXY, $proxy);

curl_setopt($ch, CURLOPT_PROXYUSERPWD, $usr);

// grab URL and pass it to the browser

curl_exec($ch);

// close cURL resource, and free up system resources

curl_close($ch);

-Alex