Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

connecting with an invalid token results in a SQL exception #127

Open
individual-it opened this issue Apr 13, 2018 · 0 comments
Open

connecting with an invalid token results in a SQL exception #127

individual-it opened this issue Apr 13, 2018 · 0 comments
Labels

Comments

@individual-it
Copy link
Member

individual-it commented Apr 13, 2018

  1. connect with the desktop app via oauth
  2. delete the authorized application in Settings=>Security
  3. resync with the desktop app

everything works fine for the user but there is an SQL exception loged

{"reqId":"2df63cea-2281-4531-a3b2-d1bcc62f08fb","level":3,"time":"2018-04-13T10:55:58+00:00","remoteAddr":"127.0.0.1","user":"--","app":"OCA\\OAuth2\\Controller\\OAuthApiController","method":"POST","url":"\/owncloud-10.0.8RC\/owncloud\/index.php\/apps\/oauth2\/api\/v1\/token","message":"Exception: {\"Exception\":\"OCP\\\\AppFramework\\\\Db\\\\DoesNotExistException\",\"Message\":\"Did expect one result but found none when executing: query \\\"SELECT * FROM `*PREFIX*oauth2_refresh_tokens` WHERE `token` = ?\\\"; parameters Array\\n(\\n    [0] => aTvtNSoJNjJMIvHIk2834akjm9FvIfLAp4APzZIXwzkinSLd88iDxQiGpPbWTdSk\\n)\\n; limit \\\"\\\"; offset \\\"\\\"\",\"Code\":0,\"Trace\":\"#0 \\\/home\\\/artur\\\/www\\\/owncloud-10.0.8RC\\\/owncloud\\\/lib\\\/public\\\/AppFramework\\\/Db\\\/Mapper.php(379): OCP\\\\AppFramework\\\\Db\\\\Mapper->findOneQuery('SELECT * FROM `...', Array, NULL, NULL)\\n#1 \\\/home\\\/artur\\\/www\\\/owncloud-10.0.8RC\\\/owncloud\\\/apps\\\/oauth2\\\/lib\\\/Db\\\/RefreshTokenMapper.php(75): OCP\\\\AppFramework\\\\Db\\\\Mapper->findEntity('SELECT * FROM `...', Array, NULL, NULL)\\n#2 \\\/home\\\/artur\\\/www\\\/owncloud-10.0.8RC\\\/owncloud\\\/apps\\\/oauth2\\\/lib\\\/Controller\\\/OAuthApiController.php(165): OCA\\\\OAuth2\\\\Db\\\\RefreshTokenMapper->findByToken('aTvtNSoJNjJMIvH...')\\n#3 [internal function]: OCA\\\\OAuth2\\\\Controller\\\\OAuthApiController->generateToken(*** sensitive parameters replaced ***)\\n#4 \\\/home\\\/artur\\\/www\\\/owncloud-10.0.8RC\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(159): call_user_func_array(Array, Array)\\n#5 \\\/home\\\/artur\\\/www\\\/owncloud-10.0.8RC\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(89): OC\\\\AppFramework\\\\Http\\\\Dispatcher->executeController(Object(OCA\\\\OAuth2\\\\Controller\\\\OAuthApiController), 'generateToken')\\n#6 \\\/home\\\/artur\\\/www\\\/owncloud-10.0.8RC\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/App.php(103): OC\\\\AppFramework\\\\Http\\\\Dispatcher->dispatch(Object(OCA\\\\OAuth2\\\\Controller\\\\OAuthApiController), 'generateToken')\\n#7 \\\/home\\\/artur\\\/www\\\/owncloud-10.0.8RC\\\/owncloud\\\/lib\\\/private\\\/AppFramework\\\/Routing\\\/RouteActionHandler.php(46): OC\\\\AppFramework\\\\App::main('OCA\\\\\\\\OAuth2\\\\\\\\Cont...', 'generateToken', Object(OC\\\\AppFramework\\\\DependencyInjection\\\\DIContainer), Array)\\n#8 [internal function]: OC\\\\AppFramework\\\\Routing\\\\RouteActionHandler->__invoke(Array)\\n#9 \\\/home\\\/artur\\\/www\\\/owncloud-10.0.8RC\\\/owncloud\\\/lib\\\/private\\\/Route\\\/Router.php(342): call_user_func(Object(OC\\\\AppFramework\\\\Routing\\\\RouteActionHandler), Array)\\n#10 \\\/home\\\/artur\\\/www\\\/owncloud-10.0.8RC\\\/owncloud\\\/lib\\\/base.php(912): OC\\\\Route\\\\Router->match('\\\/apps\\\/oauth2\\\/ap...')\\n#11 \\\/home\\\/artur\\\/www\\\/owncloud-10.0.8RC\\\/owncloud\\\/index.php(55): OC::handleRequest()\\n#12 {main}\",\"File\":\"\\\/home\\\/artur\\\/www\\\/owncloud-10.0.8RC\\\/owncloud\\\/lib\\\/public\\\/AppFramework\\\/Db\\\/Mapper.php\",\"Line\":294}"}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant