[Serusers] Re: [Serhelp] Problem with SER accounting, Please help

[mkumar at mantragroup.com]

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 at 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 at 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 at lists.iptel.org
>> http://lists.iptel.org/mailman/listinfo/serhelp
>>
>
>