SELECT version() AS version
SELECT routine_schema from INFORMATION_SCHEMA.routines where routine_name = 'wfwl_inet_pton'
SELECT count(*) FROM webfwlog.services LIMIT 1
SHOW COLUMNS FROM webfwlog.hostnames LIKE 'ip_addr';
SELECT definition FROM webfwlog.reports WHERE code ='everything'
SELECT oob_family FROM ulogd.ulog LIMIT 1;
SELECT ip_saddr_bin FROM ulogd.ulog LIMIT 1;
SHOW COLUMNS FROM ulogd.ulog LIKE 'ip_saddr_bin';
SHOW COLUMNS FROM ulogd.ulog LIKE 'icmp_gateway';
SELECT local_time FROM ulogd.ulog LIMIT 1
SELECT oob_family FROM ulogd.ulog LIMIT 1
SELECT _id FROM ulogd.ulog LIMIT 1
SELECT mac_str FROM ulogd.ulog LIMIT 1
SELECT last_accessed FROM webfwlog.reports
UPDATE webfwlog.reports SET last_accessed = 1781134377 WHERE code = 'everything'
SHOW COLUMNS FROM ulogd.ulog;
CREATE TEMPORARY TABLE webfwlog.allrows AS
SELECT
CAST('ulogd.ulog' AS char(32)) AS sname,
t.ip_saddr_bin AS `ip_saddr`,
t.ip_daddr_bin AS `ip_daddr`,
t.*
FROM ulogd.ulog AS t
WHERE (t.oob_time_sec IS NOT NULL AND t.oob_time_sec>=1780356777)
AND (t.oob_time_sec IS NOT NULL AND t.oob_time_sec<=1781134377)
AND (t.local_hostname IS NULL OR NOT (t.local_hostname REGEXP 'dewey'))
AND (t.oob_prefix IS NULL OR NOT (t.oob_prefix REGEXP 'DROP'))
AND NOT (t.ip_protocol=6)
AND (NOT (t.ip_protocol=6) OR NOT (t.tcp_sport=3128))
AND (NOT (t.ip_protocol=6) OR NOT (t.tcp_dport=3128))
AND (NOT (t.ip_protocol=17) OR NOT (t.udp_sport=53))
AND (NOT (t.ip_protocol=17) OR NOT (t.udp_dport=53))
AND (NOT (t.ip_protocol=1) OR NOT (t.icmp_type=8))
AND (NOT (t.ip_protocol=1) OR NOT (t.icmp_code=0))
AND (NOT (t.ip_protocol=58) OR NOT (t.icmpv6_type=128))
AND (NOT (t.ip_protocol=58) OR NOT (t.icmpv6_code=129))
AND NOT ((t.oob_family=2 AND t.ip_saddr_bin = wfwl_inet_pton(10, '192.168.0.2')))
AND NOT ((t.oob_family=2 AND t.ip_daddr_bin = wfwl_inet_pton(10, '66.47.77.160')))
AND (t.oob_in IS NULL OR NOT (t.oob_in REGEXP 'ppp0'))
AND (t.oob_out IS NULL OR NOT (t.oob_out REGEXP 'ppp0'))
AND (NOT (t.oob_family=2) OR NOT (t.ip_tos=1))
AND (NOT (t.oob_family=10) OR (t.ip6_priority=1))
AND (NOT (t.oob_family=2) OR NOT (t.ip_tos=1))
AND (NOT (t.oob_family=10) OR (t.ip6_fragid=3))
AND (NOT (t.oob_family=2) OR NOT (t.ip_ttl=10))
AND (NOT (t.oob_family=10) OR (t.ip6_hoplimit=10))
AND (t.ip_ihl IS NULL OR NOT (t.ip_ihl=2))
AND (t.ip_totlen IS NULL OR NOT (t.ip_totlen=11))
AND (NOT (t.oob_family=2) OR NOT (t.ip_id=3))
AND (NOT (t.oob_family=10) OR (t.ip6_fragid=3))
AND (t.ip_csum IS NULL OR NOT (t.ip_csum=12))
AND (t.ip6_flowlabel IS NULL OR NOT (t.ip6_flowlabel=4))
AND (t.ip6_payloadlen IS NULL OR NOT (t.ip6_payloadlen=25))
AND (NOT (t.oob_family=10) OR (t.ip6_fragoff=13))
AND (NOT (t.ip_protocol=6) OR NOT (t.tcp_seq=5))
AND (NOT (t.ip_protocol=6) OR NOT (t.tcp_ackseq=14))
AND (NOT (t.ip_protocol=6) OR NOT (t.tcp_window=6))
AND (NOT (t.ip_protocol=6) OR NOT (t.tcp_urgp=15))
AND (NOT (t.ip_protocol=6) OR NOT (t.tcp_csum=14.5))
AND (NOT (t.ip_protocol=1 AND t.icmp_echoid IS NOT NULL) OR NOT (t.icmp_echoid=7))
AND (NOT (t.ip_protocol=1 AND t.icmp_echoseq IS NOT NULL) OR NOT (t.icmp_echoseq=16))
AND (NOT (t.ip_protocol=1 AND t.icmp_gateway IS NOT NULL) OR NOT (t.icmp_gateway & 4294967295 = 3232235520 & 4294967295))
AND (NOT (t.ip_protocol=1 AND t.icmp_fragmtu IS NOT NULL) OR NOT (t.icmp_fragmtu=17))
AND (NOT (t.ip_protocol=58 AND t.icmpv6_echoid IS NOT NULL) OR NOT (t.icmpv6_echoid=8))
AND (NOT (t.ip_protocol=58 AND t.icmpv6_echoseq IS NOT NULL) OR NOT (t.icmpv6_echoseq=8))
AND (NOT (t.ip_protocol=17) OR NOT (t.udp_len=8))
AND (NOT (t.ip_protocol=17) OR NOT (t.udp_csum=8.5))
AND (t.raw_type IS NULL OR NOT (t.raw_type=8))
AND (t.oob_protocol IS NULL OR NOT (t.oob_protocol=2))
AND (t.mac_saddr_str IS NULL OR NOT (t.mac_saddr_str REGEXP 'as'))
AND (t.mac_daddr_str IS NULL OR NOT (t.mac_daddr_str REGEXP 'asf'))
AND (t.mac_str IS NULL OR NOT (t.mac_str REGEXP '18'))
AND (t.oob_mark IS NULL OR NOT (t.oob_mark=4))
AND (NOT (t.ip_protocol BETWEEN 50 AND 51) OR NOT (t.ahesp_spi=9))
AND (t.oob_time_usec IS NULL OR NOT (t.oob_time_usec=19))
AND (t.pwsniff_user IS NULL OR NOT (t.pwsniff_user REGEXP 'sadf'))
AND (t.pwsniff_pass IS NULL OR NOT (t.pwsniff_pass REGEXP 'sdfg'))
AND ((tcp_dport=25 or tcp_dport=80 or tcp_dport=135 or tcp_dport=111 or tcp_dport=515 or tcp_dport=21))
AND (t.ip_protocol<>6 OR (t.tcp_syn AND t.tcp_fin AND t.tcp_ack AND t.tcp_rst AND t.tcp_psh AND t.tcp_urg))
AND (t.ip_fragoff IS NULL OR NOT (t.ip_fragoff=24589))
CREATE TEMPORARY TABLE webfwlog.allrows AS
SELECT
CAST('ulogd.ulog' AS char(32)) AS sname,
t.ip_saddr_bin AS `ip_saddr`,
t.ip_daddr_bin AS `ip_daddr`,
t.*
FROM ulogd.ulog AS t
WHERE (t.oob_time_sec IS NOT NULL AND t.oob_time_sec>=1780356777)
AND (t.oob_time_sec IS NOT NULL AND t.oob_time_sec<=1781134377)
AND (t.local_hostname IS NULL OR NOT (t.local_hostname REGEXP 'dewey'))
AND (t.oob_prefix IS NULL OR NOT (t.oob_prefix REGEXP 'DROP'))
AND NOT (t.ip_protocol=6)
AND (NOT (t.ip_protocol=6) OR NOT (t.tcp_sport=3128))
AND (NOT (t.ip_protocol=6) OR NOT (t.tcp_dport=3128))
AND (NOT (t.ip_protocol=17) OR NOT (t.udp_sport=53))
AND (NOT (t.ip_protocol=17) OR NOT (t.udp_dport=53))
AND (NOT (t.ip_protocol=1) OR NOT (t.icmp_type=8))
AND (NOT (t.ip_protocol=1) OR NOT (t.icmp_code=0))
AND (NOT (t.ip_protocol=58) OR NOT (t.icmpv6_type=128))
AND (NOT (t.ip_protocol=58) OR NOT (t.icmpv6_code=129))
AND NOT ((t.oob_family=2 AND t.ip_saddr_bin = wfwl_inet_pton(10, '192.168.0.2')))
AND NOT ((t.oob_family=2 AND t.ip_daddr_bin = wfwl_inet_pton(10, '66.47.77.160')))
AND (t.oob_in IS NULL OR NOT (t.oob_in REGEXP 'ppp0'))
AND (t.oob_out IS NULL OR NOT (t.oob_out REGEXP 'ppp0'))
AND (NOT (t.oob_family=2) OR NOT (t.ip_tos=1))
AND (NOT (t.oob_family=10) OR (t.ip6_priority=1))
AND (NOT (t.oob_family=2) OR NOT (t.ip_tos=1))
AND (NOT (t.oob_family=10) OR (t.ip6_fragid=3))
AND (NOT (t.oob_family=2) OR NOT (t.ip_ttl=10))
AND (NOT (t.oob_family=10) OR (t.ip6_hoplimit=10))
AND (t.ip_ihl IS NULL OR NOT (t.ip_ihl=2))
AND (t.ip_totlen IS NULL OR NOT (t.ip_totlen=11))
AND (NOT (t.oob_family=2) OR NOT (t.ip_id=3))
AND (NOT (t.oob_family=10) OR (t.ip6_fragid=3))
AND (t.ip_csum IS NULL OR NOT (t.ip_csum=12))
AND (t.ip6_flowlabel IS NULL OR NOT (t.ip6_flowlabel=4))
AND (t.ip6_payloadlen IS NULL OR NOT (t.ip6_payloadlen=25))
AND (NOT (t.oob_family=10) OR (t.ip6_fragoff=13))
AND (NOT (t.ip_protocol=6) OR NOT (t.tcp_seq=5))
AND (NOT (t.ip_protocol=6) OR NOT (t.tcp_ackseq=14))
AND (NOT (t.ip_protocol=6) OR NOT (t.tcp_window=6))
AND (NOT (t.ip_protocol=6) OR NOT (t.tcp_urgp=15))
AND (NOT (t.ip_protocol=6) OR NOT (t.tcp_csum=14.5))
AND (NOT (t.ip_protocol=1 AND t.icmp_echoid IS NOT NULL) OR NOT (t.icmp_echoid=7))
AND (NOT (t.ip_protocol=1 AND t.icmp_echoseq IS NOT NULL) OR NOT (t.icmp_echoseq=16))
AND (NOT (t.ip_protocol=1 AND t.icmp_gateway IS NOT NULL) OR NOT (t.icmp_gateway & 4294967295 = 3232235520 & 4294967295))
AND (NOT (t.ip_protocol=1 AND t.icmp_fragmtu IS NOT NULL) OR NOT (t.icmp_fragmtu=17))
AND (NOT (t.ip_protocol=58 AND t.icmpv6_echoid IS NOT NULL) OR NOT (t.icmpv6_echoid=8))
AND (NOT (t.ip_protocol=58 AND t.icmpv6_echoseq IS NOT NULL) OR NOT (t.icmpv6_echoseq=8))
AND (NOT (t.ip_protocol=17) OR NOT (t.udp_len=8))
AND (NOT (t.ip_protocol=17) OR NOT (t.udp_csum=8.5))
AND (t.raw_type IS NULL OR NOT (t.raw_type=8))
AND (t.oob_protocol IS NULL OR NOT (t.oob_protocol=2))
AND (t.mac_saddr_str IS NULL OR NOT (t.mac_saddr_str REGEXP 'as'))
AND (t.mac_daddr_str IS NULL OR NOT (t.mac_daddr_str REGEXP 'asf'))
AND (t.mac_str IS NULL OR NOT (t.mac_str REGEXP '18'))
AND (t.oob_mark IS NULL OR NOT (t.oob_mark=4))
AND (NOT (t.ip_protocol BETWEEN 50 AND 51) OR NOT (t.ahesp_spi=9))
AND (t.oob_time_usec IS NULL OR NOT (t.oob_time_usec=19))
AND (t.pwsniff_user IS NULL OR NOT (t.pwsniff_user REGEXP 'sadf'))
AND (t.pwsniff_pass IS NULL OR NOT (t.pwsniff_pass REGEXP 'sdfg'))
AND ((tcp_dport=25 or tcp_dport=80 or tcp_dport=135 or tcp_dport=111 or tcp_dport=515 or tcp_dport=21))
AND (t.ip_protocol<>6 OR (t.tcp_syn AND t.tcp_fin AND t.tcp_ack AND t.tcp_rst AND t.tcp_psh AND t.tcp_urg))
AND (t.ip_fragoff IS NULL OR NOT (t.ip_fragoff=24589))
Query failed!
Unknown column 't.local_hostname' in 'WHERE'