Koozali.org: home of the SME Server

Nextcloud updates - NC24 and mariadb migration for existing installs

Offline Jean-Philippe Pialasse

  • *
  • 2,747
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Re: Nextcloud updates - NC24 and mariadb migration for existing installs
« Reply #15 on: September 12, 2022, 04:04:06 AM »
Is it safe to upgrade to 24.0.5 if nextcloud Security & setup warnings report All checks passed?

security no issue.
only issue, is to first check that all needed extension are available for you before proceeding !
if you only use core just go, if you heavily rely on a lot of modules check the pre update messages about plugins...

Offline Randall

  • *
  • 35
  • +0/-0
Re: Nextcloud updates - NC24 and mariadb migration for existing installs
« Reply #16 on: October 01, 2022, 09:07:23 PM »
Last night I applied SME updates via UI, and this morning I discovered that NextCloud (still on 20.0.1-1.el7.sme) is now broken - <my server>/nextcloud now appears to point to default web page (Under Construction). Could that be related to this, or is this some new issue ? Thanks

Offline Jean-Philippe Pialasse

  • *
  • 2,747
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Re: Nextcloud updates - NC24 and mariadb migration for existing installs
« Reply #17 on: October 01, 2022, 10:27:33 PM »
broken? wait a little before this conclusion.

i would rather say not displaying what you expect. thus not accessible would be more appropriate.


what returns
Code: [Select]
/sbin/e-smith/audittools/templates | grep http
Code: [Select]
config show nextcloud |egrep -vi 'pass|secre'
have you configured a dedicated domain?

have tried

Code: [Select]
signal-event nextcloud-update

Offline Randall

  • *
  • 35
  • +0/-0
Re: Nextcloud updates - NC24 and mariadb migration for existing installs
« Reply #18 on: October 01, 2022, 11:05:29 PM »
Thanks for the reply. Broken being the technical term to say it's not functioning correctly ;)

No, I haven't set up a dedicated domain, just the stock install. I have been having issues with the www group being removed from the shared group (https://forums.koozali.org/index.php/topic,54851.15.html), so not sure if that's related.

Here's the output of the suggested commands:
[root@e-smith ~]# /sbin/e-smith/audittools/templates | grep http
[root@e-smith ~]# config show nextcloud |egrep -vi 'pass|secre'
nextcloud=service
    AdminUser=nextcloudadmin
    DbName=nextcloud
    DbUser=nextcloud
    TrustedDomains=
    access=public
    status=enabled
[root@e-smith ~]# signal-event nextcloud-update

The signal event didn't seem to help (tried reboot after as well, no change).

Somehow nextcloud appears to be directed to default doc. Not familiar with how this is supposed to work ...

Offline monoman

  • **
  • 45
  • +0/-0
Re: Nextcloud updates - NC24 and mariadb migration for existing installs
« Reply #19 on: October 01, 2022, 11:26:44 PM »
broken? wait a little before this conclusion.

i would rather say not displaying what you expect. thus not accessible would be more appropriate.


what returns
Code: [Select]
/sbin/e-smith/audittools/templates | grep http
Code: [Select]
config show nextcloud |egrep -vi 'pass|secre'
have you configured a dedicated domain?

have tried

Code: [Select]
signal-event nextcloud-update

Randall's issues are almost an exact replica of my issue with the exception that I am running a dedicated domain.  It was at the stage Randall is at that I was getting a 404.

Code: [Select]
[root@mimime ~]# config show nextcloud |egrep -vi 'pass|secre'
nextcloud=service
    AdminUser=nextcloudadmin
    DbName=nextcloud
    DbUser=nextcloud
    IncludeIbay=distribution,distrofiles,jono-artwork,orders,printing,sol-shared
    IncludeIbays=distribution,distrofiles,jono-artwork,orders,printing,sol-shared
    MemoryLimit=4G
    TrustedDomains=www.solportal.com.au,solportal.com.au
    access=public
    status=enabled

I then tried upgrading the nextcloud contrib via signal-event nextcloud-update.  After that, I am getting the update required nextcloud screen, which I am being told is a nextcloud bug, not something caused by the SME upgrades
« Last Edit: October 01, 2022, 11:49:51 PM by monoman »

Offline Randall

  • *
  • 35
  • +0/-0
Re: Nextcloud updates - NC24 and mariadb migration for existing installs
« Reply #20 on: October 01, 2022, 11:36:25 PM »
Thanks for that. So it seems likely that upgrading NextCloud will fix it ...

Offline monoman

  • **
  • 45
  • +0/-0
Re: Nextcloud updates - NC24 and mariadb migration for existing installs
« Reply #21 on: October 01, 2022, 11:49:18 PM »
Thanks for that. So it seems likely that upgrading NextCloud will fix it ...

That has not been my experience.

Offline Jean-Philippe Pialasse

  • *
  • 2,747
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Re: Nextcloud updates - NC24 and mariadb migration for existing installs
« Reply #22 on: October 02, 2022, 03:52:09 AM »
@monoman those are likely two different situations.

On yours you had a 404, then a 403 error, which were one kind of error against httpd, and I am still waiting for you to show the logs so I can find a way to reproduce this step.
Then you are now on a state were you have a db that prevent you to update from one version to another because some field are missing on some table and some other table are present while they should not.
Please keep on your initial post.



@Randall,
you also have an issue right now with httpd access, this is not nextcloud issue, this is SME side. So do not try to fix nextcloud you just do not have access to it but your ibay instead.

I would need two things to help you from there :
content of /var/log/messages* during the signal-event temp right after the update of smeserver-nextcloud.

current /etc/httpd/conf/httpd.conf

you could send it to  security@lists.contribs.org


you could also report here
Code: [Select]
occ status
looking forward

Offline Randall

  • *
  • 35
  • +0/-0
Re: Nextcloud updates - NC24 and mariadb migration for existing installs
« Reply #23 on: October 02, 2022, 06:30:08 AM »
I have just forwarded log, extending from just before reconfig to present, and config as requested (I got a notice that it Is being held until the list moderator can review it for approval). I notice there a some jumps in the log time - I think I may have a hardware clock that needs to be updated. You'll also see numerous reboots and reconfigs, and I've tried various things (including fixing the shared group to include www).

I should also mention that I have made no effort to ugrade nextcloud itself - it is still at 20.0.1.
« Last Edit: October 02, 2022, 06:43:37 AM by Randall »

Offline Jean-Philippe Pialasse

  • *
  • 2,747
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Re: Nextcloud updates - NC24 and mariadb migration for existing installs
« Reply #24 on: October 02, 2022, 07:47:49 AM »
I see in messages
Code: [Select]
Sep 30 23:38:51 e-smith esmith::event[3798]: Processing event: temp#no nextcloud update !
Code: [Select]
Sep 30 23:41:43 e-smith esmith::event[5562]: Processing event: post-upgrade
Sep 30 23:43:09 e-smith esmith::event[8669]: Processing event: reboot
Sep 30 23:44:12 e-smith esmith::event[686]: Processing event: bootstrap-console-save
Oct  1 00:01:05 e-smith esmith::event[3844]: Processing event: reboot
Oct  1 10:10:19 e-smith esmith::event[8572]: Processing event: post-upgrade
Oct  1 10:12:22 e-smith esmith::event[11852]: Processing event: reboot
Oct  1 10:14:49 e-smith esmith::event[681]: Processing event: bootstrap-console-save
Oct  1 14:42:59 e-smith esmith::event[3205]: Processing event: post-upgrade
Oct  1 14:44:54 e-smith esmith::event[6485]: Processing event: reboot
Oct  1 14:47:17 e-smith esmith::event[682]: Processing event: bootstrap-console-save
Oct  1 14:56:00 e-smith esmith::event[3783]: Processing event: reboot


in term of warning /errors, only issue I see not related is
Oct  1 10:14:48 e-smith initializedate: Exiting, name server cannot be used: Temporary failure in name resolution (-3) 1 Oct 10:14:48 ntpdate[688]: name server cannot be used: Temporary failure in name resolution (-3)

I never saw any smeserver-nextcloud.
I do not see any contribs update.  There is only one temp event in the whole log
I would say you might not have the smecontribs enabled, and you still have a very old version not compatible with the new  apache.
See alert about it on the wiki release page and in the SME 10 forum.

Code: [Select]
rpm -q smeserver-nextcloud
should show 1.2.0-19

looking at your httpd, I can confirm you do not use the compatible smeserver-nextcloud version.


you should keep enabled smecontribs.

Offline Randall

  • *
  • 35
  • +0/-0
Re: Nextcloud updates - NC24 and mariadb migration for existing installs
« Reply #25 on: October 02, 2022, 07:23:08 PM »
You were correct. Contribs updates were disabled (I have never touched these settings, so maybe a remnant of upgrade from some old SME version). I enabled it, and then issued
yum update --enablerepo=smecontribs
signal-event post-upgrade;  signal-event reboot
(needed to fix shared group membership, because www is always removed after reconfig for some unknown reason, and reboot again)

It's a bit slow to start, but NextCloud now appears to be working. Eureka !
Once again, thanks again for your prompt help. I'm a bit of a dummy when it comes to administering some of this stuff, because during probably 15 years or more of using it, I rarely have to go beyond UI point and click - a real testament to the usability and stability of SME !

Offline Jean-Philippe Pialasse

  • *
  • 2,747
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Re: Nextcloud updates - NC24 and mariadb migration for existing installs
« Reply #26 on: October 02, 2022, 08:52:33 PM »
great news!

can you list your contribs to see which one might play on the www/shared thing?

Offline Randall

  • *
  • 35
  • +0/-0
Re: Nextcloud updates - NC24 and mariadb migration for existing installs
« Reply #27 on: October 02, 2022, 09:58:35 PM »
Sure. Here's the full list:
Code: [Select]
GeoIP.x86_64                           1.6.12-9.el7.sme        @smecontribs     
GeoIP-GeoLite-data.noarch              2018.06-7.el7.sme       @smecontribs     
GeoIP-GeoLite-data-extra.noarch        2018.06-7.el7.sme       @smecontribs     
ddclient.noarch                        3.9.1-2.el7.sme         @smecontribs     
jq.x86_64                              1.6-2.el7               @smecontribs     
nextcloud.noarch                       20.0.1-1.el7.sme        @smecontribs     
nextcloud-src.noarch                   24.0.2-3.el7.sme        @smecontribs     
oniguruma.x86_64                       6.8.2-2.el7             @smecontribs     
perl-Array-Compare.noarch              3.0.0-1.of.el7          @smecontribs     
perl-B-Hooks-OP-Check.x86_64           0.22-1.of.el7           @smecontribs     
perl-Class-Method-Modifiers.noarch     2.13-1.of.el7           @smecontribs     
perl-Class-XSAccessor.x86_64           1.19-2.el7              @smecontribs     
perl-Data-Validate-IP.noarch           0.27-13.el7             @smecontribs     
perl-Devel-GlobalDestruction.noarch    0.14-1.of.el7           @smecontribs     
perl-Lexical-SealRequireHints.x86_64   0.011-1.of.el7          @smecontribs     
perl-Module-Runtime.noarch             0.016-1.of.el7          @smecontribs     
perl-Moo.noarch                        2.004004-2.of.el7       @smecontribs     
perl-Params-Classify.x86_64            0.013-7.el7             @smecontribs     
perl-Role-Tiny.noarch                  2.001004-1.of.el7       @smecontribs     
perl-Sub-Exporter-Progressive.noarch   0.001013-1.of.el7       @smecontribs     
perl-Sub-Name.x86_64                   0.26-1.of.el7           @smecontribs     
perl-Sub-Quote.noarch                  2.006006-1.of.el7       @smecontribs     
perl-bareword-filehandles.x86_64       0.007-1.of.el7          @smecontribs     
perl-indirect.x86_64                   0.39-1.of.el7           @smecontribs     
perl-multidimensional.x86_64           0.014-1.of.el7          @smecontribs     
perl-strictures.noarch                 2.000006-1.of.el7       @smecontribs     
rh-mariadb105.x86_64                   3.7-1.el7               @smecontribs     
rh-mariadb105-mariadb.x86_64           3:10.5.9-2.el7          @smecontribs     
rh-mariadb105-mariadb-common.x86_64    3:10.5.9-2.el7          @smecontribs     
rh-mariadb105-mariadb-config.x86_64    3:10.5.9-2.el7          @smecontribs     
rh-mariadb105-mariadb-errmsg.x86_64    3:10.5.9-2.el7          @smecontribs     
rh-mariadb105-mariadb-libs.x86_64      3:10.5.9-2.el7          @smecontribs     
rh-mariadb105-mariadb-server.x86_64    3:10.5.9-2.el7          @smecontribs     
rh-mariadb105-mariadb-server-utils.x86_64
                                       3:10.5.9-2.el7          @smecontribs     
rh-mariadb105-runtime.x86_64           3.7-1.el7               @smecontribs     
smeserver-ddclient.noarch              1.3.0-23.el7.sme        @smecontribs     
smeserver-dhcp-dns.noarch              1.2.0-5.el7.sme         @smecontribs     
smeserver-mariadb105.noarch            2.7.0-16.el7.sme        @smecontribs     
smeserver-nextcloud.noarch             1.2.0-19.el7.sme        @smecontribs     
smeserver-wsdd.noarch                  0.2-5.el7.sme           @smecontribs     
wsdd.noarch                            0.7.0-1.el7             @smecontribs