Hi

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

It seems that the graphs are drawing correctly, but something is happening before they get displayed.

Did you put some erroneous characters in your config.php?

Does it have a ?> at the end with extra lines after it?

On the money … someone™ added a blank line after ?> ...

Sorted - thanks for the help.

Regards,


Shaun


Adam.



Sent from BlueMail

On 7 Nov 2016, at 19:03, Shaun Courtney <shaun@cybersmart.co.za> wrote:
Hi.

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


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
]
<attachment.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?  

<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


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