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:mico...@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:mico...@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-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
