Ryan,
One more question.
Currently i have some db extra attrs setup. My acc table looks like
following:
+------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| method | char(16) | NO | | | |
| from_tag | char(64) | NO | | | |
| to_tag | char(64) | NO | | | |
| callid | char(64) | NO | MUL | | |
| sip_code | char(3) | NO | | | |
| sip_reason | char(32) | NO | | | |
| time | datetime | NO | | NULL | |
| duration | int(11) unsigned | NO | | 0 | |
| setuptime | int(11) unsigned | NO | | 0 | |
| SourceAddr | char(30) | NO | | NULL | |
| DestAddr | char(30) | NO | | NULL | |
| Anum | char(30) | NO | | NULL | |
| Bnum_rU | char(30) | NO | | NULL | |
| Bnum_tU | char(30) | NO | | NULL | |
| created | datetime | YES | | NULL | |
+------------+------------------+------+-----+---------+----------------+
modparam("acc", "db_extra", "SourceAddr=$si; DestAddr=$rd; Anum=$fU;
Bnum_rU=$rU; Bnum_tU=$tU")
Now using additional data like $time will give me the exact moment the call
is ended, nothing more, am i right?
To have detailed call duration i need to know exact answer and disconnect
timestamps.
Btw: i am using OpenSIPS (1.9.1-notls (x86_64/linux))
Thanks,
Mac
2014-04-10 22:03 GMT+02:00 Ryan Mitchell <[email protected]>:
> Using db_extra to stuff custom data into your acc table, use the $time var
> with a format such as "%s.%N" or similar.
>
> Or, as you suggested, do it on the database level with a trigger or
> auto-update column.
>
>
>
> On Thu, Apr 10, 2014 at 10:01 AM, Maciej Bylica <[email protected]> wrote:
>
>> Hello
>>
>> I just want to know how to achieve miliseconds precision for accounting
>> module.
>> This is quite important while trying to sum up total traffic duration
>> with the accuracy of hundred of ms.
>>
>> As i see there is no rounding feature implemented as well, but heaving ms
>> precision it could be done directly on DB level.
>>
>> Could somebody give me a hand.
>>
>> Thanks in advanced
>> Mac
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> [email protected]
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>
>
> --
> Ryan Mitchell <[email protected]>
> Telecom Logic, LLC
>
>
> _______________________________________________
> Users mailing list
> [email protected]
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
