« previous next »

Pages: 1 2 [All] Go Down

Nextcloud woes after recent sme and Nextcloud updates

monoman

45
+0/-0

Nextcloud woes after recent sme and Nextcloud updates

« 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.

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]

« Last Edit: September 30, 2022, 01:12:46 AM by monoman »

Logged

Jean-Philippe Pialasse

2,761
+11/-0
aka Unnilennium

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #1 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 ?

Logged

monoman

45
+0/-0

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #2 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

# 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:

/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

Logged

monoman

45
+0/-0

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #3 on: September 30, 2022, 01:21:03 AM »

Recent upgrade history of server

[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

Logged

monoman

45
+0/-0

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #4 on: September 30, 2022, 01:32:17 AM »

Update details show command run and results

yum update

[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

Logged

monoman

45
+0/-0

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #5 on: September 30, 2022, 01:33:03 AM »

yum update

[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

« Last Edit: September 30, 2022, 01:38:55 AM by monoman »

Logged

monoman

45
+0/-0

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #6 on: September 30, 2022, 01:33:59 AM »

yum update --enablerepo=smecontribs

[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

Logged

Jean-Philippe Pialasse

2,761
+11/-0
aka Unnilennium

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #7 on: September 30, 2022, 02:34:22 AM »


/sbin/e-smith/audittools/templates |grep httpd

Logged

monoman

45
+0/-0

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #8 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.

Logged

Jean-Philippe Pialasse

2,761
+11/-0
aka Unnilennium

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #9 on: September 30, 2022, 09:20:56 PM »

what says httpd logs ? particularly error one

Logged

monoman

45
+0/-0

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #10 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

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

[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'

Logged

Jean-Philippe Pialasse

2,761
+11/-0
aka Unnilennium

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #11 on: October 01, 2022, 03:51:38 AM »

i see only 200 ok there. no 404

Logged

monoman

45
+0/-0

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #12 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

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

Logged

Jean-Philippe Pialasse

2,761
+11/-0
aka Unnilennium

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #13 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.

Logged

monoman

45
+0/-0

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #14 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

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.

Logged

Jean-Philippe Pialasse

2,761
+11/-0
aka Unnilennium

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #15 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.

Logged

monoman

45
+0/-0

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #16 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.

[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

Logged

Jean-Philippe Pialasse

2,761
+11/-0
aka Unnilennium

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #17 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

occ update

Logged

monoman

45
+0/-0

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #18 on: October 02, 2022, 05:17:37 AM »

[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

Logged

Jean-Philippe Pialasse

2,761
+11/-0
aka Unnilennium

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #19 on: October 02, 2022, 05:24:06 AM »

sorry

occ upgrade

Logged

Jean-Philippe Pialasse

2,761
+11/-0
aka Unnilennium

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #20 on: October 02, 2022, 05:27:40 AM »

also to fix part of your issue you could do, before :

occ db:add-missing-columns
occ db:add-missing-indices
occ db:add-missing-primary-keys
occ maintenance:repair

Logged

monoman

45
+0/-0

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #21 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

[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

Logged

monoman

45
+0/-0

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #22 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

[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

Logged

Jean-Philippe Pialasse

2,761
+11/-0
aka Unnilennium

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #23 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

occ upgrade
if it is successful then issue

occ maintenance:mode --off

Logged

monoman

45
+0/-0

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #24 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

[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.

« Last Edit: October 02, 2022, 06:41:06 AM by monoman »

Logged

Jean-Philippe Pialasse

2,761
+11/-0
aka Unnilennium

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #25 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.

Logged

monoman

45
+0/-0

Re: Nextcloud woes after recent sme and Nextcloud updates

« Reply #26 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

echo "RENAME TABLE nextcloud.oc_authorized_groups TO nextcloud.oc_authorized_groups_backup;" | mysql105
Next I executed

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.

Logged

Pages: 1 2 [All] Go Up

« previous next »