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