I would like to send postgres connection logs to the OVH Logs Data Platform service with syslog-ng. How should syslog-ng be configured to send these logs?
Currently I have the following configuration in the ldp.conf file:
source s_postgres {
file("/var/log/postgresql/postgresql-${YEAR}-${MONTH}-${DAY}_000000.log" flags(no-parse));
}
template t_postgres {
template("<${LEVEL_NUM}>1 ${ISODATE} ${HOST} ${PROGRAM} ${PID} - [sdid X-OVH-TOKEN=\"\" pid=\"${PID}\" facility=\"${FACILITY}\" priority=\"${PRIORITY}\"]$
template_escape(no);
}
d_postgres {
tcp(".logs.ovh.com"
port(12201)
tls(ca_dir("/etc/ssl/certs"))
ts_format("rfc3339") template(t_postgres)
keep-alive(yes)
so_keepalive(yes)
log-fifo-size(30000)
);
}
log {
source(s_postgres);
destination(d_postgres);
}
Syslog-ng and postgresql connection logs
Related questions
- Could not connect to remote process. Aborting debug session. Attach Debugger OK button
2118 
19.06.2021 06:47
- Connect to MYSQL in OVH cloud, with python that consisted of SSH possibility
1368 11.03.2021 09:46
- I can't find my country in the contact details!
1210 12.12.2021 20:02
- Changing my VAT EU no
1117 13.06.2022 09:38
- Chatbot and rasa python library
1098 09.05.2021 09:12
- Ovhai CLI : Deserialize error
1085 11.06.2021 13:29
- Error loading open cv python dependencies
883 25.04.2022 09:00
- About the AI Training category
749 08.12.2020 16:21
- POST on an Object Storage
739 27.10.2022 14:30
In order to log RFC 5424 syslogs to Logs Data Platform, you must use the appropriate port. The Port for RFC 5424 is 6514. You can find an example of the syslog-ng configuration at the following Official Documentation:
https://docs.ovh.com/fr/logs-data-platform/how-to-log-your-linux/
For your configuration, your are mostly interested in this part of the documentation (for syslog-ng 3.8+, note also the timestamp format).
destination ovhPaaSLogs {
network(".logs.ovh.com"
port(6514),
template(ovhTemplate),
ts_format("iso"),
transport("tls"),
tls(peer-verify("required-trusted") ca_dir("/etc/ssl/certs/")),
keep-alive(yes),
so_keepalive(yes),
);
};
The documentation provides also an example https://www.tommypetarabic.com/ Website of a working template, and other guides will give you alternatives.
Don't hesitate do reach directly the OVH team if you need further assistance at: