Ad Widget

Collapse

Password less db auth using Oracle wallet

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • StormScorpion
    Junior Member
    • Feb 2024
    • 22

    #1

    Password less db auth using Oracle wallet

    Hello,
    I want to use a wallet for Zabbix database auth to prevent storing credentials in Zabbix. Is this possible?
    Using the wallet to authenticate on command line is working fine. But not with Zabbix.

    My config:
    Code:
    mkstore -wrl /etc/zabbix/oracle_wallet -createCredential MYDB zabbix password
    
    
    cat /etc/zabbix/oracle_tns/sqlnet.ora
    DIAG_ADR_ENABLED = OFF
    SQLNET.WALLET_OVERRIDE = TRUE
    WALLET_LOCATION =
     (SOURCE=
       (METHOD = FILE)
       (METHOD_DATA = (DIRECTORY=/etc/zabbix/oracle_wallet))
     )
    
    
    cat /etc/sysconfig/zabbix-agent2
    ORACLE_HOME=/opt/oracle/product/19.3.0/dbhome_1
    LD_LIBRARY_PATH=/opt/oracle/product/19.3.0/dbhome_1/lib:/opt/oracle/product/19.3.0/client_32/instantclient/light/:$LD_LIBRARY_PATH
    TNS_ADMIN=/etc/zabbix/oracle_tns
    DB_LOGIN_ID=zabbix
    
    
    zabbix_agent2 -t oracle.sys.params["tcp://localhost:1521","","","MYDB"]
    oracle.sys.params[tcp://localhost:1521,,,MYDB][m|ZBX_NOTSUPPORTED] [Connection failed: ORA-01017: invalid username/password; logon denied.]​
    
    
    sqlplus /@MYDB
    SQL*Plus: Release 19.0.0.0.0 - Production on​ (...) -> successful
    Last edited by StormScorpion; 03-04-2024, 11:04.
Working...