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