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

Zabbix_server failes to connect to oracle db

XMLWordPrintable

    • Icon: Change Request Change Request
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 3.2.1
    • Installation (I)
    • None
    • 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

      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/[email protected]: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

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

              Created:
              Updated:
              Resolved: