Hey! I just added Auth-Type := Local for this group, and it worked. Is there any clever/cleaner way to do it? Thank you. Felipe Ceglia - PY1NB wrote:
Hi again...
I am now trying to authenticate a DHCPd request from a mikrotik box. My freeradius server says that there is a problem with user's password. How can I tell him (PAP) that this should be ok?
Something strange that I noticed is that the calling station id got changed from the original mac address value. Anyway, I just put this as a calling-station id attribute on radcheck.
mysql> SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = '00:0B:CD:EC:63:50' ORDER BY id; +------+-------------------+--------------------+-------------------+----+ | id | UserName | Attribute | Value | op | +------+-------------------+--------------------+-------------------+----+ | 2047 | 00:0B:CD:EC:63:50 | Calling-Station-Id | 1:0:b:cd:ec:63:50 | := | | 2050 | 00:0B:CD:EC:63:50 | User-Password | | := | +------+-------------------+--------------------+-------------------+----+ 2 rows in set (0.00 sec)
SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = '00:0B:CD:EC:63:50' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id; Empty set (0.00 sec)
mysql> SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = '00:0B:CD:EC:63:50' ORDER BY id; +----+-------------------+-------------------+-----------------+----+ | id | UserName | Attribute | Value | op | +----+-------------------+-------------------+-----------------+----+ | 42 | 00:0B:CD:EC:63:50 | Framed-IP-Address | 192.168.254.101 | == | | 43 | 00:0B:CD:EC:63:50 | Framed-IP-Netmask | 255.255.255.0 | == | +----+-------------------+-------------------+-----------------+----+ 2 rows in set (0.00 sec)
SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = '00:0B:CD:EC:63:50' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id; Empty set (0.00 sec)
Ready to process requests. rad_recv: Access-Request packet from host 172.16.3.5:32768, id=71, length=113 NAS-Port-Type = Ethernet NAS-Port = 2205155400 Calling-Station-Id = "1:0:b:cd:ec:63:50" Called-Station-Id = "server1" User-Name = "00:0B:CD:EC:63:50" User-Password = "" NAS-Identifier = "MikroTik" NAS-IP-Address = 172.16.3.5 Processing the authorize section of radiusd.conf modcall: entering group authorize for request 0 modcall[authorize]: module "preprocess" returns ok for request 0 modcall[authorize]: module "chap" returns noop for request 0 modcall[authorize]: module "mschap" returns noop for request 0 rlm_realm: No '@' in User-Name = "00:0B:CD:EC:63:50", looking up realm NULL rlm_realm: Found realm "NULL" rlm_realm: Adding Stripped-User-Name = "00:0B:CD:EC:63:50" rlm_realm: Proxying request from user 00:0B:CD:EC:63:50 to realm NULL rlm_realm: Adding Realm = "NULL" rlm_realm: Authentication realm is LOCAL. modcall[authorize]: module "suffix" returns noop for request 0 rlm_eap: No EAP-Message, not doing EAP modcall[authorize]: module "eap" returns noop for request 0 users: Matched entry DEFAULT at line 174 modcall[authorize]: module "files" returns ok for request 0 radius_xlat: '00:0B:CD:EC:63:50' rlm_sql (sql): sql_set_user escaped user --> '00:0B:CD:EC:63:50' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = '00:0B:CD:EC:63:50' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 4 radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = '00:0B:CD:EC:63:50' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = '00:0B:CD:EC:63:50' ORDER BY id' radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = '00:0B:CD:EC:63:50' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql (sql): Released sql socket id: 4 modcall[authorize]: module "sql" returns ok for request 0 rlm_pap: Found existing Auth-Type, not changing it. modcall[authorize]: module "pap" returns noop for request 0 modcall: leaving group authorize (returns ok) for request 0 ****************************************************************************** rad_check_password: Found Auth-Type PAP auth: type "PAP" Processing the authenticate section of radiusd.conf modcall: entering group PAP for request 0 modcall[authenticate]: module "pap" returns invalid for request 0 modcall: leaving group PAP (returns invalid) for request 0 ****************************************************************************** auth: Failed to validate the user. Login incorrect (rlm_pap: empty password supplied): [00:0B:CD:EC:63:50/] (from client mikrotik port 2205155400 cli 1:0:b:cd:ec:63:50) rad_lowerpair: Stripped-User-Name now '00:0b:cd:ec:63:50' rad_lowerpair: User-Password now '' rad_rmspace_pair: Stripped-User-Name now '00:0b:cd:ec:63:50' rad_rmspace_pair: User-Password now '' Processing the authorize section of radiusd.conf modcall: entering group authorize for request 0 modcall[authorize]: module "preprocess" returns ok for request 0 modcall[authorize]: module "chap" returns noop for request 0 modcall[authorize]: module "mschap" returns noop for request 0 rlm_realm: Request already proxied. Ignoring. modcall[authorize]: module "suffix" returns noop for request 0
Thank you,
Felipe - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html