Thanks Dan!! I have successfully compiled freeradius 1.1.6 with the rlm_python compiled statically! So the freeradius-cdrtool module works!!
My problem is that is cannot find the destination whereas it's in the Canonical-URI, so that with To=None, it cannot calculate the max session time But in the radacct database, there is the Canonical-URI A Parsing problem? Stange, I don't know where to search for it Aug 23 16:57:23 sd-7501 CDRTool[20011]: MaxSessionTime [EMAIL PROTECTED] To=None Duration=7200 Lock=1 Aug 23 16:57:23 sd-7501 CDRTool[20011]: Load last minute: 5 calls @ 0.04 cps, memory: 10.13 MB Aug 23 16:57:23 sd-7501 CDRTool[20011]: Call to none, no limit imposed Aug 23 16:57:23 sd-7501 CDRTool[20011]: GetBalance [EMAIL PROTECTED] Aug 23 16:57:23 sd-7501 CDRTool[20011]: Customer : [EMAIL PROTECTED] Aug 23 16:57:23 sd-7501 CDRTool[20011]: Balance : 1000.0000 Aug 23 16:57:23 sd-7501 CDRTool[20011]: MaxSessionTime [EMAIL PROTECTED] To=None Duration=7200 Lock=1 Aug 23 16:57:23 sd-7501 CDRTool[20011]: Call to none, no limit imposed Aug 23 16:57:23 sd-7501 CDRTool[20011]: GetBalance [EMAIL PROTECTED] Aug 23 16:57:23 sd-7501 CDRTool[20011]: Customer : [EMAIL PROTECTED] Aug 23 16:57:23 sd-7501 CDRTool[20011]: Balance : 1000.0000 Aug 23 16:57:24 sd-7501 CDRTool[20011]: MaxSessionTime [EMAIL PROTECTED] To=None Duration=7200 Lock=1 Aug 23 16:57:24 sd-7501 CDRTool[20011]: Call to none, no limit imposed Aug 23 16:57:24 sd-7501 CDRTool[20011]: GetBalance [EMAIL PROTECTED] Aug 23 16:57:24 sd-7501 CDRTool[20011]: Customer : [EMAIL PROTECTED] Aug 23 16:57:24 sd-7501 CDRTool[20011]: Balance : 1000.0000 Aug 23 16:57:45 sd-7501 CDRTool[20011]: DebitBalance From=None To=sip:[EMAIL PROTECTED]:5060;user=phone Duration=0 Aug 23 16:57:45 sd-7501 CDRTool[20011]: Warning: Account none is not prepaid rad_recv: Accounting-Request packet from host 127.0.0.1:59701, id=79, length=318 Acct-Status-Type = Failed Service-Type = Sip-Session Sip-Response-Code = 487 Sip-Method = INVITE Event-Timestamp = "Aug 23 2007 16:51:33 CEST" Sip-From-Tag = "c0a80101-29f6f83" Sip-To-Tag = "c0a80101-29f6daa" Acct-Session-Id = "[EMAIL PROTECTED]" Sip-Src-IP = "81.57.0.22" Sip-Src-Port = "62854" Canonical-URI = "sip:[EMAIL PROTECTED]:5060;user=phone" Billing-Party = "sip:[EMAIL PROTECTED]:5060;user=phone" SIP-Proxy-IP = "88.191.45.91" User-Agent = "THOMSON ST2030 hw0 fw1.56 00-0E-50-4E-AF-C4" NAS-Port = 5060 Acct-Delay-Time = 0 NAS-IP-Address = 127.0.0.1 Processing the preacct section of radiusd.conf Dan-Cristian Bogos a écrit : > Marc, > > try this (as I have written in freeradius list) - should work fine if > u follow the exact steps. I am compiling it statically since this was > the building policy recommended by developers: > > 1. Grab the sources and unpack them (1.1.7 version) > 2. After unpacking, run from within the source folder: > ./configure --with-static-modules=python > make > 3. Your make will stop here: "libtool: link: cannot find the library > `../modules/rlm_python/rlm_python.la' or unhandled argument > `../modules/rlm_python/rlm_python.la'" > 4. Go into ./src/modules/rlm_python > 5. run ./configure + make + make install > 6. Go back to root of sources and run again make + make install. > > Hope that will do, > DanB > > > > > On 8/23/07, Marc LEURENT <[EMAIL PROTECTED]> wrote: >> I'm receiving freeradius-users@lists.freeradius.org >> Did you sent it there? >> >> I have posted some message there and some developpers said that rlm_python >> shouldn't be compiled statically... And that I should use the experimental >> module option. So I don't know what to do in order to get your module working >> >> PS: I have tested it in console with python directly, Congratulations!! It >> works perfectly >> >> >> >> Dan-Cristian Bogos a écrit : >>> SOLVED, check the freeradius list, I have posted there the solution. >>> >>> DanB >>> >>> On 8/23/07, Marc LEURENT <[EMAIL PROTECTED]> wrote: >>>> I have copied the missing radpaths.h from 1.1.7 source, but there is still >>>> an error! (libradius.la) >>>> Why is ir so important de compile de python module statically?? >>>> >>>> Can we compile the experimental modules?? >>>> >>>> rlm_python.c: At top level: >>>> rlm_python.c:244: warning: function declaration isn't a prototype >>>> rlm_python.c: In function 'python_load_function': >>>> rlm_python.c:456: warning: passing argument 2 of 'PyObject_GetAttrString' >>>> discards qualifiers from pointer target type >>>> gcc -g -O2 -D_REENTRANT -D_POSIX_PTHREAD_SEMANTICS -Wall -D_GNU_SOURCE -g >>>> -Wshadow -Wpointer-arith -Wcast-qual -Wcast-align -Wwrite-strings >>>> -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations >>>> -Wnested-externs -W -Wredundant-decls -Wundef >>>> -I/home/mleurent/freeradius/official/freeradius-1.1.6/src/include >>>> -I/usr/include/python2.4 -c rlm_python.c -o rlm_python.o >/dev/null 2>&1 >>>> /home/mleurent/freeradius/official/freeradius-1.1.6/libtool --mode=link >>>> gcc -release 1.1.6 \ >>>> -module -static -o rlm_python.la \ >>>> -rpath /usr/local/lib rlm_python.lo rlm_python.c >>>> /home/mleurent/freeradius/official/freeradius-1.1.6/src/lib/libradius.la \ >>>> -L/usr/lib/python2.4/config -lpthread >>>> -ldl -lutil -lpython2.4 -lm -lnsl -lresolv -lpthread >>>> libtool: link: cannot find the library >>>> `/home/mleurent/freeradius/official/freeradius-1.1.6/src/lib/libradius.la' >>>> or unhandled argument >>>> `/home/mleurent/freeradius/official/freeradius-1.1.6/src/lib/libradius.la' >>>> make: *** [rlm_python.la] Error 1 >>>> zsh: exit 2 make >>>> >>>> >>>> Dan-Cristian Bogos a écrit : >>>>> Ok, try a trick then, >>>>> >>>>> 1. in root folder type: >>>>> >>>>> ./configure --with-static-modules=python >>>>> >>>>> 2. go in ./src/modules/rlm_python/ and try after the installation >>>>> procedure: ./configure + make + make install >>>>> 3. Go back to root folder and try again the installation procedure >>>>> (./configure --with-static-modules=python + make + make install). >>>>> >>>>> Let me know how it goes. >>>>> >>>>> DanB >>>>> >>>>> On 8/23/07, Marc LEURENT <[EMAIL PROTECTED]> wrote: >>>>>> I cannot do it! >>>>>> Sniff again >>>>>> >>>>>> SCREEN):[EMAIL PROTECTED]:[/home/../freeradius-1.1.6]# cd >>>>>> src/modules/rlm_python >>>>>> (SCREEN):[EMAIL PROTECTED]:[~mleurent/../rlm_python]# ./configure >>>>>> checking for gcc... gcc >>>>>> checking for C compiler default output file name... a.out >>>>>> checking whether the C compiler works... yes >>>>>> checking whether we are cross compiling... no >>>>>> checking for suffix of executables... >>>>>> checking for suffix of object files... o >>>>>> checking whether we are using the GNU C compiler... yes >>>>>> checking whether gcc accepts -g... yes >>>>>> checking for gcc option to accept ANSI C... none needed >>>>>> checking how to run the C preprocessor... gcc -E >>>>>> checking for python2.3... no >>>>>> checking for python2.2... no >>>>>> checking for python2.1... no >>>>>> checking for python1.5... no >>>>>> checking for python... python >>>>>> checking for Python.h... yes >>>>>> checking for Py_Initialize in -lpython2.4... yes >>>>>> configure: creating ./config.status >>>>>> config.status: creating Makefile >>>>>> >>>>>> (SCREEN):[EMAIL PROTECTED]:[~mleurent/../rlm_python]# make >>>>>> ../rules.mak:24: ../../../Make.inc: No such file or directory >>>>>> make: *** No rule to make target `../../../Make.inc'. Stop. >>>>>> zsh: exit 2 make >>>>>> >>>>>> >>>>>> Dan-Cristian Bogos a écrit : >>>>>>> Hi Marc, >>>>>>> >>>>>>> it looks like there has been some changes with freeradius 1.7 since >>>>>>> this one does not install for me either. It says :" ibtool: link: >>>>>>> cannot find the library >>>>>>> `/usr/local/src/freeradius/freeradius-1.1.7/src/lib/libradius.la' or >>>>>>> unhandled argument >>>>>>> `/usr/local/src/freeradius/freeradius-1.1.7/src/lib/libradius.la'". On >>>>>>> a manual search I could see that this library is not longer included >>>>>>> with the sources. I will try asking the guys from freeradius about the >>>>>>> changes necessary to work. >>>>>>> In the mean time, if u want to give it a try, here is how I have >>>>>>> installed from freeradius 1.6: >>>>>>> 1. Download the sources: "wget >>>>>>> ftp://ftp.freeradius.org/pub/radius/freeradius-1.1.6.tar.gz" >>>>>>> 2. Extract and get into the source folder. >>>>>>> 3. Go to ./src/modules/rlm_python/ >>>>>>> 4. Install the sources statically: (./configure + make + make install). >>>>>>> 5. Go back to root folder for the sources >>>>>>> 6. ./configure --with-static-modules=python >>>>>>> 7. make + make install. >>>>>>> >>>>>>> Hope that would do for you. >>>>>>> >>>>>>> Cheers, >>>>>>> DanB >>>>>>> >>>>>>> On 8/22/07, Marc LEURENT <[EMAIL PROTECTED]> wrote: >>>>>>>> I have another error with freeradius 1.1.7 from source, I don't know >>>>>>>> why it cannot find the module... >>>>>>>> I'll check tomorrow >>>>>>>> Yhanks for your help Dan, have a pleasant evening >>>>>>>> >>>>>>>> rlm_sql_mysql: Starting connect to MySQL server for #3 >>>>>>>> rlm_sql (sql): Connected new DB handle, #3 >>>>>>>> rlm_sql (sql): starting 4 >>>>>>>> rlm_sql (sql): Attempting to connect rlm_sql_mysql #4 >>>>>>>> rlm_sql_mysql: Starting connect to MySQL server for #4 >>>>>>>> rlm_sql (sql): Connected new DB handle, #4 >>>>>>>> Module: Instantiated sql (sql) >>>>>>>> python_init done >>>>>>>> Module: Loaded python >>>>>>>> python: mod_instantiate = "freeradius-cdrtool" >>>>>>>> python: func_instantiate = "instantiate" >>>>>>>> python: mod_authorize = "freeradius-cdrtool" >>>>>>>> python: func_authorize = "authorize" >>>>>>>> python: mod_authenticate = "(null)" >>>>>>>> python: func_authenticate = "(null)" >>>>>>>> python: mod_preacct = "(null)" >>>>>>>> python: func_preacct = "(null)" >>>>>>>> python: mod_accounting = "freeradius-cdrtool" >>>>>>>> python: func_accounting = "accounting" >>>>>>>> python: mod_checksimul = "(null)" >>>>>>>> python: func_checksimul = "(null)" >>>>>>>> python: mod_detach = "freeradius-cdrtool" >>>>>>>> python: func_detach = "detach" >>>>>>>> rlm_python:python_load_function: module 'freeradius-cdrtool' is not >>>>>>>> found >>>>>>>> rlm_python:EXCEPT:exceptions.ImportError: >>>>>>>> /usr/lib/python2.4/lib-dynload/_socket.so: undefined symbol: >>>>>>>> _Py_TrueStruct >>>>>>>> rlm_python:python_load_function: failed to import python function >>>>>>>> 'freeradius-cdrtool.instantiate' >>>>>>>> radiusd.conf[541]: python: Module instantiation failed. >>>>>>>> radiusd.conf[1900] Unknown module "python". >>>>>>>> radiusd.conf[1803] Failed to parse authorize section. >>>>>>>> zsh: exit 1 radiusd -X >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> Dan-Cristian Bogos a écrit : >>>>>>>>> You are getting this error because the interpreter does not accept "-" >>>>>>>>> in the name. I didn't need to import it in the interpreter and there >>>>>>>>> will be no use since radiusd package is available only within >>>>>>>>> freeradius process. >>>>>>>>> >>>>>>>>> Thxs, >>>>>>>>> DanB >>>>>>>>> >>>>>>>>> On 8/22/07, Marc LEURENT <[EMAIL PROTECTED]> wrote: >>>>>>>>>> Do you have this error? >>>>>>>>>> When I try to load your module in mython, I have this error because >>>>>>>>>> of the dash.. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> [EMAIL PROTECTED]:[/home/../freeradius-cdrtool-1.0]# python >>>>>>>>>> Python 2.4.4 (#2, Apr 5 2007, 20:11:18) >>>>>>>>>> [GCC 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)] on linux2 >>>>>>>>>> Type "help", "copyright", "credits" or "license" for more >>>>>>>>>> information. >>>>>>>>>>>>> import freeradius-cdrtool >>>>>>>>>> File "<stdin>", line 1 >>>>>>>>>> import freeradius-cdrtool >>>>>>>>>> ^ >>>>>>>>>> SyntaxError: invalid syntax >>>>>>>>>>>>> import setup >>>>>>>>>> usage: [global_opts] cmd1 [cmd1_opts] [cmd2 [cmd2_opts] ...] >>>>>>>>>> or: --help [cmd1 cmd2 ...] >>>>>>>>>> or: --help-commands >>>>>>>>>> or: cmd --help >>>>>>>>>> >>>>>>>>>> error: no commands supplied >>>>>>>>>> zsh: exit 1 python >>>>>>>>>> >>>>>>>>>> Dan-Cristian Bogos a écrit : >>>>>>>>>>> Marc, >>>>>>>>>>> >>>>>>>>>>> This is still an error from python, not my module. I think it has >>>>>>>>>>> something to do with linking inside between C and python. What were >>>>>>>>>>> the steps in your freeradius installation? >>>>>>>>>>> >>>>>>>>>>> DanB >>>>>>>>>>> >>>>>>>>>>> On 8/22/07, Marc LEURENT <[EMAIL PROTECTED]> wrote: >>>>>>>>>>>> I have compiled the experimental modules, now the python module is >>>>>>>>>>>> working but I have an error with yours... >>>>>>>>>>>> I have changed the rlm_digest.c and fixed the sql module to work >>>>>>>>>>>> with procedure >>>>>>>>>>>> >>>>>>>>>>>> rlm_sql (sql): Connected new DB handle, #4 >>>>>>>>>>>> Module: Instantiated sql (sql) >>>>>>>>>>>> python_init done >>>>>>>>>>>> Module: Loaded python >>>>>>>>>>>> python: mod_instantiate = "freeradius-cdrtool" >>>>>>>>>>>> python: func_instantiate = "instantiate" >>>>>>>>>>>> python: mod_authorize = "freeradius-cdrtool" >>>>>>>>>>>> python: func_authorize = "authorize" >>>>>>>>>>>> python: mod_authenticate = "(null)" >>>>>>>>>>>> python: func_authenticate = "(null)" >>>>>>>>>>>> python: mod_preacct = "(null)" >>>>>>>>>>>> python: func_preacct = "(null)" >>>>>>>>>>>> python: mod_accounting = "freeradius-cdrtool" >>>>>>>>>>>> python: func_accounting = "accounting" >>>>>>>>>>>> python: mod_checksimul = "(null)" >>>>>>>>>>>> python: func_checksimul = "(null)" >>>>>>>>>>>> python: mod_detach = "freeradius-cdrtool" >>>>>>>>>>>> python: func_detach = "detach" >>>>>>>>>>>> exceptions.ImportError: /usr/lib/python2.4/lib-dynload/_socket.so: >>>>>>>>>>>> undefined symbol: _Py_TrueStruct >>>>>>>>>>>> Failed to import python module "freeradius-cdrtool" >>>>>>>>>>>> radiusd.conf[544]: python: Module instantiation failed. >>>>>>>>>>>> radiusd.conf[1884] Unknown module "python". >>>>>>>>>>>> radiusd.conf[1792] Failed to parse authorize section. >>>>>>>>>>>> zsh: exit 1 freeradius -X >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> Dan-Cristian Bogos a écrit : >>>>>>>>>>>>> You can get it from here: >>>>>>>>>>>>> http://frad-cdrtool.sourceforge.net/rlm_digest.c >>>>>>>>>>>>> >>>>>>>>>>>>> DanB >>>>>>>>>>>>> >>>>>>>>>>>>> On 8/22/07, Marc LEURENT <[EMAIL PROTECTED]> wrote: >>>>>>>>>>>>>> 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 <[EMAIL PROTECTED]> 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 <[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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html