Broken installation of nextcloud when upgrading. Howto backup reinstall - restore?

I have got a broken installation of nextcloud. It was working great but I show, as admin a message “click here to upgrade version” and I did it and it fails, after that I realized that I have installed nextcloud through the Opensuse packet manager and upgrades should go this way. Then I removed the nextcloud package and installed it again, some things works but others don’t. I documented it here.
Te point is that I think it may be easier to backup user data, delete nexcloud install it from scratch and recover the backed up data. I have seen some documents explaining the backup process but if i only want to backup alll user data (files, calendar, etc.) but no the system files what should I back up?
I think some of the stuff will be in the files under /srv/www/htdocs/netxcloud/data wich is the data directory set in config.php (should I backup/restore the entire directory? is there everything in there?) but other stuff will be in the mysql database, but… if I backup/restore the entire database will not make the things that are working bad work bad again? should I restore the database in a selective way?

best regards

The data/user/files folder contains the files, but stuff like contacts, calendar, user credentials etc. are in the MySQL database. I haven’t got a good picture of everything you tried, hence not of the state the install is in now. One of the things I do know from the nextcloud website and their docs is that the advice in case of a failure during upgrade/update is to enter the webroot of the install and run

sudo -u wwwrun php occ upgrade

That would tell you what goes wrong.

aldebaran:/srv/www/htdocs/nextcloud # sudo -u wwwrun php occ upgrade
Nextcloud is already latest version
aldebaran:/srv/www/htdocs/nextcloud # 

I don’t really know what went broken, but I had nextcloud and collabra working and now nextcloud does not work well and collabra does not work at all,so, as there was not very difficult to install and configure them both, and I have the process documented, I think it may be more straightforwad to delete/reinstall, but the problem is that I’m not sure about the backup/restore part.

On the collabora issue: What’s the version of the app in Nextcloud? From 3.6.0 it needs

                       # WOPI capabilities URL
 ProxyPass           /hosting/capabilities retry=0
 ProxyPassReverse    /hosting/capabilities

in the apache vhost for the collabora server ( in my case

I’ve already contacted one of the collabora people that they have to include some check for required changes and have the app’s settings display a clear message ( like NC itself does ) what to change.

Does the Nextcloud admin settings page - Overview report anything?

is this one, isn’t it?

aldebaran:/srv/www/htdocs/nextcloud # sudo -u wwwrun php occ app:list  |grep rich
  - richdocuments: 3.7.0
aldebaran:/srv/www/htdocs/nextcloud # 

This is in my virtual server conf.

        # static html, js, images, etc. served from loolwsd
        # loleaflet is the client part of LibreOffice Online
        ProxyPass           /loleaflet retry=0
        ProxyPassReverse    /loleaflet

        # WOPI discovery URL
        ProxyPass           /hosting/discovery retry=0
        ProxyPassReverse    /hosting/discovery

        # Main websocket
        ProxyPassMatch "/lool/(.*)/ws$" wss://$1/ws nocanon

        # Admin Console websocket
        ProxyPass   /lool/adminws wss://

        # Download as, Fullscreen presentation and Image upload operations
        ProxyPass           /lool
        ProxyPassReverse    /lool

        # Endpoint with information about availability of various features
        ProxyPass           /hosting/capabilities retry=0
        ProxyPassReverse    /hosting/capabilities

The vhost looks OK, it already has those two lines added. No idea what you mean with the richdocuments output.

(collabora online setup) Could not establish connection to the Collabora Online server

Some files have not passed the integrity check. Further information on how to resolve this issue can be found in the documentation.
there are a lot of files…

Version Nextcloud 18.0.4
A new version is available: Nextcloud 18.0.5
All apps have an update for this version available

I’m thinking on trying the upgrade… It may not be worse

Isn’t it richodocuments the collabora app?

No. The app is called ‘Collabora Online’.

Did you restart apache after you added the two capabilities lines?

Here are ( modified URLS ) my vhost configs of a working Nextcloud: