Dear Sir
this is the log in debugging mode , in query in using
query = SELECT (SUM(AcctInputOctets)+SUM(AcctOutputOctets)) FROM radacct
WHERE UserName='%{%k}'
it works just fine
Waking up in 5 seconds...
rad_recv: Access-Request packet from host 192.168.22.2:52098, id=20,
length=114
Dear Gentlemen
I'm having a problem with my daily count :
sqlcounter chillispot_max_bytes_daily {
counter-name = ChilliSpot-Max-Total-Octets
check-name = ChilliSpot-Max-Total-Octets
reply-name = ChilliSpot-Max-Total-Octets
sqlmod-inst = sql
key = User-Name
reset = daily
query = SELECT
would u please show me the code u used?
On Fri, Apr 9, 2010 at 4:27 PM, Alexander alexander_aust...@yahoo.comwrote:
--- On Wed, 4/7/10, Alan DeKok al...@deployingradius.com wrote:
See man unlang
In the authorize section, do:
if (%{sql: SELECT ...quota ...} =
%{sql:SELECT
roaring penguin never reply , im stuck with this issue!
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi , i added RP-upsteam-speed-limit and RP-down-speed-limit attributes to my
freeradius and i can see the outout with radiusd -X
Sending Access-Accept of id 250 to 127.0.0.1 port 37116
Framed-Protocol = PPP
Framed-IP-Address = 255.255.255.254
Framed-IP-Netmask =
Ivan thanks for your help but can you tell me how to add them? i tried to
include the dictionary.roaring,,, but it didnt work.
thanks again
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
hi
sql.conf is your mysql database config , you use it when u need to have
AAA with radius , like freeradius with mysql backend
what distro your using? linux redhat? debain? slackware? fedora?
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Thor Spruyt wrote:
Mordor Networks wrote:
hi Graham
yes sir i know but my question is how to do that im all new to all
this.. thank you
Connect to your mysql database and type show tables;, then you'll see a
list of tables in your database.
It's probably the radacct table you
i want to know how many user logged in mysql database/radius but it only
show the number of user in my databse for example is says 61 logged out
and 0 login
so here is the problem
//login users from//
$login_users = ; what i have to write here ? which table i have to query?
how i can fix that
hi ivan thank you for your reply
it tried this : $requet = SELECT COUNT(*) FROM radcheck WHERE
AcctStopTime=0;
$login_users = $requet
and
$login_users = SELECT COUNT(*) FROM radcheck WHERE AcctStopTime=0;
still 0 , what im doing wrong?
-
List info/subscribe/unsubscribe? See
hi Graham
yes sir i know but my question is how to do that im all new to all this..
thank you
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi allI have a question i used freeradisu with mysqlbackend for auth and accounting for dialup account , i want to know it is is possible when the user account is expired i want to allow the user to connect but to be redirected to a website telling him that the account is expired is it possible?
Hello guysTalking about report generator anyone got using Username too see the reporti mean the user can enter his username and password and see his usage?thanksOn 8/24/06,
Guy Fraser [EMAIL PROTECTED] wrote:
Me too.I have also built a report generator, into the management system Ibuilt.I can
yes im using mysql backend and dialu[_admin on ppp server.regards On 8/25/06, Guy Fraser [EMAIL PROTECTED]
wrote:That used to work in dialup_admin, I have not worked with itin a long time. The last time I attempted to test
dialup_admin, it seemed more difficult to get working than ithad been in
Hello sean it is exactly what i need :) thank you MarkOn 8/25/06, Sean [EMAIL PROTECTED] wrote:
Hi Morder,I've also written a utility to allow users to see their usage. I'm tying
it into a complete reporting and statistics package, I expect to have atest version ready over the weekend. As soon as
Hi allI have a small problem , i have a freeradius server with mysql backend and 3 pppoe server and one pptp server all the NAS'es pppoe/pptp server connect to the same radiusd and same mysql database , so when i add a user for exampe i added a user to server-one and his ip is
192.168.2.100 so
Hello list!I wonder if someone used the RP-Upstream-Speed-Limit and RP-Downstream-Speed-Limit ATTRIBUTES from roaring pangiun rp-pppoe with mysql , if so can someone please tell me how to add the ATTRIBUTES to freeradius sql table radreply?
thanks
-
List info/subscribe/unsubscribe? See
/31/06, Seferovic Edvin [EMAIL PROTECTED] wrote:
shall i added it to
the radclient on the nas box ?
YES ! Both server and
client have to know about what attribute are you "talking about".
Regards,
Edvin
From:
Mordor Networks [mailto:[EMAIL PROTECT
Edvin
PS: one mail to the
mailing list should be enough. I get the mails from the list too, so you do NOT
need to send me an extra mail ;-)
From:
Mordor Networks [mailto:[EMAIL PROTECTED]]
Sent: Mittwoch, 31. Mai 2006 09:19
To: [EMAIL PROTECTED];
FreeRadius users mailing list
Subjec
;-)From: Mordor Networks [mailto:[EMAIL PROTECTED]]Sent: Mittwoch, 31. Mai 2006 09:19
To: [EMAIL PROTECTED]; FreeRadius users mailing listSubject: Re: Session-Octets-Limitsok thanks a lit edvin but one more question pleaseSession-Octets-Limit := 1000 for example the 1000 = byte or kbyte or MB
Do i have to patch the sqlcounter module so that it can be used for counting traffic?I have the default sqlcounter in my radius.conf sqlcounter Dailycounter and sqlcounter monthlycounter/
On 5/31/06, Seferovic Edvin [EMAIL PROTECTED] wrote:
Its working and the user disconnect when reachs the limit
HelloHow can i add some attributes to freeradius sql tables , like i want to add Session-Octets-Limits what should i do?
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hello!If you just want to send reply attributes of type Session-Octets-Limit add this to your dictionaryfile (located probably in /usr/local/share/freeradius):# Limit session traffic
ATTRIBUTE Session-Octets-Limit227 integer# What to assume as limit - 0 in+out, 1 in, 2 out, 3
be in the dictionary file ! The freeradius should sent a
value ( integer value = bytes count ) to your pppoe server which uses radius
client. Look at the debug output of the freeradius server to see if those
attributes are in the reply message !
Regards,
Edvin
From:
Mordor Networks [mailto
/06, Mordor Networks
[EMAIL PROTECTED] wrote:Hi edvinsorry for asking too much but do i think i can add fieldsin sql radreply so i can make it works with mysql since i use radius + mysql? and if so how i do that
thanks a lot
On 5/29/06, Seferovic Edvin [EMAIL PROTECTED]
wrote:
Hi
Hello please can some one tell me how to disconnect a user when reach the bandwidth qouta?ex: if user joe reachs 100MB daily i want to lock his account and disconnect himanyhelp?
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
hello Seferovic Edvinim using rp-pppoe as a pppoe server with freeradius and myqsl backend ,how to disconnect a user when reachs his daily or weekly, monthly bandwidth qouta?
thank u .On 5/27/06, Seferovic Edvin
[EMAIL PROTECTED] wrote:Depending on what are you using - this is possible !
On 5/17/06, Terry J Fike Jr [EMAIL PROTECTED] wrote:
does anyone knows how to limit upload/download speed for each user in user file ? Rate_Limit_Rate = 137, Rate_Limit_Burst = 15000, Police_Rate = 137, Police_Burst = 15000,
Rate_Limit aprox= downloadPolice_Rate aprox= upload--Terry J Fike
On 4/27/06, YvesDM [EMAIL PROTECTED]
wrote:
On 4/27/06, Mordor Networks
[EMAIL PROTECTED] wrote:
Hii want to make prepaid system for my dialup users ex: username : 15789546 password 123456How i can make freeradius change the pin code to a valid username in my database ? i use mysql as a backend
Hello Thank you all for your replies , i fixed my issue using some scripts that comes with dialup_admin, /bin/ dir , it is working for know , thank you Guy Fraser.My question know , is it possible to send any attribute using dialup_admin to disconnect a user, i have a some handmade bash scripts to
Date: Wed, 05 Apr 2006 11:09:58 -0600From: Guy Fraser [EMAIL PROTECTED]Subject: Re: How to make FR reset the logs
To: freeradius-users@lists.freeradius.orgMessage-ID:
[EMAIL PROTECTED]Content-Type: text/plainOn Wed, 2006-05-04 at 06:15 +0300, Mordor Networks wrote: hi Is it possible to make FR
hiIs it possible to make FR remove all monthly accounting logs from the database mysql?
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
HelloI\'m trying to log the users MAc address using pppoe and FR + mysqli added AVpair to the users file calling-station-id but checkval could not find itenrlm_checkval: Could not find item named Calling-Station-Id in request
rlm_checkval: Could not find attribute named Calling-Station-Id in check
Hello, I finally have a working rp-pppoe+pppd+linux+radius+mysql setup handling lots of connections :)
I used to handle pppoe connections on freebsd, and when a connection is
established, the field CallingStationId of the radacct table on mysql
had the mac address of the calling user.
rp-pppoe
HelloI have pppoe-server with freeradius and mysql backend working pretty good , thus i still want to know if it is possible to use mac adders with user name and password ?thanks in advanced
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
35 matches
Mail list logo