joshtrichards
commented
2 months ago I don't see the user getting created successfully (even on 25), but we should be handling this better. Currently we're letting the db query fail (data too long for the column) which not only generates an exception on the backend, but (worse) a An error occurred during the request. Unable to proceed. Bad request pop-up in the front-end.
{
"reqId": "hK3172T1eAOenHNyW9kE",
"level": 3,
"time": "2024-08-21T20:13:29+00:00",
"remoteAddr": "192.168.88.67",
"user": "ncadmin",
"app": "ocs_api",
"method": "POST",
"url": "/ocs/v2.php/cloud/users",
"message": "Failed addUser attempt with exception.",
"userAgent": "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0",
"version": "28.0.8.1",
"exception": {
"Exception": "OC\\DB\\Exceptions\\DbalException",
"Message": "An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'uid' at row 1",
"Code": 1406,
"Trace": [
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 328,
"function": "wrap",
"class": "OC\\DB\\Exceptions\\DbalException",
"type": "::",
"args": [
[
"Doctrine\\DBAL\\Exception\\DriverException"
]
]
},
{
"file": "/var/www/html/lib/private/User/Database.php",
"line": 137,
"function": "executeStatement",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/public/AppFramework/Db/TTransactional.php",
"line": 63,
"function": "OC\\User\\{closure}",
"class": "OC\\User\\Database",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/User/Database.php",
"line": 128,
"function": "atomic",
"class": "OC\\User\\Database",
"type": "->",
"args": [
[
"Closure"
],
[
"OC\\DB\\ConnectionAdapter"
]
]
},
{
"file": "/var/www/html/lib/private/User/Manager.php",
"line": 474,
"function": "createUser",
"class": "OC\\User\\Database",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/User/Manager.php",
"line": 442,
"function": "createUserFromBackend",
"class": "OC\\User\\Manager",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/provisioning_api/lib/Controller/UsersController.php",
"line": 523,
"function": "createUser",
"class": "OC\\User\\Manager",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line": 230,
"function": "addUser",
"class": "OCA\\Provisioning_API\\Controller\\UsersController",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line": 137,
"function": "executeController",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
[
"OCA\\Provisioning_API\\Controller\\UsersController"
],
"addUser"
]
},
{
"file": "/var/www/html/lib/private/AppFramework/App.php",
"line": 184,
"function": "dispatch",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
[
"OCA\\Provisioning_API\\Controller\\UsersController"
],
"addUser"
]
},
{
"file": "/var/www/html/lib/private/Route/Router.php",
"line": 315,
"function": "main",
"class": "OC\\AppFramework\\App",
"type": "::",
"args": [
"OCA\\Provisioning_API\\Controller\\UsersController",
"addUser",
[
"OC\\AppFramework\\DependencyInjection\\DIContainer"
],
[
"ocs.provisioning_api.Users.addUser"
]
]
},
{
"file": "/var/www/html/ocs/v1.php",
"line": 65,
"function": "match",
"class": "OC\\Route\\Router",
"type": "->",
"args": [
"/ocsapp/cloud/users"
]
},
{
"file": "/var/www/html/ocs/v2.php",
"line": 23,
"args": [
"/var/www/html/ocs/v1.php"
],
"function": "require_once"
}
],
"File": "/var/www/html/lib/private/DB/Exceptions/DbalException.php",
"Line": 71,
"Previous": {
"Exception": "Doctrine\\DBAL\\Exception\\DriverException",
"Message": "An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'uid' at row 1",
"Code": 1406,
"Trace": [
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1938,
"function": "convert",
"class": "Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter",
"type": "->",
"args": [
[
"Doctrine\\DBAL\\Driver\\PDO\\Exception"
],
[
"Doctrine\\DBAL\\Query"
]
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1880,
"function": "handleDriverException",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
[
"Doctrine\\DBAL\\Driver\\PDO\\Exception"
],
[
"Doctrine\\DBAL\\Query"
]
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1208,
"function": "convertExceptionDuringQuery",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
[
"Doctrine\\DBAL\\Driver\\PDO\\Exception"
],
"INSERT INTO `oc_users` (`uid`, `password`, `uid_lower`) VALUES(?, ?, ?)",
[
"*** sensitive parameters replaced ***",
"3|$argon2id$v=19$m=65536,t=4,p=1$LklwcXRqdWg1SjZ6azhYdQ$Z3nFZ9zhFzIK7eSUqYnRMOn07DaXUc5hbvsQB5Fb6ME",
"liwgombldbwufk8xq7021nbnyxhd53kf48nfi2yom4kmaumz5kp6sqiua8tad9u1j"
],
[
2,
2,
2
]
]
},
{
"file": "/var/www/html/lib/private/DB/Connection.php",
"line": 297,
"function": "executeStatement",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
"INSERT INTO `oc_users` (`uid`, `password`, `uid_lower`) VALUES(?, ?, ?)",
[
"*** sensitive parameters replaced ***",
"3|$argon2id$v=19$m=65536,t=4,p=1$LklwcXRqdWg1SjZ6azhYdQ$Z3nFZ9zhFzIK7eSUqYnRMOn07DaXUc5hbvsQB5Fb6ME",
"liwgombldbwufk8xq7021nbnyxhd53kf48nfi2yom4kmaumz5kp6sqiua8tad9u1j"
],
[
2,
2,
2
]
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
"line": 386,
"function": "executeStatement",
"class": "OC\\DB\\Connection",
"type": "->",
"args": [
"INSERT INTO `oc_users` (`uid`, `password`, `uid_lower`) VALUES(:dcValue1, :dcValue2, :dcValue3)",
[
"*** sensitive parameters replaced ***",
"3|$argon2id$v=19$m=65536,t=4,p=1$LklwcXRqdWg1SjZ6azhYdQ$Z3nFZ9zhFzIK7eSUqYnRMOn07DaXUc5hbvsQB5Fb6ME",
"liwgombldbwufk8xq7021nbnyxhd53kf48nfi2yom4kmaumz5kp6sqiua8tad9u1j"
],
[
2,
2,
2
]
]
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 280,
"function": "execute",
"class": "Doctrine\\DBAL\\Query\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 326,
"function": "execute",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/private/User/Database.php",
"line": 137,
"function": "executeStatement",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/public/AppFramework/Db/TTransactional.php",
"line": 63,
"function": "OC\\User\\{closure}",
"class": "OC\\User\\Database",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/User/Database.php",
"line": 128,
"function": "atomic",
"class": "OC\\User\\Database",
"type": "->",
"args": [
[
"Closure"
],
[
"OC\\DB\\ConnectionAdapter"
]
]
},
{
"file": "/var/www/html/lib/private/User/Manager.php",
"line": 474,
"function": "createUser",
"class": "OC\\User\\Database",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/User/Manager.php",
"line": 442,
"function": "createUserFromBackend",
"class": "OC\\User\\Manager",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/provisioning_api/lib/Controller/UsersController.php",
"line": 523,
"function": "createUser",
"class": "OC\\User\\Manager",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line": 230,
"function": "addUser",
"class": "OCA\\Provisioning_API\\Controller\\UsersController",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line": 137,
"function": "executeController",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
[
"OCA\\Provisioning_API\\Controller\\UsersController"
],
"addUser"
]
},
{
"file": "/var/www/html/lib/private/AppFramework/App.php",
"line": 184,
"function": "dispatch",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
[
"OCA\\Provisioning_API\\Controller\\UsersController"
],
"addUser"
]
},
{
"file": "/var/www/html/lib/private/Route/Router.php",
"line": 315,
"function": "main",
"class": "OC\\AppFramework\\App",
"type": "::",
"args": [
"OCA\\Provisioning_API\\Controller\\UsersController",
"addUser",
[
"OC\\AppFramework\\DependencyInjection\\DIContainer"
],
[
"ocs.provisioning_api.Users.addUser"
]
]
},
{
"file": "/var/www/html/ocs/v1.php",
"line": 65,
"function": "match",
"class": "OC\\Route\\Router",
"type": "->",
"args": [
"/ocsapp/cloud/users"
]
},
{
"file": "/var/www/html/ocs/v2.php",
"line": 23,
"args": [
"/var/www/html/ocs/v1.php"
],
"function": "require_once"
}
],
"File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php",
"Line": 117,
"Previous": {
"Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
"Message": "SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'uid' at row 1",
"Code": 1406,
"Trace": [
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
"line": 132,
"function": "new",
"class": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
"type": "::",
"args": [
[
"PDOException",
[
"22001",
1406,
"Data too long for column 'uid' at row 1"
]
]
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1202,
"function": "execute",
"class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/private/DB/Connection.php",
"line": 297,
"function": "executeStatement",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
"INSERT INTO `oc_users` (`uid`, `password`, `uid_lower`) VALUES(?, ?, ?)",
[
"*** sensitive parameters replaced ***",
"3|$argon2id$v=19$m=65536,t=4,p=1$LklwcXRqdWg1SjZ6azhYdQ$Z3nFZ9zhFzIK7eSUqYnRMOn07DaXUc5hbvsQB5Fb6ME",
"liwgombldbwufk8xq7021nbnyxhd53kf48nfi2yom4kmaumz5kp6sqiua8tad9u1j"
],
[
2,
2,
2
]
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
"line": 386,
"function": "executeStatement",
"class": "OC\\DB\\Connection",
"type": "->",
"args": [
"INSERT INTO `oc_users` (`uid`, `password`, `uid_lower`) VALUES(:dcValue1, :dcValue2, :dcValue3)",
[
"*** sensitive parameters replaced ***",
"3|$argon2id$v=19$m=65536,t=4,p=1$LklwcXRqdWg1SjZ6azhYdQ$Z3nFZ9zhFzIK7eSUqYnRMOn07DaXUc5hbvsQB5Fb6ME",
"liwgombldbwufk8xq7021nbnyxhd53kf48nfi2yom4kmaumz5kp6sqiua8tad9u1j"
],
[
2,
2,
2
]
]
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 280,
"function": "execute",
"class": "Doctrine\\DBAL\\Query\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 326,
"function": "execute",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/private/User/Database.php",
"line": 137,
"function": "executeStatement",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/public/AppFramework/Db/TTransactional.php",
"line": 63,
"function": "OC\\User\\{closure}",
"class": "OC\\User\\Database",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/User/Database.php",
"line": 128,
"function": "atomic",
"class": "OC\\User\\Database",
"type": "->",
"args": [
[
"Closure"
],
[
"OC\\DB\\ConnectionAdapter"
]
]
},
{
"file": "/var/www/html/lib/private/User/Manager.php",
"line": 474,
"function": "createUser",
"class": "OC\\User\\Database",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/User/Manager.php",
"line": 442,
"function": "createUserFromBackend",
"class": "OC\\User\\Manager",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/provisioning_api/lib/Controller/UsersController.php",
"line": 523,
"function": "createUser",
"class": "OC\\User\\Manager",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line": 230,
"function": "addUser",
"class": "OCA\\Provisioning_API\\Controller\\UsersController",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line": 137,
"function": "executeController",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
[
"OCA\\Provisioning_API\\Controller\\UsersController"
],
"addUser"
]
},
{
"file": "/var/www/html/lib/private/AppFramework/App.php",
"line": 184,
"function": "dispatch",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
[
"OCA\\Provisioning_API\\Controller\\UsersController"
],
"addUser"
]
},
{
"file": "/var/www/html/lib/private/Route/Router.php",
"line": 315,
"function": "main",
"class": "OC\\AppFramework\\App",
"type": "::",
"args": [
"OCA\\Provisioning_API\\Controller\\UsersController",
"addUser",
[
"OC\\AppFramework\\DependencyInjection\\DIContainer"
],
[
"ocs.provisioning_api.Users.addUser"
]
]
},
{
"file": "/var/www/html/ocs/v1.php",
"line": 65,
"function": "match",
"class": "OC\\Route\\Router",
"type": "->",
"args": [
"/ocsapp/cloud/users"
]
},
{
"file": "/var/www/html/ocs/v2.php",
"line": 23,
"args": [
"/var/www/html/ocs/v1.php"
],
"function": "require_once"
}
],
"File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",
"Line": 28,
"Previous": {
"Exception": "PDOException",
"Message": "SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'uid' at row 1",
"Code": "22001",
"Trace": [
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
"line": 130,
"function": "execute",
"class": "PDOStatement",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1202,
"function": "execute",
"class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/private/DB/Connection.php",
"line": 297,
"function": "executeStatement",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
"INSERT INTO `oc_users` (`uid`, `password`, `uid_lower`) VALUES(?, ?, ?)",
[
"*** sensitive parameters replaced ***",
"3|$argon2id$v=19$m=65536,t=4,p=1$LklwcXRqdWg1SjZ6azhYdQ$Z3nFZ9zhFzIK7eSUqYnRMOn07DaXUc5hbvsQB5Fb6ME",
"liwgombldbwufk8xq7021nbnyxhd53kf48nfi2yom4kmaumz5kp6sqiua8tad9u1j"
],
[
2,
2,
2
]
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
"line": 386,
"function": "executeStatement",
"class": "OC\\DB\\Connection",
"type": "->",
"args": [
"INSERT INTO `oc_users` (`uid`, `password`, `uid_lower`) VALUES(:dcValue1, :dcValue2, :dcValue3)",
[
"*** sensitive parameters replaced ***",
"3|$argon2id$v=19$m=65536,t=4,p=1$LklwcXRqdWg1SjZ6azhYdQ$Z3nFZ9zhFzIK7eSUqYnRMOn07DaXUc5hbvsQB5Fb6ME",
"liwgombldbwufk8xq7021nbnyxhd53kf48nfi2yom4kmaumz5kp6sqiua8tad9u1j"
],
[
2,
2,
2
]
]
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 280,
"function": "execute",
"class": "Doctrine\\DBAL\\Query\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 326,
"function": "execute",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/private/User/Database.php",
"line": 137,
"function": "executeStatement",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/lib/public/AppFramework/Db/TTransactional.php",
"line": 63,
"function": "OC\\User\\{closure}",
"class": "OC\\User\\Database",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/User/Database.php",
"line": 128,
"function": "atomic",
"class": "OC\\User\\Database",
"type": "->",
"args": [
[
"Closure"
],
[
"OC\\DB\\ConnectionAdapter"
]
]
},
{
"file": "/var/www/html/lib/private/User/Manager.php",
"line": 474,
"function": "createUser",
"class": "OC\\User\\Database",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/User/Manager.php",
"line": 442,
"function": "createUserFromBackend",
"class": "OC\\User\\Manager",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/apps/provisioning_api/lib/Controller/UsersController.php",
"line": 523,
"function": "createUser",
"class": "OC\\User\\Manager",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line": 230,
"function": "addUser",
"class": "OCA\\Provisioning_API\\Controller\\UsersController",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line": 137,
"function": "executeController",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
[
"OCA\\Provisioning_API\\Controller\\UsersController"
],
"addUser"
]
},
{
"file": "/var/www/html/lib/private/AppFramework/App.php",
"line": 184,
"function": "dispatch",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
[
"OCA\\Provisioning_API\\Controller\\UsersController"
],
"addUser"
]
},
{
"file": "/var/www/html/lib/private/Route/Router.php",
"line": 315,
"function": "main",
"class": "OC\\AppFramework\\App",
"type": "::",
"args": [
"OCA\\Provisioning_API\\Controller\\UsersController",
"addUser",
[
"OC\\AppFramework\\DependencyInjection\\DIContainer"
],
[
"ocs.provisioning_api.Users.addUser"
]
]
},
{
"file": "/var/www/html/ocs/v1.php",
"line": 65,
"function": "match",
"class": "OC\\Route\\Router",
"type": "->",
"args": [
"/ocsapp/cloud/users"
]
},
{
"file": "/var/www/html/ocs/v2.php",
"line": 23,
"args": [
"/var/www/html/ocs/v1.php"
],
"function": "require_once"
}
],
"File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
"Line": 130
}
}
},
"message": "Failed addUser attempt with exception.",
"exception": {},
"CustomMessage": "Failed addUser attempt with exception."
}
}
⚠️ This issue respects the following points: ⚠️
Bug description
[Add new user] The system reported an error, the account was still created successfully
Steps to reproduce
Expected behavior
Add new user failed
Installation method
Community Manual installation with Archive
Nextcloud Server version
25
Operating system
Debian/Ubuntu
PHP engine version
PHP 8.1
Web server
Apache (supported)
Database engine version
MariaDB
Is this bug present after an update or on a fresh install?
Fresh Nextcloud Server install
Are you using the Nextcloud Server Encryption module?
Encryption is Disabled
What user-backends are you using?
Configuration report
List of activated Apps
Nextcloud Signing status
No response
Nextcloud Logs
No response
Additional info
No response