WEBDav access in Windows 10 (Nextcloud)

boniek

Cadet
Joined
Feb 8, 2021
Messages
4
Hello All,

Please help me to configure access to my nextcloud files via webdav in Win10:

TrueNAS-12.0-U1.1
Plugin:
nextcloud
Release:
12.1-RELEASE-p13
Nextcloud 20.0.5

TrueNAS IP : 192.168.0.111
Nextcloud IP : 192.168.0.221

Nextcloud filesystem path: http://192.168.0.111/iocage/jails/nextcloud_j/
WEBDav path generated in nextcloud gui: http://192.168.0.221/remote.php/dav/files/rafal/

I'm trying to map network drive in windows 10 from file explore - path http://192.168.0.221/remote.php/dav/files/rafal/
Once the credentials are entered, they are not accepted.
I tried to use the login and password of the user from nextcloud, also password generated in
Security -> Devices & sessions -> Create new app password. Didn't work.

Errors in nextcloud log:

ErrorPHPError: Undefined offset: 0 at /usr/local/www/nextcloud/apps-pkg/serverinfo/lib/OperatingSystems/FreeBSD.php#187

FatalwebdavDoctrine\DBAL\Exception\DeadlockException: An exception occurred while executing 'UPDATE `oc_filecache` SET `storage` = ?, `path_hash` = MD5(CONCAT(?, SUBSTR(`path`, ?))), `path` = CONCAT(?, SUBSTR(`path`, ?)) WHERE (`storage` = ?) AND (`path` LIKE ?)' with params [3, "files_trashbin\/files\/Documents.d1612807593", 16, "files_trashbin\/files\/Documents.d1612807593", 16, 3, "files\/Documents\/%"]: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction

Fatalwebdav
  1. /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 169:
    Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
  2. /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 149:
    Doctrine\DBAL\DBALException::wrapException()
  3. /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 1071:
    Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
  4. /usr/local/www/nextcloud/lib/private/DB/Connection.php - line 222:
    Doctrine\DBAL\Connection->executeUpdate()
  5. /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 209:
    OC\DB\Connection->executeUpdate()
  6. /usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 217:
    Doctrine\DBAL\Query\QueryBuilder->execute()
  7. /usr/local/www/nextcloud/lib/private/Files/Cache/Cache.php - line 662:
    OC\DB\QueryBuilder\QueryBuilder->execute()
  8. /usr/local/www/nextcloud/lib/private/Files/Cache/Cache.php - line 601:
    OC\Files\Cache\Cache->moveFromCache()
  9. /usr/local/www/nextcloud/lib/private/Files/Cache/Updater.php - line 199:
    OC\Files\Cache\Cache->move()
  10. /usr/local/www/nextcloud/apps-pkg/files_trashbin/lib/Trashbin.php - line 315:
    OC\Files\Cache\Updater->renameFromStorage()
  11. /usr/local/www/nextcloud/apps-pkg/files_trashbin/lib/Trash/LegacyTrashBackend.php - line 108:
    OCA\Files_Trashbin\Trashbin::move2trash()
  12. /usr/local/www/nextcloud/apps-pkg/files_trashbin/lib/Trash/TrashManager.php - line 103:
    OCA\Files_Trashbin\Trash\LegacyTrashBackend->moveToTrash()
  13. /usr/local/www/nextcloud/apps-pkg/files_trashbin/lib/Storage.php - line 192:
    OCA\Files_Trashbin\Trash\TrashManager->moveToTrash()
  14. /usr/local/www/nextcloud/apps-pkg/files_trashbin/lib/Storage.php - line 118:
    OCA\Files_Trashbin\Storage->doDelete()
  15. /usr/local/www/nextcloud/lib/private/Files/View.php - line 1167:
    OCA\Files_Trashbin\Storage->rmdir()
  16. /usr/local/www/nextcloud/lib/private/Files/View.php - line 350:
    OC\Files\View->basicOperation()
  17. /usr/local/www/nextcloud/apps-pkg/dav/lib/Connector/Sabre/Directory.php - line 309:
    OC\Files\View->rmdir()
  18. /usr/local/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php - line 183:
    OCA\DAV\Connector\Sabre\Directory->delete()
  19. /usr/local/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php - line 295:
    Sabre\DAV\Tree->delete()
  20. /usr/local/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php - line 89:
    Sabre\DAV\CorePlugin->httpDelete()
  21. /usr/local/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 474:
    Sabre\DAV\Server->emit()
  22. /usr/local/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 251:
    Sabre\DAV\Server->invokeMethod()
  23. /usr/local/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 319:
    Sabre\DAV\Server->start()
  24. /usr/local/www/nextcloud/apps-pkg/dav/lib/Server.php - line 332:
    Sabre\DAV\Server->exec()
  25. /usr/local/www/nextcloud/apps-pkg/dav/appinfo/v2/remote.php - line 35:
    OCA\DAV\Server->exec()
  26. /usr/local/www/nextcloud/remote.php - line 167:
    require_once("/usr/local/ ... p")
Caused by Doctrine\DBAL\Driver\PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction
  1. /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 1062:
    Doctrine\DBAL\Driver\PDOStatement->execute()
  2. /usr/local/www/nextcloud/lib/private/DB/Connection.php - line 222:
    Doctrine\DBAL\Connection->executeUpdate()
  3. /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 209:
    OC\DB\Connection->executeUpdate()
  4. /usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 217:
    Doctrine\DBAL\Query\QueryBuilder->execute()
  5. /usr/local/www/nextcloud/lib/private/Files/Cache/Cache.php - line 662:
    OC\DB\QueryBuilder\QueryBuilder->execute()
  6. /usr/local/www/nextcloud/lib/private/Files/Cache/Cache.php - line 601:
    OC\Files\Cache\Cache->moveFromCache()
  7. /usr/local/www/nextcloud/lib/private/Files/Cache/Updater.php - line 199:
    OC\Files\Cache\Cache->move()
  8. /usr/local/www/nextcloud/apps-pkg/files_trashbin/lib/Trashbin.php - line 315:
    OC\Files\Cache\Updater->renameFromStorage()
  9. /usr/local/www/nextcloud/apps-pkg/files_trashbin/lib/Trash/LegacyTrashBackend.php - line 108:
    OCA\Files_Trashbin\Trashbin::move2trash()
  10. /usr/local/www/nextcloud/apps-pkg/files_trashbin/lib/Trash/TrashManager.php - line 103:
    OCA\Files_Trashbin\Trash\LegacyTrashBackend->moveToTrash()
  11. /usr/local/www/nextcloud/apps-pkg/files_trashbin/lib/Storage.php - line 192:
    OCA\Files_Trashbin\Trash\TrashManager->moveToTrash()
  12. /usr/local/www/nextcloud/apps-pkg/files_trashbin/lib/Storage.php - line 118:
    OCA\Files_Trashbin\Storage->doDelete()
  13. /usr/local/www/nextcloud/lib/private/Files/View.php - line 1167:
    OCA\Files_Trashbin\Storage->rmdir()
  14. /usr/local/www/nextcloud/lib/private/Files/View.php - line 350:
    OC\Files\View->basicOperation()
  15. /usr/local/www/nextcloud/apps-pkg/dav/lib/Connector/Sabre/Directory.php - line 309:
    OC\Files\View->rmdir()
  16. /usr/local/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php - line 183:
    OCA\DAV\Connector\Sabre\Directory->delete()
  17. /usr/local/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php - line 295:
    Sabre\DAV\Tree->delete()
  18. /usr/local/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php - line 89:
    Sabre\DAV\CorePlugin->httpDelete()
  19. /usr/local/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 474:
    Sabre\DAV\Server->emit()
  20. /usr/local/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 251:
    Sabre\DAV\Server->invokeMethod()
  21. /usr/local/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 319:
    Sabre\DAV\Server->start()
  22. /usr/local/www/nextcloud/apps-pkg/dav/lib/Server.php - line 332:
    Sabre\DAV\Server->exec()
  23. /usr/local/www/nextcloud/apps-pkg/dav/appinfo/v2/remote.php - line 35:
    OCA\DAV\Server->exec()
  24. /usr/local/www/nextcloud/remote.php - line 167:
    require_once("/usr/local/ ... p")
Caused by PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction
  1. /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php - line 127:
    PDOStatement->execute()
  2. /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 1062:
    Doctrine\DBAL\Driver\PDOStatement->execute()
  3. /usr/local/www/nextcloud/lib/private/DB/Connection.php - line 222:
    Doctrine\DBAL\Connection->executeUpdate()
  4. /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 209:
    OC\DB\Connection->executeUpdate()
  5. /usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 217:
    Doctrine\DBAL\Query\QueryBuilder->execute()
  6. /usr/local/www/nextcloud/lib/private/Files/Cache/Cache.php - line 662:
    OC\DB\QueryBuilder\QueryBuilder->execute()
  7. /usr/local/www/nextcloud/lib/private/Files/Cache/Cache.php - line 601:
    OC\Files\Cache\Cache->moveFromCache()
  8. /usr/local/www/nextcloud/lib/private/Files/Cache/Updater.php - line 199:
    OC\Files\Cache\Cache->move()
  9. /usr/local/www/nextcloud/apps-pkg/files_trashbin/lib/Trashbin.php - line 315:
    OC\Files\Cache\Updater->renameFromStorage()
  10. /usr/local/www/nextcloud/apps-pkg/files_trashbin/lib/Trash/LegacyTrashBackend.php - line 108:
    OCA\Files_Trashbin\Trashbin::move2trash()
  11. /usr/local/www/nextcloud/apps-pkg/files_trashbin/lib/Trash/TrashManager.php - line 103:
    OCA\Files_Trashbin\Trash\LegacyTrashBackend->moveToTrash()
  12. /usr/local/www/nextcloud/apps-pkg/files_trashbin/lib/Storage.php - line 192:
    OCA\Files_Trashbin\Trash\TrashManager->moveToTrash()
  13. /usr/local/www/nextcloud/apps-pkg/files_trashbin/lib/Storage.php - line 118:
    OCA\Files_Trashbin\Storage->doDelete()
  14. /usr/local/www/nextcloud/lib/private/Files/View.php - line 1167:
    OCA\Files_Trashbin\Storage->rmdir()
  15. /usr/local/www/nextcloud/lib/private/Files/View.php - line 350:
    OC\Files\View->basicOperation()
  16. /usr/local/www/nextcloud/apps-pkg/dav/lib/Connector/Sabre/Directory.php - line 309:
    OC\Files\View->rmdir()
  17. /usr/local/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php - line 183:
    OCA\DAV\Connector\Sabre\Directory->delete()
  18. /usr/local/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php - line 295:
    Sabre\DAV\Tree->delete()
  19. /usr/local/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php - line 89:
    Sabre\DAV\CorePlugin->httpDelete()
  20. /usr/local/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 474:
    Sabre\DAV\Server->emit()
  21. /usr/local/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 251:
    Sabre\DAV\Server->invokeMethod()
  22. /usr/local/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php - line 319:
    Sabre\DAV\Server->start()
  23. /usr/local/www/nextcloud/apps-pkg/dav/lib/Server.php - line 332:
    Sabre\DAV\Server->exec()
  24. /usr/local/www/nextcloud/apps-pkg/dav/appinfo/v2/remote.php - line 35:
    OCA\DAV\Server->exec()
  25. /usr/local/www/nextcloud/remote.php - line 167:
    require_once("/usr/local/ ... p")
 
Top