Community discussions

MikroTik App
 
manson
newbie
Topic Author
Posts: 32
Joined: Thu Feb 14, 2013 9:41 am

Mikrotik DHCP Server + freeradius sql

Mon Sep 15, 2014 1:29 pm

Hello,

I have problem with making freeradius+sql work as dhcp leases database.

Whatever i'm doing i get always:

rad_recv: Access-Request packet from host 83.xx.xx.30 port 45683, id=93, length=116
NAS-Port-Type = Ethernet
NAS-Port = 2199942289
Calling-Station-Id = "1:dc:9f:db:9d:b3:29"
Called-Station-Id = "vlan510"
User-Name = "DC:9F:DB:9D:B3:29"
User-Password = ""
NAS-Identifier = "MT Router"
NAS-IP-Address = 83.xx.xx.30
WARNING: Empty authorize section. Using default return values.
ERROR: No authenticate method (Auth-Type) found for the request: Rejecting the user
Failed to authenticate the user.
Login incorrect: [DC:9F:DB:9D:B3:29/] (from client mt port 2199942289 cli 1:dc:9f:db:9d:b3:29)
Using Post-Auth-Type Reject
WARNING: Unknown value specified for Post-Auth-Type. Cannot perform requested action.

My sql:
mysql> SELECT * FROM radius.radcheck;
+----+-------------------+--------------------+----+-------+
| id | username | attribute | op | value |
+----+-------------------+--------------------+----+-------+
| 1 | DC:9F:DB:9D:B3:29 | Cleartext-Password | := | |
+----+-------------------+--------------------+----+-------+
1 row in set (0.00 sec)

mysql> SELECT * FROM radius.radreply;
+----+-------------------+----------------------+----+-------------+
| id | username | attribute | op | value |
+----+-------------------+----------------------+----+-------------+
| 1 | DC:9F:DB:9D:B3:29 | DHCP-Your-IP-Address | = | 192.168.2.4 |
| 2 | DC:9F:DB:9D:B3:29 | Mikrotik-Rate-Limit | = | 15M/30M |
+----+-------------------+----------------------+----+-------------+

With pppoe i don't have any problems to make it work ;/


Any idea? Please help :)
 
manson
newbie
Topic Author
Posts: 32
Joined: Thu Feb 14, 2013 9:41 am

Re: Mikrotik DHCP Server + freeradius sql

Mon Sep 15, 2014 2:44 pm

Problem solved ;P

Who is online

Users browsing this forum: dhiaahmed, Kampfwurst and 89 guests