[OpenSER-Users] Re: Prepaid acounts CDRTool

[Marc LEURENT]

I haven't found this patch on http://sourceforge.net/projects/frad-cdrtool...
Where did you found it?
Thanks

Dan-Cristian Bogos a écrit :
> Marc,
> 
> I don't have this problem.
> I have compiled freeradius with rlm_python from sources.
> 
> For problems with freeradius, I think the best would be to grab some
> support directly from their mailing list, since they are pretty
> helpful. Don't forget about patching also rlm_digest in order to
> sanitize the params coming from OpenSER in the authorization phase and
> not the authentication one. They promised for future releases to
> include this patch inside the distribution.
> 
> Cheers,
> DanB
> 
> 
> On 8/22/07, Marc LEURENT <lftsy at free.fr> wrote:
>> I have corrected it: mea culpa
>>
>> But now I have a real trouble:
>> When I start freeradius, it said that it can't find rlm_python.so, but this is normal because we added --with-static-modules=python
>>
>>
>> Did you have thos problem?
>> Do you know how to correct it?
>>
>> Thanks
>>
>> rlm_sql (sql): Connected new DB handle, #4
>> Module: Instantiated sql (sql)
>> radiusd.conf[544] Failed to link to module 'rlm_python': rlm_python.so: cannot open shared object file: No such file or directory
>> radiusd.conf[1884] Unknown module "python".
>> radiusd.conf[1792] Failed to parse authorize section.
>> zsh: exit 1     freeradius -X
>>
>>
>> Dan-Cristian Bogos a écrit :
>>> Hi Marc,
>>>
>>> it looks like you are getting some problems related to stored
>>> procedure in your mysql database. Did u install also the radius patch
>>> recommended by AG-Projects in order to work properly with stored
>>> procedures? On the sql side I cannot help you too much since I am
>>> using still the normal sql queries without stored procedures.
>>>
>>> DanB
>>>
>>> On 8/22/07, Marc LEURENT <lftsy at free.fr> wrote:
>>>> 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