[OpenSER-Users] Re: Prepaid acounts CDRTool

Marc LEURENT lftsy at free.fr
Wed Aug 22 14:57:34 CEST 2007


Ok, now it's a true question!
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
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



root at sd-7501:[~mleurent/../freeradius-1.1.3]# ls src/modules/rlm_python
Makefile     config.log      configure*    prepaid.py   radiusd.py       rlm_python.c   rlm_python.lo
Makefile.in  config.status*  configure.in  prepaid.sql  radiusd_test.py  rlm_python.la  rlm_python.o




Marc LEURENT a écrit :
> 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
> 
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users



More information about the Freeradius-Users mailing list