OtAuthenticationService.php 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473
  1. <?php
  2. namespace Opentalent\OtConnect\Service;
  3. use DateTime;
  4. use GuzzleHttp\Cookie\CookieJar;
  5. use GuzzleHttp\Cookie\SetCookie;
  6. use GuzzleHttp\Exception\GuzzleException;
  7. use GuzzleHttp\Exception\RequestException;
  8. use Opentalent\OtCore\Exception\ApiRequestException;
  9. use Opentalent\OtCore\Logging\OtLogger;
  10. use Opentalent\OtCore\Service\OpentalentApiService;
  11. use TYPO3\CMS\Core\Crypto\Random;
  12. use TYPO3\CMS\Core\Database\ConnectionPool;
  13. use TYPO3\CMS\Core\TimeTracker\TimeTracker;
  14. use TYPO3\CMS\Core\Utility\GeneralUtility;
  15. use \TYPO3\CMS\Core\Authentication\AbstractAuthenticationService;
  16. /**
  17. * Authentication service based on the Opentalent API.
  18. * See the README for more
  19. */
  20. class OtAuthenticationService extends AbstractAuthenticationService
  21. {
  22. CONST LOGIN_URI = 'api/login_check';
  23. CONST GET_USER_DATA_URI = 'api/user/datafortypo3';
  24. CONST ISAUTH_URI = 'api/user/isauthenticated';
  25. CONST LOGOUT_URI = 'logout';
  26. CONST GROUP_FE_ALL_UID = 18076;
  27. // Cookies' domain needs to be the same that the api's cookies, or guzzle will ignore them.
  28. CONST COOKIE_DOMAIN = 'opentalent.fr';
  29. CONST PRODUCT_MAPPING = [
  30. "school-standard" => 1, // Association writer basic
  31. "artist-standard" => 1, // Association writer basic
  32. "school-premium" => 3, // Association writer full
  33. "artist-premium" => 3, // Association writer full
  34. "manager" => 3, // Association writer full
  35. ];
  36. /**
  37. * The time in seconds during which the user's data in DB won't be re-updated after the last successful update
  38. * Set it to 0 to disable the delay
  39. */
  40. CONST USER_UPDATE_DELAY = 300;
  41. /**
  42. * 0 - Authentification failed, no more services will be called...
  43. * @see https://docs.typo3.org/m/typo3/reference-coreapi/master/en-us/ApiOverview/Authentication/Index.html#the-service-chain
  44. *
  45. * @var int
  46. */
  47. const STATUS_AUTHENTICATION_FAILURE = 0;
  48. /**
  49. * 100 - OK, but call next services...
  50. * @see https://docs.typo3.org/m/typo3/reference-coreapi/master/en-us/ApiOverview/Authentication/Index.html#the-service-chain
  51. *
  52. * @var int
  53. */
  54. const STATUS_AUTHENTICATION_CONTINUE = 100;
  55. /**
  56. * 200 - authenticated and no more checking needed
  57. * @see https://docs.typo3.org/m/typo3/reference-coreapi/master/en-us/ApiOverview/Authentication/Index.html#the-service-chain
  58. *
  59. * @var int
  60. */
  61. const STATUS_AUTHENTICATION_SUCCESS = 200;
  62. /**
  63. * @var object
  64. */
  65. private object $apiService;
  66. /**
  67. * Guzzle Cookie Jar
  68. *
  69. * @var CookieJar
  70. */
  71. private CookieJar $jar;
  72. /**
  73. * @var \TYPO3\CMS\Core\Database\ConnectionPool
  74. */
  75. private $connectionPool;
  76. public function injectConnectionPool(ConnectionPool $connectionPool)
  77. {
  78. $this->connectionPool = $connectionPool;
  79. }
  80. /**
  81. * OtAuthenticationService constructor.
  82. */
  83. public function __construct() {
  84. $this->jar = new CookieJar;
  85. $this->apiService = GeneralUtility::makeInstance(OpentalentApiService::class, null, null, $this->jar);
  86. $this->connectionPool = GeneralUtility::makeInstance(ConnectionPool::class);
  87. }
  88. /**
  89. * This function returns the user record back to the AbstractUserAuthentication.
  90. * It does not mean that user is authenticated, it only means that user is found.
  91. * /!\ The 'getUser' method is required by the Typo3 authentification system
  92. * @see https://docs.typo3.org/m/typo3/reference-coreapi/master/en-us/ApiOverview/Authentication/Index.html#the-auth-services-api
  93. *
  94. * @return array|bool User record or false (content of fe_users/be_users as appropriate for the current mode)
  95. * @throws GuzzleException
  96. */
  97. public function getUser()
  98. {
  99. // Does the user already have a session on the Opentalent API?
  100. $username = $this->getAuthenticatedUsername();
  101. if ($username != null && $this->authInfo['loginType'] === 'FE' && $this->login['status'] === 'logout') {
  102. // This is a logout request
  103. $this->logout();
  104. return false;
  105. }
  106. if ($username != null && $this->login['status'] === 'login' && $this->login['uname'] != $username) {
  107. // The user trying to log in is not the one authenticated on the Opentalent API
  108. // We let the TYPO3 auth service handle it
  109. return false;
  110. } else if ($username == null && $this->login['status'] != 'login') {
  111. // The user has no current session on Opentalent.fr and this is not a login request
  112. return false;
  113. } else if ($this->login['status'] === 'login' && $this->login['uname'] && $this->login['uident']) {
  114. // This is a login request
  115. $username = $this->login['uname'];
  116. $password = $this->login['uident'];
  117. // Send a login request for the user to the Opentalent Api, and return the data
  118. // of the matching user, or false if le login failed
  119. $logged = $this->logUser($username, $password);
  120. if (!$logged) {
  121. return false;
  122. }
  123. }
  124. /// At this point, username should be set
  125. if ($username === null) {
  126. return false;
  127. }
  128. // Request the latest data for the user and write it in the Typo3 DB
  129. // * The shouldUserBeUpdated() method checks if the user was already
  130. // generated in the last minutes, to avoid unnecessary operations *
  131. if ($this->shouldUserBeUpdated($username)) {
  132. $wasUpdated = $this->createOrUpdateUser();
  133. if (!$wasUpdated) {
  134. // An error happened during the update of the user's data
  135. // since its data may have changed (credentials, rights, rôles...)
  136. // we can't allow him to connect.
  137. return false;
  138. }
  139. }
  140. // No need to check Pid for those users
  141. $this->authInfo['db_user']['checkPidList'] = '';
  142. $this->authInfo['db_user']['check_pid_clause'] = '';
  143. // Fetch the typo3 user from the database
  144. return $this->fetchUserRecord($username, '', $this->authInfo['db_user']);
  145. }
  146. /**
  147. * Returns the name of the user currently authenticated on the API side, or null if no user is logged in
  148. *
  149. * @return string|null
  150. * @throws GuzzleException
  151. */
  152. protected function getAuthenticatedUsername(): ?string
  153. {
  154. $this->fillCookieJar();
  155. try {
  156. if (!$this->jar->getCookieByName('BEARER')) {
  157. // Missing cookie : No need to ask API
  158. return null;
  159. }
  160. $response = $this->apiService->get(self::ISAUTH_URI, [], ['cookies' => $this->jar]);
  161. if ($response->getStatusCode() != 200) {
  162. return null;
  163. }
  164. return json_decode((string)$response->getBody());
  165. } catch (ApiRequestException $e) {
  166. return null;
  167. }
  168. }
  169. /**
  170. * Update the guzzle cookie jar with the current session's ones
  171. */
  172. private function fillCookieJar() {
  173. foreach (['BEARER', 'SFSESSID', 'AccessId'] as $cookieName) {
  174. if (array_key_exists($cookieName, $_COOKIE)) {
  175. $cookie = new SetCookie();
  176. $cookie->setName($cookieName);
  177. $cookie->setValue($_COOKIE[$cookieName]);
  178. $cookie->setDomain(self::COOKIE_DOMAIN);
  179. $this->jar->setCookie($cookie);
  180. }
  181. }
  182. }
  183. /**
  184. * Submit a login request to the API
  185. *
  186. * @param string $username
  187. * @param string $password
  188. * @return bool Returns true if the api accepted the login request
  189. * @throws GuzzleException
  190. */
  191. protected function logUser(string $username, string $password): bool
  192. {
  193. try {
  194. $response = $this->apiService->request(
  195. 'POST',
  196. self::LOGIN_URI,
  197. [],
  198. ['form_params' => ['_username' => $username, '_password' => $password]]
  199. );
  200. if ($response->getStatusCode() != 200) {
  201. return false;
  202. }
  203. // The API accepted the login request
  204. // Set the cookies returned by the Api (SESSID and BEARER)
  205. $this->setCookiesFromApiResponse($response);
  206. return true;
  207. } catch (ApiRequestException $e) {
  208. return false;
  209. }
  210. }
  211. /**
  212. * Get the cookies from the API response and set them
  213. *
  214. * @param $response
  215. */
  216. private function setCookiesFromApiResponse($response) {
  217. foreach ($response->getHeader('Set-Cookie') as $cookieStr) {
  218. $cookie = SetCookie::fromString($cookieStr);
  219. $name = $cookie->getName();
  220. $value = $cookie->getValue();
  221. $expires = $cookie->getExpires();
  222. $path = $cookie->getPath();
  223. $secure = $cookie->getSecure();
  224. $httpOnly = $cookie->getHttpOnly();
  225. $_COOKIE[$name] = $value;
  226. setcookie($name, $value, $expires, $path, self::COOKIE_DOMAIN, $secure, $httpOnly);
  227. setcookie($name, $value, $expires, $path, '.' . self::COOKIE_DOMAIN, $secure, $httpOnly);
  228. if (!preg_match('/(.*\.)?opentalent\.fr/', $_SERVER['HTTP_HOST'])) {
  229. setcookie($name, $value, $expires, $path, $_SERVER['HTTP_HOST'], $secure, $httpOnly);
  230. }
  231. }
  232. }
  233. /**
  234. * Compare the last update date for the user to the GENERATION_DELAY delay
  235. * and return wether the user's data may be created/updated in the Typo3 DB
  236. *
  237. * @param string $username
  238. * @return bool
  239. */
  240. protected function shouldUserBeUpdated(string $username): bool
  241. {
  242. $cnn = $this->connectionPool->getConnectionForTable('fe_users');
  243. $q = $cnn->select(['tx_opentalent_generationDate'], 'fe_users', ['username' => $username]);
  244. $strGenDate = $q->fetch(3)[0];
  245. $genDate = DateTime::createFromFormat("Y-m-d H:i:s", $strGenDate);
  246. if ($genDate == null) {
  247. return true;
  248. }
  249. $now = new DateTime();
  250. $diff = $now->getTimestamp() - $genDate->getTimestamp();
  251. return ($diff > self::USER_UPDATE_DELAY);
  252. }
  253. /**
  254. * Create or update the Frontend-user record in the typo3 database (table 'fe_users')
  255. * with the data fetched from the Api
  256. *
  257. * @return bool
  258. */
  259. protected function createOrUpdateUser(): bool
  260. {
  261. // Get user's data from the API
  262. $userApiData = $this->getUserData();
  263. if (empty($userApiData)) {
  264. // An error happened, and even if the user was logged, we can not continue
  265. // (user's data and rights could have changed)
  266. return false;
  267. }
  268. $connection = $this->connectionPool->getConnectionForTable('fe_users');
  269. // Since we don't want to store the password in the TYPO3 DB, we store a random string instead
  270. $randomStr = (new Random)->generateRandomHexString(20);
  271. // Front-end user
  272. $fe_row = [
  273. 'username' => $userApiData['username'],
  274. 'password' => $randomStr,
  275. 'name' => $userApiData['name'],
  276. 'first_name' => $userApiData['first_name'],
  277. 'description' => '[Warning: auto-generated record, do not modify] FE User',
  278. 'deleted' => 0,
  279. 'tx_opentalent_opentalentId' => $userApiData['id'],
  280. 'tx_opentalent_generationDate' => date('Y/m/d H:i:s')
  281. ];
  282. $groupsUid = [self::GROUP_FE_ALL_UID];
  283. if ($userApiData['accesses']) {
  284. foreach ($userApiData['accesses'] as $accessData) {
  285. $organizationId = $accessData['organizationId'];
  286. // get the fe_group for this organization
  287. $groupUid = $connection->fetchOne(
  288. "select g.uid
  289. from typo3.fe_groups g
  290. inner join (select uid, ot_website_uid from typo3.pages where is_siteroot) p
  291. on g.pid = p.uid
  292. inner join typo3.ot_websites w on p.ot_website_uid = w.uid
  293. where w.organization_id=:organizationId;",
  294. ['organizationId' => $organizationId]
  295. );
  296. if ($groupUid) {
  297. $groupsUid[] = $groupUid;
  298. } else {
  299. OtLogger::warning("Warning: no fe_group found for organization " . $organizationId);
  300. }
  301. }
  302. }
  303. $fe_row['usergroup'] = join(',', $groupsUid);
  304. // TODO: log a warning if a user with the same opentalentId exists (the user might have changed of username)
  305. $q = $connection->select(
  306. ['uid', 'tx_opentalent_opentalentId'],
  307. 'fe_users',
  308. ['username' => $userApiData['username']]
  309. );
  310. $row = $q->fetch(3);
  311. $uid = $row[0];
  312. $tx_opentalent_opentalentId = $row[1];
  313. if (!$uid) {
  314. // No existing user: create
  315. $connection->insert('fe_users', $fe_row);
  316. } else {
  317. // User exists: update
  318. if (!$tx_opentalent_opentalentId > 0) {
  319. OtLogger::warning('WARNING: FE user ' . $userApiData['username'] . ' has been replaced by an auto-generated version.');
  320. }
  321. $connection->update('fe_users', $fe_row, ['uid' => $uid]);
  322. }
  323. return true;
  324. }
  325. /**
  326. * Get the data for the current authenticated user from the API
  327. *
  328. * @return array
  329. */
  330. protected function getUserData(): ?array
  331. {
  332. $this->fillCookieJar();
  333. try {
  334. $response = $this->apiService->request('GET', self::GET_USER_DATA_URI, [], ['cookies' => $this->jar]);
  335. } catch (ApiRequestException $e) {
  336. return [];
  337. }
  338. return json_decode($response->getBody(), true);
  339. }
  340. /**
  341. * Authenticates user using Opentalent auth service.
  342. * /!\ The 'authUser' method is required by the Typo3 authentification system
  343. * @see https://docs.typo3.org/m/typo3/reference-coreapi/master/en-us/ApiOverview/Authentication/Index.html#the-auth-services-api
  344. *
  345. * @param array $user Data of user.
  346. * @return int Code that shows if user is really authenticated.
  347. * @throws GuzzleException
  348. */
  349. public function authUser(array $user): int
  350. {
  351. if ($user['username'] == $this->getAuthenticatedUsername()) {
  352. // Tha API just validated this user's auth
  353. return self::STATUS_AUTHENTICATION_SUCCESS;
  354. } else if ($this->authInfo['loginType'] === 'FE') {
  355. return self::STATUS_AUTHENTICATION_FAILURE;
  356. } else if (isset($user['tx_opentalent_opentalentId']) and $user['tx_opentalent_opentalentId'] != null) {
  357. // This is a user from the Opentalent DB, and the API refused its auth
  358. // (For performance only, since the password stored in the Typo3 is a random string,
  359. // the auth will be refused by the other services anyway)
  360. return self::STATUS_AUTHENTICATION_FAILURE;
  361. }
  362. // This may be a user using another auth system
  363. return self::STATUS_AUTHENTICATION_CONTINUE;
  364. }
  365. /**
  366. * Send a logout request to the API, remove the sessions cookies then logout
  367. * /!\ Frontend only
  368. */
  369. public function logout(): bool
  370. {
  371. try {
  372. $response = $this->apiService->request(
  373. 'GET',
  374. self::LOGOUT_URI
  375. );
  376. if ($response->getStatusCode() != 200) {
  377. return false;
  378. }
  379. // The API accepted the logout request
  380. // Unset the session cookies (SESSID and BEARER)
  381. if (isset($_COOKIE['BEARER'])) {
  382. unset($_COOKIE['BEARER']);
  383. $this->unset_cookie('BEARER');
  384. }
  385. if (isset($_COOKIE['SFSESSID'])) {
  386. unset($_COOKIE['SFSESSID']);
  387. $this->unset_cookie('SFSESSID');
  388. }
  389. $this->pObj->logoff();
  390. return true;
  391. } catch (RequestException $e) {
  392. return false;
  393. } catch (GuzzleException $e) {
  394. return false;
  395. }
  396. }
  397. /**
  398. * Unset a cookie by reducing its expiration date
  399. *
  400. * @param string $name
  401. */
  402. protected function unset_cookie(string $name)
  403. {
  404. setcookie($name, '', 1, '/', $_SERVER['HTTP_HOST']); // for custom domains (not in .opentalent.fr)
  405. setcookie($name, '', 1, '/', self::COOKIE_DOMAIN); // for opentalent.fr subdomains
  406. }
  407. }