Crontab manager Nethserver integration of crontab manager 1.0.4
Fail2ban Nethserver integration of Fail2ban 1.7.1
File server Share files with your working group 4.6.0
Guacamole Provides a clientless remote desktop gateway 0.0.1
mrmarkuz repo is online Provides mrmarkuz repo, open link to get repoview 0.0.1
Nextcloud Provides Nextcloud for NethServer 1.17.0
NFS server Share files with NFS 1.0.1
phpMyAdmin Provide the administration of MySQL over the Web 1.2.5
Stephdl is online You can support the stephane de Labrusse (stephdl) software repository by clicking on the button 1.1.7
Web server Web server configuration with named virtual hosts and reverse proxy 3.12.0
Also I’m planning to install one of these Offices (OnlyOffice or Collabora Office).
Just found the following logs on /var/log/rh-mariadb105/nextcloud.log
2021-07-06 11:20:02 442 [Warning] Access denied for user 'nextcloud'@'localhost' (using password: YES)
Don’t know why, but maybe the cause is Nextcloud update 2 days ago.
DB missing. I have reinstalled nextcloud. So I need to resotore it from backup or there are other choices?
grep 'db /usr/share/nextcloud/config/config.php |grep -v dbpass
It shall be on mariadb105 (use the second command above)
What do you mean with second command?
the files are on /var/opt/rh/rh-mariadb105/lib/mysql-nextcloud/
/opt/rh/rh-mariadb105/root/bin/mysql --socket="/var/run/rh-mariadb105-mariadb/nextcloud-mysql.sock" -e 'SELECT user FROM mysql.user'
If it exists, then you might need to check for a password mismatch (dbpassword in nextcloud config.php file and password on /var/lib/nethserver/secrets/nextcloud).
If passwords are the same what is left is to check them against the mysql nextcloud user password or the mysql nextcloud user privileges:
mysql --socket="/var/run/rh-mariadb105-mariadb/nextcloud-mysql.sock" -e "SHOW GRANTS FOR 'nextcloud'@'localhost'"
+------------------------------------------------------------------------------------------------------------------+
| Grants for nextcloud@localhost |
+------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO `nextcloud`@`localhost` IDENTIFIED BY PASSWORD '*xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' |
| GRANT ALL PRIVILEGES ON `nextcloud`.* TO `nextcloud`@`localhost` |
+------------------------------------------------------------------------------------------------------------------+
Or to run signal-event nethserver-nextcloud-update hoping it completes what was left.
ok, a little bit closer! I had to reset the password and now I got the warning
Downgrading is not supported and is likely to cause unpredictable issues (from 21.0.3.1 to 21.0.2.1)
nethserver-nextcloud-1.17.1-1 (for Nextcloud 21.0.3.1) was released today.
Looks like you managed to install 21.0.3.1 (maybe from testing repo?) but now you are offered 21.0.2.1
rpm -q nethserver-nextcloud
yum check-update
yum list nethserver-nextcloud --show-duplicates
From where came the message? maybe was a partial manual update using nextcloud integrated update assistant (from the update button on Nextcloud interface)
21.0.3 should soon propagate to mirrors. In the meantime, you can choose to download manually download it…
Or install it directly from the link (installing it directly from yum via direct URL is sometimes considered insecure)
After installation the same internal error has been generated. I looked at nextcloud log and seen the same mariadb access denied error. Have changed the password for user and nextcloud works!
One error which have been fixed after update stayed without changes.
There are some errors regarding your setup.
* Last background job execution ran 4 days ago. Something seems wrong. [Check the background job settings](https://biz.itkonsultanti.lv/index.php/settings/admin#backgroundjobs)