[SR-Users] siremis CDR problem

Sat Feb 23 02:21:15 CET 2013

Yay, got it fixed.
I grep'd my logs for ERROR, and finally noticed this.
Added the missing dst_ouser in ACC and missed_calls.

Feb 22 17:02:45 pbr /usr/sbin/kamailio[16623]: ERROR: db_mysql [km_dbase.c:122]: driver error on query: Unknown column 'dst_ouser' in 'field list'
Feb 22 17:02:45 pbr /usr/sbin/kamailio[16623]: ERROR: <core> [db_query.c:210]: error while submitting query
Feb 22 17:02:45 pbr /usr/sbin/kamailio[16623]: ERROR: acc [acc.c:404]: failed to insert into database

Thanks for the help!

Matt Scott

-----Original Message-----
From: Daniel-Constantin Mierla [mailto:miconda at gmail.com] 
Sent: Thursday, February 14, 2013 10:43 AM
To: Scott, Matt; 'SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List'
Subject: Re: [SR-Users] siremis CDR problem

These are the logs for starting up kamailio. What the logs processing 
the invite and the 200 ok reply to it?

Cheers,
Daniel

On 2/13/13 11:24 PM, Scott, Matt wrote:
> No records in acc table.
> I usually grep logs, so I never noticed.
>
> That's not good.
>
> Feb 13 14:17:08 psbcpr002 kamailio: DEBUG: <core> [cfg.y:1772]: loading module acc.so
> Feb 13 14:17:08 psbcpr002 kamailio: DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/lib64/kamailio/modules_k/acc.so>
> Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4525]: DEBUG: <core> [sr_module.c:935]: DEBUG: init_mod: acc
> Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4531]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (1): acc
> Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4532]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (2): acc
> Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4534]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (3): acc
> Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4536]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (4): acc
> Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4537]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (-1): acc
> Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4539]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (-1): acc
> Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4546]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (-4): acc
> Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4545]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (-2): acc
>
> Matt Scott
> 303-963-2990 | Telephony Administrator
>
>
>
>
>
>
>
> -----Original Message-----
> From: Daniel-Constantin Mierla [mailto:miconda at gmail.com]
> Sent: Tuesday, February 12, 2013 2:35 AM
> To: Scott, Matt; 'SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List'
> Subject: Re: [SR-Users] siremis CDR problem
>
>
> 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 -