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@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.
>