Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
ssl=true;sslfactory=org.postgresql.ssl.NonValidatingFactory
Parameters should not be added to the URL, but instead set in the Properties. This is how it works for the PostgreSQL driver.
|
|
45 KB
Modifications made so that we do not append the parameters to the end of the jdbc URL string. Instead the parameters are parsed and set for the driver from the parameter string. For the parameter string we should use: ?ssl=true&sslfactory=com.amazon.redshift.ssl.NonValidatingFactory.
We have modified our AWS Redshift instead to use a parameter group with SSL required set to true. So currently we will need to configure our connection to use ssl, if not you connection should fail.
Verified in
"Aqua Data Studio 18.0.0-dev-45" and "Aqua Data Studio 17.0.2-1"
Steps to Verify issue :
1) Right click on Server treenode and select "Register Server"
2) Select "Amazon Redshift" database from left hand side
3) Enter valid credentials in 'General tab'
4) Now go to 'Driver' tab and in 'Parameter' textbox enter below parameter :
ssl=true&sslfactory=com.amazon.redshift.ssl.NonValidatingFactory
5) And click on 'Test Connection'
Refer screenshot "redshift.png"
Verified in
"Aqua Data Studio 18.0.0-dev-45" and "Aqua Data Studio 17.0.2-1"
Steps to Verify issue :
1) Right click on Server treenode and select "Register Server"
2) Select "Amazon Redshift" database from left hand side
3) Enter valid credentials in 'General tab'
4) Now go to 'Driver' tab and in 'Parameter' textbox enter below parameter :
ssl=true&sslfactory=com.amazon.redshift.ssl.NonValidatingFactory
5) And click on 'Test Connection'
Refer screenshot "redshift.png"
Issue #14255 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build v18.0.0-dev-39, v17.0.1-2 |
| No time estimate |
Modifications made so that we do not append the parameters to the end of the jdbc URL string. Instead the parameters are parsed and set for the driver from the parameter string. For the parameter string we should use: ?ssl=true&sslfactory=com.amazon.redshift.ssl.NonValidatingFactory.
We have modified our AWS Redshift instead to use a parameter group with SSL required set to true. So currently we will need to configure our connection to use ssl, if not you connection should fail.