I have ROS 4.5 and FreeRadius. I have successfully used the Mikrotik-Address-List attribute with Framed-Pool to create a dynamic entry in the address list. I cannot seem to be able to use Mikrotik-Address-List & Framed-IP-Address to assign a static ip and create an entry in the address-list. Is this not allowed?
Are you using RADIUS with the hotspot? Or dhcp? Have you checked “/ip hotspot host”? I found the original ip issued to the client remains unchanged. But the to-address will show the correct framed-ip-address.
Sorry, forgot to mention I’m doing PPPOE.
A simple question, does Mikrotik-Address-List & Framed-IP-Address work together with PPPOE?
yes.
Ok and if it doesn’t work any why, here are the attributes from the radreply table.
id UserName Attribute op Value
453 LEFTY53 Acct-Interim-Interval := 3600
450 LEFTY53 Framed-IP-Address := 10.10.10.145
456 LEFTY53 Mikrotik-Address-List := basic
452 LEFTY53 Port-Limit := 1
451 LEFTY53 Session-Timeout := 21600
It works if i use Framed-Pool.
I now have a theory. If the response comes from the radgroupreply table it adds it to the address-list. If it comes from the radreply table it doesn’t. That doesn’t seem to be correct behavior.
Have some problem. But with Mikrotik 3.20. Can’t add to address list and turn off Encryption by radreply.
stored mysql procedure radreply(Framed address works fine)
BEGIN
DECLARE usr_id INT;
DECLARE usr_ip VARCHAR(15);
SELECT id,ip INTO usr_id,usr_ip FROM users WHERE name=login;
INSERT into dblogin (mid,act,time) VALUES (usr_id,47,unix_timestamp());
SELECT NULL,login,‘Mikrotik_Address_List’,‘SUPERMAN’,‘=’;
SELECT NULL,login,‘Framed-IP-Address’,usr_ip,‘=’;
SELECT NULL,login,‘Framed-IP-Netmask’,‘255.255.255.255’,‘=’;
SELECT NULL,login,‘Acct-Interim-Interval’,‘50’,‘=’;
SELECT NULL,login,‘MS-MPPE-Encryption-Types’,‘0’,‘=’;
END
I need help. Mikrotik does’nt accept his specific attributes from radius. Radius send’s reply with format specificated in previous post. Radius log checked.No errors. Mikrotik attributes added to dictionary by the following:
#
# This is the master dictionary file, which references the
# pre-defined dictionary files included with the server.
#
# Any new/changed attributes MUST be placed in this file, as
# the pre-defined dictionaries SHOULD NOT be edited.
#
# $Id$
#
#
# The filename given here should be an absolute path.
#
$INCLUDE /usr/share/freeradius/dictionary
#
# Place additional attributes or $INCLUDEs here. They will
# over-ride the definitions in the pre-defined dictionaries.
#
# See the 'man' page for 'dictionary' for information on
# the format of the dictionary files.
#
# If you want to add entries to the dictionary file,
# which are NOT going to be placed in a RADIUS packet,
# add them here. The numbers you pick should be between
# 3000 and 4000.
#
#ATTRIBUTE My-Local-String 3000 string
#ATTRIBUTE My-Local-IPAddr 3001 ipaddr
ATTRIBUTE MikroTik_Address_List 19 string
Dictionary file:
# -*- text -*-
# http://www.mikrotik.com
#
# http://www.mikrotik.com/documentation//manual_2.9/dictionary
#
# Do NOT follow their instructions and replace the dictionary
# in /etc/raddb with the one that they supply. It is NOT necessary.
#
# On top of that, the sample dictionary file they provide
# DOES NOT WORK. Do NOT use it.
#
# $Id$
#
VENDOR Mikrotik 14988
BEGIN-VENDOR Mikrotik
ATTRIBUTE Mikrotik-Recv-Limit 1 integer
ATTRIBUTE Mikrotik-Xmit-Limit 2 integer
# this attribute is unused
ATTRIBUTE Mikrotik-Group 3 string
ATTRIBUTE Mikrotik-Wireless-Forward 4 integer
ATTRIBUTE Mikrotik-Wireless-Skip-Dot1x 5 integer
ATTRIBUTE Mikrotik-Wireless-Enc-Algo 6 integer
ATTRIBUTE Mikrotik-Wireless-Enc-Key 7 string
ATTRIBUTE Mikrotik-Rate-Limit 8 string
ATTRIBUTE Mikrotik-Realm 9 string
ATTRIBUTE Mikrotik-Host-IP 10 ipaddr
ATTRIBUTE Mikrotik-Mark-Id 11 string
ATTRIBUTE Mikrotik-Advertise-URL 12 string
ATTRIBUTE Mikrotik-Advertise-Interval 13 integer
ATTRIBUTE Mikrotik-Recv-Limit-Gigawords 14 integer
ATTRIBUTE Mikrotik-Xmit-Limit-Gigawords 15 integer
ATTRIBUTE Mikrotik-Address-List 19 string
# MikroTik Values
VALUE Mikrotik-Wireless-Enc-Algo No-encryption 0
VALUE Mikrotik-Wireless-Enc-Algo 40-bit-WEP 1
VALUE Mikrotik-Wireless-Enc-Algo 104-bit-WEP 2
END-VENDOR Mikrotik
I add Mikrotik-Address-List in both. Freeradius 2
Help me please.
I don’t see the attribute Mikrotik-Address-List here under Access-Accept:
http://wiki.mikrotik.com/wiki/Manual:RADIUS_Client
Is this new?
ADD: My bad. There is. I just did not look far enough.
radgroupreply and radreply are freeradius concepts. The radius client (the router) just receives a list of attributes. This implies that freeradius is not sending the attribute when you have it in radreply, or it is sending multiple values for it and the router is not picking the right one to use. Perhaps you have an overriding attribute in radgroupreply (one with username DEFAULT). Turn on radius debug logging in the mikrotik, or do a packet sniff and see what attributes are actually being sent (I’m not sure if the radius debug logging will actually show this). Freeradius may also have an option to log what it is actually sending to a specific request.
Also, note the difference between :=, =, and += in the freeradius operators.
Offhand, I’m not sure whether radgroupreply or radreply take precedence when there is a conflict.
Thanks to all who participate. Error was only with correct typing.
Mikrotik-Address-List and not Mikrotik_Address_List and deleting override item from dictionary.
But with mppe…more interesting.
Guys,
good night.
My ATTRIBUTE Mikrotik-Address-List 19 string
is not working, i setted up on radreply the username, Mikrotik-Address-List, addressLISTname, but it’s not working.
If i send debug log freeradius -XXX > /var/www/rd.log, could anyone helpe me???
thx!
rad_recv: Access-Request packet from host 10.200.255.2 port 43203, id=10, length=147
Service-Type = Framed-User
Framed-Protocol = PPP
NAS-Port = 6
NAS-Port-Type = Ethernet
User-Name = “login1”
Calling-Station-Id = “08:00:27:78:D0:28”
Called-Station-Id = “Servidor-PPPoE-RB2”
NAS-Port-Id = “ether3”
CHAP-Challenge = 0x9d0a89efab940178e4c26079d47540a5
CHAP-Password = 0x016afaa4ff92e26f44656bb72f69a509a4
NAS-Identifier = “RB1”
NAS-IP-Address = 10.200.255.2
Mon Jun 16 13:22:24 2014 : Info: # Executing section authorize from file /etc/freeradius/sites-enabled/default
Mon Jun 16 13:22:24 2014 : Info: ± entering group authorize {…}
Mon Jun 16 13:22:24 2014 : Info: ++[preprocess] returns ok
Mon Jun 16 13:22:24 2014 : Info: [chap] Setting ‘Auth-Type := CHAP’
Mon Jun 16 13:22:24 2014 : Info: ++[chap] returns ok
Mon Jun 16 13:22:24 2014 : Info: ++[mschap] returns noop
Mon Jun 16 13:22:24 2014 : Info: ++[digest] returns noop
Mon Jun 16 13:22:24 2014 : Info: [suffix] No ‘@’ in User-Name = “login1”, looking up realm NULL
Mon Jun 16 13:22:24 2014 : Info: [suffix] No such realm “NULL”
Mon Jun 16 13:22:24 2014 : Info: ++[suffix] returns noop
Mon Jun 16 13:22:24 2014 : Info: [eap] No EAP-Message, not doing EAP
Mon Jun 16 13:22:24 2014 : Info: ++[eap] returns noop
Mon Jun 16 13:22:24 2014 : Info: [sql] expand: %{User-Name} → login1
Mon Jun 16 13:22:24 2014 : Info: [sql] sql_set_user escaped user → ‘login1’
Mon Jun 16 13:22:24 2014 : Debug: rlm_sql (sql): Reserving sql socket id: 0
Mon Jun 16 13:22:24 2014 : Info: [sql] expand: SELECT id, username, attribute, value, op FROM radcheck WHERE username = BINARY ‘%{SQL-User-Name}’ AND enable = ‘Y’ ORDER BY id → SELECT id, username, attribute, value, op FROM radcheck WHERE username = BINARY ‘login1’ AND enable = ‘Y’ ORDER BY id
Mon Jun 16 13:22:24 2014 : Info: [sql] User found in radcheck table
Mon Jun 16 13:22:24 2014 : Info: [sql] expand: SELECT id, username, attribute, value, op FROM radreply WHERE username = BINARY ‘%{SQL-User-Name}’ AND enable = ‘Y’ ORDER BY id → SELECT id, username, attribute, value, op FROM radreply WHERE username = BINARY ‘login1’ AND enable = ‘Y’ ORDER BY id
Mon Jun 16 13:22:24 2014 : Info: [sql] expand: SELECT groupname FROM radusergroup WHERE username = ‘%{SQL-User-Name}’ ORDER BY priority → SELECT groupname FROM radusergroup WHERE username = ‘login1’ ORDER BY priority
Mon Jun 16 13:22:24 2014 : Info: [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 = ‘plano5mb’ ORDER BY id
Mon Jun 16 13:22:24 2014 : Info: [sql] User found in group plano5mb
Mon Jun 16 13:22:24 2014 : Info: [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 = ‘plano5mb’ ORDER BY id
Mon Jun 16 13:22:24 2014 : Debug: rlm_sql (sql): Released sql socket id: 0
Mon Jun 16 13:22:24 2014 : Info: ++[sql] returns ok
Mon Jun 16 13:22:24 2014 : Info: [sql] expand: %{User-Name} → login1
Mon Jun 16 13:22:24 2014 : Info: [sql] sql_set_user escaped user → ‘login1’
Mon Jun 16 13:22:24 2014 : Debug: rlm_sql (sql): Reserving sql socket id: 4
Mon Jun 16 13:22:24 2014 : Info: [sql] expand: SELECT id, username, attribute, value, op FROM radcheck WHERE username = BINARY ‘%{SQL-User-Name}’ AND enable = ‘Y’ ORDER BY id → SELECT id, username, attribute, value, op FROM radcheck WHERE username = BINARY ‘login1’ AND enable = ‘Y’ ORDER BY id
Mon Jun 16 13:22:24 2014 : Info: [sql] User found in radcheck table
Mon Jun 16 13:22:24 2014 : Info: [sql] expand: SELECT id, username, attribute, value, op FROM radreply WHERE username = BINARY ‘%{SQL-User-Name}’ AND enable = ‘Y’ ORDER BY id → SELECT id, username, attribute, value, op FROM radreply WHERE username = BINARY ‘login1’ AND enable = ‘Y’ ORDER BY id
Mon Jun 16 13:22:24 2014 : Info: [sql] expand: SELECT groupname FROM radusergroup WHERE username = ‘%{SQL-User-Name}’ ORDER BY priority → SELECT groupname FROM radusergroup WHERE username = ‘login1’ ORDER BY priority
Mon Jun 16 13:22:24 2014 : Info: [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 = ‘plano5mb’ ORDER BY id
Mon Jun 16 13:22:24 2014 : Info: [sql] User found in group plano5mb
Mon Jun 16 13:22:24 2014 : Info: [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 = ‘plano5mb’ ORDER BY id
Mon Jun 16 13:22:24 2014 : Debug: rlm_sql (sql): Released sql socket id: 4
Mon Jun 16 13:22:24 2014 : Info: ++[sql] returns ok
Mon Jun 16 13:22:24 2014 : Info: ++? if (notfound)
Mon Jun 16 13:22:24 2014 : Info: ? Evaluating (notfound) → FALSE
Mon Jun 16 13:22:24 2014 : Info: ++? if (notfound) → FALSE
Mon Jun 16 13:22:24 2014 : Info: ++[expiration] returns noop
Mon Jun 16 13:22:24 2014 : Info: ++[logintime] returns noop
Mon Jun 16 13:22:24 2014 : Info: [pap] WARNING: Auth-Type already set. Not setting to PAP
Mon Jun 16 13:22:24 2014 : Info: ++[pap] returns noop
Mon Jun 16 13:22:24 2014 : Info: Found Auth-Type = CHAP
Mon Jun 16 13:22:24 2014 : Info: # Executing group from file /etc/freeradius/sites-enabled/default
Mon Jun 16 13:22:24 2014 : Info: ± entering group CHAP {…}
Mon Jun 16 13:22:24 2014 : Info: [chap] login attempt by “login1” with CHAP password
Mon Jun 16 13:22:24 2014 : Info: [chap] Using clear text password “123” for user login1 authentication.
Mon Jun 16 13:22:24 2014 : Info: [chap] chap user login1 authenticated succesfully
Mon Jun 16 13:22:24 2014 : Info: ++[chap] returns ok
Mon Jun 16 13:22:24 2014 : Info: ++? if (reject)
Mon Jun 16 13:22:24 2014 : Info: ? Evaluating (reject) → FALSE
Mon Jun 16 13:22:24 2014 : Info: ++? if (reject) → FALSE
Mon Jun 16 13:22:24 2014 : Info: # Executing section session from file /etc/freeradius/sites-enabled/default
Mon Jun 16 13:22:24 2014 : Info: ± entering group session {…}
Mon Jun 16 13:22:24 2014 : Info: [sql] expand: %{User-Name} → login1
Mon Jun 16 13:22:24 2014 : Info: [sql] sql_set_user escaped user → ‘login1’
Mon Jun 16 13:22:24 2014 : Info: [sql] expand: SELECT COUNT() FROM radacct WHERE username = ‘%{SQL-User-Name}’ AND acctstoptime IS NULL → SELECT COUNT() FROM radacct WHERE username = ‘login1’ AND acctstoptime IS NULL
Mon Jun 16 13:22:24 2014 : Debug: rlm_sql (sql): Reserving sql socket id: 3
Mon Jun 16 13:22:24 2014 : Debug: rlm_sql (sql): Released sql socket id: 3
Mon Jun 16 13:22:24 2014 : Info: ++[sql] returns ok
Mon Jun 16 13:22:24 2014 : Info: # Executing section post-auth from file /etc/freeradius/sites-enabled/default
Mon Jun 16 13:22:24 2014 : Info: ± entering group post-auth {…}
Mon Jun 16 13:22:24 2014 : Info: [sqlippool] No Pool-Name defined.
Mon Jun 16 13:22:24 2014 : Info: [sqlippool] expand: No Pool-Name defined (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name}) → No Pool-Name defined (did Servidor-PPPoE-RB2 cli 08:00:27:78:D0:28 port 6 user login1)
Mon Jun 16 13:22:24 2014 : Info: No Pool-Name defined (did Servidor-PPPoE-RB2 cli 08:00:27:78:D0:28 port 6 user login1)
Mon Jun 16 13:22:24 2014 : Info: ++[sqlippool] returns noop
Mon Jun 16 13:22:24 2014 : Info: [sql] expand: %{User-Name} → login1
Mon Jun 16 13:22:24 2014 : Info: [sql] sql_set_user escaped user → ‘login1’
Mon Jun 16 13:22:24 2014 : Info: [sql] expand: %{User-Password} →
Mon Jun 16 13:22:24 2014 : Info: [sql] … expanding second conditional
Mon Jun 16 13:22:24 2014 : Info: [sql] expand: %{Chap-Password} → 0x016afaa4ff92e26f44656bb72f69a509a4
Mon Jun 16 13:22:24 2014 : Info: [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 ( ‘login1’, ‘0x016afaa4ff92e26f44656bb72f69a509a4’, ‘Access-Accept’, ‘2014-06-16 13:22:24’)
Mon Jun 16 13:22:24 2014 : Debug: rlm_sql (sql) in sql_postauth: query is INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( ‘login1’, ‘0x016afaa4ff92e26f44656bb72f69a509a4’, ‘Access-Accept’, ‘2014-06-16 13:22:24’)
Mon Jun 16 13:22:24 2014 : Debug: rlm_sql (sql): Reserving sql socket id: 2
Mon Jun 16 13:22:24 2014 : Debug: rlm_sql (sql): Released sql socket id: 2
Mon Jun 16 13:22:24 2014 : Info: ++[sql] returns ok
Mon Jun 16 13:22:24 2014 : Info: [sql_log] Processing sql_log_postauth
Mon Jun 16 13:22:24 2014 : Info: [sql_log] expand: %{User-Name} → login1
Mon Jun 16 13:22:24 2014 : Info: [sql_log] expand: %{%{User-Name}:-DEFAULT} → login1
Mon Jun 16 13:22:24 2014 : Info: [sql_log] sql_set_user escaped user → ‘login1’
Mon Jun 16 13:22:24 2014 : Info: [sql_log] WARNING: Deprecated conditional expansion “:-”. See “man unlang” for details
Mon Jun 16 13:22:24 2014 : Info: [sql_log] … expanding second conditional
Mon Jun 16 13:22:24 2014 : Info: [sql_log] expand: Chap-Password → Chap-Password
Mon Jun 16 13:22:24 2014 : Info: [sql_log] 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 (‘login1’, ‘Chap-Password’, ‘Access-Accept’, ‘2014-06-16 13:22:24’);
Mon Jun 16 13:22:24 2014 : Info: [sql_log] expand: /var/log/freeradius/radacct/sql-relay → /var/log/freeradius/radacct/sql-relay
Mon Jun 16 13:22:24 2014 : Info: ++[sql_log] returns ok
Mon Jun 16 13:22:24 2014 : Info: ++[exec] returns noop
Sending Access-Accept of id 10 to 10.200.255.2 port 43203
Mikrotik-Address-List := “pgcorte”
Mikrotik-Rate-Limit := “256k/256k”
Mon Jun 16 13:22:24 2014 : Info: Finished request 3.
Mon Jun 16 13:22:24 2014 : Debug: Going to the next request
Mon Jun 16 13:22:24 2014 : Debug: Waking up in 4.9 seconds.
rad_recv: Accounting-Request packet from host 10.200.255.2 port 41396, id=11, length=150
Service-Type = Framed-User
Framed-Protocol = PPP
NAS-Port = 6
NAS-Port-Type = Ethernet
User-Name = “login1”
Calling-Station-Id = “08:00:27:78:D0:28”
Called-Station-Id = “Servidor-PPPoE-RB2”
NAS-Port-Id = “ether3”
Acct-Session-Id = “81f00001”
Framed-IP-Address = 172.16.0.3
Acct-Authentic = RADIUS
Event-Timestamp = “Jun 16 2014 09:22:24 AMT”
Acct-Status-Type = Start
NAS-Identifier = “RB1”
Acct-Delay-Time = 0
NAS-IP-Address = 10.200.255.2
Mon Jun 16 13:22:24 2014 : Info: # Executing section preacct from file /etc/freeradius/sites-enabled/default
Mon Jun 16 13:22:24 2014 : Info: ± entering group preacct {…}
Mon Jun 16 13:22:24 2014 : Info: ++[preprocess] returns ok
Mon Jun 16 13:22:24 2014 : Info: [acct_unique] Hashing ‘NAS-Port = 6,Client-IP-Address = 10.200.255.2,NAS-IP-Address = 10.200.255.2,Acct-Session-Id = “81f00001”,User-Name = “login1”’
Mon Jun 16 13:22:24 2014 : Info: [acct_unique] Acct-Unique-Session-ID = “b5e2221bab0044e2”.
Mon Jun 16 13:22:24 2014 : Info: ++[acct_unique] returns ok
Mon Jun 16 13:22:24 2014 : Info: [suffix] No ‘@’ in User-Name = “login1”, looking up realm NULL
Mon Jun 16 13:22:24 2014 : Info: [suffix] No such realm “NULL”
Mon Jun 16 13:22:24 2014 : Info: ++[suffix] returns noop
Mon Jun 16 13:22:24 2014 : Info: ++[files] returns noop
Mon Jun 16 13:22:24 2014 : Info: # Executing section accounting from file /etc/freeradius/sites-enabled/default
Mon Jun 16 13:22:24 2014 : Info: ± entering group accounting {…}
Mon Jun 16 13:22:24 2014 : Info: [detail] expand: %{Packet-Src-IP-Address} → 10.200.255.2
Mon Jun 16 13:22:24 2014 : Info: [detail] expand: /var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d → /var/log/freeradius/radacct/10.200.255.2/detail-20140616
Mon Jun 16 13:22:24 2014 : Info: [detail] /var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/freeradius/radacct/10.200.255.2/detail-20140616
Mon Jun 16 13:22:24 2014 : Info: [detail] expand: %t → Mon Jun 16 13:22:24 2014
Mon Jun 16 13:22:24 2014 : Info: ++[detail] returns ok
Mon Jun 16 13:22:24 2014 : Info: ++[unix] returns ok
Mon Jun 16 13:22:24 2014 : Debug: rlm_sql (sql): Reserving sql socket id: 1
Mon Jun 16 13:22:24 2014 : Info: [sqlippool] expand: %{User-Name} → login1
Mon Jun 16 13:22:24 2014 : Info: [sqlippool] sql_set_user escaped user → ‘login1’
Mon Jun 16 13:22:24 2014 : Info: [sqlippool] expand: START TRANSACTION → START TRANSACTION
Mon Jun 16 13:22:24 2014 : Info: [sqlippool] expand: UPDATE radippool SET expiry_time = NOW() + INTERVAL 3600 SECOND WHERE nasipaddress = ‘%{NAS-IP-Address}’ AND pool_key = ‘%{NAS-Port}’ AND username = ‘%{User-Name}’ AND callingstationid = ‘%{Calling-Station-Id}’ AND framedipaddress = ‘%{Framed-IP-Address}’ → UPDATE radippool SET expiry_time = NOW() + INTERVAL 3600 SECOND WHERE nasipaddress = ‘10.200.255.2’ AND pool_key = ‘6’ AND username = ‘login1’ AND callingstationid = ‘08:00:27:78:D0:28’ AND framedipaddress = ‘172.16.0.3’
Mon Jun 16 13:22:24 2014 : Info: [sqlippool] expand: COMMIT → COMMIT
Mon Jun 16 13:22:24 2014 : Debug: rlm_sql (sql): Released sql socket id: 1
Mon Jun 16 13:22:24 2014 : Info: ++[sqlippool] returns ok
Mon Jun 16 13:22:24 2014 : Info: ++? if (Acct-Status-Type)
Mon Jun 16 13:22:24 2014 : Info: ? Evaluating (Acct-Status-Type) → TRUE
Mon Jun 16 13:22:24 2014 : Info: ++? if (Acct-Status-Type) → TRUE
Mon Jun 16 13:22:24 2014 : Info: +± entering if (Acct-Status-Type) {…}
Mon Jun 16 13:22:24 2014 : Info: [sql] expand: %{User-Name} → login1
Mon Jun 16 13:22:24 2014 : Info: [sql] sql_set_user escaped user → ‘login1’
Mon Jun 16 13:22:24 2014 : Info: [sql] expand: %{Acct-Delay-Time} → 0
Mon Jun 16 13:22:24 2014 : Info: [sql] expand: INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, acctstartdelay, acctstopdelay, xascendsessionsvrkey) VALUES (‘%{Acct-Session-Id}’, ‘%{Acct-Unique-Session-Id}’, ‘%{SQL-User-Name}’, ‘%{Realm}’, ‘%{NAS-IP-Address}’, ‘%{NAS-Port}’, ‘%{NAS-Port-Type}’, ‘%S’, NULL, ‘0’, ‘%{Acct-Authentic}’, ‘%{Connect-Info}’, ‘’, ‘0’, ‘0’, ‘%{Called-Station-Id}’, ‘%{Calling-Station-Id}’, ‘’, ‘%{Service-Type}’, ‘%{Framed-Protocol}’, ‘%{Framed-IP-Address}’,
Mon Jun 16 13:22:24 2014 : Debug: rlm_sql (sql): Reserving sql socket id: 0
Mon Jun 16 13:22:24 2014 : Debug: rlm_sql (sql): Released sql socket id: 0
Mon Jun 16 13:22:24 2014 : Info: +++[sql] returns ok
Mon Jun 16 13:22:24 2014 : Info: +± if (Acct-Status-Type) returns ok
Mon Jun 16 13:22:24 2014 : Info: ++[exec] returns noop
Mon Jun 16 13:22:24 2014 : Info: [attr_filter.accounting_response] expand: %{User-Name} → login1
Mon Jun 16 13:22:24 2014 : Debug: attr_filter: Matched entry DEFAULT at line 12
Mon Jun 16 13:22:24 2014 : Info: ++[attr_filter.accounting_response] returns updated
Sending Accounting-Response of id 11 to 10.200.255.2 port 41396
Mon Jun 16 13:22:24 2014 : Info: Finished request 4.
Mon Jun 16 13:22:24 2014 : Info: Cleaning up request 4 ID 11 with timestamp +95
Mon Jun 16 13:22:24 2014 : Debug: Going to the next request
Mon Jun 16 13:22:24 2014 : Debug: Waking up in 4.9 seconds.
Mon Jun 16 13:22:29 2014 : Info: Cleaning up request 3 ID 10 with timestamp +95
Mon Jun 16 13:22:29 2014 : Info: Ready to process requests.
here you can see:
Sending Access-Accept of id 10 to 10.200.255.2 port 43203
Mikrotik-Address-List := “pgcorte”
Mikrotik-Rate-Limit := “256k/256k”
but the client recive mikrotik-rate-limit, but dont recive mikrotik-address-list =[
Guys
now it’s working!!! i got it!!!
Do you mind sharing your config if you still have it?
how it is working?
please help me too in this issue
thanks