Attribute,Value,op fields are not specific to my case, they included in FreeRadius default SQL schema. SQL schema in its turn is trying to mimic "users" file in the way it defines users. '"users" file format is derived from cistron/livingston, and goes like: Username "check values" "reply values" Since attribute is "Password", op is "==", value is "gw1" we will get the line : gw1 Password == "gw1" This means that for user gw1 password has to be "gw1", othervise access will be denied. Since for AliasAuth username is by default the same as gw1 it will always match so access will be granted. You can use this to enter wrong password for denied destinations so the calls will be denied. More doc's on the topic could be found in the FreeRadius distribution itself. Julius -----Original Message----- From: Andrey S Pankov [mailto:casper@kbuapa.kharkov.ua] Sent: Tuesday, October 07, 2003 5:50 PM To: openh323gk-users@lists.sourceforge.net Subject: Re: Call controll: PrefixAuth and Q931 Setup > 4. modify sql.conf : > authorize check query = "SELECT id,UserName,Attribute,Value,op FROM > ${authcheck table} WHERE Username = '%{SQL-User-Name}' AND IP = > '%{Framed-IP-Address}' AND '%{Called-Station-Id}' REGEXP REG ORDER BY id > LIMIT 1" Can you please explain how do you use Attribute,Value,op fields? -- Best regards, Andrey S Pankov. ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ List: Openh323gk-users@lists.sourceforge.net Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 Homepage: http://www.gnugk.org/ ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ List: Openh323gk-users@lists.sourceforge.net Archive: http://sourceforge.net/mailarchive/forum.php?forum_id?49 Homepage: http://www.gnugk.org/
