Re: Radius attributes in SQL INSERT

2002-11-05 Thread Alan DeKok
"Mieczyslaw Maciejewski (EPO)" wrote:
> Numbers in the database are easier to understand for some programs
> which do whimsical operations and finally present data in a graphical
> way.

  Huh?

  The numbers assigned to Acct-Status-Type values are meaningless.
You can't graph them, as they have no relationship to each other.

  I still don't understand why it's an issue.

  Alan DeKok.

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



RE: Radius attributes in SQL INSERT

2002-11-05 Thread Mieczyslaw Maciejewski (EPO)
Thx

Numbers in the database are easier to understand for some programs which do  whimsical 
operations and finally present data in a graphical way.

MM

-Original Message-
From: Alan DeKok [mailto:aland@;ox.org]
Sent: Tuesday, November 05, 2002 4:35 PM
To: [EMAIL PROTECTED]
Subject: Re: Radius attributes in SQL INSERT 


"Mieczyslaw Maciejewski (EPO)" wrote:
> For some purposes it is better to have numeric values in
> database. We have GUI which then presents data in user friendly
> fashion.

 And numbers in the database are easier to understand than names?

> OK. If I comment out attributes in dictionary, then everything will
> work for me. Is there any other way to do it without changing
> dictionary?

  Right now, no.

  Alan DeKok.

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

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



Re: Radius attributes in SQL INSERT

2002-11-05 Thread Alan DeKok
"Mieczyslaw Maciejewski (EPO)" wrote:
> For some purposes it is better to have numeric values in
> database. We have GUI which then presents data in user friendly
> fashion.

 And numbers in the database are easier to understand than names?

> OK. If I comment out attributes in dictionary, then everything will
> work for me. Is there any other way to do it without changing
> dictionary?

  Right now, no.

  Alan DeKok.

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



RE: Radius attributes in SQL INSERT

2002-11-04 Thread Mieczyslaw Maciejewski (EPO)
Hi

For some purposes  it is better to have numeric values in database. We have  GUI which 
then presents data in user friendly fashion.
OK. If I comment out attributes in dictionary, then everything will work for me. Is 
there any other way to do it without changing dictionary?

MM

-Original Message-
From: Alan DeKok [mailto:aland@;ox.org]
Sent: Monday, November 04, 2002 5:35 PM
To: [EMAIL PROTECTED]
Subject: Re: Radius attributes in SQL INSERT 


"Mieczyslaw Maciejewski (EPO)" wrote:
> One of values of  attribute Acct-Status-Type is value (in mnemonic) Start.
> For me it looks that instead of inserting into database numeric
> value of attribute Acct-Status-Type, FreeRadius tries to insert
> mnemonic of that attribute (i.e. text 'Start').

  Yes.  What's wrong with that?

  The default schema does NOT include a row for Acct-Status-Type.  So
if you're using it, then you've changed the schema and the SQL
queries.

  The Acct-Status-Type attribute is an 'integer' type, but it's easier
for people to use names, so the integers have names.  See the
dictionary files for details.

  Alan DeKok.

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

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



Re: Radius attributes in SQL INSERT

2002-11-04 Thread Alan DeKok
"Mieczyslaw Maciejewski (EPO)" wrote:
> One of values of  attribute Acct-Status-Type is value (in mnemonic) Start.
> For me it looks that instead of inserting into database numeric
> value of attribute Acct-Status-Type, FreeRadius tries to insert
> mnemonic of that attribute (i.e. text 'Start').

  Yes.  What's wrong with that?

  The default schema does NOT include a row for Acct-Status-Type.  So
if you're using it, then you've changed the schema and the SQL
queries.

  The Acct-Status-Type attribute is an 'integer' type, but it's easier
for people to use names, so the integers have names.  See the
dictionary files for details.

  Alan DeKok.

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