Re: mysql op field
Enesha Fairluck [EMAIL PROTECTED] wrote: Thanks for everything taht everyone did last weel about the op field. Heh guess I opened a can of worms :) Anyway everyone seems to be saying that the op value needs to be something. The problem is I don't know what. I don't know what that field is, much less what should go there.o Look at the 'users' file which is shipped with the server. Look at the SQL schema. Note what's in the 'users' file, and see where they're the same. See 'man 5 users', and look at the 'operator' text. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: mysql/op ...
Do-Risika RAFIEFERANTSIARONJY [EMAIL PROTECTED] wrote: It's really what I need, but what should happen if some of these attributes are not provided by the nas ? (because some of our nas provides Ascend-Data-Rate, but the others no ...) Then their values will be zero. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: mysql/op ...
[EMAIL PROTECTED] wrote: Do-Risika RAFIEFERANTSIARONJY [EMAIL PROTECTED] wrote: It's really what I need, but what should happen if some of these attributes are not provided by the nas ? (because some of our nas provides Ascend-Data-Rate, but the others no ...) Then their values will be zero. Alan DeKok. Ah, ok, that is well for me ! @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
mysql/op ...
Hi all, Another questions please : * where would I find the operations to follow to add the 'op' in the mysql tables ? I mean what should I do after mofdifying the tables structures ? * about operators, can someone explain me the difference betwen an '=' and an ':=' ? an ':=' i think is for affectation and '==' for comparison, but '=' ? * can I add some attributes (already in the dictionary such as DataRate or XMitRate) into the radacct table ? I think of modifying the table and the accounting queries in the radiusd.conf but I'm not sure it would work ... Thanx in advance, @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: mysql/op ...
On Wed, 16 Jan 2002 12:21:47 +0300
Do-Risika RAFIEFERANTSIARONJY [EMAIL PROTECTED] wrote:
Hi all,
Another questions please :
* where would I find the operations to follow to add the 'op' in the
mysql tables ? I mean what should I do after mofdifying the tables
structures ?
edit authorize_check_query and authorize_reply_query in sql.conf, adding
the op column.
reported:
# Authorization Queries
# These queries compare the check items for the user
# in ${authcheck_table} and setup the reply items in
# ${authreply_table}. You can use any query/tables
# you want, but the return data for each row MUST
# be in the following order:
#
# 0. Row ID (currently unused)
# 1. UserName/GroupName
# 2. Item Attr Name
# 3. Item Attr Value
# 4. Item Attr Operation
# Use these for case sensitive usernames. WARNING: Slower queries!
# authorize_check_query = SELECT id,UserName,Attribute,Value,op FROM
${authcheck_table} WHERE STRCMP(Username, '%{SQL-User-Name}') = 0 ORDER BY id
# authorize_reply_query = SELECT id,UserName,Attribute,Value,op FROM
${authreply_table} WHERE STRCMP(Username, '%{SQL-User-Name}') = 0 ORDER BY id
* about operators, can someone explain me the difference betwen an '='
and an ':=' ? an ':=' i think is for affectation and '==' for
comparison, but '=' ?
look at the manual page man5/users.5
* can I add some attributes (already in the dictionary such as DataRate
or XMitRate) into the radacct table ? I think of modifying the table and
the accounting queries in the radiusd.conf but I'm not sure it would
work ...
Thanx in advance,
@+
--
DouRiX
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Nicola Orru'
ENERGIT
Via Efisio Melis, 26
09134 Cagliari - Italia
Tel. +39 070 7521 317 Fax +39 070 7521 51
www.energit.it
Energia Telefonia Servizi Internet Sistemi di Gestione per le Aziende
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
