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 <[email protected]> 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/ > >
_______________________________________________ Liste de diffusion du FRsAG http://www.frsag.org/
