Ad Widget

Collapse

Oracle monitoring stopped working after configuring PSK agent encryption

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mcflurry
    Member
    • Jun 2022
    • 32

    #1

    Oracle monitoring stopped working after configuring PSK agent encryption

    Using Oracle by Zabbix agent 2 template.

    Adding encryption in zabbix agent config file breaks Oracle monitoring.

    Is there any additional configuration for this template after adding agent encryption?

    Just commenting the encryption lines in agent config file brings the alerts back to life.
  • Markku
    Senior Member
    Zabbix Certified SpecialistZabbix Certified ProfessionalZabbix Certified Expert
    • Sep 2018
    • 1782

    #2
    If you only add the encryption configuration in the agent config file and not to the Zabbix server-side configuration for the host, your agent connections will fail for sure. See a configuration example: https://www.zabbix.com/documentation...cation-example

    Markku

    Comment

    • mcflurry
      Member
      • Jun 2022
      • 32

      #3
      Originally posted by Markku
      If you only add the encryption configuration in the agent config file and not to the Zabbix server-side configuration for the host, your agent connections will fail for sure. See a configuration example: https://www.zabbix.com/documentation...cation-example

      Markku
      Uhm, I've done that already, I have all my other hosts with PSK encryption enabled and working.

      Comment

      • Markku
        Senior Member
        Zabbix Certified SpecialistZabbix Certified ProfessionalZabbix Certified Expert
        • Sep 2018
        • 1782

        #4
        In that case feel free to tell some information about your problem.

        Markku

        Comment

        • mcflurry
          Member
          • Jun 2022
          • 32

          #5
          Originally posted by Markku
          In that case feel free to tell some information about your problem.

          Markku
          AGENT
          2022/07/05 11:54:05.703660 [Oracle] Connection failed: ORA-00000: DPI-1047: Cannot locate a 64-bit Oracle Client library: "/oracle/PID/19/lib/libclntsh.so: cannot open shared object file: Too many open files". See https://oracle.github.io/odpi/doc/in...ion.html#linux for help.
          2022/07/05 11:54:06.709231 cannot accept incoming connection for peer: server


          SERVER
          2005:20220705:115359.048 item "server.domain.comracle.cdb.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORA CLE. PASSWORD}","{$ORACLE.SERVICE}"]" became not supported: Connection failed: ORA-00000: DPI-1047: Cannot locate a 64-bit Oracle Client library: "/oracle/PID/19/lib/libclntsh.so: cannot open shared object file: Too many open files". See https://oracle.github.io/odpi/doc/in...ion.html#linux for help.
          Those errors showed just after configuring the template for the very first time, fixed those following this:



          So, without encryption is working, and just after configuring encryption it fails.

          Comment

          • Markku
            Senior Member
            Zabbix Certified SpecialistZabbix Certified ProfessionalZabbix Certified Expert
            • Sep 2018
            • 1782

            #6
            I don't really understand the relevance of information about the problems you have had earlier with Oracle libraries, I'm not an Oracle user. How do you think that affects your Zabbix agent connection encryption?

            But you still haven't said anything about your problem or your configurations. How does it "fail"? What fails? Agent does not start? Agent logs some errors? Server logs some errors? Items don't work? How exactly did you configure your encryption (on agent and on server)?

            Markku

            Comment

            • mcflurry
              Member
              • Jun 2022
              • 32

              #7
              Uhm, nothing, sorry you can delete first post, it was a misconfig file.

              Comment

              Working...