If you’re referring to the link speed (100Mb, 1Gb, etc) then that has historically been a problem with permissions when snmpd tries to access ethtool info. You basically have 3 options:
- Run snmpd as “root” (Not recommended) - Enable ETHTOOL_GSET in the kernel - Add the link speed of each NIC to snmpd.conf (interface ethX 6 <speed in bits/s>)
I went with the third option and wrote a script to do this for me. This info is kept in the “ports” table.
Or are you talking about current throughput and not port speed?
-Hogan
On Aug 8, 2014, at 10:09 AM, Nick Pais nick@nickserver.net wrote:
Hi guys,
It's been a while since I posted on here, but I made a fresh Observium installation (for the moment, yes, it's CE, can't convince the CEO to shell out that cash for Pro yet...) however I'm having a weird issue with the table ports-state:
root@comet:/opt/observium# ./poller.php -h 1 -d | grep -C2 MEMORY\ DB
SQL[INSERT INTO `ports-state` (`port_id`) VALUES ('1')] Certain MEMORY DB error for table 'ports-state'.
SQL[UPDATE `ports-state` set `poll_time` ='1407517231',`poll_period` ='1407517231',`ifInOctets` ='2974209',`ifOutOctets` ='2974209',`ifInErrors` ='0',`ifOutErrors` ='0',`ifInUcastPkts` ='10310',`ifOutUcastPkts` ='10310',`ifInOctets_perc` ='0',`ifOutOctets_perc` ='0',`ifOctets_rate` ='0',`ifUcastPkts_rate` ='0',`ifErrors_rate` ='0' WHERE `port_id` = '1']
SQL[INSERT INTO `ports-state` (`port_id`) VALUES ('2')] Certain MEMORY DB error for table 'ports-state'.
SQL[UPDATE `ports-state` set `poll_time` ='1407517231',`poll_period` ='1407517231',`ifInOctets` ='997162274',`ifOutOctets` ='12070347',`ifInErrors` ='0',`ifOutErrors` ='0',`ifInUcastPkts` ='929556',`ifOutUcastPkts` ='92562',`ifInOctets_perc` ='0',`ifOutOctets_perc` ='0',`ifOctets_rate` ='0',`ifUcastPkts_rate` ='0',`ifErrors_rate` ='0' WHERE `port_id` = '2']
SQL[INSERT INTO `ports-state` (`port_id`) VALUES ('3')] Certain MEMORY DB error for table 'ports-state'.
SQL[UPDATE `ports-state` set `poll_time` ='1407517231',`poll_period` ='1407517231',`ifInOctets` ='17012646',`ifOutOctets` ='369532358',`ifInErrors` ='0',`ifOutErrors` ='0',`ifInUcastPkts` ='74830',`ifOutUcastPkts` ='550361',`ifInOctets_perc` ='0',`ifOutOctets_perc` ='0',`ifOctets_rate` ='0',`ifUcastPkts_rate` ='0',`ifErrors_rate` ='0' WHERE `port_id` = '3'] root@comet:/opt/observium#
This in turn doesn't enable the "current" port speeds on the web and when I look in the database itself, the table is empty. Has anyone come accross this before? Is there a way to fix this?
Details:
OS: Debian 7.6 PHP: 5.4.4-14+deb7u12 MySQL: 5.6.15 Observium: v0.14.4.5229
Thanks in advance guys! _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium