Ad Widget

Collapse

rc2.4.4rc1 oracle install issues

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

    #16
    you need to config php to use the Oracle driver. For that you need the Oracle client installation and in /etc/php.d/ the oci8.ini with "extension=oci8.so"

    Comment


      #17
      still not there

      Thanks for the reply. I am a step closer but still not there.
      I added the oci8.so to the ini and the I got.

      PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/oci8.so' - /usr/lib64/php/modules/oci8.so: cannot open shared object file: No such file or directory in Unknown on line 0

      I made a link in /usr/lib64/php/modules/oci8.so to libclntsh.so. no luch
      I added Environment=LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib to the httpd.service file; no luck

      Do I need to rebuild php?
      I have instantclient12.1-basic-12.1.0.2.0-1 loaded for oracle.

      Comment


        #18
        does this: http://php.net/manual/en/book.oci8.php help?

        Comment


          #19
          does PHP that came in the postgres install pkg have

          Thanks very much for the quick response.
          does PHP that came in the postgres install pkg have oracle enabled?
          "--with-oci8"

          Comment


            #20
            I am an Oracle guy, not so much php ..... normally I get tools working on Oracle, if I have enough privileges .....
            I think you need
            Code:
            pecl install oci8

            Comment


              #21
              still blank

              I am not a php guy either so I am fighting this one. How did you get zabbix front end to talk to the db. I do not have access to pull from pecl. Do I need to rebuild php for oracle? or is there a binary I can drop in?

              Comment


                #22
                on step

                I got OCI8 loaded in the PHP process, at least no errors. but I am getting "Error connecting to Database" I have tried all options in the zabbix.conf.php. How do I get some helpful messages fro the php process to see what the issue is?

                Comment


                  #23
                  Originally posted by ik_zelf View Post
                  Because I ran into this issue <Compilation of server fails for 2.4.3 with Oracle support with zabbix 2.4.3 I tried 2.4.4rc1, as was suggested in the article.

                  Linux OL6.5
                  Oracle 12.1.0.2

                  1) for oracle and db2 the schema.sql is not generated
                  2) the webinterface does not get me past setup.php
                  3) almost forgot to mention: in oracle nvarchar2 length limit is 2000 characters, not 2048.

                  The webinterface has an issue with case sensitivity in DB[TYPE] ORACLE. If using Oracle it shows the db config screen, If using ORACLE it just complains about not being able to connect. Looks like some inconsistency.

                  I can not find logs, access_log and error_log don't have any error messages related to the database connection. 192.168.1.1 192.168.0.1 10.0.0.1

                  zabbix_server is running without problems.
                  Also installed the images.

                  With the config in /var/www/html/zabbix/conf/zabbix.conf.php I can choose between the following error message:

                  <?php
                  // Zabbix GUI configuration file.
                  global $DB;

                  $DB["TYPE"] = 'ORACLE';
                  $DB["SERVER"] = 'localhost';
                  $DB["PORT"] = '1521';
                  $DB["DATABASE"] = 'orcl';
                  $DB["USER"] = 'zabbix';
                  $DB["PASSWORD"] = 'zabbix';
                  // Schema name. Used for IBM DB2 and PostgreSQL.
                  $DB["SCHEMA"] = 'zabbix';
                  $ZBX_SERVER = 'localhost';
                  $ZBX_SERVER_PORT = '10051';
                  $ZBX_SERVER_NAME = '';
                  $IMAGE_FORMAT_DEFAULT = IMAGE_FORMAT_PNG;
                  ?>

                  I get:
                  Zabbix 2.4.4rc1
                  Database error
                  Error connecting to database:


                  and with
                  <?php
                  // Zabbix GUI configuration file.
                  global $DB;

                  $DB["TYPE"] = 'Oracle';
                  $DB["SERVER"] = 'localhost';
                  $DB["PORT"] = '1521';
                  $DB["DATABASE"] = 'orcl';
                  $DB["USER"] = 'zabbix';
                  $DB["PASSWORD"] = 'zabbix';
                  // Schema name. Used for IBM DB2 and PostgreSQL.
                  $DB["SCHEMA"] = 'zabbix';
                  $ZBX_SERVER = 'localhost';
                  $ZBX_SERVER_PORT = '10051';
                  $ZBX_SERVER_NAME = '';
                  $IMAGE_FORMAT_DEFAULT = IMAGE_FORMAT_PNG;
                  ?>

                  I get:
                  Zabbix 2.4.4rc1
                  Configuration file error
                  DB type has wrong value. Possible values MYSQL, POSTGRESQL, ORACLE, IBM_DB2, SQLITE3

                  It's a pity that I can not find a more descriptive error message.
                  /* $DB['DB'] = @oci_connect($DB['USER'], $DB['PASSWORD'], $connect); */
                  $DB['DB'] = @oci_connect('zabbix', 'zabbix', '127.0.0.1:1521/orcl');
                  if ($DB['DB']) {
                  DBexecute('ALTER SESSION SET NLS_NUMERIC_CHARACTERS='.zbx_dbstr('. '));
                  }
                  else {
                  $ociError = oci_error();
                  $error = 'Error boe connecting to database: '.$ociError['message'];
                  $result = false;
                  }

                  does not show any error info, I guess the problem is the oci_connect itself. I see not a single request in the oracle listener log file. I do see my 'boe' marker in the browser.

                  Comment

                  Working...
                  X