classes/xorgsession.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2008 Polytechnique.org                              *
   4  *  http://opensource.polytechnique.org/                                   *
   5  *                                                                         *
   6  *  This program is free software; you can redistribute it and/or modify   *
   7  *  it under the terms of the GNU General Public License as published by   *
   8  *  the Free Software Foundation; either version 2 of the License, or      *
   9  *  (at your option) any later version.                                    *
  10  *                                                                         *
  11  *  This program is distributed in the hope that it will be useful,        *
  12  *  but WITHOUT ANY WARRANTY; without even the implied warranty of         *
  13  *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          *
  14  *  GNU General Public License for more details.                           *
  15  *                                                                         *
  16  *  You should have received a copy of the GNU General Public License      *
  17  *  along with this program; if not, write to the Free Software            *
  18  *  Foundation, Inc.,                                                      *
  19  *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
  20  ***************************************************************************/
  21
  22 class XorgSession extends PlSession
  23 {
  24     public function __construct()
  25     {
  26         parent::__construct();
  27     }
  28
  29     public function startAvailableAuth()
  30     {
  31         if (!S::logged()) {
  32             $cookie = $this->tryCookie();
  33             if ($cookie == 0) {
  34                 return $this->start(AUTH_COOKIE);
  35             } else if ($cookie == 1 || $cookie == -2) {
  36                 return false;
  37             }
  38         }
  39         if ((check_ip('dangerous') && S::has('uid')) || check_account()) {
  40             $_SESSION['log']->log("view_page", $_SERVER['REQUEST_URI']);
  41         }
  42         return true;
  43     }
  44
  45     /** Check the cookie and set the associated user_id in the auth_by_cookie session variable.
  46      */
  47     private function tryCookie()
  48     {
  49         S::kill('auth_by_cookie');
  50         if (Cookie::v('ORGaccess') == '' || !Cookie::has('ORGuid')) {
  51             return -1;
  52         }
  53
  54         $res = XDB::query('SELECT  user_id, password
  55                              FROM  auth_user_md5
  56                             WHERE  user_id = {?} AND perms IN(\'admin\', \'user\')',
  57                          Cookie::i('ORGuid'));
  58         if ($res->numRows() != 0) {
  59             list($uid, $password) = $res->fetchOneRow();
  60             require_once 'secure_hash.inc.php';
  61             $expected_value = hash_encrypt($password);
  62             if ($expected_value == Cookie::v('ORGaccess')) {
  63                 S::set('auth_by_cookie', $uid);
  64                 return 0;
  65             } else {
  66                 return 1;
  67             }
  68         }
  69         return -2;
  70     }
  71
  72     private function checkPassword($uname, $login, $response, $login_type)
  73     {
  74         $res = XDB::query('SELECT  u.user_id, u.password
  75                              FROM  auth_user_md5 AS u
  76                        INNER JOIN  aliases       AS a ON (a.id = u.user_id AND type != \'homonyme\')
  77                              WHERE  a.' . $login_type . ' = {?} AND u.perms IN(\'admin\', \'user\')',
  78                           $login);
  79         if (list($uid, $password) = $res->fetchOneRow()) {
  80             require_once 'secure_hash.inc.php';
  81             $expected_response = hash_encrypt("$uname:$password:" . S::v('challenge'));
  82             if ($response != $expected_response && Env::has('xorpass')
  83                 && !preg_match('/^0*$/', Env::v('xorpass'))) {
  84                 $new_password = hash_xor(Env::v('xorpass'), $password);
  85                 $expected_response = hash_encrypt("$uname:$new_password:" . S::v('challenge'));
  86                 if ($response == $expected_response) {
  87                     XDB::execute('UPDATE  auth_user_md5
  88                                      SET  password = {?}
  89                                    WHERE  user_id = {?}',
  90                                  $new_password, $uid);
  91
  92                     // Update the GoogleApps password as well, if required.
  93                     global $globals;
  94                     if ($globals->mailstorage->googleapps_domain) {
  95                         require_once 'googleapps.inc.php';
  96                         $user = User::getSilent($uid);
  97                         $account = new GoogleAppsAccount($user);
  98                         if ($account->active() && $account->sync_password) {
  99                             $account->set_password($new_password);
 100                         }
 101                     }
 102                 }
 103             }
 104             if ($response != $expected_response) {
 105                 S::logger($uid)->log('auth_fail', 'bad password');
 106                 return null;
 107             }
 108             return $uid;
 109         }
 110         return null;
 111     }
 112
 113
 114     /** Check auth.
 115      */
 116     protected function doAuth($level)
 117     {
 118         global $globals;
 119
 120         /* Cookie authentication
 121          */
 122         if ($level == AUTH_COOKIE && !S::has('auth_by_cookie')) {
 123             $this->tryCookie();
 124         }
 125         if ($level == AUTH_COOKIE && S::has('auth_by_cookie')) {
 126             if (!S::logged()) {
 127                 S::set('auth', AUTH_COOKIE);
 128             }
 129             return S::i('auth_by_cookie');
 130         }
 131
 132
 133         /* We want to do auth... we must have infos from a form.
 134          */
 135         if (!Post::has('username') || !Post::has('response') || !S::has('challenge')) {
 136             return null;
 137         }
 138
 139         /** We come from an authentication form.
 140          */
 141         if (S::has('suid')) {
 142             $suid  = S::v('suid');
 143             $login = $uname = $suid['hruid'];
 144             $redirect = false;
 145         } else {
 146             $uname = Env::v('username');
 147
 148             if (Env::v('domain') == "alias") {
 149                 $res = XDB::query('SELECT  redirect
 150                                      FROM  virtual
 151                                INNER JOIN  virtual_redirect USING(vid)
 152                                     WHERE  alias LIKE {?}',
 153                                    $uname . '@' . $globals->mail->alias_dom);
 154                 $redirect = $res->fetchOneCell();
 155                 if ($redirect) {
 156                     $login = substr($redirect, 0, strpos($redirect, '@'));
 157                 } else {
 158                     $login = '';
 159                 }
 160             } else {
 161                 $login = $uname;
 162                 $redirect = false;
 163             }
 164         }
 165
 166         $uid = $this->checkPassword($uname, $login, Post::v('response'), (!$redirect && preg_match('/^\d*$/', $uname)) ? 'id' : 'alias');
 167         if (!is_null($uid)) {
 168             S::set('auth', AUTH_MDP);
 169             if (Post::has('domain')) {
 170                 if (($domain = Post::v('domain', 'login')) == 'alias') {
 171                     setcookie('ORGdomain', "alias", (time() + 25920000), '/', '', 0);
 172                 } else {
 173                     setcookie('ORGdomain', '', (time() - 3600), '/', '', 0);
 174                 }
 175                 // pour que la modification soit effective dans le reste de la page
 176                 $_COOKIE['ORGdomain'] = $domain;
 177             }
 178             S::kill('challenge');
 179             S::logger($uid)->log('auth_ok');
 180         }
 181         return $uid;
 182     }
 183
 184     protected function startSessionAs($uid, $level)
 185     {
 186         if ((!is_null(S::v('user')) && S::i('user') != $uid) || (S::has('uid') && S::i('uid') != $uid)) {
 187             return false;
 188         } else if (S::has('uid')) {
 189             return true;
 190         }
 191         if ($level == -1) {
 192             S::set('auth', AUTH_COOKIE);
 193         }
 194         unset($_SESSION['log']);
 195
 196         // Retrieves main user properties.
 197         global $globals;
 198         $res  = XDB::query("SELECT  u.user_id AS uid, u.hruid, prenom, prenom_ini, nom, nom_ini, nom_usage, perms, promo, promo_sortie,
 199                                     matricule, password, FIND_IN_SET('femme', u.flags) AS femme,
 200                                     CONCAT(a.alias, '@{$globals->mail->domain}') AS forlife,
 201                                     CONCAT(a2.alias, '@{$globals->mail->domain}') AS bestalias,
 202                                     q.core_mail_fmt AS mail_fmt, UNIX_TIMESTAMP(q.banana_last) AS banana_last, q.watch_last, q.core_rss_hash,
 203                                     FIND_IN_SET('watch', u.flags) AS watch_account, q.last_version, g.g_account_name IS NOT NULL AS googleapps
 204                               FROM  auth_user_md5   AS u
 205                         INNER JOIN  auth_user_quick AS q  USING(user_id)
 206                         INNER JOIN  aliases         AS a  ON (u.user_id = a.id AND a.type = 'a_vie')
 207                         INNER JOIN  aliases         AS a2 ON (u.user_id = a2.id AND FIND_IN_SET('bestalias', a2.flags))
 208                          LEFT JOIN  gapps_accounts  AS g  ON (u.user_id = g.l_userid AND g.g_status = 'active')
 209                              WHERE  u.user_id = {?} AND u.perms IN('admin', 'user')", $uid);
 210         $sess = $res->fetchOneAssoc();
 211         $perms = $sess['perms'];
 212         unset($sess['perms']);
 213
 214         // Retrieves account usage information (last login, last host).
 215         $res = XDB::query('SELECT  UNIX_TIMESTAMP(s.start) AS lastlogin, s.host
 216                              FROM  logger.sessions AS s
 217                             WHERE  s.uid = {?} AND s.suid = 0
 218                          ORDER BY  s.start DESC
 219                             LIMIT  1', $uid);
 220         if ($res->numRows()) {
 221             $sess = array_merge($sess, $res->fetchOneAssoc());
 222         }
 223
 224         // Loads the data into the real session.
 225         $_SESSION = array_merge($_SESSION, $sess);
 226
 227         // Starts the session's logger, and sets up the permanent cookie.
 228         if (S::has('suid')) {
 229             $suid = S::v('suid');
 230             $logger = S::logger($uid);
 231             $logger->log("suid_start", S::v('hruid') . " by " . $suid['hruid']);
 232         } else {
 233             $logger = S::logger($uid);
 234             setcookie('ORGuid', $uid, (time() + 25920000), '/', '', 0);
 235
 236             if (S::i('auth_by_cookie') == $uid || Post::v('remember', 'false') == 'true') {
 237                 $cookie = hash_encrypt($sess['password']);
 238                 setcookie('ORGaccess', $cookie, (time() + 25920000), '/', '', 0);
 239                 if ($logger && S::i('auth_by_cookie') != $uid) {
 240                     $logger->log("cookie_on");
 241                 }
 242             } else {
 243                 setcookie('ORGaccess', '', time() - 3600, '/', '', 0);
 244                 if ($logger) {
 245                     $logger->log("cookie_off");
 246                 }
 247             }
 248         }
 249
 250         // Finalizes the session setup.
 251         S::set('perms', User::makePerms($perms));
 252         $this->securityChecks();
 253         $this->setSkin();
 254         $this->updateNbNotifs();
 255         check_redirect();
 256
 257         // We should not have to use this private data anymore
 258         S::kill('auth_by_cookie');
 259         return true;
 260     }
 261
 262     private function securityChecks()
 263     {
 264         $mail_subject = array();
 265         if (check_account()) {
 266             $mail_subject[] = 'Connexion d\'un utilisateur surveillé';
 267         }
 268         if (check_ip('unsafe')) {
 269             $mail_subject[] = 'Une IP surveillee a tente de se connecter';
 270             if (check_ip('ban')) {
 271                 send_warning_mail(implode(' - ', $mail_subject));
 272                 $this->destroy();
 273                 Platal::page()->kill('Une erreur est survenue lors de la procédure d\'authentification. '
 274                                     . 'Merci de contacter au plus vite '
 275                                     . '<a href="mailto:support@polytechnique.org">support@polytechnique.org</a>');
 276                 return false;
 277             }
 278         }
 279         if (count($mail_subject)) {
 280             send_warning_mail(implode(' - ', $mail_subject));
 281         }
 282     }
 283
 284     public function tokenAuth($login, $token)
 285     {
 286         $res = XDB::query('SELECT  u.hruid
 287                              FROM  aliases         AS a
 288                        INNER JOIN  auth_user_md5   AS u ON (a.id = u.user_id AND u.perms IN ("admin", "user"))
 289                        INNER JOIN  auth_user_quick AS q ON (a.id = q.user_id AND q.core_rss_hash = {?})
 290                             WHERE  a.alias = {?} AND a.type != "homonyme"', $token, $login);
 291         if ($res->numRows() == 1) {
 292             $data = $res->fetchOneAssoc();
 293             return new User($data['hruid'], $data);
 294         }
 295         return null;
 296     }
 297
 298     public function makePerms($perm)
 299     {
 300         $flags = new PlFlagSet();
 301         if ($perm == 'disabled' || $perm == 'ext') {
 302             S::set('perms', $flags);
 303             return;
 304         }
 305         $flags->addFlag(PERMS_USER);
 306         if ($perm == 'admin') {
 307             $flags->addFlag(PERMS_ADMIN);
 308         }
 309         S::set('perms', $flags);
 310     }
 311
 312     public function setSkin()
 313     {
 314         global $globals;
 315         if (S::logged() && (!S::has('skin') || S::has('suid'))) {
 316             $uid = S::v('uid');
 317             $res = XDB::query("SELECT  skin_tpl
 318                                  FROM  auth_user_quick AS a
 319                            INNER JOIN  skins           AS s ON a.skin = s.id
 320                                 WHERE  user_id = {?} AND skin_tpl != ''", $uid);
 321             S::set('skin', $res->fetchOneCell());
 322         }
 323     }
 324
 325     public function loggedLevel()
 326     {
 327         return AUTH_COOKIE;
 328     }
 329
 330     public function sureLevel()
 331     {
 332         return AUTH_MDP;
 333     }
 334
 335
 336     public function updateNbNotifs()
 337     {
 338         require_once 'notifs.inc.php';
 339         $n = select_notifs(false, S::i('uid'), S::v('watch_last'), false);
 340         S::set('notifs', $n->numRows());
 341     }
 342 }
 343
 344 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 345 ?>