Hi , I try this :
AuthSelect select PASSWORD,TACACSGROUPID from SUBSCRIBERS and define AuthColumnDef 0, User-Password, check AuthColumnDef 1, OSC-Group-Identifier, reply I got ERR: Execute failed for 'select PASSWORD,TACACSGROUPID from SUBSCRIBERS': Unknown column 'TACACSGROUPID' in 'field list' In my Subscribers table there is no column like this.Do I need to change mysql schema ? -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Heikki Vatiainen Sent: 19 Kasım 2012 Pazartesi 23:33 To: [email protected] Subject: Re: [RADIATOR] group DEFAULT. No matching AuthorizeGroup rule On 11/19/2012 10:13 AM, Murat Bilal wrote: > <ServerTACACSPLUS> > GroupMemberAttr OSC-AVPAIR Hello Murat, note that you have set GroupMemberAttr to OSC-AVPAIR here. > <Handler> > <AuthBy SQL> > AuthColumnDef 1, OSC-Group-Identifier, reply Here you are adding OSC-Group-Identifier to the reply. Maybe this should be OSC-AVPAIR or alternatively you should have GropMemberAttr set to OSC-Group-Identifier in ServerTACACSPLUS. Also, since you have not changed AuthSelect from the default, you should select it to something like AuthSelect select PASSWORD,TACACSGROUPID from SUBSCRIBERS and define AuthColumnDef 0, User-Password, check AuthColumnDef 1, OSC-Group-Identifier, reply This will check the request password and and the desired group name to reply if password check succeeds. Thanks, Heikki -- Heikki Vatiainen <[email protected]> Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP, DIAMETER etc. Full source on Unix, Windows, MacOSX, Solaris, VMS, NetWare etc. _______________________________________________ radiator mailing list [email protected] http://www.open.com.au/mailman/listinfo/radiator _______________________________________________ radiator mailing list [email protected] http://www.open.com.au/mailman/listinfo/radiator
