* @author Joas Schilling * @author Julius Härtl * @author Lukas Reschke * @author Morris Jobke * @author Robin Appelman * @author Roeland Jago Douma * @author Vincent Petry * * @license AGPL-3.0 * * This code is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License, version 3, * as published by the Free Software Foundation. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License, version 3, * along with this program. If not, see * */ namespace OC\Files\Config; use OC\User\LazyUser; use OCP\Cache\CappedMemoryCache; use OCP\DB\QueryBuilder\IQueryBuilder; use OCP\Diagnostics\IEventLogger; use OCP\Files\Config\ICachedMountFileInfo; use OCP\Files\Config\ICachedMountInfo; use OCP\Files\Config\IUserMountCache; use OCP\Files\NotFoundException; use OCP\IDBConnection; use OCP\IUser; use OCP\IUserManager; use Psr\Log\LoggerInterface; /** * Cache mounts points per user in the cache so we can easily look them up */ class UserMountCache implements IUserMountCache { private IDBConnection $connection; private IUserManager $userManager; /** * Cached mount info. * @var CappedMemoryCache **/ private CappedMemoryCache $mountsForUsers; /** * fileid => internal path mapping for cached mount info. * @var CappedMemoryCache **/ private CappedMemoryCache $internalPathCache; private LoggerInterface $logger; /** @var CappedMemoryCache */ private CappedMemoryCache $cacheInfoCache; private IEventLogger $eventLogger; /** * UserMountCache constructor. */ public function __construct( IDBConnection $connection, IUserManager $userManager, LoggerInterface $logger, IEventLogger $eventLogger ) { $this->connection = $connection; $this->userManager = $userManager; $this->logger = $logger; $this->eventLogger = $eventLogger; $this->cacheInfoCache = new CappedMemoryCache(); $this->internalPathCache = new CappedMemoryCache(); $this->mountsForUsers = new CappedMemoryCache(); } public function registerMounts(IUser $user, array $mounts, array $mountProviderClasses = null) { $this->eventLogger->start('fs:setup:user:register', 'Registering mounts for user'); /** @var array $newMounts */ $newMounts = []; foreach ($mounts as $mount) { // filter out any storages which aren't scanned yet since we aren't interested in files from those storages (yet) if ($mount->getStorageRootId() !== -1) { $mountInfo = new LazyStorageMountInfo($user, $mount); $newMounts[$mountInfo->getKey()] = $mountInfo; } } $cachedMounts = $this->getMountsForUser($user); if (is_array($mountProviderClasses)) { $cachedMounts = array_filter($cachedMounts, function (ICachedMountInfo $mountInfo) use ($mountProviderClasses, $newMounts) { // for existing mounts that didn't have a mount provider set // we still want the ones that map to new mounts if ($mountInfo->getMountProvider() === '' && isset($newMounts[$mountInfo->getKey()])) { return true; } return in_array($mountInfo->getMountProvider(), $mountProviderClasses); }); } $addedMounts = []; $removedMounts = []; foreach ($newMounts as $mountKey => $newMount) { if (!isset($cachedMounts[$mountKey])) { $addedMounts[] = $newMount; } } foreach ($cachedMounts as $mountKey => $cachedMount) { if (!isset($newMounts[$mountKey])) { $removedMounts[] = $cachedMount; } } $changedMounts = $this->findChangedMounts($newMounts, $cachedMounts); if ($addedMounts || $removedMounts || $changedMounts) { $this->connection->beginTransaction(); $userUID = $user->getUID(); try { foreach ($addedMounts as $mount) { $this->addToCache($mount); /** @psalm-suppress InvalidArgument */ $this->mountsForUsers[$userUID][$mount->getKey()] = $mount; } foreach ($removedMounts as $mount) { $this->removeFromCache($mount); unset($this->mountsForUsers[$userUID][$mount->getKey()]); } foreach ($changedMounts as $mount) { $this->updateCachedMount($mount); /** @psalm-suppress InvalidArgument */ $this->mountsForUsers[$userUID][$mount->getKey()] = $mount; } $this->connection->commit(); } catch (\Throwable $e) { $this->connection->rollBack(); throw $e; } } $this->eventLogger->end('fs:setup:user:register'); } /** * @param array $newMounts * @param array $cachedMounts * @return ICachedMountInfo[] */ private function findChangedMounts(array $newMounts, array $cachedMounts) { $changed = []; foreach ($cachedMounts as $key => $cachedMount) { if (isset($newMounts[$key])) { $newMount = $newMounts[$key]; if ( $newMount->getStorageId() !== $cachedMount->getStorageId() || $newMount->getMountId() !== $cachedMount->getMountId() || $newMount->getMountProvider() !== $cachedMount->getMountProvider() ) { $changed[] = $newMount; } } } return $changed; } private function addToCache(ICachedMountInfo $mount) { if ($mount->getStorageId() !== -1) { $this->connection->insertIfNotExist('*PREFIX*mounts', [ 'storage_id' => $mount->getStorageId(), 'root_id' => $mount->getRootId(), 'user_id' => $mount->getUser()->getUID(), 'mount_point' => $mount->getMountPoint(), 'mount_id' => $mount->getMountId(), 'mount_provider_class' => $mount->getMountProvider(), ], ['root_id', 'user_id', 'mount_point']); } else { // in some cases this is legitimate, like orphaned shares $this->logger->debug('Could not get storage info for mount at ' . $mount->getMountPoint()); } } private function updateCachedMount(ICachedMountInfo $mount) { $builder = $this->connection->getQueryBuilder(); $query = $builder->update('mounts') ->set('storage_id', $builder->createNamedParameter($mount->getStorageId())) ->set('mount_point', $builder->createNamedParameter($mount->getMountPoint())) ->set('mount_id', $builder->createNamedParameter($mount->getMountId(), IQueryBuilder::PARAM_INT)) ->set('mount_provider_class', $builder->createNamedParameter($mount->getMountProvider())) ->where($builder->expr()->eq('user_id', $builder->createNamedParameter($mount->getUser()->getUID()))) ->andWhere($builder->expr()->eq('root_id', $builder->createNamedParameter($mount->getRootId(), IQueryBuilder::PARAM_INT))); $query->execute(); } private function removeFromCache(ICachedMountInfo $mount) { $builder = $this->connection->getQueryBuilder(); $query = $builder->delete('mounts') ->where($builder->expr()->eq('user_id', $builder->createNamedParameter($mount->getUser()->getUID()))) ->andWhere($builder->expr()->eq('root_id', $builder->createNamedParameter($mount->getRootId(), IQueryBuilder::PARAM_INT))) ->andWhere($builder->expr()->eq('mount_point', $builder->createNamedParameter($mount->getMountPoint()))); $query->execute(); } /** * @param array $row * @param (callable(CachedMountInfo): string)|null $pathCallback * @return CachedMountInfo */ private function dbRowToMountInfo(array $row, ?callable $pathCallback = null): ICachedMountInfo { $user = new LazyUser($row['user_id'], $this->userManager); $mount_id = $row['mount_id']; if (!is_null($mount_id)) { $mount_id = (int)$mount_id; } if ($pathCallback) { return new LazyPathCachedMountInfo( $user, (int)$row['storage_id'], (int)$row['root_id'], $row['mount_point'], $row['mount_provider_class'] ?? '', $mount_id, $pathCallback, ); } else { return new CachedMountInfo( $user, (int)$row['storage_id'], (int)$row['root_id'], $row['mount_point'], $row['mount_provider_class'] ?? '', $mount_id, $row['path'] ?? '', ); } } /** * @param IUser $user * @return ICachedMountInfo[] */ public function getMountsForUser(IUser $user) { $userUID = $user->getUID(); if (!$this->userManager->userExists($userUID)) { return []; } if (!isset($this->mountsForUsers[$userUID])) { $builder = $this->connection->getQueryBuilder(); $query = $builder->select('storage_id', 'root_id', 'user_id', 'mount_point', 'mount_id', 'mount_provider_class') ->from('mounts', 'm') ->where($builder->expr()->eq('user_id', $builder->createPositionalParameter($userUID))); $result = $query->execute(); $rows = $result->fetchAll(); $result->closeCursor(); /** @var array $mounts */ $mounts = []; foreach ($rows as $row) { $mount = $this->dbRowToMountInfo($row, [$this, 'getInternalPathForMountInfo']); if ($mount !== null) { $mounts[$mount->getKey()] = $mount; } } $this->mountsForUsers[$userUID] = $mounts; } return $this->mountsForUsers[$userUID]; } public function getInternalPathForMountInfo(CachedMountInfo $info): string { $cached = $this->internalPathCache->get($info->getRootId()); if ($cached !== null) { return $cached; } $builder = $this->connection->getQueryBuilder(); $query = $builder->select('path') ->from('filecache') ->where($builder->expr()->eq('fileid', $builder->createPositionalParameter($info->getRootId()))); return $query->executeQuery()->fetchOne() ?: ''; } /** * @param int $numericStorageId * @param string|null $user limit the results to a single user * @return CachedMountInfo[] */ public function getMountsForStorageId($numericStorageId, $user = null) { $builder = $this->connection->getQueryBuilder(); $query = $builder->select('storage_id', 'root_id', 'user_id', 'mount_point', 'mount_id', 'f.path', 'mount_provider_class') ->from('mounts', 'm') ->innerJoin('m', 'filecache', 'f', $builder->expr()->eq('m.root_id', 'f.fileid')) ->where($builder->expr()->eq('storage_id', $builder->createPositionalParameter($numericStorageId, IQueryBuilder::PARAM_INT))); if ($user) { $query->andWhere($builder->expr()->eq('user_id', $builder->createPositionalParameter($user))); } $result = $query->execute(); $rows = $result->fetchAll(); $result->closeCursor(); return array_filter(array_map([$this, 'dbRowToMountInfo'], $rows)); } /** * @param int $rootFileId * @return CachedMountInfo[] */ public function getMountsForRootId($rootFileId) { $builder = $this->connection->getQueryBuilder(); $query = $builder->select('storage_id', 'root_id', 'user_id', 'mount_point', 'mount_id', 'f.path', 'mount_provider_class') ->from('mounts', 'm') ->innerJoin('m', 'filecache', 'f', $builder->expr()->eq('m.root_id', 'f.fileid')) ->where($builder->expr()->eq('root_id', $builder->createPositionalParameter($rootFileId, IQueryBuilder::PARAM_INT))); $result = $query->execute(); $rows = $result->fetchAll(); $result->closeCursor(); return array_filter(array_map([$this, 'dbRowToMountInfo'], $rows)); } /** * @param $fileId * @return array{int, string, int} * @throws \OCP\Files\NotFoundException */ private function getCacheInfoFromFileId($fileId): array { if (!isset($this->cacheInfoCache[$fileId])) { $builder = $this->connection->getQueryBuilder(); $query = $builder->select('storage', 'path', 'mimetype') ->from('filecache') ->where($builder->expr()->eq('fileid', $builder->createNamedParameter($fileId, IQueryBuilder::PARAM_INT))); $result = $query->execute(); $row = $result->fetch(); $result->closeCursor(); if (is_array($row)) { $this->cacheInfoCache[$fileId] = [ (int)$row['storage'], (string)$row['path'], (int)$row['mimetype'] ]; } else { throw new NotFoundException('File with id "' . $fileId . '" not found'); } } return $this->cacheInfoCache[$fileId]; } /** * @param int $fileId * @param string|null $user optionally restrict the results to a single user * @return ICachedMountFileInfo[] * @since 9.0.0 */ public function getMountsForFileId($fileId, $user = null) { try { [$storageId, $internalPath] = $this->getCacheInfoFromFileId($fileId); } catch (NotFoundException $e) { return []; } $mountsForStorage = $this->getMountsForStorageId($storageId, $user); // filter mounts that are from the same storage but not a parent of the file we care about $filteredMounts = array_filter($mountsForStorage, function (ICachedMountInfo $mount) use ($internalPath, $fileId) { if ($fileId === $mount->getRootId()) { return true; } $internalMountPath = $mount->getRootInternalPath(); return $internalMountPath === '' || str_starts_with($internalPath, $internalMountPath . '/'); }); $filteredMounts = array_filter($filteredMounts, function (ICachedMountInfo $mount) { return $this->userManager->userExists($mount->getUser()->getUID()); }); return array_map(function (ICachedMountInfo $mount) use ($internalPath) { return new CachedMountFileInfo( $mount->getUser(), $mount->getStorageId(), $mount->getRootId(), $mount->getMountPoint(), $mount->getMountId(), $mount->getMountProvider(), $mount->getRootInternalPath(), $internalPath ); }, $filteredMounts); } /** * Remove all cached mounts for a user * * @param IUser $user */ public function removeUserMounts(IUser $user) { $builder = $this->connection->getQueryBuilder(); $query = $builder->delete('mounts') ->where($builder->expr()->eq('user_id', $builder->createNamedParameter($user->getUID()))); $query->execute(); } public function removeUserStorageMount($storageId, $userId) { $builder = $this->connection->getQueryBuilder(); $query = $builder->delete('mounts') ->where($builder->expr()->eq('user_id', $builder->createNamedParameter($userId))) ->andWhere($builder->expr()->eq('storage_id', $builder->createNamedParameter($storageId, IQueryBuilder::PARAM_INT))); $query->execute(); } public function remoteStorageMounts($storageId) { $builder = $this->connection->getQueryBuilder(); $query = $builder->delete('mounts') ->where($builder->expr()->eq('storage_id', $builder->createNamedParameter($storageId, IQueryBuilder::PARAM_INT))); $query->execute(); } /** * @param array $users * @return array */ public function getUsedSpaceForUsers(array $users) { $builder = $this->connection->getQueryBuilder(); $slash = $builder->createNamedParameter('/'); $mountPoint = $builder->func()->concat( $builder->func()->concat($slash, 'user_id'), $slash ); $userIds = array_map(function (IUser $user) { return $user->getUID(); }, $users); $query = $builder->select('m.user_id', 'f.size') ->from('mounts', 'm') ->innerJoin('m', 'filecache', 'f', $builder->expr()->andX( $builder->expr()->eq('m.storage_id', 'f.storage'), $builder->expr()->eq('f.path_hash', $builder->createNamedParameter(md5('files'))) )) ->where($builder->expr()->eq('m.mount_point', $mountPoint)) ->andWhere($builder->expr()->in('m.user_id', $builder->createNamedParameter($userIds, IQueryBuilder::PARAM_STR_ARRAY))); $result = $query->execute(); $results = []; while ($row = $result->fetch()) { $results[$row['user_id']] = $row['size']; } $result->closeCursor(); return $results; } public function clear(): void { $this->cacheInfoCache = new CappedMemoryCache(); $this->mountsForUsers = new CappedMemoryCache(); } public function getMountForPath(IUser $user, string $path): ICachedMountInfo { $mounts = $this->getMountsForUser($user); $mountPoints = array_map(function (ICachedMountInfo $mount) { return $mount->getMountPoint(); }, $mounts); $mounts = array_combine($mountPoints, $mounts); $current = rtrim($path, '/'); // walk up the directory tree until we find a path that has a mountpoint set // the loop will return if a mountpoint is found or break if none are found while (true) { $mountPoint = $current . '/'; if (isset($mounts[$mountPoint])) { return $mounts[$mountPoint]; } elseif ($current === '') { break; } $current = dirname($current); if ($current === '.' || $current === '/') { $current = ''; } } throw new NotFoundException("No cached mount for path " . $path); } public function getMountsInPath(IUser $user, string $path): array { $path = rtrim($path, '/') . '/'; $mounts = $this->getMountsForUser($user); return array_filter($mounts, function (ICachedMountInfo $mount) use ($path) { return $mount->getMountPoint() !== $path && str_starts_with($mount->getMountPoint(), $path); }); } }