Guten Tag,
Ich habe die Tage einen den IP Adressbereich meines Netzwerkes geändert und ab da Konnte mich nicht mehr in meine Nextcloud Einloggen. Nach der Eingabe von Benutzername und Passwort kommt immer die Meldung Interner Serverfehler. Die IP Adressen wurden in der config.php angepasst. ich setzte 2FA ein und einen Yubikey zum anmelden, der geht auch nicht mehr. Nach dem wechsel auf den alten IP Adressbereich und dem einspielen eines Backups wirft die Nextcloud immer noch einen Internen Serverfehler.
- Bei welchen Anbieter? Was für ein Server? v-server, shared, root, usw. Oder Lokal?
Lokal
- Auf welcher Hardware? PC, Raspberry PI, Banana, NAS usw…
as rock rack C2750D4I Mainboard mit Intel Atom 8 Kern CPU und 32 GB RAM
- Betriebssystem sowie Version ALLER beteiligten Systeme
Proxmox 6.4-13
Debian 10.10
- Nextcloud Version?
22.0.0
- PHP Version?
7.4.21
- Welche Datenbank? MySql,Engine X (Nginx),MariaDB usw…
MariaDB
- Apache version, usw.
weis ich nicht
- Läuft NC in Docker,Snap oder VM
Docker 20.10.7
- Netzwerk Aufgliederung: zb. Router>Switch>PI>
Router>Switch>Server
- Wurden vor kurzen Server Updates gemacht? Wenn ja von was?
Nein
- Habt ihr die Logs angesehen von Nextcloud und von System?
{
"reqId": "wteVbE7FWim9YZIaHMAx",
"level": 3,
"time": "2021-07-21T08:04:08+00:00",
"remoteAddr": "79.238.92.223",
"user": "NakashiUGS",
"app": "index",
"method": "POST",
"url": "/login",
"message": "An exception occurred while executing a query: SQLSTATE[HY000]: General error: 4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.",
"userAgent": "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:90.0) Gecko/20100101 Firefox/90.0",
"version": "22.0.0.11",
"exception": {
"Exception": "Doctrine\\DBAL\\Exception\\DriverException",
"Message": "An exception occurred while executing a query: SQLSTATE[HY000]: General error: 4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.",
"Code": 4047,
"Trace": [
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1728,
"function": "convert",
"class": "Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter",
"type": "->",
"args": [
{
"__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception"
},
{
"__class__": "Doctrine\\DBAL\\Query"
}
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1667,
"function": "handleDriverException",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
{
"__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception"
},
{
"__class__": "Doctrine\\DBAL\\Query"
}
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1146,
"function": "convertExceptionDuringQuery",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
{
"__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception"
},
"UPDATE `oc_preferences` SET `configvalue` = ? WHERE (`userid` = ?) AND (`appid` = ?) AND (`configkey` = ?)",
[
1626854648,
"*** sensitive parameter replaced ***",
"login",
"lastLogin"
],
[
2,
2,
2,
2
]
]
},
{
"file": "/var/www/html/lib/private/DB/Connection.php",
"line": 262,
"function": "executeStatement",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
"UPDATE `oc_preferences` SET `configvalue` = ? WHERE (`userid` = ?) AND (`appid` = ?) AND (`configkey` = ?)",
[
1626854648,
"*** sensitive parameter replaced ***",
"login",
"lastLogin"
],
[
2,
2,
2,
2
]
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
"line": 213,
"function": "executeStatement",
"class": "OC\\DB\\Connection",
"type": "->",
"args": [
"UPDATE `oc_preferences` SET `configvalue` = :dcValue1 WHERE (`userid` = :dcValue2) AND (`appid` = :dcValue3) AND (`configkey` = :dcValue4)",
{
"dcValue1": 1626854648,
"dcValue2": "*** sensitive parameter replaced ***",
"dcValue3": "login",
"dcValue4": "lastLogin"
},
{
"dcValue1": 2,
"dcValue2": 2,
"dcValue3": 2,
"dcValue4": 2
}
]
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 287,
"function": "execute",
"class": "Doctrine\\DBAL\\Query\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/private/AllConfig.php",
"line": 277,
"function": "execute",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/private/User/User.php",
"line": 203,
"function": "setUserValue",
"class": "OC\\AllConfig",
"type": "->",
"args": [
"*** sensitive parameter replaced ***",
"login",
"lastLogin",
1626854648
]
},
{
"file": "/var/www/html/lib/private/User/Session.php",
"line": 398,
"function": "updateLastLoginTimestamp",
"class": "OC\\User\\User",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/Authentication/Login/CompleteLoginCommand.php",
"line": 44,
"function": "completeLogin",
"class": "OC\\User\\Session",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/Authentication/Login/ALoginCommand.php",
"line": 40,
"function": "process",
"class": "OC\\Authentication\\Login\\CompleteLoginCommand",
"type": "->",
"args": [
{
"__class__": "OC\\Authentication\\Login\\LoginData"
}
]
},
{
"file": "/var/www/html/lib/private/Authentication/Login/LoggedInCheckCommand.php",
"line": 60,
"function": "processNextOrFinishSuccessfully",
"class": "OC\\Authentication\\Login\\ALoginCommand",
"type": "->",
"args": [
{
"__class__": "OC\\Authentication\\Login\\LoginData"
}
]
},
{
"file": "/var/www/html/lib/private/Authentication/Login/ALoginCommand.php",
"line": 40,
"function": "process",
"class": "OC\\Authentication\\Login\\LoggedInCheckCommand",
"type": "->",
"args": [
{
"__class__": "OC\\Authentication\\Login\\LoginData"
}
]
},
{
"file": "/var/www/html/lib/private/Authentication/Login/EmailLoginCommand.php",
"line": 58,
"function": "processNextOrFinishSuccessfully",
"class": "OC\\Authentication\\Login\\ALoginCommand",
"type": "->",
"args": [
{
"__class__": "OC\\Authentication\\Login\\LoginData"
}
]
},
{
"file": "/var/www/html/lib/private/Authentication/Login/ALoginCommand.php",
"line": 40,
"function": "process",
"class": "OC\\Authentication\\Login\\EmailLoginCommand",
"type": "->",
"args": [
{
"__class__": "OC\\Authentication\\Login\\LoginData"
}
]
},
{
"file": "/var/www/html/lib/private/Authentication/Login/UidLoginCommand.php",
"line": 54,
"function": "processNextOrFinishSuccessfully",
"class": "OC\\Authentication\\Login\\ALoginCommand",
"type": "->",
"args": [
{
"__class__": "OC\\Authentication\\Login\\LoginData"
}
]
},
{
"file": "/var/www/html/lib/private/Authentication/Login/ALoginCommand.php",
"line": 40,
"function": "process",
"class": "OC\\Authentication\\Login\\UidLoginCommand",
"type": "->",
"args": [
{
"__class__": "OC\\Authentication\\Login\\LoginData"
}
]
},
{
"file": "/var/www/html/lib/private/Authentication/Login/UserDisabledCheckCommand.php",
"line": 58,
"function": "processNextOrFinishSuccessfully",
"class": "OC\\Authentication\\Login\\ALoginCommand",
"type": "->",
"args": [
{
"__class__": "OC\\Authentication\\Login\\LoginData"
}
]
},
{
"file": "/var/www/html/lib/private/Authentication/Login/ALoginCommand.php",
"line": 40,
"function": "process",
"class": "OC\\Authentication\\Login\\UserDisabledCheckCommand",
"type": "->",
"args": [
{
"__class__": "OC\\Authentication\\Login\\LoginData"
}
]
},
{
"file": "/var/www/html/lib/private/Authentication/Login/PreLoginHookCommand.php",
"line": 53,
"function": "processNextOrFinishSuccessfully",
"class": "OC\\Authentication\\Login\\ALoginCommand",
"type": "->",
"args": [
{
"__class__": "OC\\Authentication\\Login\\LoginData"
}
]
},
{
"file": "/var/www/html/lib/private/Authentication/Login/Chain.php",
"line": 108,
"function": "process",
"class": "OC\\Authentication\\Login\\PreLoginHookCommand",
"type": "->",
"args": [
{
"__class__": "OC\\Authentication\\Login\\LoginData"
}
]
},
{
"file": "/var/www/html/core/Controller/LoginController.php",
"line": 314,
"function": "process",
"class": "OC\\Authentication\\Login\\Chain",
"type": "->",
"args": [
{
"__class__": "OC\\Authentication\\Login\\LoginData"
}
]
},
{
"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line": 217,
"function": "tryLogin",
"class": "OC\\Core\\Controller\\LoginController",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line": 126,
"function": "executeController",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
{
"__class__": "OC\\Core\\Controller\\LoginController"
},
"tryLogin"
]
},
{
"file": "/var/www/html/lib/private/AppFramework/App.php",
"line": 156,
"function": "dispatch",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
{
"__class__": "OC\\Core\\Controller\\LoginController"
},
"tryLogin"
]
},
{
"file": "/var/www/html/lib/private/Route/Router.php",
"line": 301,
"function": "main",
"class": "OC\\AppFramework\\App",
"type": "::",
"args": [
"OC\\Core\\Controller\\LoginController",
"tryLogin",
{
"__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer"
},
{
"_route": "core.login.tryLogin"
}
]
},
{
"file": "/var/www/html/lib/base.php",
"line": 1000,
"function": "match",
"class": "OC\\Route\\Router",
"type": "->",
"args": [
"/login"
]
},
{
"file": "/var/www/html/index.php",
"line": 36,
"function": "handleRequest",
"class": "OC",
"type": "::",
"args": []
}
],
"File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php",
"Line": 114,
"Previous": {
"Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
"Message": "SQLSTATE[HY000]: General error: 4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.",
"Code": 4047,
"Trace": [
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
"line": 84,
"function": "new",
"class": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
"type": "::",
"args": [
{
"errorInfo": [
"HY000",
4047,
"InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE."
],
"__class__": "PDOException"
}
]
},
- Bei was für einer Aktion ist der Fehler aufgetreten?
Ändern des IP Adressbereichs von 192.168.200.x auf 192.168.100.x