Issue with Queues in RRD Mailreport package



  • I searched but did not find any threads related to the mailreport package.  This is a pretty nice tool that will send you daily, weekly, monthly, etc emails containing that period's RRD Graphs.

    Anyway, I'm having a small issue related to the content of the email.  I have the following graphs set up in a daily report:
    WAN :: Traffic    
    WAN :: Quality    
    WAN :: Queues    
    WAN :: Queuedrops    
    System :: States    
    System :: Processor

    It works great the first time after a reboot, but any subsequent daily emails will show up missing the graphs for Queues and Queuedrops.

    Seems strange, but I'm sure there's a perfectly reasonable explanation.


  • Rebel Alliance Developer Netgate

    I haven't seen that myself but then I don't use the queue graph there. (Disclaimer: I wrote that package)

    So the graph is completely missing and doesn't show up at all? Or it's a broken image? Or … ?



  • @jimp:

    So the graph is completely missing and doesn't show up at all? Or it's a broken image? Or … ?

    Completely missing.  After a reboot the email will contain 6 attached images.  Then, any subsequent email reports will only contain 4 attachments.  I just rebooted today, so if for some reason I don't see 6 images tomorrow morning I'll let you know.

    Here's a screen grab of the config page
    https://skitch.com/rdlugosz/gdafm/pfsense.localdomain-status-edit-mail-reports

    Thanks & let me know if there's anything else I can provide that you think would be useful…

    edit: should mention that I'm running version 1.1 of your package and pfSense version: 2.0-RELEASE (i386) built on Tue Sep 13 17:00:00 EDT 2011


  • Rebel Alliance Developer Netgate

    Can you post the "<mailreports>" section of your config.xml so I can see what it's looking for?</mailreports>


  • Rebel Alliance Developer Netgate

    Also, does it show up when you click "send now" on the report? Is it only missing during the daily automatic e-mail?



  • Tried hitting "Send Now" twice just now and both emails contained all six graphs.  Interesting.

    Here's another interesting twist. I've gotten an handful of reports in the last couple of days which actually contain the Queues graph (so 5 attachments out of 6 expected).  The most recent Weekly report contained just four.

    It would seem that there's no exact consistency as I had previously suggested.

    mailreports section of config:

    	 <mailreports><schedule><frequency>daily</frequency>
    			<timeofday>5</timeofday>
    			<submit>Save</submit>
    			<id>0</id>
    			 <row><graph>wan-traffic.rrd</graph>
    
    				<timespan>day</timespan>
    				<period>absolute</period>
    				<submit>Save</submit>
    				<reportid>0</reportid></row> 
    			 <row><graph>WAN-quality.rrd</graph>
    
    				<timespan>day</timespan>
    				<period>absolute</period>
    				<submit>Save</submit>
    				<reportid>0</reportid>
    				<id>1</id></row> 
    			 <row><graph>wan-queues.rrd</graph>
    
    				<timespan>day</timespan>
    				<period>absolute</period>
    				<submit>Save</submit>
    				<reportid>0</reportid>
    				<id>2</id></row> 
    			 <row><graph>wan-queuedrops.rrd</graph>
    
    				<timespan>day</timespan>
    				<period>absolute</period>
    				<submit>Save</submit>
    				<reportid>0</reportid>
    				<id>3</id></row> 
    			 <row><graph>system-states.rrd</graph>
    
    				<timespan>day</timespan>
    				<period>absolute</period>
    				<submit>Save</submit>
    				<reportid>0</reportid>
    				<id>4</id></row> 
    			 <row><graph>system-processor.rrd</graph>
    
    				<timespan>day</timespan>
    				<period>absolute</period>
    				<submit>Save</submit>
    				<reportid>0</reportid>
    				<id>5</id></row> 
    			<schedule_friendly>Daily at 05:00</schedule_friendly></schedule> 
    		 <schedule><frequency>weekly</frequency>
    			<dayofweek>1</dayofweek>
    			<timeofday>5</timeofday>
    			<submit>Save</submit>
    			<id>1</id>
    			 <row><graph>wan-traffic.rrd</graph>
    
    				<timespan>week</timespan>
    				<period>absolute</period>
    				<submit>Save</submit>
    				<reportid>1</reportid></row> 
    			 <row><graph>WAN-quality.rrd</graph>
    
    				<timespan>week</timespan>
    				<period>absolute</period>
    				<submit>Save</submit>
    				<reportid>1</reportid></row> 
    			 <row><graph>wan-queues.rrd</graph>
    
    				<timespan>week</timespan>
    				<period>absolute</period>
    				<submit>Save</submit>
    				<reportid>1</reportid></row> 
    			 <row><graph>wan-queuedrops.rrd</graph>
    
    				<timespan>week</timespan>
    				<period>absolute</period>
    				<submit>Save</submit>
    				<reportid>1</reportid></row> 
    			 <row><graph>system-states.rrd</graph>
    
    				<timespan>week</timespan>
    				<period>absolute</period>
    				<submit>Save</submit>
    				<reportid>1</reportid></row> 
    			 <row><graph>system-processor.rrd</graph>
    
    				<timespan>week</timespan>
    				<period>absolute</period>
    				<submit>Save</submit>
    				<reportid>1</reportid></row> 
    			<schedule_friendly>Weekly, on monday at 05:00</schedule_friendly></schedule> 
    		 <schedule><frequency>monthly</frequency>
    			<dayofmonth>1</dayofmonth>
    			<timeofday>0</timeofday>
    			<submit>Save</submit>
    			<id>2</id>
    			 <row><graph>wan-traffic.rrd</graph>
    
    				<timespan>month</timespan>
    				<period>absolute</period>
    				<submit>Save</submit>
    				<reportid>2</reportid></row> 
    			 <row><graph>WAN-quality.rrd</graph>
    
    				<timespan>month</timespan>
    				<period>absolute</period>
    				<submit>Save</submit>
    				<reportid>2</reportid></row> 
    			 <row><graph>wan-queues.rrd</graph>
    
    				<timespan>month</timespan>
    				<period>absolute</period>
    				<submit>Save</submit>
    				<reportid>2</reportid></row> 
    			 <row><graph>wan-queuedrops.rrd</graph>
    
    				<timespan>month</timespan>
    				<period>absolute</period>
    				<submit>Save</submit>
    				<reportid>2</reportid></row> 
    			 <row><graph>system-states.rrd</graph>
    
    				<timespan>month</timespan>
    				<period>absolute</period>
    				<submit>Save</submit>
    				<reportid>2</reportid></row> 
    			 <row><graph>system-processor.rrd</graph>
    
    				<timespan>month</timespan>
    				<period>absolute</period>
    				<submit>Save</submit>
    				<reportid>2</reportid></row> 
    			<schedule_friendly>Monthly, on day 1 at 00:00</schedule_friendly></schedule></mailreports> 
    

    Thanks for continuing to look into this.  I hope you are considering it to be a low priority issue.


  • Rebel Alliance Developer Netgate

    Yeah I get that it's low :-)

    I've had mine running a few days now and they've come through OK every time. The code path is the same regardless of the report being run, so unless the file is actually missing at the time the report is run, I don't see what could be failing to attach just the queue graphs.



  • So… for the past two days the daily reports have included all six graphs & there's been no reboots, etc.  Maybe we just chalk this up to strange issues that occasionally happen?


  • Rebel Alliance Developer Netgate

    Not sure, but it's possible it's a timing issue that only pops up at certain times, where the rrd file is being updated by the system when the report is being run and it can't find the file at the moment it's trying to attach it.

    Not sure what else it might be…


Locked