- Freeradius-Users - lists.freeradius.org

Freeradius DHCP problem with some vendors.
by Ricardo Oliveira 13 Jan '14

13 Jan '14

Hello, I am introducing the Freeradius as DHCP server at my ISP and am experiencing problems with some vendors specifically routers TP-Link. The FreeRadius allocates the IP Router but unable to associate the IP offered by freeradius, what intrigues me is that the problem does not occur with the ISC-DHCP. FreeRADIUS Version 2.2.4 (git #14e1ee7) Follow my configuration and Debug. server dhcp { listen { type = dhcp ipaddr = XXX.XXX.0.26 port = 67 interface = eth0 broadcast = no } dhcp DHCP-Discover { update reply { DHCP-Message-Type = DHCP-Offer } update reply { DHCP-Domain-Name-Server = XXX.XXX.0.6 DHCP-Domain-Name-Server = XXX.XXX.0.250 DHCP-IP-Address-Lease-Time = 120 DHCP-DHCP-Server-Identifier = XXX.XXX.0.26 } sql.authorize dhcp_sqlippool sql.post-auth ok } dhcp DHCP-Request { update reply { DHCP-Message-Type = DHCP-Ack } update reply { DHCP-Domain-Name-Server = XXX.XXX.0.6 DHCP-Domain-Name-Server = XXX.XXX.0.250 DHCP-IP-Address-Lease-Time = 120 DHCP-DHCP-Server-Identifier = XXX.XXX.0.26 } sql.authorize dhcp_sqlippool sql.post-auth ok } dhcp { reject } } Ready to process requests. Received DHCP-Discover of id 7f519348 from 179.127.59.1:67 to 187.85.0.26:67 DHCP-Opcode = Client-Message DHCP-Hardware-Type = Ethernet DHCP-Hardware-Address-Length = 6 DHCP-Hop-Count = 1 DHCP-Transaction-Id = 2136052552 DHCP-Number-of-Seconds = 4 DHCP-Flags = Broadcast DHCP-Client-IP-Address = 0.0.0.0 DHCP-Your-IP-Address = 0.0.0.0 DHCP-Server-IP-Address = 0.0.0.0 DHCP-Gateway-IP-Address = 179.127.59.1 DHCP-Client-Hardware-Address = a0:f3:c1:f3:78:6a DHCP-Message-Type += DHCP-Discover DHCP-Client-Identifier += a0:f3:c1:f3:78:6a DHCP-DHCP-Maximum-Msg-Size += 576 DHCP-Parameter-Request-List += DHCP-Subnet-Mask DHCP-Parameter-Request-List += DHCP-Router-Address DHCP-Parameter-Request-List += DHCP-Domain-Name-Server DHCP-Parameter-Request-List += DHCP-Static-Routes DHCP-Parameter-Request-List += DHCP-Vendor DHCP-Parameter-Request-List += DHCP-NETBIOS-Name-Servers DHCP-Parameter-Request-List += DHCP-NETBIOS-Node-Type DHCP-Parameter-Request-List += DHCP-NETBIOS DHCP-Parameter-Request-List += DHCP-Classless-Static-Route DHCP-Parameter-Request-List += 249 DHCP-Relay-Circuit-Id = "1/1/FHTT-0027b63b" DHCP-Relay-Remote-Id = "" server dhcp { Trying sub-section dhcp DHCP-Discover {...} +group DHCP-Discover { ++update reply { ++} # update reply = noop ++update reply { ++} # update reply = noop [sql] expand: %{DHCP-Relay-Circuit-Id} -> 1/1/FHTT-0027b63b [sql] sql_set_user escaped user --> '1/1/FHTT-0027b63b' rlm_sql (sql): Reserving sql socket id: 2 [sql] expand: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radcheck WHERE username = '1/1/FHTT-0027b63b' ORDER BY id [sql] User found in radcheck table [sql] expand: SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radreply WHERE username = '1/1/FHTT-0027b63b' ORDER BY id [sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = '1/1/FHTT-0027b63b' ORDER BY priority rlm_sql (sql): Released sql socket id: 2 ++[sql.authorize] = ok ++policy dhcp_sqlippool.post-auth { +++update request { expand: %{DHCP-Relay-Circuit-Id} -> 1/1/FHTT-0027b63b expand: %{DHCP-Relay-Circuit-Id} -> 1/1/FHTT-0027b63b expand: %{DHCP-Gateway-IP-Address} -> 179.127.59.1 expand: %{%{DHCP-Gateway-IP-Address}:-127.0.0.1} -> 179.127.59.1 +++} # update request = noop [dhcp_sqlippool] No Pool-Name defined. [dhcp_sqlippool] expand: DHCP: No Pool-Name defined (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name}) -> DHCP: No Pool-Name defined (did cli 1/1/FHTT-0027b63b port user 1/1/FHTT-0027b63b) DHCP: No Pool-Name defined (did cli 1/1/FHTT-0027b63b port user 1/1/FHTT-0027b63b) +++[dhcp_sqlippool] = noop +++? if (ok) ? Evaluating (ok) -> FALSE +++? if (ok) -> FALSE ++} # policy dhcp_sqlippool.post-auth = noop [sql] expand: %{DHCP-Relay-Circuit-Id} -> 1/1/FHTT-0027b63b [sql] sql_set_user escaped user --> '1/1/FHTT-0027b63b' [sql] expand: %{User-Password} -> [sql] ... expanding second conditional [sql] expand: %{Chap-Password} -> [sql] expand: INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S') -> INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '1/1/FHTT-0027b63b', '', '0', '2014-01-12 18:02:18') rlm_sql (sql) in sql_postauth: query is INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '1/1/FHTT-0027b63b', '', '0', '2014-01-12 18:02:18') rlm_sql (sql): Reserving sql socket id: 1 rlm_sql (sql): Released sql socket id: 1 ++[sql.post-auth] = ok ++[ok] = ok +} # group DHCP-Discover = ok DHCP: Reply will be unicast to giaddr from original packet } # server dhcp Encoding DHCP-Offer of id 7f519348 to 179.127.59.1:67 DHCP-Opcode = Server-Message DHCP-Hardware-Type = Ethernet DHCP-Hardware-Address-Length = 6 DHCP-Hop-Count = 1 DHCP-Transaction-Id = 2136052552 DHCP-Number-of-Seconds = 0 DHCP-Flags = Broadcast DHCP-Client-IP-Address = 0.0.0.0 DHCP-Your-IP-Address = 179.127.59.2 DHCP-Server-IP-Address = 187.85.0.26 DHCP-Gateway-IP-Address = 179.127.59.1 DHCP-Client-Hardware-Address = a0:f3:c1:f3:78:6a DHCP-Server-Host-Name = "" DHCP-Boot-Filename = "" DHCP-Domain-Name-Server = 187.85.0.6 DHCP-Domain-Name-Server = 187.85.0.250 DHCP-IP-Address-Lease-Time = 120 DHCP-DHCP-Server-Identifier = 187.85.0.26 DHCP-DHCP-Maximum-Msg-Size = 576 Sending DHCP-Offer of id 7f519348 to 179.127.59.1:67 Finished request 1. Thanks.

2 3

FR 2.2.3 crash
by Alex Sharaz 13 Jan '14

13 Jan '14

Hi, Just been looking at my development server logs and noticed Mon Jan 13 08:38:10 2014 : Auth: Login OK: [f5healthcheck] (from client f5-man-1 port 0 cli ) Mon Jan 13 08:38:13 2014 : Info: WARNING: Child is hung for request 13100 in component <core> module . Mon Jan 13 08:38:16 2014 : Error: ASSERT FAILED event.c[543]: request->child_state == REQUEST_DONE o.k. the 1st line is our F5 load balancer performing a health check, and is normal. The other 2 aren’t. At this point FR is dead and had to be restarted. Not sure if I can reproduce the conditions but the server was last restarted on Friday. Running 2.2.3 built from git source code Rgds A

2 1

post-auth bash script
by Jean Carlos Coelho 13 Jan '14

13 Jan '14

Hi! Is there some way to execute a shell with freeradius? here’s my scenario: - Users login to cisco wi-fi with 3 BSSID (teachers, students or employees) with LDAP credentials; - I verify if user is at group X, Y or Z (LDAP-Group); - *** Now, i need to verify in ldap (ldapsearch/shell) if the objectclass “userenalbled” is enabled or “expiredate” is “less” than "now” *** - Then grant or not access to wifi lan. This is what I did so far (eg. From students network)… Authenticate { post-auth { # if (LDAP-Group == “teachers" || LDAP-Group == “employees") { # reject # else { # noop # } # } } } Same file above: Authorize { update control { Auth-Type := `bash /opt/verify_date.sh '%{User-Name}'` } } Content of “verify_date.sh” file is an ldapsearch with filters to return the values of “expiredate” or “userenabled” with “if” statements to check the results, my question is: How can I work with the results of this script to allow or deny access to networks? Thank You!

5 5

Re: coa / proxy question
by Richard J Palmer 13 Jan '14

13 Jan '14

One more question (sorry) As an example I use --- /bin/echo "Acct-Session-Id='.$sess.'" | /usr/bin/radclient -x 127.0.0.1:3799 disconnect mypassword' --- Within the SQL you suggested -- > > Tmp-String-0 := "%{sql:<query>}" -- How can I access the Acct-Session-Id that is sent into freeradius ? ie so I can do something like Tmp-String-0 := "%{sql:<SELECT TOP 1 LNSIPAddress FROM radacct where Acct-Session-Id='x'}" Once I know this I think I can do the rest - If I am missing something obvious please point me in the right direction - the help so far has been very much appriciated -- Richard Palmer | Director | Merula Limited Company Registered in England and Wales No. 3243995 5 Avro Court, Huntingdon, Cambridgeshire, PE29 6XS Phone 01480 222940 | Support 0845 330 0666 Support Email support(a)merula.net > --- Original message --- > Subject: Re: coa / proxy question > From: Arran Cudbard-Bell <a.cudbardb(a)freeradius.org> > To: FreeRadius users mailing list > <freeradius-users(a)lists.freeradius.org> > Date: Thursday, 09/01/2014 10:06 AM > > > On 9 Jan 2014, at 09:03, Richard J Palmer <richard(a)merula.net> wrote: > >> >> OK I now have part one of this done - radacct now holds the LNS IP >> address thank you. >> >> I just want to clarify one small thing if I may ... >> >> With the CoA I currently have one CoA server enabled on port 3799 on >> the radius server. How should I forward the CoA to the LNS ? Do I >> setup 2 CoA servers either on different ports or IPs within FreeRadius >> and each send to a different LNS, or Can FreeRadius itself do a SQL >> query based on the AcctUniqueId and use that to get the IP to forward >> to ? > > Yes, that's the idea. > > update control { > Tmp-String-0 := "%{sql:<query>}" > } > > It'll use the value from the first column/row. > > You'll have to use the IP address to set the realm to forward to. > > -Arran > > Arran Cudbard-Bell <a.cudbardb(a)freeradius.org> > FreeRADIUS Development Team > > FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2 > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html

2 1

Radius dies
by Tyller D 13 Jan '14

13 Jan '14

Hi, I have setup a new freeradius server and today it died for the first time. Some info regarding the install: Version: radiusd -v radiusd: FreeRADIUS Version 2.1.12, for host x86_64-redhat-linux-gnu, built on Oct 3 2012 at 01:22:51 Copyright (C) 1999-2011 The FreeRADIUS server project and contributors. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. You may redistribute copies of FreeRADIUS under the terms of the GNU General Public License. For more information about these matters, see the file named COPYRIGHT. OS CentOS release 6.4 (Final) Some notes on my setup: Everything runs through mod_perl. So my perl script handles the DB connection, add and removes records from the DB and so forth. Its called for each and every request. I checked the logs when the server was down and the errors I saw were Sat Jan 11 16:26:08 2014 : Info: WARNING: Child is hung for request 67332 in component <core> module <queue>. Sat Jan 11 16:26:12 2014 : Info: WARNING: Child is hung for request 67329 in component <core> module <queue>. Sat Jan 11 16:26:13 2014 : Info: WARNING: Child is hung for request 67328 in component <core> module <queue>. Sat Jan 11 16:26:18 2014 : Info: WARNING: Child is hung for request 67330 in component <core> module <queue>. Sat Jan 11 16:26:18 2014 : Info: WARNING: Child is hung for request 67333 in component <core> module <queue>. Sat Jan 11 16:26:19 2014 : Info: WARNING: Child is hung for request 67331 in component <core> module <queue>. Sat Jan 11 16:26:20 2014 : Info: WARNING: Child is hung for request 67332 in component <core> module <queue>. Sat Jan 11 16:26:21 2014 : Info: WARNING: Child is hung for request 67331 in component <core> module <queue>. Sat Jan 11 16:26:23 2014 : Info: WARNING: Child is hung for request 67331 in component <core> module <queue>. and those went on for HOURS. when i reached the top of those messages ( I assume just before the server failed I saw these logs come through) Sat Jan 11 13:19:00 2014 : Error: Received conflicting packet from client private-network-1 port 39484 - ID: 89 due to unfinished request 63062. Giving up on old request. Sat Jan 11 13:19:01 2014 : Error: Received conflicting packet from client private-network-1 port 53062 - ID: 244 due to unfinished request 63063. Giving up on old request. Sat Jan 11 13:19:04 2 Is there anything more I can do to troubleshoot and get more logs (exept run radiusd -X with nohup or something). Could it be my script causing this, or my DB or freeradius? Thanks for any advice

2 3

Trouble getting ldaps to work
by Alberto Martínez 13 Jan '14

13 Jan '14

Hi. I'm having trouble setting up a rlm_ldap module. FR version is 3.0.0 Trimmed output from radiusd -X: radiusd: #### Instantiating modules #### instantiate { } modules { # Loaded module rlm_ldap # Instantiating module "ldap_xxxxxx" from file /usr/local/etc/raddb/mods-enabled/ldap_xxxxxx ldap ldap_xxxxxx { server = "ldap.example.org" port = 636 password = "whocares" identity = "someuser(a)example.org" user { filter = "(sAMAccountName=%{%{Stripped-User-Name}:-%{User-Name}})" scope = "sub" base_dn = "dc=example,dc=org" access_positive = yes } group { filter = "(objectClass=posixGroup)" scope = "sub" base_dn = "dc=example,dc=org" name_attribute = "cn" membership_attribute = "memberOf" cacheable_name = no cacheable_dn = no } client { scope = "sub" attribute { identifier = "host" shortname = "cn" } } profile { filter = "(&)" } options { ldap_debug = 40 chase_referrals = no rebind = yes net_timeout = 3 res_timeout = 20 srv_timelimit = 20 idle = 60 probes = 3 interval = 3 } tls { ca_file = "/usr/local/etc/raddb/certs/ca.example.org.pem" start_tls = no require_cert = "demand" } } accounting { reference = "." } post-auth { reference = "." } rlm_ldap (ldap_xxxxxx): Initialising connection pool pool { start = 4 min = 2 max = 6 spare = 2 uses = 0 lifetime = 0 cleanup_delay = 5 idle_timeout = 60 spread = no } rlm_ldap (ldap_xxxxxx): Opening additional connection (0) rlm_ldap (ldap_xxxxxx): Connecting to ldap.example.org:636 rlm_ldap (ldap_xxxxxx): Bind with someuser(a)example.org to ldap.example.org:636 failed: Can't contact LDAP server rlm_ldap (ldap_xxxxxx): Opening connection failed (0) rlm_ldap (ldap_xxxxxx): Removing connection pool /usr/local/etc/raddb/mods-enabled/ldap_xxxxxx[8]: Instantiation failed for module "ldap_xxxxxx" FR is able to bind with the LDAP server only if require_cert is set to "never", which makes me believe this is a certificate verification issue. I tried to do a manual connect using openssl using openssl s_client -connect ldap.example.org:636 -CAfile /usr/local/etc/raddb/certs/ca.example.org.pem -debug which shows a Verify return code: 0 (ok) Module is being called at the sites-enabled/default: authorize { .... -ldap_xxxxx .... } BTW: Why the "-" before the module name? TIA

4 10

Problem setting up EAP-TLS with hostap
by Chris Anderson 12 Jan '14

12 Jan '14

Hi I am having a problem that appears to be similar to http://freeradius.1045715.n5.nabble.com/suddenly-problem-with-certificates-… but the solution there didn't work. I have configured hostap to use radius on a free radius server running locally. I am trying to use certificates for authentication. To test this I am using a stock android device, with the certicates generated from /etc/raddb/certs directory. The certs are installed on android and they appear to be correct. I have installed both the CA certificate and the client certififate on the device. When I run freeradius with the -X option I get the following log. I though that it might have been a fragmentation problem so I set fragmentation to 1024 in both hostapd and freeradius but I still get the same error. Cheers Chris

3 3

detail: suppress not working in 3.0.0?
by Stefan Winter 12 Jan '14

12 Jan '14

Hello, I am currently converting from v2 to 3.0.0 and want to preserve my old behaviour of logging packets using a "detail" instance without logging the User-Password. The 3.0 raddb template (mods-available/detail.log) seems to look exactly like the 2.x one; so I've created the following in /usr/local/freeradius/config/raddb/modules/auth_log_silent (yes, the directory is called modules, not mods-enabled, that is intentional and configured like that; radiusd loads that directory instead of mods-enabled. Please don't beat me up for it.) detail auth_log_silent { filename = ${radacctdir}/%Y%m%d/%{RESTENA-Service-Type}-service/auth-detail permissions = 0600 suppress { User-Password } } But during startup, "permissions" and the "suppress" section get ignored (filename is picked up though): # Instantiating module "auth_log_silent" from file /usr/local/freeradius/config/raddb/modules/auth_log_silent detail auth_log_silent { filename = "/var/log/radius/radacct/%Y%m%d/%{RESTENA-Service-Type}-service/auth-detail" header = "%t" permissions = 384 dir_permissions = 493 locking = no log_packet_header = no } And the log files do contain the User-Password attribute. I'm also staring at the "permissions" line and wonder if it ignores my 0600? Is the example in raddb/ incorrect? Greetings, Stefan Winter -- Stefan WINTER Ingenieur de Recherche Fondation RESTENA - Réseau Téléinformatique de l'Education Nationale et de la Recherche 6, rue Richard Coudenhove-Kalergi L-1359 Luxembourg Tel: +352 424409 1 Fax: +352 422473 PGP key updated to 4096 Bit RSA - I will encrypt all mails if the recipient's key is known to me http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xC0DE6A358A39DC66

3 8

User-Profile and Fall-Through attributes
by Fernando Pizarro 11 Jan '14

11 Jan '14

Hi all, I'm running FreeRADIUS version 2.1.12 on Debian 7.3 and I'm using User-Profile attribute to organise my users into profiles. I have active read_groups in sql.conf file but in all groups I need add Fall-Through to get all attributes of the groups. Module: Linked to module rlm_sql Module: Instantiating module "sql" from file /etc/freeradius/sql.conf sql { driver = "rlm_sql_mysql" server = "localhost" port = "" login = "radius" password = "radpass" radius_db = "radiusdb" *read_groups = yes* sqltrace = no sqltracefile = "/var/log/freeradius/sqltrace.sql" readclients = yes deletestalesessions = yes For example: With Fall-Through attribute equal Yes, there is the result [sql] *Checking profile DF_V2_U3* [sql] sql_set_user escaped user --> 'DF_V2_U3' [sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = 'DF_V2_U3' ORDER BY priority [sql] expand: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id -> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'DF' ORDER BY id [sql] *User found in group DF* [sql] expand: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{Sql-Group}' ORDER BY id -> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'DF' ORDER BY id [sql] expand: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id -> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'V2' ORDER BY id [sql] *User found in group V2* [sql] expand: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{Sql-Group}' ORDER BY id -> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'V2' ORDER BY id [sql] expand: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id -> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'EX' ORDER BY id [sql] *User found in group EX* [sql] expand: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{Sql-Group}' ORDER BY id -> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'EX' ORDER BY id [sql] expand: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id -> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'U3' ORDER BY id [sql] *User found in group U3* [sql] expand: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{Sql-Group}' ORDER BY id -> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'U3' ORDER BY id rlm_sql (sql): Released sql socket id: 3 ++[sql] returns ok And with Fall-Through equal No or without it: [sql] *Checking profile DF_V2_U3* [sql] sql_set_user escaped user --> 'DF_V2_U3' [sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = 'DF_V2_U3' ORDER BY priority [sql] expand: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id -> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'DF' ORDER BY id [sql] *User found in group DF* [sql] expand: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{Sql-Group}' ORDER BY id -> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'DF' ORDER BY id rlm_sql (sql): Released sql socket id: 2 ++[sql] returns ok I add the User-Name and User-Profile with Fall-Through attribute in radreply table but doesn't work. Always I need add Fall-Through attribute at the groups or there are another way to create profiles? Regards. Fernando.

1 0

problem with counter reset In hourly -daily -weekly -monthly
by SORROW 10 Jan '14

10 Jan '14

hello friends I Test freeradius and run in ubuntu+MySql+Mikrotik as NAS .. FreeRADIUS Version 2.1.10, for host i686-pc-linux-gnu, built on Sep 24 2012 for limit Download user traffic daily i user this setting in /etc/freeradius/sql/mysql/counter.conf ==== sqlcounter counterChilliSpotMaxTotalOctetsDaily { counter-name = ChilliSpot-Max-Total-Octets-Daily check-name = CS-Total-Octets-Daily counter-type = data reply-name = Mikrotik-Xmit-Limit sqlmod-inst = sql key = User-Name reset = daily query = "SELECT (SUM(AcctInputOctets + AcctOutputOctets)) FROM radacct WHERE UserName='%{%k}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'" } ==== Now i have problem in reset= hourly - daily - weekly Or monthly . I dont know how to fix it for example i set for user CS-Total-Octets-Daily check attribute 10MB .. user in first login use 9MB and disconnect and re login again can use 10MB !! user must disconnect after 1MB and user stay connect ! in this example sum of two connection usage is 19MB !!! But if reset = never counter working correctly and user disconnected in exact usage ... in freeradius -X if reset = never Reply-Item for user is correct value [counterChilliSpotMaxTotalOctetsDaily] expand: %{sql:SELECT (SUM(AcctInputOctets + AcctOutputOctets)) FROM radacct WHERE UserName='test4' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '0'} -> 766328 rlm_sqlcounter: Check item is greater than query result rlm_sqlcounter: Authorized user test4, check_item=1000000, counter=766328 rlm_sqlcounter: Sent Reply-Item for user test4, Type=Mikrotik-Xmit-Limit, value=233672 ++[counterChilliSpotMaxTotalOctetsDaily] returns ok ===== In freeradius -X if reset = daily Reply-Item for user is not correct value [counterChilliSpotMaxTotalOctetsDaily] expand: %{sql:SELECT (SUM(AcctInputOctets + AcctOutputOctets)) FROM radacct WHERE UserName='test4' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '1389299400'} -> 727301 rlm_sqlcounter: Check item is greater than query result rlm_sqlcounter: Authorized user test4, check_item=1000000, counter=727301 rlm_sqlcounter: Sent Reply-Item for user test4, Type=Mikrotik-Xmit-Limit, value=1031030 ++[counterChilliSpotMaxTotalOctetsDaily] returns ok how can i solve this ?? regards

2 1