[OpenSIPS-Users] ACC CDR
M.Khaled W Chehab
kchehab at icucall.com
Thu Apr 4 16:17:09 CEST 2013
Hi Bogdan,
mysql> select * from acc limit 1 ;
+----+--------+----------+-------------------+------------------+----------+
------------+---------------------+--------+----------+------------+--------
---+---------------------+----------------------------+---------------------
-------------+---------+-----+-----------------+--------------+-----------+-
--------+--------------+----------------+---------+-------------------------
----------+-----+------+------+-------+-----------+------+--------------+---
--------+-------------------+---------------------+---------------+
| id | method | from_tag | to_tag | callid | sip_code |
sip_reason | time | cdr_id | duration | durationms |
setuptime | created | from_uri | to_uri
| gateway | ani | dest | source | callsetup | leg_src |
leg_dst | via | timeout | uaA
| uaB | uuid | pdd | rate | cusid | cost | dstname | dstprefix |
trunkdialednumber | timestamp | failure_count |
+----+--------+----------+-------------------+------------------+----------+
------------+---------------------+--------+----------+------------+--------
---+---------------------+----------------------------+---------------------
-------------+---------+-----+-----------------+--------------+-----------+-
--------+--------------+----------------+---------+-------------------------
----------+-----+------+------+-------+-----------+------+--------------+---
--------+-------------------+---------------------+---------------+
| 1 | INVITE | 1a5a4937 | 3573387689-983960 | 1c11f97fbb29600c | 200 |
OK | 2013-03-27 15:41:42 | 1 | 19 | 18782 |
15 | 2013-03-27 15:41:27 | <sip:ew at 77.42.241.66:8036> |
sip:777201001168108 at 5.104.224.33 | Provider1 | ew | 777201001168108 |
77.42.241.66 | NULL | | 201001168108 | 74.201.101.201 |
| eyeBeam release 3007n stamp 17816 | | NULL | | 0.031 | 100000020
| NULL | Egypt-Mobile | 777201 | 201001168108 | 2013-03-27 15:42:01
| 0 |
+----+--------+----------+-------------------+------------------+----------+
------------+---------------------+--------+----------+------------+--------
---+---------------------+----------------------------+---------------------
-------------+---------+-----+-----------------+--------------+-----------+-
--------+--------------+----------------+---------+-------------------------
----------+-----+------+------+-------+-----------+------+--------------+---
--------+-------------------+---------------------+---------------+
mysql> select * from cdrs limit 1 ;
+--------+---------------------+---------------------+----------+-----------
-+------------------+--------------+-------------------+--------------------
-+-----+-----------------+--------------+----------------+----------+-----+-
--------+---------+------------+-----------+--------------+-----------+-----
-------+---------------+---------+-------------+
| cdr_id | call_start_time | call_end_time | duration | durationms
| sip_call_id | sip_from_tag | sip_to_tag | created
| ani | dest | source | via | sip_code | pdd |
bye_leg | rate | cost | cusid | dstname | dstprefix |
sip_reason | customer_name | gateway | accduration |
+--------+---------------------+---------------------+----------+-----------
-+------------------+--------------+-------------------+--------------------
-+-----+-----------------+--------------+----------------+----------+-----+-
--------+---------+------------+-----------+--------------+-----------+-----
-------+---------------+---------+-------------+
There is a difference in field as I am not getting any error while debugging
using debug level 4 , moreover I was running store procedure before to fill
cdrs table ,now I am trying to let opensips write cdr directly to cdrs
table .
Regards
From: Bogdan-Andrei Iancu [mailto:bogdan at opensips.org]
Sent: Thursday, April 04, 2013 4:11 PM
To: M.Khaled W Chehab
Cc: 'OpenSIPS users mailling list'
Subject: Re: [OpenSIPS-Users] ACC CDR
Could you post the record from DB ?
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
On 04/04/2013 03:36 PM, M.Khaled W Chehab wrote:
Yes I can get the records in acc table
Regards
From: Bogdan-Andrei Iancu [mailto:bogdan at opensips.org]
Sent: Thursday, April 04, 2013 3:16 PM
To: M.Khaled W Chehab
Cc: 'OpenSIPS users mailling list'
Subject: Re: [OpenSIPS-Users] ACC CDR
And you get no record in the "ACC" table ?
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
On 04/04/2013 03:13 PM, M.Khaled W Chehab wrote:
Hi Bogdan,
Already dialog module loaded ,
$var(a) = "udp:"+$avp(termip)+":5060";
$fs = $var(a) ;
setflag(1); # do accounting
setflag(2); #Missed calls
#setflag(3); #transaction falis
setflag(4); #CDR flag
# create dialog with timeout
if ( !create_dialog("B") ) {
send_reply("500","Internal Server Error");
exit;
}
$dlg_val("customerid") = $avp(Cusid);
engage_media_proxy();
topology_hiding();
please advice
regards
From: Bogdan-Andrei Iancu [mailto:bogdan at opensips.org]
Sent: Thursday, April 04, 2013 3:10 PM
To: M.Khaled W Chehab
Cc: 'OpenSIPS users mailling list'
Subject: Re: [OpenSIPS-Users] ACC CDR
Hi Khaled,
Load the "dialog" module too and do "create_dialog()" for the initial
INVITEs.
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
On 04/03/2013 06:48 PM, M.Khaled W Chehab wrote:
Hello,
I already add the below config to my script and no call can be found in
cdrs table
modparam("acc", "db_flag", 1)
modparam("acc", "db_missed_flag", 2)
modparam("acc", "log_missed_flag", 2)
modparam("acc", "failed_transaction_flag", 3)
modparam("acc", "cdr_flag", 4)
if (!has_totag() &&is_method("INVITE")) {
setflag(1); # do accounting
setflag(2); #Missed calls
#setflag(3); #transaction falis
setflag(4); #CDR flag
whats missing ?
Regards
Khaled
From: Bogdan-Andrei Iancu [mailto:bogdan at opensips.org]
Sent: Wednesday, April 03, 2013 6:25 PM
To: OpenSIPS users mailling list
Cc: M.Khaled W Chehab
Subject: Re: [OpenSIPS-Users] ACC CDR
Hello,
Use the ACC module together with DIALOG module and set the cdr_flag option
in ACC (see
http://www.opensips.org/html/docs/modules/1.9.x/acc.html#id294245) - you
need to set this flag at at INVITE time only (plus one of the acc flags).
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
On 04/03/2013 04:55 PM, M.Khaled W Chehab wrote:
Dears ,
Is there a way to right directly to CDRS table in mysql .
Regards
_______________________________________________
Users mailing list
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130404/f6f11a90/attachment-0001.htm>
More information about the Users
mailing list