{ "version": "https://jsonfeed.org/version/1.1", "user_comment": "This feed allows you to read the posts from this site in any feed reader that supports the JSON Feed format. To add this feed to your reader, copy the following URL -- https://matoken.org/blog/category/ostatus/feed/json/ -- and add it your reader.", "home_page_url": "https://matoken.org/blog/category/ostatus/", "feed_url": "https://matoken.org/blog/category/ostatus/feed/json/", "language": "ja", "title": "Ostatus – matoken's blog", "description": "Is there no plan B?", "icon": "https://matoken.org/blog/wp-content/uploads/2025/03/cropped-1865f695c4eecc844385acef2f078255036adccd42c254580ea3844543ab56d9.jpeg", "items": [ { "id": "http://matoken.org/blog/?p=2334", "url": "https://matoken.org/blog/2019/03/23/im-having-trouble-accessing-gnu-social-and-it-wont-show-anything/", "title": "GNU social \u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3068\u306a\u306b\u3082\u8868\u793a\u3055\u308c\u306a\u304f\u306a\u3063\u3066\u56f0\u308b", "content_html": "

gnusocial

\n
\n

\u3055\u3063\u304d\u307e\u3067\u306f\u52d5\u3044\u3066\u3044\u305f\u306e\u306b\u30a6\u30a7\u30d6\u30d6\u30e9\u30a6\u30b6(qutebrowser)\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u30a2\u30c3\u30d7\u306b\u8ffd\u5f93\u3059\u308b\u305f\u3081\u306b\u518d\u8d77\u52d5\u3057\u3066\uff0c\u81ea\u5206\u7528 GNU social \u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3068\u753b\u9762\u304c\u771f\u3063\u767d\u3067\u3059><
\n\u30b9\u30de\u30fc\u30c8\u30d5\u30a9\u30f3\u306e\u30a2\u30d7\u30ea\u7d4c\u7531(Twidere)\u3060\u3068\u52d5\u4f5c\u3057\u3066\u3044\u308b\u306e\u3067\u8868\u793a\u5468\u308a\u306e\u554f\u984c\u3067\u3057\u3087\u3046\u304b?

\n
\n
\n

config.php \u306e
\n$config['site']['logfile'] \u306b\u6307\u5b9a\u3057\u3066\u3044\u308b\u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u3092\u78ba\u8a8d\u3059\u308b\u3068\u3053\u3093\u306a\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u3042\u308a\u307e\u3057\u305f\uff0e

\n
\n
\n
\n
2019-03-22 14:35:28 LOG_DEBUG: [gnusocial.matoken.org:29424.bda9531d GET /] action.php - Server error '500' on 'qvitter': Class 'Locale' not found\r\n2019-03-22 14:35:28 LOG_ERR: [gnusocial.matoken.org:29424.bda9531d GET /] Handled serverError (500) but cannot output into desired format (NULL): 'Class \\'Locale\\' not found'\r\n2019-03-22 14:35:28 LOG_ERR: [gnusocial.matoken.org:29424.bda9531d GET /] ServerErrorAction: 500 Class 'Locale' not found
\n
\n
\n
\n

\u3053\u306e\u3042\u305f\u308a\u3067\u4f7f\u304a\u3046\u3068\u3057\u3066\u3044\u308b\u3088\u3046

\n
\n
\n
\n
$ find plugins/Qvitter -type f -print0 | xargs -0 grep -n Locale\r\nplugins/Qvitter/actions/qvitter.php:341:                    window.usersLanguageNameInEnglish = <?php print json_encode(Locale::getDisplayLanguage($user_browser_language, 'en')) ?>;\r\nplugins/Qvitter/actions/qvitter.php:462:                                                $languagecodesandnames[$lancode]['english_name'] = Locale::getDisplayName($lancode, 'en');\r\nplugins/Qvitter/actions/qvitter.php:463:                                                $languagecodesandnames[$lancode]['name'] = Locale::getDisplayName($lancode, $lancode);
\n
\n
\n
\n

\u3053\u308c\u304c\u898b\u3064\u304b\u3089\u306a\u3044\u304b\u5b58\u5728\u3057\u306a\u3044\u72b6\u614b\u306e\u3088\u3046\u3067\u3059\uff0e

\n
\n
\n\n
\n
\n

\u305d\u308c\u3089\u3057\u3044package \u3092\u63a2\u3057\u3066\uff0c

\n
\n
\n
\n
$ apt-cache search ^php international\r\nphp-horde-idna - IDNA backend normalization package\r\nphp-horde-ingo - An email filter rules manager\r\nphp-intl - Internationalisation module for PHP [default]\r\nphp-net-idna2 - PHP Pear module for handling international domain names\r\nphp-symfony-translation - tools to internationalize an application\r\nphp7.2-intl - Internationalisation module for PHP\r\nphpmyadmin - MySQL web administration tool\r\nphp7.0-intl - Internationalisation module for PHP
\n
\n
\n
\n
\n
$ apt show php-intl\r\nPackage: php-intl\r\nVersion: 1:7.2+60ubuntu1\r\nPriority: optional\r\nSection: universe/php\r\nSource: php-defaults (60ubuntu1)\r\nOrigin: Ubuntu\r\nMaintainer: Ubuntu Developers <ubuntu-devel-discuss@lists.ubuntu.com>\r\nOriginal-Maintainer: Debian PHP Maintainers <pkg-php-maint@lists.alioth.debian.org>\r\nBugs: https://bugs.launchpad.net/ubuntu/+filebug\r\nInstalled-Size: 12.3 kB\r\nDepends: php-common, php7.2-intl\r\nDownload-Size: 2,012 B\r\nAPT-Sources: http://jp.archive.ubuntu.com/ubuntu bionic/universe amd64 Packages\r\nDescription: Internationalisation module for PHP [default]\r\n This package provides a Internationalisation module for PHP.\r\n .\r\n PHP (recursive acronym for PHP: Hypertext Preprocessor) is a widely-used\r\n open source general-purpose scripting language that is especially suited\r\n for web development and can be embedded into HTML.\r\n .\r\n This package is a dependency package, which depends on Ubuntu's default\r\n PHP version (currently 7.2).
\n
\n
\n
\n

\u5c0e\u5165\u3059\u308b\u3053\u3068\u3067\u89e3\u6c7a\u3057\u307e\u3057\u305f\uff0e

\n
\n
\n
\n
sudo apt-get install php7.2-intl
\n
\n
\n
\n

\u6050\u3089\u304f php \u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u4e0a\u3052\u305f\u3068\u304d\u306b\u6f0f\u308c\u3066\u3057\u307e\u3044\uff0cAPI \u306a\u3069\u306f\u554f\u984c\u306a\u304f\u4f7f\u3048\u3066\u3044\u305f\u306e\u3067\u30a6\u30a7\u30d6\u30d6\u30e9\u30a6\u30b6\u3092\u518d\u8d77\u52d5\u3059\u308b\u307e\u3067\u6c17\u3065\u304b\u306a\u304b\u3063\u305f\u611f\u3058\u306e\u3088\u3046\u3067\u3059\uff0e

\n
\n
\n

\u3057\u304b\u3057\uff0cGNU social \u306f\u3053\u3046\u3044\u3046\u8b66\u544a\u3092\u3088\u304f\u898b\u304b\u3051\u308b\u306e\u3067\u3069\u3046\u306b\u304b\u3057\u306a\u3044\u3068\u3044\u3051\u306a\u3044\u3067\u3059\u306d\uff0e\u958b\u767a\u306f\u6ede\u3063\u3066\u3044\u308b\u611f\u3058\u306a\u306e\u3067 Pleroma \u3042\u305f\u308a\u306b\u79fb\u884c\u3059\u308b\u306e\u304c\u3044\u3044\u3093\u3067\u3057\u3087\u3046\u304c\u2026\u2026\uff0e

\n
\n
\n
\n
this will throw an Error in a future version of PHP
\n
\n
\n
\n

\u74b0\u5883

\n
\n
\n
\n
$ dpkg-query -W php7.2-intl\r\nphp7.2-intl     7.2.15-0ubuntu0.18.04.1\r\n$ w3m -dump https://gnusocial.matoken.org/nodeinfo/2.0|jq .software\r\n{\r\n  \"name\": \"gnusocial\",\r\n  \"version\": \"1.2.0-beta5\"\r\n}\r\n$ lsb_release -d\r\nDescription:    Ubuntu 18.04.2 LTS\r\n$ uname -m\r\nx86_64
\n
\n
\n

\n", "content_text": "\u3055\u3063\u304d\u307e\u3067\u306f\u52d5\u3044\u3066\u3044\u305f\u306e\u306b\u30a6\u30a7\u30d6\u30d6\u30e9\u30a6\u30b6(qutebrowser)\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u30a2\u30c3\u30d7\u306b\u8ffd\u5f93\u3059\u308b\u305f\u3081\u306b\u518d\u8d77\u52d5\u3057\u3066\uff0c\u81ea\u5206\u7528 GNU social \u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3068\u753b\u9762\u304c\u771f\u3063\u767d\u3067\u3059><\n\u30b9\u30de\u30fc\u30c8\u30d5\u30a9\u30f3\u306e\u30a2\u30d7\u30ea\u7d4c\u7531(Twidere)\u3060\u3068\u52d5\u4f5c\u3057\u3066\u3044\u308b\u306e\u3067\u8868\u793a\u5468\u308a\u306e\u554f\u984c\u3067\u3057\u3087\u3046\u304b?\n\n\nconfig.php \u306e\n$config['site']['logfile'] \u306b\u6307\u5b9a\u3057\u3066\u3044\u308b\u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u3092\u78ba\u8a8d\u3059\u308b\u3068\u3053\u3093\u306a\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u3042\u308a\u307e\u3057\u305f\uff0e\n\n\n\n2019-03-22 14:35:28 LOG_DEBUG: [gnusocial.matoken.org:29424.bda9531d GET /] action.php - Server error '500' on 'qvitter': Class 'Locale' not found\r\n2019-03-22 14:35:28 LOG_ERR: [gnusocial.matoken.org:29424.bda9531d GET /] Handled serverError (500) but cannot output into desired format (NULL): 'Class \\'Locale\\' not found'\r\n2019-03-22 14:35:28 LOG_ERR: [gnusocial.matoken.org:29424.bda9531d GET /] ServerErrorAction: 500 Class 'Locale' not found\n\n\n\n\u3053\u306e\u3042\u305f\u308a\u3067\u4f7f\u304a\u3046\u3068\u3057\u3066\u3044\u308b\u3088\u3046\n\n\n\n$ find plugins/Qvitter -type f -print0 | xargs -0 grep -n Locale\r\nplugins/Qvitter/actions/qvitter.php:341: window.usersLanguageNameInEnglish = <?php print json_encode(Locale::getDisplayLanguage($user_browser_language, 'en')) ?>;\r\nplugins/Qvitter/actions/qvitter.php:462: $languagecodesandnames[$lancode]['english_name'] = Locale::getDisplayName($lancode, 'en');\r\nplugins/Qvitter/actions/qvitter.php:463: $languagecodesandnames[$lancode]['name'] = Locale::getDisplayName($lancode, $lancode);\n\n\n\n\u3053\u308c\u304c\u898b\u3064\u304b\u3089\u306a\u3044\u304b\u5b58\u5728\u3057\u306a\u3044\u72b6\u614b\u306e\u3088\u3046\u3067\u3059\uff0e\n\n\n\n\nPHP: Locale – Manual\n\n\n\n\n\u305d\u308c\u3089\u3057\u3044package \u3092\u63a2\u3057\u3066\uff0c\n\n\n\n$ apt-cache search ^php international\r\nphp-horde-idna - IDNA backend normalization package\r\nphp-horde-ingo - An email filter rules manager\r\nphp-intl - Internationalisation module for PHP [default]\r\nphp-net-idna2 - PHP Pear module for handling international domain names\r\nphp-symfony-translation - tools to internationalize an application\r\nphp7.2-intl - Internationalisation module for PHP\r\nphpmyadmin - MySQL web administration tool\r\nphp7.0-intl - Internationalisation module for PHP\n\n\n\n\n$ apt show php-intl\r\nPackage: php-intl\r\nVersion: 1:7.2+60ubuntu1\r\nPriority: optional\r\nSection: universe/php\r\nSource: php-defaults (60ubuntu1)\r\nOrigin: Ubuntu\r\nMaintainer: Ubuntu Developers <ubuntu-devel-discuss@lists.ubuntu.com>\r\nOriginal-Maintainer: Debian PHP Maintainers <pkg-php-maint@lists.alioth.debian.org>\r\nBugs: https://bugs.launchpad.net/ubuntu/+filebug\r\nInstalled-Size: 12.3 kB\r\nDepends: php-common, php7.2-intl\r\nDownload-Size: 2,012 B\r\nAPT-Sources: http://jp.archive.ubuntu.com/ubuntu bionic/universe amd64 Packages\r\nDescription: Internationalisation module for PHP [default]\r\n This package provides a Internationalisation module for PHP.\r\n .\r\n PHP (recursive acronym for PHP: Hypertext Preprocessor) is a widely-used\r\n open source general-purpose scripting language that is especially suited\r\n for web development and can be embedded into HTML.\r\n .\r\n This package is a dependency package, which depends on Ubuntu's default\r\n PHP version (currently 7.2).\n\n\n\n\u5c0e\u5165\u3059\u308b\u3053\u3068\u3067\u89e3\u6c7a\u3057\u307e\u3057\u305f\uff0e\n\n\n\nsudo apt-get install php7.2-intl\n\n\n\n\u6050\u3089\u304f php \u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u4e0a\u3052\u305f\u3068\u304d\u306b\u6f0f\u308c\u3066\u3057\u307e\u3044\uff0cAPI \u306a\u3069\u306f\u554f\u984c\u306a\u304f\u4f7f\u3048\u3066\u3044\u305f\u306e\u3067\u30a6\u30a7\u30d6\u30d6\u30e9\u30a6\u30b6\u3092\u518d\u8d77\u52d5\u3059\u308b\u307e\u3067\u6c17\u3065\u304b\u306a\u304b\u3063\u305f\u611f\u3058\u306e\u3088\u3046\u3067\u3059\uff0e\n\n\n\u3057\u304b\u3057\uff0cGNU social \u306f\u3053\u3046\u3044\u3046\u8b66\u544a\u3092\u3088\u304f\u898b\u304b\u3051\u308b\u306e\u3067\u3069\u3046\u306b\u304b\u3057\u306a\u3044\u3068\u3044\u3051\u306a\u3044\u3067\u3059\u306d\uff0e\u958b\u767a\u306f\u6ede\u3063\u3066\u3044\u308b\u611f\u3058\u306a\u306e\u3067 Pleroma \u3042\u305f\u308a\u306b\u79fb\u884c\u3059\u308b\u306e\u304c\u3044\u3044\u3093\u3067\u3057\u3087\u3046\u304c\u2026\u2026\uff0e\n\n\n\nthis will throw an Error in a future version of PHP\n\n\n\n\u74b0\u5883\n\n\n\n$ dpkg-query -W php7.2-intl\r\nphp7.2-intl 7.2.15-0ubuntu0.18.04.1\r\n$ w3m -dump https://gnusocial.matoken.org/nodeinfo/2.0|jq .software\r\n{\r\n \"name\": \"gnusocial\",\r\n \"version\": \"1.2.0-beta5\"\r\n}\r\n$ lsb_release -d\r\nDescription: Ubuntu 18.04.2 LTS\r\n$ uname -m\r\nx86_64", "date_published": "2019-03-23T12:22:48+09:00", "date_modified": "2019-03-23T12:22:48+09:00", "authors": [ { "name": "matoken", "url": "https://matoken.org/blog/author/matoken/", "avatar": "https://secure.gravatar.com/avatar/38f5f3b575c5eb45cda6aa659bca119ac7a5e16b46565e869d0030e3bd66981d?s=512&d=mm&r=g" } ], "author": { "name": "matoken", "url": "https://matoken.org/blog/author/matoken/", "avatar": "https://secure.gravatar.com/avatar/38f5f3b575c5eb45cda6aa659bca119ac7a5e16b46565e869d0030e3bd66981d?s=512&d=mm&r=g" }, "tags": [ "GNU social", "php", "Bionic Beaver(18.04LTS)", "Linux", "Ostatus", "Ubuntu" ] }, { "id": "http://matoken.org/blog/?p=1838", "url": "https://matoken.org/blog/2018/02/19/time-line-of-my-gnu-social-is-very-slow/", "title": "\u81ea\u5206\u7528GNU social\u306e\u30bf\u30a4\u30e0\u30e9\u30a4\u30f3\u306e\u53cd\u6620\u304c\u3068\u3066\u3082\u9045\u304f\u306a\u3063\u3066\u56f0\u308b", "content_html": "

\u81ea\u5b85\u306ePC\u3067GNU social(nightly)\u3092\u52d5\u304b\u3057\u3066\u3044\u308b\u306e\u3067\u3059\u304c\uff0c\u3075\u3068\u6c17\u3065\u304f\u3068\u30bf\u30a4\u30e0\u30e9\u30a4\u30f3\u306e\u6700\u65b0\u304c30\u5206\u307b\u3069\u524d\u306b\u306a\u3063\u3066\u3044\u307e\u3059\uff0e\u81ea\u5206\u306e\u6295\u7a3f\u3082\u4ed6\u306eMastodon\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306a\u3069\u306b\u53cd\u6620\u3055\u308c\u3066\u3044\u307e\u305b\u3093\uff0e
\n\u30ed\u30b0(config.php\u306e$config['site']['logfile']\u3067\u8a2d\u5b9a\u3057\u3066\u3042\u308b\u3082\u306e)\u3092\u898b\u308b\u3068\u602a\u3057\u305d\u3046\u306a\u306e\u306f\u3053\u306e\u8fba\uff0e

\n
\n
2018-02-18 22:46:31 LOG_ERR: [gnusocial.matoken.org:8923.6a16ed84 GET /api/statuses/public_and_external_timeline.json?since_id=312334&count=20] OpportunisticQueueManager: [mirror:Notice 221617] Exception (ServerException) thrown: '[SubMirror] DB_DataObject error []: DB Error: no such table'\r\n
\n
\n

DB Error: no such table?\u6700\u8fd1\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3082\u30d7\u30e9\u30b0\u30a4\u30f3\u306e\u8ffd\u52a0\u306a\u3069\u3082\u3057\u305f\u899a\u3048\u304c\u306a\u3044\u306e\u3067\u95a2\u4fc2\u3042\u308b\u304b\u308f\u304b\u308a\u307e\u305b\u3093\uff0e\u9023\u5408\u304b\u3089\u306e\u6295\u7a3f\u3082\u6b21\u3005\u5c4a\u3044\u3066\u3044\u308b\u3057\uff0c\u9045\u3044\u306a\u304c\u3089\u3082\u30bf\u30a4\u30e0\u30e9\u30a4\u30f3\u306f\u66f4\u65b0\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u634c\u304d\u304d\u308c\u3066\u3044\u306a\u3044?\u3068QueueDaemon\u3092\u5897\u3084\u3057\u3066\u307f\u307e\u3057\u305f\uff0e

\n

daemon\u3092\u4e00\u65e6\u505c\u6b62\u3057\u3066\uff0c

\n
\n
$ sudo -u www-data scripts/stopdaemons.sh \r\n
\n
\n

config.php\u306b\u4ee5\u4e0b\u3092\u8ffd\u52a0\uff0c

\n
\n
$config['queue']['threads'] = 8;\r\n
\n
\n

\u518d\u5ea6daemon\u3092\u5b9f\u884c

\n
\n
$ sudo -u www-data scripts/startdaemons.sh \r\n
\n
\n

\u524d(cpu core\u304b\u30892threads\u3060\u3063\u305f)\u304b\u3089\u5909\u308f\u3063\u305f\u611f\u3058\u304c\u3057\u307e\u305b\u3093\uff0evmstat\u3092\u898b\u3066\u3082\u7279\u306b\u8ca0\u8377\u3082\u4e0a\u304c\u3063\u3066\u3044\u306a\u3044\u3088\u3046\u3067\u3059\uff0e

\n

log level\u3092\u4e0a\u3052\u3066\u307f\u3088\u3046\u3068config.php\u306b\u4ee5\u4e0b\u3092\u8a2d\u5b9a\u3057\u3066\u307f\u307e\u3057\u305f\u304c\u4e0a\u306e\u30a8\u30e9\u30fc\u3068\u540c\u3058\u3082\u306e\u3057\u304b\u898b\u5f53\u305f\u308a\u307e\u305b\u3093\uff0e

\n
\n
$config['site']['logdebug'] = true;\r\n
\n
\n

mysqlcheck --auto-repair\u3092\u8a66\u3057\u306b\u304b\u3051\u3066\u307f\u307e\u3057\u305f\u304c\u5909\u308f\u3089\u305a\uff0e

\n

\u305d\u3046\u3044\u3048\u3070plugin\u3092\u8ffd\u52a0\u3057\u305f\u3068\u304d\u7b49\u306b\u30ab\u30b9\u30bf\u30e0\u30c6\u30fc\u30d6\u30eb\u306e\u30c1\u30a7\u30c3\u30af\u3092\u3057\u3066\u304f\u308c\u308bscript(checkschema.php)\u304c\u3042\u3063\u305f\u306a\u3068\u8a66\u3057\u3066\u307f\u307e\u3057\u305f\uff0e

\n
\n
$ sudo -u www-data scripts/stopdaemons.sh \r\n$ sudo -u www-data php scripts/checkschema.php\r\nConstraint checking Notice table...\r\n* notice_reply_to_fkey (reply_to => notice.id)\r\n        Found 2 notices with reply_to NOT IN notice.id, reseting...DONE.\r\n* notice_repeat_of_fkey (repeat_of => notice.id)\r\n* notice_profile_id_fkey (profile_id => profile.id)\r\nPHP Warning:  fopen(/var/log/gnusocial.log): failed to open stream: ???????? in /export/data/www/gnusocial.matoken.org/lib/util.php on line 1853\r\nPHP Warning:  fopen(/var/log/gnusocial.log): failed to open stream: ???????? in /export/data/www/gnusocial.matoken.org/lib/util.php on line 1853\r\n  :\r\nPHP Warning:  fopen(/var/log/gnusocial.log): failed to open stream: ???????? in /export/data/www/gnusocial.matoken.org/lib/util.php on line 1853\r\nPHP Warning:  fopen(/var/log/gnusocial.log): failed to open stream: ???????? in /export/data/www/gnusocial.matoken.org/lib/util.php on line 1853\r\nEnsuring no NULL values for foreign keys in QvitterNotification...DONE.\r\nEnsuring no dead profile or notice IDs are stored in QvitterNotification...DONE.\r\n$ sudo -u www-data scripts/startdaemons.sh \r\n
\n
\n

\u3053\u308c\u304c\u5f53\u305f\u308a\u3060\u3063\u305f\u3088\u3046\u3067DB error\u306f\u6d88\u3048\u3066\u30bf\u30a4\u30e0\u30e9\u30a4\u30f3\u306e\u6d41\u901f\u3082\u623b\u308a\u307e\u3057\u305f\uff0e
\n\u539f\u56e0\u306f\u4e0d\u660e\u306e\u307e\u307e\u306a\u306e\u304c\u3061\u3087\u3063\u3068\u6c17\u6301\u3061\u60aa\u3044\u3067\u3059\u304c\uff0c\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u304b\u3089\u539f\u56e0\u3092\u63a2\u3059\u306e\u3082\u9762\u5012\u306a\u306e\u3067\u591a\u5206\u653e\u7f6e\u3067\u3059\u2026\u2026\uff0e

\n

\n", "content_text": "\u81ea\u5b85\u306ePC\u3067GNU social(nightly)\u3092\u52d5\u304b\u3057\u3066\u3044\u308b\u306e\u3067\u3059\u304c\uff0c\u3075\u3068\u6c17\u3065\u304f\u3068\u30bf\u30a4\u30e0\u30e9\u30a4\u30f3\u306e\u6700\u65b0\u304c30\u5206\u307b\u3069\u524d\u306b\u306a\u3063\u3066\u3044\u307e\u3059\uff0e\u81ea\u5206\u306e\u6295\u7a3f\u3082\u4ed6\u306eMastodon\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306a\u3069\u306b\u53cd\u6620\u3055\u308c\u3066\u3044\u307e\u305b\u3093\uff0e\n\u30ed\u30b0(config.php\u306e$config['site']['logfile']\u3067\u8a2d\u5b9a\u3057\u3066\u3042\u308b\u3082\u306e)\u3092\u898b\u308b\u3068\u602a\u3057\u305d\u3046\u306a\u306e\u306f\u3053\u306e\u8fba\uff0e\n\n2018-02-18 22:46:31 LOG_ERR: [gnusocial.matoken.org:8923.6a16ed84 GET /api/statuses/public_and_external_timeline.json?since_id=312334&count=20] OpportunisticQueueManager: [mirror:Notice 221617] Exception (ServerException) thrown: '[SubMirror] DB_DataObject error []: DB Error: no such table'\r\n\n\nDB Error: no such table?\u6700\u8fd1\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3082\u30d7\u30e9\u30b0\u30a4\u30f3\u306e\u8ffd\u52a0\u306a\u3069\u3082\u3057\u305f\u899a\u3048\u304c\u306a\u3044\u306e\u3067\u95a2\u4fc2\u3042\u308b\u304b\u308f\u304b\u308a\u307e\u305b\u3093\uff0e\u9023\u5408\u304b\u3089\u306e\u6295\u7a3f\u3082\u6b21\u3005\u5c4a\u3044\u3066\u3044\u308b\u3057\uff0c\u9045\u3044\u306a\u304c\u3089\u3082\u30bf\u30a4\u30e0\u30e9\u30a4\u30f3\u306f\u66f4\u65b0\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u634c\u304d\u304d\u308c\u3066\u3044\u306a\u3044?\u3068QueueDaemon\u3092\u5897\u3084\u3057\u3066\u307f\u307e\u3057\u305f\uff0e\ndaemon\u3092\u4e00\u65e6\u505c\u6b62\u3057\u3066\uff0c\n\n$ sudo -u www-data scripts/stopdaemons.sh \r\n\n\nconfig.php\u306b\u4ee5\u4e0b\u3092\u8ffd\u52a0\uff0c\n\n$config['queue']['threads'] = 8;\r\n\n\n\u518d\u5ea6daemon\u3092\u5b9f\u884c\n\n$ sudo -u www-data scripts/startdaemons.sh \r\n\n\n\u524d(cpu core\u304b\u30892threads\u3060\u3063\u305f)\u304b\u3089\u5909\u308f\u3063\u305f\u611f\u3058\u304c\u3057\u307e\u305b\u3093\uff0evmstat\u3092\u898b\u3066\u3082\u7279\u306b\u8ca0\u8377\u3082\u4e0a\u304c\u3063\u3066\u3044\u306a\u3044\u3088\u3046\u3067\u3059\uff0e\nlog level\u3092\u4e0a\u3052\u3066\u307f\u3088\u3046\u3068config.php\u306b\u4ee5\u4e0b\u3092\u8a2d\u5b9a\u3057\u3066\u307f\u307e\u3057\u305f\u304c\u4e0a\u306e\u30a8\u30e9\u30fc\u3068\u540c\u3058\u3082\u306e\u3057\u304b\u898b\u5f53\u305f\u308a\u307e\u305b\u3093\uff0e\n\n$config['site']['logdebug'] = true;\r\n\n\nmysqlcheck --auto-repair\u3092\u8a66\u3057\u306b\u304b\u3051\u3066\u307f\u307e\u3057\u305f\u304c\u5909\u308f\u3089\u305a\uff0e\n\u305d\u3046\u3044\u3048\u3070plugin\u3092\u8ffd\u52a0\u3057\u305f\u3068\u304d\u7b49\u306b\u30ab\u30b9\u30bf\u30e0\u30c6\u30fc\u30d6\u30eb\u306e\u30c1\u30a7\u30c3\u30af\u3092\u3057\u3066\u304f\u308c\u308bscript(checkschema.php)\u304c\u3042\u3063\u305f\u306a\u3068\u8a66\u3057\u3066\u307f\u307e\u3057\u305f\uff0e\n\n$ sudo -u www-data scripts/stopdaemons.sh \r\n$ sudo -u www-data php scripts/checkschema.php\r\nConstraint checking Notice table...\r\n* notice_reply_to_fkey (reply_to => notice.id)\r\n Found 2 notices with reply_to NOT IN notice.id, reseting...DONE.\r\n* notice_repeat_of_fkey (repeat_of => notice.id)\r\n* notice_profile_id_fkey (profile_id => profile.id)\r\nPHP Warning: fopen(/var/log/gnusocial.log): failed to open stream: ???????? in /export/data/www/gnusocial.matoken.org/lib/util.php on line 1853\r\nPHP Warning: fopen(/var/log/gnusocial.log): failed to open stream: ???????? in /export/data/www/gnusocial.matoken.org/lib/util.php on line 1853\r\n :\r\nPHP Warning: fopen(/var/log/gnusocial.log): failed to open stream: ???????? in /export/data/www/gnusocial.matoken.org/lib/util.php on line 1853\r\nPHP Warning: fopen(/var/log/gnusocial.log): failed to open stream: ???????? in /export/data/www/gnusocial.matoken.org/lib/util.php on line 1853\r\nEnsuring no NULL values for foreign keys in QvitterNotification...DONE.\r\nEnsuring no dead profile or notice IDs are stored in QvitterNotification...DONE.\r\n$ sudo -u www-data scripts/startdaemons.sh \r\n\n\n\u3053\u308c\u304c\u5f53\u305f\u308a\u3060\u3063\u305f\u3088\u3046\u3067DB error\u306f\u6d88\u3048\u3066\u30bf\u30a4\u30e0\u30e9\u30a4\u30f3\u306e\u6d41\u901f\u3082\u623b\u308a\u307e\u3057\u305f\uff0e\n\u539f\u56e0\u306f\u4e0d\u660e\u306e\u307e\u307e\u306a\u306e\u304c\u3061\u3087\u3063\u3068\u6c17\u6301\u3061\u60aa\u3044\u3067\u3059\u304c\uff0c\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u304b\u3089\u539f\u56e0\u3092\u63a2\u3059\u306e\u3082\u9762\u5012\u306a\u306e\u3067\u591a\u5206\u653e\u7f6e\u3067\u3059\u2026\u2026\uff0e", "date_published": "2018-02-19T20:04:25+09:00", "date_modified": "2018-02-20T02:36:50+09:00", "authors": [ { "name": "matoken", "url": "https://matoken.org/blog/author/matoken/", "avatar": "https://secure.gravatar.com/avatar/38f5f3b575c5eb45cda6aa659bca119ac7a5e16b46565e869d0030e3bd66981d?s=512&d=mm&r=g" } ], "author": { "name": "matoken", "url": "https://matoken.org/blog/author/matoken/", "avatar": "https://secure.gravatar.com/avatar/38f5f3b575c5eb45cda6aa659bca119ac7a5e16b46565e869d0030e3bd66981d?s=512&d=mm&r=g" }, "tags": [ "GNU social", "Ostatus" ] }, { "id": "http://matoken.org/blog/?p=1744", "url": "https://matoken.org/blog/2017/12/30/gnu-social-nightly/", "title": "GNU social\u3092nightly\u306b\u3057\u3066\u307f\u308b", "content_html": "

GNU social\u306f\u4ee5\u524d\u306floadaverage.org\u306b\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u6301\u3063\u3066\u3044\u305f\u306e\u3067\u3059\u304c\uff0c\u73fe\u5728\u306f\u81ea\u5206\u7528\u306b\u81ea\u5b85PC\u3067\u52d5\u304b\u3057\u3066\u3044\u307e\u3059\uff0e\u540c\u3058OStatus\u306eMastodon\u306f\u958b\u767a\u304c\u6d3b\u767a\u3067\u3059\u304c\uff0cGNU social\u306f\u305d\u308c\u306b\u6bd4\u3079\u308b\u3068\u5927\u5206\u9759\u304b\u3067\u3059\uff0e\u65b0\u3057\u3044\u6a5f\u80fd\u3082\u8a66\u3057\u3066\u307f\u305f\u3044\u3057nightly\u306b\u4e0a\u3052\u3066\u307f\u307e\u3057\u305f\uff0e

\n

\u5b9f\u969b\u8a66\u3057\u3066\u307f\u308b\u3068\u3044\u3064\u3082\u306eUPGRADE\u3068\u540c\u3058\u624b\u9806\u3067\u30c8\u30e9\u30d6\u30eb\u3082\u306a\u304fnightly\u306b\u3067\u304d\u307e\u3057\u305f\uff0e

\n

\u52d5\u3044\u3066\u3044\u308b GNU social \u3092\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3059\u308b

\n

\u5c0e\u5165\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u4ee5\u4e0b(\u3053\u3053\u3067\u306f /var/www/gnusocial.matoken.org )\u3068db\u3092\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u3066\u304a\u304f\uff0e
\n\u30c7\u30a4\u30ea\u30fc\u3067\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u3066\u3044\u308b\u306e\u3067\u4eca\u56de\u306f\u305d\u308c\u3092\u624b\u52d5\u3067\u56de\u3057\u3066tar ball\u306b\u3057\u3066\u304a\u3044\u305f\uff0e

\n
\n
$ sudo -u www-data rsync -avv /var/www/gnusocial.matoken.org \r\nionice -c2 -n7 nice -n19 rsync --stats -av --delete --link-dest=/export/backup/micro/gs/www/`/bin/date -d '1 day ago' +%Y%m%d`/ /var/www/gnusocial.matoken.org /export/backup/micro/gs/www/`/bin/date +\\%Y\\%m\\%d`/\r\n$ sudo -u www-data tar cvf - /export/backup/micro/gs/www/`/bin/date +\\%Y\\%m\\%d`/ > /export/backup/micro/gs/www/`/bin/date +\\%Y\\%m\\%d`-master2nightly.tar.xz\r\n$ umask 0266 && /usr/bin/mysqldump --defaults-file=/export/backup/micro/gs/db/.my-backup.cnf --opt --all-databases --events | /usr/bin/xz -9 > /export/backup/micro/gs/db/`date +\\%Y-\\%M-\\%d_\\%H:\\%m:\\%S_\\%s_$$`-master2nightly.sql.xz\r\n
\n
\n

nightly\u3092\u5c0e\u5165\u3059\u308b

\n

\u524d\u3082\u3063\u3066git lone\u3057\u3066\u3042\u3063\u305f\u3068\u3053\u308d\u306b\u79fb\u52d5\uff0eclone\u3057\u3066\u306a\u304b\u3063\u305f\u3089\u3059\u308b\uff0e

\n
\n
$ git clone https://git.gnu.io/gnu/gnu-social.git\r\n$ cd gnu-social\r\n
\n
\n

git pull\u3057\u3066nightly\u3092checkout\u3059\u308b\uff0e

\n
\n
$ git pull\r\n$ git checkout nightly\r\n
\n
\n

nightly\u3092cp\u3059\u308b\uff0esudo -u www-data \u306f httpd \u304c\u305d\u306e\u30e6\u30fc\u30b6\u30fc\u3067\u52d5\u3044\u3066\u3044\u3066\u30d5\u30a1\u30a4\u30eb\u3082\u305d\u306e\u6a29\u9650\u306b\u306a\u3063\u3066\u3044\u308b\u306e\u3067\u5408\u308f\u305b\u3066\u3044\u308b\uff0e

\n
\n
$ sudo -u www-data rsync -av --exclude={.git,.gitignore,.htaccess,config.php,file,avatar} ./ /var/www/gnusocial.matoken.org/\r\n
\n
\n

upgrade

\n

\u3053\u3053\u3067\u306f GNU social \u306e scripts/startdaemons.sh \u3092monit \u3067\u76e3\u8996\u3057\u3066\u3044\u308b\u306e\u3067\u4e00\u6642\u7684\u306b\u505c\u6b62\u3057\u3066\u304a\u304f\uff0emonit\u3084\u305d\u308c\u306b\u985e\u3059\u308b\u3082\u306e\u3092\u52d5\u304b\u3057\u3066\u306a\u3051\u308c\u3070\u7121\u8996\u3057\u3066\u6b21\u3078\uff0e

\n
\n
$ sudo service monit stop\r\n
\n
\n

UPGRADE \u30d5\u30a1\u30a4\u30eb\u306b\u66f8\u304b\u308c\u3066\u3044\u308b\u3068\u304a\u308a\uff0c\u30c7\u30fc\u30e2\u30f3\u3092\u505c\u6b62\u3057\u3066\uff0c\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u5b9f\u884c\u3092\u884c\u3044\uff0c\u30c7\u30fc\u30e2\u30f3\u3092\u518d\u958b\u3059\u308b\uff0e

\n
\n
$ cd /var/www/gnusocial.matoken.org/\r\n$ sudo -u www-data bash scripts/stopdaemons.sh\r\n$ sudo -u www-data php scripts/upgrade.php\r\n$ sudo -u www-data bash scripts/startdaemons.sh\r\n
\n
\n

\u3053\u308c\u3067\u52d5\u4f5c\u78ba\u8a8d\u304c\u3068\u308c\u305f\u3089OK
\nmonit\u3082\u518d\u958b\u3057\u3066\u304a\u304f\uff0e

\n
\n
$ sudo service monit start\r\n
\n
\n

GNU social\u306e\u30d5\u30c3\u30bf\u30fc\u306e\u30d0\u30fc\u30b7\u30e7\u30f3\u306f\u3053\u3046\u306a\u3063\u305f\uff0e

\n
\n

It runs on GNU social, version 1.2.0-beta5

\n
\n\n

\n", "content_text": "GNU social\u306f\u4ee5\u524d\u306floadaverage.org\u306b\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u6301\u3063\u3066\u3044\u305f\u306e\u3067\u3059\u304c\uff0c\u73fe\u5728\u306f\u81ea\u5206\u7528\u306b\u81ea\u5b85PC\u3067\u52d5\u304b\u3057\u3066\u3044\u307e\u3059\uff0e\u540c\u3058OStatus\u306eMastodon\u306f\u958b\u767a\u304c\u6d3b\u767a\u3067\u3059\u304c\uff0cGNU social\u306f\u305d\u308c\u306b\u6bd4\u3079\u308b\u3068\u5927\u5206\u9759\u304b\u3067\u3059\uff0e\u65b0\u3057\u3044\u6a5f\u80fd\u3082\u8a66\u3057\u3066\u307f\u305f\u3044\u3057nightly\u306b\u4e0a\u3052\u3066\u307f\u307e\u3057\u305f\uff0e\n\u5b9f\u969b\u8a66\u3057\u3066\u307f\u308b\u3068\u3044\u3064\u3082\u306eUPGRADE\u3068\u540c\u3058\u624b\u9806\u3067\u30c8\u30e9\u30d6\u30eb\u3082\u306a\u304fnightly\u306b\u3067\u304d\u307e\u3057\u305f\uff0e\n\u52d5\u3044\u3066\u3044\u308b GNU social \u3092\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3059\u308b\n\u5c0e\u5165\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u4ee5\u4e0b(\u3053\u3053\u3067\u306f /var/www/gnusocial.matoken.org )\u3068db\u3092\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u3066\u304a\u304f\uff0e\n\u30c7\u30a4\u30ea\u30fc\u3067\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u3066\u3044\u308b\u306e\u3067\u4eca\u56de\u306f\u305d\u308c\u3092\u624b\u52d5\u3067\u56de\u3057\u3066tar ball\u306b\u3057\u3066\u304a\u3044\u305f\uff0e\n\n$ sudo -u www-data rsync -avv /var/www/gnusocial.matoken.org \r\nionice -c2 -n7 nice -n19 rsync --stats -av --delete --link-dest=/export/backup/micro/gs/www/`/bin/date -d '1 day ago' +%Y%m%d`/ /var/www/gnusocial.matoken.org /export/backup/micro/gs/www/`/bin/date +\\%Y\\%m\\%d`/\r\n$ sudo -u www-data tar cvf - /export/backup/micro/gs/www/`/bin/date +\\%Y\\%m\\%d`/ > /export/backup/micro/gs/www/`/bin/date +\\%Y\\%m\\%d`-master2nightly.tar.xz\r\n$ umask 0266 && /usr/bin/mysqldump --defaults-file=/export/backup/micro/gs/db/.my-backup.cnf --opt --all-databases --events | /usr/bin/xz -9 > /export/backup/micro/gs/db/`date +\\%Y-\\%M-\\%d_\\%H:\\%m:\\%S_\\%s_$$`-master2nightly.sql.xz\r\n\n\nnightly\u3092\u5c0e\u5165\u3059\u308b\n\u524d\u3082\u3063\u3066git lone\u3057\u3066\u3042\u3063\u305f\u3068\u3053\u308d\u306b\u79fb\u52d5\uff0eclone\u3057\u3066\u306a\u304b\u3063\u305f\u3089\u3059\u308b\uff0e\n\n$ git clone https://git.gnu.io/gnu/gnu-social.git\r\n$ cd gnu-social\r\n\n\ngit pull\u3057\u3066nightly\u3092checkout\u3059\u308b\uff0e\n\n$ git pull\r\n$ git checkout nightly\r\n\n\nnightly\u3092cp\u3059\u308b\uff0esudo -u www-data \u306f httpd \u304c\u305d\u306e\u30e6\u30fc\u30b6\u30fc\u3067\u52d5\u3044\u3066\u3044\u3066\u30d5\u30a1\u30a4\u30eb\u3082\u305d\u306e\u6a29\u9650\u306b\u306a\u3063\u3066\u3044\u308b\u306e\u3067\u5408\u308f\u305b\u3066\u3044\u308b\uff0e\n\n$ sudo -u www-data rsync -av --exclude={.git,.gitignore,.htaccess,config.php,file,avatar} ./ /var/www/gnusocial.matoken.org/\r\n\n\nupgrade\n\u3053\u3053\u3067\u306f GNU social \u306e scripts/startdaemons.sh \u3092monit \u3067\u76e3\u8996\u3057\u3066\u3044\u308b\u306e\u3067\u4e00\u6642\u7684\u306b\u505c\u6b62\u3057\u3066\u304a\u304f\uff0emonit\u3084\u305d\u308c\u306b\u985e\u3059\u308b\u3082\u306e\u3092\u52d5\u304b\u3057\u3066\u306a\u3051\u308c\u3070\u7121\u8996\u3057\u3066\u6b21\u3078\uff0e\n\n$ sudo service monit stop\r\n\n\nUPGRADE \u30d5\u30a1\u30a4\u30eb\u306b\u66f8\u304b\u308c\u3066\u3044\u308b\u3068\u304a\u308a\uff0c\u30c7\u30fc\u30e2\u30f3\u3092\u505c\u6b62\u3057\u3066\uff0c\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u5b9f\u884c\u3092\u884c\u3044\uff0c\u30c7\u30fc\u30e2\u30f3\u3092\u518d\u958b\u3059\u308b\uff0e\n\n$ cd /var/www/gnusocial.matoken.org/\r\n$ sudo -u www-data bash scripts/stopdaemons.sh\r\n$ sudo -u www-data php scripts/upgrade.php\r\n$ sudo -u www-data bash scripts/startdaemons.sh\r\n\n\n\u3053\u308c\u3067\u52d5\u4f5c\u78ba\u8a8d\u304c\u3068\u308c\u305f\u3089OK\nmonit\u3082\u518d\u958b\u3057\u3066\u304a\u304f\uff0e\n\n$ sudo service monit start\r\n\n\nGNU social\u306e\u30d5\u30c3\u30bf\u30fc\u306e\u30d0\u30fc\u30b7\u30e7\u30f3\u306f\u3053\u3046\u306a\u3063\u305f\uff0e\n\nIt runs on GNU social, version 1.2.0-beta5\n\n\nmatoken social", "date_published": "2017-12-30T12:16:56+09:00", "date_modified": "2017-12-30T12:22:18+09:00", "authors": [ { "name": "matoken", "url": "https://matoken.org/blog/author/matoken/", "avatar": "https://secure.gravatar.com/avatar/38f5f3b575c5eb45cda6aa659bca119ac7a5e16b46565e869d0030e3bd66981d?s=512&d=mm&r=g" } ], "author": { "name": "matoken", "url": "https://matoken.org/blog/author/matoken/", "avatar": "https://secure.gravatar.com/avatar/38f5f3b575c5eb45cda6aa659bca119ac7a5e16b46565e869d0030e3bd66981d?s=512&d=mm&r=g" }, "tags": [ "GNU social", "Ostatus" ] } ] }