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 ='dport_123'

SELECT oob_family FROM ulogd.ulog LIMIT 1;

SELECT last_accessed FROM webfwlog.reports

UPDATE webfwlog.reports SET last_accessed = 1781134602 WHERE code = 'dport_123'

Firewall Log Report

db=mysql
mysql_user=webfwlog
mysql_pass=ulogd
mysql_wfwl_db=webfwlog
pgsql_port=5432
pgsql_user=webfwlog
pgsql_pass=ulogd
pgsql_db=webfwlog
pgsql_wfwl_schema=webfwlog
geoip2_locale=en
geoip2_file=/usr/share/GeoIP/GeoLite2-City.mmdb
geoip2_asn_file=/usr/share/GeoIP/GeoLite2-ASN.mmdb
level=0
description=packets with dport= 123
data_source=syslog
syslog_file=messages
refresh=0
summarize=on
s_latest=1
o_latest=on
s_count=2
o_count=on
l_count=on
c_count=1
c_oob_prefix=2
c_latest=3
c_ip_saddr=4
c_src_host=5
c_ip_daddr=6
w_max_date=1781134602
w_tcp_syn=on
w_tcp_fin=on
w_tcp_rst=on
w_tcp_ack=on
w_tcp_urg=on
w_tcp_psh=on
w_ip_protocol=udp
w_udp_dport=123
data_table=ulog
syslog_dir=/mnt/logs/
show_select_data_source=0
have_family=1

Query time was 1 Seconds.
Report time was 0 Seconds.
Total time was 1 Seconds.

Generated by webfwlog 1.1.3