WikiMiNET

La documentation technique et administrative

Outils pour utilisateurs

Outils du site


wiki:services:radius

Différences

Ci-dessous, les différences entre deux révisions de la page.

Lien vers cette vue comparative

Les deux révisions précédentes Révision précédente
wiki:services:radius [2018/08/02 23:34]
sowarks
wiki:services:radius [2018/08/02 23:35] (Version actuelle)
sowarks
Ligne 68: Ligne 68:
 NB2: Il peut être nécessaire de réaliser un drop table sur certaines tables créés par le script automatique de freeradius. (ex: radcheck) NB2: Il peut être nécessaire de réaliser un drop table sur certaines tables créés par le script automatique de freeradius. (ex: radcheck)
  
-<​del>​Création ​de la vue **login_authorize**:​</​del>​+__Création ​de la vue **login_authorize**:​__
 <​code>​ <​code>​
 CREATE ALGORITHM=UNDEFINED DEFINER=`thunder`@`%` SQL SECURITY DEFINER VIEW `login_authorize` AS select `adh5-prod`.`adherents`.`id` AS `id`,​`adh5-prod`.`adherents`.`login` AS `login`,​`adh5-prod`.`vlans`.`numero` AS `vlan_nb`,​`adh5-prod`.`adherents`.`date_de_depart` AS `date_de_depart`,​`adh5-prod`.`adherents`.`mode_association` AS `mode_association` from ((`adh5-prod`.`adherents` join `adh5-prod`.`chambres`) join `adh5-prod`.`vlans`) where ((`adh5-prod`.`adherents`.`chambre_id` = `adh5-prod`.`chambres`.`id`) and (`adh5-prod`.`chambres`.`vlan_id` = `adh5-prod`.`vlans`.`id`));​ CREATE ALGORITHM=UNDEFINED DEFINER=`thunder`@`%` SQL SECURITY DEFINER VIEW `login_authorize` AS select `adh5-prod`.`adherents`.`id` AS `id`,​`adh5-prod`.`adherents`.`login` AS `login`,​`adh5-prod`.`vlans`.`numero` AS `vlan_nb`,​`adh5-prod`.`adherents`.`date_de_depart` AS `date_de_depart`,​`adh5-prod`.`adherents`.`mode_association` AS `mode_association` from ((`adh5-prod`.`adherents` join `adh5-prod`.`chambres`) join `adh5-prod`.`vlans`) where ((`adh5-prod`.`adherents`.`chambre_id` = `adh5-prod`.`chambres`.`id`) and (`adh5-prod`.`chambres`.`vlan_id` = `adh5-prod`.`vlans`.`id`));​
 </​code>​ </​code>​
  
-<​del>​Création ​de la vue **login_to_macf**:​</​del>​+__Création ​de la vue **login_to_macf**:​__
 <​code>​ <​code>​
 CREATE ALGORITHM=UNDEFINED DEFINER=`thunder`@`%` SQL SECURITY DEFINER VIEW `login_to_macf` AS select `A`.`login` AS `login`,​`O`.`mac` AS `mac` from (`adh5-prod`.`adherents` `A` join `adh5-prod`.`ordinateurs` `O`) where (`A`.`id` = `O`.`adherent_id`);​ CREATE ALGORITHM=UNDEFINED DEFINER=`thunder`@`%` SQL SECURITY DEFINER VIEW `login_to_macf` AS select `A`.`login` AS `login`,​`O`.`mac` AS `mac` from (`adh5-prod`.`adherents` `A` join `adh5-prod`.`ordinateurs` `O`) where (`A`.`id` = `O`.`adherent_id`);​
 </​code>​ </​code>​
  
-<​del>​Création ​de la vue **login_to_macw**:​</​del>​+__Création ​de la vue **login_to_macw**:​__
 <​code>​ <​code>​
 CREATE ALGORITHM=UNDEFINED DEFINER=`thunder`@`%` SQL SECURITY DEFINER VIEW `login_to_macw` AS select `adh5-prod`.`adherents`.`login` AS `login`,​`adh5-prod`.`portables`.`mac` AS `mac` from (`adh5-prod`.`portables` join `adh5-prod`.`adherents`) where (`adh5-prod`.`portables`.`adherent_id` = `adh5-prod`.`adherents`.`id`);​ CREATE ALGORITHM=UNDEFINED DEFINER=`thunder`@`%` SQL SECURITY DEFINER VIEW `login_to_macw` AS select `adh5-prod`.`adherents`.`login` AS `login`,​`adh5-prod`.`portables`.`mac` AS `mac` from (`adh5-prod`.`portables` join `adh5-prod`.`adherents`) where (`adh5-prod`.`portables`.`adherent_id` = `adh5-prod`.`adherents`.`id`);​
 </​code>​ </​code>​
  
-<​del>​Création ​de la vue **radcheck**:​</​del>​+__Création ​de la vue **radcheck**:​__
 <​code>​ <​code>​
 CREATE ALGORITHM=UNDEFINED DEFINER=`thunder`@`%` SQL SECURITY DEFINER VIEW `radcheck` AS select `adh5-prod`.`adherents`.`id` AS `id`,​`adh5-prod`.`adherents`.`login` AS `username`,'​NT-Password'​ AS `attribute`,':​='​ AS `op`,​`adh5-prod`.`adherents`.`password` AS `value` from `adh5-prod`.`adherents`;​ CREATE ALGORITHM=UNDEFINED DEFINER=`thunder`@`%` SQL SECURITY DEFINER VIEW `radcheck` AS select `adh5-prod`.`adherents`.`id` AS `id`,​`adh5-prod`.`adherents`.`login` AS `username`,'​NT-Password'​ AS `attribute`,':​='​ AS `op`,​`adh5-prod`.`adherents`.`password` AS `value` from `adh5-prod`.`adherents`;​
 </​code>​ </​code>​
  
wiki/services/radius.txt · Dernière modification: 2018/08/02 23:35 par sowarks