Fix performance issue at session creation.
[platal.git] / classes / xorgsession.php
CommitLineData
0337d704 1<?php
2/***************************************************************************
179afa7f 3 * Copyright (C) 2003-2008 Polytechnique.org *
0337d704 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
c0799142 22class XorgSession extends PlSession
0337d704 23{
c0799142
FB
24 public function __construct()
25 {
26 parent::__construct();
abde67b1
FB
27 }
28
c0799142 29 public function startAvailableAuth()
5480a216 30 {
c0799142
FB
31 if (!S::logged()) {
32 $cookie = $this->tryCookie();
33 if ($cookie == 0) {
34 return $this->start(AUTH_COOKIE);
998c070f 35 } else if ($cookie == 1 || $cookie == -2) {
c0799142
FB
36 return false;
37 }
5480a216 38 }
0be07aa6 39 if ((check_ip('dangerous') && S::has('uid')) || check_account()) {
5480a216 40 $_SESSION['log']->log("view_page", $_SERVER['REQUEST_URI']);
0337d704 41 }
c0799142 42 return true;
0337d704 43 }
44
c0799142
FB
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 }
cab08090 53
c0799142
FB
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)
5480a216 73 {
c0799142
FB
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'));
79afc233
FB
82 if ($response != $expected_response && Env::has('xorpass')
83 && !preg_match('/^0*$/', Env::v('xorpass'))) {
c0799142
FB
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) {
e0e27d63
VZ
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';
0aa026b3
VZ
96 $user = User::getSilent($uid);
97 $account = new GoogleAppsAccount($user);
e0e27d63
VZ
98 if ($account->active() && $account->sync_password) {
99 $account->set_password($new_password);
100 }
101 }
c0799142
FB
102 }
103 }
104 if ($response != $expected_response) {
732e5855 105 S::logger($uid)->log('auth_fail', 'bad password');
c0799142
FB
106 return null;
107 }
108 return $uid;
109 }
110 return null;
0337d704 111 }
cab08090 112
0337d704 113
c0799142
FB
114 /** Check auth.
115 */
116 protected function doAuth($level)
0337d704 117 {
e74411f7 118 global $globals;
c0799142
FB
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');
e74411f7 130 }
0337d704 131
c0799142
FB
132
133 /* We want to do auth... we must have infos from a form.
134 */
e64c8b61 135 if (!Post::has('username') || !Post::has('response') || !S::has('challenge')) {
c0799142 136 return null;
63528107 137 }
138
c0799142
FB
139 /** We come from an authentication form.
140 */
e74411f7 141 if (S::has('suid')) {
c0799142 142 $suid = S::v('suid');
3fc71fad 143 $login = $uname = $suid['hruid'];
e74411f7 144 $redirect = false;
145 } else {
146 $uname = Env::v('username');
147
148 if (Env::v('domain') == "alias") {
c0799142
FB
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);
e74411f7 154 $redirect = $res->fetchOneCell();
155 if ($redirect) {
156 $login = substr($redirect, 0, strpos($redirect, '@'));
157 } else {
c0799142 158 $login = '';
e74411f7 159 }
0337d704 160 } else {
e74411f7 161 $login = $uname;
162 $redirect = false;
0337d704 163 }
63528107 164 }
cab08090 165
c0799142
FB
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);
e74411f7 174 }
c0799142
FB
175 // pour que la modification soit effective dans le reste de la page
176 $_COOKIE['ORGdomain'] = $domain;
e74411f7 177 }
c0799142 178 S::kill('challenge');
732e5855 179 S::logger($uid)->log('auth_ok');
c0799142
FB
180 }
181 return $uid;
182 }
cab08090 183
c0799142
FB
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']);
70232020 195
6672b29b 196 // Retrieves main user properties.
70232020
VZ
197 $res = XDB::query("SELECT u.user_id AS uid, u.hruid, prenom, prenom_ini, nom, nom_ini, nom_usage, perms, promo, promo_sortie,
198 matricule, password, FIND_IN_SET('femme', u.flags) AS femme,
c0799142 199 q.core_mail_fmt AS mail_fmt, UNIX_TIMESTAMP(q.banana_last) AS banana_last, q.watch_last, q.core_rss_hash,
6a61c46d
FB
200 FIND_IN_SET('watch', u.flags) AS watch_account, q.last_version, g.g_account_name IS NOT NULL AS googleapps,
201 UNIX_TIMESTAMP(s.start) AS lastlogin, s.host
c0799142
FB
202 FROM auth_user_md5 AS u
203 INNER JOIN auth_user_quick AS q USING(user_id)
70232020 204 LEFT JOIN gapps_accounts AS g ON (u.user_id = g.l_userid AND g.g_status = 'active')
6a61c46d
FB
205 LEFT JOIN logger.last_sessions AS ls ON (ls.uid = u.user_id)
206 LEFT JOIN logger.sessions AS s ON(s.id = ls.id)
70232020 207 WHERE u.user_id = {?} AND u.perms IN('admin', 'user')", $uid);
c0799142
FB
208 $sess = $res->fetchOneAssoc();
209 $perms = $sess['perms'];
210 unset($sess['perms']);
6672b29b 211
6672b29b
VZ
212 // Loads the data into the real session.
213 $_SESSION = array_merge($_SESSION, $sess);
214
215 // Starts the session's logger, and sets up the permanent cookie.
216 if (S::has('suid')) {
217 $suid = S::v('suid');
e4501b51 218 $logger = S::logger($uid);
d0b64586 219 $logger->log("suid_start", S::v('hruid') . " by " . $suid['hruid']);
c0799142 220 } else {
e4501b51 221 $logger = S::logger($uid);
c0799142 222 setcookie('ORGuid', $uid, (time() + 25920000), '/', '', 0);
a90cde48 223
d0621f88 224 if (S::i('auth_by_cookie') == $uid || Post::v('remember', 'false') == 'true') {
c0799142
FB
225 $cookie = hash_encrypt($sess['password']);
226 setcookie('ORGaccess', $cookie, (time() + 25920000), '/', '', 0);
d0621f88 227 if ($logger && S::i('auth_by_cookie') != $uid) {
c0799142 228 $logger->log("cookie_on");
63528107 229 }
c0799142
FB
230 } else {
231 setcookie('ORGaccess', '', time() - 3600, '/', '', 0);
232 if ($logger) {
233 $logger->log("cookie_off");
0337d704 234 }
0337d704 235 }
63528107 236 }
b0b937fd 237
6672b29b 238 // Finalizes the session setup.
50d5ec0b 239 S::set('perms', User::makePerms($perms));
c0799142
FB
240 $this->securityChecks();
241 $this->setSkin();
ebfdf077 242 $this->updateNbNotifs();
c0799142 243 check_redirect();
d0621f88
FB
244
245 // We should not have to use this private data anymore
246 S::kill('auth_by_cookie');
c0799142 247 return true;
0337d704 248 }
249
c0799142 250 private function securityChecks()
0337d704 251 {
c0799142
FB
252 $mail_subject = array();
253 if (check_account()) {
254 $mail_subject[] = 'Connexion d\'un utilisateur surveillé';
0337d704 255 }
c0799142
FB
256 if (check_ip('unsafe')) {
257 $mail_subject[] = 'Une IP surveillee a tente de se connecter';
258 if (check_ip('ban')) {
259 send_warning_mail(implode(' - ', $mail_subject));
260 $this->destroy();
261 Platal::page()->kill('Une erreur est survenue lors de la procédure d\'authentification. '
262 . 'Merci de contacter au plus vite '
263 . '<a href="mailto:support@polytechnique.org">support@polytechnique.org</a>');
264 return false;
265 }
0337d704 266 }
c0799142
FB
267 if (count($mail_subject)) {
268 send_warning_mail(implode(' - ', $mail_subject));
0337d704 269 }
270 }
271
0d44ce42
FB
272 public function tokenAuth($login, $token)
273 {
50d5ec0b 274 $res = XDB::query('SELECT u.hruid
0d44ce42
FB
275 FROM aliases AS a
276 INNER JOIN auth_user_md5 AS u ON (a.id = u.user_id AND u.perms IN ("admin", "user"))
277 INNER JOIN auth_user_quick AS q ON (a.id = q.user_id AND q.core_rss_hash = {?})
278 WHERE a.alias = {?} AND a.type != "homonyme"', $token, $login);
279 if ($res->numRows() == 1) {
50d5ec0b
FB
280 $data = $res->fetchOneAssoc();
281 return new User($data['hruid'], $data);
0d44ce42
FB
282 }
283 return null;
284 }
285
732e5855 286 public function makePerms($perm)
bf517daf 287 {
113f6de8 288 $flags = new PlFlagSet();
bf517daf 289 if ($perm == 'disabled' || $perm == 'ext') {
ab694eb5 290 S::set('perms', $flags);
ab694eb5 291 return;
bf517daf 292 }
293 $flags->addFlag(PERMS_USER);
294 if ($perm == 'admin') {
295 $flags->addFlag(PERMS_ADMIN);
296 }
c0799142 297 S::set('perms', $flags);
bf517daf 298 }
299
c0799142
FB
300 public function setSkin()
301 {
c0799142
FB
302 if (S::logged() && (!S::has('skin') || S::has('suid'))) {
303 $uid = S::v('uid');
304 $res = XDB::query("SELECT skin_tpl
305 FROM auth_user_quick AS a
306 INNER JOIN skins AS s ON a.skin = s.id
307 WHERE user_id = {?} AND skin_tpl != ''", $uid);
308 S::set('skin', $res->fetchOneCell());
5480a216 309 }
310 }
0337d704 311
faa06583
FB
312 public function loggedLevel()
313 {
314 return AUTH_COOKIE;
315 }
316
c0799142
FB
317 public function sureLevel()
318 {
319 return AUTH_MDP;
0337d704 320 }
ebfdf077
FB
321
322
323 public function updateNbNotifs()
324 {
325 require_once 'notifs.inc.php';
326 $n = select_notifs(false, S::i('uid'), S::v('watch_last'), false);
327 S::set('notifs', $n->numRows());
328 }
0337d704 329}
330
a7de4ef7 331// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
0337d704 332?>