Hi guys, I’m trying to authenticate users from MySQL database but unfortunately I am unable to authenticate. I am able to authenticate with LDAP but unable to authenticate with sql. Please share me the steps to authenticate users from MySQL. I have followed GitHub - nextcloud/user_sql: 🔒 App for authenticating Nextcloud users using SQL.
Regards
Chandrashekar
Please provide DETAILED information about your enviornment, the used software and app versions, any error messages from the nextcloud log file, how you EXACTLY tried to configure the app and which error/result is shown.
First created database
mysql -u root -p
CREATE DATABASE nextcloud_sql;
GRANT ALL PRIVILEGES ON nextcloud_sql.* TO ‘nextcloud_sql’@‘localhost’ IDENTIFIED BY ‘t0t@l’;
FLUSH PRIVILEGES;
use nextcloud_sql;
CREATE TABLE sql_user ( uid INT PRIMARY KEY AUTO_INCREMENT, username VARCHAR(16) NOT NULL UNIQUE, display_name TEXT NULL, email TEXT NULL, quota TEXT NULL, home TEXT NULL, password TEXT NOT NULL, active TINYINT(1) NOT NULL DEFAULT ‘1’, disabled TINYINT(1) NOT NULL DEFAULT ‘0’, provide_avatar BOOLEAN NOT NULL DEFAULT FALSE, salt TEXT NULL );
INSERT INTO sql_user (uid, username, email, display_name, quota, salt, password) VALUES (84, ‘chandru’, ‘chandrashekar@abcd.com’, ‘chandru’, ‘1000’, ‘cleartext’, ‘Test123’);
exit;
Nextcloud —> Settings —> Administration —> SQL backends
Database → MySQL
Hostname —> localhost
Database —> nextcloud_sql
Username —> nextcloud_sql
Password ----> t0t@l
Allow display name change —> box checked
Allow password change —> box checked
Hash algorithm —> text
If i click on verify settings getting “successfully connected to database”.
next SAVE.
I have executed above commands but unable to login with Mysql users.
Regards,
Chandrashekar Azad
What about related error messages from the Nextcloud log file? I would assume that more detailed information can be found in the log.
Hi sir,
In the error-log files, I’m not getting any errors. The file is empty.
Regards,
Chandrashekar Azad
I’ve not spoken about the web servers error log file, but the Nextcloud log file, which usually contains related messages.
Hi Sir,
In the backend there are no error logs in nextcloud log file. but in the browser we are getting “wrong password or username” error.
Hi Sir,
Please find errors as below.
{“reqId”:“lux1TfgIvp2gvqrdPz0W”,“level”:3,“time”:“April 14, 2021 11:51:32”,“remoteAddr”:“157.45.208.110”,“user”:“admin”,“app”:“index”,“method”:“POST”,“url”:"/index.php/apps/user_sql/settings/autocomplete/table",“message”:{“Exception”:“Exception”,“Message”:“Call to undefined method Doctrine\DBAL\Driver\PDO\MySQL\Driver::getName()”,“Code”:0,“Trace”:[{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“Line”:159,“Previous”:{“Exception”:“Error”,“Message”:“Call to undefined method Doctrine\DBAL\Driver\PDO\MySQL\Driver::getName()”,“Code”:0,“Trace”:[{“file”:"/data/nextcloud/abcd/nextcloud/apps/user_sql/lib/Controller/SettingsController.php",“line”:368,“function”:“getPlatform”,“class”:“OCA\UserSQL\Platform\PlatformFactory”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:218,“function”:“tableAutocomplete”,“class”:“OCA\UserSQL\Controller\SettingsController”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:127,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/data/nextcloud/abcd/nextcloud/apps/user_sql/lib/Platform/PlatformFactory.php",“Line”:42},“CustomMessage”:"–"},“userAgent”:“Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0”,“version”:“21.0.0.18”}
{“reqId”:“sVbjQUSSHnDfgVIXc3cC”,“level”:3,“time”:“April 14, 2021 11:51:34”,“remoteAddr”:“157.45.208.110”,“user”:“admin”,“app”:“index”,“method”:“POST”,“url”:"/index.php/apps/user_sql/settings/autocomplete/table",“message”:{“Exception”:“Exception”,“Message”:“Call to undefined method Doctrine\DBAL\Driver\PDO\MySQL\Driver::getName()”,“Code”:0,“Trace”:[{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“Line”:159,“Previous”:{“Exception”:“Error”,“Message”:“Call to undefined method Doctrine\DBAL\Driver\PDO\MySQL\Driver::getName()”,“Code”:0,“Trace”:[{“file”:"/data/nextcloud/abcd/nextcloud/apps/user_sql/lib/Controller/SettingsController.php",“line”:368,“function”:“getPlatform”,“class”:“OCA\UserSQL\Platform\PlatformFactory”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:218,“function”:“tableAutocomplete”,“class”:“OCA\UserSQL\Controller\SettingsController”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:127,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/data/nextcloud/abcd/nextcloud/apps/user_sql/lib/Platform/PlatformFactory.php",“Line”:42},“CustomMessage”:"–"},“userAgent”:“Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0”,“version”:“21.0.0.18”}
{“reqId”:“H5sYcDHIbvlSLP5MblmR”,“level”:3,“time”:“April 14, 2021 11:51:35”,“remoteAddr”:“157.45.208.110”,“user”:“admin”,“app”:“index”,“method”:“POST”,“url”:"/index.php/apps/user_sql/settings/autocomplete/table",“message”:{“Exception”:“Exception”,“Message”:“Call to undefined method Doctrine\DBAL\Driver\PDO\MySQL\Driver::getName()”,“Code”:0,“Trace”:[{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“Line”:159,“Previous”:{“Exception”:“Error”,“Message”:“Call to undefined method Doctrine\DBAL\Driver\PDO\MySQL\Driver::getName()”,“Code”:0,“Trace”:[{“file”:"/data/nextcloud/abcd/nextcloud/apps/user_sql/lib/Controller/SettingsController.php",“line”:368,“function”:“getPlatform”,“class”:“OCA\UserSQL\Platform\PlatformFactory”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:218,“function”:“tableAutocomplete”,“class”:“OCA\UserSQL\Controller\SettingsController”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:127,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/data/nextcloud/abcd/nextcloud/apps/user_sql/lib/Platform/PlatformFactory.php",“Line”:42},“CustomMessage”:"–"},“userAgent”:“Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0”,“version”:“21.0.0.18”}
{“reqId”:“zhGgdSeERrNmLBNxboN5”,“level”:3,“time”:“April 14, 2021 11:51:35”,“remoteAddr”:“157.45.208.110”,“user”:“admin”,“app”:“index”,“method”:“POST”,“url”:"/index.php/apps/user_sql/settings/autocomplete/table",“message”:{“Exception”:“Exception”,“Message”:“Call to undefined method Doctrine\DBAL\Driver\PDO\MySQL\Driver::getName()”,“Code”:0,“Trace”:[{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“Line”:159,“Previous”:{“Exception”:“Error”,“Message”:“Call to undefined method Doctrine\DBAL\Driver\PDO\MySQL\Driver::getName()”,“Code”:0,“Trace”:[{“file”:"/data/nextcloud/abcd/nextcloud/apps/user_sql/lib/Controller/SettingsController.php",“line”:368,“function”:“getPlatform”,“class”:“OCA\UserSQL\Platform\PlatformFactory”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:218,“function”:“tableAutocomplete”,“class”:“OCA\UserSQL\Controller\SettingsController”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:127,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/data/nextcloud/abcd/nextcloud/apps/user_sql/lib/Platform/PlatformFactory.php",“Line”:42},“CustomMessage”:"–"},“userAgent”:“Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0”,“version”:“21.0.0.18”}
{“reqId”:“xJsbQL73G2MxiPz6KxK8”,“level”:3,“time”:“April 14, 2021 11:51:36”,“remoteAddr”:“157.45.208.110”,“user”:“admin”,“app”:“index”,“method”:“POST”,“url”:"/index.php/apps/user_sql/settings/autocomplete/table",“message”:{“Exception”:“Exception”,“Message”:“Call to undefined method Doctrine\DBAL\Driver\PDO\MySQL\Driver::getName()”,“Code”:0,“Trace”:[{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“Line”:159,“Previous”:{“Exception”:“Error”,“Message”:“Call to undefined method Doctrine\DBAL\Driver\PDO\MySQL\Driver::getName()”,“Code”:0,“Trace”:[{“file”:"/data/nextcloud/abcd/nextcloud/apps/user_sql/lib/Controller/SettingsController.php",“line”:368,“function”:“getPlatform”,“class”:“OCA\UserSQL\Platform\PlatformFactory”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:218,“function”:“tableAutocomplete”,“class”:“OCA\UserSQL\Controller\SettingsController”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:127,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/data/nextcloud/abcd/nextcloud/apps/user_sql/lib/Platform/PlatformFactory.php",“Line”:42},“CustomMessage”:"–"},“userAgent”:“Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0”,“version”:“21.0.0.18”}
{“reqId”:“tTD2vcZqZaSngRirFlMf”,“level”:3,“time”:“April 14, 2021 11:51:37”,“remoteAddr”:“157.45.208.110”,“user”:“admin”,“app”:“index”,“method”:“POST”,“url”:"/index.php/apps/user_sql/settings/autocomplete/table",“message”:{“Exception”:“Exception”,“Message”:“Call to undefined method Doctrine\DBAL\Driver\PDO\MySQL\Driver::getName()”,“Code”:0,“Trace”:[{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“Line”:159,“Previous”:{“Exception”:“Error”,“Message”:“Call to undefined method Doctrine\DBAL\Driver\PDO\MySQL\Driver::getName()”,“Code”:0,“Trace”:[{“file”:"/data/nextcloud/abcd/nextcloud/apps/user_sql/lib/Controller/SettingsController.php",“line”:368,“function”:“getPlatform”,“class”:“OCA\UserSQL\Platform\PlatformFactory”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:218,“function”:“tableAutocomplete”,“class”:“OCA\UserSQL\Controller\SettingsController”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:127,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/data/nextcloud/abcd/nextcloud/apps/user_sql/lib/Platform/PlatformFactory.php",“Line”:42},“CustomMessage”:"–"},“userAgent”:“Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0”,“version”:“21.0.0.18”}
{“reqId”:“WV3swXKwNTeCCixuqsWh”,“level”:3,“time”:“April 14, 2021 11:51:48”,“remoteAddr”:“157.45.208.110”,“user”:“admin”,“app”:“index”,“method”:“POST”,“url”:"/index.php/apps/user_sql/settings/autocomplete/table",“message”:{“Exception”:“Exception”,“Message”:“Call to undefined method Doctrine\DBAL\Driver\PDO\MySQL\Driver::getName()”,“Code”:0,“Trace”:[{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“Line”:159,“Previous”:{“Exception”:“Error”,“Message”:“Call to undefined method Doctrine\DBAL\Driver\PDO\MySQL\Driver::getName()”,“Code”:0,“Trace”:[{“file”:"/data/nextcloud/abcd/nextcloud/apps/user_sql/lib/Controller/SettingsController.php",“line”:368,“function”:“getPlatform”,“class”:“OCA\UserSQL\Platform\PlatformFactory”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:218,“function”:“tableAutocomplete”,“class”:“OCA\UserSQL\Controller\SettingsController”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:127,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/data/nextcloud/abcd/nextcloud/apps/user_sql/lib/Platform/PlatformFactory.php",“Line”:42},“CustomMessage”:"–"},“userAgent”:“Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0”,“version”:“21.0.0.18”}
{“reqId”:“R2jMejX95Y7Sedpgzfqe”,“level”:3,“time”:“April 14, 2021 11:52:45”,“remoteAddr”:“157.45.208.110”,“user”:“admin”,“app”:“index”,“method”:“POST”,“url”:"/index.php/apps/user_sql/settings/autocomplete/table",“message”:{“Exception”:“Exception”,“Message”:“Call to undefined method Doctrine\DBAL\Driver\PDO\MySQL\Driver::getName()”,“Code”:0,“Trace”:[{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“Line”:159,“Previous”:{“Exception”:“Error”,“Message”:“Call to undefined method Doctrine\DBAL\Driver\PDO\MySQL\Driver::getName()”,“Code”:0,“Trace”:[{“file”:"/data/nextcloud/abcd/nextcloud/apps/user_sql/lib/Controller/SettingsController.php",“line”:368,“function”:“getPlatform”,“class”:“OCA\UserSQL\Platform\PlatformFactory”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:218,“function”:“tableAutocomplete”,“class”:“OCA\UserSQL\Controller\SettingsController”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:127,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/data/nextcloud/abcd/nextcloud/apps/user_sql/lib/Platform/PlatformFactory.php",“Line”:42},“CustomMessage”:"–"},“userAgent”:“Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0”,“version”:“21.0.0.18”}
{“reqId”:“AKn9L3RcxKOserng7ZIb”,“level”:3,“time”:“April 14, 2021 11:53:42”,“remoteAddr”:“157.45.208.110”,“user”:“admin”,“app”:“index”,“method”:“POST”,“url”:"/index.php/apps/user_sql/settings/autocomplete/table",“message”:{“Exception”:“Exception”,“Message”:“Call to undefined method Doctrine\DBAL\Driver\PDO\MySQL\Driver::getName()”,“Code”:0,“Trace”:[{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“Line”:159,“Previous”:{“Exception”:“Error”,“Message”:“Call to undefined method Doctrine\DBAL\Driver\PDO\MySQL\Driver::getName()”,“Code”:0,“Trace”:[{“file”:"/data/nextcloud/abcd/nextcloud/apps/user_sql/lib/Controller/SettingsController.php",“line”:368,“function”:“getPlatform”,“class”:“OCA\UserSQL\Platform\PlatformFactory”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:218,“function”:“tableAutocomplete”,“class”:“OCA\UserSQL\Controller\SettingsController”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:127,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/data/nextcloud/abcd/nextcloud/apps/user_sql/lib/Platform/PlatformFactory.php",“Line”:42},“CustomMessage”:"–"},“userAgent”:“Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0”,“version”:“21.0.0.18”}
{“reqId”:“qeBsT7kAOhC3RYFGtWze”,“level”:3,“time”:“April 14, 2021 11:53:44”,“remoteAddr”:“157.45.208.110”,“user”:“admin”,“app”:“index”,“method”:“POST”,“url”:"/index.php/apps/user_sql/settings/autocomplete/table",“message”:{“Exception”:“Exception”,“Message”:“Call to undefined method Doctrine\DBAL\Driver\PDO\MySQL\Driver::getName()”,“Code”:0,“Trace”:[{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“Line”:159,“Previous”:{“Exception”:“Error”,“Message”:“Call to undefined method Doctrine\DBAL\Driver\PDO\MySQL\Driver::getName()”,“Code”:0,“Trace”:[{“file”:"/data/nextcloud/abcd/nextcloud/apps/user_sql/lib/Controller/SettingsController.php",“line”:368,“function”:“getPlatform”,“class”:“OCA\UserSQL\Platform\PlatformFactory”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:218,“function”:“tableAutocomplete”,“class”:“OCA\UserSQL\Controller\SettingsController”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:127,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/data/nextcloud/abcd/nextcloud/lib/base.php",“line”:993,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/data/nextcloud/abcd/nextcloud/index.php",“line”:37,“function”:“handleRequest”,“class”:“OC”,“type”:"::"}],“File”:"/data/nextcloud/abcd/nextcloud/apps/user_sql/lib/Platform/PlatformFactory.php",“Line”:42},“CustomMessage”:"–"},“userAgent”:“Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0”,“version”:“21.0.0.18”}
{“reqId”:“VK2PP70paVuGOZCLQ2Yg”,“level”:2,“time”:“April 14, 2021 12:04:34”,“remoteAddr”:“157.45.208.110”,“user”:“admin”,“app”:“filesystem”,“method”:“PUT”,“url”:"/index.php/apps/user_status/heartbeat",“message”:“Storage wrapper ‘sharepermissions’ was not registered via the ‘OC_Filesystem - preSetup’ hook which could cause potential problems.”,“userAgent”:“Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0”,“version”:“21.0.0.18”}
{“reqId”:“RbchBjOCm5aE5rU1kIiZ”,“level”:2,“time”:“April 14, 2021 12:06:00”,“remoteAddr”:“157.45.208.110”,“user”:"–",“app”:“filesystem”,“method”:“GET”,“url”:"/index.php/csrftoken",“message”:“Storage wrapper ‘sharepermissions’ was not registered via the ‘OC_Filesystem - preSetup’ hook which could cause potential problems.”,“userAgent”:“Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36”,“version”:“21.0.0.18”}
{“reqId”:“pFNs8Ymp1kUg75GjlQWz”,“level”:2,“time”:“April 14, 2021 12:06:20”,“remoteAddr”:“157.45.208.110”,“user”:“admin”,“app”:“filesystem”,“method”:“PUT”,“url”:"/index.php/apps/user_status/heartbeat",“message”:“Storage wrapper ‘sharepermissions’ was not registered via the ‘OC_Filesystem - preSetup’ hook which could cause potential problems.”,“userAgent”:“Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0”,“version”:“21.0.0.18”}
{“reqId”:“syGTlTzCdmAjicgoepzY”,“level”:2,“time”:“April 14, 2021 12:08:08”,“remoteAddr”:“49.206.22.198”,“user”:“Aiyaz”,“app”:“filesystem”,“method”:“PUT”,“url”:"/index.php/apps/user_status/heartbeat",“message”:“Storage wrapper ‘sharepermissions’ was not registered via the ‘OC_Filesystem - preSetup’ hook which could cause potential problems.”,“userAgent”:“Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.114 Safari/537.36”,“version”:“21.0.0.18”}
{“reqId”:“O8JAxIxOTF0N54BIzaQu”,“level”:2,“time”:“April 14, 2021 12:09:32”,“remoteAddr”:“49.206.22.198”,“user”:“Aiyaz”,“app”:“filesystem”,“method”:“GET”,“url”:"/index.php/csrftoken",“message”:“Storage wrapper ‘sharepermissions’ was not registered via the ‘OC_Filesystem - preSetup’ hook which could cause potential problems.”,“userAgent”:“Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.114 Safari/537.36”,“version”:“21.0.0.18”}
{“reqId”:“EnSOIH96I5zvz8u7nadv”,“level”:2,“time”:“April 14, 2021 12:09:33”,“remoteAddr”:“157.45.208.110”,“user”:“admin”,“app”:“filesystem”,“method”:“GET”,“url”:"/index.php/apps/files/ajax/getstoragestats.php?dir=%2F",“message”:“Storage wrapper ‘sharepermissions’ was not registered via the ‘OC_Filesystem - preSetup’ hook which could cause potential problems.”,“userAgent”:“Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0”,“version”:“21.0.0.18”}
{“reqId”:“Jzt7071NXC62iiZUPxA1”,“level”:2,“time”:“April 14, 2021 12:11:20”,“remoteAddr”:“157.45.208.110”,“user”:“admin”,“app”:“filesystem”,“method”:“PUT”,“url”:"/index.php/apps/user_status/heartbeat",“message”:“Storage wrapper ‘sharepermissions’ was not registered via the ‘OC_Filesystem - preSetup’ hook which could cause potential problems.”,“userAgent”:“Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0”,“version”:“21.0.0.18”}
{“reqId”:“hrdAADaI8BTAcnbAZ5VT”,“level”:2,“time”:“April 14, 2021 12:11:56”,“remoteAddr”:“157.45.208.110”,“user”:“admin”,“app”:“filesystem”,“method”:“PUT”,“url”:"/index.php/apps/user_status/heartbeat",“message”:“Storage wrapper ‘sharepermissions’ was not registered via the ‘OC_Filesystem - preSetup’ hook which could cause potential problems.”,“userAgent”:“Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:87.0) Gecko/20100101 Firefox/87.0”,“version”:“21.0.0.18”}
{“reqId”:“lAO5lx5N4xXgGeti8mY2”,“level”:2,“time”:“April 14, 2021 12:12:09”,“remoteAddr”:“103.81.95.130”,“user”:“demo2”,“app”:“filesystem”,“method”:“PUT”,“url”:"/index.php/apps/user_status/heartbeat",“message”:“Storage wrapper ‘sharepermissions’ was not registered via the ‘OC_Filesystem - preSetup’ hook which could cause potential problems.”,“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.114 Safari/537.36”,“version”:“21.0.0.18”}
{“reqId”:“dLj2VpvF5emzzxewdPou”,“level”:2,“time”:“April 14, 2021 12:12:09”,“remoteAddr”:“103.81.95.130”,“user”:“demo2”,“app”:“filesystem”,“method”:“GET”,“url”:"/index.php/csrftoken",“message”:“Storage wrapper ‘sharepermissions’ was not registered via the ‘OC_Filesystem - preSetup’ hook which could cause potential problems.”,“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.114 Safari/537.36”,“version”:“21.0.0.18”}