尝试使用typeorm连接到aws-rds-aurora-db-mysql Handshake inactivity timeout
错误。
code: 'PROTOCOL_SEQUENCE_TIMEOUT',
fatal: true,
timeout: 10000
尝试使用默认的10秒和我自己的15秒超时。 ormconfig.json
文件:
{
"type": "mysql",
"host": "host connection string",
"port": 3306,
"username": "xxxx",
"password": "xxxx",
"database": "xxxx",
"synchronize": true,
"logging": true,
"connectTimeout": 15000,
"entities": [
"src/entity/**/*.ts"
],
"migrations": [
"src/migration/**/*.ts"
],
"subscribers": [
"src/subscriber/**/*.ts"
],
"cli": {
"entitiesDir": "src/entity",
"migrationsDir": "src/migration",
"subscribersDir": "src/subscriber"
}
}
能够使用linux mysql客户端cli连接示例,甚至尝试在同一vpc中使用ecs连接数据库,但出现了相同的错误。
1条答案
按热度按时间chhqkbe11#
这个问题最常见的过程是vpc和安全组规则的错误设置。试着为它写进/出规则。
有用的链接:*https://docs.aws.amazon.com/en_us/vpc/latest/userguide/vpc_securitygroups.html#defaultsecuritygroup *https://docs.aws.amazon.com/en_us/awscloudformation/latest/userguide/aws-properties-ec2-security-group-ingress.html