Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-3512

Zabbix_server failes to connect to oracle db

    Details

    • Type: Change Request
    • Status: Closed
    • Priority: Trivial
    • Resolution: Won't fix
    • Affects Version/s: 3.2.1
    • Fix Version/s: None
    • Component/s: Installation (I)
    • Labels:
      None
    • Environment:
      Oracle: Release 10.2.0.5.0
      Linux localhost.localdomain 2.6.32-431.el6.x86_64 #1 SMP Sun Nov 10 22:19:54 EST 2013 x86_64 x86_64 x86_64 GNU/Linux

      Description

      When i start the zabbix server is OK, but in the logfile /tmp/zabbix_server.log occurs error as following:
      11761:20161021:170846.057 Starting Zabbix Server. Zabbix 3.2.1 (revision 62890).
      11761:20161021:170846.065 ****** Enabled features ******
      11761:20161021:170846.065 SNMP monitoring: YES
      11761:20161021:170846.065 IPMI monitoring: YES
      11761:20161021:170846.065 Web monitoring: YES
      11761:20161021:170846.065 VMware monitoring: YES
      11761:20161021:170846.065 SMTP authentication: NO
      11761:20161021:170846.065 Jabber notifications: NO
      11761:20161021:170846.065 Ez Texting notifications: YES
      11761:20161021:170846.065 ODBC: YES
      11761:20161021:170846.065 SSH2 support: NO
      11761:20161021:170846.066 IPv6 support: NO
      11761:20161021:170846.066 TLS support: NO
      11761:20161021:170846.066 ******************************
      11761:20161021:170846.066 using configuration file: /usr/local/zabbix_server/etc/zabbix_server.conf
      11761:20161021:170846.076 [Z3001] connection to database '//172.16.11.150:1521/lytestdb' failed: [-1]
      11761:20161021:170846.076 Cannot connect to the database. Exiting...

      But I can connect database successful in command :
      [root@localhost htdocs]# sqlplus zabbix/zabbix@172.16.11.150:1521/lytestdb

      SQL*Plus: Release 10.2.0.5.0 - Production on Fri Oct 21 17:22:39 2016

      Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

      Connected to:
      Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options

      SQL>
      SQL> show user
      USER is "ZABBIX"
      SQL> exit

      And i write a php test script testconndb.php:
      <?php
      $conn = oci_connect('zabbix', 'zabbix123', '//xxxx.xxx.xxx.xxx:1521/testdb');
      if (!$conn)

      { $e = oci_error(); print htmlentities($e['message']); exit; }

      else

      { echo "Connect to oracle successful !"; }

      ?>

      then open the web URL and it return success:

      Connect to oracle successful !

      can anyone help ?
      Regards,
      vindy.fang

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Vindy Vindy.fang
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: