Hi Rob,
On Apr 17, 11:47pm, Rob Thomas wrote:
> Subject: (RADIATOR) Ah. <Authby SQL> question..
>
> I've been plowing through radiator, and I'm pretty happy with it. Just going
> through and I don't seem to find any documentation on having a different
> database for authentication and accounting. Am I blind, or is it not there?
Its there, just a bit non-obvious
You wil need to set up 2 AuthBy SQL, each with slightly differetn setup. With
SQL, if you have an _empty string_ for the AuthSelect, it wont to do
authentication. If AcctTable is not defined, it wont do accounting, so:
<Realm DEFAULT>
AuthByPolicy ContinueWhileReject
# This one does accounting, but rejects all auths
<AuthBy SQL>
AuthSelect
AcctTable ACCOUNTING
DBSource dbi:mysql:db1
....
</AuthBy>
# THis one does auths, but not accounting
<AuthBy SQL>
AuthSelect whatever
DBSource dbi:mysql:db2
....
</AuthBy>
</Realm>
Hope that helps.
Cheers.
> Why, I hear you asking, do you want to do that?
>
> Well. I'm using MySQL and MySQL can't limit access per table, only per
> database. So, I'm going to have to set up two databases. One with only
> 'select' permissions (for authentcation), and the other with
> insert/update/delete permissions (for accounting - insert only, and
> simultaneous-use, requires insert, update(?) and delete.) So really, I need
> three databases. Or I need Oracle 8-)
>
> Anyone done this?
>
> --Rob
>
> ===
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
>-- End of excerpt from Rob Thomas
--
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, external, etc etc on Unix, Win95/8, NT, Rhapsody
===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
