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 <[EMAIL PROTECTED]> 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', '[EMAIL PROTECTED]',
> '36afb36cd5c82c34', 'sip:[EMAIL
> PROTECTED]:5060=3Buser=3Dphone',
> 'sip:[EMAIL PROTECTED]: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:[EMAIL PROTECTED]: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 <[EMAIL PROTECTED]> 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
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users
