In Alans post to this question, he has a better suggestion. In my case there is an existing billing system, that we will be integrating to, that also uses MySQL for the database that will handle the updates via a background process.
MySQL does not have a concept of database triggers, for that you would probally need to loook at Oracle ($$$), so the only way to get auto updates is via an external process to MySQL.
IMHO, the perl script Alan suggested might be the way to go. It's a lot cleaner if you don't have to worry about integrating to a legacy backend billing system.
Robert Causey iMedia Associates
German Viera wrote:
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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
