On 1/30/13 6:57 PM, Scott, Matt wrote:
Thanks for responding, yes I think I have all that ready.
Not sure if accdb_comment was needed, but I enabled.
accdb_comment is not needed, but it is fine because it is defined after
is used in an #!ifdef, because it would through errors.
We deleted the tables, and re-created based on tutorial.
MySql is running, as I'm using dispatcher in db mode.
Any other thoughts?
Do you get records in acc table? Any error messages in the syslog?
Cheers,
Daniel
loadmodule "acc.so"
#### ---- enabling accountingdb here by matt ---
#!define WITH_ACCDB
#!define WITH_ACCDB_COMMENT
# ----- acc params -----
/* what special events should be accounted ? */
modparam("acc", "early_media", 0)
modparam("acc", "report_ack", 0)
modparam("acc", "report_cancels", 0)
/* by default ww do not adjust the direct of the sequential requests.
if you enable this parameter, be sure the enable "append_fromtag"
in "rr" module */
modparam("acc", "detect_direction", 0)
/* account triggers (flags) */
modparam("acc", "log_flag", FLT_ACC)
modparam("acc", "log_missed_flag", FLT_ACCMISSED)
modparam("acc", "log_extra",
"src_user=$fU;src_domain=$fd;src_ip=$si;"
"dst_ouser=$tU;dst_user=$rU;dst_domain=$rd")
modparam("acc", "failed_transaction_flag", FLT_ACCFAILED)
/* enhanced DB accounting */
#!ifdef WITH_ACCDB
modparam("acc", "db_flag", FLT_ACC)
modparam("acc", "db_missed_flag", FLT_ACCMISSED)
modparam("acc", "db_url", DBURL)
modparam("acc", "db_extra",
"src_user=$fU;src_domain=$fd;src_ip=$si;"
"dst_ouser=$tU;dst_user=$rU;dst_domain=$rd")
#!endif
Matt Scott
303-963-2990 | Telephony Administrator
-----Original Message-----
From: sr-users-boun...@lists.sip-router.org
[mailto:sr-users-boun...@lists.sip-router.org] On Behalf Of Daniel-Constantin
Mierla
Sent: Wednesday, January 30, 2013 2:18 AM
To: SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users
Mailing List
Subject: Re: [SR-Users] siremis CDR problem
Have you enabled the acc db accounting in kamailio config file?
Cheers,
Daniel
On 1/29/13 8:28 PM, Scott, Matt wrote:
Anybody have a working model?
I am following here, but I can't load kam with this code.
http://kb.asipto.com/siremis:install32x:accounting
# ======================================================
# Populate CDRs Table of Siremis
# ======================================================
route[CDRS] {
sql_query("cb","call kamailio_cdrs()","rb");
sql_query("cb","call kamailio_rating('default')","rb");
Looking at my table they are empty.
Matt Scott
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, April 16-17, 2013, Berlin
- http://conference.kamailio.com -
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
