Post Nextcloud 21 issues with installed apps, TOTP, DECK

So I am in a bit of a catch 22, namely Deck and TOTP can be removed but not readded via the web gui, the entire list of non-installed apps are not appearing. I am open to using the OCC to maybe rerun the update or something. Any suggestions on using the OCC command?

My Nextcloud settings Overview page shows this warning, not sure what to make of it either but it might be an unrelated rabbit hole

There are some warnings regarding your setup.

    This server has no working Internet connection: Multiple endpoints could not be reached. This means that some of the features like mounting external storage, notifications about updates or installation of third-party apps will not work. Accessing files remotely and sending of notification emails might not work, either. Establish a connection from this server to the Internet to enjoy all features.

    Your installation has no default phone region set. This is required to validate phone numbers in the profile settings without a country code. To allow numbers without a country code, please add "default_phone_region" with the respective ISO 3166-1 code ↗ of the region to your config file.
    The database is missing some primary keys. Due to the fact that adding primary keys on big tables could take some time they were not added automatically. By running "occ db:add-missing-primary-keys" those missing primary keys could be added manually while the instance keeps running.
        Missing primary key on table "oc_federated_reshares".
        Missing primary key on table "oc_systemtag_object_mapping".
        Missing primary key on table "oc_comments_read_markers".
        Missing primary key on table "oc_collres_resources".
        Missing primary key on table "oc_collres_accesscache".
        Missing primary key on table "oc_filecache_extended".
    Some columns in the database are missing a conversion to big int. Due to the fact that changing column types on big tables could take some time they were not changed automatically. By running 'occ db:convert-filecache-bigint' those pending changes could be applied manually. This operation needs to be made while the instance is offline. For further details read the documentation page about this.
        federated_reshares.share_id
        filecache_extended.fileid
        mounts.storage_id
        mounts.root_id
        mounts.mount_id
        share_external.id
        share_external.parent

Please double check the installation guides ↗, and check for any errors or warnings in the log.

Check the security of your Nextcloud over our security scan ↗. 

Well that seems the problem:

This server has no working Internet connection: Multiple endpoints could not be reached. This means that some of the features like mounting external storage, notifications about updates or installation of third-party apps will not work. Accessing files remotely and sending of notification emails might not work, either. Establish a connection from this server to the Internet to enjoy all features.

The other warning can be fixed by running:

snap run nextcloud.occ db:convert-filecache-bigint 
1 Like

Yeah, sorry for not seeing that sooner

I only hesitated to run what it suggested in case it was related. But I ran both suggestions.
As for the loss of server connection that was not an issue before upgrading to 21.

do you have internet connection from the box?

ping google.com

Yeah that was one of the first things i did. In other words yes it pings

ok try this and send the output:

snap run nextcloud.occ app:install deck
root@syncloud:~# snap run nextcloud.occ app:install deck
Error: Could not download app deck
root@syncloud:~# 


Ok, try

ping github.com

Also this

wget https://github.com/nextcloud/deck/releases/download/v1.4.2/deck.tar.gz
root@syncloud:~# ping github.com
PING github.com (140.82.112.4) 56(84) bytes of data.
64 bytes from lb-140-82-112-4-iad.github.com (140.82.112.4): icmp_seq=1 ttl=54 time=19.7 ms
64 bytes from lb-140-82-112-4-iad.github.com (140.82.112.4): icmp_seq=2 ttl=54 time=12.7 ms
64 bytes from lb-140-82-112-4-iad.github.com (140.82.112.4): icmp_seq=3 ttl=54 time=14.6 ms
64 bytes from lb-140-82-112-4-iad.github.com (140.82.112.4): icmp_seq=4 ttl=54 time=17.0 ms
^C
--- github.com ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 3005ms
rtt min/avg/max/mdev = 12.767/16.046/19.759/2.627 ms
root@syncloud:~# wget https://github.com/nextcloud/deck/releases/download/v1.4.2/deck.tar.gz
--2021-06-06 12:14:23--  https://github.com/nextcloud/deck/releases/download/v1.4.2/deck.tar.gz
Resolving github.com (github.com)... 140.82.113.4
Connecting to github.com (github.com)|140.82.113.4|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://github-releases.githubusercontent.com/79368515/79e59a80-ac00-11eb-878f-d05f1c5c6d2c?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20210606%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20210606T161423Z&X-Amz-Expires=300&X-Amz-Signature=7657ded53b66bbb486a2000338135c17d2a60a965884f36f56b626d50c849570&X-Amz-SignedHeaders=host&actor_id=0&key_id=0&repo_id=79368515&response-content-disposition=attachment%3B%20filename%3Ddeck.tar.gz&response-content-type=application%2Foctet-stream [following]
--2021-06-06 12:14:23--  https://github-releases.githubusercontent.com/79368515/79e59a80-ac00-11eb-878f-d05f1c5c6d2c?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20210606%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20210606T161423Z&X-Amz-Expires=300&X-Amz-Signature=7657ded53b66bbb486a2000338135c17d2a60a965884f36f56b626d50c849570&X-Amz-SignedHeaders=host&actor_id=0&key_id=0&repo_id=79368515&response-content-disposition=attachment%3B%20filename%3Ddeck.tar.gz&response-content-type=application%2Foctet-stream
Resolving github-releases.githubusercontent.com (github-releases.githubusercontent.com)... 185.199.111.154, 185.199.108.154, 185.199.110.154, ...
Connecting to github-releases.githubusercontent.com (github-releases.githubusercontent.com)|185.199.111.154|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 6643839 (6.3M) [application/octet-stream]
Saving to: ‘deck.tar.gz’

deck.tar.gz                   100%[=================================================>]   6.34M  13.5MB/s   in 0.5s   

2021-06-06 12:14:24 (13.5 MB/s) - ‘deck.tar.gz’ saved [6643839/6643839]

root@syncloud:~#

Seems I am getting errors listed in the logs and this is what comes up

2021-06-06T12:26:57-0400
Error	internet_connection_check	GuzzleHttp\Exception\ConnectException: cURL error 6: Could not resolve host: www.eff.org (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for http://www.eff.org/	
2021-06-06T12:26:57-0400
Error	internet_connection_check	GuzzleHttp\Exception\ConnectException: cURL error 6: Could not resolve host: www.startpage.com (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for http://www.startpage.com/	
2021-06-06T12:26:57-0400
Error	internet_connection_check	GuzzleHttp\Exception\ConnectException: cURL error 6: Could not resolve host: www.nextcloud.com (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for http://www.nextcloud.com/	
2021-06-06T12:26:57-0400

try to ping them:

ping www.eff.org
ping www.startpage.com
ping www.nextcloud.com
root@syncloud:~# ping www.eff.org
PING eff.map.fastly.net (151.101.116.201) 56(84) bytes of data.
64 bytes from 151.101.116.201: icmp_seq=1 ttl=59 time=10.8 ms
64 bytes from 151.101.116.201: icmp_seq=2 ttl=59 time=13.5 ms
64 bytes from 151.101.116.201: icmp_seq=3 ttl=59 time=6.03 ms
64 bytes from 151.101.116.201: icmp_seq=4 ttl=59 time=9.32 ms
64 bytes from 151.101.116.201: icmp_seq=5 ttl=59 time=12.0 ms
^C
--- eff.map.fastly.net ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4006ms
rtt min/avg/max/mdev = 6.039/10.363/13.524/2.566 ms
root@syncloud:~# ping www.startpage.com
PING startpage.com (216.218.239.42) 56(84) bytes of data.
64 bytes from 216.218.239.42: icmp_seq=1 ttl=58 time=76.3 ms
64 bytes from 216.218.239.42: icmp_seq=2 ttl=58 time=78.9 ms
64 bytes from 216.218.239.42: icmp_seq=3 ttl=58 time=72.3 ms
64 bytes from 216.218.239.42: icmp_seq=4 ttl=58 time=75.4 ms
64 bytes from 216.218.239.42: icmp_seq=5 ttl=58 time=77.6 ms
^C
--- startpage.com ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4005ms
rtt min/avg/max/mdev = 72.326/76.141/78.927/2.256 ms
root@syncloud:~# ping www.nextcloud.com
PING www.nextcloud.com (95.217.53.153) 56(84) bytes of data.
64 bytes from nextcloud.com (95.217.53.153): icmp_seq=1 ttl=54 time=109 ms
64 bytes from nextcloud.com (95.217.53.153): icmp_seq=2 ttl=54 time=112 ms
64 bytes from nextcloud.com (95.217.53.153): icmp_seq=3 ttl=54 time=115 ms
64 bytes from nextcloud.com (95.217.53.153): icmp_seq=4 ttl=54 time=108 ms
64 bytes from nextcloud.com (95.217.53.153): icmp_seq=5 ttl=54 time=111 ms
^C
--- www.nextcloud.com ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4005ms
rtt min/avg/max/mdev = 108.267/111.260/115.239/2.484 ms
root@syncloud:~# 

Ok can you run oneore time

snap run nextcloud.occ app:install deck

And then send logs from Settings - Support?

I had to mv the deck.tar.gz to /var/snap/nextcloud/current/extra-apps and then untar it to get that to work, so it works, but the server internet connection issues persists.

If you do the above I could help you

Yeah I submitted the logs just as I posted here, so you should have them as support was cc’d

Ok log is full of errors about not able to resolve hosts. Similar to this question (with no answer) NextcloudPi appstore cUrl error 6, can't install anything! - #5 by ctinleonard - 📦 Appliances (Docker, Snappy, VM, NCP) - Nextcloud community

One option is to reinstall nextcloud which will remove all custom settings if any.
Let me know if you are ok to o do that?

Or I can try to give you few commands to try understanding why php cannot download files.

Another option is to try to remove pihole to see if that helps as it is a DNS forwarder which may be related (usually it is not)