Misskey サーバー管理記録
2024年01月12日
2024年01月13日
画像がアップロードできない
code:bash
vim /home/misskey/misskey/.config/default.yml
code:default.yml
# Misskey configuration
# ┌─────┐
#───┘ URL └───────────────────────────────────────────────────── # Final accessible URL seen by a user.
ここのurlを書き換えて systemctl restart misskey を実行したら画像がアップロード出来るようになった。
2024年01月14日
Misskeyのアップデート
code:bash
root@vm-ed6af101-0c:/home/misskey/misskey# git status
HEAD detached at 13.14.2
root@vm-ed6af101-0c:/home/misskey/misskey# git branch
* (HEAD detached at 13.14.2)
develop
root@vm-ed6af101-0c:/home/misskey/misskey# git checkout master
Previous HEAD position was a8d45d4b0 Merge pull request #11384 from misskey-dev/develop Branch 'master' set up to track remote branch 'master' from 'origin'.
Switched to a new branch 'master'
root@vm-ed6af101-0c:/home/misskey/misskey# git pull
root@vm-ed6af101-0c:/home/misskey/misskey# git submodule update --init
root@vm-ed6af101-0c:/home/misskey/misskey# NODE_ENV=production pnpm install --frozen-lockfile
ERR_PNPM_UNSUPPORTED_ENGINE Unsupported environment (bad pnpm and/or Node.js version)
Your Node version is incompatible with "/home/misskey/misskey/packages/backend".
Expected version: >=20.10.0
Got: v20.5.1
This is happening because the package's manifest has an engines.node field specified.
To fix this issue, install the required Node version.
Nodeのバージョン上げ
code:bash
root@vm-ed6af101-0c:/home/misskey/misskey# sudo rm /usr/share/keyrings/nodesource.gpg
root@vm-ed6af101-0c:/home/misskey/misskey# sudo apt update
root@vm-ed6af101-0c:/home/misskey/misskey# sudo apt install -y nodejs
root@vm-ed6af101-0c:/home/misskey/misskey# apt show nodejs
Package: nodejs
Version: 20.5.1-deb-1nodesource1
Status: install ok installed
Node を 20.10.0 以上にあげた。nodenv を使う。
code:bash
root@vm-ed6af101-0c:/home/misskey/misskey# echo 'export PATH="$HOME/.nodenv/bin:$PATH"' >> ~/.bashrc
root@vm-ed6af101-0c:/home/misskey/misskey# echo 'eval "$(nodenv init -)"' >> ~/.bashrc
root@vm-ed6af101-0c:/home/misskey/misskey# source ~/.bashrc
root@vm-ed6af101-0c:/home/misskey/misskey# source ~/.bashrc
root@vm-ed6af101-0c:/home/misskey/misskey# nodenv --version
nodenv 1.4.1+79.15375bb
root@vm-ed6af101-0c:/home/misskey/misskey# nodenv install -list
root@vm-ed6af101-0c:/home/misskey/misskey# nodenv install 20.10.0
Downloading node-v20.10.0-linux-x64.tar.gz...
Installing node-v20.10.0-linux-x64...
Installed node-v20.10.0-linux-x64 to /root/.nodenv/versions/20.10.0
root@vm-ed6af101-0c:/home/misskey/misskey# node --version
v20.10.0
root@vm-ed6af101-0c:/home/misskey/misskey# nodenv global 20.10.0
root@vm-ed6af101-0c:/home/misskey/misskey# nodenv versions
system
* 20.10.0 (set by /home/misskey/misskey/.node-version)
20.11.0
もう一度 NODE_ENV=production pnpm install --frozen-lockfile を実行
code:bash
root@vm-ed6af101-0c:/home/misskey/misskey# NODE_ENV=production pnpm install --frozen-lockfile
Scope: all 6 workspace projects
? The modules directory at "/home/misskey/misskey/packages/misskey-js/node_modules" will be removed and reinstalled from scratch. Proceed? (Y/n) ‣ ? The modules directory at "/home/misskey/misskey/packages/misskey-js/generator/node_modules" will be removed and reinstalled from scratch. Proceed? (Y/n) ‣ ? The modules directory at "/home/misskey/misskey/packages/backend/node_modules" will be removed and reinstalled from scratch. Proceed? (Y/n) ‣ ? The modules directory at "/home/misskey/misskey/packages/frontend/node_modules" will be removed and reinstalled from scratch. Proceed? (Y/n) ‣ ? The modules directory at "/home/misskey/misskey/packages/sw/node_modules" will be removed and reinstalled from scratch. Proceed? (Y/n) ‣ true
╭──────────────────────────────────────────────────────────────────╮
│ │
│ Update available! 8.12.1 → 8.14.1. │
│ Run "corepack prepare pnpm@8.14.1 --activate" to update. │
│ │
│ │
✔ The modules directory at "/home/misskey/misskey/packages/misskey-js/generator/node_modules" will be removed and reinstalled from scratch. Proceed? (✔ The modules directory at "/home/misskey/misskey/packages/sw/node_modules" will be removed and reinstalled from scratch. Proceed? (Y/n) · true
e
Lockfile is up to date, resolution step is skipped
Packages: +404 -1620
+++++++++++++++++++++++++++++-----------------------------------------------------------------------------------------------------------------------
Downloading registry.npmjs.org/@swc/core-linux-x64-musl/1.3.100: 18.30 MB/18.30 MB, done
Downloading registry.npmjs.org/typescript/5.3.3: 5.76 MB/5.76 MB, done
Downloading registry.npmjs.org/@swc/core-linux-x64-gnu/1.3.100: 15.40 MB/15.40 MB, done
Downloading registry.npmjs.org/@tabler/icons/2.44.0: 5.50 MB/5.50 MB, done
Downloading registry.npmjs.org/three/0.159.0: 9.39 MB/9.39 MB, done
Progress: resolved 404, reused 53, downloaded 351, added 359, done
node_modules/.pnpm/@nestjs+core@10.2.10_@nestjs+common@10.2.10_reflect-metadata@0.1.14_rxjs@7.8.1/node_modules/@nestjs/core: Running postinstall scripnode_modules/.pnpm/@nestjs+core@10.2.10_@nestjs+common@10.2.10_reflect-metadata@0.1.14_rxjs@7.8.1/node_modules/@nestjs/core: Running postinstall scripnode_modules/.pnpm/sharp@0.32.6/node_modules/sharp: Running install script, done in 4.7s
node_modules/.pnpm/re2@1.20.9/node_modules/re2: Running install script, done in 3.3s
node_modules/.pnpm/vue-demi@0.13.11_vue@3.3.12/node_modules/vue-demi: Running postinstall script, done in 248ms
node_modules/.pnpm/@swc+core@1.3.100/node_modules/@swc/core: Running postinstall script, done in 227ms
node_modules/.pnpm/esbuild@0.19.8/node_modules/esbuild: Running postinstall script, done in 245ms
node_modules/.pnpm/esbuild@0.19.9/node_modules/esbuild: Running postinstall script, done in 268ms
node_modules/.pnpm/v-code-diff@1.7.2_vue@3.3.12/node_modules/v-code-diff: Running postinstall script, done in 223ms
node_modules/.pnpm/cbor-extract@2.1.1/node_modules/cbor-extract: Running install script, done in 320ms
dependencies:
+ cssnano 6.0.2
- execa 7.1.1
+ execa 8.0.1
- gulp 4.0.2
- gulp-cssnano 2.1.3
- gulp-rename 2.0.0
- gulp-replace 1.1.4
- gulp-terser 2.1.0
+ postcss 8.4.32
+ terser 5.26.0
- typescript 5.1.6
+ typescript 5.3.3
devDependencies:
- @types/gulp 4.0.10
- @types/gulp-rename 2.0.1
- @typescript-eslint/eslint-plugin 5.61.0
- @typescript-eslint/parser 5.61.0
- cross-env 7.0.3
- cypress 12.17.1
- eslint 8.45.0
- start-server-and-test 2.0.0
Done in 36.2s
root@vm-ed6af101-0c:/home/misskey/misskey# NODE_ENV=production pnpm run build
misskey@2023.12.2 build /home/misskey/misskey
pnpm build-pre && pnpm -r build && pnpm build-assets
misskey@2023.12.2 build-pre /home/misskey/misskey
node ./scripts/build-pre.js
Scope: 5 of 6 workspace projects
packages/misskey-js build$ tsc
└─ Done in 3.2s
packages/backend build$ swc src -d built -D
│ Successfully compiled: 779 files, copied 26 files with swc (771.35ms)
└─ Done in 1s
packages/frontend build$ vite build
│ ../../built/_vite_/pq2n0X2z.js 88.69 kB
│ ../../built/_vite_/sY6fKBGg.js 89.66 kB
│ ../../built/_vite_/GhmxpAP2.js 94.37 kB
│ ../../built/_vite_/GaX0tKTU.js 96.73 kB
│ ../../built/_vite_/SpbEIxoS.js 114.43 kB
│ ../../built/_vite_/rfvDQ5Yd.js 117.38 kB
│ ../../built/_vite_/QjIV7Lsd.js 176.25 kB
│ ../../built/_vite_/Fj1_oXRQ.js 301.47 kB
│ ../../built/_vite_/app-Dc2eRmTj.js 408.42 kB
│ ✓ built in 21.50s
└─ Done in 22.6s
packages/sw build$ node build.js
│ (node:90328) ExperimentalWarning: Importing JSON modules is an experimental feature and might change at any time
│ (Use node --trace-warnings ... to show where the warning was created)
│ Starting SW building...
│ done
└─ Done in 605ms
misskey@2023.12.2 build-assets /home/misskey/misskey
node ./scripts/build-assets.mjs
(node:90428) ExperimentalWarning: Importing JSON modules is an experimental feature and might change at any time
(Use node --trace-warnings ... to show where the warning was created)
root@vm-ed6af101-0c:/home/misskey/misskey# pnpm run migrate
misskey@2023.12.2 migrate /home/misskey/misskey
cd packages/backend && pnpm migrate
backend@ migrate /home/misskey/misskey/packages/backend
pnpm typeorm migration:run -d ormconfig.js
query: SELECT * FROM current_schema()
query: SELECT version();
query: SELECT * FROM "information_schema"."tables" WHERE "table_schema" = 'public' AND "table_name" = 'migrations'
query: SELECT * FROM "migrations" "migrations" ORDER BY "id" DESC
220 migrations are already loaded in the database.
267 migrations were found in the source code.
NsfwCache1689102832143 is the last executed migration. It was executed on Wed Jul 12 2023 04:13:52 GMT+0900 (Japan Standard Time).
47 migrations are new migrations must be executed.
query: START TRANSACTION
query: ALTER TYPE "antenna_src_enum" ADD VALUE 'users_blacklist' AFTER 'list'
Migration UserBlacklistAnntena1689325027964 has been executed successfully.
query: DELETE FROM "renote_muting" WHERE "muteeId" NOT IN (SELECT "id" FROM "user")
query: DELETE FROM "renote_muting" WHERE "muterId" NOT IN (SELECT "id" FROM "user")
Migration FixRenoteMuting1690417561185 has been executed successfully.
query: ALTER TABLE "meta" ALTER COLUMN "cacheRemoteFiles" SET DEFAULT false
Migration ChangeCacheRemoteFilesDefault1690417561186 has been executed successfully.
query: DROP INDEX "public"."IDX_2cd3b2a6b4cf0b910b260afe08"
query: DROP INDEX "public"."IDX_renote_muting_createdAt"
query: DROP INDEX "public"."IDX_renote_muting_muteeId"
query: DROP INDEX "public"."IDX_renote_muting_muterId"
query: COMMENT ON COLUMN "user"."isRoot" IS 'Whether the User is the root.'
query: COMMENT ON COLUMN "ad"."startsAt" IS 'The expired date of the Ad.'
query: ALTER TABLE "antenna" ALTER COLUMN "lastUsedAt" DROP DEFAULT
query: ALTER TABLE "meta" ALTER COLUMN "mascotImageUrl" DROP DEFAULT
query: ALTER TABLE "meta" ALTER COLUMN "preservedUsernames" SET DEFAULT '{ "admin", "administrator", "root", "system", "maintainer", "host", "mod", "moderator", "owner", "superuser", "staff", "auth", "i", "me", "everyone", "all", "mention", "mentions", "example", "user", "users", "account", "accounts", "official", "help", "helps", "support", "supports", "info", "information", "informations", "announce", "announces", "announcement", "announcements", "notice", "notification", "notifications", "dev", "developer", "developers", "tech", "misskey" }'
query: COMMENT ON COLUMN "renote_muting"."createdAt" IS 'The created date of the Muting.'
query: COMMENT ON COLUMN "renote_muting"."muteeId" IS 'The mutee user ID.'
query: COMMENT ON COLUMN "renote_muting"."muterId" IS 'The muter user ID.'
query: ALTER TABLE "poll" DROP CONSTRAINT "FK_da851e06d0dfe2ef397d8b1bf1b"
query: ALTER TABLE "poll" DROP CONSTRAINT "UQ_da851e06d0dfe2ef397d8b1bf1b"
query: ALTER TABLE "promo_note" DROP CONSTRAINT "FK_e263909ca4fe5d57f8d4230dd5c"
query: ALTER TABLE "promo_note" DROP CONSTRAINT "UQ_e263909ca4fe5d57f8d4230dd5c"
query: ALTER TABLE "user_keypair" DROP CONSTRAINT "FK_f4853eb41ab722fe05f81cedeb6"
query: ALTER TABLE "user_keypair" DROP CONSTRAINT "UQ_f4853eb41ab722fe05f81cedeb6"
query: ALTER TABLE "user_profile" DROP CONSTRAINT "FK_51cb79b5555effaf7d69ba1cff9"
query: ALTER TABLE "user_profile" DROP CONSTRAINT "UQ_51cb79b5555effaf7d69ba1cff9"
query: ALTER TABLE "user_publickey" DROP CONSTRAINT "FK_10c146e4b39b443ede016f6736d"
query: ALTER TABLE "user_publickey" DROP CONSTRAINT "UQ_10c146e4b39b443ede016f6736d"
query: CREATE INDEX "IDX_3fcc2c589eaefc205e0714b99c" ON "ad" ("startsAt")
query: CREATE UNIQUE INDEX "IDX_c71faf11f0a28a5c0bb506203c" ON "channel_favorite" ("userId", "channelId")
query: CREATE INDEX "IDX_f7b9d338207e40e768e4a5265a" ON "instance" ("firstRetrievedAt")
query: CREATE INDEX "IDX_d1259a2c2b7bb413ff449e8711" ON "renote_muting" ("createdAt")
query: CREATE INDEX "IDX_7eac97594bcac5ffcf2068089b" ON "renote_muting" ("muteeId")
query: CREATE INDEX "IDX_7aa72a5fe76019bfe8e5e0e8b7" ON "renote_muting" ("muterId")
query: CREATE UNIQUE INDEX "IDX_0d801c609cec4e9eb4b6b4490c" ON "renote_muting" ("muterId", "muteeId")
query: ALTER TABLE "renote_muting" ADD CONSTRAINT "FK_7eac97594bcac5ffcf2068089b6" FOREIGN KEY ("muteeId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION
query: ALTER TABLE "renote_muting" ADD CONSTRAINT "FK_7aa72a5fe76019bfe8e5e0e8b7d" FOREIGN KEY ("muterId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION
query: ALTER TABLE "poll" ADD CONSTRAINT "FK_da851e06d0dfe2ef397d8b1bf1b" FOREIGN KEY ("noteId") REFERENCES "note"("id") ON DELETE CASCADE ON UPDATE NO ACTION
query: ALTER TABLE "promo_note" ADD CONSTRAINT "FK_e263909ca4fe5d57f8d4230dd5c" FOREIGN KEY ("noteId") REFERENCES "note"("id") ON DELETE CASCADE ON UPDATE NO ACTION
query: ALTER TABLE "user_keypair" ADD CONSTRAINT "FK_f4853eb41ab722fe05f81cedeb6" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION
query: ALTER TABLE "user_profile" ADD CONSTRAINT "FK_51cb79b5555effaf7d69ba1cff9" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION
query: ALTER TABLE "user_publickey" ADD CONSTRAINT "FK_10c146e4b39b443ede016f6736d" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION
Migration Fix1690417561187 has been executed successfully.
query: ALTER TABLE "user_profile" ADD "twoFactorBackupSecret" character varying array
Migration User2faBackupCodes1690569881926 has been executed successfully.
query: ALTER TABLE "channel"
ADD "isSensitive" boolean NOT NULL DEFAULT false
Migration SensitiveChannel1690782653311 has been executed successfully.
query: ALTER TABLE "public"."flash" ADD "visibility" character varying(512) DEFAULT 'public'
Migration PlayVisibility1690796169261 has been executed successfully.
query: ALTER TABLE "announcement" ADD "display" character varying(256) NOT NULL DEFAULT 'normal'
query: ALTER TABLE "announcement" ADD "needConfirmationToRead" boolean NOT NULL DEFAULT false
query: ALTER TABLE "announcement" ADD "isActive" boolean NOT NULL DEFAULT true
query: ALTER TABLE "announcement" ADD "forExistingUsers" boolean NOT NULL DEFAULT false
query: ALTER TABLE "announcement" ADD "userId" character varying(32)
query: CREATE INDEX "IDX_bc1afcc8ef7e9400cdc3c0a87e" ON "announcement" ("isActive")
query: CREATE INDEX "IDX_da795d3a83187e8832005ba19d" ON "announcement" ("forExistingUsers")
query: CREATE INDEX "IDX_fd25dfe3da37df1715f11ba6ec" ON "announcement" ("userId")
query: ALTER TABLE "announcement" ADD CONSTRAINT "FK_fd25dfe3da37df1715f11ba6ec8" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION
Migration RefineAnnouncement1691649257651 has been executed successfully.
query: ALTER TABLE "announcement" ADD "icon" character varying(256) NOT NULL DEFAULT 'info'
Migration RefineAnnouncement21691657412740 has been executed successfully.
query: ALTER TABLE "user_security_key" ADD "counter" bigint NOT NULL DEFAULT '0'
query: COMMENT ON COLUMN "user_security_key"."counter" IS 'The number of times the UserSecurityKey was validated.'
query: ALTER TABLE "user_security_key" ADD "credentialDeviceType" character varying(32)
query: COMMENT ON COLUMN "user_security_key"."credentialDeviceType" IS 'The type of Backup Eligibility in authenticator data'
query: ALTER TABLE "user_security_key" ADD "credentialBackedUp" boolean
query: COMMENT ON COLUMN "user_security_key"."credentialBackedUp" IS 'Whether or not the credential has been backed up'
query: ALTER TABLE "user_security_key" ADD "transports" character varying(32) array
query: COMMENT ON COLUMN "user_security_key"."transports" IS 'The type of the credential returned by the browser'
query: COMMENT ON COLUMN "user_security_key"."publicKey" IS 'The public key of the UserSecurityKey, hex-encoded.'
query: COMMENT ON COLUMN "user_security_key"."lastUsed" IS 'Timestamp of the last time the UserSecurityKey was used.'
query: ALTER TABLE "user_security_key" ALTER COLUMN "lastUsed" SET DEFAULT now()
query: UPDATE "user_security_key" SET "id" = REPLACE(REPLACE(REPLACE(REPLACE(ENCODE(DECODE("id", 'hex'), 'base64'), E'\n', ''), '+', '-'), '/', '_'), '=', ''), "publicKey" = REPLACE(REPLACE(REPLACE(REPLACE(ENCODE(DECODE("publicKey", 'hex'), 'base64'), E'\n', ''), '+', '-'), '/', '_'), '=', '')
query: ALTER TABLE "attestation_challenge" DROP CONSTRAINT "FK_f1a461a618fa1755692d0e0d592"
query: DROP INDEX "IDX_47efb914aed1f72dd39a306c7b"
query: DROP INDEX "IDX_f1a461a618fa1755692d0e0d59"
query: DROP TABLE "attestation_challenge"
Migration PasskeySupport1691959191872 has been executed successfully.
query: ALTER TABLE "meta" ADD "app192IconUrl" character varying(1024)
query: ALTER TABLE "meta" ADD "app512IconUrl" character varying(1024)
query: ALTER TABLE "meta" ADD "manifestJsonOverride" character varying(8192) NOT NULL DEFAULT '{}'
Migration ServerIconsAndManifest1694850832075 has been executed successfully.
query: ALTER TABLE "note" ADD "clippedCount" smallint NOT NULL DEFAULT '0'
Migration ClippedCount1694915420864 has been executed successfully.
query: ALTER TABLE "user_profile" ADD "verifiedLinks" character varying array NOT NULL DEFAULT '{}'
Migration VerifiedLinks1695260774117 has been executed successfully.
query: ALTER TABLE "following" ADD "notify" character varying(32)
query: CREATE INDEX "IDX_5108098457488634a4768e1d12" ON "following" ("notify")
Migration FollowingNotify1695288787870 has been executed successfully.
query: ALTER TABLE "meta" ADD "shortName" character varying(64)
Migration ShortName1695440131671 has been executed successfully.
query: ALTER TYPE "public"."user_profile_mutingnotificationtypes_enum" RENAME TO "user_profile_mutingnotificationtypes_enum_old"
query: CREATE TYPE "public"."user_profile_mutingnotificationtypes_enum" AS ENUM('note', 'follow', 'mention', 'reply', 'renote', 'quote', 'reaction', 'pollEnded', 'receiveFollowRequest', 'followRequestAccepted', 'achievementEarned', 'app', 'test', 'pollVote', 'groupInvited')
query: ALTER TABLE "user_profile" ALTER COLUMN "mutingNotificationTypes" DROP DEFAULT
query: ALTER TABLE "user_profile" ALTER COLUMN "mutingNotificationTypes" TYPE "public"."user_profile_mutingnotificationtypes_enum"[] USING "mutingNotificationTypes"::"text"::"public"."user_profile_mutingnotificationtypes_enum"[]
query: ALTER TABLE "user_profile" ALTER COLUMN "mutingNotificationTypes" SET DEFAULT '{}'
query: DROP TYPE "public"."user_profile_mutingnotificationtypes_enum_old"
Migration MutingNotificationTypes1695605508898 has been executed successfully.
query: ALTER TABLE "note" ADD "updatedAt" TIMESTAMP WITH TIME ZONE
Migration NoteUpdatedAt1695901659683 has been executed successfully.
query: ALTER TABLE "user_profile" DROP COLUMN "mutingNotificationTypes"
query: ALTER TABLE "user_profile" ADD "notificationRecieveConfig" jsonb NOT NULL DEFAULT '{}'
Migration NotificationRecieveConfig1695944637565 has been executed successfully.
query: ALTER TABLE "meta" ADD "impressumUrl" character varying(1024)
query: ALTER TABLE "meta" ADD "privacyPolicyUrl" character varying(1024)
Migration AddSomeUrls1696003580220 has been executed successfully.
query: ALTER TABLE "following" ADD "withReplies" boolean NOT NULL DEFAULT false
query: ALTER TABLE "user_list_joining" ADD "withReplies" boolean NOT NULL DEFAULT false
query: CREATE INDEX "IDX_d74d8ab5efa7e3bb82825c0fa2" ON "following" ("followeeId", "followerHost")
Migration WithReplies1696222183852 has been executed successfully.
query: ALTER TABLE "user_list_joining" RENAME TO "user_list_membership"
Migration UserListMembership1696323464251 has been executed successfully.
query: DROP INDEX "public"."IDX_d74d8ab5efa7e3bb82825c0fa2"
query: ALTER TABLE "user" ADD "isHibernated" boolean NOT NULL DEFAULT false
query: ALTER TABLE "following" ADD "isFollowerHibernated" boolean NOT NULL DEFAULT false
query: CREATE INDEX "IDX_ce62b50d882d4e9dee10ad0d2f" ON "following" ("followeeId", "followerHost", "isFollowerHibernated")
Migration Hibernation1696331570827 has been executed successfully.
query: ALTER TABLE "user_list_membership" DROP CONSTRAINT "FK_d844bfc6f3f523a05189076efaa"
query: ALTER TABLE "user_list_membership" DROP CONSTRAINT "FK_605472305f26818cc93d1baaa74"
query: DROP INDEX "public"."IDX_d844bfc6f3f523a05189076efa"
query: DROP INDEX "public"."IDX_605472305f26818cc93d1baaa7"
query: DROP INDEX "public"."IDX_90f7da835e4c10aca6853621e1"
query: ALTER TABLE "meta" ALTER COLUMN "preservedUsernames" SET DEFAULT '{ "admin", "administrator", "root", "system", "maintainer", "host", "mod", "moderator", "owner", "superuser", "staff", "auth", "i", "me", "everyone", "all", "mention", "mentions", "example", "user", "users", "account", "accounts", "official", "help", "helps", "support", "supports", "info", "information", "informations", "announce", "announces", "announcement", "announcements", "notice", "notification", "notifications", "dev", "developer", "developers", "tech", "misskey" }'
query: COMMENT ON COLUMN "user_list_membership"."createdAt" IS 'The created date of the UserListMembership.'
query: CREATE INDEX "IDX_021015e6683570ae9f6b0c62be" ON "user_list_membership" ("userId")
query: CREATE INDEX "IDX_cddcaf418dc4d392ecfcca842a" ON "user_list_membership" ("userListId")
query: CREATE UNIQUE INDEX "IDX_e4f3094c43f2d665e6030b0337" ON "user_list_membership" ("userId", "userListId")
query: ALTER TABLE "user_list_membership" ADD CONSTRAINT "FK_021015e6683570ae9f6b0c62bee" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE NO ACTION
query: ALTER TABLE "user_list_membership" ADD CONSTRAINT "FK_cddcaf418dc4d392ecfcca842a7" FOREIGN KEY ("userListId") REFERENCES "user_list"("id") ON DELETE CASCADE ON UPDATE NO ACTION
Migration Clean1696332072038 has been executed successfully.
query: ALTER TABLE "meta" ADD "perLocalUserUserTimelineCacheMax" integer NOT NULL DEFAULT '300'
query: ALTER TABLE "meta" ADD "perRemoteUserUserTimelineCacheMax" integer NOT NULL DEFAULT '100'
query: ALTER TABLE "meta" ADD "perUserHomeTimelineCacheMax" integer NOT NULL DEFAULT '300'
query: ALTER TABLE "meta" ADD "perUserListTimelineCacheMax" integer NOT NULL DEFAULT '300'
Migration MetaCacheSettings1696373953614 has been executed successfully.
query: ALTER TABLE "note" DROP COLUMN "updatedAt"
Migration RevertNoteEdit1696388600237 has been executed successfully.
query: DROP INDEX "public"."IDX_e7c0567f5261063592f022e9b5"
query: DROP INDEX "public"."IDX_25dfc71b0369b003a4cd434d0b"
Migration CleanUp1696405744672 has been executed successfully.
query: DROP INDEX "public"."IDX_01f4581f114e0ebd2bbb876f0b"
query: ALTER TABLE "note" DROP COLUMN "score"
Migration CleanUp1696569742153 has been executed successfully.
query: DROP TABLE IF EXISTS "muted_note"
Migration CleanUp1696581429196 has been executed successfully.
query: ALTER TABLE "meta" ADD "notesPerOneAd" integer NOT NULL DEFAULT '0'
Migration AdsOnStream1696743032098 has been executed successfully.
query: ALTER TABLE "user_list_membership" ADD "userListUserId" character varying(32) NOT NULL DEFAULT ''
query: SELECT "id", "userListId" FROM "user_list_membership"
Migration UserListUserId1696807733453 has been executed successfully.
query: ALTER TABLE "user_list_membership" ALTER COLUMN "userListUserId" DROP DEFAULT
Migration UserListUserId21696808725134 has been executed successfully.
query: ALTER TABLE "meta" ADD "silencedHosts" character varying(1024) array NOT NULL DEFAULT '{}'
Migration InstanceSilence1697247230117 has been executed successfully.
query: DROP INDEX "public"."IDX_02878d441ceae15ce060b73daf"
query: DROP INDEX "public"."IDX_c8dfad3b72196dd1d6b5db168a"
query: DROP INDEX "public"."IDX_e11e649824a45d8ed01d597fd9"
query: DROP INDEX "public"."IDX_db2098070b2b5a523c58181f74"
query: DROP INDEX "public"."IDX_048a757923ed8b157e9895da53"
query: DROP INDEX "public"."IDX_1129c2ef687fc272df040bafaa"
query: DROP INDEX "public"."IDX_118ec703e596086fc4515acb39"
query: DROP INDEX "public"."IDX_b9a354f7941c1e779f3b33aea6"
query: DROP INDEX "public"."IDX_71cb7b435b7c0d4843317e7e16"
query: DROP INDEX "public"."IDX_11e71f2511589dcc8a4d3214f9"
query: DROP INDEX "public"."IDX_735a5544f9249d412255f47f95"
query: DROP INDEX "public"."IDX_582f8fab771a9040a12961f3e7"
query: DROP INDEX "public"."IDX_8f1a239bd077c8864a20c62c2c"
query: DROP INDEX "public"."IDX_f86d57fbca33c7a4e6897490cc"
query: DROP INDEX "public"."IDX_d1259a2c2b7bb413ff449e8711"
query: DROP INDEX "public"."IDX_fbb4297c927a9b85e9cefa2eb1"
query: DROP INDEX "public"."IDX_0fb627e1c2f753262a74f0562d"
query: DROP INDEX "public"."IDX_149d2e44785707548c82999b01"
query: ALTER TABLE "drive_folder" DROP COLUMN "createdAt"
query: ALTER TABLE "drive_file" DROP COLUMN "createdAt"
query: ALTER TABLE "user" DROP COLUMN "createdAt"
query: ALTER TABLE "abuse_user_report" DROP COLUMN "createdAt"
query: ALTER TABLE "app" DROP COLUMN "createdAt"
query: ALTER TABLE "access_token" DROP COLUMN "createdAt"
query: ALTER TABLE "ad" DROP COLUMN "createdAt"
query: ALTER TABLE "announcement" DROP COLUMN "createdAt"
query: ALTER TABLE "announcement_read" DROP COLUMN "createdAt"
query: ALTER TABLE "user_list" DROP COLUMN "createdAt"
query: ALTER TABLE "antenna" DROP COLUMN "createdAt"
query: ALTER TABLE "auth_session" DROP COLUMN "createdAt"
query: ALTER TABLE "blocking" DROP COLUMN "createdAt"
query: ALTER TABLE "channel" DROP COLUMN "createdAt"
query: ALTER TABLE "channel_following" DROP COLUMN "createdAt"
query: ALTER TABLE "channel_favorite" DROP COLUMN "createdAt"
query: ALTER TABLE "clip" DROP COLUMN "createdAt"
query: ALTER TABLE "note" DROP COLUMN "createdAt"
query: ALTER TABLE "clip_favorite" DROP COLUMN "createdAt"
query: ALTER TABLE "following" DROP COLUMN "createdAt"
query: ALTER TABLE "follow_request" DROP COLUMN "createdAt"
query: ALTER TABLE "gallery_post" DROP COLUMN "createdAt"
query: ALTER TABLE "gallery_like" DROP COLUMN "createdAt"
query: ALTER TABLE "moderation_log" DROP COLUMN "createdAt"
query: ALTER TABLE "muting" DROP COLUMN "createdAt"
query: ALTER TABLE "renote_muting" DROP COLUMN "createdAt"
query: ALTER TABLE "note_favorite" DROP COLUMN "createdAt"
query: ALTER TABLE "note_reaction" DROP COLUMN "createdAt"
query: ALTER TABLE "note_thread_muting" DROP COLUMN "createdAt"
query: ALTER TABLE "page" DROP COLUMN "createdAt"
query: ALTER TABLE "page_like" DROP COLUMN "createdAt"
query: ALTER TABLE "password_reset_request" DROP COLUMN "createdAt"
query: ALTER TABLE "poll_vote" DROP COLUMN "createdAt"
query: ALTER TABLE "promo_read" DROP COLUMN "createdAt"
query: ALTER TABLE "registration_ticket" DROP COLUMN "createdAt"
query: ALTER TABLE "registry_item" DROP COLUMN "createdAt"
query: ALTER TABLE "signin" DROP COLUMN "createdAt"
query: ALTER TABLE "sw_subscription" DROP COLUMN "createdAt"
query: ALTER TABLE "user_list_favorite" DROP COLUMN "createdAt"
query: ALTER TABLE "user_list_membership" DROP COLUMN "createdAt"
query: ALTER TABLE "user_note_pining" DROP COLUMN "createdAt"
query: ALTER TABLE "user_pending" DROP COLUMN "createdAt"
query: ALTER TABLE "webhook" DROP COLUMN "createdAt"
query: ALTER TABLE "role" DROP COLUMN "createdAt"
query: ALTER TABLE "role_assignment" DROP COLUMN "createdAt"
query: ALTER TABLE "flash" DROP COLUMN "createdAt"
query: ALTER TABLE "flash_like" DROP COLUMN "createdAt"
Migration DeleteCreatedAt1697420555911 has been executed successfully.
query: ALTER TABLE "antenna" ADD "localOnly" boolean NOT NULL DEFAULT false
Migration AntennaLocalOnly1697436246389 has been executed successfully.
query: ALTER TABLE "follow_request" ADD "withReplies" boolean NOT NULL DEFAULT false
Migration FollowRequestWithReplies1697441463087 has been executed successfully.
query: ALTER TABLE "note" ADD "reactionAndUserPairCache" character varying(1024) array NOT NULL DEFAULT '{}'
Migration NoteReactionAndUserPairCache1697673894459 has been executed successfully.
query: CREATE TABLE "avatar_decoration" ("id" character varying(32) NOT NULL, "updatedAt" TIMESTAMP WITH TIME ZONE, "url" character varying(1024) NOT NULL, "name" character varying(256) NOT NULL, "description" character varying(2048) NOT NULL, "roleIdsThatCanBeUsedThisDecoration" character varying(128) array NOT NULL DEFAULT '{}', CONSTRAINT "PK_b6de9296f6097078e1dc53f7603" PRIMARY KEY ("id"))
query: ALTER TABLE "user" ADD "avatarDecorations" character varying(512) array NOT NULL DEFAULT '{}'
Migration AvatarDecoration1697847397844 has been executed successfully.
query: ALTER TABLE "user" DROP COLUMN "avatarDecorations"
query: ALTER TABLE "user" ADD "avatarDecorations" jsonb NOT NULL DEFAULT '[]'
Migration AvatarDecoration21697941908548 has been executed successfully.
query: ALTER TABLE "meta" ADD "enableFanoutTimeline" boolean NOT NULL DEFAULT true
Migration EnableFtt1698041201306 has been executed successfully.
query: ALTER TABLE "channel" ADD "allowRenoteToExternal" boolean NOT NULL DEFAULT true
Migration AddAllowRenoteToExternal1698840138000 has been executed successfully.
query: ALTER TABLE "announcement" ADD "silence" boolean NOT NULL DEFAULT false
query: CREATE INDEX "IDX_7b8d9225168e962f94ea517e00" ON "announcement" ("silence")
Migration AnnouncementSilence1699141698112 has been executed successfully.
query: ALTER TABLE "meta" ADD "enableFanoutTimelineDbFallback" boolean NOT NULL DEFAULT true
Migration EnableFanoutTimelineDbFallback1700096812223 has been executed successfully.
query: ALTER TABLE "meta" ADD "verifymailAuthKey" character varying(1024)
query: ALTER TABLE "meta" ADD "enableVerifymailApi" boolean NOT NULL DEFAULT false
Migration SupportVerifyMailApi1700303245007 has been executed successfully.
query: ALTER TABLE "user_profile" ADD "hardMutedWords" jsonb NOT NULL DEFAULT '[]'
Migration HardMute1700383825690 has been executed successfully.
query: CREATE INDEX "IDX_de22cd2b445eee31ae51cdbe99" ON "user_profile" (SUBSTR("birthday", 6, 5))
Migration AddBdayIndex1700902349231 has been executed successfully.
query: CREATE TYPE "public"."user_profile_followingvisibility_enum" AS ENUM('public', 'followers', 'private')
query: CREATE CAST ("public"."user_profile_ffvisibility_enum" AS "public"."user_profile_followingvisibility_enum") WITH INOUT AS ASSIGNMENT
query: CREATE TYPE "public"."user_profile_followersVisibility_enum" AS ENUM('public', 'followers', 'private')
query: CREATE CAST ("public"."user_profile_ffvisibility_enum" AS "public"."user_profile_followersVisibility_enum") WITH INOUT AS ASSIGNMENT
query: ALTER TABLE "user_profile" ADD "followingVisibility" "public"."user_profile_followingvisibility_enum" NOT NULL DEFAULT 'public'
query: ALTER TABLE "user_profile" ADD "followersVisibility" "public"."user_profile_followersVisibility_enum" NOT NULL DEFAULT 'public'
query: UPDATE "user_profile" SET "followingVisibility" = "ffVisibility"
query: UPDATE "user_profile" SET "followersVisibility" = "ffVisibility"
query: DROP CAST ("public"."user_profile_ffvisibility_enum" AS "public"."user_profile_followersVisibility_enum")
query: DROP CAST ("public"."user_profile_ffvisibility_enum" AS "public"."user_profile_followingvisibility_enum")
query: ALTER TABLE "user_profile" DROP COLUMN "ffVisibility"
query: DROP TYPE "public"."user_profile_ffvisibility_enum"
Migration ffVisibility1702718871541 has been executed successfully.
query: ALTER TABLE "meta" ADD "bannedEmailDomains" character varying(1024) array NOT NULL DEFAULT '{}'
Migration bannedEmailDomains1703209889304 has been executed successfully.
query: COMMIT
Misskeyプロセスを再起動 sudo systemctl restart misskey
code:bash
sudo vim /etc/systemd/system/misskey.service
エラーが出た
code:bash
Jan 14 10:25:08 vm-ed6af101-0c misskey91925: > misskey@2023.12.2 start Jan 14 10:25:08 vm-ed6af101-0c misskey91925: > pnpm check:connect && cd packages/backend && node ./built/boot/entry.js Jan 14 10:25:08 vm-ed6af101-0c misskey91942: > misskey@2023.12.2 check:connect /home/misskey/misskey Jan 14 10:25:08 vm-ed6af101-0c misskey91942: > cd packages/backend && pnpm check:connect Jan 14 10:25:09 vm-ed6af101-0c misskey91957: ERR_PNPM_UNSUPPORTED_ENGINE Unsupported environment (bad pnpm and/or Node.js version) Jan 14 10:25:09 vm-ed6af101-0c misskey91957: Your Node version is incompatible with "/home/misskey/misskey/packages/backend". Jan 14 10:25:09 vm-ed6af101-0c misskey91957: Expected version: >=20.10.0 Jan 14 10:25:09 vm-ed6af101-0c misskey91957: Got: v20.5.1 Jan 14 10:25:09 vm-ed6af101-0c misskey91957: This is happening because the package's manifest has an engines.node field specified. Jan 14 10:25:09 vm-ed6af101-0c misskey91957: To fix this issue, install the required Node version. Jan 14 10:25:09 vm-ed6af101-0c misskey91942: ELIFECYCLE Command failed with exit code 1. Jan 14 10:25:09 vm-ed6af101-0c systemd1: misskey.service: Main process exited, code=exited, status=1/FAILURE Jan 14 10:25:09 vm-ed6af101-0c systemd1: misskey.service: Failed with result 'exit-code'. Jan 14 10:25:09 vm-ed6af101-0c systemd1: misskey.service: Scheduled restart job, restart counter is at 5. Jan 14 10:25:09 vm-ed6af101-0c systemd1: Stopped Misskey daemon. Jan 14 10:25:09 vm-ed6af101-0c systemd1: misskey.service: Start request repeated too quickly. Jan 14 10:25:09 vm-ed6af101-0c systemd1: misskey.service: Failed with result 'exit-code'. Jan 14 10:25:09 vm-ed6af101-0c systemd1: Failed to start Misskey daemon. v20.5.1 を使って npm start しているっぽい。
nodenvのバージョンをつかって npm start
code:misskey.service
Description=Misskey daemon
Type=simple
User=root
ExecStart=/root/.nodenv/shims/npm start
WorkingDirectory=/home/misskey/misskey
Environment="NODE_ENV=production"
https://scrapbox.io/files/65a33a9e2a20e1002493b33d.png
更新された
クラウドストレージ設定 (Cloudflare R2)
テスト用にBucketを作成
Publicアクセスには R2.dev subdomain を使う
Manage R2 API Tokens からAPI トークン作成
Specify bucket(s) で指定して、オブジェクト読み書きで作成
Misskey
リージョンの設定
Asia-Pacific にしたら画像アップロードできたけど、ぼやけていて見れなかった
→ Region us-east-1 に設定したら画像表示できた
2024年01月17日
hetemlでメールサーバーの設定をした
自分のアカウントのメールアドレス設定をした
2024年01月18日
管理者がパスワード忘れた方の再設定をする場合
本人確認は別途必要
やること
メールアドレスの設定
証明書
ヘッダーなどデザインの調整
Botプロテクション
参考
アップデート