[2020-08-17 20:14:58.350 6047/F5457] gravityDB_open(): Successfully opened gravity.db
[2020-08-17 20:14:58.350 6047/F5457] TCP worker terminating (client disconnected)
[2020-08-17 20:14:58.350 6047/F5457] Finalizing gravity statements for 10.0.10.182
[2020-08-17 20:14:58.350 6047/F5457] Finalizing gravity statements for 10.0.1.1
[2020-08-17 20:14:58.350 6047/F5457] Finalizing gravity statements for 10.0.40.3
[2020-08-17 20:14:58.350 6047/F5457] Finalizing gravity statements for 10.0.10.190
[2020-08-17 20:14:58.350 6047/F5457] Finalizing gravity statements for 10.0.10.215
[2020-08-17 20:14:58.350 6047/F5457] Finalizing gravity statements for 10.0.1.7
[2020-08-17 20:14:58.351 6047/F5457] Finalizing gravity statements for 10.0.1.2
[2020-08-17 20:14:58.351 6047/F5457] Finalizing gravity statements for 127.0.0.1
[2020-08-17 20:14:58.351 6047/F5457] Finalizing gravity statements for 10.0.10.64
[2020-08-17 20:14:58.351 6047/F5457] Finalizing gravity statements for 10.0.10.84
[2020-08-17 20:15:00.003 5457/T5461] dbquery: "BEGIN TRANSACTION IMMEDIATE"
[2020-08-17 20:15:00.003 5457/T5461] ---> OK
[2020-08-17 20:15:00.004 5457/T5461] dbquery: "SELECT MAX(ID) FROM queries"
[2020-08-17 20:15:00.005 5457/T5461] ---> Result 1137954 (long long int)
[2020-08-17 20:15:00.009 5457/T5461] dbquery: "END TRANSACTION"
[2020-08-17 20:15:00.022 5457/T5461] ---> OK
[2020-08-17 20:15:00.022 5457/T5461] dbquery: "INSERT OR REPLACE INTO ftl (id, value) VALUES ( 1, 1597688097 );"
[2020-08-17 20:15:00.028 5457/T5461] ---> OK
[2020-08-17 20:15:00.028 5457/T5461] dbquery: "UPDATE counters SET value = value + 66 WHERE id = 0;"
[2020-08-17 20:15:00.037 5457/T5461] ---> OK
[2020-08-17 20:15:00.037 5457/T5461] dbquery: "UPDATE counters SET value = value + 30 WHERE id = 1;"
[2020-08-17 20:15:00.043 5457/T5461] ---> OK
[2020-08-17 20:15:00.044 5457/T5461] Notice: Queries stored in long-term database: 66 (took 16.8 ms, last SQLite ID 1138020)
[2020-08-17 20:15:00.045 5457/T5461] dbquery: "BEGIN TRANSACTION IMMEDIATE"
[2020-08-17 20:15:00.046 5457/T5461] ---> OK
[2020-08-17 20:15:00.056 5457/T5461] dbquery: "SELECT id FROM network WHERE hwaddr = 'f0:9f:c2:1e:8f:e9';"
[2020-08-17 20:15:00.057 5457/T5461] ---> No data
[2020-08-17 20:15:00.058 5457/T5461] dbquery: "SELECT id FROM network WHERE hwaddr = 'ip-10.0.1.1' AND firstSeen > (cast(strftime('%s', 'now') as int)-3600);"
[2020-08-17 20:15:00.058 5457/T5461] ---> No data
[2020-08-17 20:15:00.094 5457/T5461] DEBUG: MAC Vendor lookup for f0:9f:c2:1e:8f:e9 returned "Ubiquiti Networks Inc."
[2020-08-17 20:15:00.094 5457/T5461] dbquery: "INSERT INTO network (hwaddr,interface,firstSeen,lastQuery,numQueries,macVendor) VALUES (?1,'N/A',?2,?3,?4,?5);" with arguments ?1-?5 = ("f0:9f:c2:1e:8f:e9",1597688100,1597609573,0,"Ubiquiti Networks Inc.")
[2020-08-17 20:15:00.095 5457/T5461] dbquery: "INSERT OR REPLACE INTO network_addresses (network_id,ip,lastSeen,name,nameUpdated) VALUES (?1,?2,(cast(strftime('%s', 'now') as int)),(SELECT name FROM network_addresses WHERE ip = ?2),(SELECT nameUpdated FROM network_addresses WHERE ip = ?2));" with arguments ?1 = 1 and ?2 = "10.0.1.1"
[2020-08-17 20:15:00.095 5457/T5461] dbquery: "UPDATE network_addresses SET name = ?1, nameUpdated = (cast(strftime('%s', 'now') as int)) WHERE ip = ?2" with arguments 1 = "usg" and 2 = "10.0.1.1"
[2020-08-17 20:15:00.095 5457/T5461] dbquery: "UPDATE network SET interface = ?1 WHERE id = ?2" with arguments ?1 = "eth0" and ?2 = 1
[2020-08-17 20:15:00.096 5457/T5461] dbquery: "INSERT OR REPLACE INTO network_addresses (network_id,ip,lastSeen,name,nameUpdated) VALUES (?1,?2,(cast(strftime('%s', 'now') as int)),(SELECT name FROM network_addresses WHERE ip = ?2),(SELECT nameUpdated FROM network_addresses WHERE ip = ?2));" with arguments ?1 = 1 and ?2 = "10.0.1.1"
[2020-08-17 20:15:00.096 5457/T5461] dbquery: "SELECT id FROM network WHERE hwaddr = 'e0:63:da:2c:19:17';"
[2020-08-17 20:15:00.096 5457/T5461] ---> No data
[2020-08-17 20:15:00.096 5457/T5461] dbquery: "SELECT id FROM network WHERE hwaddr = 'ip-10.0.1.2' AND firstSeen > (cast(strftime('%s', 'now') as int)-3600);"
[2020-08-17 20:15:00.096 5457/T5461] ---> No data
[2020-08-17 20:15:00.127 5457/T5461] DEBUG: MAC Vendor lookup for e0:63:da:2c:19:17 returned "Ubiquiti Networks Inc."
[2020-08-17 20:15:00.127 5457/T5461] dbquery: "INSERT INTO network (hwaddr,interface,firstSeen,lastQuery,numQueries,macVendor) VALUES (?1,'N/A',?2,?3,?4,?5);" with arguments ?1-?5 = ("e0:63:da:2c:19:17",1597688100,1597685972,0,"Ubiquiti Networks Inc.")
[2020-08-17 20:15:00.128 5457/T5461] dbquery: "INSERT OR REPLACE INTO network_addresses (network_id,ip,lastSeen,name,nameUpdated) VALUES (?1,?2,(cast(strftime('%s', 'now') as int)),(SELECT name FROM network_addresses WHERE ip = ?2),(SELECT nameUpdated FROM network_addresses WHERE ip = ?2));" with arguments ?1 = 2 and ?2 = "10.0.1.2"
[2020-08-17 20:15:00.128 5457/T5461] dbquery: "UPDATE network_addresses SET name = ?1, nameUpdated = (cast(strftime('%s', 'now') as int)) WHERE ip = ?2" with arguments 1 = "cloudkey" and 2 = "10.0.1.2"
[2020-08-17 20:15:00.128 5457/T5461] dbquery: "UPDATE network SET interface = ?1 WHERE id = ?2" with arguments ?1 = "eth0" and ?2 = 2
[2020-08-17 20:15:00.128 5457/T5461] dbquery: "INSERT OR REPLACE INTO network_addresses (network_id,ip,lastSeen,name,nameUpdated) VALUES (?1,?2,(cast(strftime('%s', 'now') as int)),(SELECT name FROM network_addresses WHERE ip = ?2),(SELECT nameUpdated FROM network_addresses WHERE ip = ?2));" with arguments ?1 = 2 and ?2 = "10.0.1.2"
[2020-08-17 20:15:00.128 5457/T5461] dbquery: "SELECT id FROM network WHERE hwaddr = '00:a2:89:5b:1d:f0';"
[2020-08-17 20:15:00.129 5457/T5461] ---> No data
[2020-08-17 20:15:00.129 5457/T5461] dbquery: "SELECT id FROM network WHERE hwaddr = 'ip-10.0.1.7' AND firstSeen > (cast(strftime('%s', 'now') as int)-3600);"
[2020-08-17 20:15:00.129 5457/T5461] ---> No data
[2020-08-17 20:15:00.143 5457/T5461] DEBUG: MAC Vendor lookup for 00:a2:89:5b:1d:f0 returned "Cisco Systems, Inc"
[2020-08-17 20:15:00.143 5457/T5461] dbquery: "INSERT INTO network (hwaddr,interface,firstSeen,lastQuery,numQueries,macVendor) VALUES (?1,'N/A',?2,?3,?4,?5);" with arguments ?1-?5 = ("00:a2:89:5b:1d:f0",1597688100,1597687812,0,"Cisco Systems, Inc")
[2020-08-17 20:15:00.144 5457/T5461] dbquery: "INSERT OR REPLACE INTO network_addresses (network_id,ip,lastSeen,name,nameUpdated) VALUES (?1,?2,(cast(strftime('%s', 'now') as int)),(SELECT name FROM network_addresses WHERE ip = ?2),(SELECT nameUpdated FROM network_addresses WHERE ip = ?2));" with arguments ?1 = 3 and ?2 = "10.0.1.7"
[2020-08-17 20:15:00.144 5457/T5461] dbquery: "UPDATE network_addresses SET name = ?1, nameUpdated = (cast(strftime('%s', 'now') as int)) WHERE ip = ?2" with arguments 1 = "spa112" and 2 = "10.0.1.7"
[2020-08-17 20:15:00.144 5457/T5461] dbquery: "UPDATE network SET interface = ?1 WHERE id = ?2" with arguments ?1 = "eth0" and ?2 = 3
[2020-08-17 20:15:00.144 5457/T5461] dbquery: "INSERT OR REPLACE INTO network_addresses (network_id,ip,lastSeen,name,nameUpdated) VALUES (?1,?2,(cast(strftime('%s', 'now') as int)),(SELECT name FROM network_addresses WHERE ip = ?2),(SELECT nameUpdated FROM network_addresses WHERE ip = ?2));" with arguments ?1 = 3 and ?2 = "10.0.1.7"
[2020-08-17 20:15:00.144 5457/T5461] dbquery: "SELECT id FROM network WHERE hwaddr = 'f0:9f:c2:ce:09:31';"
[2020-08-17 20:15:00.144 5457/T5461] ---> No data
[2020-08-17 20:15:00.144 5457/T5461] dbquery: "SELECT id FROM network WHERE hwaddr = 'ip-10.0.1.3' AND firstSeen > (cast(strftime('%s', 'now') as int)-3600);"
[2020-08-17 20:15:00.145 5457/T5461] ---> No data
[2020-08-17 20:15:00.177 5457/T5461] DEBUG: MAC Vendor lookup for f0:9f:c2:ce:09:31 returned "Ubiquiti Networks Inc."
[2020-08-17 20:15:00.177 5457/T5461] dbquery: "INSERT INTO network (hwaddr,interface,firstSeen,lastQuery,numQueries,macVendor) VALUES (?1,'N/A',?2,?3,?4,?5);" with arguments ?1-?5 = ("f0:9f:c2:ce:09:31",1597688100,0,0,"Ubiquiti Networks Inc.")
[2020-08-17 20:15:00.177 5457/T5461] dbquery: "INSERT OR REPLACE INTO network_addresses (network_id,ip,lastSeen,name,nameUpdated) VALUES (?1,?2,(cast(strftime('%s', 'now') as int)),(SELECT name FROM network_addresses WHERE ip = ?2),(SELECT nameUpdated FROM network_addresses WHERE ip = ?2));" with arguments ?1 = 4 and ?2 = "10.0.1.3"
[2020-08-17 20:15:05.209 5457/T5461] dbquery: "UPDATE network SET interface = ?1 WHERE id = ?2" with arguments ?1 = "eth0" and ?2 = 4
[2020-08-17 20:15:05.209 5457/T5461] dbquery: "INSERT OR REPLACE INTO network_addresses (network_id,ip,lastSeen,name,nameUpdated) VALUES (?1,?2,(cast(strftime('%s', 'now') as int)),(SELECT name FROM network_addresses WHERE ip = ?2),(SELECT nameUpdated FROM network_addresses WHERE ip = ?2));" with arguments ?1 = 4 and ?2 = "10.0.1.3"
[2020-08-17 20:15:05.210 5457/T5461] dbquery: "SELECT id FROM network WHERE hwaddr = 'f0:9f:c2:dc:2f:75';"
[2020-08-17 20:15:05.210 5457/T5461] ---> No data
[2020-08-17 20:15:05.210 5457/T5461] dbquery: "SELECT id FROM network WHERE hwaddr = 'ip-10.0.1.4' AND firstSeen > (cast(strftime('%s', 'now') as int)-3600);"
[2020-08-17 20:15:05.210 5457/T5461] ---> No data
[2020-08-17 20:15:05.257 5457/T5461] DEBUG: MAC Vendor lookup for f0:9f:c2:dc:2f:75 returned "Ubiquiti Networks Inc."
[2020-08-17 20:15:05.258 5457/T5461] dbquery: "INSERT INTO network (hwaddr,interface,firstSeen,lastQuery,numQueries,macVendor) VALUES (?1,'N/A',?2,?3,?4,?5);" with arguments ?1-?5 = ("f0:9f:c2:dc:2f:75",1597688100,0,0,"Ubiquiti Networks Inc.")
[2020-08-17 20:15:05.258 5457/T5461] dbquery: "INSERT OR REPLACE INTO network_addresses (network_id,ip,lastSeen,name,nameUpdated) VALUES (?1,?2,(cast(strftime('%s', 'now') as int)),(SELECT name FROM network_addresses WHERE ip = ?2),(SELECT nameUpdated FROM network_addresses WHERE ip = ?2));" with arguments ?1 = 5 and ?2 = "10.0.1.4"
[2020-08-17 20:15:15.272 5457/T5461] dbquery: "UPDATE network SET interface = ?1 WHERE id = ?2" with arguments ?1 = "eth0" and ?2 = 5
[2020-08-17 20:15:15.273 5457/T5461] dbquery: "INSERT OR REPLACE INTO network_addresses (network_id,ip,lastSeen,name,nameUpdated) VALUES (?1,?2,(cast(strftime('%s', 'now') as int)),(SELECT name FROM network_addresses WHERE ip = ?2),(SELECT nameUpdated FROM network_addresses WHERE ip = ?2));" with arguments ?1 = 5 and ?2 = "10.0.1.4"
[2020-08-17 20:15:15.273 5457/T5461] dbquery: "SELECT network_id FROM network_addresses WHERE ip = '10.0.10.182' AND lastSeen > (cast(strftime('%s', 'now') as int)-86400) ORDER BY lastSeen DESC LIMIT 1;"
[2020-08-17 20:15:15.273 5457/T5461] ---> No data
[2020-08-17 20:15:15.273 5457/T5461] dbquery: "SELECT id FROM network WHERE hwaddr = 'ip-10.0.10.182';"
[2020-08-17 20:15:15.274 5457/T5461] ---> No data
[2020-08-17 20:15:15.274 5457/T5461] dbquery: "INSERT INTO network (hwaddr,interface,firstSeen,lastQuery,numQueries,macVendor) VALUES (?1,'N/A',?2,?3,?4,?5);" with arguments ?1-?5 = ("ip-10.0.10.182",1597688100,1597688082,8,"(null)")
[2020-08-17 20:15:15.274 5457/T5461] dbquery: "INSERT OR REPLACE INTO network_addresses (network_id,ip,lastSeen,name,nameUpdated) VALUES (?1,?2,(cast(strftime('%s', 'now') as int)),(SELECT name FROM network_addresses WHERE ip = ?2),(SELECT nameUpdated FROM network_addresses WHERE ip = ?2));" with arguments ?1 = 6 and ?2 = "10.0.10.182"
[2020-08-17 20:15:15.275 5457/T5461] dbquery: "UPDATE network_addresses SET name = ?1, nameUpdated = (cast(strftime('%s', 'now') as int)) WHERE ip = ?2" with arguments 1 = "thinkpad-wifi" and 2 = "10.0.10.182"
[2020-08-17 20:15:15.275 5457/T5461] dbquery: "UPDATE network SET interface = ?1 WHERE id = ?2" with arguments ?1 = "eth0" and ?2 = 6
[2020-08-17 20:15:15.275 5457/T5461] dbquery: "SELECT network_id FROM network_addresses WHERE ip = '127.0.0.1' AND lastSeen > (cast(strftime('%s', 'now') as int)-86400) ORDER BY lastSeen DESC LIMIT 1;"
[2020-08-17 20:15:15.275 5457/T5461] ---> No data
[2020-08-17 20:15:15.275 5457/T5461] dbquery: "SELECT id FROM network WHERE hwaddr = 'ip-127.0.0.1';"
[2020-08-17 20:15:15.275 5457/T5461] ---> No data
[2020-08-17 20:15:15.276 5457/T5461] dbquery: "INSERT INTO network (hwaddr,interface,firstSeen,lastQuery,numQueries,macVendor) VALUES (?1,'N/A',?2,?3,?4,?5);" with arguments ?1-?5 = ("ip-127.0.0.1",1597688100,1597688095,1,"(null)")
[2020-08-17 20:15:15.276 5457/T5461] dbquery: "INSERT OR REPLACE INTO network_addresses (network_id,ip,lastSeen,name,nameUpdated) VALUES (?1,?2,(cast(strftime('%s', 'now') as int)),(SELECT name FROM network_addresses WHERE ip = ?2),(SELECT nameUpdated FROM network_addresses WHERE ip = ?2));" with arguments ?1 = 7 and ?2 = "127.0.0.1"
[2020-08-17 20:15:15.276 5457/T5461] dbquery: "UPDATE network_addresses SET name = ?1, nameUpdated = (cast(strftime('%s', 'now') as int)) WHERE ip = ?2" with arguments 1 = "localhost" and 2 = "127.0.0.1"
[2020-08-17 20:15:15.277 5457/T5461] dbquery: "UPDATE network SET interface = ?1 WHERE id = ?2" with arguments ?1 = "lo" and ?2 = 7
[2020-08-17 20:15:15.277 5457/T5461] dbquery: "SELECT id FROM network WHERE hwaddr = '14:20:5E:DB:00:16' COLLATE NOCASE;"
[2020-08-17 20:15:15.277 5457/T5461] ---> No data
[2020-08-17 20:15:15.303 5457/T5461] DEBUG: MAC Vendor lookup for 14:20:5E:DB:00:16 returned "Apple, Inc."
[2020-08-17 20:15:15.303 5457/T5461] dbquery: "INSERT INTO network (hwaddr,interface,firstSeen,lastQuery,numQueries,macVendor) VALUES (?1,'N/A',?2,?3,?4,?5);" with arguments ?1-?5 = ("14:20:5E:DB:00:16",1597688100,1597688097,57,"Apple, Inc.")
[2020-08-17 20:15:15.304 5457/T5461] dbquery: "INSERT OR REPLACE INTO network_addresses (network_id,ip,lastSeen,name,nameUpdated) VALUES (?1,?2,(cast(strftime('%s', 'now') as int)),(SELECT name FROM network_addresses WHERE ip = ?2),(SELECT nameUpdated FROM network_addresses WHERE ip = ?2));" with arguments ?1 = 8 and ?2 = "10.0.10.64"
[2020-08-17 20:15:15.304 5457/T5461] dbquery: "UPDATE network_addresses SET name = ?1, nameUpdated = (cast(strftime('%s', 'now') as int)) WHERE ip = ?2" with arguments 1 = "ipad" and 2 = "10.0.10.64"
[2020-08-17 20:15:15.304 5457/T5461] dbquery: "UPDATE network SET interface = ?1 WHERE id = ?2" with arguments ?1 = "eth0" and ?2 = 8
[2020-08-17 20:15:15.304 5457/T5461] dbquery: "END TRANSACTION"
[2020-08-17 20:15:15.314 5457/T5461] ---> OK
[2020-08-17 20:15:15.315 5457M] Finalizing gravity statements for 127.0.0.1
[2020-08-17 20:15:15.315 5457M] Initializing gravity statements for 127.0.0.1
[2020-08-17 20:15:15.316 5457M] SQL: Comparing 127.0.0.1 vs. 10.0.1.0/16 (subnet 255.255.0.0) - NO MATCH
[2020-08-17 20:15:15.316 5457M] SQL: Comparing 127.0.0.1 vs. 10.0.10.1/24 (subnet 255.255.255.0) - NO MATCH
[2020-08-17 20:15:15.317 5457M] Found database hardware address 127.0.0.1 -> ip-127.0.0.1
[2020-08-17 20:15:15.317 5457M] Skipping mock-device hardware address lookup
[2020-08-17 20:15:15.318 5457M] Found database host name 127.0.0.1 -> localhost
[2020-08-17 20:15:15.325 5457M] Found database interface 127.0.0.1 -> lo
[2020-08-17 20:15:15.325 5457M] gravityDB_open(): Preparing vw_whitelist statement for client 127.0.0.1
[2020-08-17 20:15:15.325 5457M] get_client_querystr: SELECT EXISTS(SELECT domain from vw_whitelist WHERE domain = ? AND group_id IN (0));
[2020-08-17 20:15:15.326 5457M] gravityDB_open(): Preparing vw_gravity statement for client 127.0.0.1
[2020-08-17 20:15:15.326 5457M] get_client_querystr: SELECT EXISTS(SELECT domain from vw_gravity WHERE domain = ? AND group_id IN (0));
[2020-08-17 20:15:15.326 5457M] gravityDB_open(): Preparing vw_blacklist statement for client 127.0.0.1
[2020-08-17 20:15:15.326 5457M] get_client_querystr: SELECT EXISTS(SELECT domain from vw_blacklist WHERE domain = ? AND group_id IN (0));
[2020-08-17 20:15:15.327 5457M] domain_in_list("3.1.0.10.in-addr.arpa", 0xaaab0f22b9d8, whitelist): 0
[2020-08-17 20:15:15.327 5457M] Finalizing gravity statements for 127.0.0.1
[2020-08-17 20:15:15.328 5457M] Initializing gravity statements for 127.0.0.1
[2020-08-17 20:15:15.328 5457M] SQL: Comparing 127.0.0.1 vs. 10.0.1.0/16 (subnet 255.255.0.0) - NO MATCH
[2020-08-17 20:15:15.328 5457M] SQL: Comparing 127.0.0.1 vs. 10.0.10.1/24 (subnet 255.255.255.0) - NO MATCH
[2020-08-17 20:15:15.329 5457M] Found database hardware address 127.0.0.1 -> ip-127.0.0.1
[2020-08-17 20:15:15.329 5457M] Skipping mock-device hardware address lookup
[2020-08-17 20:15:15.330 5457M] Found database host name 127.0.0.1 -> localhost
[2020-08-17 20:15:15.332 5457M] Found database interface 127.0.0.1 -> lo
[2020-08-17 20:15:15.332 5457M] gravityDB_open(): Preparing vw_whitelist statement for client 127.0.0.1
[2020-08-17 20:15:15.332 5457M] get_client_querystr: SELECT EXISTS(SELECT domain from vw_whitelist WHERE domain = ? AND group_id IN (0));
[2020-08-17 20:15:15.332 5457M] gravityDB_open(): Preparing vw_gravity statement for client 127.0.0.1
[2020-08-17 20:15:15.333 5457M] get_client_querystr: SELECT EXISTS(SELECT domain from vw_gravity WHERE domain = ? AND group_id IN (0));
[2020-08-17 20:15:15.333 5457M] gravityDB_open(): Preparing vw_blacklist statement for client 127.0.0.1
[2020-08-17 20:15:15.333 5457M] get_client_querystr: SELECT EXISTS(SELECT domain from vw_blacklist WHERE domain = ? AND group_id IN (0));
[2020-08-17 20:15:15.334 5457M] domain_in_list("3.1.0.10.in-addr.arpa", 0xaaab0f22ed68, blacklist): 0
[2020-08-17 20:15:15.334 5457M] domain_in_list("3.1.0.10.in-addr.arpa", 0xaaab0f22e8b8, gravity): 0
[2020-08-17 20:15:15.338 6105/F5457] TCP worker forked for client 127.0.0.1 on interface lo (127.0.0.1)
[2020-08-17 20:15:15.339 6105/F5457] gravityDB_open(): Trying to open /etc/pihole/gravity.db in read-only mode
[2020-08-17 20:15:15.339 5457M] domain_in_list("4.1.0.10.in-addr.arpa", 0xaaab0f22c338, whitelist): 0
[2020-08-17 20:15:15.339 6105/F5457] gravityDB_open(): Setting location for temporary object to MEMORY
[2020-08-17 20:15:15.340 6105/F5457] gravityDB_open(): Preparing audit query
Add
Updated and flushed network table. No empty clients returned. Maybe it was a network hiccup.