Hi, Alan. Alan wrote 1 July 2004, 16:50:35:
AD> [EMAIL PROTECTED] wrote: >> I create billing based on FreeRadius and PostgreSQL for ISP, and it >> would be nice to know some about dictionary table that will be >> probably used in future releases of FreeRADIUS to create compatible >> billing system. AD> As the text you posted already says, FreeRADIUS doesn't use that AD> dictionary table. AD> Instead, it uses dictionary files. The idea was to create front-end of billing system that allows user to select values of Attribute field for radcheck, radreply, etc. tables from database table and probably using foreign key constraint. So when I saw dictionary table in db_postgresql.sql I thought it can be used for this. As I understand if it appeared in database schema, it mean that in future it can be used in FreeRADIUS, and I just want to create billing system that will not need modifying to be compatible with future versions of FreeRADIUS. >> so, I'd like to know if it (table) will be used without modifications >> of field list and surely know what meaning have each field. AD> See the existing dictionary files && "man" page for documentation. AD> The intended meaning of those fields should be obvious from there. After I saw dictionary file, it seems to me that in the table "dictionary" fields mean: id - that is clear; Type - for example "string"; Attribute - for example "Framed-Protocol"; Value - for example "PPP"; Vendor - for example "3com" BUT I still can not understand: 1. what mean field "Format"; 2. to define all possible values of Attribute I should insert several rows that contain pair Attribute - Value with the same Attribute value? But this is wrong way to create database!!! or I missed something and not understand? Please help me to understand the idea. -- Dmitriy mailto:[EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

