[ZBXNEXT-3512] Zabbix_server failes to connect to oracle db Created: 2016 Oct 21  Updated: 2017 May 31  Resolved: 2016 Oct 24

Status: Closed
Project: ZABBIX FEATURE REQUESTS
Component/s: Installation (I)
Affects Version/s: 3.2.1
Fix Version/s: None

Type: Change Request Priority: Trivial
Reporter: Vindy.fang Assignee: Unassigned
Resolution: Won't fix Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
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/[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

 Comments   
Comment by richlv [ 2016 Oct 22 ]

this issue tracker is for bugreports. please see http://zabbix.org/wiki/Getting_help for support options.

Comment by Aleksandrs Saveljevs [ 2016 Oct 24 ]

Closing as "Won't fix" as per richlv's comment above.

Generated at Thu Apr 25 01:11:02 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.