Hallo,
seit Nextcloud 21 habe ich auf zwei Nextcloud-Instanzen (VM von hanssonit.se, und Univention Server 4.4) das Problem, dass ich in den “Einstellungen” - “Groupware” aus Versehen “Neue Einstellungen hinzufügen” angeklickt hatte.
Jetzt existieren diese Einstellungen, in der Nextcloud-Datenbank “oc_mail_accounts” sind jetzt 10 “tote” Einträge mit “domain.com”, teilweise auch von deaktivierten Benutzerkonten.
Klicke ich in den Nextcloud-Einstellungen auf den Schalter “Bereitstellung aufheben und Einstellungen löschen”, erhalte ich eine Fehlermeldung:
“Fehler beim Löschen und Aufheben der Bereitstellung von Konten für “*””
Auch inerhalb der Mail-App kann ich das Konto nicht löschen.
nextcloud.log:
{“reqId”:“DrFBMNTTYk7pUvqhnhOb”,“level”:3,“time”:“2021-09-15T14:35:12+00:00”,“remoteAddr”:“79.194.182.103”,“user”:“Administrator”,“app”:“index”,“method”:“DELETE”,“url”:“/nextcloud/apps/mail/api/settings/provisioning/1”,“message”:{“Exception”:“Doctrine\DBAL\Exception\DriverException”,“Message”:“An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 FEHLER: ung\u00fcltige Eingabesyntax f\u00fcr ganze Zahl: \u00bbt\u00ab”,“Code”:7,“Trace”:[{“file”:“/var/www/html/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1728,“function”:“convert”,“class”:“Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter”,“type”:“->”},{“file”:“/var/www/html/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1667,“function”:“handleDriverException”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”},{“file”:“/var/www/html/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1146,“function”:“convertExceptionDuringQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”},{“file”:“/var/www/html/lib/private/DB/Connection.php”,“line”:257,“function”:“executeStatement”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”},{“file”:“/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php”,“line”:213,“function”:“executeStatement”,“class”:“OC\DB\Connection”,“type”:“->”},{“file”:“/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php”,“line”:287,“function”:“execute”,“class”:“Doctrine\DBAL\Query\QueryBuilder”,“type”:“->”},{“file”:“/var/www/html/apps/mail/lib/Db/MailAccountMapper.php”,“line”:140,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:“->”},{“file”:“/var/www/html/apps/mail/lib/Service/Provisioning/Manager.php”,“line”:185,“function”:“deleteProvisionedAccounts”,“class”:“OCA\Mail\Db\MailAccountMapper”,“type”:“->”},{“file”:“/var/www/html/apps/mail/lib/Controller/SettingsController.php”,“line”:85,“function”:“deprovision”,“class”:“OCA\Mail\Service\Provisioning\Manager”,“type”:“->”},{“file”:“/var/www/html/lib/private/AppFramework/Http/Dispatcher.php”,“line”:218,“function”:“deprovision”,“class”:“OCA\Mail\Controller\SettingsController”,“type”:“->”},{“file”:“/var/www/html/lib/private/AppFramework/Http/Dispatcher.php”,“line”:127,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:“->”},{“file”:“/var/www/html/lib/private/AppFramework/App.php”,“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:“->”},{“file”:“/var/www/html/lib/private/Route/Router.php”,“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:“::”},{“file”:“/var/www/html/lib/base.php”,“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:“->”},{“file”:“/var/www/html/index.php”,“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:“::”}],“File”:“/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php”,“Line”:83,“Previous”:{“Exception”:“Doctrine\DBAL\Driver\PDO\Exception”,“Message”:“SQLSTATE[22P02]: Invalid text representation: 7 FEHLER: ung\u00fcltige Eingabesyntax f\u00fcr ganze Zahl: \u00bbt\u00ab”,“Code”:7,“Trace”:[{“file”:“/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php”,“line”:84,“function”:“new”,“class”:“Doctrine\DBAL\Driver\PDO\Exception”,“type”:“::”},{“file”:“/var/www/html/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1136,“function”:“execute”,“class”:“Doctrine\DBAL\Driver\PDO\Statement”,“type”:“->”},{“file”:“/var/www/html/lib/private/DB/Connection.php”,“line”:257,“function”:“executeStatement”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”},{“file”:“/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php”,“line”:213,“function”:“executeStatement”,“class”:“OC\DB\Connection”,“type”:“->”},{“file”:“/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php”,“line”:287,“function”:“execute”,“class”:“Doctrine\DBAL\Query\QueryBuilder”,“type”:“->”},{“file”:“/var/www/html/apps/mail/lib/Db/MailAccountMapper.php”,“line”:140,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:“->”},{“file”:“/var/www/html/apps/mail/lib/Service/Provisioning/Manager.php”,“line”:185,“function”:“deleteProvisionedAccounts”,“class”:“OCA\Mail\Db\MailAccountMapper”,“type”:“->”},{“file”:“/var/www/html/apps/mail/lib/Controller/SettingsController.php”,“line”:85,“function”:“deprovision”,“class”:“OCA\Mail\Service\Provisioning\Manager”,“type”:“->”},{“file”:“/var/www/html/lib/private/AppFramework/Http/Dispatcher.php”,“line”:218,“function”:“deprovision”,“class”:“OCA\Mail\Controller\SettingsController”,“type”:“->”},{“file”:“/var/www/html/lib/private/AppFramework/Http/Dispatcher.php”,“line”:127,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:“->”},{“file”:“/var/www/html/lib/private/AppFramework/App.php”,“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:“->”},{“file”:“/var/www/html/lib/private/Route/Router.php”,“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:“::”},{“file”:“/var/www/html/lib/base.php”,“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:“->”},{“file”:“/var/www/html/index.php”,“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:“::”}],“File”:“/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php”,“Line”:26,“Previous”:{“Exception”:“PDOException”,“Message”:“SQLSTATE[22P02]: Invalid text representation: 7 FEHLER: ung\u00fcltige Eingabesyntax f\u00fcr ganze Zahl: \u00bbt\u00ab”,“Code”:“22P02”,“Trace”:[{“file”:“/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php”,“line”:82,“function”:“execute”,“class”:“PDOStatement”,“type”:“->”},{“file”:“/var/www/html/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1136,“function”:“execute”,“class”:“Doctrine\DBAL\Driver\PDO\Statement”,“type”:“->”},{“file”:“/var/www/html/lib/private/DB/Connection.php”,“line”:257,“function”:“executeStatement”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”},{“file”:“/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php”,“line”:213,“function”:“executeStatement”,“class”:“OC\DB\Connection”,“type”:“->”},{“file”:“/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php”,“line”:287,“function”:“execute”,“class”:“Doctrine\DBAL\Query\QueryBuilder”,“type”:“->”},{“file”:“/var/www/html/apps/mail/lib/Db/MailAccountMapper.php”,“line”:140,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:“->”},{“file”:“/var/www/html/apps/mail/lib/Service/Provisioning/Manager.php”,“line”:185,“function”:“deleteProvisionedAccounts”,“class”:“OCA\Mail\Db\MailAccountMapper”,“type”:“->”},{“file”:“/var/www/html/apps/mail/lib/Controller/SettingsController.php”,“line”:85,“function”:“deprovision”,“class”:“OCA\Mail\Service\Provisioning\Manager”,“type”:“->”},{“file”:“/var/www/html/lib/private/AppFramework/Http/Dispatcher.php”,“line”:218,“function”:“deprovision”,“class”:“OCA\Mail\Controller\SettingsController”,“type”:“->”},{“file”:“/var/www/html/lib/private/AppFramework/Http/Dispatcher.php”,“line”:127,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:“->”},{“file”:“/var/www/html/lib/private/AppFramework/App.php”,“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:“->”},{“file”:“/var/www/html/lib/private/Route/Router.php”,“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:“::”},{“file”:“/var/www/html/lib/base.php”,“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:“->”},{“file”:“/var/www/html/index.php”,“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:“::”}],“File”:“/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php”,“Line”:82}},“CustomMessage”:“–”},“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:92.0) Gecko/20100101 Firefox/92.0”,“version”:“21.0.4.1”}
Zum System:
Univention Corporate Server 4.4.8
- Debian GNU/Linux 9 (stretch)
- PostgreSQL 9.6.23
- Apache 2.4
- PHP 7.0.33-0+deb9u11
- Nextcloud 21.0.4
- 8GB RAM
in einer Virtual Box-Umgebung unter Windows 10
Das zweite System mit dem gleichen Problem:
- Ubuntu Server 20.04 LTS 64-bit
- Apache 2.4
- PostgreSQL 12
- PHP-FPM 7.4
- Linux Kernel: 5.4
- Nextcloud 22.1.1
- 16GB RAM
vor-konfigurierte VM von hanssonit.se
in einer VM-Ware ESXi-Umgebung
Meine Fragen:
- Wie kann ich die 10 “toten” Mailaccounts los werden - die nextcloud.log läuft permanent mit Fehlermeldungen voll.
- Kann ich alternativ die 10 “toten” Accounts mit “@domain.com” einfach in der Nextcloud-Datenbank “oc_mail_accounts” löschen?
- Wie kann ich die Bereitstellung aufheben? - Löschen der Mail-App ist genauso unwirksam, wie Löschpapier bei einem Feuer - bringt nix, denn nach einer Neuinstallation ist das Problem wieder da.