124cd6f55SDamien Regad<?php 224cd6f55SDamien Regad/** 324cd6f55SDamien Regad * DokuWiki Plugin authwordpress (Auth Component) 424cd6f55SDamien Regad * 535dd80b8SDamien Regad * Provides authentication against a WordPress MySQL database backend 635dd80b8SDamien Regad * 735dd80b8SDamien Regad * This program is free software; you can redistribute it and/or modify 835dd80b8SDamien Regad * it under the terms of the GNU General Public License as published by 935dd80b8SDamien Regad * the Free Software Foundation; version 2 of the License 1035dd80b8SDamien Regad * 1135dd80b8SDamien Regad * This program is distributed in the hope that it will be useful, 1235dd80b8SDamien Regad * but WITHOUT ANY WARRANTY; without even the implied warranty of 1335dd80b8SDamien Regad * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 1435dd80b8SDamien Regad * GNU General Public License for more details. 1535dd80b8SDamien Regad * 1635dd80b8SDamien Regad * See the COPYING file in your DokuWiki folder for details 1735dd80b8SDamien Regad * 1824cd6f55SDamien Regad * @author Damien Regad <dregad@mantisbt.org> 1935dd80b8SDamien Regad * @copyright 2015 Damien Regad 2035dd80b8SDamien Regad * @license GPL 2 http://www.gnu.org/licenses/gpl-2.0.html 21b5b72c15SDamien Regad * @version 1.1 2235dd80b8SDamien Regad * @link https://github.com/dregad/dokuwiki-authwordpress 2324cd6f55SDamien Regad */ 2424cd6f55SDamien Regad 2535dd80b8SDamien Regad 2624cd6f55SDamien Regad// must be run within Dokuwiki 2724cd6f55SDamien Regadif(!defined('DOKU_INC')) die(); 2824cd6f55SDamien Regad 2935dd80b8SDamien Regad/** 3035dd80b8SDamien Regad * WordPress password hashing framework 3135dd80b8SDamien Regad */ 3235dd80b8SDamien Regadrequire_once('class-phpass.php'); 3335dd80b8SDamien Regad 3435dd80b8SDamien Regad/** 3535dd80b8SDamien Regad * Authentication class 3635dd80b8SDamien Regad */ 3724cd6f55SDamien Regadclass auth_plugin_authwordpress extends DokuWiki_Auth_Plugin { 3824cd6f55SDamien Regad 3935dd80b8SDamien Regad /** 4035dd80b8SDamien Regad * SQL statement to retrieve User data from WordPress DB 4135dd80b8SDamien Regad * (including group memberships) 42b5b72c15SDamien Regad * '%prefix%' will be replaced by the actual prefix (from plugin config) 4335dd80b8SDamien Regad */ 44b5b72c15SDamien Regad private $sql_wp_user_data = "SELECT 4535dd80b8SDamien Regad id, user_login, user_pass, user_email, display_name, 4635dd80b8SDamien Regad meta_value AS groups 47b5b72c15SDamien Regad FROM %prefix%users u 48b5b72c15SDamien Regad JOIN %prefix%usermeta m ON u.id = m.user_id 495a632944SDamien Regad WHERE meta_key = '%prefix%capabilities' 5035dd80b8SDamien Regad AND user_login = :user"; 5124cd6f55SDamien Regad 5224cd6f55SDamien Regad /** 53*015f33b2SDamien Regad * Wordpress database connection 54*015f33b2SDamien Regad */ 55*015f33b2SDamien Regad private $db; 56*015f33b2SDamien Regad 57*015f33b2SDamien Regad 58*015f33b2SDamien Regad /** 5924cd6f55SDamien Regad * Constructor. 6024cd6f55SDamien Regad */ 6124cd6f55SDamien Regad public function __construct() { 6235dd80b8SDamien Regad parent::__construct(); 6324cd6f55SDamien Regad 6435dd80b8SDamien Regad // Try to establish a connection to the WordPress DB 6535dd80b8SDamien Regad // abort in case of failure 6635dd80b8SDamien Regad try { 6735dd80b8SDamien Regad $wp_db = $this->wp_connect(); 6835dd80b8SDamien Regad } 6935dd80b8SDamien Regad catch (Exception $e) { 7035dd80b8SDamien Regad msg(sprintf($this->getLang('error_connect_failed'), $e->getMessage())); 7135dd80b8SDamien Regad $this->success = false; 7235dd80b8SDamien Regad return; 7335dd80b8SDamien Regad } 7424cd6f55SDamien Regad 75b5b72c15SDamien Regad // Initialize SQL query with configured prefix 76b5b72c15SDamien Regad $this->sql_wp_user_data = str_replace( 77b5b72c15SDamien Regad '%prefix%', 78b5b72c15SDamien Regad $this->getConf('prefix'), 79b5b72c15SDamien Regad $this->sql_wp_user_data 80b5b72c15SDamien Regad ); 81b5b72c15SDamien Regad 8224cd6f55SDamien Regad $this->success = true; 8324cd6f55SDamien Regad } 8424cd6f55SDamien Regad 8524cd6f55SDamien Regad 8624cd6f55SDamien Regad /** 8724cd6f55SDamien Regad * Check user+password 8824cd6f55SDamien Regad * 8924cd6f55SDamien Regad * @param string $user the user name 9024cd6f55SDamien Regad * @param string $pass the clear text password 9124cd6f55SDamien Regad * @return bool 9235dd80b8SDamien Regad * 9335dd80b8SDamien Regad * @uses PasswordHash::CheckPassword WordPress password hasher 9424cd6f55SDamien Regad */ 9524cd6f55SDamien Regad public function checkPass($user, $pass) { 9635dd80b8SDamien Regad $data = $this->getUserData($user); 9735dd80b8SDamien Regad if ($data === false) { 9835dd80b8SDamien Regad return false; 9924cd6f55SDamien Regad } 10024cd6f55SDamien Regad 10135dd80b8SDamien Regad $hasher = new PasswordHash(8, true); 10235dd80b8SDamien Regad return $hasher->CheckPassword($pass, $data['pass']); 10335dd80b8SDamien Regad } 10435dd80b8SDamien Regad 10535dd80b8SDamien Regad 10624cd6f55SDamien Regad /** 10735dd80b8SDamien Regad * Returns info about the given user 10824cd6f55SDamien Regad * 10924cd6f55SDamien Regad * @param string $user the user name 11024cd6f55SDamien Regad * @return array containing user data or false 11124cd6f55SDamien Regad */ 11235dd80b8SDamien Regad function getUserData($user, $requireGroups=true) { 11335dd80b8SDamien Regad global $conf; 11435dd80b8SDamien Regad 115*015f33b2SDamien Regad $stmt = $this->db->prepare($this->sql_wp_user_data); 11635dd80b8SDamien Regad $stmt->bindParam(':user', $user); 11735dd80b8SDamien Regad 11835dd80b8SDamien Regad if (!$stmt->execute()) { 1199520968dSDamien Regad // Query execution failed 12024cd6f55SDamien Regad return false; 12124cd6f55SDamien Regad } 1229520968dSDamien Regad 1239520968dSDamien Regad $user = $stmt->fetch(PDO::FETCH_ASSOC); 1249520968dSDamien Regad if ($user === false) { 1259520968dSDamien Regad // Unknown user 1269520968dSDamien Regad return false; 1279520968dSDamien Regad } 12824cd6f55SDamien Regad 12935dd80b8SDamien Regad // Group membership - add DokuWiki's default group 13035dd80b8SDamien Regad $groups = array_keys(unserialize($user['groups'])); 13135dd80b8SDamien Regad $groups[] = $conf['defaultgroup']; 13224cd6f55SDamien Regad 13335dd80b8SDamien Regad $info = array( 13435dd80b8SDamien Regad 'user' => $user['user_login'], 13535dd80b8SDamien Regad 'name' => $user['display_name'], 13635dd80b8SDamien Regad 'pass' => $user['user_pass'], 13735dd80b8SDamien Regad 'mail' => $user['user_email'], 13835dd80b8SDamien Regad 'grps' => $groups, 13935dd80b8SDamien Regad ); 14035dd80b8SDamien Regad return $info; 14124cd6f55SDamien Regad } 14224cd6f55SDamien Regad 14324cd6f55SDamien Regad 14424cd6f55SDamien Regad /** 14535dd80b8SDamien Regad * Connect to Wordpress database 146*015f33b2SDamien Regad * Initializes $db property as PDO object 14724cd6f55SDamien Regad */ 14835dd80b8SDamien Regad private function wp_connect() { 14935dd80b8SDamien Regad $dsn = array( 15035dd80b8SDamien Regad 'host=' . $this->getConf('hostname'), 15135dd80b8SDamien Regad 'dbname=' . $this->getConf('database'), 15235dd80b8SDamien Regad ); 15335dd80b8SDamien Regad $port = $this->getConf('port'); 15435dd80b8SDamien Regad if ($port) { 15535dd80b8SDamien Regad $dsn[] = 'port=' . $port; 15635dd80b8SDamien Regad } 15735dd80b8SDamien Regad $dsn = 'mysql:' . implode(';', $dsn); 15835dd80b8SDamien Regad 159*015f33b2SDamien Regad $this->db = new PDO($dsn, $this->getConf('username'), $this->getConf('password')); 16024cd6f55SDamien Regad } 16124cd6f55SDamien Regad 16224cd6f55SDamien Regad} 16324cd6f55SDamien Regad 1640e6cb03cSDamien Regad// vim:ts=4:sw=4:noet: 165