entries in the 'users' file

[Ruslan A Dautkhanov]

    Hi all,

    Is it possible to locate multiple entries in a DB, like
    we can do in the 'users' file:

dailu1   Auth-Type := Local, Some-Attr <= 100
         Callback-Number = "9,5512"

dialu1   Auth-Type := Local, Some-Attr >= 700
         Callback-Number = "9,5533"


    In this example I mean to reply Callback-Number depend on
    Some-Attr value. I can't map this example to rlm_sql! See:
    The DB schema for the radcheck and radreply tables:

CREATE TABLE radcheck      (
  id SERIAL,
  UserName VARCHAR(30) DEFAULT '' NOT NULL,
  Attribute VARCHAR(30),
  Value VARCHAR(40),
  op VARCHAR(2)            );

CREATE TABLE radreply      (
  id SERIAL,
  UserName VARCHAR(30) DEFAULT '' NOT NULL,
  Attribute VARCHAR(30),
  Value VARCHAR(40),
  op VARCHAR(2)            );


    And the following INSERT's must be executed for imitataion
    the first entry of the users file for user 'dialu1':

INSERT INTO radcheck (UserName,Attribute,Value,op) VALUES
('dialu1','Auth-Type','Local',':=');
INSERT INTO radcheck (UserName,Attribute,Value,op) VALUES
('dialu1','Some-Attr','100',  '<=');
INSERT INTO radreply (UserName,Attribute,Value,op) VALUES
('dialu1','Callback-Number','9,5512','=');

    Isn't it? I not sure, maybe 'Fall-Through' should be added also.

        But the problems starts when I want to add the second entry of
    the 'users' file - the DB's schema HAVE NOT any columns to
determinate
    isolated entries. If I misunderstood smth, please correct me.
        I offer to add additional column, for example,  EntryID
:Integer,
    which will devide several independent entries of the 'users' file.
        Is it true, that rlm_sql is not real substitution of the 'users'

    file? Thanks for any useful information or suggestions.



    Thanks. Ruslan

smime.p7s
Description: S/MIME Cryptographic Signature