[SR-Users] siremis CDR problem

[Daniel-Constantin Mierla]

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-bounces at lists.sip-router.org [mailto:sr-users-bounces at 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 at 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 -