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:[email protected]:8036> |
sip:[email protected] | 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:[email protected]]
*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:[email protected]]
*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:[email protected]]
*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:[email protected]]
*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
[email protected] <mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
