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!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  &#x1f680; Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...