22 Aug
2007
22 Aug
'07
9:14 a.m.
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(a)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(a)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(a)192.168.95.79'.79',
> '36afb36cd5c82c34',
'sip:101@sd-7501.dedibox.fr:5060=3Buser=3Dphone',
> 'sip:101@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@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(a)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