nextcloud reinstall fails

[AlfredoCubitos]

When I try to reinstall nextcloud it throws the following error:

Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [1698] Access denied for user 'oc_oc_admin'@'localhost' in /var/www/nextcloud/lib/private/DB/Connection.php:238

I assume that the login name 'oc_oc_admin' is not correct created.

To fix this problem I had to delete 'var/www/nextcloud' and '/mnt/dietpi_userdata/nextcloud_data/'

This error occurs when I use diepi-software reinstall or trying a fresh install after deleting '/var/www/nextcloud' while '/mnt/dietpi_userdata/nextcloud_data/' remains or vice versa. Meaning, both mentioned directories have to be deleted anyway.

[Joulinar]

Usually nothing would need to be deleted. Just the correct database user to be set within database and config file.

[MichaIng]

At which step/command does it throw this error?

oc_oc_admin looks wrong, indeed. But dietpi-software does never create or set this username, instead:

• On fresh installs, i.e. if neither the database nor a backup exists, calls occ maintenance:install which generates a database user based on internal logic, oc_admin by default.
• If the database exists, it is not touched at all.
• If only a database backup exists, e.g. if https://github.com/MichaIng/DietPi/blob/master/.meta/dietpi-cloud-migration was used to migrate the instance to a new DietPi system, the database username is read from the config.php. Hence it would have been oc_oc_admin already before the reinstall.

To fix this problem I had to delete 'var/www/nextcloud' and '/mnt/dietpi_userdata/nextcloud_data/'

That would basically equal a complete fresh install, loosing all data. The database would remain, but not used, since there is no config.php anymore with matching credentials and instance ID. I expect occ maintenance:install to throw an error in such case, but not sure. Furthermore, it should break the reinstall entirely: If a database named nextcloud exists, but no config.php, the reinstall exits with a dialogue, stating exactly this: a database without a matching config.php cannot be used. Theoretically, it should be possible to manually craft a config.php with matching IDs. But one would need to manually recreate a new database user to know its password, and read the required IDs from the database. This is complex, and dangerous to handle in dietpi-software without knowing exactly what the admin wants, and what the situation is, whether there is a /var/www/nextcloud backup to recover, or any such.

So we would need more details about:

• Why did you reinstall Nextcloud in the first place?
• Was there some issue with it? Which issues, probably the very same that made the reinstall fail.
• If you really did a successful reinstall after removing /var/www/nextcloud and /mnt/dietpi_userdata/nextcloud_data, then at best a full log of that reinstall, since this should not be possible. Also whether the in any case expected full data loss was intended, since then, a dietpi-software uninstall 114 and dietpi-software install 114 would have been cleaner, and would have included a backup of instance and database, which might even have been able to repair things (whatever it was that you did the reinstall in the first place).

[Joulinar]

Just tested on a fresh install. Maybe the NC own installer has a challenge

this is how /var/www/nextcloud/config/config.php looks like

'htaccess.RewriteBase' => '/nextcloud',
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'oc_oc_admin',

yes the user exist in the database

 mysql -e "SELECT User, Host FROM mysql.user;"
+-------------+-----------+
| User        | Host      |
+-------------+-----------+
| oc_oc_admin | %         |
| mariadb.sys | localhost |
| mysql       | localhost |
| oc_oc_admin | localhost |
| root        | localhost |
+-------------+-----------+

NC is working this way.

[MichaIng]

Oh interesting. However, then this is all correct, and should work, just a weird name, probably unintended name with doubled prefix.

All instances I have access to use oc_admin, so looks like this is a quirk introduced in one of the recent Nextcloud versions.

[Joulinar]

but it should not matter as long as user + password are equal between config.php and database.

[AlfredoCubitos]

@MichaIng

So we would need more details about:

* Why did you reinstall Nextcloud in the first place?

* Was there some issue with it? Which issues, probably the very same that made the reinstall fail.

* If you really did a successful reinstall after removing `/var/www/nextcloud` and `/mnt/dietpi_userdata/nextcloud_data`, then at best a full log of that reinstall, since this should not be possible. Also whether the in any case expected full data loss was intended, since then, a `dietpi-software uninstall 114` and `dietpi-software install 114` would have been cleaner, and would have included a backup of instance and database, which might even have been able to repair things (whatever it was that you did the reinstall in the first place).

The fresh installation works fine, no problems. I had some hardware issues, which forced me to reinstall.

@Joulinar : could you try a reinstall on your fresh installation, to see what happen?

[Joulinar]

could you try a reinstall on your fresh installation, to see what happen?

 DietPi-Software
─────────────────────────────────────────────────────
 Step: Installing Nextcloud: File sync, sharing and collaboration platform (PHP)

[ INFO ] DietPi-Software | Existing Nextcloud installation found, will NOT overwrite
[ INFO ] DietPi-Software | Installing required PHP modules
[ INFO ] DietPi-Software | APT install php8.4-intl, please wait...
Reading package lists...
Building dependency tree...
Reading state information...
php8.4-intl is already the newest version (8.4.16-1~deb13u1).
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
[  OK  ] DietPi-Software | APT install php8.4-intl
[ INFO ] DietPi-Software | Enabling required PHP modules
[  OK  ] DietPi-Software | phpenmod ctype curl dom gd intl mbstring pdo_mysql posix simplexml xmlreader xmlwriter zip fileinfo opcache apcu redis exif
[ INFO ] DietPi-Software | Applying PHP override settings for Nextcloud
[  OK  ] DietPi-Software | phpenmod dietpi-nextcloud
[ INFO ] DietPi-Software | Apache webserver found, enabling Nextcloud specific configuration
[  OK  ] DietPi-Software | a2enmod rewrite headers env dir mime
[  OK  ] DietPi-Software | mv /etc/apache2/sites-available/dietpi-nextcloud.conf /etc/apache2/sites-available/dietpi-nextcloud.conf.dietpi-old
[  OK  ] DietPi-Software | cd /tmp/DietPi-Software
[  OK  ] DietPi-Software | curl -sSfL https://raw.githubusercontent.com/MichaIng/DietPi/master/.conf/dps_114/apache.nextcloud.conf -o apache.nextcloud.conf
[  OK  ] DietPi-Software | mv apache.nextcloud.conf /etc/apache2/sites-available/dietpi-nextcloud.conf
[  OK  ] DietPi-Software | a2ensite dietpi-nextcloud
[  OK  ] DietPi-Software | a2enconf dietpi-dav_redirect
[  OK  ] DietPi-Software | systemctl restart mariadb
[  OK  ] DietPi-Software | systemctl restart redis-server
[  OK  ] DietPi-Software | mkdir -p /mnt/dietpi_userdata/nextcloud_data
[  OK  ] DietPi-Software | chown -R www-data:www-data /var/www/nextcloud /mnt/dietpi_userdata/nextcloud_data
[ INFO ] DietPi-Software | Nextcloud database found, will NOT overwrite.
[  OK  ] DietPi-Software | Desired setting in /var/www/nextcloud/config/config.php was already set:   'mysql.utf8mb4' => true,
[  OK  ] DietPi-Software | sed --follow-symlinks -i s|'http://localhost'|'http://localhost/nextcloud'| /var/www/nextcloud/config/config.php
[  OK  ] DietPi-Software | Current setting in /var/www/nextcloud/config/config.php will be preserved: 'htaccess.RewriteBase' => '/nextcloud',
.htaccess has been updated
[  OK  ] DietPi-Software | Current setting in /var/www/nextcloud/config/config.php will be preserved: 'memcache.local' => '\\OC\\Memcache\\APCu',
[  OK  ] DietPi-Software | usermod -aG redis www-data
[  OK  ] DietPi-Software | Desired setting in /var/www/nextcloud/config/config.php was already set: 'filelocking.enabled' => true,
[  OK  ] DietPi-Software | Current setting in /var/www/nextcloud/config/config.php will be preserved: 'memcache.locking' => '\\OC\\Memcache\\Redis',
[  OK  ] DietPi-Software | Current setting in /var/www/nextcloud/config/config.php will be preserved: 'hashingThreads' => 8,
All tables already up to date!
Done.
Done.
[  OK  ] DietPi-Software | occ maintenance:mode --off

No issue because a database is found, and therefore the point is skipped as described by @MichaIng above.

[ INFO ] DietPi-Software | Nextcloud database found, will NOT overwrite.

[Joulinar]

I had some hardware issues, which forced me to reinstall.

Maybe this caused inconsistency. Can you go in some detail on the hardware issues you had?

[AlfredoCubitos]

ah, I think this is a password issue.
After the fresh installation I changed the admin password (by the way, is there a default admin password?)
When a reinstallation uses the default password and does not reset the admin password to its default value, the error may appear.

@Joulinar could you please change the admin default password and try a reinstallation again?

[AlfredoCubitos]

fyi, I did not change the dbuser password only admin password for the nextcloud login.

[Joulinar]

ah, I think this is a password issue.
After the fresh installation I changed the admin password

The admin password on the web interface has nothing to do with the database user/password.

The web UI password is your own software install password you have given at some point during DietPi installation
The database password is a complete random password.

[MichaIng]

The oc_oc_admin username is btw not the issue. A little quirk introduced with Nextcloud 32, which I am fixing here: nextcloud/server#59514
However, this does not cause any issues, just a visual one.

After the fresh installation I changed the admin password

The Nextcloud admin username is not related to the database username. The latter should not be a matter for you at all, it is only relevant internally, for Nextcloud to query the database.

Changing the Nextcloud admin username, or password, or anything, has no effect on reinstalls, or database access, or any such. We need to see your logs from the errors you faced before the first reinstall, and from the first and second reinstall. There is nothing we can replicate at this stage.

[AlfredoCubitos]

The database password is a complete random password.

so this could be the issue, when during the reinstallation a new random password is used.
@Joulinar I could see that, you left the original installation untouched. So I assume that in this case the script does not create a new dbpassword. Your reinstallation works a expected.

In my case I had to remove the nexcloud folder before I started the reinstallation. May be in this case a new dbpassword is created, which does not work because the old dbpassword in the database keeps unchanged.
Could that be the issue?

[MichaIng]

so this could be the issue, when during the reinstallation a new random password is used.

No, only a fresh install (without database at /mnt/dietpi_userdata/mysql/nextcloud and without a backup of it), the password is generated. And it is then passed to occ maintenance:install, hence written to config.php, or it would fail at that step.

In my case I had to remove the nexcloud folder before I started the reinstallation.

Which "nextcloud" directory to you mean? /var/www/nextcloud, /mnt/dietpi_userdata/mysql/nextcloud (the database), or both? And at which exact step of the reinstall did you see the database connection error (before you removed those directories)?