- observium - lists.observium.org

Cisco Wifi APs registered twice
by Lars Joergensen 23 Oct '20

23 Oct '20

Hi We had a power mishap which resulted in the Cisco wifi controller rebooting. After that all the AP's got registered twice in observium. Deleting the controller and re-adding it didn't clear up the issue. I manually deleted all entries from the wifi_aps table and got the thing working correct. It's not a big issue, but it should be an easy change to only add unique APs, based on name or MAC, to the database. Lars ________________________________ Disclaimer: This e-mail, including any attachments, is for the intended recipient only. If you have received this e-mail by mistake please notify the sender immediately by return e-mail and delete this e-mail and any attachments, without opening the attachments, from your system. Access, disclosure, copying, distribution or reliance on any part of this e-mail by anyone else is prohibited. This e-mail is confidential and may be legally privileged. Chr. Hansen does not represent and/or warrant that the information sent and/or received by or with this e-mail is correct and does not accept any liability for damages related thereto. https://www.chr-hansen.com/en/legal-notice

1 0

Graphs keep reset randomly and losing previous history
by Gordon Cheng (gocheng) 22 Oct '20

22 Oct '20

Hi Adam and Observium team: We recently started having an issue with our Observium (20.9.10749) that the graphs for different devices would restart and all its previous history would be gone: [Graphical user interface Description automatically generated] And we usually see the following ‘messages’ under /var/log around that time: Oct 18 05:07:13 sjc-observium-1 rrdcached[1495]: queue_thread_main: rrd_update_r (/opt/observium/rrd/atl-wan04/status.rrd) failed with status -1. (/opt/observium/rrd/atl-wan04/status.rrd: illegal attempt to update using time 1603020715 when last update time is 1603021928 (minimum one second step)) Oct 19 05:12:05 sjc-observium-1 rrdcached[14841]: queue_thread_main: rrd_update_r (/opt/observium/rrd/atl-wan04/status.rrd) failed with status -1. (/opt/observium/rrd/atl-wan04/status.rrd: illegal attempt to update using time 1603106221 when last update time is 1603108322 (minimum one second step)) Oct 20 05:32:47 sjc-observium-1 rrdcached[14471]: queue_thread_main: rrd_update_r (/opt/observium/rrd/atl-wan04/status.rrd) failed with status -1. (/opt/observium/rrd/atl-wan04/status.rrd: illegal attempt to update using time 1603194156 when last update time is 1603194737 (minimum one second step)) We have tried restarting the rrdcached process, and deleting the rrdcached files which are not updated for some time (with the command “find * -type f -mtime +5 -delete” under the rrd directory). But they don’t help much. Do you have any suggestions how we can further investigate and troubleshoot this? Thanks. - Gordon

5 7

Error drawing graph (can not parse an empty rpn expression)
by McGregor, Kevin 22 Oct '20

22 Oct '20

I just upgraded from 19.8 to 20.9 CE. In both I've been having the same problem: Everything works as expected, except two devices (of 19) produce a big pink box instead of a chart for the "Ports" widget on the Overview page for the devices. The chart is titled "Error Drawing Graph". Other similar devices (same OS version, etc.) all show a normal-looking chart in the same place. The devices are "SunOS <hostname> 5.11 11.4.25.75.3 sun4v". Most other devices of the same version work, just not two of them. When I click on the chart, I get the Ports page and a bigger version of the same chart. Selecting "RRD Command" produces this below the pink box: Description Device total traffic in bits/sec. Performance & Output RRDTool Output: ERROR: can not parse an empty rpn expression RRDtool Runtime: 0.011s | Total time: 0.012s RRDTool Command /usr/bin/rrdtool graph /tmp/DZSTkOrAZmZQeckq.png -g -Y --alt-autoscale --rigid --start 1603133061 --end 1603219461 --width 1152 --height 300 -c BACK#EEEEEE00 -c SHADEA#EEEEEE00 -c SHADEB#EEEEEE00 -c FONT#000000 -c CANVAS#FFFFFF00 -c GRID#a5a5a5 -c MGRID#FF9999 -c FRAME#5e5e5e -c ARROW#5e5e5e -R normal --font LEGEND:8:'DroidSansMono,DejaVuSansMono' --font AXIS:7:'DroidSansMono,DejaVuSansMono' --font-render-mode normal -E CDEF:inB= CDEF:outB= CDEF:octets=inB,outB,+ CDEF:doutB=outB,-1,* CDEF:inbits=inB,8,* CDEF:outbits=outB,8,* CDEF:bits=inbits,outbits,+ CDEF:doutbits=doutB,8,* VDEF:95thin=inbits,95,PERCENT VDEF:95thout=outbits,95,PERCENT CDEF:pout_tmp=doutbits,-1,* VDEF:dpout_tmp=pout_tmp,95,PERCENT CDEF:dpout_tmp2=doutbits,doutbits,-,dpout_tmp,-1,*,+ VDEF:d95thout=dpout_tmp2,FIRST VDEF:totin=inB,TOTAL VDEF:avein=inbits,AVERAGE VDEF:totout=outB,TOTAL VDEF:aveout=outbits,AVERAGE VDEF:tot=octets,TOTAL COMMENT:' \l' HRULE:999999999999999#FFFFFF:'Total Rx' GPRINT:inbits:LAST:%6.2lf%s GPRINT:inbits:AVERAGE:%6.2lf%s GPRINT:inbits:MIN:%6.2lf%s GPRINT:inbits:MAX:%6.2lf%s GPRINT:totin:%6.2lf%sB COMMENT:'\l' HRULE:999999999999999#FFFFFF:' Tx' GPRINT:outbits:LAST:%6.2lf%s GPRINT:outbits:AVERAGE:%6.2lf%s GPRINT:outbits:MIN:%6.2lf%s GPRINT:outbits:MAX:%6.2lf%s GPRINT:totout:%6.2lf%sB COMMENT:'\l' HRULE:999999999999999#FFFFFF:' Agg' GPRINT:bits:LAST:%6.2lf%s GPRINT:bits:AVERAGE:%6.2lf%s GPRINT:bits:MIN:%6.2lf%s GPRINT:bits:MAX:%6.2lf%s GPRINT:tot:%6.2lf%sB COMMENT:'\l' HRULE:0#999999 RRDTool Files Used /opt/observium/rrd/<hostname>/port-2.rrd /opt/observium/rrd/<hostname>/port-1.rrd Would someone please give me a place to start looking for the problem? Thanks!

3 10

How to add minigraph in dashboard
by Brij Mohan 22 Oct '20

22 Oct '20

Hi Team How will I add a minigraph in the dashboard. current my OBS version is Observium 20.8.10645(stable) Thanks,

1 1

Re: [Observium] WMI custom queries and MSSQL developments
by Adam Armstrong 21 Oct '20

21 Oct '20

Hi, You cant just add extra data to an RRD, they have a fixed format. Youd also need to add code to graph and display the data. Its a fair bit more complicated than this, especially for WMI. Adam. From: Rando Sui <rando(a)blueit.ee> Sent: 21 October 2020 06:30 To: Adam Armstrong <adama(a)observium.org> Subject: RE: [Observium] WMI custom queries and MSSQL developments Hi, OK, hopefully in future versions. How you develop mssql.inc.php . I added one line to see also transactions, uploaded file and rebooted observium, but nothing appears. Am I missing something? $wql = "SELECT * FROM ".$wmi_class_prefix."GeneralStatistics"; $wmi['mssql'][$instance['Name']]['stats'] = wmi_parse(wmi_query($wql, $override), TRUE); if ($wmi['mssql'][$instance['Name']]['stats']) { $app_found['mssql'] = TRUE; echo("Stats; "); rrdtool_update_ng($device, 'mssql-stats', array( 'userconnections' => $wmi['mssql'][$instance['Name']]['stats']['UserConnections'], 'transactions' => $wmi['mssql'][$instance['Name']]['stats']['Transactions'], ), $instance['Name']); $app_data['stats']['UsrConn'] = $wmi['mssql'][$instance['Name']]['stats']['UserConnections']; $app_data['stats']['Transactions'] = $wmi['mssql'][$instance['Name']]['stats']['Transactions']; } Gr, Rando. From: observium <observium-bounces(a)observium.org <mailto:observium-bounces@observium.org> > On Behalf Of Adam Armstrong via observium Sent: teisipäev, 20. oktoober 2020 23:52 To: 'Observium' <observium(a)observium.org <mailto:observium@observium.org> > Cc: Adam Armstrong <adama(a)observium.org <mailto:adama@observium.org> > Subject: Re: [Observium] WMI custom queries and MSSQL developments Hi, We dont really have the ability to do this. :) Adam. From: observium <observium-bounces(a)observium.org <mailto:observium-bounces@observium.org> > On Behalf Of Rando Sui via observium Sent: 20 October 2020 19:15 To: observium(a)observium.org <mailto:observium@observium.org> Cc: Rando Sui <rando(a)blueit.ee <mailto:rando@blueit.ee> > Subject: [Observium] WMI custom queries and MSSQL developments Hello, We are using paid version of observium. How you can make custom WMI queries for hosts? How you can develop metrics for MSSQL? There is some available Id like to add but they are not shown once I upload .php file and reboot observium. Greetings, Rando.

2 1

Font sharpness (bold only)
by Klimek, Denis 21 Oct '20

21 Oct '20

Hi there, after updating to the latest SVN revision 10770 we noticed that every bold written font is not very clear to read. It looks blurred. Is there any way to disable this blurred effect? Mit freundlichem Gruß wilhelm.tel GmbH Denis Klimek Carrier Manager & Professional Network Engineer IP-Systemtechnik Tel: +49 (0) 40 / 521 04 - 1049 -> Work From Home Mobil: +49 (0) 151 / 652 219 06 dklimek(a)stadtwerke-norderstedt.de www.wilhelm-tel.de ______________________________________________ [cid:image001.png@01D6A6DC.DD840100] Postanschrift: wilhelm.tel GmbH Heidbergstraße 101-111 22846 Norderstedt Geschäftsführer: Jens Seedorff, Theo Weirich Vorsitzender des Aufsichtsrats: Christoph Mendel Handelsregister: HRB 4216 NO, Amtsgericht Kiel Umsatzsteuer ID: DE 81 299 7663 [ig]<https://www.instagram.com/azubiteam/>[fb]<https://www.facebook.com/wilhelmtel.norderstedt/>

2 3

Polling not periodical
by Ing. Andrés Gallo 21 Oct '20

21 Oct '20

Hello We are using latest Observium 20.9.10749 (stable), paid edition Noted that in some graphs, kind of spikes. Debugging shows that the polling interval is not every 300 seconds: /37554|1603201212|267|1785377894|1068531295|386467237639270|41301474049631|87Mbps|22.7Mbps|v2c// //37554|1603201534|322|2182521058|2288947079|386489109618914|41306989432711|67.9Mbps|17.1Mbps|v2c// //37554|1603201811|277|2993214954|3745224137|386511395149290|41312740677065|80.4Mbps|20.7Mbps|v2c// //37554|1603202130|319|2034988746|794409408|386536206726858|41318379796928|77.7Mbps|17.6Mbps|v2c// //37554|1603202410|280|215877678|2105208367|386560157419566|41323985563183|85.5Mbps|20Mbps|v2c// //37554|1603202737|327|2876073363|3906420769|386584292451731|41330081742881|73.8Mbps|18.6Mbps|v2c// //37554|1603203010|273|816113491|1430194856|386608002295635|41336195451560|86.8Mbps|22.3Mbps|v2c/ So, the graphs is with spikes, because not similar period taken. Obviously, each 5 minutes, CPU raises to 75% ( Xeon 16 Cores, 8 Gb RAM, ) /[2020/10/20 11:21:04 -0300] observium-wrapper(611935): /opt/observium/observium-wrapper: processed 160 devices in 62.68 seconds with 32 threads, load average (5min) 8.45/ What can I do to fix it? Regards -- Saludos Saludos, * Ing. Andrés E. Gallo* Tel (02255)-46-1641 Móvil (02255)-15-57-0220 Paseo 114 y Av. 3 (B7165) Villa Gesell-Bs.As. agallo(a)cotel.com.ar <mailto:agallo@fecosur.com.ar> http://www.gesell.com.ar <http://www.nuestro.com.ar>

2 4

WMI custom queries and MSSQL developments
by Rando Sui 20 Oct '20

20 Oct '20

Hello, We are using paid version of observium. How you can make custom WMI queries for hosts? How you can develop metrics for MSSQL? There is some available I'd like to add but they are not shown once I upload .php file and reboot observium. Greetings, Rando.

2 1

Question about use and support
by Matthew Cotter 20 Oct '20

20 Oct '20

Greetings, I am new to this and Observium. We have a paid version and I have some questions about support and upgrading. Question 1, how do I get support? Support question, when I try to add a device, I get an error saying it can't ping the device. I have logged into the terminal of observium and can ping the device Support question, I recently received an email about a new version, I tried to run the update, but it fails saying it can't find the root folder or something like that. I can provide more details, but this is the basic questions I have and if you can point me in the proper direction how to get these answered I would appreciate that. Thank you, Matt Matthew Cotter Network Support Engineer Boston Inc. dba Furniture & ApplianceMart | Ashley HomeStore 2404 W, Beltline Hwy Madison, WI 53713 (p) 608-277-7700 (e) Matt.Cotter(a)BostonFAM.com BostonFAM.com<http://www.BostonFAM.Com> | AshleyHomestores.com<https://www.ashleyfurniturehomestore.com> | furnitureappliancemart.com<https://www.furnitureappliancemart.com/> [FAM Stores] "Improving the quality of people's lives by making amazing rooms together!" Central Wisconsin Area - Marshfield | Rhinelander | Stevens Point | Wausau Fox Valley Area - Appleton | Green Bay | Oshkosh Madison Area - Madison East | Madison West | Janesville Milwaukee Area - Greenfield | Kenosha | Pewaukee | Richfield All locations owned & operated by Boston Inc. This e-mail contains privileged and confidential information intended only for the use of Boston Inc. or one or more of its employees. If the reader of this e-mail is not the intended recipient, please be advised that any retention, dissemination, or copying of this e-mail is strictly prohibited and may result in legal action. If you have received this e-mail in error, please immediately notify the sender by e-mail and delete the original e-mail from your mailbox.

2 1

API after update
by Olivier CALVANO 20 Oct '20

20 Oct '20

Hi i have upgraded Observium to the latest version Observium 20.9.10749 (stable) But now my internal portal can't access to the api and i have in error_log: [Tue Oct 13 10:01:28.074195 2020] [php7:error] [pid 25948] [client 192.168.1.125:35270] script '/opt/observium/html/api.php' not found or unable to stat [Tue Oct 13 11:12:15.654668 2020] [php7:error] [pid 4782] [client 192.168.1.101:52048] script '/opt/observium/html/elrekt.php' not found or unable to stat anyone know this problems ? regards Olivier

2 4