<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'><div>Hi,</div><div><br></div><div>I am having some trouble with freeradius and the SQL module. The issue i have is the radgroupcheck and radgroupreply tables never get read by freeradius. I cannot find a reason why the group tables aren't being used, they meet the requirements according the the wiki.</div><div><br></div><div>Specifically my Pool-Name is not being pulled and assigned to the user from the groupcheck. If i set the pool name in radcheck and not radgroupcheck it works and the user is assigned an IP from the pool.</div><div><br></div><div>In the sql.conf i have checked "read_groups = yes" is set</div><div><br></div><div>The sqlippool and sql modules are enabled in the default sites setup hence it works when set in radcheck. This problem is because the groups are not being read. I would really like some help as to why my groups aren't working </div><div><br></div><div>Here is my config and a debug out of radiusd -X </div><div><br></div><div>MariaDB [radius]> select * from radcheck;</div><div>+----+----------+--------------------+----+-------+</div><div>| id | username | attribute | op | value |</div><div>+----+----------+--------------------+----+-------+</div><div>| 1 | user | Cleartext-Password | := | pass |</div><div>+----+----------+--------------------+----+-------+</div><div>4 rows in set (0.00 sec)</div><div><br></div><div>MariaDB [radius]> select * from radusergroup;</div><div>+----------+-----------+----------+</div><div>| username | groupname | priority |</div><div>+----------+-----------+----------+</div><div>| user | vpngroup | 1 |</div><div>+----------+-----------+----------+</div><div>1 row in set (0.00 sec)</div><div><br></div><div>MariaDB [radius]> select * from radgroupcheck;</div><div>+----+-----------+--------------+----+-------+</div><div>| id | groupname | attribute | op | value |</div><div>+----+-----------+--------------+----+-------+</div><div>| 3 | vpngroup | Pool-Name | := | pool1 |</div><div>+----+-----------+--------------+----+-------+</div><div>2 rows in set (0.01 sec)</div><div><br></div><div>MariaDB [radius]> select * from radippool;</div><div>+----+-----------+-----------------+--------------+-----------------+------------------+---------------------+----------+----------+</div><div>| id | pool_name | framedipaddress | nasipaddress | calledstationid | callingstationid | expiry_time | username | pool_key |</div><div>+----+-----------+-----------------+--------------+-----------------+------------------+---------------------+----------+----------+</div><div>| 1 | pool1 | 172.16.15.1 | | | | NULL | | 0 |</div><div>| 2 | pool1 | 172.16.15.2 | <span class="Apple-tab-span" style="white-space:pre"> </span> | | | NULL<span class="Apple-tab-span" style="white-space:pre"> </span>| <span class="Apple-tab-span" style="white-space:pre"> </span> | |</div><div>| 3 | pool1 | 172.16.15.3 | | | | NULL | | |</div><div>+----+-----------+-----------------+--------------+-----------------+------------------+---------------------+----------+----------+</div><div>3 rows in set (0.00 sec)</div><div><br></div><div><br></div><div>From the above it meets the requirements set out in the wiki - <a href="http://wiki.freeradius.org/modules/Rlm_sql" target="_blank" style="font-size: 12pt;">http://wiki.freeradius.org/modules/Rlm_sql</a></div><div><br><br><br></div><div><ul style="margin: 15px 0px; padding-right: 0px; padding-left: 30px; color: rgb(51, 51, 51); font-family: Helvetica, arial, freesans, clean, sans-serif; font-size: 13px; line-height: 20px;"><li style="margin: 0px; padding: 0px;">"The user IS found in radcheck, the check items DO match AND the <a class="internal absent" href="http://wiki.freeradius.org/read_groups" style="margin: 0px; padding: 0px; color: rgb(204, 0, 0);">read_groups</a> directive is set to 'yes' " </li></ul></div><div><br></div><div><br></div><div>From the debug out you can see it doesn't check the groups then moves on and says " (0) sqlippool : No Pool-Name defined." </div><div><br></div><div>I have also checked the file /etc/raddb/mods-config/sql/main/mysql/queries.conf and i see the queries for the groupcheck its just not doing it </div><div><br></div><div><br></div><div><br></div><div>Ready to process requests.</div><div>rad_recv: Access-Request packet from host 192.168.1.109 port 55758, id=53, length=146</div><div> Service-Type = Framed-User</div><div> Framed-Protocol = PPP</div><div> User-Name = 'test'</div><div> MS-CHAP-Challenge = 0x7098b7e479b88ea6ea646493435c771e</div><div> MS-CHAP2-Response = 0x7a002c2ae80d2311583f5e38117753a3dc7a0000000000000000eef14310bcc325e0edb4908298df6014328fc042ddaf2360</div><div> Calling-Station-Id = '192.168.1.70'</div><div> NAS-IP-Address = 127.0.0.1</div><div> NAS-Port = 0</div><div>(0) # Executing section authorize from file /etc/raddb/sites-enabled/default</div><div>(0) authorize {</div><div>(0) filter_username filter_username {</div><div>(0) ? if (User-Name != "%{tolower:%{User-Name}}") </div><div>(0) expand: "%{tolower:%{User-Name}}" -> 'test'</div><div>(0) ? if (User-Name != "%{tolower:%{User-Name}}") -> FALSE</div><div>(0) ? if (User-Name =~ / /) </div><div>(0) ? if (User-Name =~ / /) -> FALSE</div><div>(0) ? if (User-Name =~ /@.*@/ ) </div><div>(0) ? if (User-Name =~ /@.*@/ ) -> FALSE</div><div>(0) ? if (User-Name =~ /\\.\\./ ) </div><div>(0) ? if (User-Name =~ /\\.\\./ ) -> FALSE</div><div>(0) ? if ((User-Name =~ /@/) && (User-Name !~ /@(.+)\\.(.+)$/)) </div><div>(0) ? if ((User-Name =~ /@/) && (User-Name !~ /@(.+)\\.(.+)$/)) -> FALSE</div><div>(0) ? if (User-Name =~ /\\.$/) </div><div>(0) ? if (User-Name =~ /\\.$/) -> FALSE</div><div>(0) ? if (User-Name =~ /@\\./) </div><div>(0) ? if (User-Name =~ /@\\./) -> FALSE</div><div>(0) } # filter_username filter_username = notfound</div><div>(0) [preprocess] = ok</div><div>(0) auth_log : expand: "/var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/auth-detail-%Y%m%d" -> '/var/log/radius/radacct/192.168.1.109/auth-detail-20140926'</div><div>(0) auth_log : /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/auth-detail-%Y%m%d expands to /var/log/radius/radacct/192.168.1.109/auth-detail-20140926</div><div>(0) auth_log : expand: "%t" -> 'Fri Sep 26 06:51:18 2014'</div><div>(0) [auth_log] = ok</div><div>(0) [chap] = noop</div><div>(0) mschap : Found MS-CHAP attributes. Setting 'Auth-Type = mschap'</div><div>(0) [mschap] = ok</div><div>(0) [digest] = noop</div><div>(0) suffix : No '@' in User-Name = "test", looking up realm NULL</div><div>(0) suffix : No such realm "NULL"</div><div>(0) [suffix] = noop</div><div>(0) eap : No EAP-Message, not doing EAP</div><div>(0) [eap] = noop</div><div>(0) files : users: Matched entry DEFAULT at line 181</div><div>(0) [files] = ok</div><div>(0) sql : expand: "%{User-Name}" -> 'test'</div><div>(0) sql : SQL-User-Name set to 'test'</div><div>rlm_sql (sql): Reserved connection (4)</div><div>(0) 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 = 'test' ORDER BY id'</div><div>rlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'test' ORDER BY id'</div><div>(0) sql : User found in radcheck table</div><div>(0) sql : Check items matched</div><div>(0) 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 = 'test' ORDER BY id'</div><div>rlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op FROM radreply WHERE username = 'test' ORDER BY id'</div><div>(0) sql : expand: "SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority" -> 'SELECT groupname FROM radusergroup WHERE username = 'test' ORDER BY priority'</div><div>rlm_sql (sql): Executing query: 'SELECT groupname FROM radusergroup WHERE username = 'test' ORDER BY priority'</div><div>rlm_sql (sql): Released connection (4)</div><div>rlm_sql (sql): Closing connection (0): Too many free connections (5 > 3)</div><div>rlm_sql_mysql: Socket destructor called, closing socket</div><div>(0) [sql] = ok</div><div>(0) [expiration] = noop</div><div>(0) [logintime] = noop</div><div>(0) WARNING: pap : Auth-Type already set. Not setting to PAP</div><div>(0) [pap] = noop</div><div>(0) } # authorize = ok</div><div>(0) Found Auth-Type = MSCHAP</div><div>(0) # Executing group from file /etc/raddb/sites-enabled/default</div><div>(0) Auth-Type MS-CHAP {</div><div>(0) mschap : Found Cleartext-Password, hashing to create LM-Password</div><div>(0) mschap : Found Cleartext-Password, hashing to create NT-Password</div><div>(0) mschap : Creating challenge hash with username: test</div><div>(0) mschap : Client is using MS-CHAPv2 for test, we need NT-Password</div><div>(0) mschap : adding MS-CHAPv2 MPPE keys</div><div>(0) [mschap] = ok</div><div>(0) } # Auth-Type MS-CHAP = ok</div><div>(0) Login OK: [test/<via Auth-Type = MSCHAP>] (from client 192.168.1.109 port 0 cli 192.168.1.70)</div><div>(0) # Executing section post-auth from file /etc/raddb/sites-enabled/default</div><div>(0) post-auth {</div><div>(0) sql : expand: ".query" -> '.query'</div><div>(0) sql : Using query template 'query'</div><div>rlm_sql (sql): Reserved connection (4)</div><div>(0) sql : expand: "%{User-Name}" -> 'test'</div><div>(0) sql : SQL-User-Name set to 'test'</div><div>(0) sql : expand: "INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{SQL-User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S')" -> 'INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( 'test', '', 'Access-Accept', '2014-09-26 06:51:18')'</div><div>rlm_sql (sql): Executing query: 'INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( 'test', '', 'Access-Accept', '2014-09-26 06:51:18')'</div><div>rlm_sql (sql): Released connection (4)</div><div>(0) [sql] = ok</div><div>(0) sqlippool : No Pool-Name defined.</div><div>(0) 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 cli 192.168.1.70 port 0 user test)'</div><div>(0) [sqlippool] = noop</div><div>(0) [exec] = noop</div><div>(0) remove_reply_message_if_eap remove_reply_message_if_eap {</div><div>(0) ? if (reply:EAP-Message && reply:Reply-Message) </div><div>(0) ? if (reply:EAP-Message && reply:Reply-Message) -> FALSE</div><div>(0) else else {</div><div>(0) [noop] = noop</div><div>(0) } # else else = noop</div><div>(0) } # remove_reply_message_if_eap remove_reply_message_if_eap = noop</div><div>(0) } # post-auth = ok</div><div>Sending Access-Accept of id 53 from 192.168.1.67 port 1812 to 192.168.1.109 port 55758</div><div> Framed-Protocol = PPP</div><div> Framed-Compression = Van-Jacobson-TCP-IP</div><div> MS-CHAP2-Success = 0x7a533d30383134394335414641303837374636373833433934413034313938373737363341344231433632</div><div> MS-MPPE-Recv-Key = 0xa2232b07eab47e9464305946464fdd13</div><div> MS-MPPE-Send-Key = 0xf1ab397d79c4eb450b5dde7dad811f1d</div><div> MS-MPPE-Encryption-Policy = Encryption-Required</div><div> MS-MPPE-Encryption-Types = 4</div><div>(0) Finished request 0.</div><div>Waking up in 0.2 seconds.</div><div>Waking up in 4.7 seconds.</div><div>rad_recv: Accounting-Request packet from host 192.168.1.109 port 35133, id=54, length=110</div><div> Acct-Session-Id = '5425A63435B300'</div><div> User-Name = 'test'</div><div> Acct-Status-Type = Start</div><div> Service-Type = Framed-User</div><div> Framed-Protocol = PPP</div><div> Calling-Station-Id = '192.168.1.70'</div><div> Acct-Authentic = RADIUS</div><div> NAS-Port-Type = Async</div><div> Framed-IP-Address = 192.168.1.1</div><div> NAS-IP-Address = 127.0.0.1</div><div> NAS-Port = 0</div><div> Acct-Delay-Time = 0</div><div>(1) # Executing section preacct from file /etc/raddb/sites-enabled/default</div><div>(1) preacct {</div><div>(1) [preprocess] = ok</div><div>(1) acct_unique acct_unique {</div><div>(1) ? if ("%{string:Class}" =~ /ai:([0-9a-f]{32})/i) </div><div>(1) expand: "%{string:Class}" -> ''</div><div>(1) ? if ("%{string:Class}" =~ /ai:([0-9a-f]{32})/i) -> FALSE</div><div>(1) else else {</div><div>(1) update request {</div><div>(1) expand: "%{md5:%{User-Name},%{Acct-Session-ID},%{NAS-IP-Address},%{NAS-Identifier},%{NAS-Port-ID},%{NAS-Port}}" -> '84b95fb1219c04cd5fd1f53d294840aa'</div><div>(1) Acct-Unique-Session-Id := "84b95fb1219c04cd5fd1f53d294840aa"</div><div>(1) } # update request = noop</div><div>(1) } # else else = noop</div><div>(1) } # acct_unique acct_unique = noop</div><div>(1) suffix : No '@' in User-Name = "test", looking up realm NULL</div><div>(1) suffix : No such realm "NULL"</div><div>(1) [suffix] = noop</div><div>(1) [files] = noop</div><div>(1) } # preacct = ok</div><div>(1) # Executing section accounting from file /etc/raddb/sites-enabled/default</div><div>(1) accounting {</div><div>(1) detail : expand: "/var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d" -> '/var/log/radius/radacct/192.168.1.109/detail-20140926'</div><div>(1) detail : /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/radius/radacct/192.168.1.109/detail-20140926</div><div>(1) detail : expand: "%t" -> 'Fri Sep 26 06:51:20 2014'</div><div>(1) [detail] = ok</div><div>(1) [unix] = ok</div><div>rlm_sql (sql): Reserved connection (4)</div><div>(1) sqlippool : expand: "%{User-Name}" -> 'test'</div><div>(1) sqlippool : SQL-User-Name set to 'test'</div><div>(1) sqlippool : expand: "START TRANSACTION" -> 'START TRANSACTION'</div><div>rlm_sql (sql): Executing query: 'START TRANSACTION'</div><div>(1) 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 = '127.0.0.1' AND pool_key = '0' AND username = 'test' AND callingstationid = '192.168.1.70' AND framedipaddress = '192.168.1.1''</div><div>rlm_sql (sql): Executing query: 'UPDATE radippool SET expiry_time = NOW() + INTERVAL 3600 SECOND WHERE nasipaddress = '127.0.0.1' AND pool_key = '0' AND username = 'test' AND callingstationid = '192.168.1.70' AND framedipaddress = '192.168.1.1''</div><div>(1) sqlippool : expand: "COMMIT" -> 'COMMIT'</div><div>rlm_sql (sql): Executing query: 'COMMIT'</div><div>rlm_sql (sql): Released connection (4)</div><div>rlm_sql (sql): Closing connection (1): Too many free connections (4 > 3)</div><div>rlm_sql_mysql: Socket destructor called, closing socket</div><div>(1) [sqlippool] = ok</div><div>(1) sql : expand: "%{tolower:type.%{Acct-Status-Type}.query}" -> 'type.start.query'</div><div>(1) sql : Using query template 'query'</div><div>rlm_sql (sql): Reserved connection (4)</div><div>(1) sql : expand: "%{User-Name}" -> 'test'</div><div>(1) sql : SQL-User-Name set to 'test'</div><div>(1) sql : expand: "INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', FROM_UNIXTIME(%{integer:Event-Timestamp}), FROM_UNIXTIME(%{integer:Event-Timestamp}), NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}')" -> 'INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress) VALUES ('5425A63435B300', '84b95fb1219c04cd5fd1f53d294840aa', 'test', '', '127.0.0.1', '0', 'Async', FROM_UNIXTIME(1411710680), FROM_UNIXTIME(1411710680), NULL, '0', 'RADIUS', '', '', '0', '0', '', '192.168.1.70', '', 'Framed-User', 'PPP', '192.168.1.1')'</div><div>rlm_sql (sql): Executing query: 'INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype,acctstarttime, acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress) VALUES ('5425A63435B300', '84b95fb1219c04cd5fd1f53d294840aa', 'test', '', '127.0.0.1', '0', 'Async', FROM_UNIXTIME(1411710680), FROM_UNIXTIME(1411710680), NULL, '0', 'RADIUS', '', '', '0', '0', '', '192.168.1.70', '', 'Framed-User', 'PPP', '192.168.1.1')'</div><div>rlm_sql (sql): Released connection (4)</div><div>(1) [sql] = ok</div><div>(1) [exec] = noop</div><div>(1) attr_filter.accounting_response : expand: "%{User-Name}" -> 'test'</div><div>(1) attr_filter.accounting_response : Matched entry DEFAULT at line 12</div><div>(1) [attr_filter.accounting_response] = updated</div><div>(1) } # accounting = updated</div><div>Sending Accounting-Response of id 54 from 192.168.1.67 port 1813 to 192.168.1.109 port 35133</div><div>(1) Finished request 1.</div><div>Waking up in 0.2 seconds.</div><div>(1) Cleaning up request packet ID 54 with timestamp +14</div><div>Waking up in 2.7 seconds.</div><div>(0) Cleaning up request packet ID 53 with timestamp +12</div><div>Ready to process requests.</div><div>rad_recv: Accounting-Request packet from host 192.168.1.109 port 59458, id=55, length=146</div><div> Acct-Session-Id = '5425A63435B300'</div><div> User-Name = 'test'</div><div> Acct-Status-Type = Stop</div><div> Service-Type = Framed-User</div><div> Framed-Protocol = PPP</div><div> Acct-Authentic = RADIUS</div><div> Acct-Session-Time = 4</div><div> Acct-Output-Octets = 0</div><div> Acct-Input-Octets = 2804</div><div> Acct-Output-Packets = 0</div><div> Acct-Input-Packets = 36</div><div> Calling-Station-Id = '192.168.1.70'</div><div> NAS-Port-Type = Async</div><div> Acct-Terminate-Cause = User-Request</div><div> Framed-IP-Address = 192.168.1.1</div><div> NAS-IP-Address = 127.0.0.1</div><div> NAS-Port = 0</div><div> Acct-Delay-Time = 0</div><div>(2) # Executing section preacct from file /etc/raddb/sites-enabled/default</div><div>(2) preacct {</div><div>(2) [preprocess] = ok</div><div>(2) acct_unique acct_unique {</div><div>(2) ? if ("%{string:Class}" =~ /ai:([0-9a-f]{32})/i) </div><div>(2) expand: "%{string:Class}" -> ''</div><div>(2) ? if ("%{string:Class}" =~ /ai:([0-9a-f]{32})/i) -> FALSE</div><div>(2) else else {</div><div>(2) update request {</div><div>(2) expand: "%{md5:%{User-Name},%{Acct-Session-ID},%{NAS-IP-Address},%{NAS-Identifier},%{NAS-Port-ID},%{NAS-Port}}" -> '84b95fb1219c04cd5fd1f53d294840aa'</div><div>(2) Acct-Unique-Session-Id := "84b95fb1219c04cd5fd1f53d294840aa"</div><div>(2) } # update request = noop</div><div>(2) } # else else = noop</div><div>(2) } # acct_unique acct_unique = noop</div><div>(2) suffix : No '@' in User-Name = "test", looking up realm NULL</div><div>(2) suffix : No such realm "NULL"</div><div>(2) [suffix] = noop</div><div>(2) [files] = noop</div><div>(2) } # preacct = ok</div><div>(2) # Executing section accounting from file /etc/raddb/sites-enabled/default</div><div>(2) accounting {</div><div>(2) detail : expand: "/var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d" -> '/var/log/radius/radacct/192.168.1.109/detail-20140926'</div><div>(2) detail : /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/radius/radacct/192.168.1.109/detail-20140926</div><div>(2) detail : expand: "%t" -> 'Fri Sep 26 06:51:23 2014'</div><div>(2) [detail] = ok</div><div>(2) [unix] = ok</div><div>rlm_sql (sql): Reserved connection (4)</div><div>(2) sqlippool : expand: "%{User-Name}" -> 'test'</div><div>(2) sqlippool : SQL-User-Name set to 'test'</div><div>(2) sqlippool : expand: "START TRANSACTION" -> 'START TRANSACTION'</div><div>rlm_sql (sql): Executing query: 'START TRANSACTION'</div><div>(2) sqlippool : expand: "UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NULL 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 nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NULL WHERE nasipaddress = '127.0.0.1' AND pool_key = '0' AND username = 'test' AND callingstationid = '192.168.1.70' AND framedipaddress = '192.168.1.1''</div><div>rlm_sql (sql): Executing query: 'UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NULL WHERE nasipaddress = '127.0.0.1' AND pool_key = '0' AND username = 'test' AND callingstationid = '192.168.1.70' AND framedipaddress = '192.168.1.1''</div><div>(2) sqlippool : expand: "COMMIT" -> 'COMMIT'</div><div>rlm_sql (sql): Executing query: 'COMMIT'</div><div>(2) sqlippool : expand: "Released IP %{Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} user %{User-Name})" -> 'Released IP 192.168.1.1 (did cli 192.168.1.70 user test)'</div><div>rlm_sql (sql): Released connection (4)</div><div>(2) [sqlippool] = ok</div><div>(2) sql : expand: "%{tolower:type.%{Acct-Status-Type}.query}" -> 'type.stop.query'</div><div>(2) sql : Using query template 'query'</div><div>rlm_sql (sql): Reserved connection (4)</div><div>(2) sql : expand: "%{User-Name}" -> 'test'</div><div>(2) sql : SQL-User-Name set to 'test'</div><div>(2) sql : expand: "UPDATE radacct SET acctstoptime = FROM_UNIXTIME(%{integer:Event-Timestamp}), acctsessiontime = '%{Acct-Session-Time}', acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', acctterminatecause = '%{Acct-Terminate-Cause}', connectinfo_stop = '%{Connect-Info}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'" -> 'UPDATE radacct SET acctstoptime = FROM_UNIXTIME(1411710683), acctsessiontime = '4', acctinputoctets = '0' << 32 | '2804', acctoutputoctets = '0' << 32 | '0', acctterminatecause = 'User-Request', connectinfo_stop = '' WHERE acctsessionid = '5425A63435B300' AND username = 'test' AND nasipaddress = '127.0.0.1''</div><div>rlm_sql (sql): Executing query: 'UPDATE radacct SET acctstoptime = FROM_UNIXTIME(1411710683), acctsessiontime = '4', acctinputoctets = '0' << 32 | '2804', acctoutputoctets = '0' << 32 | '0', acctterminatecause = 'User-Request', connectinfo_stop = '' WHERE acctsessionid = '5425A63435B300' AND username = 'test' AND nasipaddress = '127.0.0.1''</div><div>rlm_sql (sql): Released connection (4)</div><div>(2) [sql] = ok</div><div>(2) [exec] = noop</div><div>(2) attr_filter.accounting_response : expand: "%{User-Name}" -> 'test'</div><div>(2) attr_filter.accounting_response : Matched entry DEFAULT at line 12</div><div>(2) [attr_filter.accounting_response] = updated</div><div>(2) } # accounting = updated</div><div>Sending Accounting-Response of id 55 from 192.168.1.67 port 1813 to 192.168.1.109 port 59458</div><div>(2) Finished request 2.</div><div>Waking up in 0.3 seconds.</div><div>(2) Cleaning up request packet ID 55 with timestamp +17</div><div>Ready to process requests.</div><div><br></div> </div></body>
</html>