Ask questions. Get answers. Find technical product solutions from passionate experts in the NXLog community.
NXLOG CE 2.11 - Release date ?
pboniface created
Hi,
I posted a question on september regarding the release of nxlog for debian buster:
https://nxlog.co/question/6073/nxlog-community-edition-package-debian-buster
Raf answered that the release will be available soon, it has been 2 months, have you any idea of the release date ?
Thanks in advance,
Best regards.
Paul
pboniface created
Windows Events missing EventData
Jens_CERT-BA created
Hello,
I'm using NXlog CE 2.10.2150 on a Win2016 server to collect "Forwarded Events" and send to a syslog server as snare formatted.
However, some events only contain their System segment, missing their entire EventData.
Here's my configuration (EventData Missing):
<Input eventlog>
Module im_msvistalog
Query <QueryList>
<Query Id="">
<Select Path="ForwardedEvents">*</Select>
</Query>
</QueryList>
</Input>
<Output out>
Module om_tcp
Host ip_syslogs_server
Port 514
Exec to_syslog_snare();
</Output>
<Route 1>
Path eventlog => out
</Route>
Resulting in (tcpdump):
<14>Nov 11 10:50:37 server2.domain MSWinEventLog 1 Security 2189 Wed Nov 11 10:50:37 2020 4768 Microsoft-Windows-Security-Auditing N/A N/A Success Audit server2.domain Kerberos Authentication Service N/A 998061427
Here's my configuration (EventData Included):
<Input eventlog>
Module im_msvistalog
Query <QueryList>
<Query Id="">
<Select Path="ForwardedEvents">*</Select>
</Query>
</QueryList>
Exec $Message =~ s/(\t|\R)/ /g;
Exec $Message = to_json();
</Input>
<Output out>
Module om_tcp
Host ip_syslogs_server
Port 514
Exec to_syslog_snare();
</Output>
<Route 1>
Path eventlog => out
</Route>
Resulting in (tcpdump):
<14>Nov 11 10:49:36 server1 MSWinEventLog 1 Security 1593 Wed Nov 11 10:49:36 2020 4768 Microsoft-Windows-Security-Auditing N/A N/A Success Audit server1 Kerberos Authentication Service {"EventTime":"2020-11-11 10:49:36","Hostname":"server1","Keywords":-9214364837600034816,"EventType":"AUDIT_SUCCESS","SeverityValue":2,"Severity":"INFO","EventID":4768,"SourceName":"Microsoft-Windows-Security-Auditing","ProviderGuid":"{54849625-5478-4994-A5BA-3E3B0328CXXX}","Version":0,"Task":14339,"OpcodeValue":0,"RecordNumber":953757340,"ProcessID":708,"ThreadID":11484,"Channel":"Security","ERROR_EVT_UNRESOLVED":true,"Category":"Kerberos Authentication Service","Opcode":"Info","TargetUserName":"User1","TargetDomainName":"domain","TargetSid":"S-1-5-21-3493186346-123456789-198542525-123456","ServiceName":"krbtgt","ServiceSid":"S-1-5-21-123456789-2449186506-123456525-502","TicketOptions":"0x40000000","Status":"0x0","TicketEncryptionType":"0x12","PreAuthType":"2","IpAddress":"10.xxx.xxx.xxx","IpPort":"33925","EventReceivedTime":"2020-11-11 10:49:38","SourceModuleName":"eventlog","SourceModuleType":"im_msvistalog"} 953757340
As you can see NXLog fills the EventData with "N/A" in my first example and wiht JSON Encoded Full EventData in my Second Example.
The Problem I have is my Parser on the syslogserver does not expect JSON Encoded Data.
Any Hints?
Thx
Johannes
Jens_CERT-BA created
Cycling multiple files
JR_258437 created
Hello,
I'm logging event logs from a custom c++ app to a server and am trying to setup file cycling for both the application event logs and NXLog log file.
When I add a second Output to my Route, I start to see the event logs showing up in the NXLog log file, which I wasn't expecting.
I'm not sure how to approach this ... should I be setting up a second path for the NXLog cycling?
Here's what my config file is looking like:
Keep 2 weeks of app log files
<Output app_log_cycle>
Module om_file
File 'C:/Users/Jeremy/Documents/myApp/myApp.log'
<Schedule>
When @daily
<Exec>
file_cycle(file_name(), 7);
app_log_cycle->reopen();
</Exec>
</Schedule>
</Output>
Keep 2 weeks of nxlog log files
<Output nxlog_log_cycle>
Module om_file
File 'C:/Program Files (x86)/nxlog/data/nxlog.log'
<Schedule>
When @daily
<Exec>
file_cycle(file_name(), 14);
nxlog_log_cycle->reopen();
</Exec>
</Schedule>
</Output>
<Route 1>
Path watchfile => syslogout, app_log_cycle, nxlog_log_cycle
</Route>
Thanks++ for any tips!
Jeremy
JR_258437 created
ERROR invalid keyword: CAThumbprint
peggers created
Hey everyone!
I'm attempting to use the om_ssl module on an NXLog Community Edition but checking the logs at "C:\Program Files (x86)\nxlog\data\nxlog" showed the following message:
"ERROR invalid keyword: CAThumbprint"
After not finding anything about the error above, I decided to use a combination of CAFile, CertFile, CertKeyFile and KeyPass on the Output configuration which worked but I'd rather use the CAThumbprint directive. What am I doing wrong?
Output tag from the "C:\Program Files (x86)\nxlog\conf\nxlog.conf" looked like this:
<Output out>
Module om_ssl
CAThumbprint xxxxxxxxxxxxxxxxxxxxxxxxxxxx # numbers and letters, without spaces
Host 10.0.0.10 # representative IP
Port 1514
Exec to_syslog_bsd();
</Output>
peggers created
quaestion about multiline
egas84 created
Hi,
I have a log source (Cisco ironport) that sends some multi-line logs via syslog and I want to join only one log when the ICID is the same in the first case and join only one log when the MID is the same in the second case . But I want to remove part of the log. Example below. Is it possible to do this?
join when ICID is equal
<22>Oct 07 22:16:47 TextMailLogs: Info: New SMTP ICID 929637136 interface Public_SMTP (yy.yy.yy.yy) address xx.xx.xx.xx reverse dns host host@isp.com verified yes
<22>Oct 07 22:16:47 TextMailLogs: Info: ICID 929637136 RELAY SG policy match .isp.com SBRS not enabled
<22>Oct 07 22:16:47 TextMailLogs: Info: SMTP Auth: (ICID 929637136) succeeded for user: user@isp.com using AUTH mechanism: PLAIN with profile: SMTP_AUTH_CP
<22>Oct 07 22:16:48 TextMailLogs: Info: ICID 929637136 lost
<22>Oct 07 22:16:48 TextMailLogs: Info: ICID 929637136 close
example result: <22>Oct 07 22:16:47 TextMailLogs: Info: New SMTP ICID 929637136 interface Public_SMTP (yy.yy.yy.yy) address xx.xx.xx.xx reverse dns host host@isp.com verified yes RELAY SG policy match .isp.com SBRS not enabled succeeded for user: user@isp.com using AUTH mechanism: PLAIN with profile: SMTP_AUTH_CP lost close
join when MID is equal
<22>Apr 12 12:00:35 TextMailLogs: Info: MID 354020393 ICID 751911320 From: <from@isp.com>
<22>Apr 12 12:00:35 TextMailLogs: Info: MID 354020393 ICID 751911320 RID 0 To: <to@isp.com>
<22>Apr 12 12:00:36 TextMailLogs: Info: MID 354020393 Subject '=?UTF-8?B?V29tZW7'
<22>Apr 12 12:00:36 TextMailLogs: Info: MID 354020393 ready 92209 bytes from <from@isp.com>
<22>Apr 12 12:00:53 TextMailLogs: Info: Message finished MID 354020393 done
example result: <22>Apr 12 12:00:35 TextMailLogs: Info: MID 354020393 ICID 751911320 From: <from@isp.com> RID 0 To: <to@isp.com> Subject '=?UTF-8?B?V29tZW7' ready 92209 bytes from <from@isp.com> done
Thanks
egas84 created
Frequent disconnects after 2 hours
Deleted user created
Hey guys,
We tested nxlog on a few servers and everything worked fine, no problem at all. Now when we deployed it to more, after 2 hours, the clients just keep disconnecting and reconnecting. I'm really not sure what's happening. We're using a self signed cert, made with opeenssl.
Not sure what would you need to identify my problem.
If needed I'll copy over the debug log or conf file.
Environment is windows.
Any help is appreciated!
Deleted user created
Filter out "INFORMATIONAL" Messages to send to Loggly
DH_064454 created
hi all
Fairly simple one i think
we send way too many "informational" Messages from a few of our Windows servers to Loggly
i want to simply stop sending those "informational" messages
any help would be appreciated
Dale
DH_064454 created
DB select to graylog
lokeliu created
Q1.
Hello I have one problem about mysql to graylog server
i want my db (version:mariadb 5.5 OS centos 7 ) "SELECT eventlog" to my graylog server
but my nxlog log have error
the message is:
ERROR im_dbi failed to execute SQL statement. 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE id > -1 LIMIT 10' at line 1
my nxlog.conf
<Extension _syslog>
Module xm_syslog
</Extension>
<Input in>
Module im_dbi
Driver mysql
Option host 127.0.0.1
Option username root
Option password librenms
Option dbname librenms
SQL SELECT eventlog
</Input>
<Output out>
Module om_udp
Host 192.168.1.20
Port 10514
Exec to_syslog_snare();
</Output>
<Route 1>
Path in => out
</Route>
so how can i do or where are reference about nxlog for mysql(mariadb) ?
Q2. can i install nxlog-ce to CentOS8?
lokeliu created
Statically inject x-forward-for into IIS messages
kmschramm created
How would I go about statically assigning the value of x-forward-for the end of an IIS message that is being read through IM_FIle?
I am doing testing of IIS Log files and I want to take a value from an internal system and add the x-forward-for field to the message.
I have tried adding it to the Input on im_file
Exec $Message = $x_forwarded_for + ' ' + 'x.x.x.x';
I have tried it as
$raw_event = $raw_event + 'x.x.x.x'
Either the value never shows up or it ends up outside of the message. What I need is for it to be inside the message. Essentially where the time-taken is on this example message I would end up with my static x-forwarded-for entry.
#Software: Microsoft Internet Information Services 10.0
#Version: 1.0
#Date: 2017-10-02 17:11:27
#Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) cs(Referer) sc-status sc-substatus sc-win32-status time-taken
2017-10-02 17:11:27 fe80::b5d8:132c:cec9:daef%6 RPC_IN_DATA /rpc/rpcproxy.dll 1d4026cb-6730-43bf-91eb-df80f41c050f@test.com:6001&CorrelationID=<empty>;&RequestId=11d6a78a-7c34-4f43-9400-ad23b114aa62&cafeReqId=11d6a78a-7c34-4f43-9400-ad23b114aa62; 80 TEST\HealthMailbox418406e fe80::b5d8:132c:cec9:daef%6 MSRPC - 500 0 0 7990
2017-10-02 17:12:57 fe80::a425:345a:7143:3b15%2 POST /powershell clientApplication=ActiveMonitor;PSVersion=5.1.14393.1715 80 - fe80::a425:345a:7143:3b15%2 Microsoft+WinRM+Client - 500 0 0 11279
kmschramm created
Recommended method to compress last rotate of file?
DS_534595 created
Using one dedicated NXlog node as master collector that forwards logs to SIEM, I also dump all logs into a file and I rotate that file weekly, keeping 4 weeks worth of logs on the collector; this very clean setup is taken from the documentation and I like it - it works well (see Log rotate in documentation, example 103). Problem is: This consumes much disk, so I'll need to compress the rotated file.
Can I add compression to that output to compress the rotate-copy? I'd prefer not using the example 113 in said log-rotation documentation page.
DS_534595 created
Type of events logged by syslog.conf
R9_779777 created
I'm fairly new to this, but wanted to get some pointers. I've been provided with a syslog.conf file, and am trying to determine what events are being logged. Can someone please let me know what I should be looking for? Alternatively if the syslog.conf file doesn't contain this info, where can I find what events are being logged? On the other hand, is there a standard list of event types that are automatically logged?
R9_779777 created
Adding SOURCE_HOSTIP and SOURCE_HOSTNAME to Logevents
TK_238869 created
Hi,
I am new to NXLog and I am setting up relay log servers in IP ranges to collect and forward log events from hosts (different OS) with dynamically assigend IP addresses.
While doing so, I figured out that the forwarded log events missing important details about the orginating systems and I like to enrich the log events while receiving (accepting ) them with the following details:
hostname as SOURCE_HOSTNAME
ipv4 address as SOURCE_HOSTIP
How is the best practice to do so?
Rgds,
Thorsten
TK_238869 created
send iis log to logserver
BZ_708214 created
hi
who i can get iis web server logs and then send them to ossim log server?
BZ_708214 created
agentless log forwarding error using im_wseventing module
AH_601191 created
Hello Guys,
Im currently trialing nxlog enterprise version and specifically interested in agentless version of it. While working on it i have come across a blockade which seems to not forward logs from windows server machine to linux windows event collector(nxlog enterprise version is running).
Im running nxlog version 5.1.6133 on ubuntu.
Here are the details (SERVER details w.r.t im_wseventing module documentation)
NAME="Ubuntu"
VERSION="18.04.5 LTS (Bionic Beaver)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 18.04.5 LTS"
VERSION_ID="18.04"
Below are client details which forwards logs to server above using agentless method
OS Name: Microsoft Windows Server 2019 Datacenter
OS Version: 10.0.17763 N/A Build 17763
OS Manufacturer: Microsoft Corporation
OS Configuration: Standalone Server
Im getting following error message while trying to forward logs.
Seeing this error in eventviewer under eventlog forwarding plugin.
I have followed the documentation and generated certs and certs seems to be valid and working.
Log Name: Microsoft-Windows-Forwarding/Operational
Source: Microsoft-Windows-Forwarding
Date: 10/28/2020 2:37:05 AM
Event ID: 105
Task Category: None
Level: Error
Keywords:
User: NETWORK SERVICE
Computer: computer_name
Description:
The forwarder is having a problem communicating with subscription manager at address HTTPS://private_ip_address:5986/wsman/. Error code is 2150858819 and Error Message is 鿰柣ƴ.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft-Windows-Forwarding" Guid="{699e309c-e782-4400-98c8-e21d162d7b7b}" />
<EventID>105</EventID>
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x8000000000000000</Keywords>
<TimeCreated SystemTime="2020-10-28T02:37:05.265085100Z" />
<EventRecordID>438</EventRecordID>
<Correlation ActivityID="{2977fa9f-ac7b-0000-d9fb-77297bacd601}" />
<Execution ProcessID="2732" ThreadID="5668" />
<Channel>Microsoft-Windows-Forwarding/Operational</Channel>
<Computer>computer_name</Computer>
<Security UserID="S-1-5-20" />
</System>
<EventData Name="SubscriptionManagerStatus">
<Data Name="SubscriptionManagerAddress">HTTPS://private_ip_address:5986/wsman/</Data>
<Data Name="ErrorCode">2150858819</Data>
<Data Name="ErrorMessage">鿰柣ƴ</Data>
</EventData>
</Event>
I have tried even port 5985 and it also faces similar error.
I have checked whether the server which is the ubuntu is reachable or not, did GET request using postman api tool.POST request seems to not work which might be the cause which might be behind this problem.
Below is my nxlog config
<Input wseventing>
Module im_wseventing
ListenAddr 0.0.0.0
Port 5986
Address https://private_ip_address:5986/wsman
HTTPSCertFile %CERTDIR%/server-cert.pem
HTTPSCertKeyFile %CERTDIR%/server-key.pem
HTTPSCAFile %CERTDIR%/ca-cert.pem
<QueryXML>
<QueryList>
<Computer>*</Computer>
<Query Id="0">
<Select Path="Application">*</Select>
<Select Path="Security">*</Select>
<Select Path="Setup">*</Select>
<Select Path="System">*</Select>
<Select Path="ForwardedEvents">*</Select>
</Query>
</QueryList>
</QueryXML>
</Input>
<Output file>
Module om_file
File "/opt/nxlog/var/log/nxlog/windows_events.log"
</Output>
<Route route_wsevents>
Path wseventing => file
</Route>
Let me know how do i overcome this issue if possible.
Thanks.
AH_601191 created
windows eventlog to graylog and splunk
lokeliu created
Hello
windows ---> nxlog-------->graylog&splunk(syslog)
how can i do?
this conf is right?
p.s.
graylog 192.168.1.20
splunk 192.168.1.21
------------------------------------My conf------------------------------------------------------------------
Panic Soft
#NoFreeOnExit TRUE
define ROOT C:\Program Files (x86)\nxlog
define CERTDIR %ROOT%\cert
define CONFDIR %ROOT%\conf
define LOGDIR %ROOT%\data
define LOGFILE %LOGDIR%\nxlog.log
LogFile %LOGFILE%
Moduledir %ROOT%\modules
CacheDir %ROOT%\data
Pidfile %ROOT%\data\nxlog.pid
SpoolDir %ROOT%\data
<Extension _syslog>
Module xm_gelf
</Extension>
<Extension _syslog>
Module xm_syslog
</Extension>
<Input in>
Module im_msvistalog
</Input>
<Output out>
Module om_udp
Host 192.168.1.20
Port 10554
OutputType GELF
</Output>
<Output out1>
Module om_udp
Host 192.168.1.21
Port 10554
Exec to_syslog_snare();
</Output>
<Route 1>
Path in => out
</Route>
<Route 2>
Path in => out1
</Route>
lokeliu created
Splitting multiline log into separate fields
JP_128812 created
Hi team,
I'm sure this should be easy, but I'm not having much luck finding the answer elsewhere, can any of you help me?
So I have (McAfee Firewall) log entries that look like this:
Time: 10/23/2020 08:09:36 AM
Event: Traffic
IP Address: 172.19.0.113
Description: SNMP SERVICE
Path: C:\Windows\System32\snmp.exe
Message: Allowed Incoming UDP - Source 172.19.0.113 : (52676) Destination 172.23.25.135 : snmp (161)
Matched Rule: Adaptive Rule - snmp.exe
I've got this being parsed as a multiline log entry with the following:
<Extension 5f917c0781064d07c2e8486a-multiline>
Module xm_multiline
HeaderLine /^Time:.*/
EndLine /^Matched Rule:.*/
<Input 5f917c0781064d07c2e8486a>
Module im_file
File 'C:\ProgramData\McAfee\Endpoint Security\Logs\FirewallEventMonitor.log'
PollInterval 1
SavePos True
ReadFromLast True
Recursive True
RenameCheck False
Exec $FileName = file_name(); # Send file name with each message
InputType 5f917c0781064d07c2e8486a-multiline
So far so good - I get a multiline message come through, but I'd now like to parse it.
So my first step is to split out the individual lines - ideally in the above eample I'd split the above message into 7 fields:
'Time' -> '10/23/2020 08:09:36 AM'
'Event' -> 'Traffic'
'IP Address' -> 172.19.0.113
...etc
So I'm guessing there's an Exec section required and some regex work, but I've not managed to get anything to work yet - has anyone else done anything similar here?
thanks in advance,
Jim
JP_128812 created
Extracting data from a table in mySQL
DC_475094 created
Hope someone can provide some pointers.
I have an application that uses mySQL database and it is installed on Windows Server 2019. I just downloaded NXLog CE on the same Windows Server 2019. I am new to this but the goal is to extract a table from mySQL and output it as JSON format so that I can ingest it to another platform.
Appreciate if someone can point me to the right direction to make this work.
Thanks !
DC_475094 created
Geeting Error while running the Nxlog configuration
PS_793095 created
I am using https://nxlog.co/system/files/products/files/348/nxlog-ce-2.10.2150.msi to download the nxlog file.
I am using below configuration:
This is a sample configuration file. See the nxlog reference manual about the
configuration options. It should be installed locally and is also available
online at http://nxlog.org/docs/
Please set the ROOT to the folder your nxlog was installed into,
otherwise it will not start.
#define ROOT C:\Program Files\nxlog
define ROOT C:\Program Files (x86)\nxlog
define ROOT C:\Program Files (x86)\nxlog
Moduledir %ROOT%\modules
CacheDir %ROOT%\data
Pidfile %ROOT%\data\nxlog.pid
SpoolDir %ROOT%\data
LogFile %ROOT%\data\nxlog.log
<Extension _json>
Module xm_json
</Extension>
<Input in>
Module im_msvistalog
Query <QueryList>
<Query Id="0">
<Select Path="Security">* </Select>
<Select Path="Application">* </Select>
<Select Path="Setup">* </Select>
<Select Path="System">* </Select>
</Query>
</QueryList>
<Exec>
if ($EventID NOT IN (%aisiem%)) drop();
</Exec>
</Input>
<Output out>
Module om_udp
Host CCE_IP_ADDRESS
Port 5154
Exec to_json();
</Output>
<Route 1>
Path in => out
</Route>
Getting this error:
2020-10-22 19:11:05 WARNING stopping nxlog service
2020-10-22 19:11:05 WARNING nxlog-ce received a termination request signal, exiting...
2020-10-22 19:11:16 ERROR Failed to load module from C:\Program Files (x86)\nxlog\modules\output\om_udp .dll, Invalid argument; Invalid argument
2020-10-22 19:11:16 ERROR module 'out' is not declared at C:\Program Files (x86)\nxlog\conf\nxlog.conf:52
2020-10-22 19:11:16 ERROR route 1> is not functional without output modules, ignored at C:\Program Files (x86)\nxlog\conf\nxlog.conf:52
2020-10-22 19:11:16 WARNING no routes defined!
2020-10-22 19:11:16 WARNING not starting unused module in
2020-10-22 19:11:16 INFO nxlog-ce-2.10.2150 started
I am using windows 10.
Please suggest what should I change to configure successfully.
PS_793095 created
im_msvistalog filters
LP_577584 created
Hello,
I'm trying to query some EventID with a specific SeverityValue in "im_msvistalog", the config is something like this:
<Input eventlog>
Module im_msvistalog
<QueryXML>
<QueryList>
<Query Id='0'>
<Select Path='System'>*[System[(EventID=6005 or EventID=6008 or EventID=7036)]</Select>
</Query>
</QueryList>
</QueryXML>
Exec if $SeverityValue NOT IN (2, 4) drop();
Exec $Message =~ s/(\t|\R)/ /g;
I'm trying for a test to output on file, but nothing is outputted.
Anyone has some hint?
Thanks
LP_577584 created
Nxlog config file failure.
vishnus9330 created
Hi everyone,
I'm getting this issue of
assignment failed at line 215, character 67 in C:\Program Files (x86)\nxlog\conf\nxlog.conf. statement execution has been aborted function 'strftime' failed at line 215, character 66 in C:\Program Files
(x86)\nxlog\conf\nxlog.conf. expression evaluation has been aborted got 'unknown' for first argument of function 'strftime(datetime, string)'.
if-else failed at line 208, character 277 in C:\Program Files (x86)\nxlog\conf\nxlog.conf. statement execution has been aborted procedure 'parse_csv' failed at line 208, character 129 in C:\Program Files
(x86)\nxlog\conf\nxlog.conf. statement execution has been aborted Not enough fields in CSV input, expected 17, got 0 in input ''
Below is the line the error is refering to:
Exec $EventTime = strftime($EventTime, '%Y-%m-%d %H:%M:%S, %z');
}
Kindly help me out to fix this issue and what is causing the error.
Thanks.
vishnus9330 created