29 Jul
2013
29 Jul
'13
9:23 a.m.
Dear All,
Greetings,
I am working Kamailio (4.0.1) server with GUI package Siremis (4.0) of it.
I was successful in get through Calls and SMS features in our VoIP phones
using this kamailio sever. And now i am trying to get GUI for my kamailio
server with SIREMIS (4.0.0) package. Installation was good as i am getting
subscribers list in GUI which are in MySQL database. As it comes accounting
section. i am Failed to get the CDR list when the call session between two
clients have been done. I gone through Acc module's documentation and
followed the following links to set up the accounting in GUI :
http://kb.asipto.com/siremis:install40x:accounting.
And i read this is description in accounting module documentation :
'Note that CDR generation does not involve any kind of database storage
(yet). In order to persist the CDRs into a database you will have to set up
an exterior process (i.e., a script living outside of Kamailio) and
implement the storage task yourself'.
So what does it mean ? should i have to install external process like CDR
tool and Freeradius?
Or is there any other way to get the CDR related information in GUI using
database backend.
Please find below my kamailio configuration file.
By the way CDR data is logged to syslog fine, but i dont know where is
wrong for database backend.
Any help will greatly appreciate.
Regards,
Nandini
29 Jul
29 Jul
2:45 p.m.
Hello,
On 7/29/13 8:23 AM, Nandini madhu wrote:
Dear All,
Greetings,
I am working Kamailio (4.0.1) server with GUI package Siremis (4.0) of
it. I was successful in get through Calls and SMS features in our VoIP
phones using this kamailio sever. And now i am trying to get GUI for
my kamailio server with SIREMIS (4.0.0) package. Installation was good
as i am getting subscribers list in GUI which are in MySQL database.
As it comes accounting section. i am Failed to get the CDR list when
the call session between two clients have been done. I gone through
Acc module's documentation and followed the following links to set up
the accounting in GUI :
http://kb.asipto.com/siremis:install40x:accounting.
And i read this is description in accounting module documentation :
'Note that CDR generation does not involve any kind of database
storage (yet). In order to persist the CDRs into a database you will
have to set up an exterior process (i.e., a script living outside of
Kamailio) and implement the storage task yourself'.
So what does it mean ? should i have to install external process like
CDR tool and Freeradius?
Or is there any other way to get the CDR related information in GUI
using database backend.
Please find below my kamailio configuration file.
By the way CDR data is logged to syslog fine, but i dont know where is
wrong for database backend.
siremis creates cdrs table and installs a stored
procedure that has to
executed periodically. It does not relate to the syslog cdrs from acc
module (which rely on dialog module).
Be sure you activated WITH_ACCDB in your config file or watch the syslog
file to see if there are some errors.
Cheers,
Daniel
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
6 Aug
6 Aug
9:06 a.m.
Dear Sir,
Ya i have activated WITH_ACCDB in kamailio cfg file.
Siremis is configured to kamailio DB properly as i am getting accounting
list in the siremis GUI well, but only the CDR data is not getting
reflecting in GUI.
But this CDR data is successfully logging into syslog (see the paragraph
below), but my requirement is to get the CDR data to be reflect in my GUI.
Here below is the CDR data that logged into syslog:
Aug 3 17:36:25 kamailio /usr/local/sbin/kamailio[12391]: INFO: acc
[acc.c:275]: acc_log_request(): ACC: transaction answered:
timestamp=1375531585;method=INVITE;from_tag=170287292812;to_tag=373699520912;call_id=6595ee13-bfec-15a7-ae-4b-00210705d550(a)192.168.2.99;code=200;reason=OK;src=;dst=
Aug 3 17:36:25 kamailio /usr/local/sbin/kamailio[12393]: INFO: acc
[acc.c:275]: acc_log_request(): ACC: request acknowledged:
timestamp=1375531585;method=ACK;from_tag=170287292812;to_tag=373699520912;call_id=6595ee13-bfec-15a7-ae-4b-00210705d550(a)192.168.2.99;code=200;reason=OK;src=;dst=
Aug 3 17:36:29 kamailio /usr/local/sbin/kamailio[12391]: INFO: acc
[acc_cdr.c:192]: write_cdr(): st=1375531585.654; et=1375531588.863;
duration=3.209; src_user=102; src_domain=192.168.2.41; src_ip=192.168.2.99;
dst_ouser=101; dst_user=101; dst_domain=192.168.2.77
And my kamailio.cfg script relating to CDR's is like this:
/* enhanced DB accounting */
#!ifdef WITH_ACCDB
modparam("acc", "db_flag", FLT_ACCDB) /* FLT_ACCDB is 2 */
modparam("acc", "db_missed_flag", FLT_ACCMISSED) /* FLT_ACCMISSED is 3
*/
modparam("acc", "db_url",
mysql://kamailio:kamailiorw@kamailio/kamailio)
#modparam("acc",
"db_extra","src_user=$fU;src_domain=$fd;src_ip=$si;""dst_ouser=$tU;dst_user=
$rU;dst_domain=$rd;""duration=$DLG_lifetime")
#modparam("acc", "db_extra","${cdr_extra}")
modparam("acc",
"db_extra","src_user=$fU;src_domain=$fd;src_ip=$si;""dst_ouser=$tU;dst_user=
$rU;dst_domain=$rd")
modparam("acc", "db_table_acc", "acc")
#modparam("acc", "db_table_acc",
"acc_$time(year)_$time(mon)")
modparam("acc", "db_table_missed_calls", "missed_calls")
modparam("acc", "acc_method_column", "method")
modparam("acc", "acc_from_tag_column", "from_tag")
modparam("acc", "acc_to_tag_column", "to_tag")
modparam("acc", "acc_callid_column", "callid")
modparam("acc", "acc_sip_code_column", "sip_code")
modparam("acc", "acc_sip_reason_column", "sip_reason")
modparam("acc", "acc_time_column", "time")
modparam("acc", "db_insert_mode", 0)
#!endif
# -------- for siremis CDRs -----------
modparam("acc", "cdr_enable", 1)
modparam("acc", "cdr_start_on_confirmed", 1)
modparam("acc", "cdr_facility", "LOG_DAEMON")
#modparam("acc", "cdr_extra",
"c1=$dlg_var(caller);c2=$dlg_var(callee)")
modparam("acc", "cdr_extra",
"src_user=$fU;src_domain=$fd;src_ip=$si;""dst_ouser=$tU;dst_user=$rU;dst_domain=$rd")
modparam("acc", "cdr_start_id", "st")
modparam("acc", "cdr_end_id", "et")
modparam("acc", "cdr_duration_id", "duration")
.
modparam("rtimer", "timer",
"name=cdr;interval=300;mode=1;")
modparam("rtimer", "exec", "timer=cdr;route=2")
modparam("sqlops", "sqlcon",
"ca=>mysql://kamailio:kamailiorw@localhost/kamailio")
modparam("sqlops", "sqlres", "ra")
.
.
# Populate CDRs Table of Siremis
route[2] {
sql_query("ca","call kamailio_cdrs()","ra");
}
Can u guess where i am wrong ? how can i solve this issue ?
And for your notice, in acc module document it is said like this:
'Note that CDR generation does not involve any kind of database storage
(yet). In order to persist the CDRs into a database you will have to set up
an exterior process (i.e., a script living outside of Kamailio) and
implement the storage task yourself'.
What does it mean ? of course 'cdrs' table in kamailio database is empty.
Regards,
Nandini.
--
View this message in context:
http://sip-router.1086192.n5.nabble.com/Kamailio-CDR-issue-tp120287p120444.…
Sent from the Users mailing list archive at Nabble.com.
4126
days inactive
4134
days old
2 comments
3 participants
participants (3)
-
Daniel-Constantin Mierla -
Nandini -
Nandini madhu