Multi-node Setup: Web class does not properly configure database port

[rtizzy]

"database_port" is not properly set when web node is split from master node.

Puppet code:

# Zabbix Web Node

node 'MASTER' {
  file { '/etc/yum.conf':
    source => 'puppet:///modules/yum/yum.conf',
    owner  => root,
    group  => root,
  }
  class { 'apache':
      mpm_module => 'prefork',
  }
  class { 'apache::mod::php': }
  class { 'zabbix::web':
    zabbix_url      => '',
    zabbix_server   => 'MASTER',
    database_host   => 'MASTER',
    zabbix_api_user => 'whatever',
    zabbix_api_pass => 'crazysecurepassword',
    database_type   => 'mysql',
  }
}

Output:

/etc/zabbix/web/zabbix.conf.php

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

$DB['TYPE']     = 'MYSQL';
$DB['SERVER']   = 'c2t06545.itcs.hp.com';
$DB['PORT']     = '0';
$DB['DATABASE'] = 'zabbix_server';
$DB['USER']     = 'zabbix_server';
$DB['PASSWORD'] = 'zabbix_server';

// SCHEMA is relevant only for IBM_DB2 database
$DB['SCHEMA'] = '';

$ZBX_SERVER      = 'c2t06545.itcs.hp.com';
$ZBX_SERVER_PORT = '10051';
$ZBX_SERVER_NAME = 'c2t06545.itcs.hp.com';

$IMAGE_FORMAT_DEFAULT = IMAGE_FORMAT_PNG;
?>

[rtizzy]

MySQL not binding address properly:

MySQL server seems to be using "127.0.0.1" when it should be binding to the IP/hostname when in multi-node setup.

NOTE: This can be handled by the user with mysql overrides. Not sure if that's ideal behavior.

[rtizzy]

Issue with zabbix.conf.php.erb:

Currently

$DB['PORT']     = '0';

Should probably be

$DB['PORT']     = '<%= @database_port %>';

[dj-wasabi]

Hi,

I just pushed an fix for this, would you please test it?

Kind regards,
Werner

[rtizzy]

Greetings Werner,

I've tested this fix and it appears to be working as expected both with and without the "database_port" parameter for the zabbix::web class.

Thanks for the fix!

Sincerely,

elricsfate