[Kamailio-Users] Send MaxCallDuration and UserCredit for freeradius-cdrtool

Tue Oct 14 16:54:55 CEST 2008

Hi Again...
       It seems that problem 1 is solved... i only have to change the
configuration in clients and servers configs file from freeradius and
radius-client to point to my gateway ip-address not to my loopbak
interface...
But for problem two... any advice?...


raul2r2 wrote:
> 
> Hi Dan...
>        Well, it seems that i can solve the problem... the problem was that
> i don't recompile correctly rlm_python module support. Thank you, i see a
> similar answer from you in the same thread... Although my other problem
> persists...
> 1. How can i change/define NAS-IP-Addrees parameter from openser... it
> takes loopback interface, and i need that this must be gateway public ip,
> that i use in my rates for cdrtool to calculate correctly MaxSessionTime.
> 2. I'm trying to hangup the call... I use a little server script that use
> end_dlg_end MI function to fake bye's in both directions ending media
> session. Problems is that openser script does not process these bye's so i
> can not stop accounting. I know that this is an opensips limitation and
> saw a discursion this October where opensips Bogdan developer admit that
> he is working on some kind of solution.... Meanwhile i am looking for
> alternativies... these are the two i have:
> 	1. Use mediaproxy and engage_media_proxy to end media session when dialog
> expires (probably playing with timeout_avp dialog function and your
> script)... but i'm not sure that this can solve the accounting problem.
> 	2.  I read a bit about you are using SIP Session Timers and Yate to solve
> this... can you help me a bit in the right direction or configuration
> scripts... 
> 
> Thank you in advance...
> Cheers
> 
> DanB-2 wrote:
>> 
>> Raul,
>> 
>> this log shows only half of the call(stop one).
>> Can u show a full trace (start and stop of the call)?
>> 
>> Cheers,
>> DanB
>> 
>> On Thu, Oct 9, 2008 at 12:40 PM, raul2r2 <raul2r2 at gmail.com> wrote:
>> 
>>>
>>> Hi Dan...:
>>>    The syslog show this:
>>> Oct  9 14:40:01 PREPSQL01 cdrtool[27237]: Normalize datasource
>>> ser_radius,
>>> database DB_radius, table radacct200810
>>> Oct  9 14:40:01 PREPSQL01 cdrtool[27237]: Normalize lock id 5889 aquired
>>> for
>>> ser_radius:radacct200810
>>> Oct  9 14:40:01 PREPSQL01 cdrtool[27237]: Normalize datasource
>>> ser_radius,
>>> database DB_radius, table radacct200809
>>> Oct  9 14:40:01 PREPSQL01 cdrtool[27237]: Normalize lock id 5889 aquired
>>> for
>>> ser_radius:radacct200809
>>> Oct  9 14:40:01 PREPSQL01 cdrtool[27237]: Database error: Table
>>> 'radius.radacct200809' doesn't exist (1146)
>>> Oct  9 14:40:01 PREPSQL01 cdrtool[27237]: Unlock
>>> ser_radius:radacct200810
>>> Oct  9 14:40:01 PREPSQL01 cdrtool[27237]: Unlock
>>> ser_radius:radacct200809
>>> Oct  9 14:40:02 PREPSQL01 cdrtool[27236]: Checking user quotas for data
>>> source OpenSER
>>> Oct  9 14:40:02 PREPSQL01 cdrtool[27236]: Using database queries to
>>> block
>>> accounts
>>> Oct  9 14:40:02 PREPSQL01 cdrtool[27236]: No quota has been exceeded
>>> Oct  9 14:40:14 PREPSQL01 cdrtool[7803]: DebitBalance
>>> CallId=1A0082B8-7734-BA31-4828-3D24892A184C at 192.168.0.41
>>> From=admin at goldslam.com To=sip:0034678650039 at 192.168.0.130:5060
>>> Gateway=127.0.0.1 Duration=8
>>> Oct  9 14:40:14 PREPSQL01 cdrtool[7803]: Error: session
>>> 1A0082B8-7734-BA31-4828-3D24892A184C at 192.168.0.41 for admin at goldslam.com
>>> does not exist
>>>
>>> I don't know if the bad gateway could be the cause of this... How i can
>>> change NAS-IP-Address in openser?
>>> Cheers...
>>>
>>>
>>> DanB-2 wrote:
>>> >
>>> > Raul,
>>> >
>>> > it looks like there is something wrong with the answer you receive
>>> from
>>> > cdrtool (could be wrong handled by connector too...).
>>> >
>>> > Can u post me the cdrtool syslog? There it should be seen the answer
>>> > received.
>>> >
>>> > Cheers,
>>> > DanB
>>> >
>>> > On Tue, Oct 7, 2008 at 7:27 PM, raul2r2 <raul2r2 at gmail.com> wrote:
>>> >
>>> >>
>>> >> Hi DanB...
>>> >>    Finally i have to set up manually, nothing different from README
>>> >> configuration and from my older platform running previous version of
>>> >> freeradius-cdrtool (1.1)... It's doesn't matter, setting up manually
>>> is
>>> >> enough for me... Thank you.
>>> >>    I have other stupid problem... first one is extracting gateway ip
>>> in
>>> >> authorization section of the script. I see it is extracted from
>>> >> NAS-IP-Address... this contain the loopbak ip 127.0.0.1... how i can
>>> >> change
>>> >> this parameter in openser to send my real gateway ip?
>>> >>    The second one isn't so easy and it's possible that have some kind
>>> of
>>> >> relation with the previous one. When the script tries to do and
>>> >> endsession
>>> >> over cdrtool (6.6.9) rating engine, it raises the following
>>> exception:
>>> >> rlm_python [freeradius-cdrtool]: DebitBalance
>>> >> CallId=27874A50-6363-3C25-6B88-6FBCB76686C6 at 192.168.0.41
>>> >> From=admin at goldslam.com To=sip:0034XXXXXXXXX at 192.168.0.130:5060
>>> >> Gateway=127.0.0.1 Duration=9
>>> >> rlm_python:EXCEPT:exceptions.AttributeError: 'NoneType' object has no
>>> >> attribute 'find'
>>> >> I'll try to investigate a bit more why this is happening...
>>> >> Cheers.
>>> >>
>>> >>
>>> >>
>>> >>
>>> >
>>> > _______________________________________________
>>> > Users mailing list
>>> > Users at lists.kamailio.org
>>> > http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>>> >
>>> >
>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Send-MaxCallDuration-and-UserCredit-for-freeradius-cdrtool-tp19731475p19896343.html
>>> Sent from the OpenSER Users Mailing List mailing list archive at
>>> Nabble.com.
>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.kamailio.org
>>> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>>>
>> 
>> _______________________________________________
>> Users mailing list
>> Users at lists.kamailio.org
>> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>> 
>> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Send-MaxCallDuration-and-UserCredit-for-freeradius-cdrtool-tp19731475p19975181.html
Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com.