Hi,
I tried setting up Owncloud and gave up, I have just set up Nextcloud to find it has similar problems.
First off when I login to the admin account I get the following :
There are some errors regarding your setup.
Some files have not passed the integrity check. Further information on how to resolve this issue can be found in the documentation. (List of invalid files… / Rescan…)
The PHP memory limit is below the recommended value of 512MB.
MySQL is used as database but does not support 4-byte characters. To be able to handle 4-byte characters (like emojis) without issues in filenames or comments for example it is recommended to enable the 4-byte support in MySQL. For further details read the documentation page about this.
Your web server is not properly set up to resolve "/.well-known/caldav". Further information can be found in the documentation.
Your web server is not properly set up to resolve "/.well-known/carddav". Further information can be found in the documentation.
No memory cache has been configured. To enhance performance, please configure a memcache, if available. Further information can be found in the documentation.
The PHP OPcache is not properly configured. For better performance it is recommended to use the following settings in the php.ini:
opcache.enable=1
opcache.interned_strings_buffer=8
opcache.max_accelerated_files=10000
opcache.memory_consumption=128
opcache.save_comments=1
opcache.revalidate_freq=1
The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added automatically. By running "occ db:add-missing-indices" those missing indexes could be added manually while the instance keeps running. Once the indexes are added queries to those tables are usually much faster.
Missing index "calendarobject_calid_index" in table "oc_calendarobjects_props".
Missing index "schedulobj_principuri_index" in table "oc_schedulingobjects".
This instance is missing some recommended PHP modules. For improved performance and better compatibility it is highly recommended to install them.
imagick
Some columns in the database are missing a conversion to big int. Due to the fact that changing column types on big tables could take some time they were not changed automatically. By running 'occ db:convert-filecache-bigint' those pending changes could be applied manually. This operation needs to be made while the instance is offline. For further details read the documentation page about this.
mounts.storage_id
mounts.root_id
mounts.mount_id
Please double check the installation guides ↗, and check for any errors or warnings in the log.
Check the security of your Nextcloud over our security scan ↗.
Version
Nextcloud 18.0.4
The version you are running is not maintained anymore. Please make sure to update to a supported version as soon as possible.
A new version is available: Nextcloud 18.0.14
All apps have an update for this version available
Apps with available updates
Open updater Download nowUpdate channel: Stable
You can always update to a newer version. But you can never downgrade to a more stable version.
Note that after a new release it can take some time before it shows up here. We roll out new versions spread out over time to our users and sometimes skip a version when issues are found.
So, not only is the version in Marketplace not maintained anymore, but when I try to update I get the following:
Initializing
Current version is 18.0.4.
Update to Nextcloud 18.0.14 available. (channel: "stable")
Following file will be downloaded automatically: https://download.nextcloud.com/server/releases/nextcloud-18.0.14.zip
Open changelog ↗
Retry update
Check for expected files
The following extra files have been found:
assets
And I am unable to update
When I try to direct the storage path to a mounted HDD, different from the ClearOS drive I get the following error:
Your data directory is invalid Ensure there is a file called ".ocdata" in the root of the data directory.
Even though I did copy everything and the contents of the data folder in the mnt are :
[root@xxxxx data]# ls -a
. admin files_external index.html .ocdata updater-ocnkqx9slovx
.. appdata_ocnkqx9slovx .htaccess nextcloud.log updater.log
As you can see the ,ocdata file is present. I properly changed the path in the config.php file, but for some reason it can't find the .ocdata file, that is in the folder.
What am I missing here ?? And how can I fix all the other issues and have a properly working NextCloud ?
Thanks.
Manolo
I tried setting up Owncloud and gave up, I have just set up Nextcloud to find it has similar problems.
First off when I login to the admin account I get the following :
There are some errors regarding your setup.
Some files have not passed the integrity check. Further information on how to resolve this issue can be found in the documentation. (List of invalid files… / Rescan…)
The PHP memory limit is below the recommended value of 512MB.
MySQL is used as database but does not support 4-byte characters. To be able to handle 4-byte characters (like emojis) without issues in filenames or comments for example it is recommended to enable the 4-byte support in MySQL. For further details read the documentation page about this.
Your web server is not properly set up to resolve "/.well-known/caldav". Further information can be found in the documentation.
Your web server is not properly set up to resolve "/.well-known/carddav". Further information can be found in the documentation.
No memory cache has been configured. To enhance performance, please configure a memcache, if available. Further information can be found in the documentation.
The PHP OPcache is not properly configured. For better performance it is recommended to use the following settings in the php.ini:
opcache.enable=1
opcache.interned_strings_buffer=8
opcache.max_accelerated_files=10000
opcache.memory_consumption=128
opcache.save_comments=1
opcache.revalidate_freq=1
The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added automatically. By running "occ db:add-missing-indices" those missing indexes could be added manually while the instance keeps running. Once the indexes are added queries to those tables are usually much faster.
Missing index "calendarobject_calid_index" in table "oc_calendarobjects_props".
Missing index "schedulobj_principuri_index" in table "oc_schedulingobjects".
This instance is missing some recommended PHP modules. For improved performance and better compatibility it is highly recommended to install them.
imagick
Some columns in the database are missing a conversion to big int. Due to the fact that changing column types on big tables could take some time they were not changed automatically. By running 'occ db:convert-filecache-bigint' those pending changes could be applied manually. This operation needs to be made while the instance is offline. For further details read the documentation page about this.
mounts.storage_id
mounts.root_id
mounts.mount_id
Please double check the installation guides ↗, and check for any errors or warnings in the log.
Check the security of your Nextcloud over our security scan ↗.
Version
Nextcloud 18.0.4
The version you are running is not maintained anymore. Please make sure to update to a supported version as soon as possible.
A new version is available: Nextcloud 18.0.14
All apps have an update for this version available
Apps with available updates
Open updater Download nowUpdate channel: Stable
You can always update to a newer version. But you can never downgrade to a more stable version.
Note that after a new release it can take some time before it shows up here. We roll out new versions spread out over time to our users and sometimes skip a version when issues are found.
So, not only is the version in Marketplace not maintained anymore, but when I try to update I get the following:
Initializing
Current version is 18.0.4.
Update to Nextcloud 18.0.14 available. (channel: "stable")
Following file will be downloaded automatically: https://download.nextcloud.com/server/releases/nextcloud-18.0.14.zip
Open changelog ↗
Retry update
Check for expected files
The following extra files have been found:
assets
And I am unable to update
When I try to direct the storage path to a mounted HDD, different from the ClearOS drive I get the following error:
Your data directory is invalid Ensure there is a file called ".ocdata" in the root of the data directory.
Even though I did copy everything and the contents of the data folder in the mnt are :
[root@xxxxx data]# ls -a
. admin files_external index.html .ocdata updater-ocnkqx9slovx
.. appdata_ocnkqx9slovx .htaccess nextcloud.log updater.log
As you can see the ,ocdata file is present. I properly changed the path in the config.php file, but for some reason it can't find the .ocdata file, that is in the folder.
What am I missing here ?? And how can I fix all the other issues and have a properly working NextCloud ?
Thanks.
Manolo
Share this post:
Responses (23)
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
Manuel Alejandro Aravena wrote:
If it is a Windows setting, then I have no idea. You may do better to ask on the NC forums.
... but now I have another issue which is that windows 2019 is limiting the files that can be synced, such as for example .txt, .jpg. .pdf files. These give an error, what settings can I change in Windows 2019 Server to allow nextcloud to sync them ?
One other thing, is there a walkthrough available on how to upgrade the Nextcloud version ?? I currently have 18.0.4.2, how can I upgrade to the latest supported ClearOS version ??
That is the latest ClearOS version. you can got to v19 if you enable the testing repos:
That will take you to 19.0.0. I've tried and failed to encourage the developer to finish off the NC20 upgrade.yum update app-nextcloud nextcloud --enablerepo=clearos*testing -
Accepted Answer
Nick Howitt wrote:
Just use your LE certificate and, in the webserver app, assign it to your website. Make sure it covers the FQDN you use to access NC.
[edit]
And with certificates there is no such thing as a public key. Use the private key.
[/edit]
Thanks Nick, this managed to help me sync, but now I have another issue which is that windows 2019 is limiting the files that can be synced, such as for example .txt, .jpg. .pdf files. These give an error, what settings can I change in Windows 2019 Server to allow nextcloud to sync them ?
One other thing, is there a walkthrough available on how to upgrade the Nextcloud version ?? I currently have 18.0.4.2, how can I upgrade to the latest supported ClearOS version ??
Thanks.
Manolo -
Accepted Answer
Nick Howitt wrote:
Manuel Alejandro Aravena wrote:
I did and they simply suggested I delete and reinstall the client. Thanks anyway.
Manuel
Some Windows functions do not like self-signed certs. Do you have a self-signed one, a Let's Encrypt one or a commercial one covering your NC domain?
Nick, I have the Let's Encrypt certificate only on the ClearOS server, but my hosting provider has an SSl certificate I can download.
I have downloaded it and receive four files:
domain.cert.pem
intermediate.cert.pem
private.key.pem
public.key.pem
I tried to add these files in the certificate manager menu, under import external certificate,
certificate file domain.cert.pem
key file public.key.pem
intermediate file intermediate.cert.pem
I try adding these files but it does not work, any suggestions ??
I currently have two certificates, one says certificate authority and the other says default certificate.
I have not set anything regarding ports in my firewall should I ??
Thanks
Manuel -
Accepted Answer
It has only been like that for a few weeks!
I'd love feedback if the upgrade to MariaDB 10.x works so I can close the bug. I have not got round to testing it with MariaDB10. I just released it with the upgrade to system-mariadb as it did not appear to interfere with anything and may have also fixed the issue. -
Accepted Answer
Nick Howitt wrote:
Here is the diff, and here is the issue. As I said, the change was trivial.
That's why I was asking as this is contents of mine ..
ExecStartPre=/usr/clearos/sandbox/usr/libexec/mariadb-prepare-db-dir
ExecStart=/usr/clearos/sandbox/usr/bin/mysqld_safe --basedir=/usr/clearos/sandbox/usr
ExecStartPost=/usr/clearos/sandbox/usr/libexec/mariadb-wait-ready $MAINPID
Which looked to me like the sandboxed db (the system's) was separate anyway ..! -
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
Richard George wrote:
The user db on 3306
How do I just update the user db?
So enabling 4-byte will not have touched the system database
I have hopefully separated the user and system database fully (nothing clever, just a tweak to the system-database systemd unit file). If that is correct. Have a look at this link for 10.3. You already have the repo installed and enabled (it is used for the php engines app). The latest version available is rh-mariadb105. You can probably install it alongside MariaDB 5.4 but you won't be able to have both running at the same time and you can't stop/start it through the webconfig. I've no idea if it uses the same db or a different one, but I believe it still works on port 3306 which is why you can't have both running at the same time.
It is not good to force a change like that on a user, so it should really be done with a menu option in webconfig. The problem I have (apart from time) is that flexshare/website settings are stored in a funny way, in /etc/clearos/flexshare.conf and I don't know how that works. There has be an issue for a while which has been carried over from the old bug tracker.
Incidentally, the only thing I have to keep tweaking is the Strict-Transport-Security setting in 433-flex.conf .. something that in THIS day and age, should be a default for any https site definition. If you feel like fixing that so it's a default setting Nick, I don't you'll find many arguing against it!
In fact there are more powerful changes I'd like to do but it is probably too much for me to take on. I'd also like to see a selectable http > https redirect option. -
Accepted Answer
The user db on 3306
Incidentally, the only thing I have to keep tweaking is the Strict-Transport-Security setting in 433-flex.conf .. something that in THIS day and age, should be a default for any https site definition. If you feel like fixing that so it's a default setting Nick, I don't you'll find many arguing against it!
How do I just update the user db? -
Accepted Answer
Richard George wrote:
FWIW, I'm running NB 20.0.9 on a clearos server, and the only thiing I've not bothered with is the cache setting. And I've not had a problem with enabling the 4-byte support or any other than the necessary db updates to allow it to work, and it's hooked in to clearos LDAP. The only thing I won't be able to do is to update to version 21 because of the version of the Mariadb - that's something I might look at in the future. I accept that the various db tweaks needed might cause issues with other apps, but after reading about them and what they do, I have doubts that they will upset anything -although anything is possible.
NB itself is just installed as per NB recommendations, into a virtual clearos website using the 7.3 php engine, and NB's security scan gives the site an A+ rating with all their security hardenings enabled. I'm on a supported stable release.
The server itself is used as a file server, and the NB aspect is simply an extension of that useage. It can sync quite happily with Windows 10, Android, and iPhone/iPad. One useful feature of the newer versions of NB is that the file storage locations can be located on a flexshare, and -unlike the version in the app store, use the name of the user rather than an anonymous scrambled id, making it easier to see what belongs to who when accessing the file system via the underlying linux system
Are you using the system database (port 3308) or the user database on port 3306? If you are using the user database, you may be able to upgrade to one of the versions in the SClo repos. You'd need to fully recompile MariaDB yourself if you wanted to replace the system-database. -
Accepted Answer
-
Accepted Answer
FWIW, I'm running NB 20.0.9 on a clearos server, and the only thiing I've not bothered with is the cache setting. And I've not had a problem with enabling the 4-byte support or any other than the necessary db updates to allow it to work, and it's hooked in to clearos LDAP. The only thing I won't be able to do is to update to version 21 because of the version of the Mariadb - that's something I might look at in the future. I accept that the various db tweaks needed might cause issues with other apps, but after reading about them and what they do, I have doubts that they will upset anything -although anything is possible.
NB itself is just installed as per NB recommendations, into a virtual clearos website using the 7.3 php engine, and NB's security scan gives the site an A+ rating with all their security hardenings enabled. I'm on a supported stable release.
The server itself is used as a file server, and the NB aspect is simply an extension of that useage. It can sync quite happily with Windows 10, Android, and iPhone/iPad. One useful feature of the newer versions of NB is that the file storage locations can be located on a flexshare, and -unlike the version in the app store, use the name of the user rather than an anonymous scrambled id, making it easier to see what belongs to who when accessing the file system via the underlying linux system -
Accepted Answer
-
Accepted Answer
-
Accepted Answer
Hi,
It seems I keep having issues, I managed to make NextCloud work on all my devices except one. I have a windows server 2019 that I use as a desktop as well, but it will not sync on this install. I download the client, install, set everything, it runs an as soon as files are being synced it closes. I uninstalled it, reinstalled but it just will not work. Do you have any suggestions as to why it would not work?? My setup works on Ubuntu, Windows 10, MacOS, iOS, but not windows server 2019.
Any help or suggestions are very welcome.
Thanks
Manuel -
Accepted Answer
It is not possible to safely fix all the warnings. To do that would mean every app using the system-database would need to be checked with the mods suggested by NC.
In this case, recursively neans all files/folders under the folder you are operating on. Often it means using a -r or -R flag with the command (chmod and chown use -R),
ClearOS does not use ACL's at all (but you can if you want) so assume everything is by UNIX permissions.
Documentation is meant to cover features available from the webconfig and, perhaps, a little more. Command line hackers are assumed to have more knowledge. We also can't reproduce all the documentation on the underlying app.
Re settings in ClearOS, there is a configuration backup and restore program which will save most of your settings into /var/clearos/apps/configuration_backup (or something like it). THere is also a Remote backup app (in the Cloud menu). You get 50MB free storage space and your configs are backed up there but do not forget your secret key. It cannot be recovered by Clearcenter. The space should be sufficient for configuration backups but more can be purchased. -
Accepted Answer
Hello Nick,
First thing I am sorry, I was somewhat pissed off and that was an unwarranted bit of a rant. Sorry.
I have been able to make it work, but as I am not an experienced Linux user it did take me a while and the process was somewhat frustrating at times.
I had to chown the folders, I had been doing setfacl, and it was not working. Storage I guess does work, but it is generally, at least from my POV better practivce to use a different drive, i just guess that this should somehow be considered and I guess a choice as to where the data folder goes should be available on install or from the ClearOS webpage.
I am now exploring the recursively bit, as I have no idea what that is. But if neccessary I will change it.
Yes I read about permissions on a nexcloud forum, maybe ClearOS should include that bit in the documentation, it is a bit "sparse".
I will keep at it, and so far have managed to sync one of my PCs. I just hope the proper drive is selected or I will run out of space really quick.
Once again thanks heaps for your help and sorry for the rant.
BTW none of my systems is "Critical" so if you want me to test a tweak, I'm happy to help, considered you guide me through it. I would not mind being able to run the current or more current version, as having the warning every time I get into the NC apps is annoying.
One last question, are settings for ClerarOS stored by ClearOS, I have the home version, so in case this install "fails" can I download them from ClearOS ? I mean if a tweak goes bad .....
Anyway, thanks again.
Saludos,
Manuel -
Accepted Answer
Let us be straight about this. The app works and it works out of the box, just not necessarily optimally. Only because you've been into the admin panel settings have you noticed these warnings, but they are only warnings. Some of them it is risky to fix as they are global settings. The wellknown feature is not widely used but, if it is fixed, needs to not overwrite anything already existing (those values could, for example, have been set by SOGo). I think the dev now has a way round it.
Storage works out of the box. It is only your manual tinkering that has failed. There should be no need to set ACL's and I suggest you remove them. Did you set permissions recursively? All mine are apache:apache except for /var/clearos/nextcloud/data/.htaccess. /var/clearos/nextcloud is 0770 and the rest of the folders are 0755 and files are 0644. /var and /var/clearos are 0755 owned by root. Do your permissions of your user apache allow him to navigate to your data folder?
So to be fair, the app works out of the box and your file access issues are of your own making.
If you install a vanilla NC from upstream, you won't get the integration with LDAP so you'll need to controll the users manually. You will also have exactly the same permissions issue moving folders as it is an NC thing and not a ClearOS thing. You will get the same warnings in the admin panel as they are to do with PHP and MySQL/MariaDB settings. The wellknown issue will still need fixing, and you will need to work out how to use a later version of PHP and adjust its settings.
On the plus side, I recently did a change/tweak which I think will completely separate MariaDB from the system database (used by the ClearOS version of NC) so you may be able to upgrade MariaDB to a version from the SCLo repos and use that instead. That will allow you to use NC>=22. That bit of the change is untested and I'd love feedback on it. The real reason for upgrading the system-database was to bring it up to date with upstream . I noticed an old issue in the issue tracker where a workaround was documented so I fixed it with a different workaround which had the same effect. I have tested it by manually removing the folder which used to cause the problem when it disappeared with a MariaDB upgrade and the system database continued to function, but I have not done an actual MariaDB upgrade. -
Accepted Answer
Hello Nick,
Thanks for the info I managed to make it connect as I gave it ACL permissions for that folder but there are other permissions missing, as it will give an error for every file I want to sync. It is somehow or somewhere not being able to access the storage.
This has been quite frustrating as this is a paid app in the marketplace, not that I paid much, but I would have though it would work not only right after install, but without so many issues.
I am going to uninstall it, this is not working properly, and I really don't have the time, or patience to start fixing every bit of it that does not work as it should. To be honest I think this app should not be in the marketplace as it is not fully working, and is time consuming and complicated to setup, and the documentation is lacking detail.
Considering that I will uinstall it, I would like to know if I can download and install the original nextcloud on clearos or will I have issues later on ??
Thanks
Manolo -
Accepted Answer
The latest NC version we have is 18.0.4. Do not use their updater as it won't work with our packaging. Wait for our releases. There is an NC19 in beta, but it was never completed although it works. I run it. NC 21 is in (slow) progress and may appear some time. After that there will be no more updates as the requirements change to a Mariadb10 which is not something we can do sensibly in ClearOS.
NC18 works and is OK. You can fix some of the configurations manually. The NC19 update fixed one or two if them. The NC21 update will fix more, but not the opcache ones (I think). Enabling MySQL 4-byte support is risky. It is a global setting and will affect the whole system database so I have not tried it. I did fix my "wellknown" links as I wanted to use the shared address book in Thunderbird.
To change the data folder you can go down your route and change the "datadirectory" entry in config.php or you can bind mount your new data directory into the old one so the data also still appears to be in the old location as well as the new (although it is not really).
At a guess, the problem you have is file permissions. Please make sure your new data directory and everything under it is owned by apache:apache, or at least the group apache.
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »