{
expiration
}
3.) Added under auth section:
authorize {
expiration
}
When we expire account with expiration attribute which kind of value can
we define to the attribute so that account gets expire after 1 hour of
internet use (using sql counter). Date format is working alright (01
:
authorize {
expiration
}
When we expire account with expiration attribute which kind of value can
we define to the attribute so that account gets expire after 1 hour of
internet use (using sql counter). Date format is working alright (01 Sep
2013).
Thanks everyone for attending
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
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
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.
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
%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
Hi Alan,
Did you managed to look into the issue ?
or maybe any hints on how to use DATETIME in Expiration instead of String ?
Regads
Suman
On 3/15/2011 4:04 PM, Suman Dash wrote:
Dear Alan,
I have not removed any debug messages. I will try to put everything
once again . I was not aware
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 :=
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:
Suman Dash wrote:
Please anyone advice me the way to escape run-time variables in
freeradius. I am using STR_TO_DATE and freeradius run-time variable is
over-riding the mysql time variables
Yes... that's what it does.
I have tried escaping as per the thread
New Modified Query !
SELECT SUM(acctsessiontime) FROM tbl_acct where \
username = '%{%k}' AND acctstarttime BETWEEN \
(SELECT STR_TO_DATE((SELECT value FROM tbl_check \
WHERE username = '%{%k}' AND attribute =
'Activation'), '%%d %%M %%Y
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.
SELECT SUM(acctsessiontime) FROM tbl_acct where
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
mysql select * from tbl_check;
++--+-++--+
| id | username | attribute | op | value|
++--+-++--+
| 17 | suman| Crypt-Password | := | TeatgXaDQelbQ
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
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 =
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 .
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
and
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
and
Please anyone advice me the way to escape run-time variables in
freeradius. I am using STR_TO_DATE and freeradius run-time variable is
over-riding the mysql time variables
SELECT STR_TO_DATE('14 Mar 2012 21:37:23','%d %M %Y %H:%i:%s') gives
2012-03-14 21:37:23 in MySQL
Whereas in freeradius
Please anyone advice me the way to escape run-time variables in
freeradius. I am using STR_TO_DATE and freeradius run-time variable is
over-riding the mysql time variables
SELECT STR_TO_DATE('14 Mar 2012 21:37:23','%d %M %Y %H:%i:%s') gives
2012-03-14 21:37:23 in MySQL
Whereas in freeradius
|
+-+---+-++-+---+
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
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
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
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?
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
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
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
What happens when you replace that SELECT statement with a hard-coded
number, like 123456? Does it still truncate the result?
Alan DeKok.
Yes, it does. Check the following output:
-
rlm_sqlcounter: Entering module authorize code
select 123456 from radacct where username = 'mauro' LIMIT 1
On Wed, May 20, 2009 at 2:44 PM, Mauro Iorio - Smart Soft s.r.l.
m.io...@smartsoft.it wrote:
What happens when you replace that SELECT statement with a hard-coded
number, like 123456? Does it still truncate the result?
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
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
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
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
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
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
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
Hello All;
I just installed freeradius on fedora 10. freeradius version is
freeradius-2.1.1-2.fc10.i386 i also installed radius mysql packages. After
basic set up I configured radius with mysql. All thing are working fine but
i am not able to resolve sqlcounter issue. I have defined counters in
The NAS has
to implement session disconnection after the requisite time/byte limit.
What NAS are you using?
Padam
pushpraj nimbalkar wrote:
Hello All;
I just installed freeradius on fedora 10. freeradius version is
"freeradius-2.1.1-2.fc10.i386" i also installed radius mysql packages.
Thanks for reply,
I am using linksys WRT54GL router with DD-WRT and Chillispot.
SQLCounter works only when radacct tables contains accounting
information of logging user.
On Fri, Dec 19, 2008 at 5:08 PM, Padam J Singh padam.si...@inventum.cc wrote:
The NAS has to implement session
pushpraj nimbalkar wrote:
Thanks for reply,
I am using linksys WRT54GL router with DD-WRT and Chillispot.
SQLCounter works only when radacct tables contains accounting
information of logging user.
Please also post the reply sent back to the NAS - run the radius server
in debug
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
Sir,
when user first connects following reply sent to nas
Sending Access-Accept of id 0 to 192.168.2.5 port 2051
Idle-Timeout := 600
Acct-Interim-Interval := 60
and when same user connects 2nd time following reply is sent
Sending Access-Accept of id 0 to 192.168.2.5 port 2051
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
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
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
: 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
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
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
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
Just vim /etc/freeradius/dictionary
and include the following line
$INCLUDE/usr/share/freeradius/dictionary.chillispot
Oh, and move the chillispot.dictionary file into the
/usr/share/freeradius directory just to keep things neat!
Goodluck!
Tas.
YvesDM wrote:
On 2/24/07, *Graham
On 2/25/07, Tas Dionisakos [EMAIL PROTECTED] wrote:
Just vim /etc/freeradius/dictionary
and include the following line
$INCLUDE/usr/share/freeradius/dictionary.chillispot
Oh, and move the chillispot.dictionary file into the
/usr/share/freeradius directory just to keep things neat!
On 2/24/07, PD [EMAIL PROTECTED] wrote:
Simple questions...
how and where to get sql counter module ?
I try to googling for hours but still can not find it.
TIA
PD
You should compile FR with experimental modules
You have to create the module yourself
Read rlm_sqlcounter in the doc
YvesDM wrote:
On 2/24/07, *PD* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote:
Simple questions...
how and where to get sql counter module ?
I try to googling for hours but still can not find it.
TIA
PD
You should compile FR with experimental modules
You
On 2/24/07, Graham Beneke [EMAIL PROTECTED] wrote:
In the current version of FR (1.1.4) the sqlcounter module is no longer
experimental - comes as in the default collection of modules.
There is also a wiki article on using sqlcounter:
http://wiki.freeradius.org/Rlm_sqlcounter
Its not
- Original Message -
From: YvesDM
To: FreeRadius users mailing list
Sent: Saturday, February 24, 2007 9:03 AM
Subject: Re: Where to find sql counter module ?
On 2/24/07, PD [EMAIL PROTECTED] wrote:
Simple questions...
how and where to get sql counter module
YvesDM wrote:
rlm_sqlcounter: No such attribute ChilliSpot-Max-Total-Octets
obelix:/etc/freeradius#
Strange...
But I'm not in a rush, I'll find out what's wrong :-)
Looks like a dictionary problem to me - Chillispot's dictionary is not
yet part of FR you have to add it manually.
On 2/24/07, Graham Beneke [EMAIL PROTECTED] wrote:
YvesDM wrote:
rlm_sqlcounter: No such attribute ChilliSpot-Max-Total-Octets
obelix:/etc/freeradius#
Strange...
But I'm not in a rush, I'll find out what's wrong :-)
Looks like a dictionary problem to me - Chillispot's dictionary is not
On 2/24/07, Graham Beneke [EMAIL PROTECTED] wrote:
Looks like a dictionary problem to me - Chillispot's dictionary is not
yet part of FR you have to add it manually.
Maybe someone with a little spare time can throw together the Chillispot
dictionary as a patch ;-)
Graham Beneke
Yeah, that
Is it possible to reset the sql counter manually or by any scripts in
freeradius?
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi,
Sorry if this is a repeat. I'm not sure if an email I sent yesterday got
through.
Clearly I'm missing something simple here. I'm trying to create accounts
that will renew on a daily or monthly basis.
I've put this code into my radiusd.conf file to test daily renewals.
$INCLUDE
I have the same error message.
Somebody adviced me that I have to download the latest release of freeradius .
-- Forwarded Message --
Subject: SQL Counter
Date: Monday 11 December 2006 02:04 pm
From: Sean [EMAIL PROTECTED]
To: freeradius-users@lists.freeradius.org
Hi,
Sorry
1. Fwd: SQL Counter (Enrique Acosta)
Thanks Enrique. I upgraded to 1.1.3 but the error is still there. Alan
gave me a hint that the attribute is not in the dictionary, so I've
spent all evening searching the dictionary files looking for SQL
attributes with no luck. My searches of the list
Sean wrote:
1. Fwd: SQL Counter (Enrique Acosta)
Thanks Enrique. I upgraded to 1.1.3 but the error is still there. Alan
gave me a hint that the attribute is not in the dictionary, so I've
spent all evening searching the dictionary files looking for SQL
attributes with no luck.
No... You
Has anyone made a sql counter module for rechargeable account?
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
(rlm_sqlcounter: Maximum
never usage time reached): [test01] (from client pppoe-bhw port 4448
cli 0:7:95:10:73:9e)
What could be the problem with sql counter module? In my radiusd.conf
settings I have setup max-all-session counter as follows;
sqlcounter noresetcounter
sec)
mysql
==
My sqlcounter.conf is exactly the same.
I have added this:
$INCLUDE ${confdir}/sqlcounter.conf
Into the radiusd.conf
==
When I fire up radius in debug mode I get these messages for sqlcounter:
Module: Loaded SQL Counter
sqlcounter: counter-name = Daily-Session
@lists.freeradius.org
Subject: Re: sql counter clarification and issues
On Wed, 13 Jul 2005 12:15:45 +1000
Ross Tsolakidis [EMAIL PROTECTED] wrote:
Thanks for responding Marcin, just to double check:
I added those details into radgroupcheck:
mysql select * from radgroupcheck
PM
To: FreeRadius users mailing list
Subject: RE: sql counter clarification and issues
Yes the server is receiving accounting packets.
The SQL rows are updating every 5 mins, (I have the NAS set to send
accounting packets every 5 mins).
I run it in debug mode, I see:
Module: Loaded SQL
PROTECTED] On Behalf Of Ross
Tsolakidis
Sent: Tuesday, 5 July 2005 2:14 PM
To: FreeRadius users mailing list
Subject: RE: sql counter clarification and issues
Yes the server is receiving accounting packets.
The SQL rows are updating every 5 mins, (I have the NAS set to send
accounting packets every 5
Ross Tsolakidis [EMAIL PROTECTED] wrote:
At midnight every night will it begin a new row in SQL ?
I don't know, I've never used the module.
Because at the moment there are no new rows being created, no counters
being reset.
Is the server receiving accounting packets?
Run it in debug
Yes the server is receiving accounting packets.
The SQL rows are updating every 5 mins, (I have the NAS set to send
accounting packets every 5 mins).
I run it in debug mode, I see:
Module: Loaded SQL Counter
sqlcounter: counter-name = Daily-Session-Time
sqlcounter: check-name = Max-Daily
Hi all,
Ok I've set it all up, it looks like it's working, when I look in the
debug I see:
Module: Instantiated sql (sql)
Module: Loaded SQL Counter
sqlcounter: counter-name = Daily-Session-Time
sqlcounter: check-name = Max-Daily-Session
sqlcounter: key = User-Name
sqlcounter: sqlmod-inst
Ross Tsolakidis [EMAIL PROTECTED] wrote:
Can you give me an example of how to set the counter to reset in SQL ?
No, I said sqlcounter. It's a separate module. See
experimental.conf
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Ross Tsolakidis [EMAIL PROTECTED] wrote:
Looking at that debug, where exactly is it resetting the counter ?
The counter module is resetting the counter.
In the db.daily ? Because it's not resetting in SQL.
Yes, the counter module doesn't say it's using SQL.
Also what is the db.daily ?
:[EMAIL PROTECTED] On Behalf Of Alan
DeKok
Sent: Wednesday, 29 June 2005 12:58 AM
To: FreeRadius users mailing list
Subject: Re: sql counter clarification and issues
Ross Tsolakidis [EMAIL PROTECTED] wrote:
Looking at that debug, where exactly is it resetting the counter ?
The counter module
Hi all,
I was hoping someone could shed some light on this problem I'm having.
FreeRadius 1.04
Compiled using:
./configure --with-experimental-modules
make
make install
Radius is connecting to a mysql backend.
The NAS units are logging to Radius and into SQL.
Running in debug mode I see this:
Hi,
I'm tryin to setup radius accounts that expire after a predetermined
ammount of usage time (eg 5 hours) and are only valid for a
predetermined number of days (eg 30 days) after the first login.
I've setup an sql counter 'noresetcounter' that counts the online time:
sqlcounter noresetcounter
79 matches
Mail list logo