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.-

 

 

 

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@lists.sip-router.org

http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users