[Kamailio-Users] openser CDR Diversion calls

[Ilya Pichugin]

Hi all!

I'm new in openSER and I'm trying to get correct CDRs when the call is forwarded on busy,
noanswer and uncond., but i have some troubles :(


I use accounting flags by acc module and radius - so, I can get cdrs from
acc table or raddact table

When I do any type of FWD call by AVP module, for example, A (pstn) ->
B (ser user, fwd to GSM) -> C (GSM) i get cdrs for A -> C, but I want
get cdrs for A - B and B - C

Example:
mysql> SELECT * FROM openser.usr_preferences u;
+----+---------+----------+------------+------------+------+-------------+---------------------+
| id | uuid    | username | domain     | attribute  | type | value       | last_modified       |
+----+---------+----------+------------+------------+------+-------------+---------------------+
| 12 | 3097999 | 3097999  | xx.xxx.com | fwdall     |    0 | 89112820419 | 0000-00-00 00:01:00 |


Make call 8123364000 (pstn) - 3097999 (SERuser fwdall to GSM) - 89112820419 (GSM)

and CDRs from raddact table:

mysql> SELECT  callingstationid,canonicalURI, acctstarttime,acctstoptime, acctsessiontime FROM radacct r where acctstarttime>'2009-04-23' and callingstationid like '8123364000';
+------------------+--------------+---------------------+---------------------+-----------------+
| callingstationid | canonicalURI | acctstarttime       | acctstoptime        | acctsessiontime |
+------------------+--------------+---------------------+---------------------+-----------------+
| 8123364000       | 89112820419  | 2009-04-24 10:29:10 | 2009-04-24 10:29:12 |               2 |
+------------------+--------------+---------------------+---------------------+-----------------+


from acc table:

mysql> SELECT id,method,sip_code,sip_reason,time,src_user,dst_user FROM openser.acc a;
+------+--------+----------+------------+---------------------+------------+-------------+
| id   | method | sip_code | sip_reason | time                | src_user   | dst_user    |
+------+--------+----------+------------+---------------------+------------+-------------+
| 2420 | INVITE | 200      | OK         | 2009-04-24 10:29:10 | 8123364000 | 89112820419 |
| 2421 | ACK    | 200      | OK         | 2009-04-24 10:29:10 | 8123364000 | 89112820419 |
| 2422 | BYE    | 200      | OK         | 2009-04-24 10:29:12 | 3097999    | 8123364000  |
+------+--------+----------+------------+---------------------+------------+-------------+


So, how do you bill diversion calls?
Help, pls.




-- 
Best Regards,
Ilya Pichugin
i.pichugin at ptl.ru