[Spce-user] System Statistics stopped working

[Marco Teixeira]

Hi Alex,

Will try your pointers.

For the record, i did:
- stop all /etc/init.d/ngcp* services
- stop /etc/init.d/mysql
- change timezone
- reboot

I did see that accounting stores epoch (good architectural decision) rather
then date.
Would you say that this process is somewhat safe ?

---
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/20151019/ff095b01/attachment-0001.html>