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

Mon Oct 20 10:58:44 CEST 2008

Hi Raul,

the design I follow is:

1. Use the timeout value received from radius into openser avps and write it
into a header (Session-Timer).
2. Make Yate parse this header with regexpfile module and force that
session-timer value to become timer recognized by Yate.

Once the timeout value is hit, Yate will automatically disconnect the
running session.

Hope this info helps.

DanB

On Tue, Oct 14, 2008 at 4:54 PM, raul2r2 <raul2r2 at gmail.com> wrote:

>
> 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.
>
>
> _______________________________________________
> Users mailing list
> Users at lists.kamailio.org
> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20081020/a5aff609/attachment.htm 