在Observium上添加端口

Question

我已经安装了Observium，它运行得很好，除了一件事:没有端口出现。我添加了3个安装了snmpd的设备(Debian 7)，除了网络流量之外，所有的图表都会显示(cpu、mem)，在首页显示如下：

 Ports  0   0 up    0 down  0 ignored   0 disabled

我还在一个设备上安装了代理，它没有改变任何东西。

所使用的配置在这里(所有私人信息注意到xx)：

$config['db_host'] = 'localhost';
$config['db_user'] = 'xx';
$config['db_pass'] = 'xx';
$config['db_name'] = 'xx';

// Base directory
$config['install_dir'] = "/opt/observium";

// Default community list to use when adding/discovering
$config['snmp']['community'] = array("xx");

// Authentication Model
$config['auth_mechanism'] = "mysql";    // default, other options: ldap, http-auth, please see documentation for config he$

// Enable alerter (not available in CE)
#$config['poller-wrapper']['alerter'] = TRUE;

// Set up a default alerter (email to a single address)
$config['alerts']['alerter']['default']['descr']   = "Observium - Alert";
$config['alerts']['alerter']['default']['type']    = "email";
$config['alerts']['alerter']['default']['contact'] = "xx@xx.com";
$config['alerts']['alerter']['default']['enable']  = TRUE;

$config['poller_modules']['unix-agent'] = 1;
$config['collectd_dir'] = '/var/lib/collectd/rrd';
$config['int_customers']           = 1;  # Enable Customer Port Parsing
$config['int_transit']             = 1;  # Enable Transit Types
$config['int_peering']             = 1;  # Enable Peering Types
$config['int_core']                = 1;  # Enable Core Port Types
$config['int_l2tp']                = 0;  # Enable L2TP Port Types
$config['show_locations']          = 1;  # Enable Locations on menu
$config['show_locations_dropdown'] = 1;  # Enable Locations dropdown on menu
$config['show_services']           = 0;  # Enable Services on menu (Disabled by default as this option is deprecated)
$config['ports_page_default']      = "details/"; ## eg "details/" "graphs/bits/"
$config['show_overview_tab'] = true;
$config['overview_show_sysDescr'] = true;
$config['frontpage']['device_status']['ports'] = true;
$config['device_traffic_iftype']  = array('/loopback/','/tunnel/','/virtual/','/mpls/');
$config['device_traffic_descr']   = array('/loopback/','/vlan/','/tunnel/','/:\d+/');
// End config.php

是配置的问题吗？这是专业版的吗?谢谢你的帮助，我刚接触过“观察家”，我觉得很棒(除了这个小问题.)

Answer 1

问题解决了！轻松修复我的MySQL Observium数据库：

ALTER TABLE  `ports` CHANGE  `port_label_short`  `port_label_short` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ; 

解释：

我运行了./discovery.php -d -m ports -h 4 (4是我的主机id)，它在运行查询时显示了很多错误：

ERROR[Error in query: (1364) Field 'port_label_short' doesn't have a default value]

这个错误是关键，因为我只需要在这个列上设置一个默认值。