Cloudron Forum

@nebulon said in Issues after full disk:

Have you worked through https://docs.cloudron.io/troubleshooting/#recovery-after-disk-full already?

yep, what I found was DNS stopped and the log from journalctl.

Do I have to recover MySQL?

@nebulon said in Issues after full disk:

For Nextclou specifically, it keeps trying to write .php files onto disk, which get corrupted if there is no disk space available

I restored Nextcloud App from a backup. Everything should be fine then, if it was before disk was full? Or some config to be done?

@nebulon said in Issues after full disk:

If the server runs out of space many things may be shaky.

Why did it even happen? Why do I not get quota warning?
Now I have to deal with a corrupted installation

Hi there, my Nextcloud caused some trouble, when my server disc was full, cause of docker-volumes.
Excactly this issue https://forum.cloudron.io/topic/11112/how-to-free-up-disk-space-docker-volumes/3

My Server caused lots of trouble. The DNS unbound stopped. I could not mount my sshfs volumes. After hours I tried creating a new mount, suddenly I could mount the existing volumes and backup storage.

It was still not possible to log in to my Nextcloud. I figured out, config.php was corrupt. Some lines where simply missing. I restored from an backup and could log in again.

But still the Server has some issues. Nextcloud Notes is thowing errors (Saving note has failed HTTP 500 RuntumeException), Collective refuses to open pages (could not fetch pages). But I don't see log entries.

I have now spent hours trying to get the server up and running again.
The fact that the config.php was faulty makes me suspicious, maybe other files are also faulty.
Now I can't get any further and need help.

I did all the troubleshooting in the cloudron docs, scanned Nextcloud and Box logs without finding something.

Looks all fine, except journalctl -xe:

pam_unix(sshd:auth): check pass; user unknown
pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=191.243.149.210
Failed password for invalid user admin from 191.243.149.210 port 33254 ssh2
pam_unix(sshd:auth): check pass; user unknown
Packet dropped: IN=eth0 OUT= MAC=96:00:01:07:41:fe:d2:74:7f:6e:37:e3:08:00 SRC=104.248.135.66 DST=116.202.17.21 LEN=60 TOS=0x00 PREC=0x00 TTL=243 ID=4003 PROTO=T>
Failed password for invalid user admin from 191.243.149.210 port 33254 ssh2
error: Received disconnect from 191.243.149.210 port 33254:3: com.jcraft.jsch.JSchException: Auth cancel [preauth]
Disconnected from invalid user admin 191.243.149.210 port 33254 [preauth]
PAM 1 more authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=191.243.149.210

Most things are doing fine now, files are accessible, synchronization works, cal-dav works.
What I see currently is collective and notes.
My guess is, that appsdata could be corrupt or permission issue?
Some Ideas where to go?

Hi there, also facing this problem.

I found in the documentation this Example Request. Sending this via app terminal creates a subscriber with attributes:

curl -u 'username:password' 'https://listmonk.domain/api/subscribers' -H 'Content-Type: application/json' \
    --data '{"email":"subsriber@domain.com","name":"The Subscriber","status":"enabled","lists":[1],"attribs":{"city":"Bengaluru","projects":3,"stack":{"languages":["go","python"]}}}'

Now I would like to create a form that fills the $data with according information.

this already works:

<?php
 
$username='username';
$password='password';
$URL='https://listmonk.domain/api/subscribers';
	   	 
$data = array(
	'email' => 'name@domain.com',
	'name' => 'name',
	'status' => 'enabled'
	);


$ch = curl_init();
curl_setopt($ch, CURLOPT_URL,$URL);
curl_setopt($ch, CURLOPT_TIMEOUT, 30); //timeout after 30 seconds
curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_ANY);
curl_setopt($ch, CURLOPT_USERPWD, "$username:$password");
curl_setopt($ch, CURLOPT_POSTFIELDS, $data);

$result=curl_exec ($ch);
https://listmonk.domain/api/subscribers' = curl_getinfo($ch, CURLINFO_HTTP_CODE);   //get status code
curl_close ($ch);
	  
echo $result;

?>	  

someone has a idea how to build the $data array conforming listmonk specification? I dont get lists and attribs working.

Also it should be possible to trigger listmonk Douple Opt-in e-mail confirmation.

I don't excactly get your question. Maybe this screen is the answer?

'datadirectory' => '/media/nextcloudbox',

@nebulon said in filescan errors:

if you can browse the filesystem via the webterminal into that app instance, does it look correct?

when I go there, I see the local Data Directory of the app, but not the mounted volume content.
This applies for both instance of Nextcloud

When I navigate to /media/volume in the app Terminal (not File Manager), I can see the users Folders

@nebulon said in filescan errors:

So for nextcloud, you can confirm that using the app itself and downloading/uploading files works just fine, only the file rescanning via occ fails?

yep. I had some issues with umlauts when I migrated. But since long there are no file errors while operating.

@nebulon said in filescan errors:

Do you have other apps which reside in that sshfs mount point and does the filemanger work there?

yes, there is another nextcloud app running on a different domain. Dont have files:scan errors there and I see files via FileManager.

@nebulon said in filescan errors:

may or may not be related to sshfs potentially being slow.

I don't see issues there. nextcloud is working fine.

maybe consider to wait to update to version 28.0.5
https://help.nextcloud.com/t/web-interface-forcing-logout-after-upgrade-to-28-0-5/189651

@nebulon said in filescan errors:

Can you browse the filetree

Yep, no problems here

Nextcloud Log while filescan

May 08 14:42:10- - - [08/May/2024:12:42:10 +0000] "GET /index.php/login HTTP/1.1" 200 7156 "-" "Mozilla (CloudronHealth)"
May 08 14:42:1812:M 08 May 2024 12:42:18.008 * 10000 changes in 60 seconds. Saving...
May 08 14:42:1812:M 08 May 2024 12:42:18.012 * Background saving started by pid 368
May 08 14:42:19368:C 08 May 2024 12:42:19.389 * DB saved on disk
May 08 14:42:19368:C 08 May 2024 12:42:19.391 * Fork CoW for RDB: current 1 MB, peak 1 MB, average 1 MB
May 08 14:42:1912:M 08 May 2024 12:42:19.415 * Background saving terminated with success
May 08 14:42:20- - - [08/May/2024:12:42:20 +0000] "GET /index.php/login HTTP/1.1" 200 7151 "-" "Mozilla (CloudronHealth)"
May 08 14:42:30- - - [08/May/2024:12:42:30 +0000] "GET /index.php/login HTTP/1.1" 200 7155 "-" "Mozilla (CloudronHealth)"
May 08 14:42:40- - - [08/May/2024:12:42:40 +0000] "GET /index.php/login HTTP/1.1" 200 7155 "-" "Mozilla (CloudronHealth)"
May 08 14:42:50- - - [08/May/2024:12:42:50 +0000] "GET /index.php/login HTTP/1.1" 200 7149 "-" "Mozilla (CloudronHealth)"
May 08 14:43:00- - - [08/May/2024:12:43:00 +0000] "GET /index.php/login HTTP/1.1" 200 7157 "-" "Mozilla (CloudronHealth)"
May 08 14:43:10- - - [08/May/2024:12:43:10 +0000] "GET /index.php/login HTTP/1.1" 200 7155 "-" "Mozilla (CloudronHealth)"
May 08 14:43:20- - - [08/May/2024:12:43:20 +0000] "GET /index.php/login HTTP/1.1" 200 7153 "-" "Mozilla (CloudronHealth)"
May 08 14:43:30- - - [08/May/2024:12:43:30 +0000] "GET /index.php/login HTTP/1.1" 200 7154 "-" "Mozilla (CloudronHealth)"
May 08 14:43:40- - - [08/May/2024:12:43:40 +0000] "GET /index.php/login HTTP/1.1" 200 7155 "-" "Mozilla (CloudronHealth)"

Cloudron Box Log while filescan

May 08 14:42:10box:apphealthmonitor app health: 7 running / 3 stopped / 0 unresponsive
...

Via Cloudron File Manager I opend Nextclouds config.php. At the same time the system log shows this

May 08 14:51:23box:server no such route: GET /api/v1/apps/7826f9be-c608-4e53-af12-181aa87f33e2/files/config/config.phpfiles/app-7826f9be-c608-4e53-af12-181aa87f33e2/config%2Fconfig.php?access_token=<redacted>
[ERR_HTTP_HEADERS_SENT]: Cannot set headers after they are sent to the client
at new NodeError (node:internal/errors:399:5)
at ServerResponse.setHeader (node:_http_outgoing:645:11)
at ServerResponse.header (/home/yellowtent/box/node_modules/express/lib/response.js:794:10)
at ServerResponse.json (/home/yellowtent/box/node_modules/express/lib/response.js:275:10)
at ServerResponse.send (/home/yellowtent/box/node_modules/express/lib/response.js:162:21)
at /home/yellowtent/box/node_modules/connect-lastmile/lib/index.js:78:28
at Layer.handle_error (/home/yellowtent/box/node_modules/express/lib/router/layer.js:71:5)
at trim_prefix (/home/yellowtent/box/node_modules/express/lib/router/index.js:326:13)
at /home/yellowtent/box/node_modules/express/lib/router/index.js:286:9
at Function.process_params (/home/yellowtent/box/node_modules/express/lib/router/index.js:346:12)

The folders are in a remote file system mounted via sshfs. When I open FileManger in Cloudron, I don't see a file tree. So no folders at all. But also don't see problems when operating in nextcloud.
When I open that drive with my SFTP-Software, I can see all folders and all show same rights and owner.

Back at cloudron file manager, when I open a different Volume, which is a different Folder mounted from the same drive, I can see the containing folders.

During "Path not found: /username" there is nothing happening in the postgres logs.
But when "Exception during scan: ..." appears in the terminal, postgress logs shows this:

May 08 10:20:142024-05-08 08:20:14.180 UTC [166] user7826f9bec6084e53af12181aa87f33e2@db7826f9bec6084e53af12181aa87f33e2 ERROR: invalid byte sequence for encoding "UTF8": 0xe4 0x63 0x68
May 08 10:20:142024-05-08 08:20:14.180 UTC [166] user7826f9bec6084e53af12181aa87f33e2@db7826f9bec6084e53af12181aa87f33e2 CONTEXT: unnamed portal parameter $8
May 08 10:20:142024-05-08 08:20:14.180 UTC [166] user7826f9bec6084e53af12181aa87f33e2@db7826f9bec6084e53af12181aa87f33e2 STATEMENT: INSERT INTO "oc_filecache" ("mimepart", "mimetype", "mtime", "size", "etag", "storage_mtime", "permissions", "name", "parent", "checksum", "path_hash", "path", "storage") VALUES($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13)
May 08 10:20:142024-05-08 08:20:14.185 UTC [166] user7826f9bec6084e53af12181aa87f33e2@db7826f9bec6084e53af12181aa87f33e2 ERROR: current transaction is aborted, commands ignored until end of transaction block
May 08 10:20:142024-05-08 08:20:14.185 UTC [166] user7826f9bec6084e53af12181aa87f33e2@db7826f9bec6084e53af12181aa87f33e2 STATEMENT: INSERT INTO "oc_filecache" ("mimepart", "mimetype", "mtime", "size", "etag", "storage_mtime", "permissions", "name", "parent", "checksum", "path_hash", "path", "storage") VALUES($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13)
May 08 10:20:142024-05-08 08:20:14.187 UTC [166] user7826f9bec6084e53af12181aa87f33e2@db7826f9bec6084e53af12181aa87f33e2 ERROR: current transaction is aborted, commands ignored until end of transaction block
May 08 10:20:142024-05-08 08:20:14.187 UTC [166] user7826f9bec6084e53af12181aa87f33e2@db7826f9bec6084e53af12181aa87f33e2 STATEMENT: INSERT INTO "oc_filecache" ("mimepart", "mimetype", "mtime", "size", "etag", "storage_mtime", "permissions", "name", "parent", "checksum", "path_hash", "path", "storage") VALUES($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13)
May 08 10:20:142024-05-08 08:20:14.189 UTC [166] user7826f9bec6084e53af12181aa87f33e2@db7826f9bec6084e53af12181aa87f33e2 ERROR: current transaction is aborted, commands ignored until end of transaction block
May 08 10:20:142024-05-08 08:20:14.189 UTC [166] user7826f9bec6084e53af12181aa87f33e2@db7826f9bec6084e53af12181aa87f33e2 STATEMENT: SELECT "filecache"."fileid", "storage", "path", "path_hash", "filecache"."parent", "filecache"."name", "mimetype", "mimepart", "size", "mtime", "storage_mtime", "encrypted", "etag", "filecache"."permissions", "checksum", "unencrypted_size", "metadata_etag", "creation_time", "upload_time", "meta"."json" AS "meta_json", "meta"."sync_token" AS "meta_sync_token" FROM "oc_filecache" "filecache" LEFT JOIN "oc_filecache_extended" "fe" ON "filecache"."fileid" = "fe"."fileid" LEFT JOIN "oc_files_metadata" "meta" ON "filecache"."fileid" = "meta"."file_id" WHERE ("storage" = $1) AND ("path_hash" = $2)
May 08 10:20:142024-05-08 08:20:14.190 UTC [166] user7826f9bec6084e53af12181aa87f33e2@db7826f9bec6084e53af12181aa87f33e2 ERROR: current transaction is aborted, commands ignored until end of transaction block
May 08 10:20:142024-05-08 08:20:14.190 UTC [166] user7826f9bec6084e53af12181aa87f33e2@db7826f9bec6084e53af12181aa87f33e2 STATEMENT: SELECT "uid", "displayname", "password" FROM "oc_users" WHERE "uid_lower" = $1

Years ago I migrated this nextcloud from a vserver to a nextcloud within cloudron.
Therefore I converted the database from mysql and imported to nextcloud. Maybe relicts?

Hi there,

When I run "occ files:scan --all" I get quite some errors. They exist since some time, but I had no problems in daylie usage. And searching didnt really get me somewhere.
Does someone have a clue where to start and how to solve them?

First it says, for some users, their Folders don't exist. But these users don't have problems.

Path not found: /username

And then there is a bunch of errors, where I really don't know where to start.

Exception during scan: An exception occurred while executing a query: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block
#0 /app/code/3rdparty/doctrine/dbal/src/Connection.php(1938): Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert()
#1 /app/code/3rdparty/doctrine/dbal/src/Connection.php(1880): Doctrine\DBAL\Connection->handleDriverException()
#2 /app/code/3rdparty/doctrine/dbal/src/Connection.php(1105): Doctrine\DBAL\Connection->convertExceptionDuringQuery()
#3 /app/code/lib/private/DB/Connection.php(261): Doctrine\DBAL\Connection->executeQuery()
#4 /app/code/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(341): OC\DB\Connection->executeQuery()
#5 /app/code/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(377): Doctrine\DBAL\Query\QueryBuilder->executeQuery()
#6 /app/code/lib/private/DB/QueryBuilder/QueryBuilder.php(280): Doctrine\DBAL\Query\QueryBuilder->execute()
#7 /app/code/lib/private/Files/Cache/Cache.php(172): OC\DB\QueryBuilder\QueryBuilder->execute()
#8 /app/code/lib/private/Files/Cache/HomeCache.php(57): OC\Files\Cache\Cache->get()
#9 /app/code/lib/private/Files/Cache/Cache.php(553): OC\Files\Cache\HomeCache->get()
#10 /app/code/lib/private/Files/Cache/Scanner.php(286): OC\Files\Cache\Cache->remove()
#11 /app/code/lib/private/Files/Cache/Scanner.php(520): OC\Files\Cache\Scanner->removeFromCache()
#12 /app/code/lib/private/Files/Cache/Scanner.php(404): OC\Files\Cache\Scanner->handleChildren()
#13 /app/code/lib/private/Files/Cache/Scanner.php(409): OC\Files\Cache\Scanner->scanChildren()
#14 /app/code/lib/private/Files/Cache/Scanner.php(409): OC\Files\Cache\Scanner->scanChildren()
#15 /app/code/lib/private/Files/Cache/Scanner.php(409): OC\Files\Cache\Scanner->scanChildren()
#16 /app/code/lib/private/Files/Cache/Scanner.php(409): OC\Files\Cache\Scanner->scanChildren()
#17 /app/code/lib/private/Files/Cache/Scanner.php(354): OC\Files\Cache\Scanner->scanChildren()
#18 /app/code/lib/private/Files/Utils/Scanner.php(277): OC\Files\Cache\Scanner->scan()
#19 /app/data/apps/files/lib/Command/Scan.php(180): OC\Files\Utils\Scanner->scan()
#20 /app/data/apps/files/lib/Command/Scan.php(241): OCA\Files\Command\Scan->scanFiles()
#21 /app/code/3rdparty/symfony/console/Command/Command.php(298): OCA\Files\Command\Scan->execute()
#22 /app/code/core/Command/Base.php(177): Symfony\Component\Console\Command\Command->run()
#23 /app/code/3rdparty/symfony/console/Application.php(1040): OC\Core\Command\Base->run()
#24 /app/code/3rdparty/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#25 /app/code/3rdparty/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#26 /app/code/lib/private/Console/Application.php(213): Symfony\Component\Console\Application->run()
#27 /app/code/console.php(100): OC\Console\Application->run()
#28 /app/code/occ(11): require_once('...')
#29 {main}

In ExceptionConverter.php line 87:
                                                                                                                                                                                        
  An exception occurred while executing a query: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block  
                                                                                                                                                                                        

In Exception.php line 28:
                                                                                                                                         
  SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block  
                                                                                                                                         

In Statement.php line 130:
                                                                                                                                         
  SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block 

I am running v7.6.2 (Ubuntu 22.04.1 LTS) on a hetzner vserver. Nextcloud version 28.0.5
Any suggestions where to start?

Hi there,

i have a question about Nextcloud Apps and Nextcloud Updates.

The internal update routine checks compatibility for installed apps. For Cloudron update routine I don't find something like that. I guess Cloudron only distributes updates as soon as all featured Nextcloud Apps are compatible.
I hear Cloudron saying "We do not recommend installing apps in Nextcloud unless absolutely required"
So if "absolutely required", checking the compatibility is up to me?

How do you handle it? Whats your update routine?

I thought maybe its possible to use the internal updater to check compatibility. So i switched the update channel, only to find out, the internal updater wants to update to 27.1.6 while Cloudron updates to 28.0.2. So I still don't see compatibility

Further more, now my Update channel is switched and it is not possible to switch back to "cloudron" in that interface. Is this an issue at all? Does this have an affect? Is it back to "cloudron" after update via Cloudron?

Okay, I've come one step further.

The situation with the domain was apparently caused by Firefox. With Vivaldi there is a successful login again, or an error, depending on the plugins. How unnecessary

Actually Discourse only works with one plugin, but the plugin itself does not work: Discourse User Notes

With the other tested plugins nothing works, only the error message:

"Oops
The software powering this discussion forum encountered an unexpected problem...."
I only tested two further Plugins: check-list and reactions

My test procedure is simply to remove the plugin folder and restart the app. I have no idea whether this is a reliable test.

Hello everyone,
I have had discourse installed for a long time. (lately 3.1.3)
Recently a user informed me that the login no longer works.

Currently nothing happens during login, the login window remains and shows "Signing In" forever.
If I move the Discourse app to another subdomain, everything seems to work. If I put it back on the original subdomain, the login does not work again.
Even a fresh installation shows the same error.

What I have already tried.

• I quickly found out that a plugin could be the problem. I removed all subfolders from the plugins folder. At that point, the login worked again. I put the plugins back in one by one. Suddenly the login no longer worked at all.
• I have restored backups. First the login worked again without plugins. So I tried again to find out which plugin was causing problems.
• Now there is no login at all, with or without plugins. Not even with a fresh installation.
• On another subdomain the login works, even with the plugins.

How can the domain cause the error? What should I do?

Hi there, I wanna migrate from a other cloud service to nextcloud.
I have set up the cloud running well. Now I want to upload my data.

I'm talking about several 1000 files and around 20GB size.

I wanted to upload a zip file and installed the "extract" App on nextcloud. But here I do get encoding problems with german umlauts. I found a solution to run on the server:
'convmv -f utf-8 -t utf-8 -r --notest --nfc <nextcloud-data-folder>'
But this wont work in the Terminal?

When I upload with the cloudron Filemanager, I get the same problem.

On Nextcloud side there was an issue already in 2017. https://github.com/nextcloud/server/issues/3136
With the same 'convmv' solution.

Seems like I will install Nextcloud Client and sync the files.

Also, it would be very interesting if it is possible to get the files with the original timestamp and have them visible in Nextcloud with the original timestamp.

I am grateful for any suggestions.

I had to enable Masquerading under settings.
"Masquerading allows users and apps to send emails with an arbitrary username in the FROM address."

Hi there, I successfully migrated from a selfhosted docker installation to cloudron. So far as I can see everything works fine.

Only sending mails doesn't work. I configurated the domain to use an external smtp. I used that same smtp server for my selfhosted discourse installations.
There I had to configure mail-login in containers/app.yml

My App-configuration in Cloudron

• E-Mail FROM Adresse: mail@domain
• x Do not configure inbox

My mail-configuration for domain

• external smtp
• status: test Mail arrives

My Mail Event Log:

no-reply@domain 	admin@domain 	Delivered mail
community+verp-7077d0c715a9701676aba02c5ae1ce03@domain 	- 	Connection denied. Authenticated user community@domain cannot send mail as community+verp-7077d0c715a9701676aba02c5ae1ce03@domain

Discourse settings: Delivery Method

address: 	mail
port:	2525
domain: 	goodmotion.de
user_name:	community@domain
authentication: 	plain
enable_starttls_auto: 	true

I can not change these settings. Adress "mail" looks wrong, the port is also different then configured in cloudron external smtp

@solarsimon said in how extensive are backups?:

I am sure you can make my worries disappear...

@mehdi said in how extensive are backups?:

@solarsimon Dumb question but ... have you tried in another browser, just to make sure it's not a cache problem ?

no words. It had to be that simple.
solved, or better erase

thanks for quick reply.

I followed this guide
https://meta.discourse.org/t/rocket-chat-sso-embed-plugin-for-discourse/199450
Where it says to turn of registration and login form. Pretty sure that fault is not about cloudron...

After I failed there, I went to restore rocket.chat, but login form is still gone.

About SSO I guess it failed, because user exist in both apps (discourse and rocket) with different password.

Hey there, I'm a bit confused, which leads to my question.
Just made some carefree experiments, the app does not contain sensitive data, anyways cloudron says there are full backups.

So I played around with SSO within the app rocket.chat. Apparently it's not working properly, I'm locked out now. As I said, I was a bit carefree, cus of the backups.

I restored backups, tried them all, I'm still locked out. Which leads me to the question: Whats happening here? Cloudron Docs say Backups are Snapshots. So I should be able to move back to configuration some ours ago. I'm really confused now and worried about my other apps backups.

I am sure you can make my worries disappear...

@solarsimon said in Migrate Nextcloud - Keep Nextcloud Users and Settings:

One more issue in detail:
All Files get a new FileID. Thats a big problem, cus file-links don't work anymore, both internal and external.
Anybody got a hint? Gonna ask in the nextcloud community.

solved!
Make sure your data folder has the same folder structure.
Otherwise (in general when changing data folder) nextcloud does a rescan.

In my case I had to move all my data to new folder (media/storage) before I dump the database

Step by step:

1. maintenance mode and move data folder
2. update database

sudo -u postgres psql
\c db8fe...
UPDATE public.oc_storages SET id = 'local::/media/storage/' WHERE id = 'local::/home/data/';

3. update config.php

Maybe you can save work, by just alter the oc_storages in your database on your new server after import. But I did not try.

I also copied 'passwordsalt' and 'secret' in config.php from the old to the new server.