Hi,
Thanks for the reply.
My problem is solved by changing value of db_localtime in acc module and recompiling it.
Manoj.
Quoting Jan Janak jan@iptel.org:
Hello,
SER does know the timezone of the caller, thus the timestamp is either in the timezone of the machine running SER or timezone of the MySQL.
Configuring MySQL timezone can be a bit tricky, please consult the MySQL documentation.
Jan.
mkumar@mantragroup.com wrote:
Hi All,
I was able to install SER and able to get all the call details to the Mysql DB. But my problem is with the time of timestamp recorded, it is not recorded according to time on Server where my DB is located. The time recorded is according to timezone of the caller and so because of this when I use NOW() of Mysql and get the calls I miss the calls dialled from timezones ahead of NOW() time on Mysql. I think while inserting call details in to DB the acc.so module is using some other thing other than using NOW(). I do not know where to change this, please tell me where can I modify that query and get a common timezone for all the users so that billing will not be a problem for me.
Thanks, Manoj.
Serhelp mailing list serhelp@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serhelp