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
