Re: FR 3.0.x Head + coova chilli + mysql Volume Limit
need advice please as to what am i doing wrong On Wed, Oct 29, 2014 at 6:19 PM, Abdullah <b.hawks123@gmail.com> wrote:
log showing how user logged in on 3 separate occasions and was able to continue using data despite crossing 4gb limit since previous sessions record isnt taken into consideration. But once he uses up 4gb on one single session, he gets disconnected and cant login again
Abdullah wrote:
need advice please as to what am i doing wrong
Read the debug output. The server looks in SQL for the user, and then runs the dailycounter module. The Max-Daily-Session attribute isn't found by the counter module. So... that attribute isn't being returned from SQL. You can run the queries yourself to see what is being returned from SQL. The debug output shows you the queries. It's not difficult. Set the Max-Daily-Session attribute in the "users" file, and it will work. Therefore, it should also work with SQL. If it doesn't work with SQL, it's because you configured SQL wrong. Alan DeKok.
Sorry my problem is persisting. I need your help. Kindly reply please I have Set up qouta of 5GB for a user He downloads 2 GB and disconnects When he logins again, he should disconnect after 3GB but he doesnt get disconnected rather he gets disconnected after 5Gb I think NAS only stores volume for current session and freeradius has the db which saves all session's volume. On Thu, Oct 30, 2014 at 12:27 AM, Alan DeKok <aland@deployingradius.com> wrote:
Abdullah wrote:
need advice please as to what am i doing wrong
Read the debug output. The server looks in SQL for the user, and then runs the dailycounter module. The Max-Daily-Session attribute isn't found by the counter module.
So... that attribute isn't being returned from SQL.
You can run the queries yourself to see what is being returned from SQL. The debug output shows you the queries.
It's not difficult. Set the Max-Daily-Session attribute in the "users" file, and it will work. Therefore, it should also work with SQL. If it doesn't work with SQL, it's because you configured SQL wrong.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
You should run freeRadius in debbuging mode and look what attributes are sent to NAS. I have a feeling that you have "hard-coded" the limit which is sent back to the NAS instead of sending the limit minus quota usage (which is again read from the db). Basically, check you SQL configuration (as Alan DeKok already wrote). Kind regards, E:S On 30.10.2014 08:14, Abdullah wrote:
Sorry my problem is persisting. I need your help. Kindly reply please I have Set up qouta of 5GB for a user He downloads 2 GB and disconnects When he logins again, he should disconnect after 3GB but he doesnt get disconnected rather he gets disconnected after 5Gb I think NAS only stores volume for current session and freeradius has the db which saves all session's volume.
On Thu, Oct 30, 2014 at 12:27 AM, Alan DeKok <aland@deployingradius.com <mailto:aland@deployingradius.com>> wrote:
Abdullah wrote: > need advice please as to what am i doing wrong
Read the debug output. The server looks in SQL for the user, and then runs the dailycounter module. The Max-Daily-Session attribute isn't found by the counter module.
So... that attribute isn't being returned from SQL.
You can run the queries yourself to see what is being returned from SQL. The debug output shows you the queries.
It's not difficult. Set the Max-Daily-Session attribute in the "users" file, and it will work. Therefore, it should also work with SQL. If it doesn't work with SQL, it's because you configured SQL wrong.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
i have set the quota limit attribute to a user What i get from queries.conf files is that every time a new record is added, it is putting in 0 for acctinput and acctoutput octets Does that need to be changed some how? On Thu, Oct 30, 2014 at 2:38 PM, "Edvin Seferovic | Kolpinghaus St. Pölten" <edvin.seferovic@kolp.at> wrote:
You should run freeRadius in debbuging mode and look what attributes are sent to NAS. I have a feeling that you have "hard-coded" the limit which is sent back to the NAS instead of sending the limit minus quota usage (which is again read from the db).
Basically, check you SQL configuration (as Alan DeKok already wrote).
Kind regards, E:S
On 30.10.2014 08:14, Abdullah wrote:
Sorry my problem is persisting. I need your help. Kindly reply please I have Set up qouta of 5GB for a user He downloads 2 GB and disconnects When he logins again, he should disconnect after 3GB but he doesnt get disconnected rather he gets disconnected after 5Gb I think NAS only stores volume for current session and freeradius has the db which saves all session's volume.
On Thu, Oct 30, 2014 at 12:27 AM, Alan DeKok <aland@deployingradius.com <mailto:aland@deployingradius.com>> wrote:
Abdullah wrote: > need advice please as to what am i doing wrong
Read the debug output. The server looks in SQL for the user, and then runs the dailycounter module. The Max-Daily-Session attribute isn't found by the counter module.
So... that attribute isn't being returned from SQL.
You can run the queries yourself to see what is being returned from SQL. The debug output shows you the queries.
It's not difficult. Set the Max-Daily-Session attribute in the "users" file, and it will work. Therefore, it should also work with SQL. If it doesn't work with SQL, it's because you configured SQL wrong.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html
I have a feeling that you have "hard-coded" the limit which is sent back to the NAS instead of sending the limit minus quota usage (which is again read from the db) How do i achieve this? i.e. to send limit minus quota usage? On Thu, Oct 30, 2014 at 2:38 PM, "Edvin Seferovic | Kolpinghaus St. Pölten" <edvin.seferovic@kolp.at> wrote:
You should run freeRadius in debbuging mode and look what attributes are sent to NAS. I have a feeling that you have "hard-coded" the limit which is sent back to the NAS instead of sending the limit minus quota usage (which is again read from the db).
Basically, check you SQL configuration (as Alan DeKok already wrote).
Kind regards, E:S
On 30.10.2014 08:14, Abdullah wrote:
Sorry my problem is persisting. I need your help. Kindly reply please I have Set up qouta of 5GB for a user He downloads 2 GB and disconnects When he logins again, he should disconnect after 3GB but he doesnt get disconnected rather he gets disconnected after 5Gb I think NAS only stores volume for current session and freeradius has the db which saves all session's volume.
On Thu, Oct 30, 2014 at 12:27 AM, Alan DeKok <aland@deployingradius.com <mailto:aland@deployingradius.com>> wrote:
Abdullah wrote: > need advice please as to what am i doing wrong
Read the debug output. The server looks in SQL for the user, and then runs the dailycounter module. The Max-Daily-Session attribute isn't found by the counter module.
So... that attribute isn't being returned from SQL.
You can run the queries yourself to see what is being returned from SQL. The debug output shows you the queries.
It's not difficult. Set the Max-Daily-Session attribute in the "users" file, and it will work. Therefore, it should also work with SQL. If it doesn't work with SQL, it's because you configured SQL wrong.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html
i thought maybe my counter has the issue so i use default provided dailycounter set session-timeout to 120 and login, user disconnects after 34 seconds next the user logins again and instead of getting disconnected after 84 odd sweconds gets disconnected after 120. how can i update nas with limit-used time? log is attached please help On Thu, Oct 30, 2014 at 12:27 AM, Alan DeKok <aland@deployingradius.com> wrote:
Abdullah wrote:
need advice please as to what am i doing wrong
Read the debug output. The server looks in SQL for the user, and then runs the dailycounter module. The Max-Daily-Session attribute isn't found by the counter module.
So... that attribute isn't being returned from SQL.
You can run the queries yourself to see what is being returned from SQL. The debug output shows you the queries.
It's not difficult. Set the Max-Daily-Session attribute in the "users" file, and it will work. Therefore, it should also work with SQL. If it doesn't work with SQL, it's because you configured SQL wrong.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (3)
-
"Edvin Seferovic | Kolpinghaus St. Pölten" -
Abdullah -
Alan DeKok