On Mon, 14 Jul 2003 10:30 am, Peter Nixon wrote:MySQL - InnoBase Tables for authentication and accounting
Hi List
I would like to take a quick straw poll.
a) If you use a Database backend for FreeRadius which one do you use?
I use custom queries because we wanted to use an existing database to authenticate. I also added an "ACTIVE" field to our user table so that we could easily desactivate a user that doesn't pay. (added WHERE ACTIVE = 1 to the query).b) If you do not use a DB backend for FreeRadius, but do have a DB on your server or in your rack, what DB is it?
c) If you do not use a DB backend for FreeRadius, but do have a DB on your
server or in your rack, why don't you use it as a backend to FreeRadius?
d) If you do use a DB backend for FR do you use the default SQL queries that come with FR or have you written your own? If you wrote your own, would you mind sharing them with us (with a description please)?
I am going to add a table to blacklist CallingStationIDs that aren't allowed to connect no matter what password they use to keep out old users who cancelled to use their neighbor's / cousin's / mother-in-law's account.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
