Postgresql Logs Configuration

Overview

Using this document we configure Linux server with the CCE, CCE pulls the logs and redirect it to APE.

For this configuration we use UDP port 514.

Steps of Configuration:-

To configure PostGRE SQL logs, please follow the steps:

• Log in to the PostGRE server as root.

• Run the command: vi  /etc/rsyslog.conf

• Add the lines as below:

• After adding,configure CCE-IP at the end of file:

• Restart rsyslog service using the command:  service rsyslog restart

• To check  the status type the command  service rsyslog status

Verification:-

• VERIFICATION CAN BE DONE IN TWO WAYS :-

   1. By Checking on UI 

2. Checking logs through CCE server

Verification through UI 

• Open UI >>System tab >> Logs and flows collection status:

• The IP will reflect in System tab as source device IP.

Verification Through CCE server

• Run the command " sudo tcpdump -i any port 514 and host <IP address>