mysql> SELECT * FROM radcheck LIMIT 0 , 30; ±—±---------±--------------------±—±------------------+
| id | UserName | Attribute | op | Value |
±—±---------±--------------------±—±------------------+
| 1 | toni | User-Password | == | pass |
| 2 | toni | Simultaneous-Use | := | 1 |
| 3 | saki | User-Password | := | saki |
| 4 | yusuf | User-Password | := | saki |
| 5 | faisal | User-Password | := | faisal |
| 6 | rafi | User-Password | := | rafi |
| 7 | saki | Mikrotik-Rate-Limit | = | 512k/512k |
±—±---------±--------------------±—±------------------+
7 rows in set (0.00 sec)
Here is freeradius log output:
Service-Type = Framed-User
Framed-Protocol = PPP
NAS-Port = 46
NAS-Port-Type = Ethernet
User-Name = “saki”
Calling-Station-Id = “00:E0:00:22:B9:97”
Called-Station-Id = “Mikrotik”
NAS-Port-Id = “ether2”
MS-CHAP-Challenge = 0x4ecde0bd93ddd7a4189fcded711af0d8
MS-CHAP2-Response = 0x01009cf1efae4db1fa768aa2fa6daaae6be000000000000000008bc7c96891f2ebcf8b7eb5cd8e716a27965559e769a93cd8
NAS-Identifier = “MikroTik”
NAS-IP-Address = 10.0.10.3
rlm_sql (sql): Reserving sql socket id: 2
rlm_sql: Failed to create the pair: Unknown attribute “Mikrotik-Rate-Limit”
rlm_sql (sql): Error getting data from database
rlm_sql (sql): SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 2
rad_recv: Access-Request packet from host 10.0.10.3:1059, id=80, length=185
Sending Access-Reject of id 80 to 10.0.10.3:1059