[Serusers] ser-mysql accounting

Daryl Sanders daryl.sanders at gmail.com
Tue Jun 28 18:34:44 CEST 2005


Klaus,

You may find that even after you have uncommented the mysql lines in
makefile, it still does not compile...

you need to use:

make modules include_modules="mysql" 

make install include_modules="mysql" 

mysql module is not compiled/installed by default because it depends
on an external library (libmysqlclient)

- Daryl



On 6/28/05, Klaus Darilion <klaus.mailinglists at pernau.at> wrote:
> take a look at the MAkefile of the acc module
> 
> regards,
> klaus
> 
> 
> Szabolcs Szasz 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
> >>>>>_____________________________
> >>>>>
> >>>>>
> >>>>>
> >>>>
> >>>
> >>>_____________________________
> >>>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
> >>>_____________________________
> >>>
> >>>
> >>>
> >>
> >
> >
> > _____________________________
> > 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
> > _____________________________
> >
> >
> > _______________________________________________
> > Serusers mailing list
> > serusers at lists.iptel.org
> > http://lists.iptel.org/mailman/listinfo/serusers
> >
> >
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>




More information about the sr-users mailing list