Erreur Nextcloud après une migration mysql et/ou LDAP

rodinux · December 31, 2021, 4:48pm

Mon serveur YunoHost

Matériel: VPS acheté en ligne VPN
Version de YunoHost: 4.3.5
J’ai accès à mon serveur : En SSH | Par la webadmin | En direct avec un clavier/écran | …
Êtes-vous dans un contexte particulier ou avez-vous effectué des modificiations particulières sur votre instance ? : non

Description du problème

Bonjour,
depuis une restauration d’une instance sur un VPS, Nexcloud semble avoir des soucis de configurations. J’ai même essayé de sauvegarder les données, de désinstaller Nexcloud et réinstaller… Du coup je me rend compte que ce sont des erreurs de configurations système…
bdd mysql ou mariadb ? LDAP ? Pas terrible, j’aimerai bien réparé cela…

Voici certains logs en erreur dans Nextcloud

Error	index	OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 18, 18, 18' at line 1

    /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 335:

    OC\DB\Exceptions\DbalException::wrap(Doctrine\DBA ... {})

    /var/www/nextcloud/lib/private/Files/Cache/Storage.php - line 249:

    OC\DB\QueryBuilder\QueryBuilder->executeStatement()

    /var/www/nextcloud/apps/files_external/lib/Service/StoragesService.php - line 482:

    OC\Files\Cache\Storage::cleanByMountId(7)

    /var/www/nextcloud/apps/files_external/lib/Controller/StoragesController.php - line 374:

    OCA\Files_External\Service\StoragesService->removeStorage(7)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 217:

    OCA\Files_External\Controller\StoragesController->destroy(7)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 126:

    OC\AppFramework\Http\Dispatcher->executeController(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/AppFramework/App.php - line 156:

    OC\AppFramework\Http\Dispatcher->dispatch(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/Route/Router.php - line 302:

    OC\AppFramework\App::main("OCA\\Files_ ... r", "destroy", OC\AppFramew ... {}, { id: "7",_r ... "})

    /var/www/nextcloud/lib/base.php - line 1006:

    OC\Route\Router->match("/apps/files ... 7")

    /var/www/nextcloud/index.php - line 36:

    OC::handleRequest()

Causé par Doctrine\DBAL\Exception\SyntaxErrorException: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 18, 18, 18' at line 1

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1780:

    Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Doctrine\DBA ... {}, Doctrine\DBAL\Query {})

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1719:

    Doctrine\DBAL\Connection->handleDriverException(Doctrine\DBA ... {}, Doctrine\DBAL\Query {})

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1173:

    Doctrine\DBAL\Connection->convertExceptionDuringQuery(Doctrine\DBA ... {}, "DELETE FROM ... ?", [ "18","18","18","18"], [ 1,1,1,1])

    /var/www/nextcloud/lib/private/DB/Connection.php - line 267:

    Doctrine\DBAL\Connection->executeStatement("DELETE FROM ... ?", [ "18","18","18","18"], [ 1,1,1,1])

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 354:

    OC\DB\Connection->executeStatement("DELETE FROM ... 1", { dcValue1: ... ]}, { dcValue1: 101})

    /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 287:

    Doctrine\DBAL\Query\QueryBuilder->execute()

    /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 333:

    OC\DB\QueryBuilder\QueryBuilder->execute()

    /var/www/nextcloud/lib/private/Files/Cache/Storage.php - line 249:

    OC\DB\QueryBuilder\QueryBuilder->executeStatement()

    /var/www/nextcloud/apps/files_external/lib/Service/StoragesService.php - line 482:

    OC\Files\Cache\Storage::cleanByMountId(7)

    /var/www/nextcloud/apps/files_external/lib/Controller/StoragesController.php - line 374:

    OCA\Files_External\Service\StoragesService->removeStorage(7)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 217:

    OCA\Files_External\Controller\StoragesController->destroy(7)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 126:

    OC\AppFramework\Http\Dispatcher->executeController(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/AppFramework/App.php - line 156:

    OC\AppFramework\Http\Dispatcher->dispatch(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/Route/Router.php - line 302:

    OC\AppFramework\App::main("OCA\\Files_ ... r", "destroy", OC\AppFramew ... {}, { id: "7",_r ... "})

    /var/www/nextcloud/lib/base.php - line 1006:

    OC\Route\Router->match("/apps/files ... 7")

    /var/www/nextcloud/index.php - line 36:

    OC::handleRequest()

Causé par Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 18, 18, 18' at line 1

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php - line 94:

    Doctrine\DBAL\Driver\PDO\Exception::new(PDOException ... ]})

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1163:

    Doctrine\DBAL\Driver\PDO\Statement->execute()

    /var/www/nextcloud/lib/private/DB/Connection.php - line 267:

    Doctrine\DBAL\Connection->executeStatement("DELETE FROM ... ?", [ "18","18","18","18"], [ 1,1,1,1])

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 354:

    OC\DB\Connection->executeStatement("DELETE FROM ... 1", { dcValue1: ... ]}, { dcValue1: 101})

    /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 287:

    Doctrine\DBAL\Query\QueryBuilder->execute()

    /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 333:

    OC\DB\QueryBuilder\QueryBuilder->execute()

    /var/www/nextcloud/lib/private/Files/Cache/Storage.php - line 249:

    OC\DB\QueryBuilder\QueryBuilder->executeStatement()

    /var/www/nextcloud/apps/files_external/lib/Service/StoragesService.php - line 482:

    OC\Files\Cache\Storage::cleanByMountId(7)

    /var/www/nextcloud/apps/files_external/lib/Controller/StoragesController.php - line 374:

    OCA\Files_External\Service\StoragesService->removeStorage(7)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 217:

    OCA\Files_External\Controller\StoragesController->destroy(7)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 126:

    OC\AppFramework\Http\Dispatcher->executeController(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/AppFramework/App.php - line 156:

    OC\AppFramework\Http\Dispatcher->dispatch(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/Route/Router.php - line 302:

    OC\AppFramework\App::main("OCA\\Files_ ... r", "destroy", OC\AppFramew ... {}, { id: "7",_r ... "})

    /var/www/nextcloud/lib/base.php - line 1006:

    OC\Route\Router->match("/apps/files ... 7")

    /var/www/nextcloud/index.php - line 36:

    OC::handleRequest()

Causé par PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 18, 18, 18' at line 1

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php - line 92:

    PDOStatement->execute(null)

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1163:

    Doctrine\DBAL\Driver\PDO\Statement->execute()

    /var/www/nextcloud/lib/private/DB/Connection.php - line 267:

    Doctrine\DBAL\Connection->executeStatement("DELETE FROM ... ?", [ "18","18","18","18"], [ 1,1,1,1])

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 354:

    OC\DB\Connection->executeStatement("DELETE FROM ... 1", { dcValue1: ... ]}, { dcValue1: 101})

    /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 287:

    Doctrine\DBAL\Query\QueryBuilder->execute()

    /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 333:

    OC\DB\QueryBuilder\QueryBuilder->execute()

    /var/www/nextcloud/lib/private/Files/Cache/Storage.php - line 249:

    OC\DB\QueryBuilder\QueryBuilder->executeStatement()

    /var/www/nextcloud/apps/files_external/lib/Service/StoragesService.php - line 482:

    OC\Files\Cache\Storage::cleanByMountId(7)

    /var/www/nextcloud/apps/files_external/lib/Controller/StoragesController.php - line 374:

    OCA\Files_External\Service\StoragesService->removeStorage(7)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 217:

    OCA\Files_External\Controller\StoragesController->destroy(7)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 126:

    OC\AppFramework\Http\Dispatcher->executeController(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/AppFramework/App.php - line 156:

    OC\AppFramework\Http\Dispatcher->dispatch(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/Route/Router.php - line 302:

    OC\AppFramework\App::main("OCA\\Files_ ... r", "destroy", OC\AppFramew ... {}, { id: "7",_r ... "})

    /var/www/nextcloud/lib/base.php - line 1006:

    OC\Route\Router->match("/apps/files ... 7")

    /var/www/nextcloud/index.php - line 36:

    OC::handleRequest()

	
2021-12-30T01:48:21+0100
Error	index	OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 10, 13, 16' at line 1

    /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 335:

    OC\DB\Exceptions\DbalException::wrap(Doctrine\DBA ... {})

    /var/www/nextcloud/lib/private/Files/Cache/Storage.php - line 249:

    OC\DB\QueryBuilder\QueryBuilder->executeStatement()

    /var/www/nextcloud/apps/files_external/lib/Service/StoragesService.php - line 482:

    OC\Files\Cache\Storage::cleanByMountId(6)

    /var/www/nextcloud/apps/files_external/lib/Controller/StoragesController.php - line 374:

    OCA\Files_External\Service\StoragesService->removeStorage(6)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 217:

    OCA\Files_External\Controller\StoragesController->destroy(6)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 126:

    OC\AppFramework\Http\Dispatcher->executeController(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/AppFramework/App.php - line 156:

    OC\AppFramework\Http\Dispatcher->dispatch(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/Route/Router.php - line 302:

    OC\AppFramework\App::main("OCA\\Files_ ... r", "destroy", OC\AppFramew ... {}, { id: "6",_r ... "})

    /var/www/nextcloud/lib/base.php - line 1006:

    OC\Route\Router->match("/apps/files ... 6")

    /var/www/nextcloud/index.php - line 36:

    OC::handleRequest()

Causé par Doctrine\DBAL\Exception\SyntaxErrorException: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 10, 13, 16' at line 1

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1780:

    Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Doctrine\DBA ... {}, Doctrine\DBAL\Query {})

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1719:

    Doctrine\DBAL\Connection->handleDriverException(Doctrine\DBA ... {}, Doctrine\DBAL\Query {})

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1173:

    Doctrine\DBAL\Connection->convertExceptionDuringQuery(Doctrine\DBA ... {}, "DELETE FROM ... ?", [ "7","10","13","16"], [ 1,1,1,1])

    /var/www/nextcloud/lib/private/DB/Connection.php - line 267:

    Doctrine\DBAL\Connection->executeStatement("DELETE FROM ... ?", [ "7","10","13","16"], [ 1,1,1,1])

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 354:

    OC\DB\Connection->executeStatement("DELETE FROM ... 1", { dcValue1: ... ]}, { dcValue1: 101})

    /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 287:

    Doctrine\DBAL\Query\QueryBuilder->execute()

    /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 333:

    OC\DB\QueryBuilder\QueryBuilder->execute()

    /var/www/nextcloud/lib/private/Files/Cache/Storage.php - line 249:

    OC\DB\QueryBuilder\QueryBuilder->executeStatement()

    /var/www/nextcloud/apps/files_external/lib/Service/StoragesService.php - line 482:

    OC\Files\Cache\Storage::cleanByMountId(6)

    /var/www/nextcloud/apps/files_external/lib/Controller/StoragesController.php - line 374:

    OCA\Files_External\Service\StoragesService->removeStorage(6)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 217:

    OCA\Files_External\Controller\StoragesController->destroy(6)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 126:

    OC\AppFramework\Http\Dispatcher->executeController(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/AppFramework/App.php - line 156:

    OC\AppFramework\Http\Dispatcher->dispatch(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/Route/Router.php - line 302:

    OC\AppFramework\App::main("OCA\\Files_ ... r", "destroy", OC\AppFramew ... {}, { id: "6",_r ... "})

    /var/www/nextcloud/lib/base.php - line 1006:

    OC\Route\Router->match("/apps/files ... 6")

    /var/www/nextcloud/index.php - line 36:

    OC::handleRequest()

Causé par Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 10, 13, 16' at line 1

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php - line 94:

    Doctrine\DBAL\Driver\PDO\Exception::new(PDOException ... ]})

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1163:

    Doctrine\DBAL\Driver\PDO\Statement->execute()

    /var/www/nextcloud/lib/private/DB/Connection.php - line 267:

    Doctrine\DBAL\Connection->executeStatement("DELETE FROM ... ?", [ "7","10","13","16"], [ 1,1,1,1])

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 354:

    OC\DB\Connection->executeStatement("DELETE FROM ... 1", { dcValue1: ... ]}, { dcValue1: 101})

    /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 287:

    Doctrine\DBAL\Query\QueryBuilder->execute()

    /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 333:

    OC\DB\QueryBuilder\QueryBuilder->execute()

    /var/www/nextcloud/lib/private/Files/Cache/Storage.php - line 249:

    OC\DB\QueryBuilder\QueryBuilder->executeStatement()

    /var/www/nextcloud/apps/files_external/lib/Service/StoragesService.php - line 482:

    OC\Files\Cache\Storage::cleanByMountId(6)

    /var/www/nextcloud/apps/files_external/lib/Controller/StoragesController.php - line 374:

    OCA\Files_External\Service\StoragesService->removeStorage(6)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 217:

    OCA\Files_External\Controller\StoragesController->destroy(6)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 126:

    OC\AppFramework\Http\Dispatcher->executeController(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/AppFramework/App.php - line 156:

    OC\AppFramework\Http\Dispatcher->dispatch(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/Route/Router.php - line 302:

    OC\AppFramework\App::main("OCA\\Files_ ... r", "destroy", OC\AppFramew ... {}, { id: "6",_r ... "})

    /var/www/nextcloud/lib/base.php - line 1006:

    OC\Route\Router->match("/apps/files ... 6")

    /var/www/nextcloud/index.php - line 36:

    OC::handleRequest()

Causé par PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 10, 13, 16' at line 1

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php - line 92:

    PDOStatement->execute(null)

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1163:

    Doctrine\DBAL\Driver\PDO\Statement->execute()

    /var/www/nextcloud/lib/private/DB/Connection.php - line 267:

    Doctrine\DBAL\Connection->executeStatement("DELETE FROM ... ?", [ "7","10","13","16"], [ 1,1,1,1])

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 354:

    OC\DB\Connection->executeStatement("DELETE FROM ... 1", { dcValue1: ... ]}, { dcValue1: 101})

    /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 287:

    Doctrine\DBAL\Query\QueryBuilder->execute()

    /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 333:

    OC\DB\QueryBuilder\QueryBuilder->execute()

    /var/www/nextcloud/lib/private/Files/Cache/Storage.php - line 249:

    OC\DB\QueryBuilder\QueryBuilder->executeStatement()

    /var/www/nextcloud/apps/files_external/lib/Service/StoragesService.php - line 482:

    OC\Files\Cache\Storage::cleanByMountId(6)

    /var/www/nextcloud/apps/files_external/lib/Controller/StoragesController.php - line 374:

    OCA\Files_External\Service\StoragesService->removeStorage(6)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 217:

    OCA\Files_External\Controller\StoragesController->destroy(6)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 126:

    OC\AppFramework\Http\Dispatcher->executeController(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/AppFramework/App.php - line 156:

    OC\AppFramework\Http\Dispatcher->dispatch(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/Route/Router.php - line 302:

    OC\AppFramework\App::main("OCA\\Files_ ... r", "destroy", OC\AppFramew ... {}, { id: "6",_r ... "})

    /var/www/nextcloud/lib/base.php - line 1006:

    OC\Route\Router->match("/apps/files ... 6")

    /var/www/nextcloud/index.php - line 36:

    OC::handleRequest()

	
2021-12-30T01:48:16+0100
Error	index	OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 9, 12, 15' at line 1

    /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 335:

    OC\DB\Exceptions\DbalException::wrap(Doctrine\DBA ... {})

    /var/www/nextcloud/lib/private/Files/Cache/Storage.php - line 249:

    OC\DB\QueryBuilder\QueryBuilder->executeStatement()

    /var/www/nextcloud/apps/files_external/lib/Service/StoragesService.php - line 482:

    OC\Files\Cache\Storage::cleanByMountId(1)

    /var/www/nextcloud/apps/files_external/lib/Controller/StoragesController.php - line 374:

    OCA\Files_External\Service\StoragesService->removeStorage(1)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 217:

    OCA\Files_External\Controller\StoragesController->destroy(1)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 126:

    OC\AppFramework\Http\Dispatcher->executeController(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/AppFramework/App.php - line 156:

    OC\AppFramework\Http\Dispatcher->dispatch(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/Route/Router.php - line 302:

    OC\AppFramework\App::main("OCA\\Files_ ... r", "destroy", OC\AppFramew ... {}, { id: "1",_r ... "})

    /var/www/nextcloud/lib/base.php - line 1006:

    OC\Route\Router->match("/apps/files ... 1")

    /var/www/nextcloud/index.php - line 36:

    OC::handleRequest()

Causé par Doctrine\DBAL\Exception\SyntaxErrorException: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 9, 12, 15' at line 1

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1780:

    Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Doctrine\DBA ... {}, Doctrine\DBAL\Query {})

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1719:

    Doctrine\DBAL\Connection->handleDriverException(Doctrine\DBA ... {}, Doctrine\DBAL\Query {})

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1173:

    Doctrine\DBAL\Connection->convertExceptionDuringQuery(Doctrine\DBA ... {}, "DELETE FROM ... ?", [ "6","9","12","15"], [ 1,1,1,1])

    /var/www/nextcloud/lib/private/DB/Connection.php - line 267:

    Doctrine\DBAL\Connection->executeStatement("DELETE FROM ... ?", [ "6","9","12","15"], [ 1,1,1,1])

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 354:

    OC\DB\Connection->executeStatement("DELETE FROM ... 1", { dcValue1: ... ]}, { dcValue1: 101})

    /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 287:

    Doctrine\DBAL\Query\QueryBuilder->execute()

    /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 333:

    OC\DB\QueryBuilder\QueryBuilder->execute()

    /var/www/nextcloud/lib/private/Files/Cache/Storage.php - line 249:

    OC\DB\QueryBuilder\QueryBuilder->executeStatement()

    /var/www/nextcloud/apps/files_external/lib/Service/StoragesService.php - line 482:

    OC\Files\Cache\Storage::cleanByMountId(1)

    /var/www/nextcloud/apps/files_external/lib/Controller/StoragesController.php - line 374:

    OCA\Files_External\Service\StoragesService->removeStorage(1)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 217:

    OCA\Files_External\Controller\StoragesController->destroy(1)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 126:

    OC\AppFramework\Http\Dispatcher->executeController(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/AppFramework/App.php - line 156:

    OC\AppFramework\Http\Dispatcher->dispatch(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/Route/Router.php - line 302:

    OC\AppFramework\App::main("OCA\\Files_ ... r", "destroy", OC\AppFramew ... {}, { id: "1",_r ... "})

    /var/www/nextcloud/lib/base.php - line 1006:

    OC\Route\Router->match("/apps/files ... 1")

    /var/www/nextcloud/index.php - line 36:

    OC::handleRequest()

Causé par Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 9, 12, 15' at line 1

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php - line 94:

    Doctrine\DBAL\Driver\PDO\Exception::new(PDOException ... ]})

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1163:

    Doctrine\DBAL\Driver\PDO\Statement->execute()

    /var/www/nextcloud/lib/private/DB/Connection.php - line 267:

    Doctrine\DBAL\Connection->executeStatement("DELETE FROM ... ?", [ "6","9","12","15"], [ 1,1,1,1])

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 354:

    OC\DB\Connection->executeStatement("DELETE FROM ... 1", { dcValue1: ... ]}, { dcValue1: 101})

    /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 287:

    Doctrine\DBAL\Query\QueryBuilder->execute()

    /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 333:

    OC\DB\QueryBuilder\QueryBuilder->execute()

    /var/www/nextcloud/lib/private/Files/Cache/Storage.php - line 249:

    OC\DB\QueryBuilder\QueryBuilder->executeStatement()

    /var/www/nextcloud/apps/files_external/lib/Service/StoragesService.php - line 482:

    OC\Files\Cache\Storage::cleanByMountId(1)

    /var/www/nextcloud/apps/files_external/lib/Controller/StoragesController.php - line 374:

    OCA\Files_External\Service\StoragesService->removeStorage(1)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 217:

    OCA\Files_External\Controller\StoragesController->destroy(1)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 126:

    OC\AppFramework\Http\Dispatcher->executeController(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/AppFramework/App.php - line 156:

    OC\AppFramework\Http\Dispatcher->dispatch(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/Route/Router.php - line 302:

    OC\AppFramework\App::main("OCA\\Files_ ... r", "destroy", OC\AppFramew ... {}, { id: "1",_r ... "})

    /var/www/nextcloud/lib/base.php - line 1006:

    OC\Route\Router->match("/apps/files ... 1")

    /var/www/nextcloud/index.php - line 36:

    OC::handleRequest()

Causé par PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 9, 12, 15' at line 1

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php - line 92:

    PDOStatement->execute(null)

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php - line 1163:

    Doctrine\DBAL\Driver\PDO\Statement->execute()

    /var/www/nextcloud/lib/private/DB/Connection.php - line 267:

    Doctrine\DBAL\Connection->executeStatement("DELETE FROM ... ?", [ "6","9","12","15"], [ 1,1,1,1])

    /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php - line 354:

    OC\DB\Connection->executeStatement("DELETE FROM ... 1", { dcValue1: ... ]}, { dcValue1: 101})

    /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 287:

    Doctrine\DBAL\Query\QueryBuilder->execute()

    /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 333:

    OC\DB\QueryBuilder\QueryBuilder->execute()

    /var/www/nextcloud/lib/private/Files/Cache/Storage.php - line 249:

    OC\DB\QueryBuilder\QueryBuilder->executeStatement()

    /var/www/nextcloud/apps/files_external/lib/Service/StoragesService.php - line 482:

    OC\Files\Cache\Storage::cleanByMountId(1)

    /var/www/nextcloud/apps/files_external/lib/Controller/StoragesController.php - line 374:

    OCA\Files_External\Service\StoragesService->removeStorage(1)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 217:

    OCA\Files_External\Controller\StoragesController->destroy(1)

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 126:

    OC\AppFramework\Http\Dispatcher->executeController(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/AppFramework/App.php - line 156:

    OC\AppFramework\Http\Dispatcher->dispatch(OCA\Files_Ex ... {}, "destroy")

    /var/www/nextcloud/lib/private/Route/Router.php - line 302:

    OC\AppFramework\App::main("OCA\\Files_ ... r", "destroy", OC\AppFramew ... {}, { id: "1",_r ... "})

    /var/www/nextcloud/lib/base.php - line 1006:

    OC\Route\Router->match("/apps/files ... 1")

    /var/www/nextcloud/index.php - line 36:

    OC::handleRequest()

	
2021-12-30T01:47:51+0100
Error	PHP	Error: ldap_unbind(): supplied resource is not a valid ldap link resource at /var/www/nextcloud/apps/user_ldap/lib/LDAP.php#336

    <<closure>>

    OC\Log\ErrorHandler::onError(2, "ldap_unbind ... e", "/var/www/ne ... p", 336, { arguments: ... "})

    <<closure>>

    ldap_unbind("*** sensiti ... *")

    /var/www/nextcloud/apps/user_ldap/lib/LDAP.php - line 336:

    call_user_func_array("ldap_unbind", [ "*** sensi ... "])

    /var/www/nextcloud/apps/user_ldap/lib/LDAP.php - line 283:

    OCA\User_LDAP\LDAP->invokeLDAPMethod("*** sensiti ... *")

    /var/www/nextcloud/apps/user_ldap/lib/Wizard.php - line 1103:

    OCA\User_LDAP\LDAP->unbind("*** sensiti ... *")

    /var/www/nextcloud/apps/user_ldap/lib/Wizard.php - line 696:

    OCA\User_LDAP\Wizard->connectAndBind(389, false)

    /var/www/nextcloud/apps/user_ldap/ajax/wizard.php - line 96:

    OCA\User_LDAP\Wizard->guessPortAndTLS()

    /var/www/nextcloud/lib/private/Route/Route.php - line 155:

    require_once("/var/www/ne ... p")

    <<closure>>

    OC\Route\Route->OC\Route\{closure}("*** sensiti ... *")

    /var/www/nextcloud/lib/private/Route/Router.php - line 310:

    call_user_func(Closure {}, { _route: "u ... "})

    /var/www/nextcloud/lib/base.php - line 1006:

    OC\Route\Router->match("/apps/user_ ... p")

    /var/www/nextcloud/index.php - line 36:

    OC::handleRequest()

	
2021-12-30T00:53:55+0100
Error	PHP	Error: Undefined index: s01 at /var/www/nextcloud/apps/user_ldap/templates/part.wizard-server.php#10

    /var/www/nextcloud/apps/user_ldap/templates/part.wizard-server.php - line 10:

    OC\Log\ErrorHandler::onError(8, "Undefined index: s01", "/var/www/ne ... p", 10, { 0: "And 65 ... }})

    /var/www/nextcloud/apps/user_ldap/templates/settings.php - line 74:

    require_once("/var/www/ne ... p")

    /var/www/nextcloud/lib/private/Template/Base.php - line 180:

    include("/var/www/ne ... p")

    /var/www/nextcloud/lib/private/Template/Base.php - line 150:

    OC\Template\Base->load("/var/www/ne ... p", { 0: "And 54 ... "})

    /var/www/nextcloud/lib/private/legacy/OC_Template.php - line 179:

    OC\Template\Base->fetchPage({ 0: "And 54 ... "})

    /var/www/nextcloud/lib/public/AppFramework/Http/TemplateResponse.php - line 204:

    OC_Template->fetchPage({ 0: "And 54 ... "})

    /var/www/nextcloud/apps/settings/lib/Controller/CommonSettingsTrait.php - line 138:

    OCP\AppFramework\Http\TemplateResponse->render()

    /var/www/nextcloud/apps/settings/lib/Controller/AdminSettingsController.php - line 82:

    OCA\Settings\Controller\AdminSettingsController->formatSettings({ 5: [ OCA\U ... ]})

    /var/www/nextcloud/apps/settings/lib/Controller/CommonSettingsTrait.php - line 148:

    OCA\Settings\Controller\AdminSettingsController->getSettings("ldap")

    /var/www/nextcloud/apps/settings/lib/Controller/AdminSettingsController.php - line 67:

    OCA\Settings\Controller\AdminSettingsController->getIndexResponse("admin", "ldap")

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 217:

    OCA\Settings\Controller\AdminSettingsController->index("ldap")

    /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 126:

    OC\AppFramework\Http\Dispatcher->executeController(OCA\Settings ... {}, "index")

    /var/www/nextcloud/lib/private/AppFramework/App.php - line 156:

    OC\AppFramework\Http\Dispatcher->dispatch(OCA\Settings ... {}, "index")

    /var/www/nextcloud/lib/private/Route/Router.php - line 302:

    OC\AppFramework\App::main("OCA\\Settin ... r", "index", OC\AppFramew ... {}, { section: " ... "})

    /var/www/nextcloud/lib/base.php - line 1006:

    OC\Route\Router->match("/settings/admin/ldap")

    /var/www/nextcloud/index.php - line 36:

    OC::handleRequest()

Aleks · December 31, 2021, 6:04pm

Que veux-tu dire par “dans Nextcloud” ?

Si il s’agit d’un log d’upgrade de Yunohost, alors il faut nous partager le log complet.

Si il ne s’agit pas d’un log de Yunohost, alors il faut nous expliquer plus précisément d’où ça viens et comment tu l’as obtenu

rodinux · January 1, 2022, 1:00pm

Il ne s’agit pas d’un log de Yunohost. C’est des logs dans l’interface de Nextcloud qui dans Paramètres => Système me montre ce message

Ceci suite à une migration de ce serveur vers un VPS où j’ai restauré le système avec des backups du serveur. Ces messages sont suite à une tentative de désinstaller la restauration de Nextcloud et une réinstallation…

Mais cela semble des erreurs propres à Nextcloud…

Ceci dit des logs de Yunohost qui ont peut-être un lien

/var/log/syslog

Jan  1 13:02:11 lucchareyron nslcd[1041]: [315369] <passwd="*"> request denied by validnames option
Jan  1 13:02:12 lucchareyron slapd[938]: slap_global_control: unrecognized control: 1.3.6.1.4.1.4203.666.5.16

Aleks · January 1, 2022, 1:07pm

Wokay mais dans le screenshot que tu montres, je ne vois pas les message d’erreurs que tu as posté initialement, donc d’où viennent-ils ?

rodinux · January 1, 2022, 1:15pm

En cliquant sur logs dans le message de cette interface de Nextcloud. Ou aussi un onglet Paramètres => Journalisation
On dirait des erreurs du à mysql ou MariaDB, ou avec les apps de Nextcloud… Je ne sais pas trop… Par contre les logs que j’ai mis au début ne sont pas complets, en effet.
En voici deux plus complets

{"reqId":"KtnnOcjxByc9iC21DMn2","level":3,"time":"2022-01-01T13:33:02+00:00","remoteAddr":"2a01:e0a:94:50:21ea:ed8f:65ea:e5a8","user":"nom_user","app":"PHP","method":"POST","url":"/nextcloud/apps/user_ldap/ajax/wizard.php","message":"ldap_unbind(): supplied resource is not a valid ldap link resource at /var/www/nextcloud/apps/user_ldap/lib/LDAP.php#336","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Firefox/78.0","version":"22.2.3.0","exception":{"Exception":"Error","Message":"ldap_unbind(): supplied resource is not a valid ldap link resource at /var/www/nextcloud/apps/user_ldap/lib/LDAP.php#336","Code":0,"Trace":[{"function":"onError","class":"OC\\Log\\ErrorHandler","type":"::","args":[2,"ldap_unbind(): supplied resource is not a valid ldap link resource","/var/www/nextcloud/apps/user_ldap/lib/LDAP.php",336,{"arguments":["*** sensitive parameter replaced ***"],"func":"ldap_unbind"}]},{"function":"ldap_unbind","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/apps/user_ldap/lib/LDAP.php","line":336,"function":"call_user_func_array","args":["ldap_unbind",["*** sensitive parameter replaced ***"]]},{"file":"/var/www/nextcloud/apps/user_ldap/lib/LDAP.php","line":283,"function":"invokeLDAPMethod","class":"OCA\\User_LDAP\\LDAP","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/apps/user_ldap/lib/Wizard.php","line":1103,"function":"unbind","class":"OCA\\User_LDAP\\LDAP","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/apps/user_ldap/lib/Wizard.php","line":696,"function":"connectAndBind","class":"OCA\\User_LDAP\\Wizard","type":"->","args":[389,false]},{"file":"/var/www/nextcloud/apps/user_ldap/ajax/wizard.php","line":96,"function":"guessPortAndTLS","class":"OCA\\User_LDAP\\Wizard","type":"->","args":[]},{"file":"/var/www/nextcloud/lib/private/Route/Route.php","line":155,"args":["/var/www/nextcloud/apps/user_ldap/ajax/wizard.php"],"function":"require_once"},{"function":"OC\\Route\\{closure}","class":"OC\\Route\\Route","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":310,"function":"call_user_func","args":[{"__class__":"Closure"},{"_route":"user_ldap_ajax_wizard"}]},{"file":"/var/www/nextcloud/lib/base.php","line":1006,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/user_ldap/ajax/wizard.php"]},{"file":"/var/www/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/nextcloud/lib/private/Log/ErrorHandler.php","Line":92,"CustomMessage":"--"},"id":"61d0586655c43"}
{"reqId":"8T0fD4oU5q6mF89TdNgh","level":3,"time":"2022-01-01T13:32:49+00:00","remoteAddr":"2a01:e0a:94:50:21ea:ed8f:65ea:e5a8","user":"nom_user","app":"PHP","method":"GET","url":"/nextcloud/settings/admin/ldap","message":"Undefined index: s01 at /var/www/nextcloud/apps/user_ldap/templates/part.wizard-server.php#10","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Firefox/78.0","version":"22.2.3.0","exception":{"Exception":"Error","Message":"Undefined index: s01 at /var/www/nextcloud/apps/user_ldap/templates/part.wizard-server.php#10","Code":0,"Trace":[{"file":"/var/www/nextcloud/apps/user_ldap/templates/part.wizard-server.php","line":10,"function":"onError","class":"OC\\Log\\ErrorHandler","type":"::","args":[8,"Undefined index: s01","/var/www/nextcloud/apps/user_ldap/templates/part.wizard-server.php",10,{"0":"And 65 more entries, set log level to debug to see all entries","file":"/var/www/nextcloud/apps/user_ldap/templates/settings.php","additionalParams":{"0":"And 54 more entries, set log level to debug to see all entries","serverConfigurationPrefixes":["","s01"],"serverConfigurationHosts":{"":"localhost"},"settingControls":"<div class=\"ldapSettingControls\">\n\t<button type=\"button\" class=\"ldap_action_test_connection\" name=\"ldap_action_test_connection\">\n\t\tTester la configuration\t</button>\n\t<a href=\"https://docs.nextcloud.com/server/22/go.php?to=admin-ldap\"\n\t\ttarget=\"_blank\" rel=\"noreferrer noopener\">\n\t\t<img src=\"/nextcloud/core/img/actions/info.svg\"\n\t\t\tstyle=\"height:1.75ex\" />\n\t\tAide\t</a>\n</div>\n","wizardControls":"<div class=\"ldapWizardControls\">\n\t<span class=\"ldap_saving hidden\">Enregistrement... <img class=\"wizSpinner\" src=\"/nextcloud/core/img/loading.gif\"/></span>\n\t<span class=\"ldap_config_state_indicator\"></span> <span class=\"ldap_config_state_indicator_sign\"></span>\n\t<button class=\"ldap_action_back invisible\" name=\"ldap_action_back\"\n\t\t\ttype=\"button\">\n\t\tRetour\t</button>\n\t<button class=\"ldap_action_continue primary\" name=\"ldap_action_continue\" type=\"button\">\n\t\tContinuer\t</button>\n\t<a href=\"https://docs.nextcloud.com/server/22/go.php?to=admin-ldap\"\n\t\ttarget=\"_blank\" rel=\"noreferrer noopener\">\n\t\t<img src=\"/nextcloud/core/img/actions/info.svg\"\n\t\t\tstyle=\"height:1.75ex\" />\n\t\t<span class=\"ldap_grey\">Aide</span>\n\t</a>\n</div>\n","ldap_host_default":""},"_":{"0":"And 55 more entries, set log level to debug to see all entries","serverConfigurationPrefixes":["","s01"],"serverConfigurationHosts":{"":"localhost"},"settingControls":"<div class=\"ldapSettingControls\">\n\t<button type=\"button\" class=\"ldap_action_test_connection\" name=\"ldap_action_test_connection\">\n\t\tTester la configuration\t</button>\n\t<a href=\"https://docs.nextcloud.com/server/22/go.php?to=admin-ldap\"\n\t\ttarget=\"_blank\" rel=\"noreferrer noopener\">\n\t\t<img src=\"/nextcloud/core/img/actions/info.svg\"\n\t\t\tstyle=\"height:1.75ex\" />\n\t\tAide\t</a>\n</div>\n","wizardControls":"<div class=\"ldapWizardControls\">\n\t<span class=\"ldap_saving hidden\">Enregistrement... <img class=\"wizSpinner\" src=\"/nextcloud/core/img/loading.gif\"/></span>\n\t<span class=\"ldap_config_state_indicator\"></span> <span class=\"ldap_config_state_indicator_sign\"></span>\n\t<button class=\"ldap_action_back invisible\" name=\"ldap_action_back\"\n\t\t\ttype=\"button\">\n\t\tRetour\t</button>\n\t<button class=\"ldap_action_continue primary\" name=\"ldap_action_continue\" type=\"button\">\n\t\tContinuer\t</button>\n\t<a href=\"https://docs.nextcloud.com/server/22/go.php?to=admin-ldap\"\n\t\ttarget=\"_blank\" rel=\"noreferrer noopener\">\n\t\t<img src=\"/nextcloud/core/img/actions/info.svg\"\n\t\t\tstyle=\"height:1.75ex\" />\n\t\t<span class=\"ldap_grey\">Aide</span>\n\t</a>\n</div>\n","ldap_host_default":""},"l":{"__class__":"OC\\L10N\\LazyL10N"},"theme":{"__class__":"OCP\\Defaults"}}]},{"file":"/var/www/nextcloud/apps/user_ldap/templates/settings.php","line":74,"args":["/var/www/nextcloud/apps/user_ldap/templates/part.wizard-server.php"],"function":"require_once"},{"file":"/var/www/nextcloud/lib/private/Template/Base.php","line":180,"args":["/var/www/nextcloud/apps/user_ldap/templates/settings.php"],"function":"include"},{"file":"/var/www/nextcloud/lib/private/Template/Base.php","line":150,"function":"load","class":"OC\\Template\\Base","type":"->","args":["/var/www/nextcloud/apps/user_ldap/templates/settings.php",{"0":"And 54 more entries, set log level to debug to see all entries","serverConfigurationPrefixes":["","s01"],"serverConfigurationHosts":{"":"localhost"},"settingControls":"<div class=\"ldapSettingControls\">\n\t<button type=\"button\" class=\"ldap_action_test_connection\" name=\"ldap_action_test_connection\">\n\t\tTester la configuration\t</button>\n\t<a href=\"https://docs.nextcloud.com/server/22/go.php?to=admin-ldap\"\n\t\ttarget=\"_blank\" rel=\"noreferrer noopener\">\n\t\t<img src=\"/nextcloud/core/img/actions/info.svg\"\n\t\t\tstyle=\"height:1.75ex\" />\n\t\tAide\t</a>\n</div>\n","wizardControls":"<div class=\"ldapWizardControls\">\n\t<span class=\"ldap_saving hidden\">Enregistrement... <img class=\"wizSpinner\" src=\"/nextcloud/core/img/loading.gif\"/></span>\n\t<span class=\"ldap_config_state_indicator\"></span> <span class=\"ldap_config_state_indicator_sign\"></span>\n\t<button class=\"ldap_action_back invisible\" name=\"ldap_action_back\"\n\t\t\ttype=\"button\">\n\t\tRetour\t</button>\n\t<button class=\"ldap_action_continue primary\" name=\"ldap_action_continue\" type=\"button\">\n\t\tContinuer\t</button>\n\t<a href=\"https://docs.nextcloud.com/server/22/go.php?to=admin-ldap\"\n\t\ttarget=\"_blank\" rel=\"noreferrer noopener\">\n\t\t<img src=\"/nextcloud/core/img/actions/info.svg\"\n\t\t\tstyle=\"height:1.75ex\" />\n\t\t<span class=\"ldap_grey\">Aide</span>\n\t</a>\n</div>\n","ldap_host_default":""}]},{"file":"/var/www/nextcloud/lib/private/legacy/OC_Template.php","line":179,"function":"fetchPage","class":"OC\\Template\\Base","type":"->","args":[{"0":"And 54 more entries, set log level to debug to see all entries","serverConfigurationPrefixes":["","s01"],"serverConfigurationHosts":{"":"localhost"},"settingControls":"<div class=\"ldapSettingControls\">\n\t<button type=\"button\" class=\"ldap_action_test_connection\" name=\"ldap_action_test_connection\">\n\t\tTester la configuration\t</button>\n\t<a href=\"https://docs.nextcloud.com/server/22/go.php?to=admin-ldap\"\n\t\ttarget=\"_blank\" rel=\"noreferrer noopener\">\n\t\t<img src=\"/nextcloud/core/img/actions/info.svg\"\n\t\t\tstyle=\"height:1.75ex\" />\n\t\tAide\t</a>\n</div>\n","wizardControls":"<div class=\"ldapWizardControls\">\n\t<span class=\"ldap_saving hidden\">Enregistrement... <img class=\"wizSpinner\" src=\"/nextcloud/core/img/loading.gif\"/></span>\n\t<span class=\"ldap_config_state_indicator\"></span> <span class=\"ldap_config_state_indicator_sign\"></span>\n\t<button class=\"ldap_action_back invisible\" name=\"ldap_action_back\"\n\t\t\ttype=\"button\">\n\t\tRetour\t</button>\n\t<button class=\"ldap_action_continue primary\" name=\"ldap_action_continue\" type=\"button\">\n\t\tContinuer\t</button>\n\t<a href=\"https://docs.nextcloud.com/server/22/go.php?to=admin-ldap\"\n\t\ttarget=\"_blank\" rel=\"noreferrer noopener\">\n\t\t<img src=\"/nextcloud/core/img/actions/info.svg\"\n\t\t\tstyle=\"height:1.75ex\" />\n\t\t<span class=\"ldap_grey\">Aide</span>\n\t</a>\n</div>\n","ldap_host_default":""}]},{"file":"/var/www/nextcloud/lib/public/AppFramework/Http/TemplateResponse.php","line":204,"function":"fetchPage","class":"OC_Template","type":"->","args":[{"0":"And 54 more entries, set log level to debug to see all entries","serverConfigurationPrefixes":["","s01"],"serverConfigurationHosts":{"":"localhost"},"settingControls":"<div class=\"ldapSettingControls\">\n\t<button type=\"button\" class=\"ldap_action_test_connection\" name=\"ldap_action_test_connection\">\n\t\tTester la configuration\t</button>\n\t<a href=\"https://docs.nextcloud.com/server/22/go.php?to=admin-ldap\"\n\t\ttarget=\"_blank\" rel=\"noreferrer noopener\">\n\t\t<img src=\"/nextcloud/core/img/actions/info.svg\"\n\t\t\tstyle=\"height:1.75ex\" />\n\t\tAide\t</a>\n</div>\n","wizardControls":"<div class=\"ldapWizardControls\">\n\t<span class=\"ldap_saving hidden\">Enregistrement... <img class=\"wizSpinner\" src=\"/nextcloud/core/img/loading.gif\"/></span>\n\t<span class=\"ldap_config_state_indicator\"></span> <span class=\"ldap_config_state_indicator_sign\"></span>\n\t<button class=\"ldap_action_back invisible\" name=\"ldap_action_back\"\n\t\t\ttype=\"button\">\n\t\tRetour\t</button>\n\t<button class=\"ldap_action_continue primary\" name=\"ldap_action_continue\" type=\"button\">\n\t\tContinuer\t</button>\n\t<a href=\"https://docs.nextcloud.com/server/22/go.php?to=admin-ldap\"\n\t\ttarget=\"_blank\" rel=\"noreferrer noopener\">\n\t\t<img src=\"/nextcloud/core/img/actions/info.svg\"\n\t\t\tstyle=\"height:1.75ex\" />\n\t\t<span class=\"ldap_grey\">Aide</span>\n\t</a>\n</div>\n","ldap_host_default":""}]},{"file":"/var/www/nextcloud/apps/settings/lib/Controller/CommonSettingsTrait.php","line":138,"function":"render","class":"OCP\\AppFramework\\Http\\TemplateResponse","type":"->","args":[]},{"file":"/var/www/nextcloud/apps/settings/lib/Controller/AdminSettingsController.php","line":82,"function":"formatSettings","class":"OCA\\Settings\\Controller\\AdminSettingsController","type":"->","args":[{"5":[{"__class__":"OCA\\User_LDAP\\Settings\\Admin"}]}]},{"file":"/var/www/nextcloud/apps/settings/lib/Controller/CommonSettingsTrait.php","line":148,"function":"getSettings","class":"OCA\\Settings\\Controller\\AdminSettingsController","type":"->","args":["ldap"]},{"file":"/var/www/nextcloud/apps/settings/lib/Controller/AdminSettingsController.php","line":67,"function":"getIndexResponse","class":"OCA\\Settings\\Controller\\AdminSettingsController","type":"->","args":["admin","ldap"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":217,"function":"index","class":"OCA\\Settings\\Controller\\AdminSettingsController","type":"->","args":["ldap"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":126,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Settings\\Controller\\AdminSettingsController"},"index"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":156,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Settings\\Controller\\AdminSettingsController"},"index"]},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Settings\\Controller\\AdminSettingsController","index",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"section":"ldap","_route":"settings.AdminSettings.index"}]},{"file":"/var/www/nextcloud/lib/base.php","line":1006,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/settings/admin/ldap"]},{"file":"/var/www/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/nextcloud/lib/private/Log/ErrorHandler.php","Line":92,"CustomMessage":"--"},"id":"61d0586655e34"}

ou ceux_là

[index] Error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 18, 18, 18' at line 1

DELETE /nextcloud/apps/files_external/globalstorages/7
from 2a01:XXX:XX:XX:bXX:XXXX:XXXX:XXXX by nom__user at 2021-12-30T00:48:21+00:00

[index] Error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 10, 13, 16' at line 1

DELETE /nextcloud/apps/files_external/globalstorages/6
from 2a01:XXX:XX:XX:XX:XXXX:XXXX:XXXX by nom_user at 2021-12-30T00:48:16+00:00

rodinux · January 1, 2022, 2:50pm

Je me demande aussi si ce n’est pas un soucis avec les IPs ou les DNS, du fait que j’utilise un VPN avec VPN Client. Puisque la migration vient d’un serveur auto-hébergé sur un raspberry vers un VPS… Certaines erreurs ressemble à ceci: Can't contact LDAP server at /var/www/html/apps/user_ldap/lib/LDAP.php#336 - Nextcloud/Docker

Est-ce que aussi le fait que l’utilisateur avait du synchronisé des calendriers et contacts sur une boîte Thunderbird avec TBsync et Provider pour Caldav et CarDAV induit peut-être des erreurs suite à cette migration ???

Je cherche plusieurs pistes, pas évident car je vois différentes erreurs, des erreurs SQL ? d’authentification LDAP ? de Cron ? La synchronisation des Contacts avec Rainloop ?

jarod5001 · January 1, 2022, 3:22pm

Tu devrais commencer par lancer le test de sécurité proposé par nextcloud. Il peut te guider sur ce qui cloche

rodinux · January 1, 2022, 3:33pm

Le test de sécurité donne une note pas trop mauvaise un A vert. Le seul test qui est marqué une croix rouge:

__Host-Prefix

The __Host prefix mitigates cookie injection vulnerabilities within potential third-party software sharing the same second level domain. It is an additional hardening on top of ‘normal’ same-site cookies.

rodinux · January 1, 2022, 6:16pm

Bon, pour commencer, j’ai pu demander à l’utilisateur d’effacer ces anciennes synchronisations de calendriers et contacts (avec Thunderbird et phone iOS) puis de les réinstaller proprement… Du moins je crois que c’était un point à faire.
J’ai toujours ce message d’erreur de configuration serveur, là je cale…

rodinux · January 4, 2022, 10:28am

Ça s’est arrangé après avoir réinitialisé les synchronisations et au bout d’un moment (j’imagine pour que les crons s’accordent)…
Peut-être aussi le fait d’avoir désactivé la conexion VPN, mais je ne suis pas certain que ce soit la cause…

system · January 19, 2022, 10:29am

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.