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
preguntada hace un año875 visualizaciones
1 Respuesta
2
Respuesta aceptada

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
EXPERTO
respondido hace un año
profile picture
EXPERTO
revisado hace 5 meses
profile picture
EXPERTO
revisado hace 7 meses

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas