-
Problem report
-
Resolution: Fixed
-
Minor
-
2.2.19rc1, 3.0.10rc1, 3.2.7rc1, 3.4.0alpha1
-
Sprint 11, Sprint 12
-
0.5
Discovered by accident. When I start Zabbix server I get:
14790:20170525:150936.029 [Z3001] connection to database '//192.168.3.251/XE' failed: [1] ORA-28002: the password will expire within 6 days 14790:20170525:150936.029 database is down: reconnecting in 10 seconds
When I connect with sqlplus I get the same "ORA-28002: the password will expire within 6 days" but connection is successful:
SQL*Plus: Release 11.2.0.2.0 Production on Thu May 25 15:43:10 2017 Copyright (c) 1982, 2011, Oracle. All rights reserved. Enter user-name: ZABBIX Enter password: ERROR: ORA-28002: the password will expire within 6 days Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production SQL>
I suspect that OCILogon2() returns OCI_SUCCESS_WITH_INFO in this case, but our code accepts only OCI_SUCCESS:
err = OCILogon2(oracle.envhp, oracle.errhp, &oracle.svchp, (text *)user, (ub4)(NULL != user ? strlen(user) : 0), (text *)password, (ub4)(NULL != password ? strlen(password) : 0), (text *)connect, (ub4)strlen(connect), OCI_DEFAULT); if (OCI_SUCCESS == err) { err = OCIAttrGet((void *)oracle.svchp, OCI_HTYPE_SVCCTX, (void *)&oracle.srvhp, (ub4 *)0, OCI_ATTR_SERVER, oracle.errhp); } if (OCI_SUCCESS != err) { zabbix_errlog(ERR_Z3001, connect, err, zbx_oci_error(err, NULL)); ret = ZBX_DB_DOWN; }
- is duplicated by
-
ZBX-13132 Processing password expiry ORA-28002
-
- Closed
-
