Re: [SR-Users] Question about time display in SIREMIS 2.0

Hello. Can someone help me here?. I’m still unable to get the charts working ok. Maybe it is a bug? Thanks Ricardo.- *De:* Ricardo Martinez [mailto:rmartinez@redvoiss.net] *Enviado el:* miércoles, 02 de marzo de 2011 17:47 *Para:* 'ramona(a)asipto.com' *CC:* 'sr-users(a)lists.sip-router.org' *Asunto:* RE: [SR-Users] Question about time display in SIREMIS 2.0 Hello Ramona. It is odd. I have created a table in my openser database called “statistics”. The time_stamp column stores the $Ts from Kamailio. These are my last three entries : mysql> select id,time_stamp,ul_users,fwd_requests from statistics ORDER by id DESC limit 3; +------+------------+----------+--------------+ | id | time_stamp | ul_users | fwd_requests | +------+------------+----------+--------------+ | 2002 | 1299098096 | 1 | 0 | | 2001 | 1299097646 | 1 | 18 | | 2000 | 1299097346 | 1 | 18 | +------+------------+----------+--------------+ 3 rows in set (0.00 sec) If I convert the last three timestamps I get : 1299098096 à Wed, 02 Mar 2011 20:22:26 GMT 1299097646 à Wed, 02 Mar 2011 20:27:26 GMT 1299098096 à Wed, 02 Mar 2011 20:34:56 GMT But in the charts I keeps seeing the last entry as : 12:34:56 PM. My time_stamp column is created as INT(). Could that be the problem? +--------------------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+---------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | time_stamp | int(11) | YES | | NULL | | +--------------------+---------+------+-----+---------+----------------+ Hope you can help me. Thanks in advance, Regards, Ricardo Martinez.- *De:* Elena-Ramona Modroiu [mailto:ramona@asipto.com] *Enviado el:* miércoles, 02 de marzo de 2011 15:48 *Para:* Ricardo Martinez *CC:* sr-users(a)lists.sip-router.org *Asunto:* Re: [SR-Users] Question about time display in SIREMIS 2.0 Hi, 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. Regards, Ramona On 2/28/11 10:30 PM, Ricardo Martinez wrote: Hello. 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. Thanks in advance. Regards, Ricardo Martinez.- _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users