Feedback
Did this article resolve your question/issue?

   

Article

Upgraded HDP install blocking all ODBC connections with 403 errors

Information

 
TitleUpgraded HDP install blocking all ODBC connections with 403 errors
URL Nameupgraded-hdp-install-blocking-all-odbc-connections-with-403-errors
Article Number000123709
EnvironmentProduct: Hybrid Data Pipeline (HDP)
Version: 4.5
OS: All supported platforms
Database: MySQL Community Edition
Application: ODBC Administrator
Question/Problem Description
Upgrading Hybrid Data Pipeline from 4.4.0.69 to 4.5 is blocking all ODBC connections with 403 errors
Steps to Reproduce
Clarifying Information
The web.xml for cloudservice and hdpui (the .war files) was modified to block access to the Web UI outside the user's network. However, ODBC, JDBC and OData access should be allowed form any machine.
Error Message403 forbidden
Defect Number
Enhancement Number
Cause
The way the filter is defined, it is going to block all traffic unless it comes from one of the three IP addresses listed in the filter
Resolution
Starting with HDP 4.5, the IP Address Whitelist API shoudl be used to create an IP address whitelist to determine which IP addresses (either individual IP addresses or a range of IP addresses) can access resources such as the Management API, the Administrators API, data access, and the Web UI.

Contact Technical Support for details about updating the .war files.
Workaround
Notes
References to other documentation:
Hybrid Data Pipeline API reference : IP Address Whitelist API
https://documentation.progress.com/output/DataDirect/hybridpipeline/index.html#page/hybrid%2Fip-address-whitelist-api.html%23
Last Modified Date11/20/2020 7:00 AM
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.