On 07 Nov 2016, at 4:16 PM, Adam Armstrong <adama@memetic.org> wrote:

On the end of the graph URL, not on the end of the page URL.

So this is what I did - hopefully correct …

Observium -> Devices -> All Devices -> Pick one at random -> Ports -> ether1 -> Under traffic select the first [?] . Pick 6 hours and “Open image in new tab” and add &debug=1

http://observium.lightspeed.co.za/graph.php?type=port_bits&to=1478544692&id=11582&from=1478523092&height=60&width=113&legend=no&debug=1

SELECT * FROM `entity_permissions` WHERE `user_id` = ‘1'

SELECT `alert_table_id`, `device_id`, `entity_id`, `entity_type` FROM `alert_table`

SELECT `value` FROM `users_prefs` WHERE `user_id` = '1' AND `pref` = 'atom_key'

> $graphtype/usr/local/www/observium/html/includes/graphs/graph.inc.php:33array(50=>port_bitstype=>port1=>portsubtype=>bits2=>bits)

SELECT `device_id` FROM `ports` WHERE `port_id` = '11582'

SELECT * FROM `ports` WHERE `ports`.`port_id` = '11582'

SELECT * FROM `devices` WHERE `device_id` = '246'

SELECT * FROM `device_graphs` WHERE `device_id` = '246'

RRD CMD[%ygraph /tmp/1UawDb1OdZwZKoMg.png -g -Y --alt-autoscale --rigid --start 1478523092 --end 1478544692 --width 113 --height 60 -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 --only-graph --font LEGEND:7:'DroidSansMono,DejaVuSansMono' --font AXIS:6:'DroidSansMono,DejaVuSansMono' --font-render-mode normal -E COMMENT:'Bits/s Last Avg Max 95th \n' DEF:outoctets=/usr/local/www/observium/rrd/comitis.lightspeed.co.za/port-2.rrd:OUTOCTETS:AVERAGE DEF:inoctets=/usr/local/www/observium/rrd/comitis.lightspeed.co.za/port-2.rrd:INOCTETS:AVERAGE DEF:outoctets_max=/usr/local/www/observium/rrd/comitis.lightspeed.co.za/port-2.rrd:OUTOCTETS:MAX DEF:inoctets_max=/usr/local/www/observium/rrd/comitis.lightspeed.co.za/port-2.rrd:INOCTETS:MAX CDEF:alloctets=outoctets,inoctets,+ CDEF:wrongin=alloctets,UN,INF,UNKN,IF CDEF:wrongout=wrongin,-1,* CDEF:octets=inoctets,outoctets,+ CDEF:doutoctets=outoctets,-1,* CDEF:outbits=outoctets,8,* CDEF:outbits_max=outoctets_max,8,* CDEF:doutoctets_max=outoctets_max,-1,* CDEF:doutbits=doutoctets,8,* CDEF:doutbits_max=doutoctets_max,8,* CDEF:inbits=inoctets,8,* CDEF:inbits_max=inoctets_max,8,* VDEF:totin=inoctets,TOTAL VDEF:totout=outoctets,TOTAL VDEF:tot=octets,TOTAL 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 AREA:inbits#92B73F LINE1.25:inbits#4A8328:'In ' GPRINT:inbits:LAST:%6.2lf%s GPRINT:inbits:AVERAGE:%6.2lf%s GPRINT:inbits_max:MAX:%6.2lf%s GPRINT:95thin:%6.2lf%s\n AREA:doutbits#7075B8 LINE1.25:doutbits#323B7C:'Out' GPRINT:outbits:LAST:%6.2lf%s GPRINT:outbits:AVERAGE:%6.2lf%s GPRINT:outbits_max:MAX:%6.2lf%s GPRINT:95thout:%6.2lf%s\n LINE1:95thin#aa0000 LINE1:d95thout#bb0000 GPRINT:tot:'Total %6.2lf%s' GPRINT:totin:'(In %6.2lf%s' GPRINT:totout:'Out %6.2lf%s)\l' AREA:wrongin#FFF2F2 AREA:wrongout#FFF2F2%n]

RRD RUNTIME[0.0379s]
RRD STDOUT[113x60]
RRD_STATUS[TRUE]

CMD[/bin/ls -l /tmp/1UawDb1OdZwZKoMg.png]

CMD EXITCODE[0]
CMD RUNTIME[0.0095s]

STDOUT[
-rw-r--r-- 1 www wheel 3358 Nov 7 20:51 /tmp/1UawDb1OdZwZKoMg.png
]

Runtime 0.083518981933594 secs

adam.

Sent from Mailbird
On 07/11/2016 14:14:44, Shaun Courtney <shaun@cybersmart.co.za> wrote:
Hi
On 07 Nov 2016, at 3:15 PM, Adam Armstrong <adama@memetic.org> wrote:

Open one of the graph URLs in a separate window and add &debug=1 to the end of the URL.

Picked one at random - a whole lot of SQL … and the only “red” errors:
SELECT COUNT(*) FROM `ports` WHERE `pagpGroupIfIndex` = '2' and `device_id` = '274'
Error in query: (Unknown column 'pagpGroupIfIndex' in 'where clause') 1054
Not sure if that helps.

This has been dropped from the table ports - update 297.sql

update/297.sql:ALTER TABLE `ports` DROP `pagpOperationMode` ,DROP `pagpPortState` ,DROP `pagpPartnerDeviceId` ,DROP `pagpPartnerLearnMethod` ,DROP `pagpPartnerIfIndex` ,DROP `pagpPartnerGroupIfIndex` ,DROP `pagpPartnerDeviceName` ,DROP `pagpEthcOperationMode` ,DROP `pagpDeviceId` ,DROP `pagpGroupIfIndex` ;

Not sure where else to check?

Observium 0.16.11.8202 (rolling)
<PastedGraphic-4.png>

Also have this at the bottom of the page.

<PastedGraphic-6.png>

But I don’t think this error is the cause, as on another instance I have the same error - but the graphing works Observium 0.16.10.8181 (stable)

<PastedGraphic-5.png>

Also, please don't hijack existing list threads

Sorry ;(
-sc
Adam.

Sent from BlueMail
On 7 Nov 2016, at 12:45, Shaun Courtney <shaun@cybersmart.co.za> wrote:
Hi

Since I’ve updated to 8202 - no graphs are drawing. Not sure where to check?

Regards,

Shaun

<PastedGraphic-3.png>
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium