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);
}
AI and Machine Learning - Syslog-ng and postgresql connection logs
Related questions
- Could not connect to remote process. Aborting debug session. Attach Debugger OK button
2855 
19.06.2021 06:47
- Changing my VAT EU no
2441 13.06.2022 09:38
- Connect to MYSQL in OVH cloud, with python that consisted of SSH possibility
1935 11.03.2021 09:46
- I can't find my country in the contact details!
1712 12.12.2021 20:02
- Chatbot and rasa python library
1704 09.05.2021 09:12
- About the AI Training category
1701 08.12.2020 16:21
- Ovhai CLI : Deserialize error
1651 11.06.2021 13:29
- About the Discuss AI category
1555 08.12.2020 16:20
- Error loading open cv python dependencies
1412 25.04.2022 09:00
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: