[Serusers] ser-mysql accounting

Java Rockx javarockx at gmail.com
Tue Jun 28 14:17:18 CEST 2005


Szabolcs,

You're correct in at MySQL support is not compiled by default. You need to 
edit <ser-sources>/modules/acc/Makefile and uncomment the MYSQL line. Then 
just do another "make" and it should work.

With the modparam() settings you have all you need to do is setflag(1) 
before calling t_relay() and the message will be written to the acc table in 
MySQL.

I'd recommend getting a copy of the Getting Started document on 
http://onsip.org/ because it fully documents MySQL support.

Regards,
Paul

On 6/28/05, Szabolcs Szasz <sszasz at digicomm.ro> wrote:
> 
> Hi guys!
> It looks like I have not compiled the acc module with database support.
> Can somebody confirm this? How can I do this? If I insert these rows :
> 
> modparam("acc", "db_flag", 1)
> modparam("acc", "db_missed_flag", 1)
> 
> this is the error:
> 
> 0(29943) set_mod_param_regex: parameter <db_flag> not found in module 
> <acc>
> 0(29943) parse error (87,29-30): Can't set module parameter
> 0(29943) set_mod_param_regex: parameter <db_missed_flag> not found in
> module <acc>
> 0(29943) parse error (88,36-37): Can't set module parameter
> ERROR: bad config file (2 errors)
> 
> 
> > Normaly it is ok. And it doesn't work?
> >
> >
> > Szabolcs Szasz a écrit :
> >> OK. Then, how can I define the acc module's parameter to register calls
> >> into the database?
> >> Now I have:
> >>
> >> modparam("acc", "log_level", 1)
> >> modparam("acc", "log_flag", 1 )
> >>
> >> at the module parameters
> >>
> >> and
> >>
> >> setflag(1);
> >>
> >> What have I to do?
> >>
> >>
> >>>but you can have more as one accounting. You're flag numbre must be the
> >>>same as the number defined at the beggining (module's paramters)
> >>>
> >>>Szabolcs Szasz a écrit :
> >>>
> >>>> Yes, I do. I consider that this line of log is caused by the
> >>>>"setflag()"
> >>>>command : (ACC: transaction answered: method=INVITE,), or not???
> >>>>
> >>>>
> >>>>
> >>>>>Do you use the command "setflag()" ?
> >>>>>
> >>>>>Szabolcs Szasz a écrit :
> >>>>>
> >>>>>
> >>>>>>Hello
> >>>>>>
> >>>>>>I have installed SER on my redhat box. I have a problem with
> >>>>>> ser-mysql
> >>>>>>accounting. In the log is apearing the acc information, but it
> >>>>>> doesn't
> >>>>>>write into the mysql database? It looks like this when I make a call
> >>>>>>from
> >>>>>>506029 to 506030 :
> >>>>>>
> >>>>>>0(24195) -------------------------------------------
> >>>>>>0(24195) entering route[1] - relaying SIP message
> >>>>>>0(24195) relaying message ...
> >>>>>>0(24195) ACC: transaction answered: method=INVITE,
> >>>>>>i-uri=sip:506030 at 10.1.10.10:5060;user=phone,
> >>>>>>o-uri=sip:506030 at 10.1.10.105:5060,
> >>>>>>call_id=58dcd4-a010a68-13c4-119d-44d0f9-247 at 10.1.10.10,
> >>>>>>from=<sip:506029 at 10.1.10.10> ;tag=a010a68-13c4-119d-44d0f9-3b9d,
> >>>>>>code=200
> >>>>>>0(24195) -------------------------------------------
> >>>>>>0(24195) entering main loop
> >>>>>>0(24195) ACK message received
> >>>>>>0(24195) -------------------------------------------
> >>>>>>0(24195) entering route[1] - relaying SIP message
> >>>>>>0(24195) relaying message ...
> >>>>>>0(24195) ACC: request acknowledged: method=ACK,
> >>>>>>i-uri=sip:506030 at 10.1.10.105:5060, o-uri=sip:506030 at 10.1.10.105
> :5060,
> >>>>>>call_id=58dcd4-a010a68-13c4-119d-44d0f9-247 at 10.1.10.10,
> >>>>>>from=<sip:506029 at 10.1.10.10> ;tag=a010a68-13c4-119d-44d0f9-3b9d,
> >>>>>>code=200
> >>>>>>0(24195) -------------------------------------------
> >>>>>>0(24195) entering main loop
> >>>>>>0(24195) BYE message received
> >>>>>>0(24195) -------------------------------------------
> >>>>>>0(24195) entering route[1] - relaying SIP message
> >>>>>>0(24195) relaying message ...
> >>>>>>0(24195) ACC: transaction answered: method=BYE,
> >>>>>>i-uri=sip:506029 at 10.1.10.104:5060, o-uri=sip:506029 at 10.1.10.104
> :5060,
> >>>>>>call_id=58dcd4-a010a68-13c4-119d-44d0f9-247 at 10.1.10.10,
> >>>>>>from=<sip:506030 at 10.1.10.10:5060;user=phone>
> >>>>>>;tag=a010a69-13c4-11a0-44dbd5-740c, code=200
> >>>>>>
> >>>>>>Can anyone help me ?
> >>>>>>
> >>>>>>Thanks
> >>>>>>Szabolcs
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>_______________________________________________
> >>>>>>Serusers mailing list
> >>>>>>serusers at lists.iptel.org
> >>>>>>http://lists.iptel.org/mailman/listinfo/serusers
> >>>>>>
> >>>>>
> >>>>
> >>>>_____________________________
> >>>>Szabolcs Szasz
> >>>>CCNA Network Engineer
> >>>>
> >>>>Digi Communication SRL
> >>>>H2/3 Petofi Sandor St.
> >>>>Sovata,
> >>>>Mures, Romania
> >>>>Tel/ Fax: +40 265 577888
> >>>> +40 265 577785
> >>>> +40 365 506000
> >>>>sszasz at digicomm.ro
> >>>>www.digicomm.ro <http://www.digicomm.ro>
> >>>>_____________________________
> >>>>
> >>>>
> >>>>
> >>>
> >>
> >>
> >> _____________________________
> >> Szabolcs Szasz
> >> CCNA Network Engineer
> >>
> >> Digi Communication SRL
> >> H2/3 Petofi Sandor St.
> >> Sovata,
> >> Mures, Romania
> >> Tel/ Fax: +40 265 577888
> >> +40 265 577785
> >> +40 365 506000
> >> sszasz at digicomm.ro
> >> www.digicomm.ro <http://www.digicomm.ro>
> >> _____________________________
> >>
> >>
> >>
> >
> 
> 
> _____________________________
> Szabolcs Szasz
> CCNA Network Engineer
> 
> Digi Communication SRL
> H2/3 Petofi Sandor St.
> Sovata,
> Mures, Romania
> Tel/ Fax: +40 265 577888
> +40 265 577785
> +40 365 506000
> sszasz at digicomm.ro
> www.digicomm.ro <http://www.digicomm.ro>
> _____________________________
> 
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20050628/ddaf83d7/attachment.htm>


More information about the sr-users mailing list