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

Mon Oct 13 18:43:36 CEST 2008

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-tp19731475p19958449.html
Sent from the OpenSER Users Mailing List mailing list archive at Nabble.com.