How can I check what Nextcloud user is active

[JaredBusch]

@momurda said in How can I check what Nextcloud user is active:

on my nc 12 server
cat /var/log/apache2/access.log
shows me all the web requests as well as username making them

edit: debian 9 NC server

Have you ever seriously tried to monitor the log file for a site with ~80 users all using the sync client? Chatty is an understatement.

[momurda]

Yea i know, but at night when you posted the log probably was less active. Someone might want to make a NC feature request if there isnt one already.

[black3dynamite]

@momurda said in How can I check what Nextcloud user is active:

Yea i know, but at night when you posted the log probably was less active. Someone might want to make an NC feature request if there isnt one already.

How can one tell if the user is accessing from desktop/mobile app, WebDAV or web browser in the access logs?

[momurda]

@black3dynamite I am working on that now
I think something like
grep ncusername /var/log/apache2/access.log | grep PUT
^This one shows up when using NC sync client and editing/saving a file
grep ncusername /var/log/apache2/access.log | grep DELETE
^This one shows up when deleting things from Windows Explorer and then the sync client sync the change to NC.

edit, these arent quite right yet but a good starting point i think.
You dont know the username in this case so
grep dav /var/log/apache2/access.log | grep PUT
This will return all log entries of all users who have made changes with the sync client. It makes a log entries every file change, so the result list will be quite long.
You would need to glance at the results and look at the users that shows up the most i think. After hours this would lead you to the culprit.

edit: PUT is the function used when saving a changed/edited file.
grep dav /var/log/apache2/access.log | grep PUT
This gives you a list of user and files edited in current access.log using the NC sync client. With this you can change your next query to use a specific username that shows up a lot, like my first examples.

If you want to find the # of edited files in access log add | wc -l to the end which will give the number of files changed. change the username based on results from previous query. When you see a huge number returned that would probably be the person.
grep ncusername /var/log/apache2/access.log | grep PUT | wc -l

But all this seems like much work(and still not quite right) compared to getting NC to put this info in the Web UI.

[JaredBusch]

So, upgrading....

Nextcloud (and ownCloud before) always say to upgrade without skiping anything, but never to skip a major version.

As I am on the last version of 9 with this instance, Should I upgrade to 10.0.1 or straight to 10.0.6?
https://nextcloud.com/changelog/#latest10

And then subsequently? Point releases and then majors?
Or should I just do the latest 10, latest, 11, latest 12, and finally current 13?

[Alex Sage]

@jaredbusch build a new VM, and move the config and data over

https://docs.nextcloud.com/server/12/admin_manual/maintenance/migrating.html

[JaredBusch]

@aaronstuder said in How can I check what Nextcloud user is active:

@jaredbusch build a new VM, and move the config and data over

https://docs.nextcloud.com/server/12/admin_manual/maintenance/migrating.html

Was what I posted hard to understand?

You obviously have no idea how many sync issues that type of thing causes.

[dbeato]

@jaredbusch said in How can I check what Nextcloud user is active:

So, upgrading....

Nextcloud (and ownCloud before) always say to upgrade without skiping anything, but never to skip a major version.

As I am on the last version of 9 with this instance, Should I upgrade to 10.0.1 or straight to 10.0.6?
https://nextcloud.com/changelog/#latest10

And then subsequently? Point releases and then majors?
Or should I just do the latest 10, latest, 11, latest 12, and finally current 13?

I would do point releases and then majors as outlined here:

https://nextcloud.com/migration

[JaredBusch]

Well looking closer, there are no minor Nextcloud releases. Only bug fix releases..

So that means upgrade to 10.0.x, then 11.0.x, then 12.0.x, and finally 13.0.x.

[JaredBusch]

No problem upgrading to 10.0.6.

Now I even have the option to use the built in updater.

[Alex Sage]

@jaredbusch from step 4 The data files should keep their original timestamp (can be done by using rsync with -t option) otherwise the clients will re-download all the files after the migration. Depending on the original installation

[JaredBusch]

@aaronstuder said in How can I check what Nextcloud user is active:

@jaredbusch from step 4 The data files should keep their original timestamp (can be done by using rsync with -t option) otherwise the clients will re-download all the files after the migration. Depending on the original installation

Would you stop already because that is not the supported upgrade method.

FFS.

[JaredBusch]

11.0.7 looking good.

success

[JaredBusch]

At least I am up to a supported version now.

[JaredBusch]

To do the 9 to 10upgrade, I renamed the owncloud directory, downloaded the Nextcloud bz2 and extracted it as owncloud.
My data is in a different folder.
I copied the config back in and reset ownership and permissions, as well as reset SELinux permissions.

This system started life as ownCloud 7 or something like that. So it couldn’t hurt to clean the root folder up totally.

[scottalanmiller]

That's a lot of updates over the years!

[JaredBusch]

@scottalanmiller said in How can I check what Nextcloud user is active:

That's a lot of updates over the years!

Yup, one more to go now. as I just finished the upgrade 12.0.5

[JaredBusch]

and done..

PHP 7later tonight..

[JaredBusch]

And PHP 7.1 set.

[JaredBusch]