https://github.com/osquery/osquery logo
#general
Title
# general
s

sttor

02/17/2020, 11:17 AM
I am running into an issue with Syslog. Ubuntu - 18.04, osquery - 4.0.2, Syslog-ng- 3.13.2. I got the message "Successfully opened pipe for Syslog ingestion: /var/osquery/syslog_pipe". Even cat works on syslog_pipe, but no result on query select * from syslog_events. Any help here. @zwass
s

seph

02/17/2020, 3:24 PM
Did you configure syslog to write into that pipe?
s

sttor

02/17/2020, 5:07 PM
@seph Yes as per the documentation.
s

seph

02/17/2020, 9:06 PM
Hrm. Are the various osquery settings for syslog events set? (I'm mobile and can't look them up just now)
s

sttor

02/18/2020, 4:13 AM
I was only using --enable_syslog, --disable_events, --syslog_pipe_path flags
s

seph

02/18/2020, 2:46 PM
Should that be
--disable_events=false
?
s

sttor

02/19/2020, 2:12 AM
yes it was --disable_events=false, I have tried all possible combinations, I read all the discussions on slack. Nothing helped me. The Syslog table always remains empty. Tried with both rsyslog and syslog-ng. both with osqueryi and osqueryd, nothing worked.
s

seph

02/19/2020, 2:13 AM
The
osquery_
tables often can provide some insight to how events are working
s

sttor

02/19/2020, 2:16 AM
I queried osquery_events table and refreshes count kept on increasing
s

seph

02/19/2020, 2:20 AM
I’m not really sure how to read that. But I do see the events count staying at zero there
s

sttor

02/19/2020, 2:24 AM
I am receiving syslog in
cat /var/osquery/syslog_pipe
Also
z

zwass

02/19/2020, 2:24 AM
If you are receiving it in
cat
you will not receive it in osquery
s

sttor

02/19/2020, 2:25 AM
@zwass Yes, I just cat it. Never simultaneously run osquery and cat on syslog_pipe
z

zwass

02/19/2020, 2:25 AM
I see
Can you paste a line from when you cat it?
s

sttor

02/19/2020, 2:26 AM
z

zwass

02/19/2020, 2:28 AM
Possibly this issue? https://github.com/osquery/osquery/issues/4810 I haven't worked with syslog for a while.
s

sttor

02/19/2020, 2:29 AM
Probably yes,
syslog hang issue
3 Views