docs:tips_n_tricks:nextcloud.html
Table of Contents
Nextcloud
Troubleshooting locks
Logging locks
- config.php.patch
--- config.php.orig 2025/01/11 11:02:10 +++ config.php 2025/01/11 11:02:11 @@ -29,3 +29,4 @@ 'log_type' => 'file', 'logtimezone' => 'UTC', + 'filelocking.debug' => true, );
Find files and expiry
~$ echo -n 'home::peter::files/Documents/About.txt' | md5sum | awk '{print "files/"$1}' files/64b3e23bb2d4bf9c284dee81de153a65 ~$ cd /var/lib/nextcloud/data/ # your data dir might be somewhere else ... ~$ sqlite3 --cmd '.header on' owncloud.db 'SELECT ttl FROM oc_file_locks WHERE KEY="files/64b3e23bb2d4bf9c284dee81de153a65";' 636892|-1|files/64b3e23bb2d4bf9c284dee81de153a65|1736598723 ~$ date -d @`sqlite3 owncloud.db 'SELECT ttl FROM oc_file_locks WHERE KEY="files/64b3e23bb2d4bf9c284dee81de153a65";'` Sat Jan 11 12:53:01 UTC 2025 ~$ sqlite3 --cmd '.separator \t \n' --cmd '.headers on' owncloud.db 'SELECT id,lock,strftime("%Y-%m-%d %H:%M:%S",ttl,"unixepoch","localtime") AS Timestamp,key FROM oc_file_locks WHERE lock > 0 AND ttl >= strftime("%s","now") ORDER BY ttl ASC LIMIT 20;' id lock Timestamp key 594786 2 2025-01-12 01:42:20 files/724420cd1df913fa109950d75ff86a8c 594787 2 2025-01-12 01:42:20 files/db90de96feaf1431aec0e175272915bd 594788 2 2025-01-12 01:42:21 files/7215d0b2b3918163e38c04db929c616f 633606 2 2025-01-12 01:42:21 files/3c5cfd54ca1b9aa52ddf53e519c6ecaa 633607 2 2025-01-12 01:42:21 files/8b4d19c8fad691dd9fb4aac377a79b32 629846 2 2025-01-12 01:54:06 files/08608388ab9388d0ff8f929e37083787 594771 29 2025-01-12 01:55:02 files/14f3becba9007876dd5cc797f174739c 594816 7 2025-01-12 01:55:03 files/b4e69986ee606ca892ad3645ba7a6f28 594817 3 2025-01-12 01:55:03 files/d5869ca367cf034080f6138c76f6466f 594818 5 2025-01-12 01:55:04 files/58eaf399656f0b7b5fe81da63c149e79 594819 5 2025-01-12 01:55:04 files/ada037dbc4c386f1adb2c24bd13cc4c5
- mk_file_key_list.sh
max="`sqlite3 owncloud.db 'SELECT count(*) FROM oc_filecache;'`" sqlite3 owncloud.db 'SELECT stor.id||"::"||fcache.path FROM oc_filecache AS fcache JOIN oc_storages AS stor ON fcache.storage = stor.numeric_id ;' \ | while read line do printf '%s : %s\n' \ "`echo -n \"$line\" | md5sum | awk '{print \"files/\"$1}'`" \ "$line" done \ | pv -l -s "$[max}" > /tmp/file_key_list.txt
Tagged pages (tag plugin)
Indexed pages (subjectindex plugin)
1)
Just in case, Nextcloud deletes the original while conducting their plans to clean up the forum
docs/tips_n_tricks/nextcloud.html.txt · Last modified: 12.01.2025 01:53 CET by peter