Database tables in graylog

(eshwar) #1

Hi,

I have output of sql statement in tabular format which stoted in .txt file. I am trying to send these details to graylog from the server where collector is installed but failing. I am able to send apache logs to graylog from same server and i am able to create dashborads as well.

Could you suggest me for any possibilities to send Database data in table format to Graylog.

Thanks

0 Likes

(Tmacgbay) #2

Google search gave me this which lead me to this … Make sure you are referencing the correct version of Elastic… I haven’t done it but these are where I would start my research…

0 Likes

(eshwar) #3

Thanks you your reply.
But i am placing my sql output on apache server where collector was installed. Not sending data directly from my DB server. (PF the snap)

0 Likes

(Tmacgbay) #4

That was me eliminating a step that I know nothing about. :smiley: The answer is in your reply too… it suggests using NXLOG/filebeat, which you could follow on with an extractor…

0 Likes

(eshwar) #5

i am using filebeat to send apache logs. And using same filebeat to send data base table as well to graylog. Still i am not able to send the data.
Any more suggestions please

0 Likes

(Tmacgbay) #6

Post your filebeat client config with all relevant detail (blocking sensitive stuff of course) please use the formatting so it is easier to read…

0 Likes

(eshwar) #7

Posting my input file, filebeat configuration and DB output.

My Output in tabular format like:

0 Likes

(Tmacgbay) #8

Nothing stands out to me - 0did you try debugging it in the foreground as shown here at the bottom of the docs page? (I don’t know what version you are running, you should always put that in your request as well…if it is a different version change it in the lower left side and you will still find the debugging information at the bottom of the doc. Let us know what you see, don’t make us guess!

0 Likes

(eshwar) #9

Please find below debug snap. i couldnt find anything suspicious here. kindly review

0 Likes