Re: [Serusers] session duration accounting

Hi quite a few probs in the config,I cant see you using record_route anywhere which means that your messages will not pass through SER, hence you will never (almost never) see a BYE, oops my mistake, there is a record_route, but you are just doing it on the INVITE, you need to do it for all messages which are not REGISTER, then you have to setflag everywhere, I know this may sound a little vague, but I would suggest downloading the startup config from www.onsip.org, in version 1 they have a very simple setup which will allow you to make IP -IP calls, and then they build from there, so try it out. Iqbal Ryan Pagquil wrote: > Hi Iqbal, > > Ah ok, those queries will only generate the duration of INVITE > to BYE methods data from my database. But how can I get INVITE and > BYE accounted in my ser.cfg? I have this ser.cfg that I made but it > is not running, it gaves me an error (core dumped). Well just want to > consult you on how can I make this ser.cfg to work and account for > INVITE's and BYE's. Like just I said, I'm a very newbie with ser =). > > This is the config file: > > #debug=7 > fork=no > log_stderror=yes > > check_via=no > dns=no > port=5060 > listen=10.0.1.5 > fifo_db_url="mysql://ser:heslo@localhost/ser" > fifo="/tmp/ser_fifo" > > #load needed modules > > loadmodule "/usr/local/lib/ser/modules/mysql.so" > loadmodule "/usr/local/lib/ser/modules/sl.so" > loadmodule "/usr/local/lib/ser/modules/tm.so" > loadmodule "/usr/local/lib/ser/modules/acc.so" > loadmodule "/usr/local/lib/ser/modules/rr.so" > loadmodule "/usr/local/lib/ser/modules/maxfwd.so" > loadmodule "/usr/local/lib/ser/modules/registrar.so" > loadmodule "/usr/local/lib/ser/modules/auth.so" > loadmodule "/usr/local/lib/ser/modules/auth_db.so" > loadmodule "/usr/local/lib/ser/modules/usrloc.so" > > > #parameter settings > > #usr module param > modparam("usrloc", "db_mode", 1) > > #acc module param > modparam("acc", "log_level", 1) > modparam("acc", "log_flag", 1) > modparam("acc", "log_fmt", "mpoft") > modparam("acc", "report_ack", 1) > modparam("acc", "db_url", "mysql://ser:heslo@localhost/ser") > modparam("acc", "db_flag", 2) > modparam("acc", "db_missed_flag", 3) > > #auth_db param mysql authentication active > modparam("auth_db", "calculate_ha1", yes) > modparam("auth_db", "password_column", "password") > > #rr module param > modparam("rr", "enable_full_lr", 1) > > ####routing logic#### > > route{ > > if (!mf_process_maxfwd_header("10")) { > sl_send_reply("483","To many HOPS"); > break; > }; > > if (msg:len >= max_len ) { > sl_send_reply("513","Message too big"); > break; > }; > > if (uri==myself) { > > if (method=="REGISTER") { > > if (!www_authorize("server4all", "subscriber")) { > www_challenge("server4all", "1"); > break; > }; > > save("location"); > break; > }; > > if (method=="INVITE") record_route(); > setflag(1); > }; > > if (!t_relay()) { > sl_reply_error(); > }; > } > > Thanks a lot, > > > Iqbal wrote: > >> put those queries in mysql and it should lookup your acc table >> >> Iqbal >> >> Ryan Pagquil wrote: >> >>> Hi, >>> So the only concept on how will I account for duration is to >>> account for INVITE and BYE methods...BTW, where will I put those >>> queries? Sorry, I'm in a stage of discovering SER.=) >>> >>> Thanks, >>> >>> >>> >>> Java Rockx wrote: >>> >>>> Ryan, >>>> >>>> This MySQL query should do the trick. It joins the acc table to >>>> itself. One side grabs INVITE messages and the other side grabs BYE >>>> messages. >>>> >>>> NOTE: This will not work if you account for re-INVITE messages >>>> because >>>> you will then have multple INVITEs for the same call. >>>> >>>> Regards, >>>> Paul >>>> >>>> SELECT t1.from_uri as orig_number, t1.to_uri as term_number, >>>> TIMEDIFF(t2.time, t1.time) as duration, t1.timestamp as calldate >>>> FROM acc t1, acc t2 WHERE t1.sip_callid = t2.sip_callid AND >>>> ((t1.fromtag = t2.fromtag and t1.totag = t2.totag) OR >>>> (t1.fromtag = t2.totag and t1.totag = t2.fromtag)) AND >>>> t1.sip_method='INVITE' AND >>>> t2.sip_method='BYE' >>>> >>>> On 7/4/05, Iqbal <iqbal(a)gigo.co.uk> wrote: >>>> >>>> >>>>> its records the INVITE and BYE, so fro there you can work out the >>>>> session duration >>>>> >>>>> Iqbal >>>>> >>>>> Ryan Pagquil wrote: >>>>> >>>>> >>>>> >>>>>> guys, >>>>>> just want to ask if i can make ser to account session >>>>>> durations >>>>>> for billing purposes? >>>>>> >>>>>> Thanks, >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Serusers mailing list >>>>> serusers(a)lists.iptel.org >>>>> http://lists.iptel.org/mailman/listinfo/serusers >>>>