Connection to Oracle DB fails after upgrade to 2.2.0p8 using python-oracledb

Troubleshooting
1

CMK version:
Checkmk Raw Edition 2.2.0p8

OS version:
Debian 11 (bullseye)

Error message:
Error while connecting to database: DPY-3015: password verifier type 0x939 is not supported by python-oracledb in thin mode

Hi!
We upgraded to version 2.2.0p8, which uses the newer python module “python-oracledb” for the active check “Check SQL Database”.
When we now try to connect to our Oracle 12c database, we get the error:

Error while connecting to database: DPY-3015: password verifier type 0x939 is not supported by python-oracledb in thin mode

This seems to be because in our Oracle database we have the following parameters:

  • sec_case_sensitive_logon=false
  • SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

And the password versions of our checkmk user are:

SELECT password_versions FROM dba_users WHERE username = ‘CHECKMK’;
10G 11G 12C

Is there any solution to this problem, apart from upgrading to newer password versions?

Is it possible to use the python module oracledb in thick mode? (Is there maybe some configuration that forces the python code to call oracledb.init_oracle_client in the beginning?)

2

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed. Contact an admin if you think this should be re-opened.

3

This is already fixed as part of this werk : Werk #15339: check_sql: activate thick mode for oracle connections
You can update to 2.2.0p33 if you use 2.2.x at the moment.