Пробовал.
Вот ответ:
mysql> CALL radreply('E4:8D:8C:B8:C6:83', 'dhcp_1_24');
+------+-------------------+-------------------+-----------+---+
| NULL | login | Framed-IP-Address | usr_ip | = |
+------+-------------------+-------------------+-----------+---+
| NULL | E4:8D:8C:B8:C6:83 | Framed-IP-Address | 10.0.1.82 | = |
+------+-------------------+-------------------+-----------+---+
1 row in set (0,01 sec)
+------+-------------------+-----------------+-----+---+
| NULL | login | Session-Timeout | 600 | = |
+------+-------------------+-----------------+-----+---+
| NULL | E4:8D:8C:B8:C6:83 | Session-Timeout | 600 | = |
+------+-------------------+-----------------+-----+---+
1 row in set (0,01 sec)
Query OK, 0 rows affected (0,01 sec)
И выдает новый адрес:
mysql> SELECT get_ip_by_tag('1', 'dhcp_1_saperka24');
+----------------------------------------+
| get_ip_by_tag('1', 'dhcp_1_saperka24') |
+----------------------------------------+
| 10.0.1.201 |
+----------------------------------------+
1 row in set (0,01 sec)
Радиус запущен. И перезагружал:
ps aux | grep radi
freerad 25362 0.0 0.1 479884 6184 ? Ssl 04:15 0:00 /usr/sbin/freeradius
root 25441 0.0 0.0 15476 1024 pts/8 S+ 04:16 0:00 grep --color=auto radi
При при таком запросе с консоли, Radius не выдает ошибок:
root@vps:~# radtest E4:8D:8C:B8:C6:83 '' 127.0.0.1 0 hardpass5
Sending Access-Request of id 243 to 127.0.0.1 port 1812
User-Name = "E4:8D:8C:B8:C6:83"
User-Password = ""
NAS-IP-Address = 127.0.1.1
NAS-Port = 0
Message-Authenticator = 0x00000000000000000000000000000000
rad_recv: Access-Reject packet from host 127.0.0.1 port 1812, id=243, length=20
А при дебаге, ошибка sql.