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