Server logfile: ownCloud log (data/owncloud.log):
{âreqIdâ:âvztwg5XbHBrlAvIKeXj2â,âremoteAddrâ:"",âappâ:âmysql.setupâ,âmessageâ:âDatabase creation failed: An exception occurred while executing âGRANT ALL PRIVILEGES ON owncloud . * TO âowncloudââ:\n\nSQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user âowncloudâ@âlocalhostâ to database âowncloudââ,âlevelâ:3,âtimeâ:â2020-09-12T12:41:26+00:00â,âmethodâ:âPOSTâ,âurlâ:"â",âuserâ:"â"}
It´s a new install.
Ok I just delete the old owncloud, picked up the new one (10.5) MySql was already installed with the owncloud DB and user ready for the use but the error is always the same.
So order is not important, version number also not because the error is always the same.
Any other idea?
Thank you,
Davide
Logs:
{âreqIdâ:âX13ca@L1WvGGKUy6itVlVgAAAAYâ,âlevelâ:3,âtimeâ:â2020-09-13T08:46:35+00:00â,âremoteAddrâ:â1.1.1.1â,âuserâ:"â",âappâ:âmysql.setupâ,âmethodâ:âPOSTâ,âurlâ:"/index.php",âmessageâ:âSpecific user creation failed: An exception occurred while executing âSELECT user FROM mysql.user WHERE user=?â with params [âoc_Adminâ]:\n\nSQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user âowncloudâ@âlocalhostâ for table âuserââ}
{âreqIdâ:âX13etwgn9tV5JEl@ZbmylAAAAAAâ,âlevelâ:3,âtimeâ:â2020-09-13T08:56:23+00:00â,âremoteAddrâ:â1.1.1.1â,âuserâ:"â",âappâ:âPHPâ,âmethodâ:âPOSTâ,âurlâ:"/index.php",âmessageâ:âUndefined index: dbconnectionstring at /var/www/my-ownshare.ddns.net/lib/private/Setup/AbstractDatabase.php#82â}
Itâs because the DB you try to use exists and isnât empty. This is OK for an upgrade but not for a fresh install. Setup tries to create an admin user, but as it already exists, this will end up in an error.
Switching to sqlite solves this, because you obviously didnât have such a DB, thus a new one was created by setup.