Re: rlm_sql, db_postgresql.sql ,v 1.16 2004/02/29, dictionary table question

2004-07-01 Thread Alan DeKok
[EMAIL PROTECTED] wrote:

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: rlm_sql, db_postgresql.sql ,v 1.16 2004/02/29, dictionary table question

2004-07-01 Thread Alan DeKok
[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.

  As the text you posted already says, FreeRADIUS doesn't use that
dictionary table.

  Instead, it uses dictionary files.

 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.

  See the existing dictionary files  man page for documentation.
The intended meaning of those fields should be obvious from there.

  Alan DeKok.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re[2]: rlm_sql, db_postgresql.sql ,v 1.16 2004/02/29, dictionary table question

2004-07-01 Thread Dmitriy Milashenko
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


Re: Re[2]: rlm_sql, db_postgresql.sql ,v 1.16 2004/02/29, dictionary table question

2004-07-01 Thread Alan DeKok
Dmitriy Milashenko [EMAIL PROTECTED] wrote:
 BUT I still can not understand:
 1. what mean field Format;

  Extra information, not recorded in the other fields.  See the main
dictionary files for examples.  This information is also documented in
he man page.

 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?

  So suggest something better.

  Alan DeKok.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html