Nextcloud
OK I've bitten the bullet and despite the fact that it does not support firebird, I've got a copy of nextcloud running on a new domain https://rdmcloud.uk. Since the server is text only, a few of the steps to get postgres even running were a problem. It does not like my using the root account over ssh to manage things, but since a lot of the time I had to use sudo anyway, it made sence to me. I NOW have the lester account able to run sudo and a postgres account allows me to log into the databases. STILL prefer the Firebird single file approach to a database, which is automatically backed up every night, and would be a reason to look into adding the doctrine firebird driver to nextcloud. Just hope that is not as messy as the Lavarel driver and db abstraction.
I've been jumping through a few hoops to get a working set of code which I can work on, but the master branch of nextcloud is now on the development machine along with the stable V32.0.5 build. The only problem was a missing app which is not part of the main repo. Viewer has it's own repo and until I'd manually added it to things I could not get the migration to work from the sqlite3 to postgres. Now that I've got things working, I could probably simply wipe the config.php file and start again going clean into postgres, which is something I will check later. Getting the command line PHP to run the occ was a bit of fun. I don't normally use php from the command line, and can debug the website stuff running with the php-fpm version so the occ functions simply did not work initially. This was partly down to getting sudo running under my user account on the servers and then getting php to run as nginx. I still have not quite worked out about running psql as user postgres. It runs using a password, but I've not been able to bypass that as yet.
Next step ... just what do I need to port the thunderbird email archive over so I can access it via the web! Update - contacts linked, but not sure that the local files can be linked in the same way! I need an email account for a non-existant email address.
Actually next step has been to add the other two servers as external sources for the files list on the main server. Using sftp for this which works nicely from the linux desktop via dolphin. In the process I also hit a bug in plex which has been affecting me for some time ... the images were not being displayed even where they were visible in the fix match checks.
