I am trying to create an options group with several attached options. I have timezone and s3_integration attached to the options group. The last one that is giving me issues is OEM_AGENT. I keep getting the same error but not sure how to get around it. I create a list of options and pass this onto the rds module (terraform-aws-modules/rds/aws). This is then sent to the “options” variable where rds should apply it but for some reason spits out the error. Not sure how to get this to work. Any help is appreciated.
╷
│ Error: modifying RDS DB Option Group (ylvokyle-20240116120334783200000001): InvalidParameterValue: At least one security group must be specified for the OEM_AGENT option.
│ status code: 400, request id: a6e40fba-9586-4cfe-8eab-533e1622dfad
│
│ with module.db.module.db.module.db_option_group.aws_db_option_group.this[0],
│ on .terraform/modules/db.db/modules/db_option_group/main.tf line 8, in resource “aws_db_option_group” “this”:
│ 8: resource “aws_db_option_group” “this” {
│
╵