freeradius + postgresql + realms + different databases for each realm

[trol anon]

I was wondering if anyone might be able to point me in the right direction
with regard to setting up freeradius with postgres so that each realm is
authenticated out of a separate database (on the same postgres server).

I understand that this might not be the best way to handle things, but for
historical and business reasons I find myself faced with the prospect
implementing this configuration.  I'm pretty much through the freeradius and
postgres installation and configuration, but I find myself unable to get my
head around breaking on each realm into a seperate database (yeah I can
duplicate the schema across seperate renamed databases) and then convince
freeradius to authenticate using those separate databases for each specific
realm.

I've STFW and archive(s) and found little documentation on how to accomplish
this particular config.

Thanks in advance for *any* tips, suggestions, links or outright tutorials
you might be able to provide...
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: freeradius + postgresql + realms + different databases for each realm

[Alan DeKok]

trol anon wrote:
 I was wondering if anyone might be able to point me in the right
 direction with regard to setting up freeradius with postgres so that
 each realm is authenticated out of a separate database (on the same
 postgres server).

  The SQL queries are configurable.  Just replace the database name with
%{Realm}, or whatever else is needed.

  Alan DeKok.
--
  http://deployingradius.com   - The web site of the book
  http://deployingradius.com/blog/ - The blog
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html