Configure a proxy for MSSQL Database connector

Products

• Rally SaaS

Issue/Introduction

Windows 10 environment

There are 5 configuration items for the proxy, missing some items will cause a connection failure to Rally.

The error messages may look like,

INFO: AgileCentralConnection.connect - Proxy for AgileCentral connection:  http://xxx:yyy@zzzz:False
INFO: AgileCentralConnection.connect - Connecting to AgileCentral
FATAL: AgileCentralConnection.connect(128) - <ConfigurationError> Unable to connect to Agile Central at rally1.rallydev.com: 404 Target host: 'rally1.rallydev.com' is either not reachable or doesn't support the Rally WSAPI

Cause

If the proxy url "http://xxx:yyy@zzzz:False" is ended with "False" then the proxy port is not fully configured.  It will be necessary to set the proxy port to make it work.

Resolution

List of the proxy configure items (for example, in acdata.yml file)

Item name	Required/Optional	Default value
ProxyServer	Required	N/A
ProxyPort	Required	"False"
ProxyProtocol	Optional	"http"
ProxyUser	Optional	N/A
ProxyPassword	Optional	N/A

 

Alternately, it is possible to remove the proxy configuration items from the config file and set the environment variable instead.

Format:

HTTPS_PROXY=http(s)://<user>:<password>@<proxy_hostname>:<port>/

 

Additional Information

https://techdocs.broadcom.com/us/en/ca-enterprise-software/agile-development-and-management/rally-platform-ca-agile-central/rally/integrating-with-rally/rally-integrations/rally-database-connector-microsoft-sql-server.html 

https://stackoverflow.com/questions/11726881/how-to-set-an-http-proxy-in-python-2-7