[Spce-user] System Statistics stopped working

Mon Feb 29 10:20:30 EST 2016

Sorry to bump this up, but i really need to get this working... i imagine
it would be a simple thing to fix. I just don't know where...

On Fri, Feb 26, 2016 at 11:16 PM, Marco Teixeira <admin at marcoteixeira.com>
wrote:

> If i change back to Europe/Vienna, Statistics start displaying again...
> Not even a reboot needed...
> I'm guessing a hardcoded tz_offset variable somewhere on the panel coding
> maybe ...
>
>
> ===
> Current default time zone: 'Europe/Vienna'
> Local time is now:      Sat Feb 27 00:12:48 CET 2016.
> Universal Time is now:  Fri Feb 26 23:12:48 UTC 2016.
> ===
>
>
> On Fri, Feb 26, 2016 at 11:12 PM, Marco Teixeira <admin at marcoteixeira.com>
> wrote:
>
>> Hello,
>>
>> Getting back to this old issue... Back to basics.
>> - I installed a clean 3.8.3. Stats working ok.
>> - Changed default timezone from Europe/Vienna to GMT. Stats stopped
>> working...
>>
>> Followed sugestion of deleting RRD files to allow regeneration...
>>
>> ===
>> root at spce:/var/lib/collectd/rrd# /etc/init.d/collectd stop
>> [ ok ] Stopping statistics collection and monitoring daemon: collectd.
>> root at spce:/var/lib/collectd/rrd# mv spce spce.bak
>> root at spce:/var/lib/collectd/rrd# ls -lap
>> total 12
>> drwxr-xr-x  3 root root 4096 Feb 26 23:10 ./
>> drwxr-xr-x  3 root root 4096 Feb 26 22:20 ../
>> drwxr-xr-x 48 root root 4096 Feb 26 22:30 spce.bak/
>> root at spce:/var/lib/collectd/rrd# /etc/init.d/collectd start
>> [ ok ] Starting statistics collection and monitoring daemon: collectd.
>> root at spce:/var/lib/collectd/rrd# ls -lapt
>> total 16
>> drwxr-xr-x 41 root root 4096 Feb 26 23:10 spce/
>> drwxr-xr-x  4 root root 4096 Feb 26 23:10 ./
>> drwxr-xr-x 48 root root 4096 Feb 26 22:30 spce.bak/
>> drwxr-xr-x  3 root root 4096 Feb 26 22:20 ../
>> root at spce:/var/lib/collectd/rrd#
>> ===
>>
>> Did not work... Any more hints ?
>> Please ?
>>
>>
>> ---
>> Marco
>> ---
>>
>>
>> On Fri, Oct 23, 2015 at 1:59 AM, Marco Teixeira <admin at marcoteixeira.com>
>> wrote:
>>
>>> Hi there,
>>>
>>> As it seems, i didn't catch these on the logs, on first time. Could this
>>> be it ?
>>> ntpd is running ... But i guess this only afects graphing ntp process ...
>>>
>>> === CUT
>>> Oct 23 00:27:09 localhost collectd[21512]: rrdtool plugin: Adjusting
>>> "RandomTimeout" to 0.000 seconds.
>>> Oct 23 00:27:09 localhost collectd[21512]: mysql plugin: Successfully
>>> connected to database <none> at server Localhost via UNIX socket (server
>>> version: 5.5.44-0+deb7u1-log, protocol version: 10)
>>> Oct 23 00:27:09 localhost collectd[21512]: recv(2) failed: Connection
>>> refused
>>> Oct 23 00:27:09 localhost collectd[21512]: ntpd plugin: ntpd_do_query
>>> (REQ_GET_KERNEL) failed with status -1
>>> Oct 23 00:27:09 localhost collectd[21512]: read-function of plugin
>>> `ntpd' failed. Will suspend it for 20 seconds.
>>>
>>>
>>>
>>>
>>> ---
>>> Cumprimentos / Best regards
>>>
>>> Marco
>>> ---
>>>
>>>
>>> On Thu, Oct 22, 2015 at 10:02 PM, Marco Teixeira <
>>> admin at marcoteixeira.com> wrote:
>>>
>>>> Well...
>>>>
>>>> One small corretion for future users getting to this, rrd files in
>>>> mr3.8.3 are on /var/lib/collectd/rrd/ $HOSTNAME
>>>>
>>>> Now, back to the problem in hand:
>>>> - collectd is fine
>>>> - rrd files have current timestamps
>>>> - "rrdtool fetch" works ok
>>>>
>>>> It seems something with graphics generation or saving... took a look at
>>>> the code in /usr/share/ngcp-panel/templates/statistics/lists.tt but
>>>> i'm having dificulties graspping it...
>>>> - there is a line "var tz_offset = [% tz_offset %];". Where does this
>>>> variable come from ? The system ?
>>>> - Are the graphics generated on the fly for display, or are they stored
>>>> somewhere else ?
>>>> - Does nginx have some timezone variable in the confs and not  copying
>>>> from the system ?
>>>>
>>>> thank you for your time...
>>>>
>>>>
>>>> ---
>>>> Cumprimentos / Best regards
>>>>
>>>> Marco
>>>>
>>>>
>>>> On Mon, Oct 19, 2015 at 11:16 AM, Alex Lutay <alutay at sipwise.com>
>>>> wrote:
>>>>
>>>>> Hi Marco,
>>>>>
>>>>> All system statistics are collected by collectd and are stored in RRD
>>>>> files located in /var/lib/collectd/rrd/spce/
>>>>>
>>>>> "Internally, RRDtool uses "seconds since the epoch" to keep track of
>>>>> time. This is the number of seconds since January first, 1970,
>>>>> midnight, UTC. When you are specifying a time in this format, it is UTC
>>>>> time automatically." (c) http://vandenbogaerdt.nl/rrdtool/timezone.php
>>>>>
>>>>> So, you need to check collecd log first to see new values are
>>>>> inserter properly, also you can manually extract RRD data using RRD
>>>>> tool fetch (to check content of RRD file).
>>>>>
>>>>> Finally you can move RRD files and restart collectd to init new
>>>>> statistics files. Then you can manually move old data in new RRD files
>>>>> if necessary.
>>>>>
>>>>> P.S. changing the timezone of server on the fly is not a good idea,
>>>>> AFAIK. As data in MySQL DB (like accounting, CDRs) stored in fields
>>>>> without timezone specified. Also MySQL works in server timezone by
>>>>> default.
>>>>>
>>>>> On 10/18/2015 10:22 PM, Marco Teixeira wrote:
>>>>> > Hello list,
>>>>> >
>>>>> > A couple weeks ago i lost system statistics... The page opens but
>>>>> > doesn't get pasted those loading progress circling dots... All of
>>>>> them,
>>>>> > on any variable i select on the dropdown box.
>>>>> >
>>>>> > I searched around on the logs, and found nothing.
>>>>> > Does anyone have a clue how to fix this ?
>>>>> >
>>>>> > # more /etc/ngcp_version
>>>>> > mr3.8.3
>>>>>
>>>>> --
>>>>> Alex Lutay
>>>>> _______________________________________________
>>>>> Spce-user mailing list
>>>>> Spce-user at lists.sipwise.com
>>>>> https://lists.sipwise.com/listinfo/spce-user
>>>>>
>>>>
>>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20160229/e89f2b86/attachment-0001.html>