Thanks for help.
We debugged the script and found that it uses the httplib2 module, which has no parameters for specifying a proxy_info. We have specified the proxy_info parameters here in google_spreadsheet.py and in a similar way for gspread/client.py:
http = httplib2.Http (proxy_info = httplib2.ProxyInfo (httplib2.socks.PROXY_TYPE_HTTP, 'proxy.in.our.net', 3128, proxy_rdns = False), disable_ssl_certificate_validation = True)
This solved our problem, but only after adding proxy_rdns=False parameter.
Now we have other problem:
2018-04-25 13:11:37,358 INFO Previous run was too far in the past (gap=613.1967689990997) and thus some executions of the input have been missed (stanza=google_spreadsheet://marketing)
2018-04-25 13:14:12,364 ERROR A general exception was thrown when executing the import
Traceback (most recent call last):
File "/opt/splunk/etc/apps/google_drive/bin/google_spreadsheet.py", line 211, in import_file
last_updated = google_lookup_sync.import_to_lookup_file(lookup_name, None, None, spreadsheet_title, worksheet_name, session_key, create_if_non_existent=False)
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/__init__.py", line 310, in import_to_lookup_file
return self.import_to_lookup_file_full_path(destination_full_path, namespace, owner, google_spread_sheet_name, worksheet_name, session_key, create_if_non_existent, lookup_name=lookup_name)
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/__init__.py", line 328, in import_to_lookup_file_full_path
google_spread_sheet = self.open_google_spreadsheet(google_spread_sheet_name)
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/__init__.py", line 112, in open_google_spreadsheet
google_spread_sheet = self.gspread_client.open(title)
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/gspread/client.py", line 134, in open
feed = self.get_spreadsheets_feed()
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/gspread/client.py", line 220, in get_spreadsheets_feed
r = self.session.get(url)
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/gspread/httpsession.py", line 79, in get
return self.request('GET', url, **kwargs)
File "/opt/splunk/etc/apps/google_drive/bin/google_drive_app/gspread/httpsession.py", line 71, in request
self.connections[uri.scheme+uri.netloc].request(method, url, data, headers=request_headers)
File "/opt/splunk/lib/python2.7/httplib.py", line 1042, in request
self._send_request(method, url, body, headers)
File "/opt/splunk/lib/python2.7/httplib.py", line 1082, in _send_request
self.endheaders(body)
File "/opt/splunk/lib/python2.7/httplib.py", line 1038, in endheaders
self._send_output(message_body)
File "/opt/splunk/lib/python2.7/httplib.py", line 882, in _send_output
self.send(msg)
File "/opt/splunk/lib/python2.7/httplib.py", line 844, in send
self.connect()
File "/opt/splunk/lib/python2.7/httplib.py", line 1255, in connect
HTTPConnection.connect(self)
File "/opt/splunk/lib/python2.7/httplib.py", line 821, in connect
self.timeout, self.source_address)
File "/opt/splunk/lib/python2.7/socket.py", line 575, in create_connection
raise err
error: [Errno 99] Cannot assign requested address
Can you help with it? Is this problem a reason of "Previous run was too far in the past"? Thanks.
... View more