Bonjour, Je me permet d'apporter une petite contribution, De mémoire, il me semble que sur radius il ne s'agit pas de l'opérateur " == " mais de l'opérateur " :=" (deux-points et égal). C'est en tout cas la configuration que j'ai chez moi sur mon p'tit freeradius-mysql avec un WRT54GL sur DD-WRT. Le 27 mai 2015 14:08, Olivier GUIN <olivier.guin@ariasnet.com> a écrit :
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 [image: 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 [image: 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 [image: 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 [image: 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 [image: 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
_______________________________________________ Liste de diffusion du FRsAG http://www.frsag.org/
