[SAC] [OSGeo] #2243: Upgrade to nextcloud 15.0.0.2

Committees SAC mailing list
1

#2243: Upgrade to nextcloud 15.0.0.2
---------------------------+-----------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone:
Component: Systems Admin | Keywords: nextcloud
---------------------------+-----------------------
We are running nextcloud 15.0.0 and 15.0.0.2 came out a couple of days
ago. It doesn't have that many bug fixes, but the 15.0.0.1 version does
have a lot of bug fixes.

I did an experimental upgrade and it will require probably about 30minutes
- 1 hour of downtime.

They have an online upgrade which I tried but it timed out doing backup
etc, and since we don't really need our data backed up since I can
snapshot the container before upgrade, seems better to go with the manual
upgrade.

I'm also thinking of moving the data folder out of nextcloud folder and
have on same level

I took the defaults during install which created a path like this:

{{{
/var/www/nextcloud
/var/www/nextcloud/data
}}}

I'd like to change it to this:

{{{
/var/www/nextcloud
/var/www/nextcloud-data
}}}

Main reasons for changing it, is

1) I think it's better to not have the data in the web folder just in case
their is na nginx misconfiguration and it makes that exposed.

2) During these upgrades the upgrade steps are to

mv nextcloud nextcloud-old

and then copy/move over the data folder and any 3rd party apps you may
have.
I would do the move since I would do a snapshot of the vm anyway before
hand.
I'd much rather not having to worry about moving/copying the data folder
back in place.

I've taken a backup of the nextcloud image and other containers until we
have the general backup routine sorted out.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2243&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

2

#2243: Upgrade to nextcloud 15.0.0.2
---------------------------+--------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone:
Component: Systems Admin | Resolution:
Keywords: nextcloud |
---------------------------+--------------------

Comment (by robe):

Forgot link to change log https://nextcloud.com/changelog/#latest15

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2243#comment:1&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

3

#2243: Upgrade to nextcloud 15.0.0.2
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2019-I
Component: Systems Admin | Resolution:
Keywords: nextcloud |
---------------------------+---------------------------------------
Changes (by robe):

* milestone: => Sysadmin Contract 2019-I

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2243#comment:2&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

4

#2243: Upgrade to nextcloud 15.0.5
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2019-I
Component: Systems Admin | Resolution:
Keywords: nextcloud |
---------------------------+---------------------------------------

Comment (by robe):

New version is now 15.0.5.

I'm going to do some minor updates (collabora and group folders) to the
plugins for now and deal with this upgrade later.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2243#comment:3&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

5

#2243: Upgrade to nextcloud 15.0.5
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2020-I
Component: Systems Admin | Resolution:
Keywords: nextcloud |
---------------------------+---------------------------------------
Changes (by robe):

* milestone: Sysadmin Contract 2019-II => Sysadmin Contract 2020-I

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2243#comment:5&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

6

#2243: Upgrade to nextcloud latest
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2020-I
Component: Systems Admin | Resolution:
Keywords: nextcloud |
---------------------------+---------------------------------------
Description changed by robe:

Old description:

We are running nextcloud 15.0.0 and 15.0.0.2 came out a couple of days
ago. It doesn't have that many bug fixes, but the 15.0.0.1 version does
have a lot of bug fixes.

I did an experimental upgrade and it will require probably about
30minutes - 1 hour of downtime.

They have an online upgrade which I tried but it timed out doing backup
etc, and since we don't really need our data backed up since I can
snapshot the container before upgrade, seems better to go with the manual
upgrade.

I'm also thinking of moving the data folder out of nextcloud folder and
have on same level

I took the defaults during install which created a path like this:

{{{
/var/www/nextcloud
/var/www/nextcloud/data
}}}

I'd like to change it to this:

{{{
/var/www/nextcloud
/var/www/nextcloud-data
}}}

Main reasons for changing it, is

1) I think it's better to not have the data in the web folder just in
case their is na nginx misconfiguration and it makes that exposed.

2) During these upgrades the upgrade steps are to

mv nextcloud nextcloud-old

and then copy/move over the data folder and any 3rd party apps you may
have.
I would do the move since I would do a snapshot of the vm anyway before
hand.
I'd much rather not having to worry about moving/copying the data folder
back in place.

I've taken a backup of the nextcloud image and other containers until we
have the general backup routine sorted out.

New description:

Current version is 18

We are running nextcloud 15.0.0 and 15.0.0.2 came out a couple of days
ago. It doesn't have that many bug fixes, but the 15.0.0.1 version does
have a lot of bug fixes.

I did an experimental upgrade and it will require probably about 30minutes
- 1 hour of downtime.

They have an online upgrade which I tried but it timed out doing backup
etc, and since we don't really need our data backed up since I can
snapshot the container before upgrade, seems better to go with the manual
upgrade.

I'm also thinking of moving the data folder out of nextcloud folder and
have on same level

I took the defaults during install which created a path like this:

{{{
/var/www/nextcloud
/var/www/nextcloud/data
}}}

I'd like to change it to this:

{{{
/var/www/nextcloud
/var/www/nextcloud-data
}}}

Main reasons for changing it, is

1) I think it's better to not have the data in the web folder just in case
their is na nginx misconfiguration and it makes that exposed.

2) During these upgrades the upgrade steps are to

mv nextcloud nextcloud-old

and then copy/move over the data folder and any 3rd party apps you may
have.
I would do the move since I would do a snapshot of the vm anyway before
hand.
I'd much rather not having to worry about moving/copying the data folder
back in place.

I've taken a backup of the nextcloud image and other containers until we
have the general backup routine sorted out.

--

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2243#comment:6&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

7

#2243: Upgrade to nextcloud latest
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2020-I
Component: Systems Admin | Resolution:
Keywords: nextcloud |
---------------------------+---------------------------------------

Comment (by robe):

okay looks like we need to do 3 upgrades to go to 18 as hopping from 15 ->
18 is not supported.

I'm testing now with backup copy of the nextcloud container on osgeo4 to
make sure no surprises. I'll also move the data folder in the process as
it will make future upgrades easier too.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2243#comment:7&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

8

#2243: Upgrade to nextcloud latest
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2020-I
Component: Systems Admin | Resolution:
Keywords: nextcloud |
---------------------------+---------------------------------------

Comment (by pcav):

FYI: just upgraded our NC instance (17>18). We ran into small issues,
running upgrade twice solved it effectively.
I'm available for help if necessary.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2243#comment:8&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

9

#2243: Upgrade to nextcloud latest
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2020-I
Component: Systems Admin | Resolution:
Keywords: nextcloud |
---------------------------+---------------------------------------

Comment (by pcav):

See: https://github.com/nextcloud/server/issues/18997

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2243#comment:9&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

10

#2243: Upgrade to nextcloud latest
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2020-I
Component: Systems Admin | Resolution:
Keywords: nextcloud |
---------------------------+---------------------------------------

Comment (by robe):

pcav,

Yah I think they might have already fixed this issue in 18.0.3. I did a
trial run of upgrading nextcloud from 15 - 18 using a backup of production
system and didn't run into any issues except for 1. I did run into a blip
but I think that was because I forgot to turn off the nextcloud cron job.
Rerunning upgrade fix it. Anyway going to start the upgrade soon. Thanks
for the input.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2243#comment:10&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

11

#2243: Upgrade to nextcloud latest
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2020-I
Component: Systems Admin | Resolution:
Keywords: nextcloud |
---------------------------+---------------------------------------

Comment (by robe):

pcav,

One question I was wondering about. Are you using the new
documentserver_community extension (Only office integrated document
editing).

I was experimenting with using that instead of the collabora online we are
currently using for viewing/editing office / libreoffice docs, but I
couldn't get it to work. Said it was installed but documents weren't
editable.

I also read that it doesn't scale well and some issues with documents
being saved with it, so was thinking maybe I should just stick with the
collabora office online we have already. Only reason I wanted to switch
is I liked the idea it was self-contained. Right now I have a collabora
container set up for handling the document editing/viewing features.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2243#comment:11&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

12

#2243: Upgrade to nextcloud latest
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2020-I
Component: Systems Admin | Resolution:
Keywords: nextcloud |
---------------------------+---------------------------------------

Comment (by pcav):

Hi @robe,
we have just started experimenting. AFAICT the collaborative editing
installed by default (I think it is called `text`) is good enough for our
purposes. I'd prefer a text-based editor (.md) to a complex one (.odt or
similar).

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2243#comment:12&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

13

#2243: Upgrade to nextcloud latest
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: closed
Priority: normal | Milestone: Sysadmin Contract 2020-I
Component: Systems Admin | Resolution: fixed
Keywords: nextcloud |
---------------------------+---------------------------------------
Changes (by robe):

* status: new => closed
* resolution: => fixed

Comment:

pcav,

Yah the text one is a separate. I just completed the upgrade to 18.0.3 so
please give it a try and see if you run into any issues.

I did run into issue with 18 upgrade (when I ran into it on dev, I thought
it was because cron was on but this time I had it off).

The error was

#got this error - Repair error: Repair step
'OCA\Talk\Migration\FixNamespaceInDatabaseTables' is unknown

So to fix I change turned off maintenance and reran again.

It succeeded but looks like it disabled the Talk plugin which I don't
think we were using anyway. I haven't tried reenabling it. That looks to
be a different error than what was described in the link referenced above.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2243#comment:13&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

14

#2243: Upgrade to nextcloud latest
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: closed
Priority: normal | Milestone: Sysadmin Contract 2020-I
Component: Systems Admin | Resolution: fixed
Keywords: nextcloud |
---------------------------+---------------------------------------

Comment (by pcav):

Thanks a lot. Looks pretty slow for now, but it does what it is supposed
to do.
We used Talk, it would not be bad to have it back, but if it's complicated
don't worry.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2243#comment:14&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

15

#2243: Upgrade to nextcloud latest
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: closed
Priority: normal | Milestone: Sysadmin Contract 2020-I
Component: Systems Admin | Resolution: fixed
Keywords: nextcloud |
---------------------------+---------------------------------------

Comment (by robe):

Okay I'll try to enable it and see what happens. It did seem a little
slow to me too but wasn't sure if its because I moved the data directory
and its still building the database cache.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2243#comment:15&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

16

#2243: Upgrade to nextcloud latest
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: closed
Priority: normal | Milestone: Sysadmin Contract 2020-I
Component: Systems Admin | Resolution: fixed
Keywords: nextcloud |
---------------------------+---------------------------------------

Comment (by robe):

pcav I reenabled Talk app and it seemed to reenable okay. Then it wanted
me to join into an old call. Not sure what that was about. Anyway give
it a try and see if it still works as you expect.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2243#comment:16&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

17

#2243: Upgrade to nextcloud latest
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: closed
Priority: normal | Milestone: Sysadmin Contract 2020-I
Component: Systems Admin | Resolution: fixed
Keywords: nextcloud |
---------------------------+---------------------------------------

Comment (by pcav):

Checked, apparently it works. I did not try with several users however
(none available right now).
I think it's OK.
Thanks again!

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2243#comment:17&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

18

#2243: Upgrade to nextcloud latest
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: closed
Priority: normal | Milestone: Sysadmin Contract 2020-I
Component: Systems Admin | Resolution: fixed
Keywords: nextcloud |
---------------------------+---------------------------------------

Comment (by robe):

I also figured out why my install of document server did not work. I was
missing the step of enabling the onlyoffice app. I'm going to change to
the onlyoffice one from collabora online so the document management is all
self-contained, no longer reliant on another container.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2243#comment:18&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

19

#2243: Upgrade to nextcloud latest
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: closed
Priority: normal | Milestone: Sysadmin Contract 2020-I
Component: Systems Admin | Resolution: fixed
Keywords: nextcloud |
---------------------------+---------------------------------------

Comment (by robe):

scratch that thought I did some tests on nextcloud.gallery.osgeo.org and
it appears that onlyoffice handles MS office documents really well, but
not as good as collabora online for open office. It also can't open my
open office drawings (.odg files) where as collabora can. So I guess
maybe I'll just upgrade collabora and keep using it, cause both can't be
turned on I don't htink as they would both try to handle the same files.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2243#comment:19&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

20

#2243: Upgrade to nextcloud latest
---------------------------+---------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: closed
Priority: normal | Milestone: Sysadmin Contract 2020-I
Component: Systems Admin | Resolution: fixed
Keywords: nextcloud |
---------------------------+---------------------------------------

Comment (by pcav):

Slowness has been reported. From the mail:
It probably took me 10 times longer to make my edits than it would have in
google docs. A lot of the time I would type and it would not respond, and
then ten seconds later suddenly play all my keystrokes at once like in
this gif (I am typing pretty much the whole time in the recording):

It also seems to be unable to allow me to double click words to highlight
them. I had to also reload the page completely a few times because it just
froze.

https://lists.osgeo.org/pipermail/qgis-psc/2020-April/008580.html

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2243#comment:20&gt;
OSGeo <https://osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.