Kbase P144517: How to connect to a database that is SSL enabled via SQL Explorer from command line in 10.1C?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/4/2010 |
|
Status: Unverified
GOAL:
How to connect to a database that is SSL enabled via SQL Explorer from command line in 10.1C?
GOAL:
What is the syntax fo SQL Explorer to allow it to connect to a database that is SSL enabled in 10.1C?
GOAL:
What should the SQL Explorer connection string look like when trying to connect to an SSL enabled database?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1C
OpenEdge 10.2x
FIX:
In 10.1C a new parameter was introduced which will allow a SQL Explorer client to connect to a database and make use of SSL. The connection string is:
-url <url> Mandatory argument.
Format is:
"jdbc:datadirect:openedge://<host>:<port>;databaseName=<dbName>;User=<user>;Password=<password>"
The url must be enclosed in quotes. All fields listed above must be present.
In addition, driver connection parameters can also be added to the url.
For example, SSL options are now driver connection parameters.
To enable encryption without authentication, the -url option would be as follows:
"jdbc:datadirect:openedge://<host>:<port>;databaseName=<dbName>;User=<user>;Password=<password;EncryptionMethod=ssl;validateServerCertificate=false"
See SQL documentation for other JDBC driver connection parameters.
The following is an example making use of sports2000 database and using the OpenEdge supplied default certificate:
prodb sports2000 sports2000
proserve sports2000 -H hostname -S portnumber -ssl
sqlexp -url "jdbc:datadirect:openedge://hostname:portnumber;databaseName=sports2000;User=username;EncryptionMethod=ssl;validateServerCertificate=false"