SQL Counter for Expiration Attribute - Prepaid Cards

2013-01-01 Thread Prabhpal S. Mavi
afternoon etc..). i understand i would need sql_counter to achieve. I am trying but not working. my configuration. 1.) Created Counter: sqlcounter expiration { count-attribute = Acct-Session-Time counter-name = Max-Allowed-Session check-name = Expiration

Re: SQL Counter for Expiration Attribute - Prepaid Cards

2013-01-01 Thread Mulindwa
to achieve. I am trying but not working. my configuration. 1.) Created Counter: sqlcounter expiration { count-attribute = Acct-Session-Time counter-name = Max-Allowed-Session check-name = Expiration sqlmod-inst = sql key

Re: SQL Counter for Expiration Attribute - Prepaid Cards

2013-01-01 Thread Prabhpal S. Mavi
Hi there, You can use the frontend tool called daloradius, it will sort you out in what you are trying to achieve, it uses freeradius as the back end. -- On Tue, Jan 1, 2013 12:01 PM MSK Prabhpal S. Mavi wrote: Dear Mulindwa, Thanks for your response. I am

Re: SQL Counter for Expiration Attribute - Prepaid Cards

2013-01-01 Thread A . L . M . Buxey
Hi, Dear List Members, people read this list. you do yourself no favours by repeating the same question all the time. you have been given advice but appear to want someone to do all the work for you. there are companies/consultants that can deliver the product that you need. alan - List

sql counter Re:

2012-12-07 Thread Alan DeKok
Jed Gainer wrote: /etc/raddb/sql/mysql/counter.conf there is %b unix time value of beginning of reset period ... how would i get the value of %b for a user from say PHP so i can calc and show them how much bandwidth they have left? Query the database. The schema is available.

Re: sql counter Re:

2012-12-07 Thread Jed Gainer
I looked though the SQL database. I don't see anything related to %b. On Fri, Dec 7, 2012 at 4:03 AM, Alan DeKok al...@deployingradius.com wrote: Jed Gainer wrote: /etc/raddb/sql/mysql/counter.conf there is %b unix time value of beginning of reset period ... how would i get the value

Re: sql counter Re:

2012-12-07 Thread Jed Gainer
%b is the unix time stamp of 8am on current day. mktime(8, 0, 0) in PHP seems to generate the same value as %b if anyone has this same question. :) On Fri, Dec 7, 2012 at 9:11 AM, Jed Gainer jedgai...@gmail.com wrote: I looked though the SQL database. I don't see anything related to %b. On

Create a counter for Max-Single-Session

2012-04-04 Thread Lorenzo Milesi
Hi. Is it possible to create a counter which limits the single session of a user? I'd like to create a generic temporary access, and a session should last for few minutes max. thanks -- Lorenzo Milesi - lorenzo.mil...@yetopen.it GPG/PGP Key-Id: 0xE704E230 - http://keyserver.linux.it - List

Re: Create a counter for Max-Single-Session

2012-04-04 Thread Alan DeKok
Lorenzo Milesi wrote: Hi. Is it possible to create a counter which limits the single session of a user? See the counter module. I'd like to create a generic temporary access, and a session should last for few minutes max. That will be hard. Many NASes will support a minimum of 10 min

Re: Create a counter for Max-Single-Session

2012-04-04 Thread Matthew Newton
On Wed, Apr 04, 2012 at 05:50:01PM +0200, Lorenzo Milesi wrote: Is it possible to create a counter which limits the single session of a user? I'd like to create a generic temporary access, and a session should last for few minutes max. Assuming your NAS supports it, you should be able to do

Re: rlm_sqlcounter doesn't increase counter

2012-03-05 Thread pamela pomary
code rlm_counter: Searching the database for key 'clare' rlm_counter: Key Found. rlm_counter: Check item = 240, Count = 2386 rlm_counter: Rejected user clare, check_item=240, counter=2386 modcall[authorize]: module daily returns reject for request 0 modcall: leaving group authorize (returns reject

Re: rlm_sqlcounter doesn't increase counter

2012-02-29 Thread pamela pomary
Hello Alan, logins for Cisco wont do decent accounting for login sessions - for authenticated sessions on edge ports they can sent accounting...eg aaa accounting dot1x default start-stop group RADIUS alan Sorry, I didn't quiet understand your submission.Please are you saying Cisco 2960

Re: rlm_sqlcounter doesn't increase counter

2012-02-29 Thread Alan Buxey
Hi, logins for Cisco wont do decent accounting for login sessions - for authenticated sessions on edge ports they can sent accounting...eg aaa accounting dot1x default start-stop group RADIUS did you read what I typed? I dont see a line like this inyour provided config -

Re: rlm_sqlcounter doesn't increase counter

2012-02-29 Thread pamela pomary
. But counter doesn't increase.Users are not logged off when they reach their Maximum Daily session. #Radius Debug# rlm_sqlcounter: (Check item - counter) is greater than zero rlm_sqlcounter: Authorized user clare, check_item=120, counter=0 rlm_sqlcounter: Sent Reply-Item for user clare

Re: rlm_sqlcounter doesn't increase counter

2012-02-29 Thread Fajar A. Nugraha
On Wed, Feb 29, 2012 at 8:29 PM, pamela pomary ppom...@gmail.com wrote: But counter doesn't increase.Users are not logged off when they reach their Maximum Daily session. #Radius Debug# rlm_sqlcounter: (Check item - counter) is greater than zero rlm_sqlcounter: Authorized user

Re: rlm_sqlcounter doesn't increase counter

2012-02-28 Thread pamela pomary
I have sql declared in accounting module. I have followed examples from http://wiki.freeradius.org/Rlm_sqlcounter, but my counter doesn't still increase.? What am I missing please. Do you have accounting records for that user in radacct? mmm. no Fajar, I have checked from mysql and do

Re: rlm_sqlcounter doesn't increase counter

2012-02-28 Thread Fajar A. Nugraha
On Tue, Feb 28, 2012 at 9:32 PM, pamela pomary ppom...@gmail.com wrote:    I have sql declared in accounting module. I have followed examples from http://wiki.freeradius.org/Rlm_sqlcounter, but my counter doesn't still increase.? What am I missing please. Do you have accounting records

Re: rlm_sqlcounter doesn't increase counter

2012-02-28 Thread pamela pomary
examples from http://wiki.freeradius.org/Rlm_sqlcounter, but my counter doesn't still increase.? What am I missing please. Do you have accounting records for that user in radacct? mmm. no Fajar, I have checked from mysql and do not have any record for service type= Framed

Re: rlm_sqlcounter doesn't increase counter

2012-02-28 Thread Fajar A. Nugraha
On Tue, Feb 28, 2012 at 10:30 PM, pamela pomary ppom...@gmail.com wrote: What could be the reason why accounting records are not captured in radacct for a Framed-User? Does your NAS send accounting packets? Yes i found some accounting packets, but only for telnet logins users. My NAS

Re: rlm_sqlcounter doesn't increase counter

2012-02-28 Thread Alan Buxey
Hi, logins for Cisco wont do decent accounting for login sessions - for authenticated sessions on edge ports they can sent accounting...eg aaa accounting dot1x default start-stop group RADIUS alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: rlm_sqlcounter doesn't increase counter

2012-02-27 Thread pamela pomary
Hello Alan, Thanks for your response. Sorry I did not include accounting module of radiusd.conf. I have sql declared in accounting module. I have followed examples from http://wiki.freeradius.org/Rlm_sqlcounter, but my counter doesn't still increase. What am I missing please

Re: rlm_sqlcounter doesn't increase counter

2012-02-27 Thread Fajar A. Nugraha
counter doesn't still increase.  What am I missing please. Do you have accounting records for that user in radacct? -- Fajar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

rlm_sqlcounter doesn't increase counter

2012-02-24 Thread pamela pomary
Hello Fellow Freeradius-Users, I have freeradius-1.1.3 installed on Cent OS and I have Cisco C2960 switch as my NAS. I have a task to allocate browsing time 2hrs per day to students in our computer labs. Logs from radius in debug mode, counter doesn't increase it always shows (Check item

Re: rlm_sqlcounter doesn't increase counter

2012-02-24 Thread Alan Buxey
hi, you dont seem to have SQL enabled in the accounting section... the WIKI entry should work http://wiki.freeradius.org/Rlm_sqlcounter alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Possibility to create a counter for traffic volume WITHOUT sql ?

2012-02-16 Thread Alan DeKok
Nachtfalke wrote: Then I thought I could just simple make a traffic counter with this module and I did that: NASes doesn't do traffic counters. The only way to enforce traffic counters is the *next* time that the user logs in. So once the user is logged in, they can download as much

Possibility to create a counter for traffic volume WITHOUT sql ?

2012-02-15 Thread Nachtfalke
Hi, I am using freeradius 2.1.12 and the rlm_counter module for counting amount of time. So an user has got only 60min per day, week, month or forever. As far as I can see that this is working as it should. User cannot reconnect if he used more time than allowed. This is how my counter module

counter daily

2011-07-25 Thread Angus JIANG Jian
Dear all, Can you give me an example of how to set the cache-size ? This is my config for the counter. counter daily { filename = ${raddbdir}/db.daily key = User-Name count-attribute = Acct-Session-Time reset = daily

Counter info while proxying

2011-03-21 Thread Rajkumar R
Hi All, I would like to know if there's a counter associated with the radius server to keeptrack of the incoming messages arrived. As I'm using a proxy setup with 5 homeservers connected, this info is needed to show on the statistics of loadbalancing activity. Appreciate all your inputs

Re: Counter info while proxying

2011-03-21 Thread Phil Mayers
On 21/03/11 12:04, Rajkumar R wrote: Hi All, I would like to know if there’s a counter associated with the radius server to keeptrack of the incoming messages arrived. As I’m using a proxy setup with 5 homeservers connected, this info is needed to show on the statistics of loadbalancing

Re: SQL Counter Escape String !

2011-03-16 Thread Suman Dash
that i sent you a mail. I am having a nightmare and accidently i clicked Send All instead of selecting the mailing list. sqlcounter monthlycounter { counter-name = Monthly-Session-Time check-name = Max-Monthly-Session reply-name = Session-Timeout

Re: SQL Counter Escape String !

2011-03-16 Thread Alan DeKok
Suman Dash wrote: Hi Alan, Did you managed to look into the issue ? No. or maybe any hints on how to use DATETIME in Expiration instead of String ? Honestly, in 2.1.10, you can just write SELECT statements directly in unlang. update reply { Session-Timeout :=

Re: SQL Counter Escape String !

2011-03-16 Thread Suman Dash
Much thanks Alan, That was some really good advice on how to make the thing work. So now i have to write unlang statement in preprocess so that it directly gives the Session-Timeout . Please correct me if i am wrong. Thanks Again On 3/16/2011 4:09 PM, Alan DeKok wrote: Suman Dash wrote:

Re: SQL Counter Escape String !

2011-03-15 Thread Alan DeKok
.nabble.com/Changing-the-format-of-a-date-attribute-tt2775323.html#a2775328 sigh What's wrong with reading the documentation? But no luck .. My Entire Counter is : ... which doesn't follow the escaping rules of either the above message, or the documentation. Alan DeKok. - List info

Re: SQL Counter Escape String !

2011-03-15 Thread Suman Dash
://freeradius.1045715.n5.nabble.com/Changing-the-format-of-a-date-attribute-tt2775323.html#a2775328  sigh  What's wrong with reading the documentation? But no luck .. My Entire Counter is :  ... which doesn't follow the escaping rules of either the above message, or the documentation.  Alan DeKok

Re: SQL Counter Escape String !

2011-03-15 Thread Suman Dash
wrong with reading the documentation? But no luck .. My Entire Counter is : ... which doesn't follow the escaping rules of either the above message, or the documentation. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe

Re: SQL Counter Escape String !

2011-03-15 Thread Alan DeKok
Suman Dash wrote: I have tried almost all sql escape but looks like none are working or maybe i am missing something. I am stuck in this issue for more than 3 days and now i don't have any clue due to which i am trying to reach for help on the mailing list. Hmm... the issue seems to be that

Re: SQL Counter Escape String !

2011-03-15 Thread Suman Dash
) mysql Counter.SQL sqlcounter monthlycounter { counter-name = Monthly-Session-Time check-name = Max-Monthly-Session reply-name = Session-Timeout sqlmod-inst = sql key = User-Name reset = never query

Re: SQL Counter Escape String !

2011-03-15 Thread Alan DeKok
Suman Dash wrote: sqlcounter monthlycounter { ... WHERE username = '%{%k}' AND attribute = 'Activation'), 'd M Y H:i:s')) \ The debug log doesn't show that this string is being used. And *again* you delete large amounts of the debug log. Why? It

Re: SQL Counter Escape String !

2011-03-15 Thread Suman Dash
Dear Alan, I have not removed any debug messages. I will try to put everything once again . I was not aware that i sent you a mail. I am having a nightmare and accidently i clicked Send All instead of selecting the mailing list. sqlcounter monthlycounter { counter-name = Monthly

Re: SQL Counter Escape String !

2011-03-15 Thread Suman Dash
Hi Alan, Looks like i am getting some meaningful debugs in fr-2.1.10. Undermentioned are the Counter and Debug Messages. I used %% escape but in the query it's '%d %M %Y %H:%i:%s' . Seems like that's how escaping works. I assumed that i needed to add more % but adding more doesn't help

Re: SQL Counter Escape String !

2011-03-15 Thread suman
Is it possible to change the date of Expiration to DATETIME rather than String ? Expiration Attribute is unable to parse a DATETIME but is able to parse a String 10 Jan 2011 Is Parsed 2011-01-10 Unable to Parse Reason is that i want to run a counter which will pick the Expiration

SQL Counter Logic !

2011-03-15 Thread suman
Is it possible to change the date of Expiration to DATETIME rather than String ? Expiration Attribute is unable to parse a DATETIME but is able to parse a String 10 Jan 2011 Is Parsed 2011-01-10 Unable to Parse Reason is that i want to run a counter which will pick the Expiration

String Escape in SQL Counter !

2011-03-14 Thread Suman Dash
-of-a-date-attribute-tt2775323.html#a2775328 But no luck .. My Entire Counter is : query = SELECT SUM(acctsessiontime) FROM tbl_acct where \ username = 'suman' AND acctstarttime BETWEEN \ (SELECT STR_TO_DATE((SELECT value FROM tbl_check \ WHERE username

SQL Counter Escape String !

2011-03-14 Thread Suman Dash
-of-a-date-attribute-tt2775323.html#a2775328 But no luck .. My Entire Counter is : query = SELECT SUM(acctsessiontime) FROM tbl_acct where \ username = 'suman' AND acctstarttime BETWEEN \ (SELECT STR_TO_DATE((SELECT value FROM tbl_check \ WHERE username

Re: reset sql counter every 30 minute

2011-01-27 Thread Bishal Pun
| +-+---+-++-+---+ Regards Bishal On Thu, Jan 27, 2011 at 1:34 PM, piston pisto...@yahoo.com wrote: Hi Is that possible to reset the sql counter every 30 minute? Basically, i need to get user free access of 20 minutes, after 20 minutes NAS

Re: reset sql counter every 30 minute

2011-01-27 Thread Christ Schlacta
On 1/26/2011 23:49, piston wrote: Hi Is that possible to reset the sql counter every 30 minute? Basically, i need to get user free access of 20 minutes, after 20 minutes NAS will logout the user. And the user is allow to login again after 30 minute. Thanks - List info/subscribe

reset sql counter every 30 minute

2011-01-26 Thread piston
Hi Is that possible to reset the sql counter every 30 minute? Basically, i need to get user free access of 20 minutes, after 20 minutes NAS will logout the user. And the user is allow to login again after 30 minute. Thanks - List info/subscribe/unsubscribe? See http

Re: Counter SQL Calculation

2010-11-04 Thread Neville
Can anyone please help on this as I've googled as cannot find a solution to the issue I've outlined below. Thx Nev Hi Everyone, Here is some Debug if anyone can help explain or correct the [monthlytraffic] Counter calculation. Sat Oct 30 22:39:39 2010 : Info: [monthlytraffic] expand

Re: Counter SQL Calculation

2010-10-30 Thread Neville
Hi Everyone, Here is some Debug if anyone can help explain or correct the [monthlytraffic] Counter calculation. Sat Oct 30 22:39:39 2010 : Info: [monthlytraffic] expand: SELECT IFNULL((sum(acctinputoctets)+sum(acctoutputoctets)),0) FROM radacct WHERE username='%{User-Name}' AND Month

Re: Counter SQL Calculation

2010-10-25 Thread Neville
Anyone got any pointers at all on this one? Thx Nev - Original Message - From: Neville n...@itsnev.co.uk To: freeradius-users@lists.freeradius.org Sent: Wednesday, October 20, 2010 5:14 PM Subject: Counter SQL Calculation Hi everyone, I have a small problem where the counter

Counter SQL Calculation

2010-10-20 Thread Neville
Hi everyone, I have a small problem where the counter is not working how I would like it two work. sqlcounter monthlytraffic { counter-name = Monthly-Traffic check-name = Max-Monthly-Traffic reply-name = Session-Octets-Limit sqlmod-inst

Max-All-Session counter module problem

2009-08-30 Thread Bishal Pun
socket id: 0 [noresetcounter]expand: %{sql:SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='sneha'} - 90001 rlm_sqlcounter: (Check item - counter) is less than zero rlm_sqlcounter: Rejected user sneha, check_item=9, counter=90001 ++[noresetcounter] returns reject Invalid user

Max-All-Session counter module problem[SOLVED]

2009-08-30 Thread Bishal Pun
socket id: 0 [noresetcounter] sql_xlat finished rlm_sql (sql): Released sql socket id: 0 [noresetcounter]expand: %{sql:SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='sneha'} - 90001 rlm_sqlcounter: (Check item - counter) is less than zero rlm_sqlcounter: Rejected user sneha

Re: Statistic Counter

2009-05-26 Thread Alan DeKok
Marco De Magistris wrote: Can I enable other counters for AuthRadiusClientAccessRetransmissions, AuthRadiusClientTimeouts, AuthRadiusClientCounterDiscontinuity)? The server does not currently track those statistics. As always, patches are welcome. Or I should use “counter” module

Statistic Counter

2009-05-25 Thread Marco De Magistris
auths: 0 Can I enable other counters for AuthRadiusClientAccessRetransmissions, AuthRadiusClientTimeouts, AuthRadiusClientCounterDiscontinuity)? Or I should use counter module of FreeRadius? RadiusClientAccessRetransmissions The number of RADIUS Access-Request

R: Sql Counter reads only the first 4 digits

2009-05-21 Thread Mauro Iorio - Smart Soft s.r.l.
Uh... no. If it works for Ivan, then the problem is most likely in the unixodbc drivers. Alan DeKok. But when I run the same query in both isql and tsql the result is correct. So I think that unixodbc and freetds are ok. I'll try to recompile them anyway... Other ideas?

Re: R: Sql Counter reads only the first 4 digits

2009-05-21 Thread Alan DeKok
Mauro Iorio - Smart Soft s.r.l. wrote: But when I run the same query in both isql and tsql the result is correct. So I think that unixodbc and freetds are ok. I'll try to recompile them anyway... Other ideas? Instrument the FreeRADIUS source code. Follow the data from SQL, through the

Sql Counter reads only the first 4 digits

2009-05-20 Thread Mauro Iorio - Smart Soft s.r.l.
Hi all, I've a strange problem with sql counter on freeradius both 1.1.7 and 2.1.5 versions. Actually executing SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='mauro' from SQL Server Management Studio gives me 294841 (Yes, that's a lot of seconds, is a test user) while

Re: Sql Counter reads only the first 4 digits

2009-05-20 Thread Alan DeKok
Mauro Iorio - Smart Soft s.r.l. wrote: I’ve a strange problem with sql counter on freeradius both 1.1.7 and 2.1.5 versions. Actually executing SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='mauro' What happens when you replace that SELECT statement with a hard-coded number

R: Sql Counter reads only the first 4 digits

2009-05-20 Thread Mauro Iorio - Smart Soft s.r.l.
WHERE UserName= 'mauro'} - 1234 rlm_sqlcounter: Check item is greater than query result rlm_sqlcounter: Authorized user mauro, check_item=3600, counter=1234 rlm_sqlcounter: Sent Reply-Item for user mauro, Type=Session-Timeout, value=2366 ++[sessioncounter] returns ok WARNING: Please update your

Re: R: Sql Counter reads only the first 4 digits

2009-05-20 Thread Marinko Tarlac
user mauro, check_item=3600, counter=1234 rlm_sqlcounter: Sent Reply-Item for user mauro, Type=Session-Timeout, value=2366 ++[sessioncounter] returns ok WARNING: Please update your configuration, and remove 'Auth-Type = Local' WARNING: Use the PAP or CHAP modules instead. User-Password

Re: Sql Counter reads only the first 4 digits

2009-05-20 Thread Ivan Kalik
Mauro Iorio - Smart Soft s.r.l. wrote: I’ve a strange problem with sql counter on freeradius both 1.1.7 and 2.1.5 versions. Actually executing SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='mauro' What happens when you replace that SELECT statement with a hard-coded number

Re: R: Sql Counter reads only the first 4 digits

2009-05-20 Thread Ivan Kalik
select 123456 from radacct where username = 'mauro' LIMIT 1 Don't bother with all that. Hardcode just: SELECT 123456 Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: R: Sql Counter reads only the first 4 digits

2009-05-20 Thread Alan DeKok
Mauro Iorio - Smart Soft s.r.l. wrote: Yes, it does. Check the following output: ... [sessioncounter]expand: %{sql:SELECT 123456 FROM radacct WHERE UserName='mauro'} - 1234 Hmm... I don't use the unixodbc drivers, so I can't test it here. I don't see anything in the code that would

R: R: Sql Counter reads only the first 4 digits

2009-05-20 Thread Mauro Iorio - Smart Soft s.r.l.
Don't bother with all that. Hardcode just: SELECT 123456 Ivan Kalik Kalik Informatika ISP Done. Same result: 1234. Mauro Iorio. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Sql Counter reads only the first 4 digits

2009-05-20 Thread Mauro Iorio - Smart Soft s.r.l.
Don't bother with all that. Hardcode just: SELECT 123456 Ivan Kalik Kalik Informatika ISP Done. Same result: 1234. Mauro Iorio. Any configuration parameter hidden somewhere which limits result lenght to 4 digits??? Mauro Iorio. - List info/subscribe/unsubscribe? See

Re: Sql Counter reads only the first 4 digits

2009-05-20 Thread Alan DeKok
Mauro Iorio - Smart Soft s.r.l. wrote: Any configuration parameter hidden somewhere which limits result lenght to 4 digits??? Uh... no. If it works for Ivan, then the problem is most likely in the unixodbc drivers. Alan DeKok. - List info/subscribe/unsubscribe? See

Re: Help Regarding SQL Counter

2008-12-20 Thread tnt
but one thing i wanted to ask you why NAS-IP-Addres is always shown as 0.0.0.0 in my case nas ip address is 192.168.2.5. do i need to make any other configuration. - Is that in the request packet? If it is - that's what your NAS is sending. Ivan Kalik Kalik Informatika ISP - List

Help Regarding SQL Counter

2008-12-19 Thread pushpraj nimbalkar
. That 30 mintutes counter dosent wotks. But when same user first logins for 5 minutes and logs off and again logins then counter works perfectly means user can be online only for remaining time i.e. for 25 minutes. So i think sqlcounter works only when there is accounting records for loging user inside

Re: Help Regarding SQL Counter

2008-12-19 Thread Padam J Singh
ll-Session). Then user should be able to login only for 30 minutes. But what is happening is when user connects he can be online as much time as he can. That 30 mintutes counter dosent wotks. But when same user first logins for 5 minutes and logs off and again logins then counter works perfectly mean

Re: Help Regarding SQL Counter

2008-12-19 Thread pushpraj nimbalkar
to login only for 30 minutes. But what is happening is when user connects he can be online as much time as he can. That 30 mintutes counter dosent wotks. But when same user first logins for 5 minutes and logs off and again logins then counter works perfectly means user can be online only

Re: Help Regarding SQL Counter

2008-12-19 Thread Padam J Singh
time as he can. That 30 mintutes counter dosent wotks. But when same user first logins for 5 minutes and logs off and again logins then counter works perfectly means user can be online only for remaining time i.e. for 25 minutes. So i think sqlcounter works only when there is accounting records

Re: Help Regarding SQL Counter

2008-12-19 Thread tnt
I am using linksys WRT54GL router with DD-WRT and Chillispot. SQLCounter works only when radacct tables contains accounting information of logging user. It should still limit to 30 minutes if user has no record. Post the debug of the request for a user that has no radacct entries. Ivan Kalik

Re: Help Regarding SQL Counter

2008-12-19 Thread pushpraj nimbalkar
session time(Max-All-Session). Then user should be able to login only for 30 minutes. But what is happening is when user connects he can be online as much time as he can. That 30 mintutes counter dosent wotks. But when same user first logins for 5 minutes and logs off and again logins then counter

Re: Help Regarding SQL Counter

2008-12-19 Thread pushpraj nimbalkar
On Fri, Dec 19, 2008 at 6:20 PM, t...@kalik.net wrote: I am using linksys WRT54GL router with DD-WRT and Chillispot. SQLCounter works only when radacct tables contains accounting information of logging user. It should still limit to 30 minutes if user has no record. Post the debug of the

Re: Help Regarding SQL Counter

2008-12-19 Thread tnt
sqlcounter_expand: 'SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{User-Name}'' [noresetcounter] expand: SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{User-Name}' - SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='jose' sqlcounter_expand: '%{sql:SELECT

Re: Help Regarding SQL Counter

2008-12-19 Thread pushpraj nimbalkar
On Fri, Dec 19, 2008 at 8:28 PM, t...@kalik.net wrote: sqlcounter_expand: 'SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{User-Name}'' [noresetcounter] expand: SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{User-Name}' - SELECT SUM(AcctSessionTime) FROM radacct

Re: FW: Working config file for data counter.

2008-12-17 Thread tnt
Have you read It doesn't work in FAQ? Post the radiusd -X output and your counter configuration. Tell us what you expected to happen. Ivan Kalik Kalik Informatika ISP Dana 17/12/2008, Marcel Grandemange thavi...@thavinci.za.net piše: Good Day. I am still struggling to get a working solution

FW: Working config file for data counter.

2008-12-17 Thread Marcel Grandemange
Good Day. I am still struggling to get a working solution with freeradius and mysql as backend. What im trying to do simply is have the radius server use data counters instead of time counters. I want to limit a users collective data to amounts of 1gb,2gb,3gb, all the way up. And it must be

Working config file for data counter.

2008-12-16 Thread Marcel Grandemange
Good Day. I am still struggling to get a working solution with freeradius and mysql as backend. What im trying to do simply is have the radius server use data counters instead of time counters. I want to limit a users collective data to amounts of 1gb,2gb,3gb, all the way up. And

Re: Working config file for data counter.

2008-12-16 Thread tnt
With Freeradius 2.1.3 I cannot use anything above 4gb, although I followed instructions on wiki to the tee for overcoming the wrapping problem. (wiki was outdated, but still tried) Can you post your counter configuration? What reply attribute are you using? Ivan Kalik Kalik Informatika ISP

Rlm sqlcounter -- Data Based Counter

2008-12-02 Thread Marcel Grandemange
Good Day. Im wondering is someone could assist me here. I currently have freeradius setup and working somewhat. However I have following setup: sqlcounter monthlytraffic { counter-name = Monthly-Traffic check-name = Max-Monthly-Traffic reply

Re: Rlm sqlcounter -- Data Based Counter

2008-12-02 Thread tnt
#query = SELECT SUM(OctetTotal) FROM thismonthsusage WHERE UsernameView='%{%k}' } .. As soon as a new month rolls over there are NO accounting entries for that user for that month, hence no record and freeradius denies user as he hasn't got any entries, any body know how I should modify the view

Using counter module

2008-11-03 Thread Romain Mercier
Hi ! I would like to use the counter module (not the sql_counter module) of FreeRadius 2.0.5 and I have questions about it : 1 - If it's possible, how can I display the value of a counter into the reply message ? 2 - I have created a counter based on the Acct-Output-Octets, so when a user

Re: Using counter module

2008-11-03 Thread tnt
I would like to use the counter module (not the sql_counter module) of FreeRadius 2.0.5 and I have questions about it : 1 - If it's possible, how can I display the value of a counter into the reply message ? Counter value is held in the attribute defined by counter-name. You can display

Adding a counter to raddb/sql/mysql/counter.conf

2008-07-30 Thread Liran Tal
Hey, How about adding more widely used counters to the counter.conf collection? One suggestion is the Access-Period counter which is provided with the attachment. Regards, Liran Tal. counter.conf.diff Description: Binary data - List info/subscribe/unsubscribe? See http://www.freeradius.org

RE: Possible Spam : Low Spam probability - : Re: SQL Counter Problem

2008-01-12 Thread Keith Dovale
: Possible Spam : Low Spam probability - : Re: SQL Counter Problem Keith Dovale wrote: Is there a limitation with the SQLCounter routine using a value above 2,148,000,000 in the checkfield ? As if I set this value to anything below this figure the routine works as planned however if I go above

Re: SQL Counter Problem

2008-01-11 Thread Alan DeKok
Keith Dovale wrote: Is there a limitation with the SQLCounter routine using a value above 2,148,000,000 in the checkfield ? As if I set this value to anything below this figure the routine works as planned however if I go above this value it rejects the user as no available time. The

SQL Counter Problem

2008-01-11 Thread Keith Dovale
Is there a limitation with the SQLCounter routine using a value above 2,148,000,000 in the checkfield ? As if I set this value to anything below this figure the routine works as planned however if I go above this value it rejects the user as no available time. I am trying to use the sqlcounter to

How to reset weekly counter every Sunday midnight?

2007-11-22 Thread Lee Sing Chyun
Hi, I'm trying unsuccessfully to configure a sqlcounter that is reset every Sunday 0:00AM. Here's what i configured in radiusd.conf: sqlcounter weeklycounter { counter-name = Weekly-Session-Time check-name = Max-Weekly-Session reply-name

error of accuonting with sql counter

2007-08-15 Thread zahra bahar
Hi. I set dailycounter in account part of radius.conf.but wen I run radiusd -x it writes this eeror: sql counter modules aren't allowed in 'accounting' sections - - they have no such method what is wrong in my setting? - Building a website is a piece

Re: usage counter....

2007-05-19 Thread Trio Yulistianto
so.. its mean that freeradius not yet supporting about this limit ? so i have to ask mikrotik ? 2007/5/18, [EMAIL PROTECTED] [EMAIL PROTECTED]: With a bit of gymnastics it can be done. You can run an outside program on accounting updates checking Octet total - if it goes over the limit it can

Re: usage counter....

2007-05-19 Thread Jan Mulders
Yeah, I found a method to do this. It involves configuring your NAS to reauthenticate the user every 20 minutes or so (I use OpenVPN with a NAS plugin, it does key renegotiation every 20 minutes so this is ideal for me), and using a Perl script with rlm_perl to do your own calculations. Read

Re: usage counter....

2007-05-19 Thread tnt
That is not standard radius attribute so it can't be enforced on every peace of equipment. Freeradius will happily send such attribute (if you define it yourself in the dictionary) but NAS won't know what to do with it. You have an option to use NAS that has such VSA (like Chillispot) or create

Re: usage counter....

2007-05-18 Thread tnt
18/5/2007, Trio Yulistianto [EMAIL PROTECTED] piše: next problem... i have read all documentation ebaout sql counter and all based on time.. any docoumentation about volume based ? volume based (total of inputoctets and outputoctets) in my case, i want to give user limitation about his byte

Re: usage counter....

2007-05-18 Thread Trio Yulistianto
have read all documentation ebaout sql counter and all based on time.. any docoumentation about volume based ? volume based (total of inputoctets and outputoctets) in my case, i want to give user limitation about his byte usage, ie. user heavy : has 10 Gb (total of inputoctets

users graph from freeradius counter

2007-05-18 Thread satish patel
Dear All I have useing freeradius and it is working fine but now i want to create per user download and upload graph so it is possible but any package ??? $ cat ~/satish/url.txt http://www.linuxbug.org

usage counter....

2007-05-17 Thread Trio Yulistianto
next problem... i have read all documentation ebaout sql counter and all based on time.. any docoumentation about volume based ? volume based (total of inputoctets and outputoctets) in my case, i want to give user limitation about his byte usage, ie. user heavy : has 10 Gb (total

Re: sqlcounter monthly counter impementation problem

2007-05-07 Thread satish patel
in freeradius tarball doc directory there is some more help regarding sqlcounter.conf edit file /etc/raddb/sqlcounter.conf suse:/etc/raddb # cat sqlcounter.conf sqlcounter noresetcounter { counter-name = Max-All-Session-Time check-name = Max-All-Session sqlmod-inst

Re: sqlcounter monthly counter impementation problem

2007-05-07 Thread Alan DeKok
Cory Robson wrote: I have the following configuration in my radius.conf file. The counter does function as such and if the user has utilized the allotted time it will not allow them to connect. However I'm looking to see how to also apply it to the session limit. (IE adjust the session time

  1   2   3   >