On Thu, 13 Dec 2001, Mark Fawcus wrote:
> Hi,
>
> I've been playing with freeradius in conjunction with MySQL, and not knowing
> a huge amount about either, I hope someone here can offer some comments:
>
> I have a requirement to use more than one database, with one used for
> Authentication, and another used for Accounting, where the Accounting
> database name changes on a monthly basis.
>
> sql.conf seems to only have provision for one database name (radius_db),
> although queries can be aimed at different tables.
>
> Has anyone got any suggestions on how (or if) it is possible to achieve what
> I want?
>
> Mark
>
sql1.conf:
sql mysql1{
server="db1.my.company.com"
[...]
}
sql2.conf:
sql mysql2{
server="db2.my.company.com"
}
radiusd.conf:
modules{
[...]
$INCLUDE ${confdir}/sql1.conf
$INCLUDE ${confdir}/sql2.conf
}
authenticate{
mysql1
}
authorize{
mysql1
}
accounting{
mysql2
}
--
kkalev
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
