Delete encrypted credentials from DB dump

ℹ️ Support
1

Nextcloud version : 27.0.1
Operating system and version : TrueNas Scale 22.12.3.3
Apache or nginx version: 1.25.1

I followed this migration guide of my host plattform:

its said before migrating delete the smb auth app, which I did.
Somehow it didn’t work and there are still encrypted credentials in my database dump.

after running occ upgrade i get this error:

image
image858×850 228 KB

and nc shows this error:

image
image757×387 13 KB

Is there a way to delete the encrypted credentials right in the db dump, if so, how and what parts do I have to delete to make it work?

2

There is no “smb auth app”. What did you delete?

From the docs you linked to:

If you are using SMB authenticated external storage on your Nextcloud remove it before starting this guide. The migration process will fail if it is not removed.

…I think the instruction here was to remove any configured SMB-based External Storage (i.e. delete it from your configuration) before proceeding with the rest of the guide.

3

thats what i was referring to, but sadly deleting the credentials and the app from config, didnt bring the effect that it was deleted from the db…

4

Oh, my bad. Now I understand.

The files_external app stores it’s configuration in db tables that are all called PREFIX_external_*. Typically PREFIX = oc.

oc_external_mounts
oc_external_config
oc_external_options
oc_external_applicable

Those are likely present in your db dump.

5

thank you for the db field names, in the meantime I had to manually bring back my data, but maybe some one else running into this problem could use this information and verify if its working :slight_smile:

thanks a lot!