After checking the sql.conf file, it really looks that all I need to do is to add the NASIPaddress to the "simul_count_query" query. Is it just that simple? Damn, and here was I thinking I would have to set three different accounting databases, worry about keeping them in synch, and handle three different sql.conf files. :-P
Thanks, I will try that. Marcos Roberto Greiner Chris Knipe wrote: > > Why not just optimise the SQL query to check for simultaneous users in > sql.conf? > > It's rather easy to just change the SQL query to suit your needs?? > > > > Regards, > Chris. > > ----- Original Message ----- From: "Roberto Greiner" > <[EMAIL PROTECTED]> > To: "FreeRadius users mailing list" > <freeradius-users@lists.freeradius.org> > Sent: Friday, August 25, 2006 4:20 PM > Subject: Simultaneous-Use question > > >> I'm intend to use Simultaneous-Use attribute to check logins for 3 >> different NAS. What I want to do is to allow 1 connection for each user >> in each box, at the same time. So, user1 should be able to connect to >> NAS1 and NAS2 at the same time, but not to NAS1 twice. For the user >> list I'm using the MYSQL with the default schema. >> >> If I understand it correctly (based on the /doc/Acct-Type file), to make >> this work I would have to create 3 Acct-Type entries in the Accounting >> section of radius.conf, and create 3 different sql.conf files, one for >> each Acct-Type, right? >> >> Also, does it work properly if I make all 3 sql.conf files point to the >> same database, using only different tables for accounting? Or did I get >> something wrong? >> >> Thank you for your help, >> >> Marcos Roberto Greiner >> >> -- >> ------------------------------------------------------------------- >> | Marcos Roberto Greiner | >> | | >> | Os otimistas acham que estamos no melhor dos mundos | >> | Os pessimistas tem medo de que isto seja verdade | >> | Murphy | >> ------------------------------------------------------------------- >> | [EMAIL PROTECTED] | >> ------------------------------------------------------------------- >> >> - >> List info/subscribe/unsubscribe? See >> http://www.freeradius.org/list/users.html >> > > - List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > -- ------------------------------------------------------------------- | Marcos Roberto Greiner | | | | Os otimistas acham que estamos no melhor dos mundos | | Os pessimistas tem medo de que isto seja verdade | | Murphy | ------------------------------------------------------------------- | [EMAIL PROTECTED] | ------------------------------------------------------------------- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html