[Spce-user] System Statistics stopped working

Fri Feb 26 18:16:06 EST 2016

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/20160226/70b5db98/attachment-0001.html>