23 Feb
2006
23 Feb
'06
2:31 p.m.
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(a)iptel.org>rg>:
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(a)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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serhelp