<html><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><meta name="Generator" content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML con formato previo Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Texto de globo Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
color:black;}
span.EstiloCorreo17
{mso-style-type:personal;
font-family:Consolas;
color:windowtext;}
span.HTMLconformatoprevioCar
{mso-style-name:"HTML con formato previo Car";
mso-style-priority:99;
mso-style-link:"HTML con formato previo";
font-family:Consolas;
color:black;}
span.EstiloCorreo20
{mso-style-type:personal-reply;
font-family:Consolas;
color:#1F497D;}
span.TextodegloboCar
{mso-style-name:"Texto de globo Car";
mso-style-priority:99;
mso-style-link:"Texto de globo";
font-family:"Tahoma","sans-serif";
color:black;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
{page:WordSection1;}
--></style></head><body bgcolor="white" lang="ES-CL" link="blue" vlink="purple"><div class="WordSection1"><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">Hello Ramona.</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">It is odd. I have created a table in my openser database called “statistics”. The time_stamp column stores the $Ts from Kamailio.</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">These are my last three entries :</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">mysql> select id,time_stamp,ul_users,fwd_requests from statistics ORDER by id DESC limit 3; </span></p><p class="MsoNormal">
<span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">+------+------------+----------+--------------+</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">| id | time_stamp | ul_users | fwd_requests |</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">+------+------------+----------+--------------+</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">| 2002 | 1299098096 | 1 | 0 |</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">| 2001 | 1299097646 | 1 | 18 |</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">| 2000 | 1299097346 | 1 | 18 |</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">+------+------------+----------+--------------+</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">3 rows in set (0.00 sec)</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> </span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">If I convert the last three timestamps I get :</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> </span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">1299098096 </span><span lang="EN-US" style="font-size:10.0pt;font-family:Wingdings;color:#1F497D">à</span><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> Wed, 02 Mar 2011 20:22:26 GMT</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">1299097646 </span><span lang="EN-US" style="font-size:10.0pt;font-family:Wingdings;color:#1F497D">à</span><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> Wed, 02 Mar 2011 20:27:26 GMT</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">1299098096 </span><span lang="EN-US" style="font-size:10.0pt;font-family:Wingdings;color:#1F497D">à</span><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> Wed, 02 Mar 2011 20:34:56 GMT</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> </span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">But in the charts I keeps seeing the last entry as : 12:34:56 PM.</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> </span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:Consolas;color:#1F497D"><img width="646" height="308" id="Imagen_x0020_2" src="cid:image001.png@01CBD901.4E3741F0"></span><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> </span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">My time_stamp column is created as INT(). Could that be the problem?</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">+--------------------+---------+------+-----+---------+----------------+</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">| Field | Type | Null | Key | Default | Extra |</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">+--------------------+---------+------+-----+---------+----------------+</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">| id | int(11) | NO | PRI | NULL | auto_increment |</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">| time_stamp | int(11) | YES | | NULL | |</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">+--------------------+---------+------+-----+---------+----------------+</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> </span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">Hope you can help me.</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">Thanks in advance,</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">Regards,</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> </span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">Ricardo Martinez.-</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> </span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> </span></p>
<div><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class="MsoNormal"><b><span lang="ES" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext">De:</span></b><span lang="ES" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext"> Elena-Ramona Modroiu [mailto:<a href="mailto:ramona@asipto.com">ramona@asipto.com</a>] <br>
<b>Enviado el:</b> miércoles, 02 de marzo de 2011 15:48<br><b>Para:</b> Ricardo Martinez<br><b>CC:</b> <a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br><b>Asunto:</b> Re: [SR-Users] Question about time display in SIREMIS 2.0</span></p>
</div></div><p class="MsoNormal"> </p><p class="MsoNormal">Hi,<br><br>for charts siremis uses the date() function to convert from unix timestamp that is written by kamailio to the displayed date. It might be possible to adjust the timezone from php.ini.<br>
<br>Regards,<br>Ramona<br><br>On 2/28/11 10:30 PM, Ricardo Martinez wrote: </p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">Hello.</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">Is there a way to adjust the timezone to display the charts and the logs in the SIREMIS 2.0? I have my linux machine with my local timezone, but the display in the charts and the logs are not in synch with my local time.</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">Thanks in advance.</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas"> </span></p><p class="MsoNormal">
<span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">Regards,</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas"> </span></p><p class="MsoNormal" style="margin-top:3.0pt">
<span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">Ricardo Martinez.-</span></p><p class="MsoNormal"> </p><pre> </pre><pre> </pre><pre>_______________________________________________</pre><pre>SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list</pre>
<pre><a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a></pre><pre><a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a></pre>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif""> </span></p></div></body></html>