Getting Data In

Reading database logs from linux server

islam
Explorer

Hi,

We want to read the database logs from a linux server, and the logs are stored in specific path “</path>/log/” as example . The logs are archived at the end of every day in same directory of real time log file. The real time info writes into “vertica.log” file, so we don’t want to read logs from the file “vertica.log”

How can we reed this archived  files in splunk.

 
 

vertica.log.png

Labels (2)
0 Karma
1 Solution

venkateshparank
Path Finder

Create monitoring stanza like below:

[monitor:///<path>/log/vertica.log-*]

disabled = 0

crcSalt = <SOURCE>

index = <IndexName>

 

If you still see the vertica.log is reading, trying adding below line in above Stanza

blacklist = vertica.log

 

That would be like below:

[monitor:///<path>/log/vertica.log-*]

disabled = 0

crcSalt = <SOURCE>

index = <IndexName>

blacklist = vertica.log

 

View solution in original post

0 Karma

venkateshparank
Path Finder

Create monitoring stanza like below:

[monitor:///<path>/log/vertica.log-*]

disabled = 0

crcSalt = <SOURCE>

index = <IndexName>

 

If you still see the vertica.log is reading, trying adding below line in above Stanza

blacklist = vertica.log

 

That would be like below:

[monitor:///<path>/log/vertica.log-*]

disabled = 0

crcSalt = <SOURCE>

index = <IndexName>

blacklist = vertica.log

 

0 Karma

islam
Explorer

thanks a lot for your kindly reply.

we tried this solution  and we start receiving logs now.

 

0 Karma

venkateshparank
Path Finder

@islam If the solution helps you, then an upvote would be appreciated.

0 Karma
Get Updates on the Splunk Community!

The OpenTelemetry Certified Associate (OTCA) Exam

What’s this OTCA exam? The Linux Foundation offers the OpenTelemetry Certified Associate (OTCA) credential to ...

From Manual to Agentic: Level Up Your SOC at Cisco Live

Welcome to the Era of the Agentic SOC   Are you tired of being a manual alert responder? The security ...

Splunk Classroom Chronicles: Training Tales and Testimonials (Episode 4)

Welcome back to Splunk Classroom Chronicles, our ongoing series where we shine a light on what really happens ...