[ZendTo] Re: rrd fixes
Jules
Jules at Zend.To
Fri Sep 23 09:25:21 BST 2011
Can you send me the output of rrdInit.php? I want to see all the rrdtool
commands it is doing.
On 23/09/2011 09:02, ROGERS Richard wrote:
>
> Aaagh, back to all NaN... I'll dig a bit and see if I can get anything
> useful.
>
> Regards
>
> Richard
>
> *From:*zendto-bounces at zend.to [mailto:zendto-bounces at zend.to] *On
> Behalf Of *Jules
> *Sent:* 22 September 2011 15:27
> *To:* ZendTo Users
> *Subject:* [ZendTo] Re: rrd fixes
>
> Yes, give it a few data points to work on.
>
> With my own production site, all the stats now match the counts in the
> ZendTo database (not looking at the RRD database). So the graphs say
> what they should say.
>
> Jules.
>
> On 22/09/2011 14:54, ROGERS Richard wrote:
>
> Hmmm... initial data population still seems to have an oddity
> somewhere -- perhaps because I had only one unexpired dropoff in the
> database -- it still gave all "NaN" in the RRD. However a manual
> update with a forged time seemed to insert a proper data line. I have
> done a new upload, and will recreate the database now and then check
> the overnight RRD update in the morning.
>
> Thanks and regards
>
> Richard
>
> *From:*zendto-bounces at zend.to <mailto:zendto-bounces at zend.to>
> [mailto:zendto-bounces at zend.to] *On Behalf Of *Jules
> *Sent:* 22 September 2011 14:19
> *To:* ZendTo Users
> *Subject:* [ZendTo] Re: rrd fixes
>
> Right. Now I've got it to generate correct data, and correct graphs.
> It really does match what the "All Dropoffs" says it should say.
>
> So please try the attached versions. You must delete your zendto.rrd
> file first. It will re-create all the data, so you won't lose any old
> stats. Then run rrdInit.php and then rrdUpdate.php, then check the
> graphs on your site.
>
> Please let me know if you think this works. If it does, I'll start on
> a release.
>
> Thanks for your patience,
> Jules.
>
> On 21/09/2011 09:48, ROGERS Richard wrote:
>
> I'm sorry to say I think there are still problems with this. I don't
> think the data is getting into the RRD (which is why the graphs are
> flat!). My experience was as follows:
>
> # /usr/bin/php /opt/zendto/sbin/rrdInit.php
> /opt/zendto/config/preferences.php
>
> Initial creation of RRD file (start date of 2011-09-07)
>
> 16
>
> /usr/bin/rrdtool update /var/zendto/rrd/zendto.rrd
> 1315436400:1:1:2926562.0
>
> 17
>
> /usr/bin/rrdtool update /var/zendto/rrd/zendto.rrd 1316214000:1:1:11.9
>
> Which looks OK, although on closer inspection I think the dates may be
> suspect. What's actually shown in the Outbox is:
>
> Claim ID Sender
> Recipient Size Created
>
> daWQaXD7S2bMGMfK ROGERS Richard, Staffordshire
> University staff (xxxxxx at staffs.ac.uk <mailto:xxxxxx at staffs.ac.uk>)
> RMR <richard at xxxxxxxxx.uk> <mailto:richard at xxxxxxxxx.uk>
>
>
>
> 11.9 KB 16 Sep 2011 02:14:53 PM
>
> GJYBiNngywQJjXiR ROGERS Richard,
> Staffordshire University staff (xxxxxx at staffs.ac.uk
> <mailto:xxxxxx at staffs.ac.uk>) RMR <richard at xxxxxxxxx.uk>
> <mailto:richard at xxxxxxxxx.uk>
>
>
>
> 2.8 GB 07 Sep 2011 07:42:47 PM
>
> Now an rrdtool dump (excerpt) shows:
>
> <!-- 2011-08-31 01:00:00 BST / 1314748800 -->
> <row><v>NaN</v><v>NaN</v><v>NaN</v><v>NaN</v></row>
>
> <!-- 2011-09-01 01:00:00 BST / 1314835200 -->
> <row><v>NaN</v><v>NaN</v><v>NaN</v><v>NaN</v></row>
>
> <!-- 2011-09-02 01:00:00 BST / 1314921600 -->
> <row><v>NaN</v><v>NaN</v><v>NaN</v><v>NaN</v></row>
>
> <!-- 2011-09-03 01:00:00 BST / 1315008000 -->
> <row><v>NaN</v><v>NaN</v><v>NaN</v><v>NaN</v></row>
>
> <!-- 2011-09-04 01:00:00 BST / 1315094400 -->
> <row><v>NaN</v><v>NaN</v><v>NaN</v><v>NaN</v></row>
>
> <!-- 2011-09-05 01:00:00 BST / 1315180800 -->
> <row><v>NaN</v><v>NaN</v><v>NaN</v><v>NaN</v></row>
>
> <!-- 2011-09-06 01:00:00 BST / 1315267200 -->
> <row><v>NaN</v><v>NaN</v><v>NaN</v><v>NaN</v></row>
>
> <!-- 2011-09-07 01:00:00 BST / 1315353600 -->
> <row><v>NaN</v><v>NaN</v><v>NaN</v><v>NaN</v></row>
>
> <!-- 2011-09-08 01:00:00 BST / 1315440000 -->
> <row><v>NaN</v><v>NaN</v><v>NaN</v><v>NaN</v></row>
>
> <!-- 2011-09-09 01:00:00 BST / 1315526400 -->
> <row><v>NaN</v><v>NaN</v><v>NaN</v><v>NaN</v></row>
>
> <!-- 2011-09-10 01:00:00 BST / 1315612800 -->
> <row><v>NaN</v><v>NaN</v><v>NaN</v><v>NaN</v></row>
>
> <!-- 2011-09-11 01:00:00 BST / 1315699200 -->
> <row><v>NaN</v><v>NaN</v><v>NaN</v><v>NaN</v></row>
>
> <!-- 2011-09-12 01:00:00 BST / 1315785600 -->
> <row><v>NaN</v><v>NaN</v><v>NaN</v><v>NaN</v></row>
>
> <!-- 2011-09-13 01:00:00 BST / 1315872000 -->
> <row><v>NaN</v><v>NaN</v><v>NaN</v><v>NaN</v></row>
>
> <!-- 2011-09-14 01:00:00 BST / 1315958400 -->
> <row><v>NaN</v><v>NaN</v><v>NaN</v><v>NaN</v></row>
>
> <!-- 2011-09-15 01:00:00 BST / 1316044800 -->
> <row><v>NaN</v><v>NaN</v><v>NaN</v><v>NaN</v></row>
>
> <!-- 2011-09-16 01:00:00 BST / 1316131200 -->
> <row><v>NaN</v><v>NaN</v><v>NaN</v><v>NaN</v></row>
>
> </database>
>
> It ends after 16/9 (because the last dropoff was on the 16^th ? -- the
> time stamp on the file is "now" and the time of last update at the top
> is "<lastupdate>1316214000</lastupdate> <!-- 2011-09-17 00:00:00 BST -->")
>
> Hope this helps in further diagnosis!
>
> ZendTo 4.05 on CentOS VM.
>
> Regards
>
> Richard
>
> *From:*zendto-bounces at zend.to <mailto:zendto-bounces at zend.to>
> [mailto:zendto-bounces at zend.to] *On Behalf Of *--[ UxBoD ]--
> *Sent:* 21 September 2011 08:24
> *To:* ZendTo Users
> *Subject:* [ZendTo] Re: rrd fixes
>
> Hmm, graphs are all empty :(
> --
> Thanks, Phil
>
> ------------------------------------------------------------------------
>
> *From: *"Jules" <Jules at zend.to> <mailto:Jules at zend.to>
> *To: *"ZendTo Users" <zendto at zend.to> <mailto:zendto at zend.to>
> *Sent: *Tuesday, 20 September, 2011 9:35:05 PM
> *Subject: *[ZendTo] Re: rrd fixes
>
> To save you poor busy folks a load of patching, I might just release a
> new version of ZendTo tomorrow. It's the first in a month or so, and
> it will iron out these niggles for you.
>
> There won't be any new preferences.php settings or database changes,
> though there are a few *.tpl template changes. Should be a painless
> upgrade (he says, cursing it forever :-)
>
> Cheers,
> Jules.
>
> On 20/09/2011 21:14, Jules wrote:
>
> I've found and fixed the problems you've all been having with
> rrdInit.php and rrdUpdate.php.
>
> Attached are new copies of
> /opt/zendto/sbin/rrdInit.php
> /opt/zendto/sbin/rrdUpdate.php
> /opt/zendto/lib/MySQL.php
> /opt/zendto/lib/SQLite.php
> You will probably need to delete your RRD data file
> (/var/zendto/rrd/zendto.rrd by default) first, and then copy in the 4
> files. Then run
> /opt/zendto/sbin/rrdInit.php /opt/zendto/config/preferences.php
> /opt/zendto/sbin/rrdUpdate.php /opt/zendto/config/preferences.php
>
> The rrdInit script creates the data file if necessary and updates it
> with all the latest stats.
> The rrdUpdate script just creates all the graphs.
>
> Sorry it's taken me so long to work out the solution to this!
>
> Jules
>
>
>
>
>
> _______________________________________________
> ZendTo mailing list
> ZendTo at zend.to <mailto:ZendTo at zend.to>
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>
> Jules
>
> --
> Julian Field MEng CITP CEng
> www.Zend.To <http://www.Zend.To>
>
> Follow me at twitter.com/JulesFM
> PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
>
> 'Teach a man to reason, and he will think for a lifetime.' - Phil Plait
> 'All programs have a desire to be useful' - Tron, 1982
>
>
> _______________________________________________
> ZendTo mailing list
> ZendTo at zend.to <mailto:ZendTo at zend.to>
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>
>
>
>
>
> _______________________________________________
> ZendTo mailing list
> ZendTo at zend.to <mailto:ZendTo at zend.to>
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>
>
>
>
> Jules
>
> --
> Julian Field MEng CITP CEng
> www.Zend.To <http://www.Zend.To>
>
> Follow me at twitter.com/JulesFM
> PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
>
> 'It's okay to live without all the answers' - Charlie Eppes, 2011
> 'All programs have a desire to be useful' - Tron, 1982
> 'That is the land of lost content,
> I see it shining plain,
> The happy highways where I went,
> And cannot come again.' - A.E. Houseman
>
>
>
>
> _______________________________________________
> ZendTo mailing list
> ZendTo at zend.to <mailto:ZendTo at zend.to>
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
>
>
>
> Jules
>
> --
> Julian Field MEng CITP CEng
> www.Zend.To <http://www.Zend.To>
>
> Follow me at twitter.com/JulesFM
> PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
>
> 'It's okay to live without all the answers' - Charlie Eppes, 2011
> 'All programs have a desire to be useful' - Tron, 1982
> 'That is the land of lost content,
> I see it shining plain,
> The happy highways where I went,
> And cannot come again.' - A.E. Houseman
>
>
> _______________________________________________
> ZendTo mailing list
> ZendTo at zend.to
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto
Jules
--
Julian Field MEng CITP CEng
www.Zend.To
Follow me at twitter.com/JulesFM
PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
'It's okay to live without all the answers' - Charlie Eppes, 2011
'All programs have a desire to be useful' - Tron, 1982
'That is the land of lost content,
I see it shining plain,
The happy highways where I went,
And cannot come again.' - A.E. Houseman
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/zendto/attachments/20110923/4ac0c127/attachment-0001.html
More information about the ZendTo
mailing list