Error In RDS Aurora Creation

Hi Team,

While creating the RDS Aurora instance we are getting error related to authorization. I am using kodekloud account details to login and create the RDS Aurora cluster.

Thanks,
Debasis

Could you please give me some additional details of what settings you’re using. I just created an Aurora:mysql DB in us-east-1. Here’s what it looked like:

{
    "DBInstances": [
        {
            "DBInstanceIdentifier": "database-1-instance-1",
            "DBInstanceClass": "db.t3.medium",
            "Engine": "aurora-mysql",
            "DBInstanceStatus": "available",
            "MasterUsername": "admin",
            "Endpoint": {
                "Address": "database-1-instance-1.c30y4wq4wz3s.us-east-1.rds.amazonaws.com",
                "Port": 3306,
                "HostedZoneId": "Z2R2ITUGPM61AM"
            },
            "AllocatedStorage": 1,
            "InstanceCreateTime": "2024-10-18T05:00:22.104000+00:00",
            "PreferredBackupWindow": "07:57-08:27",
            "BackupRetentionPeriod": 1,
            "DBSecurityGroups": [],
            "VpcSecurityGroups": [
                {
                    "VpcSecurityGroupId": "sg-05d2e8395667ef4f4",
                    "Status": "active"
                }
            ],
            "DBParameterGroups": [
                {
                    "DBParameterGroupName": "default.aurora-mysql8.0",
                    "ParameterApplyStatus": "in-sync"
                }
            ],
            "AvailabilityZone": "us-east-1c",
            "DBSubnetGroup": {
                "DBSubnetGroupName": "default-vpc-0269ef3ae1a4c3b8e",
                "DBSubnetGroupDescription": "Created from the RDS Management Console",
                "VpcId": "vpc-0269ef3ae1a4c3b8e",
                "SubnetGroupStatus": "Complete",
                "Subnets": [
                    {
                        "SubnetIdentifier": "subnet-0ac1d9463e8986794",
                        "SubnetAvailabilityZone": {
                            "Name": "us-east-1b"
                        },
                        "SubnetOutpost": {},
                        "SubnetStatus": "Active"
                    },
                    {
                        "SubnetIdentifier": "subnet-0d9dc7692fb7f9654",
                        "SubnetAvailabilityZone": {
                            "Name": "us-east-1a"
                        },
                        "SubnetOutpost": {},
                        "SubnetStatus": "Active"
                    },
                    {
                        "SubnetIdentifier": "subnet-00d335e1f6c0d79da",
                        "SubnetAvailabilityZone": {
                            "Name": "us-east-1f"
                        },
                        "SubnetOutpost": {},
                        "SubnetStatus": "Active"
                    },
                    {
                        "SubnetIdentifier": "subnet-0c8e69767cbab9f70",
                        "SubnetAvailabilityZone": {
                            "Name": "us-east-1c"
                        },
                        "SubnetOutpost": {},
                        "SubnetStatus": "Active"
                    },
                    {
                        "SubnetIdentifier": "subnet-007a245de3291cdb7",
                        "SubnetAvailabilityZone": {
                            "Name": "us-east-1d"
                        },
                        "SubnetOutpost": {},
                        "SubnetStatus": "Active"
                    },
                    {
                        "SubnetIdentifier": "subnet-018ae5f17077aed29",
                        "SubnetAvailabilityZone": {
                            "Name": "us-east-1e"
                        },
                        "SubnetOutpost": {},
                        "SubnetStatus": "Active"
                    }
                ]
            },
            "PreferredMaintenanceWindow": "fri:07:14-fri:07:44",
            "PendingModifiedValues": {},
            "MultiAZ": false,
            "EngineVersion": "8.0.mysql_aurora.3.05.2",
            "AutoMinorVersionUpgrade": false,
            "ReadReplicaDBInstanceIdentifiers": [],
            "LicenseModel": "general-public-license",
            "OptionGroupMemberships": [
                {
                    "OptionGroupName": "default:aurora-mysql-8-0",
                    "Status": "in-sync"
                }
            ],
            "PubliclyAccessible": false,
            "StorageType": "aurora",
            "DbInstancePort": 0,
            "DBClusterIdentifier": "database-1",
            "StorageEncrypted": false,
            "DbiResourceId": "db-UXLQTUOFYS4SAWQ5TWJNGZRQUY",
            "CACertificateIdentifier": "rds-ca-rsa2048-g1",
            "DomainMemberships": [],
            "CopyTagsToSnapshot": false,
            "MonitoringInterval": 0,
            "PromotionTier": 1,
            "DBInstanceArn": "arn:aws:rds:us-east-1:730335214540:db:database-1-instance-1",
            "IAMDatabaseAuthenticationEnabled": false,
            "PerformanceInsightsEnabled": false,
            "DeletionProtection": false,
            "AssociatedRoles": [],
            "TagList": [],
            "CustomerOwnedIpEnabled": false,
            "BackupTarget": "region",
            "NetworkType": "IPV4",
            "StorageThroughput": 0,
            "CertificateDetails": {
                "CAIdentifier": "rds-ca-rsa2048-g1",
                "ValidTill": "2025-10-18T04:57:29+00:00"
            },
            "DedicatedLogVolume": false
        }
    ]
}

Key thing here is I used dev/test type settings with minimal services. But it did work for me. What settings did you use when you get the error?

@rob_kodekloud I am trying to create Aurora Postgres and I am also using dev/test type settings. Let me try one more time will capture the settings what I choose.

Thanks,
Debasis

@rob_kodekloud I am able to create Aroura Mysql deployment. Can you help me to create Aurora postgres deployment bcz still I am getting authorization error.

Thanks,
Debasis

I just successfully created an aurora-postgres DB. Things I changed from default:

  • No monitoring at all
  • No backup
  • us-east-1

Nothing fancy.

@rob_kodekloud I am able to create Aroura Mysql deployment. Let me try the same.

Thanks,
Debasis