[Spce-user] System Statistics stopped working

Wed Mar 2 07:34:42 EST 2016

Anyone a sipwise please ?
I think this is a defect. One cannot have the statistics to stop working
just because of timezone change...

---
Marco
---

On Mon, Feb 29, 2016 at 3:20 PM, Marco Teixeira <admin at marcoteixeira.com>
wrote:

> 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/mailman/private/spce-user_lists.sipwise.com/attachments/20160302/a6c17b40/attachment.html>