[Serusers] Problem with SER Accounting and Mysql

[mkumar at mantragroup.com]

Hi,

Finally I was able to fix it, I added

modparam("acc", "db_flag", 2)

and it worked and in acc table finally I could find some records.

Thanks for your help,
Manoj.

Quoting mkumar at mantragroup.com:

> Hi,
>
> Thanks for your reply.
>
> I first opened Makefile in /usr/local/ser/ser-0.9.4/modules/acc/ and 
> uncommented
> the line
>
> # uncomment the next line if you wish to enable SQL accounting
> DEFS+=-DSQL_ACC
>
> Later I called "make acc.so" in the same acc directory after deleting 
> previous
> acc.so and copied new acc.so to /usr/local/lib/ser/modules/acc.so 
> where I have
> all my modules and in my ser.cfg I have
> loadmodule "/usr/local/lib/ser/modules/acc.so"
>
> But still I could see nothing in acc table of my ser. On the console 
> I could see
>
> ACC: request acknowledged: call_id=1139975971-396-MERCURY at 192.168.1.113,
> totag=as3f535c91, from="manoj" <sip:manoj at mantragroup.com>;tag=8150,
> i-uri=sip:9118006733555 at 216.32.80.226:5384, method=ACK,
> o-uri=sip:9118006733555 at 216.32.80.226:5384, fromtag=8150, code=200,
> to=<sip:18006733555 at mantragroup.com>;tag=as3f535c91, uid=n/a,
> userpart=9118006733555
>
> Currently I am not handling "BYE", is that a problem?
>
> Please help me, I have no clew on where I am going wrong.
>
> Manoj.
>
> Quoting "Rafael J. Risco G.V." <rafael.risco at gmail.com>:
>
>> Hi
>> you have to edit ../modules/acc/Makefile and uncomment this line:
>>
>> # uncomment the next line if you wish to enable SQL accounting
>> DEFS+=-DSQL_ACC
>>
>> then recompile acc module and try again.
>>
>> rafael
>>
>>
>> On 2/14/06, mkumar at mantragroup.com <mkumar at mantragroup.com> wrote:
>>> Thanks for the reply.
>>>
>>> I added setflag(1) statement also but even then "acc" table of ser 
>>> is empty. I
>>> have mysql 3.23 version, is that creating the problem? I am attaching my
>>> ser.cfg again, please check it and help me know where I am going wrong?
>>>
>>> Quoting Ramin NIkaeen <Rnikaeen at goldline.net>:
>>>
>>> > I think you should have a "setflag(1)" for the accounting to work!
>>> >
>>> > ramin
>>> >
>>> >
>>> > -----Original Message-----
>>> > From: mkumar at mantragroup.com [mailto:mkumar at mantragroup.com]
>>> > Sent: Thursday, February 09, 2006 1:07 PM
>>> > To: serusers at lists.iptel.org
>>> > Subject: [Serusers] Problem with SER Accounting
>>> >
>>> > Hi All,
>>> >
>>> > I was able to install SER and call out successfully. I configured
>>> > ser.cfg after
>>> > seeing some examples in voip-info.org, almost all worked except
>>> > accounting. I
>>> > am using stable ser 0.9.4 version and followed instructions in
>>> > http://www.voip-info.org/tiki-index.php?page=SER+example+accounting.
>>> > When I
>>> > check the database for records related tables are empty. I did not
>>> > install
>>> > radius, is this required to enable accounting? I am attaching my
>>> > ser.cfg,
>>> > please check it and guide me.
>>> >
>>> > Any help will be sincerely appreciated.
>>> >
>>> > Thanks,
>>> > Manoj.
>>> >
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> Serusers mailing list
>>> serusers at lists.iptel.org
>>> http://lists.iptel.org/mailman/listinfo/serusers
>>>
>>>
>>>
>>>
>>
>
>
>