需要幫助從 Google App Engine 連接到我的 Google SQL Postgres 資料庫。我已關注https://docs.strapi.io/developer-docs/latest/setup-deployment-guides/deployment/hosting-guides/google-app-engine.html但一直遇到以下錯誤：
2022-09-27 16:11:32 default[20220928t020816] [2022-09-27 16:11:32.307] debug: ?? Server wasn't able to start properly.
2022-09-27 16:11:32 default[20220928t020816] [2022-09-27 16:11:32.309] error: connect ECONNREFUSED /cloudsql/project-id:us-central1:database-id/.s.PGSQL.5432
資料庫.ts
export default ({ env }) => ({
connection: {
client: 'postgres',
connection: {
host: env('DATABASE_HOST', '127.0.0.1'),
port: env.int('DATABASE_PORT', 5432),
database: env('DATABASE_NAME', 'database-id'),
user: env('DATABASE_USERNAME', 'strapi'),
password: env('DATABASE_PASSWORD', 'strapi'),
ssl: env.bool('DATABASE_SSL', false),
},
},
});
應用程式.yaml
runtime: nodejs16
instance_class: F1
env_variables:
ADMIN_JWT_SECRET: 'XXXXXXXXXXXXX'
API_TOKEN_SALT: 'XXXXXXXXXXXXX'
APP_KEYS: 'XXXXXXXXXXXXX'
DATABASE_HOST: '/cloudsql/project-id:us-central1:database-id'
DATABASE_PORT: '5432'
DATABASE_NAME: 'database-id'
DATABASE_USERNAME: 'postgres'
DATABASE_PASSWORD: 'XXXXXXXXXXXXX'
DATABASE_SSL: 'false'
HOST: '0.0.0.0'
JWT_SECRET: 'XXXXXXXXXXXXX'
NODE_ENV: 'production'
PORT: '1337'
beta_settings:
cloud_sql_instances: 'project-id:us-central1:database-id'
uj5u.com熱心網友回復：
使用 Unix 套接字連接到 Cloud SQL 時最常見的原因error: connect ECONNREFUSED之一是您的 GCP 專案沒有Cloud SQL Admin API啟用。
啟用 Cloud SQL Admin API，這應該有助于解決連接問題。
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/512608.html
標籤：Google Cloud Collective PostgreSQL谷歌应用引擎斯特拉皮
上一篇：谷歌應用引擎對超時實體的精確計算