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/