Hello Cliff -
On Wed, 09 Aug 2000, Cliff Cole wrote:
> Hello All,
> I'm rather new to Radiator so bare with me please. I am trying to get
> Radiator to authenticate using Authby SQL. The authentication work fine
> with the username and password. I also want this to implement a port 25
> filter. I have read the the documentation that you use a sting
> 'AuthColumnDef n' to let the select statement read the other fields in my
> table. I have five fields, username, password, encryptedpassword,
> checkattr, and replyattr. I am not sure which field the
> 'Ascend-Data-Filter' string would insert into. I now have it in ReplyAttr
> field. I have switched it back and forth from the replyattr to the
> checkattr and still am unable to block port 25 connection. I really am not
> sure about where the 'AuthColumnDef n' string should be either. Thanks for
> all the help
>
There are three things that you need to do: first, you need to put the
"Ascend-Data-Filter' (together with any other reply attributes) into the
replyattr field like this:
Ascend-Data-Filter = ....., .....
Then you have to provide an SQL query in the Radiator configuration file to
return the relevant fields from your database something like this:
AuthSelect select PASSWORD, CHECKATTR, REPLYATTR from \
SUBSCRIBERS where USERNAME = '%n'
And finally you have to define your AuthColumnDef's:
AuthColumnDef 0, User-Password, check
AuthColumnDef 1, GENERIC, check
AuthColumnDef 2, GENERIC, reply
Have a look at section 6.25.7 in the Radiator 2.16.1 reference manual.
hth
Hugh
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
