Why do you need to do this. Why not write all the data to the same table, and alter your 'output' queries to pull out data on a per-NAS basis?
You might be able to rewrite the insert statement to insert into a different table. If you need it to go to two different databases, then you may want to set up two different daemons (on two different ports) each with completely different sql setups. Then point each NAS at a different port. This essentially sets up two standalone accounting servers. Tim > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:freeradius-users-admin@;lists.cistron.nl]On Behalf Of Igor de > Rooij > Sent: Monday, October 28, 2002 10:09 AM > To: [EMAIL PROTECTED] > Subject: SQL module/query per NAS > > > Hello, > > I am looking how to configure freeradius to use different accounting sql > modules/queries per NAS. > > basically i want to put something like this in my acct_users file : > > DEFAULT NAS-IP-Address == 10.0.0.1, Acct-Status-Type == Stop, > Auth-Type := SQL1 > DEFAULT NAS-IP-Address == 10.0.0.2, Acct-Status-Type == Stop, > Auth-Type := SQL2 > > and have accounting stop requests from nas 10.0.0.1 execute queries from > SQL1 and requests from nas 10.0.0.2 execute queries from SQL2 both > configured in sql.conf. > > needless to say this way with Auth-Type doesn't work with my > setup.. also i > couldn't find it in the FAQ or mailing list archive so i thought perhaps > someone on the list could show me how to set this up if it's at all > possible.. > > Thanks, > > Igor de Rooij > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html