[OpenSER-Users] OpenSER+freeradius+billing problem

Norman Brandinger norm at goes.com
Sat Aug 18 14:24:27 CEST 2007



The RADIUS server is the component that writes data to the RADIUS log files or the database. 
The configuration that manages this is generally the "sql.conf" file located in the
RADIUS server directory.  If you have new attributes that are to be written to the log files
and/or database, "sql.conf" must be updated.

RADIUS will look at its main
configuration file "radiusd.conf" during various steps of
authorization/accounting.  If the "radiusd.conf" file is set to use "sql"
then the "sql.conf" file is referred to.  

The "sql.conf"
file is broken down into sections based on the different types of processing needed (for example
authorization or accouting).  The sections are SQL code and the addition of new attributes to
the appropriate section will cause radius to INSERT/UPDATE them to the database.  

Note that the format used (in sql.conf) to refer to the attributes passed from the radius
client must be strictly followed

Regards,
Norm

> On 8/18/07, Norman
Brandinger <norm at goes.com> wrote: 
>> 
>> Your problem is that the
RADIUS server and the RADIUS client are using 
>> different dictionaries. 
>> 
>> See what happens when they both use the same dictionary. 
> 
> 
> I have made seperate directory for both 
> 
> and copied what
ever required Files for the Openser and Radius 
> 
> I see only Start and Stop (
Invite and Bye) I dont see ACK 
> 
> and i see the Stop records coming in the Log
Twise 
> 
> 
> http://www.pastebin.ca/662039 
> 
> 
> So how i need to calculate the call time from Database. 
> 
> I see in
radacct, all the fields anot filled. some are still empty. 
> 
> how can make
extra fields, and calculate automatically 
> talk time. 
> 
> any
suggestions 
> 
> Ram 
> 
> Norman-thanks for the extended
support. 
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20070818/9d6e8931/attachment.htm 


More information about the Users mailing list