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" <mrgreiner@gmail.com> 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 | ------------------------------------------------------------------- | rgreiner@usp.br | -------------------------------------------------------------------
- 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 | ------------------------------------------------------------------- | rgreiner@usp.br | -------------------------------------------------------------------