Hi Robert
Thank's for your replay . I am aware of Cisco's AAA and the VSA that
freeradius provides with cisco's dictionary. I hadn't already understud how
to setup the mysql interaction with freeradius, I am currently using flat
text files as comes by default. My next question is , in a prepaid
environment is it really usefull to use the mysql environment with a
backgroud processes that check for users logs (if it was that what you where
refering in your mail) and updates the db.
I am trying to implement an application altering the free radius code
that log directly to a db and during logging update users data (depending on
de VSA of time left and the number dialed), I didn't very good result till
now but I would like to know if there is a easy way to configure and add
thing to freeradius in order to acomplish the task of real-time billing.
Thank's again and hope you can give me a hand,
Regards,
German Viera
[EMAIL PROTECTED]
Montevideo
Uruguay
----- Original Message -----
From: "Robert Causey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 07, 2004 9:29 PM
Subject: Re: Implementing a realtime-prepaid platform with freeradius
> German,
>
> I am currently working on something similar. I can't go into great
> detail because I am under NDA, however I can give you the general
approach.
>
> In Cisco VOIP aplications it is possible to do authentication via what
> Cisco refers to as AAA authentication. This realy does authenication to
> a radius server. Using freeradius with mysql, it is possible to include
> some custom attributes associated with the user that will be returned
> with the authorization query. It then should be possible from your Cisco
> TCL script to use those attribues and handle the call accordingly. Your
> backend systems could then simply update the mysql database for realtime
> updates.
>
> Look at the Cisco web site for information on TCL and writing IVR
> scripts. There is some sample code and applications there as well that
> should help.
>
> Also look at the mysql db schema and sql.conf that is included in the
> freeradius dist and if you havn't already, pick up a copy of the radius
> book from O'Reily. This will start to give you an idea of how flexable
> the integration is, and how you can massage the sql queries to get the
> custom attributes.
>
> Hope this helps.
>
> Robert Causey
> iMedia Associates
>
>
>
> German Viera wrote:
> > Hi everybody,
> >
> > I have been working with free radius for a while and I think is one
of the most usefull open source radius servers arround.
> > Right now I am just logging accounting details for a VoIP platform, also
making auth to users (both with the text detail and users file.) My questing
is if does anybothy of the freeradius communy implemented or is implementing
a real-time prepaid service for users. If don't I would like to know if
somebody could give me some tip to code an application that receive the
RADIUS logs of auth in order to response with the availability of time,
depending on the dialed number (I am using cisco AS5300 ..and I think some
VSA have this items) also that updates the time left in the users file .
> >
> > Hope somebody could give me a hand on this ,
> >
> >
> > Regards,
> >
> > German Viera
> > Montevideo
> > Uruguay
> >
>
>
> -
> List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
