ZABBIX BUGS AND ISSUES
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-3253

zabbix does not support schema selection for ibm db2

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: 1.8.4rc2
    • Fix Version/s: 1.8.4
    • Component/s: Frontend (F), Server (S)
    • Labels:
      None

      Description

      It should be possible to specify schema both in the frontend and in the server configuration file. If schema is specified, Zabbix should execute "set current schema $dbschema" after connecting to the database.

        Issue Links

          Activity

          Hide
          Alexey Fukalov added a comment -

          dev branch: ZBX-3253

          Show
          Alexey Fukalov added a comment - dev branch: ZBX-3253
          Hide
          Alexey Fukalov added a comment -

          branches/1.8 16042

          Show
          Alexey Fukalov added a comment - branches/1.8 16042
          Hide
          richlv added a comment -

          trunk string has been added w/o gettext function.
          also, wouldn't it have been better to use original string in the php file itself (if that's in php) ?

          Show
          richlv added a comment - trunk string has been added w/o gettext function. also, wouldn't it have been better to use original string in the php file itself (if that's in php) ?
          Hide
          richlv added a comment -

          config wizard is not translatable yet -> closing

          Show
          richlv added a comment - config wizard is not translatable yet -> closing
          Hide
          Aleksandrs Saveljevs added a comment -

          Empty DB schema for IBM DB2 is not written into the configuration file. The installation wizard then complains that DB schema is not set.

          Show
          Aleksandrs Saveljevs added a comment - Empty DB schema for IBM DB2 is not written into the configuration file. The installation wizard then complains that DB schema is not set.
          Hide
          Alexey Fukalov added a comment -

          dev branch: ZBX-3253

          Show
          Alexey Fukalov added a comment - dev branch: ZBX-3253
          Hide
          Alexey Fukalov added a comment -

          branches/1.8 16076

          Show
          Alexey Fukalov added a comment - branches/1.8 16076
          Hide
          Alexander Vladishev added a comment -

          "Zabbix is temporarily unavailable!" if option $DB['SCHEMA'] is not available in zabbix.conf.php

          Show
          Alexander Vladishev added a comment - "Zabbix is temporarily unavailable!" if option $DB ['SCHEMA'] is not available in zabbix.conf.php
          Hide
          Alexey Fukalov added a comment -

          Decided to separate config parameters for mandatory and optional. If optional parameter missing, default value is used. If mandatory parameter missing, error is shown with info about missing parameter.

          Default values:

          $DB["TYPE"] = *
          $DB["SERVER"] = 'localhost';
          $DB["PORT"] = '0';
          $DB["DATABASE"] = *
          $DB["USER"] = '';
          $DB["PASSWORD"] = '';
          $DB["SCHEMA"] = '';

          $ZBX_SERVER = 'localhost';
          $ZBX_SERVER_PORT = '10051';
          $ZBX_SERVER_NAME = '';

          $IMAGE_FORMAT_DEFAULT = IMAGE_FORMAT_PNG;

          $DB["TYPE"] and $DB["DATABASE"] are mandatory.

          If we cannot connect to database, error is shown.

          Show
          Alexey Fukalov added a comment - Decided to separate config parameters for mandatory and optional. If optional parameter missing, default value is used. If mandatory parameter missing, error is shown with info about missing parameter. Default values: $DB ["TYPE"] = * $DB ["SERVER"] = 'localhost'; $DB ["PORT"] = '0'; $DB ["DATABASE"] = * $DB ["USER"] = ''; $DB ["PASSWORD"] = ''; $DB ["SCHEMA"] = ''; $ZBX_SERVER = 'localhost'; $ZBX_SERVER_PORT = '10051'; $ZBX_SERVER_NAME = ''; $IMAGE_FORMAT_DEFAULT = IMAGE_FORMAT_PNG; $DB ["TYPE"] and $DB ["DATABASE"] are mandatory. If we cannot connect to database, error is shown.
          Hide
          Alexey Fukalov added a comment -

          branches/1.8 16191

          Show
          Alexey Fukalov added a comment - branches/1.8 16191

            People

            • Assignee:
              Alexey Fukalov
              Reporter:
              Aleksandrs Saveljevs
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: