Forum Post: RE: ODBC DB2 auth problems

  • Thread starter Thread starter Ed Steward
  • Start date Start date
Status
Not open for further replies.
E

Ed Steward

Guest
Hi grittix, The most likely cause is that the server is configured to require AES encryption and you do not have the DataDirect OpenSSL library, ddssl27.so or ivssl27.so, on your lib path. You can check your server's authentication and alternate encryption settings and set the driver's EncryptionMethod and AuthenticationMethod based on that. Server Authentication Setting Server alternate_auth_enc Setting Driver EncryptionMethod Driver AuthenticationMethod SERVER (default) N/A 0 (No Encryption) 0 (No Encryption) CLIENT N/A 0 (No Encryption) 3 (Client Authentication) SERVER_ENCRYPT NOT_SPECIFIED (default) 0 (No Encryption) 1 (Encrypt Password) or 2 (Encrypt UID and Password) or 7 (Encrypted Password AES) or 8 (Encrypted UID and Password AES) AES_CMP 0 (No Encryption) 7 (Encrypted Password AES) or 8 (Encrypted UID and Password AES) AES_ONLY 0 (No Encryption) 7 (Encrypted Password AES) or 8 (Encrypted UID and Password AES) DATA_ENCRYPT N/A 2 (Database Encryption) 1 (Encrypt Password) or 2 (Encrypt UID and Password) or 7 (Encrypted Password AES) or 8 (Encrypted UID and Password AES) DATA_ENCRYPT_CMP N/A 2 (Database Encryption) 1 (Encrypt Password) or 2 (Encrypt UID and Password) or 7 (Encrypted Password AES) or 8 (Encrypted UID and Password AES) KERBEROS N/A 0 (No Encryption) 4 (Kerberos Authentication) KRB_SERVER_ENCRYPT N/A 0 (No Encryption) 4 (Kerberos Authentication) Hope this helps, Ed

Continue reading...
 
Status
Not open for further replies.
Back
Top