RDS General Log does not exist in Cloudwatch

0

I want to find out the connections to all my databases in a database instance and I used the instructions below to enable General log on a RDS MariaDB database instance:

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.MySQLDB.PublishtoCloudWatchLogs.html

Unfortunately, I am not able to find the general log under log group in CloudWatch. I can see a General (hyperlink) on the RDS database instance: RDS->Configure->Published Logs->Cloudwatch logs. When I clicked on the hyperlink, CloudWatch was opened but displayed an error: There was an error filtering log events. The specified log group does not exist. I have set general_log to 1 on RDS->Parameter Groups, and enabled the check box for General Log for the DB Instance (Modify->Log export)

And also, will I be able to stop the General logging afterwards? What is the performance impact on the database when General Loggin is turned on? What is the performance impact on the database when Audit Logging is turned on?

profile picture
Lottie
asked 5 months ago380 views
1 Answer
1
Accepted Answer

Hello.

There is a parameter called "log_output" in the parameter group, so try changing its setting value to "FILE".
By changing this value to "FILE" you should be able to output to CloudWatch Logs.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Concepts.MariaDB.html

And also, will I be able to stop the General logging afterwards?

Yes, you can stop it later.
If you want to stop it, follow the steps in the reverse order of the output settings.

profile picture
EXPERT
answered 5 months ago
profile picture
EXPERT
reviewed a month ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions