Simutaneus Check Query in FR2?
Hi, Currently my "Simultaneous-Use" attribute is not working and I have few questions regarding this. Following are my setup: ================ OS: CentOS 5.3 freeradius2-2.1.6 MySQL 5.0.45 PERL 5.8.8 =============== I am consulting the FAQ checklist. Some are not applicable to me since I am doing everything from SQL. 1) FAQ says "uncheck the Simutaneus check query in sql.conf" but I couldn't find that in in my sql.conf. Where is this in FR2? 2) in "/etc/raddb/sites-enable/default" I noticed that "radutmp" is uncommented by default in "session" and "accounting" section. I tried disabling this but no effect on simultaneous use. Do I need to turn on "radutmp" for something else (like for "radwho"? (What I mean is does any other part the freeradius use this feature for session and accounting purpose? Is it necessary to turn on this feature if I am using SQL for my session and accounting?) 3) I am trying to use "radwho" and it is giving me the error ========== "radwho: Error reading /var/log/radius/sradutmp: No such file or directory". ========== It is looking for "sradutmp" instead of "radutmp" which is not there. I guess probably it has its historical reasons. May be I can solve this my renaming the "radutmp" to "sradutmp" but I am not sure if I want to do that. 4) What are the other things I need to look for to solve this problem? Some suggestions greatly appreciated Thanks -- ============================== Registered Linux User #460714 Currently Using Fedora 10, CentOS 5.3 ==============================
Hi,
Currently my "Simultaneous-Use" attribute is not working and I have few questions regarding this.
Following are my setup: ================ OS: CentOS 5.3 freeradius2-2.1.6 MySQL 5.0.45 PERL 5.8.8 ===============
I am consulting the FAQ checklist. Some are not applicable to me since I am doing everything from SQL.
1) FAQ says "uncheck the Simutaneus check query in sql.conf" but I couldn't find that in in my sql.conf. Where is this in FR2?
You are looking for in the wrong directory. In FR2 the SQL queries are in sql/mysql/dialup.conf. In this file you will find the simulaneus-use queries.
2) in "/etc/raddb/sites-enable/default" I noticed that "radutmp" is uncommented by default in "session" and "accounting" section. I tried disabling this but no effect on simultaneous use. Do I need to turn on "radutmp" for something else (like for "radwho"? (What I mean is does any other part the freeradius use this feature for session and accounting purpose? Is it necessary to turn on this feature if I am using SQL for my session and accounting?)
This service is check using SQL queries in radacct table. Think that all checks are in the Database and not in files.
3) I am trying to use "radwho" and it is giving me the error ========== "radwho: Error reading /var/log/radius/sradutmp: No such file or directory". ========== It is looking for "sradutmp" instead of "radutmp" which is not there. I guess probably it has its historical reasons. May be I can solve this my renaming the "radutmp" to "sradutmp" but I am not sure if I want to do that.
4) What are the other things I need to look for to solve this problem?
Some suggestions greatly appreciated
Thanks
-- ============================== Registered Linux User #460714 Currently Using Fedora 10, CentOS 5.3 ============================== - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
_________________________________________________________________ Internet Explorer 8 más sencillo y seguro ¡Descárgatelo gratis! http://events.es.msn.com/noticias/internet-explorer-8/
You are looking for in the wrong directory. In FR2 the SQL queries are in sql/mysql/dialup.conf. In this file you will find the simulaneus-use queries.
Thanks for the quick reply. This solved the problem. What about the "radutmp" thing? Do I need to leave it uncommented or disable it in "default" file since I am using SQL? Thanks -- ============================== Registered Linux User #460714 Currently Using Fedora 10, CentOS 5.3 ==============================
Date: Tue, 4 Aug 2009 14:42:55 +0800 Subject: Re: Simutaneus Check Query in FR2? From: d88pak@gmail.com To: freeradius-users@lists.freeradius.org
You are looking for in the wrong directory. In FR2 the SQL queries are in sql/mysql/dialup.conf. In this file you will find the simulaneus-use queries.
Thanks for the quick reply. This solved the problem. What about the "radutmp" thing? Do I need to leave it uncommented or disable it in "default" file since I am using SQL?
I think you do not understand why you use radutmp. If you use a DB system, then you needn't use a flat file for save the session log. Look at radacct table. _________________________________________________________________ Entérate de todas las noticias al instante ¡Suscríbete al servicio de Alertas MSN! http://especiales.es.msn.com/noticias/msninforma.aspx
I think you do not understand why you use radutmp. If you use a DB system, then you needn't use a flat file for save the session log. Look at radacct table.
Thanks. I understand that but I was just concerned about unwanted side effects if in case other tools are using that. I got the idea. Thanks again -- ============================== Registered Linux User #460714 Currently Using Fedora 10, CentOS 5.3 ==============================
participants (2)
-
Deepak -
Santiago Balaguer García