Koozali.org: home of the SME Server

Contribs.org Forums => Koozali SME Server 10.x Contribs => Topic started by: monoman on September 29, 2022, 06:58:18 AM

Title: Nextcloud woes after recent sme and Nextcloud updates
Post by: monoman on September 29, 2022, 06:58:18 AM: Installed recent updates in the following order

27/9 - yum update
27/9 - sme-nextcloud update
28/9 - yum update

Getting 404 accessing nextcloud

Opp. Forgot to migrate db - done

ran Nextcloud-update

Now getting 403 and primary site (under construction)

29/9 - sme-nextcloud update

Nextcloud now displays app update required screen

then shows screen saying upgrade unsuccessful

Update to 23.0.8
Doctrine\DBAL\Schema\SchemaException: The table with name 'nextcloud.oc_authorized_groups' already exists.

Code: [Select]
Detailed logs Preparing update Set log level to debug Turned on maintenance mode Repair step: Repair MySQL collation Repair info: All tables already have the correct collation -> nothing to do Repair step: Repair SQLite autoincrement Repair step: Copy data from accounts table when migrating from ownCloud Repair step: Drop account terms table when migrating from ownCloud Updating database schema Doctrine\DBAL\Schema\SchemaException: The table with name 'nextcloud.oc_authorized_groups' already exists. The update was unsuccessful. Please report this issue to the Nextcloud community.[/i][/I]
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: Jean-Philippe Pialasse on September 29, 2022, 12:38:31 PM: check your smecontribs repo is enabled.

it should have been before updating as most the contribs needed to have the new httpd templates.

Remove or rewrite as needed all the httpd custom templates as the new access control syntax is incompatible with older one.

SME nextcloud comtribs has never used Sqlite. what is the history of your instance ?
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: monoman on September 30, 2022, 12:56:39 AM: Quote from: Jean-Philippe Pialasse on September 29, 2022, 12:38:31 PM
check your smecontribs repo is enabled.

smecontribs was enabled
Code: [Select]
# yum update --enablerepo=smecontribs
Quote from: Jean-Philippe Pialasse on September 29, 2022, 12:38:31 PM
it should have been before updating as most the contribs needed to have the new httpd templates.

Are you saying smecontribs must have been enabled? It was.

Quote from: Jean-Philippe Pialasse on September 29, 2022, 12:38:31 PM
Remove or rewrite as needed all the httpd custom templates as the new access control syntax is incompatible with older one.

What custom templates?

Quote from: Jean-Philippe Pialasse on September 29, 2022, 12:38:31 PM
SME nextcloud comtribs has never used Sqlite. what is the history of your instance ?

Fresh install December 2021 of both sme 10 and nextcloud

AFAIK, my install has been on mysql, not sqlite. A search for .sqlite shows:
Code: [Select]
/opt/remi/php56/root/usr/share/doc/php56-php-common-5.6.40/php.ini-development.sqlite3.defensive /opt/remi/php56/root/usr/share/doc/php56-php-common-5.6.40/php.ini-production.sqlite3.defensive /opt/remi/php70/root/usr/share/doc/php70-php-common-7.0.33/php.ini-development.sqlite3.defensive /opt/remi/php70/root/usr/share/doc/php70-php-common-7.0.33/php.ini-production.sqlite3.defensive /usr/share/doc/pear/Horde_Rdo/examples/users.sqlite.sql /usr/share/doc/perl-Mail-DMARC-1.20141206/share/mail_dmarc_schema.sqlite /usr/share/perl5/vendor_perl/auto/share/dist/Mail-DMARC/mail_dmarc_schema.sqlite /var/cache/yum/x86_64/7/base/6d0c3a488c282fe537794b5946b01e28c7f44db79097bb06826e1c0c88bad5ef-primary.sqlite.bz2 /var/cache/yum/x86_64/7/base/d6d94c7d406fe7ad4902a97104b39a0d8299451832a97f31d71653ba982c955b-filelists.sqlite.bz2 /var/cache/yum/x86_64/7/base/gen/primary_db.sqlite /var/cache/yum/x86_64/7/remi-safe/7dfe694f3f770f7c3a5c82e208414f155183be8568f1c447daa02a1fcd306ea8-primary.sqlite.bz2 /var/cache/yum/x86_64/7/remi-safe/8b843822fad3ffe509114ed436a797453b1f5f6af551bd88bd4f0cdd0ede6c1e-filelists.sqlite.bz2 /var/cache/yum/x86_64/7/remi-safe/gen/primary_db.sqlite /var/cache/yum/x86_64/7/smeaddons/35ea17aa229dbf8bfff2687c05024eec950d860c6ce70c17838cc3d9b6f1dc4b-primary.sqlite.bz2 /var/cache/yum/x86_64/7/smeaddons/8035fbb4e055106742ef0e4aea4a7ea75d5dacc41a441e48291e8837721949e7-filelists.sqlite.bz2 /var/cache/yum/x86_64/7/smeaddons/gen/primary_db.sqlite /var/cache/yum/x86_64/7/smecontribs/primary.sqlite.bz2 /var/cache/yum/x86_64/7/smecontribs/gen/primary_db.sqlite /var/cache/yum/x86_64/7/smeextras/filelists.sqlite.bz2 /var/cache/yum/x86_64/7/smeextras/primary.sqlite.bz2 /var/cache/yum/x86_64/7/smeextras/gen/primary_db.sqlite /var/cache/yum/x86_64/7/smeos/filelists.sqlite.bz2 /var/cache/yum/x86_64/7/smeos/primary.sqlite.bz2 /var/cache/yum/x86_64/7/smeos/gen/primary_db.sqlite /var/cache/yum/x86_64/7/smeupdates/8fe7c947c77a58e40e7ff5af689f7358e9b60c7d0b11a791d46ee198e035807c-primary.sqlite.bz2 /var/cache/yum/x86_64/7/smeupdates/f8f08118d091a4d101406383a48d19af6d92ddef9e4551c69c1aa97c1df07e28-filelists.sqlite.bz2 /var/cache/yum/x86_64/7/smeupdates/gen/primary_db.sqlite /var/cache/yum/x86_64/7/updates/7d565d24739a1bbc46b185b6864d4ca020956cc1be712c3c8a9e8d1586d2dc5a-primary.sqlite.bz2 /var/cache/yum/x86_64/7/updates/cf57eeb7d6adb19cae12779f178ed2559c6e07a183c7f49927873959d6ed6753-filelists.sqlite.bz2 /var/cache/yum/x86_64/7/updates/gen/primary_db.sqlite /var/lib/fail2ban/fail2ban.sqlite3 /var/lib/qpsmtpd/dmarc/reports.sqlite /var/lib/yum/history/history-2021-12-27.sqlite /var/lib/yum/history/history-2021-12-27.sqlite-journal
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: monoman on September 30, 2022, 01:21:03 AM: Recent upgrade history of server

Code: [Select]
[root@mimime ~]# yum history Loaded plugins: fastestmirror, post-transaction-actions, priorities, smeserver ID | Command line | Date and time | Action(s) | Altered ------------------------------------------------------------------------------- 45 | update --enablerepo=smec | 2022-09-29 14:31 | Update | 87 EE 44 | update | 2022-09-28 08:39 | Update | 64 EE 43 | update | 2022-09-27 08:22 | Update | 33 42 | update | 2022-09-14 08:12 | Update | 27
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: monoman on September 30, 2022, 01:32:17 AM: Update details show command run and results

Code: [Select]
yum update
Code: [Select]
[root@mimime ~]# yum history info 43 Loaded plugins: fastestmirror, post-transaction-actions, priorities, smeserver Transaction ID : 43 Begin time : Tue Sep 27 08:22:31 2022 Begin rpmdb : 1373:cfca41d085297993863efd779d07bf4d7a1e8e2d End time : 08:25:33 2022 (182 seconds) End rpmdb : 1373:26334c21fa6511969afa45e6e301cacd63310ae7 User : root <root> Return-Code : Success Command Line : update Transaction performed with: Installed rpm-4.11.3-48.el7_9.x86_64 @smeupdates Installed yum-3.4.3-168.el7.centos.noarch @anaconda/10.0 Installed yum-plugin-fastestmirror-1.1.31-54.el7_8.noarch @anaconda/10.0 Packages Altered: Updated ImageMagick6-libs-6.9.12.63-1.el7.remi.x86_64 @remi-safe Update 6.9.12.64-1.el7.remi.x86_64 @remi-safe Updated bglibs-1.102-2.el7.sme.x86_64 @anaconda/10.0 Update 2.04-1.x86_64 @smeos Updated ca-certificates-2021.2.50-72.el7_9.noarch @smeupdates Update 2022.2.54-74.el7_9.noarch @smeupdates Updated cvm-0.82-1.el7.sme.x86_64 @anaconda/10.0 Update 0.97-1.el7.sme.x86_64 @smeos Updated e-smith-apache-2.6.0-16.el7.sme.noarch @smeupdates Update 2.6.0-22.el7.sme.noarch @smeos Updated e-smith-base-5.8.1-16.el7.sme.x86_64 @smeupdates Update 5.8.1-18.el7.sme.x86_64 @smeos Updated e-smith-cvm-unix-local-2.6.0-4.el7.sme.noarch @smeupdates Update 2.6.0-10.el7.sme.noarch @smeos Updated e-smith-email-5.6.0-17.el7.sme.noarch @smeupdates Update 5.6.0-19.el7.sme.noarch @smeos Updated e-smith-ibays-2.6.0-17.el7.sme.noarch @anaconda/10.0 Update 2.6.0-19.el7.sme.noarch @smeos Updated e-smith-manager-2.8.0-34.el7.sme.x86_64 @anaconda/10.0 Update 2.8.0-37.el7.sme.x86_64 @smeos Updated e-smith-proxy-5.6.0-10.el7.sme.noarch @smeupdates Update 5.6.0-11.el7.sme.noarch @smeos Updated libsmbclient-4.10.16-19.el7_9.x86_64 @smeupdates Update 4.10.16-20.el7_9.x86_64 @smeupdates Updated libwbclient-4.10.16-19.el7_9.x86_64 @smeupdates Update 4.10.16-20.el7_9.x86_64 @smeupdates Updated php55-php-pecl-zip-1.21.0-3.el7.remi.x86_64 @remi-safe Update 1.21.1-1.el7.remi.x86_64 @remi-safe Updated php56-php-pecl-zip-1.21.0-3.el7.remi.x86_64 @remi-safe Update 1.21.1-1.el7.remi.x86_64 @remi-safe Updated php70-php-pecl-zip-1.21.0-3.el7.remi.x86_64 @remi-safe Update 1.21.1-1.el7.remi.x86_64 @remi-safe Updated php71-php-pecl-zip-1.21.0-3.el7.remi.x86_64 @remi-safe Update 1.21.1-1.el7.remi.x86_64 @remi-safe Updated php72-php-pecl-zip-1.21.0-3.el7.remi.x86_64 @remi-safe Update 1.21.1-1.el7.remi.x86_64 @remi-safe Updated php73-php-pecl-zip-1.21.0-3.el7.remi.x86_64 @remi-safe Update 1.21.1-1.el7.remi.x86_64 @remi-safe Updated php74-php-pecl-apcu-5.1.21-1.el7.remi.x86_64 @remi-safe Update 5.1.22-1.el7.remi.x86_64 @remi-safe Updated php74-php-pecl-zip-1.21.0-3.el7.remi.x86_64 @remi-safe Update 1.21.1-1.el7.remi.x86_64 @remi-safe Updated php80-php-pecl-zip-1.21.0-3.el7.remi.x86_64 @remi-safe Update 1.21.1-1.el7.remi.x86_64 @remi-safe Updated php81-php-pecl-zip-1.21.0-3.el7.remi.x86_64 @remi-safe Update 1.21.1-1.el7.remi.x86_64 @remi-safe Updated samba-4.10.16-19.el7_9.x86_64 @smeupdates Update 4.10.16-20.el7_9.x86_64 @smeupdates Updated samba-client-4.10.16-19.el7_9.x86_64 @smeupdates Update 4.10.16-20.el7_9.x86_64 @smeupdates Updated samba-client-libs-4.10.16-19.el7_9.x86_64 @smeupdates Update 4.10.16-20.el7_9.x86_64 @smeupdates Updated samba-common-4.10.16-19.el7_9.noarch @smeupdates Update 4.10.16-20.el7_9.noarch @smeupdates Updated samba-common-libs-4.10.16-19.el7_9.x86_64 @smeupdates Update 4.10.16-20.el7_9.x86_64 @smeupdates Updated samba-common-tools-4.10.16-19.el7_9.x86_64 @smeupdates Update 4.10.16-20.el7_9.x86_64 @smeupdates Updated samba-libs-4.10.16-19.el7_9.x86_64 @smeupdates Update 4.10.16-20.el7_9.x86_64 @smeupdates Updated smeserver-horde-1.0.0-29.el7.sme.noarch @smeupdates Update 1.0.0-33.el7.sme.noarch @smeos Updated smeserver-php-3.0.0-42.el7.sme.x86_64 @smeupdates Update 3.0.0-43.el7.sme.x86_64 @smeos Updated smeserver-release-26:10.0-3.el7.sme.noarch @anaconda/10.0 Update 26:10.1-1.el7.sme.noarch @smeos history info
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: monoman on September 30, 2022, 01:33:03 AM: Code: [Select]
yum update
Code: [Select]
[root@mimime ~]# yum history info 44 Loaded plugins: fastestmirror, post-transaction-actions, priorities, smeserver Transaction ID : 44 Begin time : Wed Sep 28 08:39:36 2022 Begin rpmdb : 1373:26334c21fa6511969afa45e6e301cacd63310ae7 End time : 08:40:59 2022 (83 seconds) End rpmdb : 1373:23333a602a9df36d08735c43fc30e5c95dbe7300 User : root <root> Return-Code : Success Command Line : update Transaction performed with: Installed rpm-4.11.3-48.el7_9.x86_64 @smeupdates Installed yum-3.4.3-168.el7.centos.noarch @anaconda/10.0 Installed yum-plugin-fastestmirror-1.1.31-54.el7_8.noarch @anaconda/10.0 Packages Altered: Updated php71-php-7.1.33-20.el7.remi.x86_64 @remi-safe Update 7.1.33-22.el7.remi.x86_64 @remi-safe Updated php71-php-bcmath-7.1.33-20.el7.remi.x86_64 @remi-safe Update 7.1.33-22.el7.remi.x86_64 @remi-safe Updated php71-php-cli-7.1.33-20.el7.remi.x86_64 @remi-safe Update 7.1.33-22.el7.remi.x86_64 @remi-safe Updated php71-php-common-7.1.33-20.el7.remi.x86_64 @remi-safe Update 7.1.33-22.el7.remi.x86_64 @remi-safe Updated php71-php-enchant-7.1.33-20.el7.remi.x86_64 @remi-safe Update 7.1.33-22.el7.remi.x86_64 @remi-safe Updated php71-php-fpm-7.1.33-20.el7.remi.x86_64 @remi-safe Update 7.1.33-22.el7.remi.x86_64 @remi-safe Updated php71-php-gd-7.1.33-20.el7.remi.x86_64 @remi-safe Update 7.1.33-22.el7.remi.x86_64 @remi-safe Updated php71-php-imap-7.1.33-20.el7.remi.x86_64 @remi-safe Update 7.1.33-22.el7.remi.x86_64 @remi-safe Updated php71-php-intl-7.1.33-20.el7.remi.x86_64 @remi-safe Update 7.1.33-22.el7.remi.x86_64 @remi-safe Updated php71-php-json-7.1.33-20.el7.remi.x86_64 @remi-safe Update 7.1.33-22.el7.remi.x86_64 @remi-safe Updated php71-php-ldap-7.1.33-20.el7.remi.x86_64 @remi-safe Update 7.1.33-22.el7.remi.x86_64 @remi-safe Updated php71-php-mbstring-7.1.33-20.el7.remi.x86_64 @remi-safe Update 7.1.33-22.el7.remi.x86_64 @remi-safe Updated php71-php-mcrypt-7.1.33-20.el7.remi.x86_64 @remi-safe Update 7.1.33-22.el7.remi.x86_64 @remi-safe Updated php71-php-mysqlnd-7.1.33-20.el7.remi.x86_64 @remi-safe Update 7.1.33-22.el7.remi.x86_64 @remi-safe Updated php71-php-opcache-7.1.33-20.el7.remi.x86_64 @remi-safe Update 7.1.33-22.el7.remi.x86_64 @remi-safe Updated php71-php-pdo-7.1.33-20.el7.remi.x86_64 @remi-safe Update 7.1.33-22.el7.remi.x86_64 @remi-safe Updated php71-php-process-7.1.33-20.el7.remi.x86_64 @remi-safe Update 7.1.33-22.el7.remi.x86_64 @remi-safe Updated php71-php-snmp-7.1.33-20.el7.remi.x86_64 @remi-safe Update 7.1.33-22.el7.remi.x86_64 @remi-safe Updated php71-php-soap-7.1.33-20.el7.remi.x86_64 @remi-safe Update 7.1.33-22.el7.remi.x86_64 @remi-safe Updated php71-php-tidy-7.1.33-20.el7.remi.x86_64 @remi-safe Update 7.1.33-22.el7.remi.x86_64 @remi-safe Updated php71-php-xml-7.1.33-20.el7.remi.x86_64 @remi-safe Update 7.1.33-22.el7.remi.x86_64 @remi-safe Updated php71-php-xmlrpc-7.1.33-20.el7.remi.x86_64 @remi-safe Update 7.1.33-22.el7.remi.x86_64 @remi-safe Updated php72-php-7.2.34-11.el7.remi.x86_64 @remi-safe Update 7.2.34-13.el7.remi.x86_64 @remi-safe Updated php72-php-bcmath-7.2.34-11.el7.remi.x86_64 @remi-safe Update 7.2.34-13.el7.remi.x86_64 @remi-safe Updated php72-php-cli-7.2.34-11.el7.remi.x86_64 @remi-safe Update 7.2.34-13.el7.remi.x86_64 @remi-safe Updated php72-php-common-7.2.34-11.el7.remi.x86_64 @remi-safe Update 7.2.34-13.el7.remi.x86_64 @remi-safe Updated php72-php-enchant-7.2.34-11.el7.remi.x86_64 @remi-safe Update 7.2.34-13.el7.remi.x86_64 @remi-safe Updated php72-php-fpm-7.2.34-11.el7.remi.x86_64 @remi-safe Update 7.2.34-13.el7.remi.x86_64 @remi-safe Updated php72-php-gd-7.2.34-11.el7.remi.x86_64 @remi-safe Update 7.2.34-13.el7.remi.x86_64 @remi-safe Updated php72-php-imap-7.2.34-11.el7.remi.x86_64 @remi-safe Update 7.2.34-13.el7.remi.x86_64 @remi-safe Updated php72-php-intl-7.2.34-11.el7.remi.x86_64 @remi-safe Update 7.2.34-13.el7.remi.x86_64 @remi-safe Updated php72-php-json-7.2.34-11.el7.remi.x86_64 @remi-safe Update 7.2.34-13.el7.remi.x86_64 @remi-safe Updated php72-php-ldap-7.2.34-11.el7.remi.x86_64 @remi-safe Update 7.2.34-13.el7.remi.x86_64 @remi-safe Updated php72-php-mbstring-7.2.34-11.el7.remi.x86_64 @remi-safe Update 7.2.34-13.el7.remi.x86_64 @remi-safe Updated php72-php-mysqlnd-7.2.34-11.el7.remi.x86_64 @remi-safe Update 7.2.34-13.el7.remi.x86_64 @remi-safe Updated php72-php-opcache-7.2.34-11.el7.remi.x86_64 @remi-safe Update 7.2.34-13.el7.remi.x86_64 @remi-safe Updated php72-php-pdo-7.2.34-11.el7.remi.x86_64 @remi-safe Update 7.2.34-13.el7.remi.x86_64 @remi-safe Updated php72-php-process-7.2.34-11.el7.remi.x86_64 @remi-safe Update 7.2.34-13.el7.remi.x86_64 @remi-safe Updated php72-php-snmp-7.2.34-11.el7.remi.x86_64 @remi-safe Update 7.2.34-13.el7.remi.x86_64 @remi-safe Updated php72-php-soap-7.2.34-11.el7.remi.x86_64 @remi-safe Update 7.2.34-13.el7.remi.x86_64 @remi-safe Updated php72-php-tidy-7.2.34-11.el7.remi.x86_64 @remi-safe Update 7.2.34-13.el7.remi.x86_64 @remi-safe Updated php72-php-xml-7.2.34-11.el7.remi.x86_64 @remi-safe Update 7.2.34-13.el7.remi.x86_64 @remi-safe Updated php72-php-xmlrpc-7.2.34-11.el7.remi.x86_64 @remi-safe Update 7.2.34-13.el7.remi.x86_64 @remi-safe Updated php73-php-7.3.33-3.el7.remi.x86_64 @remi-safe Update 7.3.33-5.el7.remi.x86_64 @remi-safe Updated php73-php-bcmath-7.3.33-3.el7.remi.x86_64 @remi-safe Update 7.3.33-5.el7.remi.x86_64 @remi-safe Updated php73-php-cli-7.3.33-3.el7.remi.x86_64 @remi-safe Update 7.3.33-5.el7.remi.x86_64 @remi-safe Updated php73-php-common-7.3.33-3.el7.remi.x86_64 @remi-safe Update 7.3.33-5.el7.remi.x86_64 @remi-safe Updated php73-php-enchant-7.3.33-3.el7.remi.x86_64 @remi-safe Update 7.3.33-5.el7.remi.x86_64 @remi-safe Updated php73-php-fpm-7.3.33-3.el7.remi.x86_64 @remi-safe Update 7.3.33-5.el7.remi.x86_64 @remi-safe Updated php73-php-gd-7.3.33-3.el7.remi.x86_64 @remi-safe Update 7.3.33-5.el7.remi.x86_64 @remi-safe Updated php73-php-imap-7.3.33-3.el7.remi.x86_64 @remi-safe Update 7.3.33-5.el7.remi.x86_64 @remi-safe Updated php73-php-intl-7.3.33-3.el7.remi.x86_64 @remi-safe Update 7.3.33-5.el7.remi.x86_64 @remi-safe Updated php73-php-json-7.3.33-3.el7.remi.x86_64 @remi-safe Update 7.3.33-5.el7.remi.x86_64 @remi-safe Updated php73-php-ldap-7.3.33-3.el7.remi.x86_64 @remi-safe Update 7.3.33-5.el7.remi.x86_64 @remi-safe Updated php73-php-mbstring-7.3.33-3.el7.remi.x86_64 @remi-safe Update 7.3.33-5.el7.remi.x86_64 @remi-safe Updated php73-php-mysqlnd-7.3.33-3.el7.remi.x86_64 @remi-safe Update 7.3.33-5.el7.remi.x86_64 @remi-safe Updated php73-php-opcache-7.3.33-3.el7.remi.x86_64 @remi-safe Update 7.3.33-5.el7.remi.x86_64 @remi-safe Updated php73-php-pdo-7.3.33-3.el7.remi.x86_64 @remi-safe Update 7.3.33-5.el7.remi.x86_64 @remi-safe Updated php73-php-process-7.3.33-3.el7.remi.x86_64 @remi-safe Update 7.3.33-5.el7.remi.x86_64 @remi-safe Updated php73-php-snmp-7.3.33-3.el7.remi.x86_64 @remi-safe Update 7.3.33-5.el7.remi.x86_64 @remi-safe Updated php73-php-soap-7.3.33-3.el7.remi.x86_64 @remi-safe Update 7.3.33-5.el7.remi.x86_64 @remi-safe Updated php73-php-tidy-7.3.33-3.el7.remi.x86_64 @remi-safe Update 7.3.33-5.el7.remi.x86_64 @remi-safe Updated php73-php-xml-7.3.33-3.el7.remi.x86_64 @remi-safe Update 7.3.33-5.el7.remi.x86_64 @remi-safe Updated php73-php-xmlrpc-7.3.33-3.el7.remi.x86_64 @remi-safe Update 7.3.33-5.el7.remi.x86_64 @remi-safe Scriptlet output: 1 ===================================================================== 2 3 WARNING : PHP 7.2 have reached its "End of Life" in 4 November 2020. Even, if this package includes some of 5 the important security fix, backported from 7.4, the 6 UPGRADE to a maintained version is very strongly RECOMMENDED. 7 8 ===================================================================== 9 ===================================================================== 10 11 WARNING : PHP 7.3 have reached its "End of Life" in 12 December 2021. Even, if this package includes some of 13 the important security fix, backported from 7.4, the 14 UPGRADE to a maintained version is very strongly RECOMMENDED. 15 16 ===================================================================== 17 ===================================================================== 18 19 WARNING : PHP 7.1 have reached its "End of Life" in 20 December 2019. Even, if this package includes some of 21 the important security fix, backported from 7.4, the 22 UPGRADE to a maintained version is very strongly RECOMMENDED. 23 24 ===================================================================== history info

*** After this we noticed that NEXTCLOUD was unreachable redirecting from /nextcloud to /index.php (404)

Next migrated from mysql to mariadb
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: monoman on September 30, 2022, 01:33:59 AM: Code: [Select]
yum update --enablerepo=smecontribs
Code: [Select]
[root@mimime ~]# yum history info 45 Loaded plugins: fastestmirror, post-transaction-actions, priorities, smeserver Transaction ID : 45 Begin time : Thu Sep 29 14:31:34 2022 Begin rpmdb : 1373:23333a602a9df36d08735c43fc30e5c95dbe7300 End time : 14:33:41 2022 (127 seconds) End rpmdb : 1373:affa1a16c97a5d45e8d6c7c31362c62a76b91573 User : root <root> Return-Code : Success Command Line : update --enablerepo=smecontribs Transaction performed with: Installed rpm-4.11.3-48.el7_9.x86_64 @smeupdates Installed yum-3.4.3-168.el7.centos.noarch @anaconda/10.0 Installed yum-plugin-fastestmirror-1.1.31-54.el7_8.noarch @anaconda/10.0 Packages Altered: Updated php56-php-5.6.40-33.el7.remi.x86_64 @remi-safe Update 5.6.40-34.el7.remi.x86_64 @remi-safe Updated php56-php-bcmath-5.6.40-33.el7.remi.x86_64 @remi-safe Update 5.6.40-34.el7.remi.x86_64 @remi-safe Updated php56-php-cli-5.6.40-33.el7.remi.x86_64 @remi-safe Update 5.6.40-34.el7.remi.x86_64 @remi-safe Updated php56-php-common-5.6.40-33.el7.remi.x86_64 @remi-safe Update 5.6.40-34.el7.remi.x86_64 @remi-safe Updated php56-php-enchant-5.6.40-33.el7.remi.x86_64 @remi-safe Update 5.6.40-34.el7.remi.x86_64 @remi-safe Updated php56-php-fpm-5.6.40-33.el7.remi.x86_64 @remi-safe Update 5.6.40-34.el7.remi.x86_64 @remi-safe Updated php56-php-gd-5.6.40-33.el7.remi.x86_64 @remi-safe Update 5.6.40-34.el7.remi.x86_64 @remi-safe Updated php56-php-imap-5.6.40-33.el7.remi.x86_64 @remi-safe Update 5.6.40-34.el7.remi.x86_64 @remi-safe Updated php56-php-intl-5.6.40-33.el7.remi.x86_64 @remi-safe Update 5.6.40-34.el7.remi.x86_64 @remi-safe Updated php56-php-ldap-5.6.40-33.el7.remi.x86_64 @remi-safe Update 5.6.40-34.el7.remi.x86_64 @remi-safe Updated php56-php-mbstring-5.6.40-33.el7.remi.x86_64 @remi-safe Update 5.6.40-34.el7.remi.x86_64 @remi-safe Updated php56-php-mcrypt-5.6.40-33.el7.remi.x86_64 @remi-safe Update 5.6.40-34.el7.remi.x86_64 @remi-safe Updated php56-php-mysqlnd-5.6.40-33.el7.remi.x86_64 @remi-safe Update 5.6.40-34.el7.remi.x86_64 @remi-safe Updated php56-php-opcache-5.6.40-33.el7.remi.x86_64 @remi-safe Update 5.6.40-34.el7.remi.x86_64 @remi-safe Updated php56-php-pdo-5.6.40-33.el7.remi.x86_64 @remi-safe Update 5.6.40-34.el7.remi.x86_64 @remi-safe Updated php56-php-process-5.6.40-33.el7.remi.x86_64 @remi-safe Update 5.6.40-34.el7.remi.x86_64 @remi-safe Updated php56-php-snmp-5.6.40-33.el7.remi.x86_64 @remi-safe Update 5.6.40-34.el7.remi.x86_64 @remi-safe Updated php56-php-soap-5.6.40-33.el7.remi.x86_64 @remi-safe Update 5.6.40-34.el7.remi.x86_64 @remi-safe Updated php56-php-tidy-5.6.40-33.el7.remi.x86_64 @remi-safe Update 5.6.40-34.el7.remi.x86_64 @remi-safe Updated php56-php-xml-5.6.40-33.el7.remi.x86_64 @remi-safe Update 5.6.40-34.el7.remi.x86_64 @remi-safe Updated php56-php-xmlrpc-5.6.40-33.el7.remi.x86_64 @remi-safe Update 5.6.40-34.el7.remi.x86_64 @remi-safe Updated php70-php-7.0.33-33.el7.remi.x86_64 @remi-safe Update 7.0.33-35.el7.remi.x86_64 @remi-safe Updated php70-php-bcmath-7.0.33-33.el7.remi.x86_64 @remi-safe Update 7.0.33-35.el7.remi.x86_64 @remi-safe Updated php70-php-cli-7.0.33-33.el7.remi.x86_64 @remi-safe Update 7.0.33-35.el7.remi.x86_64 @remi-safe Updated php70-php-common-7.0.33-33.el7.remi.x86_64 @remi-safe Update 7.0.33-35.el7.remi.x86_64 @remi-safe Updated php70-php-enchant-7.0.33-33.el7.remi.x86_64 @remi-safe Update 7.0.33-35.el7.remi.x86_64 @remi-safe Updated php70-php-fpm-7.0.33-33.el7.remi.x86_64 @remi-safe Update 7.0.33-35.el7.remi.x86_64 @remi-safe Updated php70-php-gd-7.0.33-33.el7.remi.x86_64 @remi-safe Update 7.0.33-35.el7.remi.x86_64 @remi-safe Updated php70-php-imap-7.0.33-33.el7.remi.x86_64 @remi-safe Update 7.0.33-35.el7.remi.x86_64 @remi-safe Updated php70-php-intl-7.0.33-33.el7.remi.x86_64 @remi-safe Update 7.0.33-35.el7.remi.x86_64 @remi-safe Updated php70-php-json-7.0.33-33.el7.remi.x86_64 @remi-safe Update 7.0.33-35.el7.remi.x86_64 @remi-safe Updated php70-php-ldap-7.0.33-33.el7.remi.x86_64 @remi-safe Update 7.0.33-35.el7.remi.x86_64 @remi-safe Updated php70-php-mbstring-7.0.33-33.el7.remi.x86_64 @remi-safe Update 7.0.33-35.el7.remi.x86_64 @remi-safe Updated php70-php-mcrypt-7.0.33-33.el7.remi.x86_64 @remi-safe Update 7.0.33-35.el7.remi.x86_64 @remi-safe Updated php70-php-mysqlnd-7.0.33-33.el7.remi.x86_64 @remi-safe Update 7.0.33-35.el7.remi.x86_64 @remi-safe Updated php70-php-opcache-7.0.33-33.el7.remi.x86_64 @remi-safe Update 7.0.33-35.el7.remi.x86_64 @remi-safe Updated php70-php-pdo-7.0.33-33.el7.remi.x86_64 @remi-safe Update 7.0.33-35.el7.remi.x86_64 @remi-safe Updated php70-php-process-7.0.33-33.el7.remi.x86_64 @remi-safe Update 7.0.33-35.el7.remi.x86_64 @remi-safe Updated php70-php-snmp-7.0.33-33.el7.remi.x86_64 @remi-safe Update 7.0.33-35.el7.remi.x86_64 @remi-safe Updated php70-php-soap-7.0.33-33.el7.remi.x86_64 @remi-safe Update 7.0.33-35.el7.remi.x86_64 @remi-safe Updated php70-php-tidy-7.0.33-33.el7.remi.x86_64 @remi-safe Update 7.0.33-35.el7.remi.x86_64 @remi-safe Updated php70-php-xml-7.0.33-33.el7.remi.x86_64 @remi-safe Update 7.0.33-35.el7.remi.x86_64 @remi-safe Updated php70-php-xmlrpc-7.0.33-33.el7.remi.x86_64 @remi-safe Update 7.0.33-35.el7.remi.x86_64 @remi-safe Updated php74-php-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php74-php-bcmath-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php74-php-cli-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php74-php-common-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php74-php-enchant-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php74-php-fpm-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php74-php-gd-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php74-php-gmp-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php74-php-imap-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php74-php-intl-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php74-php-json-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php74-php-ldap-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php74-php-mbstring-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php74-php-mysqlnd-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php74-php-opcache-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php74-php-pdo-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php74-php-process-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php74-php-snmp-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php74-php-soap-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php74-php-sodium-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php74-php-tidy-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php74-php-xml-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php74-php-xmlrpc-7.4.30-1.el7.remi.x86_64 @remi-safe Update 7.4.32-1.el7.remi.x86_64 @remi-safe Updated php81-php-8.1.10-1.el7.remi.x86_64 @remi-safe Update 8.1.11-1.el7.remi.x86_64 @remi-safe Updated php81-php-bcmath-8.1.10-1.el7.remi.x86_64 @remi-safe Update 8.1.11-1.el7.remi.x86_64 @remi-safe Updated php81-php-cli-8.1.10-1.el7.remi.x86_64 @remi-safe Update 8.1.11-1.el7.remi.x86_64 @remi-safe Updated php81-php-common-8.1.10-1.el7.remi.x86_64 @remi-safe Update 8.1.11-1.el7.remi.x86_64 @remi-safe Updated php81-php-enchant-8.1.10-1.el7.remi.x86_64 @remi-safe Update 8.1.11-1.el7.remi.x86_64 @remi-safe Updated php81-php-fpm-8.1.10-1.el7.remi.x86_64 @remi-safe Update 8.1.11-1.el7.remi.x86_64 @remi-safe Updated php81-php-gd-8.1.10-1.el7.remi.x86_64 @remi-safe Update 8.1.11-1.el7.remi.x86_64 @remi-safe Updated php81-php-imap-8.1.10-1.el7.remi.x86_64 @remi-safe Update 8.1.11-1.el7.remi.x86_64 @remi-safe Updated php81-php-intl-8.1.10-1.el7.remi.x86_64 @remi-safe Update 8.1.11-1.el7.remi.x86_64 @remi-safe Updated php81-php-ldap-8.1.10-1.el7.remi.x86_64 @remi-safe Update 8.1.11-1.el7.remi.x86_64 @remi-safe Updated php81-php-mbstring-8.1.10-1.el7.remi.x86_64 @remi-safe Update 8.1.11-1.el7.remi.x86_64 @remi-safe Updated php81-php-mysqlnd-8.1.10-1.el7.remi.x86_64 @remi-safe Update 8.1.11-1.el7.remi.x86_64 @remi-safe Updated php81-php-opcache-8.1.10-1.el7.remi.x86_64 @remi-safe Update 8.1.11-1.el7.remi.x86_64 @remi-safe Updated php81-php-pdo-8.1.10-1.el7.remi.x86_64 @remi-safe Update 8.1.11-1.el7.remi.x86_64 @remi-safe Updated php81-php-process-8.1.10-1.el7.remi.x86_64 @remi-safe Update 8.1.11-1.el7.remi.x86_64 @remi-safe Updated php81-php-snmp-8.1.10-1.el7.remi.x86_64 @remi-safe Update 8.1.11-1.el7.remi.x86_64 @remi-safe Updated php81-php-soap-8.1.10-1.el7.remi.x86_64 @remi-safe Update 8.1.11-1.el7.remi.x86_64 @remi-safe Updated php81-php-sodium-8.1.10-1.el7.remi.x86_64 @remi-safe Update 8.1.11-1.el7.remi.x86_64 @remi-safe Updated php81-php-tidy-8.1.10-1.el7.remi.x86_64 @remi-safe Update 8.1.11-1.el7.remi.x86_64 @remi-safe Updated php81-php-xml-8.1.10-1.el7.remi.x86_64 @remi-safe Update 8.1.11-1.el7.remi.x86_64 @remi-safe Updated smeserver-nextcloud-1.2.0-17.el7.sme.noarch @smecontribs Update 1.2.0-19.el7.sme.noarch @smecontribs Scriptlet output: 1 ===================================================================== 2 3 WARNING : PHP 5.6 have reached its "End of Life" in 4 January 2019. Even, if this package includes some of 5 the important security fix, backported from 7.4, the 6 UPGRADE to a maintained version is very strongly RECOMMENDED. 7 8 ===================================================================== 9 ===================================================================== 10 11 WARNING : PHP 7.0 have reached its "End of Life" in 12 December 2018. Even, if this package includes some of 13 the important security fix, backported from 7.4, the 14 UPGRADE to a maintained version is very strongly RECOMMENDED. 15 16 ===================================================================== history info
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: Jean-Philippe Pialasse on September 30, 2022, 02:34:22 AM: Code: [Select]
/sbin/e-smith/audittools/templates |grep httpd
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: monoman on September 30, 2022, 02:46:22 AM: Quote from: Jean-Philippe Pialasse on September 30, 2022, 02:34:22 AM
Code: [Select]
/sbin/e-smith/audittools/templates |grep httpd

Oh, you meant e-smith templates. I thought you may have meant something related to nextcloud.

No custom templates.
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: Jean-Philippe Pialasse on September 30, 2022, 09:20:56 PM: what says httpd logs ? particularly error one
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: monoman on October 01, 2022, 12:39:34 AM: Quote from: Jean-Philippe Pialasse on September 30, 2022, 09:20:56 PM
what says httpd logs ? particularly error one

access.log

Code: [Select]
solportal.com.au 203.129.60.44 - - [01/Oct/2022:08:25:00 +1000] "GET /nextcloud/ HTTP/1.1" 200 16281 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36"
error.log
Code: [Select]
[Sat Oct 01 01:12:02.941867 2022] [mpm_prefork:notice] [pid 3030] AH00171: Graceful restart requested, doing restart [Sat Oct 01 01:12:02.977742 2022] [mpm_prefork:notice] [pid 3030] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips configured -- resuming normal operations [Sat Oct 01 01:12:02.977750 2022] [core:notice] [pid 3030] AH00094: Command line: '/usr/sbin/httpd -f /etc/httpd/conf/httpd.conf -D FOREGROUND' [Sat Oct 01 08:21:34.241394 2022] [mpm_prefork:notice] [pid 3030] AH00171: Graceful restart requested, doing restart [Sat Oct 01 08:21:34.251013 2022] [mpm_prefork:notice] [pid 3030] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips configured -- resuming normal operations [Sat Oct 01 08:21:34.251022 2022] [core:notice] [pid 3030] AH00094: Command line: '/usr/sbin/httpd -f /etc/httpd/conf/httpd.conf -D FOREGROUND' [Sat Oct 01 08:23:26.376993 2022] [mpm_prefork:notice] [pid 3030] AH00171: Graceful restart requested, doing restart [Sat Oct 01 08:23:26.386490 2022] [mpm_prefork:notice] [pid 3030] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips configured -- resuming normal operations [Sat Oct 01 08:23:26.386498 2022] [core:notice] [pid 3030] AH00094: Command line: '/usr/sbin/httpd -f /etc/httpd/conf/httpd.conf -D FOREGROUND'
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: Jean-Philippe Pialasse on October 01, 2022, 03:51:38 AM: i see only 200 ok there. no 404
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: monoman on October 01, 2022, 04:42:29 AM: Quote from: Jean-Philippe Pialasse on October 01, 2022, 03:51:38 AM
i see only 200 ok there. no 404

Perhaps you missed the 404 error was earlier on in the process

Code: [Select]
Getting 404 accessing nextcloud Opp. Forgot to migrate db - done ran Nextcloud-update Now getting 403 and primary site (under construction) 29/9 - sme-nextcloud update Nextcloud now displays app update required screen
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: Jean-Philippe Pialasse on October 01, 2022, 06:57:22 AM: but you do not provide any log of this 404 and no related errors in error log.

so all i can see from the log you post is :
- server started normally
- nextcloud is accessible and served normally.
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: monoman on October 01, 2022, 07:41:39 AM: Quote from: Jean-Philippe Pialasse on October 01, 2022, 06:57:22 AM
but you do not provide any log of this 404 and no related errors in error log.

so all i can see from the log you post is :
- server started normally
- nextcloud is accessible and served normally.

You are correct. I did not provide evidence of 404 as it no longer exists after I remembered to migrate the db to mariadb and then run nextcloud-update and yum updated nextcloud. This was all explained in my OP.

Now I get this screen saying "APP UPDATE REQUIRED". (I've tried to add it as an attachment but that is not working. File size 188kb.)

If I try to update as requested, I get the follow response

Code: [Select]
Update to 23.0.8 Doctrine\DBAL\Schema\SchemaException: The table with name 'nextcloud.oc_authorized_groups' already exists. Detailed logs Preparing update Set log level to debug Turned on maintenance mode Repair step: Repair MySQL collation Repair info: All tables already have the correct collation -> nothing to do Repair step: Repair SQLite autoincrement Repair step: Copy data from accounts table when migrating from ownCloud Repair step: Drop account terms table when migrating from ownCloud Updating database schema Doctrine\DBAL\Schema\SchemaException: The table with name 'nextcloud.oc_authorized_groups' already exists. The update was unsuccessful. Please report this issue to the Nextcloud community.
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: Jean-Philippe Pialasse on October 01, 2022, 01:50:16 PM: use occ command line to update

occ maintenance:repair

occ update

this is a nextcloud bug, you would have found this using the big G or your favorite search as first result

https://github.com/nextcloud/server/issues/31710
or
https://help.nextcloud.com/t/upgrade-to-nextcloud-23-failed-and-stuck-in-update-mode/128288
or
https://help.nextcloud.com/t/update-23-0-0-10-to-23-0-2-1054-unknown-column-argument-hash/134235/2

if not fixed by one of those options, then
post at nextcloud either help forum or bug you will have more nextcloud skilled peoples there to help than here. this dors not seems sme related. You can the link the post here if anyone encounter same issue.
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: monoman on October 01, 2022, 02:05:15 PM: Quote from: Jean-Philippe Pialasse on October 01, 2022, 01:50:16 PM
use occ command line to update

occ maintenance:repair

occ update

this is a nextcloud bug, you would have found this using the big G or your favorite search as first result

https://github.com/nextcloud/server/issues/31710
or
https://help.nextcloud.com/t/upgrade-to-nextcloud-23-failed-and-stuck-in-update-mode/128288
or
https://help.nextcloud.com/t/update-23-0-0-10-to-23-0-2-1054-unknown-column-argument-hash/134235/2

if not fixed by one of those options, then
post at nextcloud either help forum or bug you will have more nextcloud skilled peoples there to help than here. this dors not seems sme related. You can the link the post here if anyone encounter same issue.

Code: [Select]
[root@mimime ~]# occ maintenance:repair Nextcloud or one of the apps require upgrade - only a limited number of commands are available You may use your browser or the occ upgrade command to do the upgrade - Repair MySQL collation - All tables already have the correct collation -> nothing to do - Repair mime types - Clean tags and favorites - 0 tags of deleted users have been removed. - 0 tags for delete files have been removed. - 0 tag entries for deleted tags have been removed. - 0 tags with no entries have been removed. - Repair invalid shares - Move .step file of updater to backup location - Add move avatar background job - Repair step already executed - Add preview cleanup background jobs - Migrate oauth2_clients table to nextcloud schema - Update the oauth2_access_tokens table schema. - Update the oauth2_clients table schema. - Fix potential broken mount points - No mounts updated - Repair language codes - Install new core bundle components - Add log rotate job - ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause' - Clear frontend caches - Image cache cleared - SCSS cache cleared - JS cache cleared - Clear every generated avatar on major updates - Add preview background cleanup job - ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause' - Queue a one-time job to cleanup old backups of the updater - ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause' - Cleanup invalid photocache files for carddav - Add background job to cleanup login flow v2 tokens - ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause' - Remove potentially over exposing share links - No need to remove link shares. - Clear access cache of projects - Reset generated avatar flag - Keep legacy encryption enabled - Check encryption key format - Remove old dashboard app config data - Add job to cleanup the bruteforce entries - ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause' - Queue a one-time job to check for user uploaded certificates - Repair DAV shares - Add background job to set the lookup server share state for users - ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause' - Update name of the stored view - Fix component of birthday calendars - 4 birthday calendars updated. - Regenerating birthday calendars to use new icons and fix old birthday events without year - Repair step already executed - Fix broken values of calendar objects 0 [->--------------------------] - Registering building of calendar search index as background job - Repair step already executed - Register building of social profile search index as background job - Registering background jobs to update cache for webcal calendars - Added 0 background jobs to update webcal calendars - Registering building of calendar reminder index as background job - Repair step already executed - Clean up orphan event and contact data - 0 events without a calendar have been cleaned up - 0 properties without an events have been cleaned up - 0 changes without a calendar have been cleaned up - 0 cached events without a calendar subscription have been cleaned up - 0 changes without a calendar subscription have been cleaned up - 0 contacts without an addressbook have been cleaned up - 0 properties without a contact have been cleaned up - 0 changes without an addressbook have been cleaned up - Remove activity entries of private events - Removed 0 activity entries - Clean up old calendar subscriptions from deleted users that were not cleaned-up 0 [----->----------------------] - 0 calendar subscriptions without an user have been cleaned up - Fix the share type of guest shares when migrating from ownCloud - Copy the share password into the dedicated column - Set existing shares as accepted - Update OAuth token expiration times - Create help command - Invalidate access cache for projects conversation provider - Cache the user display names - Switches from default updater server to the customer one if a valid subscription is available - Send an admin notification if monthly report is disabled - ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause' - Add background job to check for backup codes - ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause' - Insert UUIDFix background job for user and group in batches - Remove deprecated refresh time markers for LDAP user records - Populating added database structures for workflows
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: Jean-Philippe Pialasse on October 02, 2022, 03:50:52 AM: and after that ?
the second command as suggested here ?

https://help.nextcloud.com/t/update-23-0-0-10-to-23-0-2-1054-unknown-column-argument-hash/134235

Code: [Select]
occ update
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: monoman on October 02, 2022, 05:17:37 AM: Code: [Select]
[root@mimime httpd]# occ update Nextcloud or one of the apps require upgrade - only a limited number of commands are available You may use your browser or the occ upgrade command to do the upgrade Command "update" is not defined. Did you mean one of these? app:update maintenance:mimetype:update-db maintenance:mimetype:update-js maintenance:theme:update maintenance:update:htaccess
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: Jean-Philippe Pialasse on October 02, 2022, 05:24:06 AM: sorry

Code: [Select]
occ upgrade
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: Jean-Philippe Pialasse on October 02, 2022, 05:27:40 AM: also to fix part of your issue you could do, before :

Code: [Select]
occ db:add-missing-columns occ db:add-missing-indices occ db:add-missing-primary-keys occ maintenance:repair
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: monoman on October 02, 2022, 05:37:15 AM: Quote from: Jean-Philippe Pialasse on October 02, 2022, 03:52:09 AM
@monoman those are likely two different situations.

On yours you had a 404, then a 403 error, which were one kind of error against httpd, and I am still waiting for you to show the logs so I can find a way to reproduce this step.

error.log

Code: [Select]
[Wed Sep 28 08:40:41.794759 2022] [mpm_prefork:notice] [pid 11087] AH00170: caught SIGWINCH, shutting down gracefully [Wed Sep 28 08:40:43.089661 2022] [mpm_prefork:notice] [pid 18915] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips configured -- resuming normal operations [Wed Sep 28 08:40:43.089729 2022] [core:notice] [pid 18915] AH00094: Command line: '/usr/sbin/httpd -f /etc/httpd/conf/httpd.conf -D FOREGROUND' [Wed Sep 28 08:41:24.814032 2022] [mpm_prefork:notice] [pid 18915] AH00171: Graceful restart requested, doing restart [Wed Sep 28 08:41:24.823607 2022] [mpm_prefork:notice] [pid 18915] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips configured -- resuming normal operations [Wed Sep 28 08:41:24.823615 2022] [core:notice] [pid 18915] AH00094: Command line: '/usr/sbin/httpd -f /etc/httpd/conf/httpd.conf -D FOREGROUND' [Wed Sep 28 08:41:43.330469 2022] [mpm_prefork:notice] [pid 18915] AH00171: Graceful restart requested, doing restart [Wed Sep 28 08:41:43.339631 2022] [mpm_prefork:notice] [pid 18915] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips configured -- resuming normal operations [Wed Sep 28 08:41:43.339639 2022] [core:notice] [pid 18915] AH00094: Command line: '/usr/sbin/httpd -f /etc/httpd/conf/httpd.conf -D FOREGROUND' [Wed Sep 28 13:56:56.871492 2022] [authz_core:error] [pid 20480] [client 192.168.10.128:58801] AH01630: client denied by server configuration: /usr/share/nextcloud/index.php [Wed Sep 28 13:56:56.871524 2022] [authz_core:error] [pid 20480] [client 192.168.10.128:58801] AH01630: client denied by server configuration: /usr/share/nextcloud/ [Wed Sep 28 13:56:59.705022 2022] [authz_core:error] [pid 20480] [client 192.168.10.128:58801] AH01630: client denied by server configuration: /usr/share/nextcloud/index.php [Wed Sep 28 13:56:59.705125 2022] [authz_core:error] [pid 20480] [client 192.168.10.128:58801] AH01630: client denied by server configuration: /usr/share/nextcloud/ [Wed Sep 28 14:38:40.402194 2022] [authz_core:error] [pid 21904] [client 192.168.10.128:59812] AH01630: client denied by server configuration: /usr/share/nextcloud/index.php [Wed Sep 28 14:38:40.402323 2022] [authz_core:error] [pid 21904] [client 192.168.10.128:59812] AH01630: client denied by server configuration: /usr/share/nextcloud/ [Wed Sep 28 15:28:24.162289 2022] [authz_core:error] [pid 21705] [client 192.168.10.128:61476] AH01630: client denied by server configuration: /usr/share/nextcloud/index.php [Wed Sep 28 15:28:24.162321 2022] [authz_core:error] [pid 21705] [client 192.168.10.128:61476] AH01630: client denied by server configuration: /usr/share/nextcloud/ [Wed Sep 28 15:28:41.833997 2022] [authz_core:error] [pid 20473] [client 192.168.10.128:61477] AH01630: client denied by server configuration: /usr/share/nextcloud [Wed Sep 28 15:28:41.834215 2022] [authz_core:error] [pid 20473] [client 192.168.10.128:61477] AH01630: client denied by server configuration: /usr/share/nextcloud/index.php [Wed Sep 28 15:29:04.849237 2022] [authz_core:error] [pid 20698] [client 192.168.10.128:61478] AH01630: client denied by server configuration: /usr/share/nextcloud [Wed Sep 28 15:29:04.849464 2022] [authz_core:error] [pid 20698] [client 192.168.10.128:61478] AH01630: client denied by server configuration: /usr/share/nextcloud/index.php [Wed Sep 28 15:31:40.495983 2022] [authz_core:error] [pid 20478] [client 115.64.155.158:55744] AH01630: client denied by server configuration: /usr/share/nextcloud [Wed Sep 28 15:31:40.496189 2022] [authz_core:error] [pid 20478] [client 115.64.155.158:55744] AH01630: client denied by server configuration: /usr/share/nextcloud/index.php [Thu Sep 29 01:12:02.725063 2022] [mpm_prefork:notice] [pid 18915] AH00171: Graceful restart requested, doing restart [Thu Sep 29 01:12:02.735104 2022] [mpm_prefork:notice] [pid 18915] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips configured -- resuming normal operations [Thu Sep 29 01:12:02.735114 2022] [core:notice] [pid 18915] AH00094: Command line: '/usr/sbin/httpd -f /etc/httpd/conf/httpd.conf -D FOREGROUND' [Thu Sep 29 04:12:16.015120 2022] [core:error] [pid 24276] [client 152.89.196.211:37750] AH00126: Invalid URI in request POST /cgi-bin/.%2e/.%2e/.%2e/.%2e/bin/sh HTTP/1.1 [Thu Sep 29 09:30:12.089816 2022] [core:error] [pid 26673] [client 92.118.39.30:45974] AH00126: Invalid URI in request GET /../../proc/cpuinfo HTTP/1.1 [Thu Sep 29 13:37:07.693322 2022] [authz_core:error] [pid 26668] [client 115.64.155.158:60065] AH01630: client denied by server configuration: /usr/share/nextcloud [Thu Sep 29 13:37:07.693519 2022] [authz_core:error] [pid 26668] [client 115.64.155.158:60065] AH01630: client denied by server configuration: /usr/share/nextcloud/index.php [Thu Sep 29 13:59:30.949836 2022] [mpm_prefork:notice] [pid 18915] AH00171: Graceful restart requested, doing restart [Thu Sep 29 13:59:30.959886 2022] [mpm_prefork:notice] [pid 18915] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips configured -- resuming normal operations [Thu Sep 29 13:59:30.959896 2022] [core:notice] [pid 18915] AH00094: Command line: '/usr/sbin/httpd -f /etc/httpd/conf/httpd.conf -D FOREGROUND' [Thu Sep 29 14:00:15.070031 2022] [authz_core:error] [pid 29817] [client 115.64.155.158:60201] AH01630: client denied by server configuration: /usr/share/nextcloud [Thu Sep 29 14:00:15.070109 2022] [authz_core:error] [pid 29817] [client 115.64.155.158:60201] AH01630: client denied by server configuration: /usr/share/nextcloud/index.php [Thu Sep 29 14:04:01.137824 2022] [mpm_prefork:notice] [pid 18915] AH00170: caught SIGWINCH, shutting down gracefully [Thu Sep 29 14:07:39.507194 2022] [mpm_prefork:notice] [pid 2965] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips configured -- resuming normal operations [Thu Sep 29 14:07:39.507248 2022] [core:notice] [pid 2965] AH00094: Command line: '/usr/sbin/httpd -f /etc/httpd/conf/httpd.conf -D FOREGROUND' [Thu Sep 29 14:08:13.984016 2022] [authz_core:error] [pid 3097] [client 192.168.10.140:59677] AH01630: client denied by server configuration: /usr/share/nextcloud [Thu Sep 29 14:08:13.984446 2022] [authz_core:error] [pid 3097] [client 192.168.10.140:59677] AH01630: client denied by server configuration: /usr/share/nextcloud/index.php [Thu Sep 29 14:14:23.976245 2022] [authz_core:error] [pid 5828] [client 192.168.10.140:59703] AH01630: client denied by server configuration: /usr/share/nextcloud [Thu Sep 29 14:14:23.976512 2022] [authz_core:error] [pid 5828] [client 192.168.10.140:59703] AH01630: client denied by server configuration: /usr/share/nextcloud/index.php [Thu Sep 29 14:16:30.759605 2022] [mpm_prefork:notice] [pid 2965] AH00171: Graceful restart requested, doing restart [Thu Sep 29 14:16:30.769452 2022] [mpm_prefork:notice] [pid 2965] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips configured -- resuming normal operations [Thu Sep 29 14:16:30.769460 2022] [core:notice] [pid 2965] AH00094: Command line: '/usr/sbin/httpd -f /etc/httpd/conf/httpd.conf -D FOREGROUND' [Thu Sep 29 14:16:46.740658 2022] [authz_core:error] [pid 6348] [client 192.168.10.140:59714] AH01630: client denied by server configuration: /usr/share/nextcloud [Thu Sep 29 14:17:33.834216 2022] [authz_core:error] [pid 6350] [client 192.168.10.140:59728] AH01630: client denied by server configuration: /usr/share/nextcloud [Thu Sep 29 14:17:36.687454 2022] [authz_core:error] [pid 6350] [client 192.168.10.140:59728] AH01630: client denied by server configuration: /usr/share/nextcloud [Thu Sep 29 14:17:39.506963 2022] [authz_core:error] [pid 6350] [client 192.168.10.140:59728] AH01630: client denied by server configuration: /usr/share/nextcloud [Thu Sep 29 14:17:51.941861 2022] [authz_core:error] [pid 6350] [client 192.168.10.140:59728] AH01630: client denied by server configuration: /usr/share/nextcloud [Thu Sep 29 14:19:09.900917 2022] [authz_core:error] [pid 6352] [client 192.168.10.140:60087] AH01630: client denied by server configuration: /usr/share/nextcloud [Thu Sep 29 14:20:52.919269 2022] [authz_core:error] [pid 6354] [client 192.168.10.140:60504] AH01630: client denied by server configuration: /usr/share/nextcloud [Thu Sep 29 14:33:06.753863 2022] [mpm_prefork:notice] [pid 2965] AH00171: Graceful restart requested, doing restart [Thu Sep 29 14:33:06.762981 2022] [mpm_prefork:notice] [pid 2965] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips configured -- resuming normal operations [Thu Sep 29 14:33:06.762988 2022] [core:notice] [pid 2965] AH00094: Command line: '/usr/sbin/httpd -f /etc/httpd/conf/httpd.conf -D FOREGROUND' [Thu Sep 29 14:35:19.534327 2022] [mpm_prefork:notice] [pid 2965] AH00171: Graceful restart requested, doing restart [Thu Sep 29 14:35:19.545162 2022] [mpm_prefork:notice] [pid 2965] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips configured -- resuming normal operations [Thu Sep 29 14:35:19.545174 2022] [core:notice] [pid 2965] AH00094: Command line: '/usr/sbin/httpd -f /etc/httpd/conf/httpd.conf -D FOREGROUND' [Thu Sep 29 15:03:18.465679 2022] [mpm_prefork:notice] [pid 2965] AH00170: caught SIGWINCH, shutting down gracefully [Thu Sep 29 15:05:25.298863 2022] [mpm_prefork:notice] [pid 3030] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips configured -- resuming normal operations [Thu Sep 29 15:05:25.298927 2022] [core:notice] [pid 3030] AH00094: Command line: '/usr/sbin/httpd -f /etc/httpd/conf/httpd.conf -D FOREGROUND' [Fri Sep 30 12:05:32.873577 2022] [mpm_prefork:notice] [pid 3030] AH00171: Graceful restart requested, doing restart [Fri Sep 30 12:05:32.883505 2022] [mpm_prefork:notice] [pid 3030] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips configured -- resuming normal operations [Fri Sep 30 12:05:32.883513 2022] [core:notice] [pid 3030] AH00094: Command line: '/usr/sbin/httpd -f /etc/httpd/conf/httpd.conf -D FOREGROUND' [Fri Sep 30 12:09:22.957212 2022] [mpm_prefork:notice] [pid 3030] AH00171: Graceful restart requested, doing restart [Fri Sep 30 12:09:22.966419 2022] [mpm_prefork:notice] [pid 3030] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips configured -- resuming normal operations [Fri Sep 30 12:09:22.966427 2022] [core:notice] [pid 3030] AH00094: Command line: '/usr/sbin/httpd -f /etc/httpd/conf/httpd.conf -D FOREGROUND' [Fri Sep 30 15:39:17.038133 2022] [core:error] [pid 21977] [client 161.35.86.181:57864] AH00126: Invalid URI in request GET /cgi-bin/.%2e/%2e%2e/%2e%2e/%2e%2e/%2e%2e/%2e%2e/%2e%2e/%2e%2e/%2e%2e/etc/hosts HTTP/1.1 [Sat Oct 01 01:12:02.941867 2022] [mpm_prefork:notice] [pid 3030] AH00171: Graceful restart requested, doing restart [Sat Oct 01 01:12:02.977742 2022] [mpm_prefork:notice] [pid 3030] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips configured -- resuming normal operations [Sat Oct 01 01:12:02.977750 2022] [core:notice] [pid 3030] AH00094: Command line: '/usr/sbin/httpd -f /etc/httpd/conf/httpd.conf -D FOREGROUND' [Sat Oct 01 08:21:34.241394 2022] [mpm_prefork:notice] [pid 3030] AH00171: Graceful restart requested, doing restart [Sat Oct 01 08:21:34.251013 2022] [mpm_prefork:notice] [pid 3030] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips configured -- resuming normal operations [Sat Oct 01 08:21:34.251022 2022] [core:notice] [pid 3030] AH00094: Command line: '/usr/sbin/httpd -f /etc/httpd/conf/httpd.conf -D FOREGROUND' [Sat Oct 01 08:23:26.376993 2022] [mpm_prefork:notice] [pid 3030] AH00171: Graceful restart requested, doing restart [Sat Oct 01 08:23:26.386490 2022] [mpm_prefork:notice] [pid 3030] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips configured -- resuming normal operations [Sat Oct 01 08:23:26.386498 2022] [core:notice] [pid 3030] AH00094: Command line: '/usr/sbin/httpd -f /etc/httpd/conf/httpd.conf -D FOREGROUND' [Sat Oct 01 08:56:50.469469 2022] [mpm_prefork:notice] [pid 3030] AH00171: Graceful restart requested, doing restart [Sat Oct 01 08:56:50.478624 2022] [mpm_prefork:notice] [pid 3030] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips configured -- resuming normal operations [Sat Oct 01 08:56:50.478632 2022] [core:notice] [pid 3030] AH00094: Command line: '/usr/sbin/httpd -f /etc/httpd/conf/httpd.conf -D FOREGROUND' [Sat Oct 01 22:02:25.807781 2022] [mpm_prefork:notice] [pid 3030] AH00171: Graceful restart requested, doing restart [Sat Oct 01 22:02:25.817123 2022] [mpm_prefork:notice] [pid 3030] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips configured -- resuming normal operations [Sat Oct 01 22:02:25.817129 2022] [core:notice] [pid 3030] AH00094: Command line: '/usr/sbin/httpd -f /etc/httpd/conf/httpd.conf -D FOREGROUND' [Sat Oct 01 22:07:08.059123 2022] [mpm_prefork:notice] [pid 3030] AH00171: Graceful restart requested, doing restart [Sat Oct 01 22:07:08.068333 2022] [mpm_prefork:notice] [pid 3030] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips configured -- resuming normal operations [Sat Oct 01 22:07:08.068341 2022] [core:notice] [pid 3030] AH00094: Command line: '/usr/sbin/httpd -f /etc/httpd/conf/httpd.conf -D FOREGROUND' [Sun Oct 02 03:46:05.484683 2022] [mpm_prefork:notice] [pid 3030] AH00170: caught SIGWINCH, shutting down gracefully
access.log emailed to
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: monoman on October 02, 2022, 05:39:16 AM: Quote from: Jean-Philippe Pialasse on October 02, 2022, 05:27:40 AM
also to fix part of your issue you could do, before :

Code: [Select]
occ db:add-missing-columns occ db:add-missing-indices occ db:add-missing-primary-keys occ maintenance:repair

Code: [Select]
[root@mimime httpd]# occ db:add-missing-columns Nextcloud or one of the apps require upgrade - only a limited number of commands are available You may use your browser or the occ upgrade command to do the upgrade Check columns of the comments table. Done. [root@mimime httpd]# occ db:add-missing-indices Nextcloud or one of the apps require upgrade - only a limited number of commands are available You may use your browser or the occ upgrade command to do the upgrade Check indices of the share table. Check indices of the filecache table. Check indices of the twofactor_providers table. Check indices of the login_flow_v2 table. Check indices of the whats_new table. Check indices of the cards table. Check indices of the cards_properties table. Check indices of the calendarobjects_props table. Check indices of the schedulingobjects table. Check indices of the oc_properties table. Check indices of the oc_jobs table. Done. [root@mimime httpd]# occ db:add-missing-primary-keys Nextcloud or one of the apps require upgrade - only a limited number of commands are available You may use your browser or the occ upgrade command to do the upgrade Check primary keys. Done. [root@mimime httpd]# occ maintenance:repair Nextcloud or one of the apps require upgrade - only a limited number of commands are available You may use your browser or the occ upgrade command to do the upgrade - Repair MySQL collation - All tables already have the correct collation -> nothing to do - Repair mime types - Clean tags and favorites - 0 tags of deleted users have been removed. - 0 tags for delete files have been removed. - 0 tag entries for deleted tags have been removed. - 0 tags with no entries have been removed. - Repair invalid shares - Move .step file of updater to backup location - Add move avatar background job - Repair step already executed - Add preview cleanup background jobs - Migrate oauth2_clients table to nextcloud schema - Update the oauth2_access_tokens table schema. - Update the oauth2_clients table schema. - Fix potential broken mount points - No mounts updated - Repair language codes - Install new core bundle components - Add log rotate job - ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause' - Clear frontend caches - Image cache cleared - SCSS cache cleared - JS cache cleared - Clear every generated avatar on major updates - Add preview background cleanup job - ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause' - Queue a one-time job to cleanup old backups of the updater - ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause' - Cleanup invalid photocache files for carddav - Add background job to cleanup login flow v2 tokens - ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause' - Remove potentially over exposing share links - No need to remove link shares. - Clear access cache of projects - Reset generated avatar flag - Keep legacy encryption enabled - Check encryption key format - Remove old dashboard app config data - Add job to cleanup the bruteforce entries - ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause' - Queue a one-time job to check for user uploaded certificates - Repair DAV shares - Add background job to set the lookup server share state for users - ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause' - Update name of the stored view - Fix component of birthday calendars - 4 birthday calendars updated. - Regenerating birthday calendars to use new icons and fix old birthday events without year - Repair step already executed - Fix broken values of calendar objects 0 [->--------------------------] - Registering building of calendar search index as background job - Repair step already executed - Register building of social profile search index as background job - Registering background jobs to update cache for webcal calendars - Added 0 background jobs to update webcal calendars - Registering building of calendar reminder index as background job - Repair step already executed - Clean up orphan event and contact data - 0 events without a calendar have been cleaned up - 0 properties without an events have been cleaned up - 0 changes without a calendar have been cleaned up - 0 cached events without a calendar subscription have been cleaned up - 0 changes without a calendar subscription have been cleaned up - 0 contacts without an addressbook have been cleaned up - 0 properties without a contact have been cleaned up - 0 changes without an addressbook have been cleaned up - Remove activity entries of private events - Removed 0 activity entries - Clean up old calendar subscriptions from deleted users that were not cleaned-up 0 [----->----------------------] - 0 calendar subscriptions without an user have been cleaned up - Fix the share type of guest shares when migrating from ownCloud - Copy the share password into the dedicated column - Set existing shares as accepted - Update OAuth token expiration times - Create help command - Invalidate access cache for projects conversation provider - Invalidation not required - Cache the user display names - Switches from default updater server to the customer one if a valid subscription is available - Repair step already executed - Send an admin notification if monthly report is disabled - ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause' - Add background job to check for backup codes - ERROR: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'argument_hash' in 'where clause' - Insert UUIDFix background job for user and group in batches - Remove deprecated refresh time markers for LDAP user records - Populating added database structures for workflows
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: Jean-Philippe Pialasse on October 02, 2022, 06:08:35 AM: Quote
[Wed Sep 28 13:56:56.871524 2022] [authz_core:error] [pid 20480] [client 192.168.10.128:58801] AH01630: client denied by server configuration: /usr/share/nextcloud/
[Wed Sep 28 13:56:59.705022 2022] [authz_core:error] [pid 20480] [client 192.168.10.128:58801] AH01630: client denied by server configuration: /usr/share/nextcloud/index.php
sound like there was still a template with older auth syntax, or an update did change the www:www ownership of the files in /usr/share/nextcloud/
the signal-event nextcloud-update could have fixed both so we will never know.

so what gives

Code: [Select]
occ upgrade
if it is successful then issue
Code: [Select]
occ maintenance:mode --off
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: monoman on October 02, 2022, 06:33:18 AM: Quote from: Jean-Philippe Pialasse on October 02, 2022, 06:08:35 AM
sound like there was still a template with older auth syntax, or an update did change the www:www ownership of the files in /usr/share/nextcloud/
the signal-event nextcloud-update could have fixed both so we will never know.

so what gives

Code: [Select]
occ upgrade
if it is successful then issue
Code: [Select]
occ maintenance:mode --off

I did issue a signal-event nextcloud-update after migrating the db and upgrading the contrib

Code: [Select]
[root@mimime ~]# occ upgrade Nextcloud or one of the apps require upgrade - only a limited number of commands are available You may use your browser or the occ upgrade command to do the upgrade Setting log level to debug Turned on maintenance mode Updating database schema Doctrine\DBAL\Schema\SchemaException: The table with name 'nextcloud.oc_authorized_groups' already exists. Update failed Maintenance mode is kept active
I have a backup of the old mysql db if that's of any use.
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: Jean-Philippe Pialasse on October 02, 2022, 07:09:52 AM: Quote from: monoman on October 02, 2022, 06:33:18 AM
I did issue a signal-event nextcloud-update after migrating the db and upgrading the contrib

Code: [Select]
[root@mimime ~]# occ upgrade Nextcloud or one of the apps require upgrade - only a limited number of commands are available You may use your browser or the occ upgrade command to do the upgrade Setting log level to debug Turned on maintenance mode Updating database schema Doctrine\DBAL\Schema\SchemaException: The table with name 'nextcloud.oc_authorized_groups' already exists. Update failed Maintenance mode is kept active
I have a backup of the old mysql db if that's of any use.

that is probably your better bet, I would bet that one attempt to update failed for whatever reason and only partial db was converted.

you could try to remove the nextcloud.oc_authorized_groups table and f it fails to upgrade with occ upgrade simply restore your db and give another try.
Title: Re: Nextcloud woes after recent sme and Nextcloud updates
Post by: monoman on October 02, 2022, 08:18:11 AM: Quote from: Jean-Philippe Pialasse on October 02, 2022, 07:09:52 AM
you could try to remove the nextcloud.oc_authorized_groups table and f it fails to upgrade with occ upgrade simply restore your db and give another try.

Problem solved.

1. I restored the db backup I made when migrating to mariadb after the the nextcloud contrib upgrade and I renamed

Code: [Select]
echo "RENAME TABLE nextcloud.oc_authorized_groups TO nextcloud.oc_authorized_groups_backup;" | mysql105
Next I executed

Code: [Select]
occ db:add-missing-columns occ db:add-missing-indices occ db:add-missing-primary-keys occ upgrade occ maintenance:mode --off
Thanks for your patience.

SMF 2.0.19 | SMF © 2021, Simple Machines
Privacy Policy | Terms and Policies