Hi Paul,
Yes, AuthBy SQL (like all AuthBy clauses takes an AddToReply parameter, which
is a comma separated list of attribute-value pairs. It will add those
attributes to _every_ reply. So if you have a common set of attributes, use
AddToReply.
There is also DefaultReply, which adds attributes to the reply if and only if
there arent some there already. So if you have some attributues that are common
to _most_ users, but not all, use DefaultReply.
One or the other should allow you to remove all those identical columns.
Hope that helps.
Cheers.
On Jun 7, 10:28am, Paul Gregg wrote:
> Subject: Re: (RADIATOR) static ip customers
>
> In message <[EMAIL PROTECTED]>,
> "Mike McCauley" <[EMAIL PROTECTED]> writes:
> | Yes, its pretty easy, but the way to do it depends on what type of databse
yo
> | u
> | have. Basically what you need to do is set up a reply item for the user
with
> | eg:
> | Framed-IP-Address=192.168.1.1
>
> While we're on this, perhaps I could ask something relivant to me.
>
> I have a MySQL db with > 4,000 users in it and Radiator is happily
> authing and accounting to it.
>
> However, as one of the table fields I have a misc_reply_items and I get
> a copy Radius Reply packet for each user.
>
> However, each user has exactly the same details (with the exception of about
5
> records - for people with static IPs).
>
> Is it possible to set a default Radius Reply list and have the db add to
> this default list or to replace entries which may be there?
>
> Paul.
> --
> Email pgregg at tibus.net | CLUB24 | Email pgregg at nyx.net |
> Technical Director | INTERNET | System Administrator |
> The Internet Business Ltd | Free Access | Nyx Public Access Internet |
> http://www.tibus.net | www.club24.co.uk | http://www.nyx.net |
>
> ===
> Archive at http://www.thesite.com.au/~radiator/
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
>-- End of excerpt from Paul Gregg
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
