I currently have a private NextCloud server up and running for our intranet which is accessed over a VPN and does not have a public facing IP address.
I am about to setup a second instance of NextCloud which does have a public facing IP address for our clients in order for us to be able to share files with each other securely.
I would like the file storage to be shared between the private instance and public instance so that when a client uploads data on the public instance we can access it from our private instance and when we put data into a client folder on the private instance they can see it on their public instance when they log in.
Is this possible?
The reason I want to do this is because I want to avoid transferring data via another service (email etc.) as we work in legal and compliance services so have to take security very seriously.
I was planning on putting the public instance on its own server which I suspect would complicate things further (I can run it on the same server as the private instance but obviously this creates a much higher security risk because then we are exposing our intranet to the world.
I currently run a Proxmox cluster with Ceph so I could potentially make storage available to both servers without any issue I just need to know if this is possible with NextCloud? I was thinking of using federated sharing but not sure if that will work between private and public networks?
Sadly that doesn’t work because I am using one private and one public instance of nextcloud. if I try to share from the public to the private instance using federated sharing it fails (it doesn’t accept my federated ID from the private server); and if I try to share from the private to the public instance it fails (because it cannot access the private server in order connect to the share).
Yeah that was my thought too - I did that and everything went nuts. CPU usage locked up completely and I got the following error spat out in the Nextcloud log file:
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT fileid, storage, path, path_hash, parent, name, mimetype, mimepart, size, mtime, storage_mtime, encrypted, etag, permissions, checksum FROM oc_filecache WHERE storage = ? AND path_hash = ?’ with params [1, “e8147787f0abd5564b546d2892a20b05”]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
/usr/share/nginx/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 128: Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException(‘An exception oc…’, Object(Doctrine\DBAL\Driver\PDOException))
/usr/share/nginx/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 855: Doctrine\DBAL\DBALException driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), ‘SELECT fileid…’, Array)
/usr/share/nginx/nextcloud/lib/private/DB/Connection.php - line 195: Doctrine\DBAL\Connection->executeQuery(‘SELECT fileid…’, Array, Array, NULL)
/usr/share/nginx/nextcloud/lib/private/Files/Cache/Cache.php - line 137: OC\DB\Connection->executeQuery(‘SELECT fileid…’, Array)
/usr/share/nginx/nextcloud/lib/private/Files/Cache/Wrapper/CacheWrapper.php - line 69: OC\Files\Cache\Cache->get(‘appdata_ock0nmm…’)
/usr/share/nginx/nextcloud/lib/private/Files/View.php - line 1315: OC\Files\Cache\Wrapper\CacheWrapper->get(‘appdata_ock0nmm…’)
/usr/share/nginx/nextcloud/lib/private/Files/View.php - line 1369: OC\Files\View->getCacheEntry(Object(OCA\RansomwareProtection\StorageWrapper), ‘appdata_ock0nmm…’, ‘/appdata_ock0nm…’)
/usr/share/nginx/nextcloud/lib/private/Files/Node/Root.php - line 198: OC\Files\View->getFileInfo(’/appdata_ock0nm…’)