[FRsAG] Mikrotik FreeRadius Hotspot

27 May 2015

      Bonjour à tous,

J'ai installé un hotspot avec le Hotspot de Mikrotik, mon freeradius et 
ma base MySql, et bien quelque soit le mot de passe que je met les 
utilisateurs se connectent toujours ...

Exemple :
radcheck
id Décroissant 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radcheck&sql_query=SELECT+%2A+FROM+%60radcheck%60+ORDER+BY+%60radcheck%60.%60id%60++ASC&token=f6816928df6cbfb951b83b937caab8d5> 
	UserName 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radcheck&sql_query=SELECT+%2A+FROM+%60radcheck%60+ORDER+BY+%60radcheck%60.%60UserName%60+ASC&token=f6816928df6cbfb951b83b937caab8d5> 
	Attribute 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radcheck&sql_query=SELECT+%2A+FROM+%60radcheck%60+ORDER+BY+%60radcheck%60.%60Attribute%60+ASC&token=f6816928df6cbfb951b83b937caab8d5> 
	op 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radcheck&sql_query=SELECT+%2A+FROM+%60radcheck%60+ORDER+BY+%60radcheck%60.%60op%60+ASC&token=f6816928df6cbfb951b83b937caab8d5> 
	Value 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radcheck&sql_query=SELECT+%2A+FROM+%60radcheck%60+ORDER+BY+%60radcheck%60.%60Value%60+ASC&token=f6816928df6cbfb951b83b937caab8d5> 

4066 	hotspot1 	Password 	== 	123456

radusergroup
id Décroissant 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radusergroup&sql_query=SELECT+%2A+FROM+%60radusergroup%60+ORDER+BY+%60radusergroup%60.%60id%60++ASC&token=f6816928df6cbfb951b83b937caab8d5> 
	UserName 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radusergroup&sql_query=SELECT+%2A+FROM+%60radusergroup%60+ORDER+BY+%60radusergroup%60.%60UserName%60+ASC&token=f6816928df6cbfb951b83b937caab8d5> 
	GroupName 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radusergroup&sql_query=SELECT+%2A+FROM+%60radusergroup%60+ORDER+BY+%60radusergroup%60.%60GroupName%60+ASC&token=f6816928df6cbfb951b83b937caab8d5> 
	Priority 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radusergroup&sql_query=SELECT+%2A+FROM+%60radusergroup%60+ORDER+BY+%60radusergroup%60.%60Priority%60+ASC&token=f6816928df6cbfb951b83b937caab8d5> 

4063 	hotspot1 	GroupeHotspot 	1

radreply
id Décroissant 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radreply&sql_query=SELECT+%2A+FROM+%60radreply%60+ORDER+BY+%60radreply%60.%60id%60++ASC&token=f6816928df6cbfb951b83b937caab8d5> 
	UserName 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radreply&sql_query=SELECT+%2A+FROM+%60radreply%60+ORDER+BY+%60radreply%60.%60UserName%60+ASC&token=f6816928df6cbfb951b83b937caab8d5> 
	Attribute 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radreply&sql_query=SELECT+%2A+FROM+%60radreply%60+ORDER+BY+%60radreply%60.%60Attribute%60+ASC&token=f6816928df6cbfb951b83b937caab8d5> 
	op 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radreply&sql_query=SELECT+%2A+FROM+%60radreply%60+ORDER+BY+%60radreply%60.%60op%60+ASC&token=f6816928df6cbfb951b83b937caab8d5> 
	Value 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radreply&sql_query=SELECT+%2A+FROM+%60radreply%60+ORDER+BY+%60radreply%60.%60Value%60+ASC&token=f6816928df6cbfb951b83b937caab8d5> 

7491 	GroupeHotspot 	Simultaneous-Use 	== 	1

radgroupreply
id 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radgroupreply&sql_query=SELECT+%2A+FROM+%60radgroupreply%60+ORDER+BY+%60radgroupreply%60.%60id%60+ASC&token=f6816928df6cbfb951b83b937caab8d5> 
	GroupName Croissant 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radgroupreply&sql_query=SELECT+%2A+FROM+%60radgroupreply%60+ORDER+BY+%60radgroupreply%60.%60GroupName%60++DESC&token=f6816928df6cbfb951b83b937caab8d5> 
	Attribute 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radgroupreply&sql_query=SELECT+%2A+FROM+%60radgroupreply%60+ORDER+BY+%60radgroupreply%60.%60Attribute%60+ASC&token=f6816928df6cbfb951b83b937caab8d5> 
	op 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radgroupreply&sql_query=SELECT+%2A+FROM+%60radgroupreply%60+ORDER+BY+%60radgroupreply%60.%60op%60+ASC&token=f6816928df6cbfb951b83b937caab8d5> 
	Value 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radgroupreply&sql_query=SELECT+%2A+FROM+%60radgroupreply%60+ORDER+BY+%60radgroupreply%60.%60Value%60+ASC&token=f6816928df6cbfb951b83b937caab8d5> 

2 	Abonnés 	Framed-Pool 	== 	pool-carrier-hotspot

radgroupcheck
id Décroissant 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radgroupcheck&sql_query=SELECT+%2A+FROM+%60radgroupcheck%60+ORDER+BY+%60radgroupcheck%60.%60id%60++ASC&token=f6816928df6cbfb951b83b937caab8d5> 
	GroupName 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radgroupcheck&sql_query=SELECT+%2A+FROM+%60radgroupcheck%60+ORDER+BY+%60radgroupcheck%60.%60GroupName%60+ASC&token=f6816928df6cbfb951b83b937caab8d5> 
	Attribute 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radgroupcheck&sql_query=SELECT+%2A+FROM+%60radgroupcheck%60+ORDER+BY+%60radgroupcheck%60.%60Attribute%60+ASC&token=f6816928df6cbfb951b83b937caab8d5> 
	op 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radgroupcheck&sql_query=SELECT+%2A+FROM+%60radgroupcheck%60+ORDER+BY+%60radgroupcheck%60.%60op%60+ASC&token=f6816928df6cbfb951b83b937caab8d5> 
	Value 
<http://noc.wayscom.net/phpmyadmin/sql.php?db=autharias&table=radgroupcheck&sql_query=SELECT+%2A+FROM+%60radgroupcheck%60+ORDER+BY+%60radgroupcheck%60.%60Value%60+ASC&token=f6816928df6cbfb951b83b937caab8d5> 

68 	GroupeHotspot 	Auth-Type 	:= 	Accept

Login : hotspot1   Password == 123456  OK
Login : hotspot2   Password == 123456 NOK
Login : hotspot1   Password == sjdkjfjsdml  OK
Login : hotspot1   Password == etc .....  OK

Bref, l'utilisateur se connecte qu'avec son nom d'utilisateur !
J'ai essayé avec ClearText, Cleartext, CHAP-Password, User-Password ...

radiusd: FreeRADIUS Version 2.1.0

Ma conf Mikrotik :
[admin@PPPoE-SRV] /ip hotspot profile> print
  1   name="hs-profil-srv" hotspot-address=100.64.8.1
      dns-name="login.srv.net" html-directory=hotspot rate-limit=""
      http-proxy=0.0.0.0:0 smtp-server=0.0.0.0 login-by=http-chap,http-pap
      split-user-domain=no use-radius=yes radius-accounting=yes
      radius-interim-update=received nas-port-type=cable
      radius-default-domain="" radius-location-id="" 
radius-location-name=""
      radius-mac-format=XX:XX:XX:XX:XX:XX

Est-ce que qq a déjà eu se problème ?
Olivier

[FRsAG] Mikrotik FreeRadius Hotspot

Olivier GUIN