[OpenSER-Users] Re: Prepaid acounts CDRTool

[Marc LEURENT]

Oups , I simply forgot the src/modules/rlm_sql/drivers/rlm_sql_mysql/sql_mysql.c patch

Marc LEURENT a écrit :
> I have followed your advice, Freeradius is recompiled with rlm_python,
> byt know, rlm_sql seems to encountered troubles
> like :
> 
> rlm_sql (sql): Reserving sql socket id: 2
> rlm_sql_mysql: MYSQL check_error: 1312 received
> 
> Any idea of how to repair this?
> Thanks
> 
> 
> I have added this in my debian/rules file:
> 
> modulelist=krb5 ldap sql_mysql sql_iodbc python
> ...
> ...
>         ./configure \
>                 $(confflags) \
>                 --prefix=/usr \
> 		... \
>                 --with-static-modules=python
> 
> 
> 
> Here is my freeradius debug:
> 
> rlm_detail: /var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /var/log/freeradius/radacct/127.0.0.1/detail-20070822
>   modcall[accounting]: module "detail" returns ok for request 5
>   modcall[accounting]: module "unix" returns noop for request 5
> radius_xlat:  '/var/log/freeradius/radutmp'
> radius_xlat:  ''
>   modcall[accounting]: module "radutmp" returns ok for request 5
> radius_xlat:  ''
> radius_xlat:  '          CALL insert_radacct_record(                 'radius',                 '52f74a-c0a80101-0-4 at 192.168.95.79',
> '36afb36cd5c82c34',                 'sip:101 at sd-7501.dedibox.fr:5060=3Buser=3Dphone',
> 'sip:101 at sd-7501.dedibox.fr:5060=3Buser=3Dphone',                 '88.191.45.91',                 '5060',                 '2007-08-22 13:59:25',
>            '0',                 '0',                 '0',                 '0',                 '',                 '',                 '200',
>         'Sip-Session',                 '',                 '',                 '0',                 '0',                 '200',
> 'INVITE',                 '',                 'c0a80101-5766ea7',                 'c0a80101-4e8244',                 '',                 '',
>        '',                 'sip:0033677832974 at sd-7501.dedibox.fr:5060=3Buser=3Dphone',                 '',                 ''                 )'
> rlm_sql (sql): Reserving sql socket id: 2
> rlm_sql_mysql: MYSQL check_error: 1312 received
> rlm_sql (sql): Couldn't insert SQL accounting START record - PROCEDURE radius.insert_radacct_record can't return a result set in the given context
> radius_xlat:  ''
> rlm_sql (sql): Released sql socket id: 2
>   modcall[accounting]: module "sql" returns ok for request 5
> 
> 
> 
> 
> 
> Dan-Cristian Bogos a écrit :
>> Marc,
>>
>> I would suggest as first step reading about how  prepaid works in
>> CDRTool. (see PREPAID.txt in doc folder).
>>
>> I personally use freeradius-cdrtool connector
>> (sourceforge.net/projects/frad-cdrtool), which I have written in
>> python and which needs rlm_python compiled into freeradius server.
>>
>> Have a look on all the info and let me know if u need any additional.
>>
>> Cheers,
>> DanB
>>
>> On 8/20/07, Marc LEURENT <lftsy at free.fr> wrote:
>>> No...
>>> Is it possible to do it with openser or is it compulsory to use asterisk?
>>> What do you use?
>>>
>>> Thanks
>>>
>>>
>>> Dan-Cristian Bogos a écrit :
>>>> Hi there Marc,
>>>>
>>>> are you using any application which locks, unlocks the prepaid
>>>> accounts, and instructs CDRTool to update the user's balance? Are you
>>>> aware that CDRTool uses separate applications for prepaid and postpaid
>>>> accounts?
>>>>
>>>> DanB
> 
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users