Hello,
first I apologize for ma bad English (I am French, and old...:-)
I can't get ulogd2 and MYSQL to work, altough it works well with LOGEMU.
After initialization, there are no more messages in the ulogd.log Below
are ulogd.log, ulogd.conf and an extract of iptables rules : Ulogd.log
========= Mon Feb 26 23:41:31 2024 <5> ulogd.c:408 registering plugin
`NFLOG' Mon Feb 26 23:41:31 2024 <5> ulogd.c:408 registering plugin
`IFINDEX' Mon Feb 26 23:41:31 2024 <5> ulogd.c:408 registering plugin
`IP2BIN' Mon Feb 26 23:41:31 2024 <5> ulogd.c:408 registering plugin
`IP2STR' Mon Feb 26 23:41:31 2024 <5> ulogd.c:408 registering plugin
`HWHDR' Mon Feb 26 23:41:31 2024 <5> ulogd.c:408 registering plugin
`MYSQL' Mon Feb 26 23:41:31 2024 <5> ulogd.c:408 registering plugin
`BASE' Mon Feb 26 23:41:31 2024 <5> ulogd.c:408 registering plugin
`PRINTPKT' Mon Feb 26 23:41:31 2024 <5> ulogd.c:408 registering plugin
`LOGEMU' Mon Feb 26 23:41:31 2024 <5> ulogd.c:978 building new
pluginstance stack:
'log1:NFLOG,base1:BASE,ifi1:IFINDEX,ip2str1:IP2STR,print1:PRINTPKT,emu1:LOGEMU'
Mon Feb 26 23:41:31 2024 <1> ulogd.c:988 tok=`log1:NFLOG' Mon Feb 26
23:41:31 2024 <1> ulogd.c:1025 pushing `NFLOG' on stack Mon Feb 26
23:41:31 2024 <1> ulogd.c:988 tok=`base1:BASE' Mon Feb 26 23:41:31 2024
<1> ulogd.c:1025 pushing `BASE' on stack Mon Feb 26 23:41:31 2024 <1>
ulogd.c:988 tok=`ifi1:IFINDEX' Mon Feb 26 23:41:31 2024 <1> ulogd.c:1025
pushing `IFINDEX' on stack Mon Feb 26 23:41:31 2024 <1> ulogd.c:988
tok=`ip2str1:IP2STR' Mon Feb 26 23:41:31 2024 <1> ulogd.c:1025 pushing
`IP2STR' on stack Mon Feb 26 23:41:31 2024 <1> ulogd.c:988
tok=`print1:PRINTPKT' Mon Feb 26 23:41:31 2024 <1> ulogd.c:1025 pushing
`PRINTPKT' on stack Mon Feb 26 23:41:31 2024 <1> ulogd.c:988
tok=`emu1:LOGEMU' Mon Feb 26 23:41:31 2024 <1> ulogd.c:1025 pushing
`LOGEMU' on stack Mon Feb 26 23:41:31 2024 <1> ulogd.c:802 traversing
plugin `LOGEMU' Mon Feb 26 23:41:31 2024 <1> ulogd_output_LOGEMU.c:180
parsing config file section emu1 Mon Feb 26 23:41:31 2024 <1>
ulogd.c:802 traversing plugin `PRINTPKT' Mon Feb 26 23:41:31 2024 <1>
ulogd.c:802 traversing plugin `IP2STR' Mon Feb 26 23:41:31 2024 <1>
ulogd.c:802 traversing plugin `IFINDEX' Mon Feb 26 23:41:31 2024 <1>
ulogd.c:802 traversing plugin `BASE' Mon Feb 26 23:41:31 2024 <1>
ulogd.c:802 traversing plugin `NFLOG' Mon Feb 26 23:41:31 2024 <1>
ulogd_inppkt_NFLOG.c:557 parsing config file section `log1', plugin
`NFLOG' Mon Feb 26 23:41:31 2024 <1> ulogd.c:819 connecting input/output
keys of stack: Mon Feb 26 23:41:31 2024 <1> ulogd.c:826 traversing
plugin `LOGEMU' Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
print1(PRINTPKT) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`print(?)' as source for LOGEMU(print) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:783 log1(NFLOG) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888
assigning `oob.time.sec(?)' as source for LOGEMU(oob.time.sec) Mon Feb
26 23:41:31 2024 <1> ulogd.c:826 traversing plugin `PRINTPKT' Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 log1(NFLOG) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `oob.family(?)' as source for PRINTPKT(oob.family)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 log1(NFLOG) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `oob.prefix(?)' as source for
PRINTPKT(oob.prefix) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
ifi1(IFINDEX) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`oob.in(?)' as source for PRINTPKT(oob.in) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:783 ifi1(IFINDEX) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888
assigning `oob.out(?)' as source for PRINTPKT(oob.out) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 log1(NFLOG) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `oob.uid(?)' as source for PRINTPKT(oob.uid) Mon
Feb 26 23:41:31 2024 <1> ulogd.c:783 log1(NFLOG) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `oob.gid(?)' as source for
PRINTPKT(oob.gid) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 log1(NFLOG)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning `oob.mark(?)' as
source for PRINTPKT(oob.mark) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
log1(NFLOG) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`raw.mac(?)' as source for PRINTPKT(raw.mac) Mon Feb 26 23:41:31 2024
<1> ulogd.c:783 log1(NFLOG) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888
assigning `raw.mac_len(?)' as source for PRINTPKT(raw.mac_len) Mon Feb
26 23:41:31 2024 <1> ulogd.c:783 ip2str1(IP2STR) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `ip.saddr.str(?)' as source for
PRINTPKT(ip.saddr.str) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
ip2str1(IP2STR) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`ip.daddr.str(?)' as source for PRINTPKT(ip.daddr.str) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `ip.totlen(?)' as source for PRINTPKT(ip.totlen)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `ip.tos(?)' as source for
PRINTPKT(ip.tos) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning `ip.ttl(?)' as source
for PRINTPKT(ip.ttl) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`ip.id(?)' as source for PRINTPKT(ip.id) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888
assigning `ip.fragoff(?)' as source for PRINTPKT(ip.fragoff) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `ip.protocol(?)' as source for
PRINTPKT(ip.protocol) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`ip6.payloadlen(?)' as source for PRINTPKT(ip6.payloadlen) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `ip6.priority(?)' as source for
PRINTPKT(ip6.priority) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`ip6.hoplimit(?)' as source for PRINTPKT(ip6.hoplimit) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `ip6.flowlabel(?)' as source for
PRINTPKT(ip6.flowlabel) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`ip6.nexthdr(?)' as source for PRINTPKT(ip6.nexthdr) Mon Feb 26 23:41:31
2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `ip6.fragoff(?)' as source for
PRINTPKT(ip6.fragoff) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`ip6.fragid(?)' as source for PRINTPKT(ip6.fragid) Mon Feb 26 23:41:31
2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `tcp.sport(?)' as source for PRINTPKT(tcp.sport)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `tcp.dport(?)' as source for
PRINTPKT(tcp.dport) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning `tcp.seq(?)' as
source for PRINTPKT(tcp.seq) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`tcp.ackseq(?)' as source for PRINTPKT(tcp.ackseq) Mon Feb 26 23:41:31
2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `tcp.window(?)' as source for PRINTPKT(tcp.window)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `tcp.syn(?)' as source for
PRINTPKT(tcp.syn) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning `tcp.ack(?)' as
source for PRINTPKT(tcp.ack) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`tcp.psh(?)' as source for PRINTPKT(tcp.psh) Mon Feb 26 23:41:31 2024
<1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888
assigning `tcp.rst(?)' as source for PRINTPKT(tcp.rst) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `tcp.fin(?)' as source for PRINTPKT(tcp.fin) Mon
Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `tcp.urg(?)' as source for
PRINTPKT(tcp.urg) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning `tcp.urgp(?)' as
source for PRINTPKT(tcp.urgp) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`udp.sport(?)' as source for PRINTPKT(udp.sport) Mon Feb 26 23:41:31
2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `udp.dport(?)' as source for PRINTPKT(udp.dport)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `udp.len(?)' as source for
PRINTPKT(udp.len) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning `icmp.type(?)' as
source for PRINTPKT(icmp.type) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`icmp.code(?)' as source for PRINTPKT(icmp.code) Mon Feb 26 23:41:31
2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `icmp.echoid(?)' as source for
PRINTPKT(icmp.echoid) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`icmp.echoseq(?)' as source for PRINTPKT(icmp.echoseq) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `icmp.gateway(?)' as source for
PRINTPKT(icmp.gateway) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`icmp.fragmtu(?)' as source for PRINTPKT(icmp.fragmtu) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `icmpv6.type(?)' as source for
PRINTPKT(icmpv6.type) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`icmpv6.code(?)' as source for PRINTPKT(icmpv6.code) Mon Feb 26 23:41:31
2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `icmpv6.echoid(?)' as source for
PRINTPKT(icmpv6.echoid) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`icmpv6.echoseq(?)' as source for PRINTPKT(icmpv6.echoseq) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `ahesp.spi(?)' as source for PRINTPKT(ahesp.spi)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `oob.protocol(?)' as source for
PRINTPKT(oob.protocol) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`arp.hwtype(?)' as source for PRINTPKT(arp.hwtype) Mon Feb 26 23:41:31
2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `arp.protocoltype(?)' as source for
PRINTPKT(arp.protocoltype) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`arp.operation(?)' as source for PRINTPKT(arp.operation) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `arp.shwaddr(?)' as source for
PRINTPKT(arp.shwaddr) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
ip2str1(IP2STR) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`arp.saddr.str(?)' as source for PRINTPKT(arp.saddr.str) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `arp.dhwaddr(?)' as source for
PRINTPKT(arp.dhwaddr) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
ip2str1(IP2STR) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`arp.daddr.str(?)' as source for PRINTPKT(arp.daddr.str) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `sctp.sport(?)' as source for PRINTPKT(sctp.sport)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `sctp.dport(?)' as source for
PRINTPKT(sctp.dport) Mon Feb 26 23:41:31 2024 <1> ulogd.c:826 traversing
plugin `IP2STR' Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 log1(NFLOG) Mon
Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning `oob.family(?)' as source
for IP2STR(oob.family) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`oob.protocol(?)' as source for IP2STR(oob.protocol) Mon Feb 26 23:41:31
2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `ip.saddr(?)' as source for IP2STR(ip.saddr) Mon
Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `ip.daddr(?)' as source for
IP2STR(ip.daddr) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning `arp.saddr(?)' as
source for IP2STR(arp.saddr) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`arp.daddr(?)' as source for IP2STR(arp.daddr) Mon Feb 26 23:41:31 2024
<1> ulogd.c:826 traversing plugin `IFINDEX' Mon Feb 26 23:41:31 2024 <1>
ulogd.c:783 log1(NFLOG) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888
assigning `oob.ifindex_in(?)' as source for IFINDEX(oob.ifindex_in) Mon
Feb 26 23:41:31 2024 <1> ulogd.c:783 log1(NFLOG) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `oob.ifindex_out(?)' as source for
IFINDEX(oob.ifindex_out) Mon Feb 26 23:41:31 2024 <1> ulogd.c:826
traversing plugin `BASE' Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
log1(NFLOG) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`raw.pkt(?)' as source for BASE(raw.pkt) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:783 log1(NFLOG) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888
assigning `raw.pktlen(?)' as source for BASE(raw.pktlen) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 log1(NFLOG) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `oob.family(?)' as source for BASE(oob.family) Mon
Feb 26 23:41:31 2024 <1> ulogd.c:783 log1(NFLOG) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `oob.protocol(?)' as source for
BASE(oob.protocol) Mon Feb 26 23:41:31 2024 <1> ulogd.c:826 traversing
plugin `NFLOG' Mon Feb 26 23:41:31 2024 <1> ulogd_inppkt_NFLOG.c:598
opening nfnetlink socket Mon Feb 26 23:41:31 2024 <5>
ulogd_inppkt_NFLOG.c:569 forcing unbind of existing log handler for
protocol 2 Mon Feb 26 23:41:31 2024 <1> ulogd_inppkt_NFLOG.c:580 binding
to protocol family 2 Mon Feb 26 23:41:31 2024 <5>
ulogd_inppkt_NFLOG.c:569 forcing unbind of existing log handler for
protocol 10 Mon Feb 26 23:41:31 2024 <1> ulogd_inppkt_NFLOG.c:580
binding to protocol family 10 Mon Feb 26 23:41:31 2024 <5>
ulogd_inppkt_NFLOG.c:569 forcing unbind of existing log handler for
protocol 7 Mon Feb 26 23:41:31 2024 <1> ulogd_inppkt_NFLOG.c:580 binding
to protocol family 7 Mon Feb 26 23:41:31 2024 <1>
ulogd_inppkt_NFLOG.c:614 binding to log group 0 Mon Feb 26 23:41:31 2024
<1> ulogd_output_LOGEMU.c:140 starting logemu Mon Feb 26 23:41:31 2024
<1> ulogd_output_LOGEMU.c:145 opening file:
/var/log/ulogd/ulogd_syslogemu.log Mon Feb 26 23:41:31 2024 <5>
ulogd.c:978 building new pluginstance stack:
'log2:NFLOG,base1:BASE,ifi1:IFINDEX,ip2bin1:IP2BIN,mac2str1:HWHDR,mysql1:MYSQL'
Mon Feb 26 23:41:31 2024 <1> ulogd.c:988 tok=`log2:NFLOG' Mon Feb 26
23:41:31 2024 <1> ulogd.c:1025 pushing `NFLOG' on stack Mon Feb 26
23:41:31 2024 <1> ulogd.c:988 tok=`base1:BASE' Mon Feb 26 23:41:31 2024
<1> ulogd.c:1025 pushing `BASE' on stack Mon Feb 26 23:41:31 2024 <1>
ulogd.c:988 tok=`ifi1:IFINDEX' Mon Feb 26 23:41:31 2024 <1> ulogd.c:1025
pushing `IFINDEX' on stack Mon Feb 26 23:41:31 2024 <1> ulogd.c:988
tok=`ip2bin1:IP2BIN' Mon Feb 26 23:41:31 2024 <1> ulogd.c:1025 pushing
`IP2BIN' on stack Mon Feb 26 23:41:31 2024 <1> ulogd.c:988
tok=`mac2str1:HWHDR' Mon Feb 26 23:41:31 2024 <1> ulogd.c:1025 pushing
`HWHDR' on stack Mon Feb 26 23:41:31 2024 <1> ulogd.c:988
tok=`mysql1:MYSQL' Mon Feb 26 23:41:31 2024 <1> ulogd.c:1025 pushing
`MYSQL' on stack Mon Feb 26 23:41:31 2024 <1> ulogd.c:802 traversing
plugin `MYSQL' Mon Feb 26 23:41:31 2024 <5> ../../util/db.c:153
(re)configuring Mon Feb 26 23:41:31 2024 <1> ulogd_output_MYSQL.c:129 57
fields in table Mon Feb 26 23:41:31 2024 <1> ulogd.c:802 traversing
plugin `HWHDR' Mon Feb 26 23:41:31 2024 <1> ulogd.c:802 traversing
plugin `IP2BIN' Mon Feb 26 23:41:31 2024 <1> ulogd.c:802 traversing
plugin `IFINDEX' Mon Feb 26 23:41:31 2024 <1> ulogd.c:802 traversing
plugin `BASE' Mon Feb 26 23:41:31 2024 <1> ulogd.c:802 traversing plugin
`NFLOG' Mon Feb 26 23:41:31 2024 <1> ulogd_inppkt_NFLOG.c:557 parsing
config file section `log2', plugin `NFLOG' Mon Feb 26 23:41:31 2024 <1>
ulogd.c:819 connecting input/output keys of stack: Mon Feb 26 23:41:31
2024 <1> ulogd.c:826 traversing plugin `MYSQL' Mon Feb 26 23:41:31 2024
<1> ulogd.c:783 log2(NFLOG) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888
assigning `oob.time.sec(?)' as source for MYSQL(oob.time.sec) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 log2(NFLOG) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `oob.time.usec(?)' as source for
MYSQL(oob.time.usec) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
log2(NFLOG) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`oob.prefix(?)' as source for MYSQL(oob.prefix) Mon Feb 26 23:41:31 2024
<1> ulogd.c:783 log2(NFLOG) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888
assigning `oob.mark(?)' as source for MYSQL(oob.mark) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 ifi1(IFINDEX) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `oob.in(?)' as source for MYSQL(oob.in) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 ifi1(IFINDEX) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `oob.out(?)' as source for MYSQL(oob.out) Mon Feb
26 23:41:31 2024 <1> ulogd.c:783 log2(NFLOG) Mon Feb 26 23:41:31 2024
<1> ulogd.c:888 assigning `oob.family(?)' as source for
MYSQL(oob.family) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning `ip.saddr(?)' as
source for MYSQL(ip.saddr) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`ip.daddr(?)' as source for MYSQL(ip.daddr) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888
assigning `ip.protocol(?)' as source for MYSQL(ip.protocol) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `ip.tos(?)' as source for MYSQL(ip.tos) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `ip.ttl(?)' as source for MYSQL(ip.ttl) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `ip.totlen(?)' as source for MYSQL(ip.totlen) Mon
Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `ip.ihl(?)' as source for MYSQL(ip.ihl)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `ip.id(?)' as source for MYSQL(ip.id) Mon
Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `ip.fragoff(?)' as source for
MYSQL(ip.fragoff) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning `ip.csum(?)' as
source for MYSQL(ip.csum) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`ip6.payloadlen(?)' as source for MYSQL(ip6.payloadlen) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `ip6.priority(?)' as source for
MYSQL(ip6.priority) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning `ip6.hoplimit(?)' as
source for MYSQL(ip6.hoplimit) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`ip6.flowlabel(?)' as source for MYSQL(ip6.flowlabel) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `ip6.fragoff(?)' as source for MYSQL(ip6.fragoff)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `ip6.fragid(?)' as source for
MYSQL(ip6.fragid) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning `tcp.sport(?)' as
source for MYSQL(tcp.sport) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`tcp.dport(?)' as source for MYSQL(tcp.dport) Mon Feb 26 23:41:31 2024
<1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888
assigning `tcp.seq(?)' as source for MYSQL(tcp.seq) Mon Feb 26 23:41:31
2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `tcp.ackseq(?)' as source for MYSQL(tcp.ackseq)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `tcp.window(?)' as source for
MYSQL(tcp.window) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning `tcp.syn(?)' as
source for MYSQL(tcp.syn) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`tcp.ack(?)' as source for MYSQL(tcp.ack) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888
assigning `tcp.fin(?)' as source for MYSQL(tcp.fin) Mon Feb 26 23:41:31
2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `tcp.rst(?)' as source for MYSQL(tcp.rst) Mon Feb
26 23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024
<1> ulogd.c:888 assigning `tcp.psh(?)' as source for MYSQL(tcp.psh) Mon
Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `tcp.urg(?)' as source for MYSQL(tcp.urg)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `tcp.urgp(?)' as source for
MYSQL(tcp.urgp) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon
Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning `tcp.csum(?)' as source
for MYSQL(tcp.csum) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning `udp.sport(?)' as
source for MYSQL(udp.sport) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`udp.dport(?)' as source for MYSQL(udp.dport) Mon Feb 26 23:41:31 2024
<1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888
assigning `udp.len(?)' as source for MYSQL(udp.len) Mon Feb 26 23:41:31
2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `udp.csum(?)' as source for MYSQL(udp.csum) Mon
Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `icmp.type(?)' as source for
MYSQL(icmp.type) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning `icmp.code(?)' as
source for MYSQL(icmp.code) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`icmp.echoid(?)' as source for MYSQL(icmp.echoid) Mon Feb 26 23:41:31
2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `icmp.echoseq(?)' as source for
MYSQL(icmp.echoseq) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning `icmp.gateway(?)' as
source for MYSQL(icmp.gateway) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`icmp.fragmtu(?)' as source for MYSQL(icmp.fragmtu) Mon Feb 26 23:41:31
2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `icmp.csum(?)' as source for MYSQL(icmp.csum) Mon
Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `icmpv6.type(?)' as source for
MYSQL(icmpv6.type) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning `icmpv6.code(?)' as
source for MYSQL(icmpv6.code) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`icmpv6.echoid(?)' as source for MYSQL(icmpv6.echoid) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `icmpv6.echoseq(?)' as source for
MYSQL(icmpv6.echoseq) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`icmpv6.csum(?)' as source for MYSQL(icmpv6.csum) Mon Feb 26 23:41:31
2024 <1> ulogd.c:783 mac2str1(HWHDR) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `mac.saddr.str(?)' as source for
MYSQL(mac.saddr.str) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
mac2str1(HWHDR) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`mac.daddr.str(?)' as source for MYSQL(mac.daddr.str) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 mac2str1(HWHDR) Mon Feb 26 23:41:31 2024
<1> ulogd.c:888 assigning `mac.str(?)' as source for MYSQL(mac.str) Mon
Feb 26 23:41:31 2024 <1> ulogd.c:783 mac2str1(HWHDR) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `oob.protocol(?)' as source for
MYSQL(oob.protocol) Mon Feb 26 23:41:31 2024 <1> ulogd.c:826 traversing
plugin `HWHDR' Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 log2(NFLOG) Mon
Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning `raw.type(?)' as source
for HWHDR(raw.type) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning `oob.protocol(?)' as
source for HWHDR(oob.protocol) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
log2(NFLOG) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`raw.mac(?)' as source for HWHDR(raw.mac) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:783 log2(NFLOG) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888
assigning `raw.mac_len(?)' as source for HWHDR(raw.mac_len) Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 log2(NFLOG) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `raw.mac.saddr(?)' as source for
HWHDR(raw.mac.saddr) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
log2(NFLOG) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`raw.mac.addrlen(?)' as source for HWHDR(raw.mac.addrlen) Mon Feb 26
23:41:31 2024 <1> ulogd.c:826 traversing plugin `IP2BIN' Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 log2(NFLOG) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `oob.family(?)' as source for IP2BIN(oob.family)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `oob.protocol(?)' as source for
IP2BIN(oob.protocol) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`ip.saddr(?)' as source for IP2BIN(ip.saddr) Mon Feb 26 23:41:31 2024
<1> ulogd.c:783 base1(BASE) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888
assigning `ip.daddr(?)' as source for IP2BIN(ip.daddr) Mon Feb 26
23:41:31 2024 <1> ulogd.c:826 traversing plugin `IFINDEX' Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 log2(NFLOG) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `oob.ifindex_in(?)' as source for
IFINDEX(oob.ifindex_in) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783
log2(NFLOG) Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning
`oob.ifindex_out(?)' as source for IFINDEX(oob.ifindex_out) Mon Feb 26
23:41:31 2024 <1> ulogd.c:826 traversing plugin `BASE' Mon Feb 26
23:41:31 2024 <1> ulogd.c:783 log2(NFLOG) Mon Feb 26 23:41:31 2024 <1>
ulogd.c:888 assigning `raw.pkt(?)' as source for BASE(raw.pkt) Mon Feb
26 23:41:31 2024 <1> ulogd.c:783 log2(NFLOG) Mon Feb 26 23:41:31 2024
<1> ulogd.c:888 assigning `raw.pktlen(?)' as source for BASE(raw.pktlen)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 log2(NFLOG) Mon Feb 26 23:41:31
2024 <1> ulogd.c:888 assigning `oob.family(?)' as source for
BASE(oob.family) Mon Feb 26 23:41:31 2024 <1> ulogd.c:783 log2(NFLOG)
Mon Feb 26 23:41:31 2024 <1> ulogd.c:888 assigning `oob.protocol(?)' as
source for BASE(oob.protocol) Mon Feb 26 23:41:31 2024 <1> ulogd.c:826
traversing plugin `NFLOG' Mon Feb 26 23:41:31 2024 <1>
ulogd_inppkt_NFLOG.c:598 opening nfnetlink socket Mon Feb 26 23:41:31
2024 <1> ulogd_inppkt_NFLOG.c:614 binding to log group 1 Mon Feb 26
23:41:31 2024 <5> ../../util/db.c:208 starting Mon Feb 26 23:41:31 2024
<1> ../../util/db.c:86 allocating 6223 bytes for statement Mon Feb 26
23:41:31 2024 <1> ../../util/db.c:138 stmt='SELECT INSERT_PACKET_FULL('
Mon Feb 26 23:41:31 2024 <3> ulogd.c:1645 initialization finished,
entering main loop ulogd.conf ========== [global] user="ulogd"
group="ulogd" logfile="/var/log/ulogd/ulogd.log" # loglevel: debug(1),
info(3), notice(5), error(7) or fatal(8) (default 5) loglevel=1
plugin="/usr/local/lib/ulogd/ulogd_inppkt_NFLOG.so"
plugin="/usr/local/lib/ulogd/ulogd_filter_IFINDEX.so"
plugin="/usr/local/lib/ulogd/ulogd_filter_IP2BIN.so"
plugin="/usr/local/lib/ulogd/ulogd_filter_IP2STR.so"
plugin="/usr/local/lib/ulogd/ulogd_filter_HWHDR.so"
plugin="/usr/local/lib/ulogd/ulogd_output_MYSQL.so"
plugin="/usr/local/lib/ulogd/ulogd_raw2packet_BASE.so"
plugin="/usr/local/lib/ulogd/ulogd_filter_PRINTPKT.so"
plugin="/usr/local/lib/ulogd/ulogd_output_LOGEMU.so" # this is a stack
for logging packet send by system via LOGEMU
stack=log1:NFLOG,base1:BASE,ifi1:IFINDEX,ip2str1:IP2STR,print1:PRINTPKT,emu1:LOGEMU
# this is a stack for logging packet to MySQL
stack=log2:NFLOG,base1:BASE,ifi1:IFINDEX,ip2bin1:IP2BIN,mac2str1:HWHDR,mysql1:MYSQL
[log1] group=0 [log2] group=1 # Group has to be different from the one
use in log1 #[log3] #group=2 [emu1]
file="/var/log/ulogd/ulogd_syslogemu.log" sync=1 [mysql1] db="ulogd"
host="localhost" user="ulogd" table="ulog2" pass="XXXXXXXX"
procedure="INSERT_PACKET_FULL" iptables rules ============== Chain
LOG_DROP (4 references) pkts bytes target prot opt in out source
destination 6464 294K DROP tcp -- * * 0.0.0.0/0 0.0.0.0/0 tcp
dpts:135:139 18631 917K DROP tcp -- * * 0.0.0.0/0 0.0.0.0/0 tcp dpt:445
2379 169K DROP udp -- * * 0.0.0.0/0 0.0.0.0/0 udp dpts:135:139 10881
1023K NFLOG all -- * * 0.0.0.0/0 0.0.0.0/0 nflog-group 1 nflog-threshold
1 10597 991K NFLOG all -- * * 0.0.0.0/0 0.0.0.0/0 nflog-threshold 1 115K
11M DROP all -- * * 0.0.0.0/0 0.0.0.0/0
