CONTENTS


Lastmodified 2024-03-29 (金) 11:44:38


サーバーにはメンテナンスウィンドウの開始時間が設定されていません。

https://manualmaton.com/2024/02/16/nextcloud-28-02%E3%81%AE%E3%82%A8%E3%83%A9%E3%83%BC%E3%80%8C%E3%83%A1%E3%83%B3%E3%83%86%E3%83%8A%E3%83%B3%E3%82%B9/

/usr/local/www/nextcloud/config

 'default_phone_region' => 'JP',
 'maintenance_window_start' => 1,        <--- この行を追加する
 'memcache.local' => '\\OC\\Memcache\\APCu',

Nextcloud internal server error

[Wed May 01 04:44:29.042409 2019] [php7:error] [pid 50726:tid 35051937792] [client xxx.aaa.bbb.ccc:57416] PHP Fatal error:
Uncaught Error: Undefined class constant 'PDO::FETCH_ASSOC' in /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php:172\n
Stack trace:\n#0
/usr/local/www/nextcloud/lib/private/DB/ConnectionFactory.php(158): Doctrine\\DBAL\\DriverManager::getConnection(Array, Object(Doctrine\\DBAL\\Configuration), Object(Doctrine\\Common\\EventManager))\n#1
/usr/local/www/nextcloud/lib/private/Server.php(641): OC\\DB\\ConnectionFactory->getConnection('mysql', Array)\n#2 
/usr/local/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\\Server->OC\\{closure}(Object(OC\\Server))\n#3 
/usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\\Container->offsetGet('OCP\\\\IDBConnecti...')\n#4 
/usr/local/www/nextcloud/lib/private/ServerContainer.php(132): OC\\AppFramework\\Utility\\SimpleContainer->query('OCP\\\\IDBConnecti...')\n#5 
/usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(165): OC\\ServerContainer->query('OCP\\\\IDBConnecti...')\n#6
/usr/local/www in 
/usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php on line 172
zend_mm_heap corrupted
Sun May 05 12:05:13.269627 2019] [core:notice] [pid 6169:tid 34397577216] AH00052: child pid 8189 exit signal Bus error (10)

Nextcloud セキュリティ&セットアップ警告

セットアップに関するいくつかのエラーがあります。

Some files have not passed the integrity check. Further information on how to resolve this issue can be found in the documentation. (List of invalid files… / Rescan…)
Your web server is not properly set up to resolve "/ocm-provider/". This is most likely related to a web server configuration that was not updated to deliver this folder directly. Please 
compare your configuration against the shipped rewrite rules in ".htaccess" for Apache or the provided one in the documentation for Nginx at it's documentation page. On Nginx those are 
typically the lines starting with "location ~" that need an update.
Your web server is not properly set up to resolve "/ocs-provider/". This is most likely related to a web server configuration that was not updated to deliver this folder directly. Please 
compare your configuration against the shipped rewrite rules in ".htaccess" for Apache or the provided one in the documentation for Nginx at it's documentation page. On Nginx those are 
typically the lines starting with "location ~" that need an update.
Your web server is not properly set up to resolve "/.well-known/caldav". Further information can be found in the documentation.
Your web server is not properly set up to resolve "/.well-known/carddav". Further information can be found in the documentation.
メモリキャッシュが設定されていません。可能であれば、パフォーマンスを向上するため、memcacheを設定してください。より詳しい情報はドキュメントで参照できます。
PHP OPcacheが適切に設定されていません。よりパフォーマンスを向上させるには、php.iniで次の設定を推奨します:
opcache.enable=1
opcache.enable_cli=1
opcache.interned_strings_buffer=8
opcache.max_accelerated_files=10000
opcache.memory_consumption=128
opcache.save_comments=1
opcache.revalidate_freq=1
This instance is missing some recommended PHP modules. For improved performance and better compatibility it is highly recommended to install them.
imagick
Some columns in the database are missing a conversion to big int. Due to the fact that changing column types on big tables could take some time they were not changed automatically. By 
running 'occ db:convert-filecache-bigint' those pending changes could be applied manually. This operation needs to be made while the instance is offline. For further details read the 
documentation page about this.

 filecache.mtime
 filecache.storage_mtime
インストールガイド ↗を再確認して、 ログ にあるすべてのエラーや警告を確認してください。
Check the security of your Nextcloud over our security scan ↗.

/.well-known/carddav

/usr/local/etc/apache24/includes/nextcloud.conf

Alias /nextcloud /usr/local/www/nextcloud
       AcceptPathInfo On
       KeepAlive On
       <Directory /usr/local/www/nextcloud>
           AllowOverride All
           Require all granted
           Header set Strict-Transport-Security "max-age=15768000; includeSubDomains; preload"
           
            <IfModule mod_dav.c>
		Dav off
	     </IfModule>
           
       </Directory>
       
        Redirect 301 /.well-known/carddav /nextcloud/remote.php/dav
        Redirect 301 /.well-known/caldav /nextcloud/remote.php/dav
       
SetEnv HOME /usr/local/www/nextcloud
SetEnv HTTP_HOME /usr/local/www/nextcloud

「occ db:convert-filecache-bigint」を実行する

https://gato.intaa.net/archives/13962

# chpass www

#Changing user information for www.
Login: www
Password: *
Uid [#]: 80
Gid [# or name]: 80
Change [month day year]:
Expire [month day year]:
Class:
Home directory: /nonexistent
Shell: /usr/sbin/nologin
Full Name: World Wide Web Owner
Office Location:
Office Phone:
Home Phone:
Other information:
Password: *
Uid [#]: 80
Gid [# or name]: 80
Change [month day year]:
Expire [month day year]:
Class:
Home directory: /usr/local/wwww
Shell: /bin/csh
Full Name: World Wide Web Owner
Office Location:
Office Phone:
Home Phone:
Other information:
chpass: user information unchanged
root@sun1:~:19_05_06:3:35 # su www
% cd /usr/local/www/nextcloud
% pwd
/usr/local/www/nextcloud
% php occ db:convert-filecache-bigint
Following columns will be updated:

* filecache.mtime
* filecache.storage_mtime

This can take up to hours, depending on the number of files in your instance!
Continue with the conversion (y/n)? [n] y

MySQL is used as database but does not support 4-byte characters

MySQL is used as database but does not support 4-byte characters. To be able to handle 4-byte characters (like emojis) without issues in filenames or comments for example it is recommended to enable the 4-byte support in MySQL. For further details read the documentation page about this.

https://docs.nextcloud.com/server/15/admin_manual/configuration_database/mysql_4byte_support.html

/usr/local/etc/my.cnf

[mysqld]
innodb_file_per_table=1

Restart the MySQL server

Change your databases character set and collation:

ALTER DATABASE nextcloud CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

Set the mysql.utf8mb4 config to true in your config.php:

# cd /usr/local/www/nextcloud
# sudo -u www php occ config:system:set mysql.utf8mb4 --type boolean --value="true"

System config value mysql.utf8mb4 set to boolean true

Convert all existing tables to the new collation by running the repair step:

$ sudo -u www php occ maintenance:repair

ここでエラー

max key length is 767 bytes

mysql5.7 以上へアップグレードする。と

# sudo -u www php occ maintenance:repair
- Repair MySQL collation
    - Change row format for oc_activity ...
    - Change collation for oc_activity ...
    - Change row format for oc_activity_mq ...
    - Change collation for oc_activity_mq ...
              :                :
    - Change row format for oc_federated_reshares ...
    - Change collation for oc_federated_reshares ...
- 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
- Remove shares of a users root folder
- Move .step file of updater to backup location
- Fix potential broken mount points
    - No mounts updated
- Repair invalid paths in file cache
- Add log rotate job
- Clear frontend caches
    - Image cache cleared
    - SCSS cache cleared
    - JS cache cleared
- Clear every generated avatar on major updates
- Add preview background cleanup job
- Queue a one-time job to cleanup old backups of the updater
- Repair pending cron jobs
    - No need to repair pending cron jobs.
- Extract the vcard uid and store it in the db
- Fix component of birthday calendars
    - 1 birthday calendars updated.
- Fix broken values of calendar objects
   0 [>---------------------------]
- Registering building of calendar search index as background job
    - Add background job
- Registering background jobs to update cache for webcal calendars
    - Added 0 background jobs to update webcal calendars
- Remove activity entries of private events
    - Removed 0 activity entries
- Fix the share type of guest shares when migrating from ownCloud
- Copy the share password into the dedicated column
- Update OAuth token expiration times
- Add background job to check for backup codes

root@sun1:/usr/local/www/nextcloud:19_05_06:14:29 #

すべてのチェックに合格しました。


Total access 1231:本日 1:昨日 0

Counter: 1231, today: 1, yesterday: 0

トップ   編集 凍結 差分 履歴 添付 複製 名前変更 リロード   新規 一覧 検索 最終更新   ヘルプ   最終更新のRSS
Last-modified: 2024-03-29 (金) 11:44:38