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

RE: Radius attributes in SQL INSERT

2002-11-05 Thread Mieczyslaw Maciejewski (EPO)
: 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

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

Radius attributes in SQL INSERT

2002-11-04 Thread Mieczyslaw Maciejewski (EPO)
Hi I use FreeRadius 0.71(snapshoot 20021104) on Solaris 8. Oracle 8.1.7 For accounting I use query as below (the query form is limited to important columns only): accounting_start_query=INSERT into TMP_TABLE( ...SESSION_START ) VALUES (.'%{Acct-Status-Type}'...

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.

RE: Radius attributes in SQL INSERT

2002-11-04 Thread Mieczyslaw Maciejewski (EPO)
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