Thanks for responding, yes I think I have all that ready.
Not sure if accdb_comment was needed, but I enabled.
We deleted the tables, and re-created based on tutorial.
MySql is running, as I'm using dispatcher in db mode.
Any other thoughts?
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
_______________________________________________
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
