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 : radcheckid 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 radusergroupid 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 radreplyid 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 radgroupreplyid <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 radgroupcheckid 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=cableradius-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/