Kbase P135430: SQL Explorer fails with error 8933 when using -ssl parameter
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/07/2009 |
|
Status: Unverified
SYMPTOM(s):
sqlexp fails with error 8933 when using -ssl parameter
Error: <command name | SQL Exception message>. (8933)
Error: [DataDirect][OpenEdge JDBC Driver]SSL Mismatch. Encryption method in client and server must match.. (8933)
FACT(s) (Environment):
OpenEdge 10.1x
All Supported Operating Systems
CAUSE:
Bug# OE00176806
FIX:
Upgrade to 10.1C03 or later, or 10.2A01.
A new option has been added to sqlexp, -driverUrl. Whatever is entered in this option is sent directly to the driver without sqlexp processing. This is how ssl is now implemented. To test this change on the server side:
prodb testdb empty
proserve -S 1234 testdb -ssl
sqlexp -driverUrl "jdbc:datadirect:openedge://localhost:1234;databaseName=testdb;EncryptionMethod=ssl;validateServerCertificate=false"
This tests encryption without authentication. To test the other driver ssl parameters, create a keystore then use the Truststore and TrustStorePassword driver parameters that have been tested elsewhere.
Execute sqlexp -h. The documentation for the old ssl parameter is gone and the new -driverUrl parameter is now documented.