I installed nextcloud yesterday for a client, everything was working just fine. Today I noticed logins are not possible.
This is the error displayed:
{“reqId”:“zpDOr6yGTEk5JIJJgsBi”,“remoteAddr”:“176.9.104.3”,“app”:“index”,“message”:“Exception: {“Exception”:“Doctrine\\DBAL\\Exception\\DriverException”,“Message”:“An exception occurred while executing ‘SELECT uid, password FROM oc_users WHERE LOWER(uid) = LOWER(?)’ with params [\“alex\”]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away”,“Code”:0,“Trace”:”#0 \/home\/cloud\/web\/domain.co\/public_html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php(128): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException(‘An exception oc…’, Object(Doctrine\\DBAL\\Driver\\PDOException))\n#1 \/home\/cloud\/web\/domain.co\/public_html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Statement.php(177): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), ‘SELECT uid, `…’, Array)\n#2 \/home\/cloud\/web\/domain.co\/public_html\/lib\/private\/legacy\/db\/statementwrapper.php(74): Doctrine\\DBAL\\Statement->execute(Array)\n#3 \/home\/cloud\/web\/domain.co\/public_html\/lib\/private\/User\/Database.php(216): OC_DB_StatementWrapper->execute(Array)\n#4 \/home\/cloud\/web\/domain.co\/public_html\/lib\/private\/User\/Manager.php(193): OC\\User\\Database->checkPassword(*** sensitive parameters replaced )\n#5 \/home\/cloud\/web\/domain.co\/public_html\/core\/Controller\/LoginController.php(221): OC\\User\\Manager->checkPassword( sensitive parameters replaced )\n#6 [internal function]: OC\\Core\\Controller\\LoginController->tryLogin( sensitive parameters replaced ***)\n#7 \/home\/cloud\/web\/domain.co\/public_html\/lib\/private\/AppFramework\/Http\/Dispatcher.php(160): call_user_func_array(Array, Array)\n#8 \/home\/cloud\/web\/domain.co\/public_html\/lib\/private\/AppFramework\/Http\/Dispatcher.php(90): OC\\AppFramework\\Http\\Dispatcher->executeController(Object(OC\\Core\\Controller\\LoginController), ‘tryLogin’)\n#9 \/home\/cloud\/web\/domain.co\/public_html\/lib\/private\/AppFramework\/App.php(114): OC\\AppFramework\\Http\\Dispatcher->dispatch(Object(OC\\Core\\Controller\\LoginController), ‘tryLogin’)\n#10 \/home\/cloud\/web\/domain.co\/public_html\/lib\/private\/AppFramework\/Routing\/RouteActionHandler.php(47): OC\\AppFramework\\App::main(‘OC\\\\Core\\\\Control…’, ‘tryLogin’, Object(OC\\AppFramework\\DependencyInjection\\DIContainer), Array)\n#11 [internal function]: OC\\AppFramework\\Routing\\RouteActionHandler->__invoke(Array)\n#12 \/home\/cloud\/web\/domain.co\/public_html\/lib\/private\/Route\/Router.php(299): call_user_func(Object(OC\\AppFramework\\Routing\\RouteActionHandler), Array)\n#13 \/home\/cloud\/web\/domain.co\/public_html\/lib\/base.php(1010): OC\\Route\\Router->match(’\/login’)\n#14 \/home\/cloud\/web\/domain.co\/public_html\/index.php(40): OC::handleRequest()\n#15 {main}",“File”:"\/home\/cloud\/web\/domain.co\/public_html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php",“Line”:116}",“level”:3,“time”:“2017-05-03T06:05:20+00:00”,“method”:“POST”,“url”:"/index.php/login",“user”:"–",“version”:“11.0.3.2”}
Not sure why this happens. Any solution?
Its a database install.
Thanks!
-Paul