At 07:32 PM 12/13/2001 -0600, 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?
sql.conf ( just like the rest of the radiusd.conf ) allows you define multiple named modules. It currently only defines one, but you could very easily define a second, different named module. See the radiusd.conf file for examples on how to define multiple named instances ( it's done for the 'realm' module ). -Chris -- \\\|||/// \ Chris Parker - Manager, Development Engineering \ ~ ~ / \ WX *is* Wireless! \ [EMAIL PROTECTED] | @ @ | \ http://www.starnetwx.net \ (847) 963-0116 oOo---(_)---oOo--\------------------------------------------------------ \ Without C we would have 'obol', 'basi', and 'pasal' - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html