User already being used

Expected behaviour

I can finish the setup

Actual behaviour

Unable to do do because of errors about user already being used.

Steps to reproduce

  1. Install Ownclud
  2. Install Mysql
  3. On the UI try to finish the setup

Server configuration

Operating system:
Raspbian GNU/Linux 10 (buster)
Web server:
Apache2
Database:
MySql
PHP version:
7.2
ownCloud version:
9
Storage backend (external storage):
none

Client configuration

Client version:

Operating system:

OS language:

Qt version used by client package (Linux only, see also Settings dialog):

Client package (From ownCloud or distro) (Linux only):
from owncloud
Installation path of client:

Logs

Please use Gist (https://gist.github.com/) or a similar code paster for longer
logs.

Template for output < 10 lines

  1. Client logfile: Output of owncloud --logwindow or owncloud --logfile log.txt
    (On Windows using cmd.exe, you might need to first cd into the ownCloud directory)
    (See also http://doc.owncloud.org/desktop/2.2/troubleshooting.html#client-logfile )

  2. Web server error log:

  3. 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”:"–"}

Then it’s an upgrade, not an install. What is in now in fact?

Wrong order, mysql is to be installed and ready to use first.

BTW, no reason to install very outdated version these days.

1 Like

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”}

Solved by switching to Sqlite instead of mysql.

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.

1 Like

Please don’t open duplicate threads if you don’t get a response.

  • This is a server issue. So server category is the right one. Moving.
1 Like

Thank you for the reply. The DB had no admin user, just owncloud user.