[ZBX-3253] zabbix does not support schema selection for ibm db2 Created: 2010 Dec 02  Updated: 2017 May 30  Resolved: 2010 Dec 17

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F), Server (S)
Affects Version/s: 1.8.4rc2
Fix Version/s: 1.8.4

Type: Incident report Priority: Critical
Reporter: Aleksandrs Saveljevs Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by ZBXNEXT-574 Schema support for db2 Closed

 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.



 Comments   
Comment by Alexey Fukalov [ 2010 Dec 09 ]

dev branch: ZBX-3253

Comment by Alexey Fukalov [ 2010 Dec 13 ]

branches/1.8 16042

Comment by richlv [ 2010 Dec 13 ]

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) ?

Comment by richlv [ 2010 Dec 14 ]

config wizard is not translatable yet -> closing

Comment by Aleksandrs Saveljevs [ 2010 Dec 14 ]

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

Comment by Alexey Fukalov [ 2010 Dec 14 ]

dev branch: ZBX-3253

Comment by Alexey Fukalov [ 2010 Dec 14 ]

branches/1.8 16076

Comment by Alexander Vladishev [ 2010 Dec 14 ]

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

Comment by Alexey Fukalov [ 2010 Dec 14 ]

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.

Comment by Alexey Fukalov [ 2010 Dec 17 ]

branches/1.8 16191

Generated at Fri Jan 18 09:53:37 EET 2019 using JIRA 7.3.9#73021-sha1:26adfd3d76803e1a04219c5cd05b58dbafff0dbf.