2 /* This Source Code Form is subject to the terms of the Mozilla Public
3 * License, v. 2.0. If a copy of the MPL was not distributed with this file,
4 * You can obtain one at http://mozilla.org/MPL/2.0/. */
6 // error reporting (for testing)
7 ini_set('display_errors', 1); error_reporting(E_ALL);
10 $dbdata = json_decode(file_get_contents('/etc/kairo/auth_db.json'), true);
11 if (!is_array($dbdata)) { trigger_error('DB configuration not found', E_USER_ERROR); }
12 $settings = json_decode(file_get_contents('/etc/kairo/auth_settings.json'), true);
13 if (!is_array($settings)) { trigger_error('Auth settings not found', E_USER_ERROR); }
15 // Extended DOM document class
16 require_once('../kairo/include/cbsm/util/document.php-class');
17 // Class for sending emails
18 require_once('../kairo/include/classes/email.php-class');
19 // Class for sending emails
20 require_once(__DIR__.'/authutils.php-class');
22 bindtextdomain('kairo_auth', 'en'); // XXX: Should negotiate locale.
23 bind_textdomain_codeset('kairo_auth', 'utf-8');
25 // Connect to our MySQL DB
26 $db = new PDO($dbdata['dsn'], $dbdata['username'], $dbdata['password']);
27 // Instantiate auth utils.
28 $utils = new AuthUtils($settings, $db);
30 /* Creating the DB tables:
31 CREATE TABLE `auth_sessions` (
32 `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,
33 `sesskey` VARCHAR(150) NOT NULL DEFAULT '' ,
34 `user` MEDIUMINT UNSIGNED NULL DEFAULT NULL ,
35 `logged_in` BOOLEAN NOT NULL DEFAULT FALSE ,
36 `time_created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
37 `time_expire` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
42 CREATE TABLE `auth_users` (
43 `id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT ,
44 `email` VARCHAR(255) NOT NULL ,
45 `pwdhash` VARCHAR(255) NOT NULL ,
46 `status` ENUM('unverified','ok') NOT NULL DEFAULT 'unverified' ,
47 `verify_hash` VARCHAR(150) NULL DEFAULT NULL ,
51 CREATE TABLE `auth_log` (
52 `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,
53 `code` VARCHAR(100) NOT NULL ,
54 `info` TEXT NULL DEFAULT NULL ,
55 `ip_addr` VARCHAR(50) NULL DEFAULT NULL ,
56 `time_logged` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
62 // include our OAuth2 Server object
63 require_once(__DIR__.'/server.inc.php');