Full ALPR Database System for Blue Iris!
- Thread starter algertc
- Start date
Did you control-left click on the clip?
TheWaterbug
Getting comfortable
Ah, there they are. I was looking in my V: drive, where I store everything else:
I see JPGs paired up with DAT files, which I'm assuming is good news, because it means something that done something with those JPGs. Except, curiously, I don't see a JPG for 7:08 PM last night, which is when I manually generated a snapshot of my plate, above.
edit: is this because the Alert generated a "Nothing Found"?
TheWaterbug
Getting comfortable
If I ctrl-click on the Alert clip, I see all these options, but none appears to take me to the AI pane:
If I switch from Alerts to AI Alerts, I get nothing:
MikeLud1
IPCT Contributor
TheWaterbug
Getting comfortable
User error. 
I wasn't recording JPEGs. I am now:
For some reason I'd thought that, since it was examining the video feed, that it would use that for the analysis. Now that I've checked the JPEGs box, I'm getting plates. There are two cars parked in the FOV of one of my LPR cameras, so I did a manual trigger:
My CPAI log has a ton of entries from just this single event. Plate reads are correct:
Is this because I'm calling the Web Request for both the Trigger and for the Alert?
So now I'm partway there, but the ALPR database still isn't populating:
I wasn't recording JPEGs. I am now:For some reason I'd thought that, since it was examining the video feed, that it would use that for the analysis. Now that I've checked the JPEGs box, I'm getting plates. There are two cars parked in the FOV of one of my LPR cameras, so I did a manual trigger:
My CPAI log has a ton of entries from just this single event. Plate reads are correct:
Code:
10:52:37:Response rec'd from License Plate Reader command 'alpr' (...638194) ['Found Plate: 8FTEXXX, Plate: 6B0MXXX'] took 904ms
10:52:37:Response rec'd from License Plate Reader command 'alpr' (...4a8021) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1005ms
Code:
10:52:36:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...66f8f8) ['Found DayPlate, DayPlate'] took 351ms
10:52:36:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...2d7501) ['Found DayPlate, DayPlate'] took 488ms
10:52:37:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...fe913b) ['Found DayPlate, DayPlate'] took 562ms
10:52:37:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...2c5290) ['Found DayPlate, DayPlate'] took 741ms
10:52:37:Response rec'd from License Plate Reader command 'alpr' (...b0e086) ['Found Plate: 8FTEXXX, Plate: 6B0MXXX'] took 661ms
10:52:37:Response rec'd from License Plate Reader command 'alpr' (...638194) ['Found Plate: 8FTEXXX, Plate: 6B0MXXX'] took 904ms
10:52:37:Response rec'd from License Plate Reader command 'alpr' (...4a8021) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1005ms
10:52:37:Response rec'd from License Plate Reader command 'alpr' (...097798) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1256ms
10:52:38:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...c24327) ['Found DayPlate, DayPlate'] took 220ms
10:52:38:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...554593) ['Found DayPlate, DayPlate'] took 404ms
10:52:38:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...0e97d8) ['Found DayPlate, DayPlate'] took 552ms
10:52:38:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...1a021d) ['Found DayPlate, DayPlate'] took 733ms
10:52:38:Response rec'd from License Plate Reader command 'alpr' (...2ec697) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 567ms
10:52:39:Response rec'd from License Plate Reader command 'alpr' (...6f011a) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 859ms
10:52:39:Response rec'd from License Plate Reader command 'alpr' (...59301a) ['Found Plate: 8FTEXXX, Plate: 6B0MXXX'] took 1089ms
10:52:39:Response rec'd from License Plate Reader command 'alpr' (...429e98) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1271ms
10:52:39:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...6d84be) ['Found DayPlate, DayPlate'] took 228ms
10:52:39:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...63d6f8) ['Found DayPlate, DayPlate'] took 391ms
10:52:39:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...aae9eb) ['Found DayPlate, DayPlate'] took 571ms
10:52:40:Response rec'd from License Plate Reader command 'alpr' (...c4ed35) ['Found Plate: 8FTEXXX, Plate: 6B0MXXX'] took 583ms
10:52:40:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...9e1c74) ['Found DayPlate, DayPlate'] took 752ms
10:52:40:Response rec'd from License Plate Reader command 'alpr' (...3a16eb) ['Found Plate: 8FTEXXX, Plate: 6B0MXXX'] took 800ms
10:52:40:Response rec'd from License Plate Reader command 'alpr' (...a01492) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 957ms
10:52:40:Response rec'd from License Plate Reader command 'alpr' (...79d5bb) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1189ms
10:52:40:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...c962fd) ['Found DayPlate, DayPlate'] took 228ms
10:52:40:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...f351c3) ['Found DayPlate, DayPlate'] took 408ms
10:52:41:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...7968cd) ['Found DayPlate, DayPlate'] took 584ms
10:52:41:Response rec'd from License Plate Reader command 'alpr' (...ca2d0b) ['Found Plate: 8FTEXXX, Plate: 6BOMXXX'] took 563ms
10:52:41:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...6dd3b0) ['Found DayPlate, DayPlate'] took 733ms
10:52:41:Response rec'd from License Plate Reader command 'alpr' (...e3acc2) ['Found Plate: 8FTEXXX, Plate: 6BOMXXX'] took 781ms
10:52:41:Response rec'd from License Plate Reader command 'alpr' (...2fde67) ['Found Plate: 8FTEXXX, Plate: 6B0MXXX'] took 965ms
10:52:41:Response rec'd from License Plate Reader command 'alpr' (...84601b) ['Found Plate: 8FTEXXX, Plate: 6B0MXXX'] took 1169ms
10:52:42:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...49d7e4) ['Found DayPlate, DayPlate'] took 222ms
10:52:42:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...2510d1) ['Found DayPlate, DayPlate'] took 405ms
10:52:42:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...b4c4e2) ['Found DayPlate, DayPlate'] took 584ms
10:52:42:Response rec'd from License Plate Reader command 'alpr' (...bed1a7) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 589ms
10:52:42:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...bbfb76) ['Found DayPlate, DayPlate'] took 640ms
10:52:42:Response rec'd from License Plate Reader command 'alpr' (...678458) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 790ms
10:52:43:Response rec'd from License Plate Reader command 'alpr' (...5a2553) ['Found Plate: 8FTEXXX, Plate: 6B0MXXX'] took 990ms
10:52:43:Response rec'd from License Plate Reader command 'alpr' (...aed38f) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1104ms
10:52:43:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...c8c910) ['Found DayPlate, DayPlate'] took 225ms
10:52:43:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...532526) ['Found DayPlate, DayPlate'] took 412ms
10:52:43:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...cf13e4) ['Found DayPlate, DayPlate'] took 589ms
10:52:43:Response rec'd from License Plate Reader command 'alpr' (...1eb83f) ['Found Plate: 6BOMXXX, Plate: 8FTEXXX'] took 588ms
10:52:43:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...bb4560) ['Found DayPlate, DayPlate'] took 590ms
10:52:44:Response rec'd from License Plate Reader command 'alpr' (...82e0e1) ['Found Plate: 6BOMXXX, Plate: 8FTEXXX'] took 804ms
10:52:44:Response rec'd from License Plate Reader command 'alpr' (...be6608) ['Found Plate: 8FTEXXX, Plate: 6B0MXXX'] took 1059ms
10:52:44:Response rec'd from License Plate Reader command 'alpr' (...e3d9fe) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1156ms
10:52:44:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...7a4eee) ['Found DayPlate, DayPlate'] took 226ms
10:52:44:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...10f808) ['Found DayPlate, DayPlate'] took 407ms
10:52:45:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...d115f4) ['Found DayPlate, DayPlate'] took 583ms
10:52:45:Response rec'd from License Plate Reader command 'alpr' (...e402a7) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 522ms
10:52:45:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...da1103) ['Found DayPlate, DayPlate'] took 764ms
10:52:45:Response rec'd from License Plate Reader command 'alpr' (...52c292) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 694ms
10:52:45:Response rec'd from License Plate Reader command 'alpr' (...b45d24) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 904ms
10:52:45:Response rec'd from License Plate Reader command 'alpr' (...d6f9c9) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1148ms
10:54:27:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...9e0cb1) ['No objects found'] took 416ms
10:54:27:Response rec'd from License Plate Reader command 'alpr' (...e1be86) ['No plates found'] took 434ms
10:54:28:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...95ac1b) ['Found DayPlate'] took 499ms
10:54:28:Response rec'd from License Plate Reader command 'alpr' (...b4b477) ['Found Plate: 6B0MXXX'] took 683ms
10:54:28:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...d70070) ['No objects found'] took 682ms
10:54:28:Response rec'd from License Plate Reader command 'alpr' (...509e49) ['No plates found'] took 755ms
10:54:28:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...426500) ['Found DayPlate, DayPlate'] took 861ms
10:54:28:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...4be425) ['No objects found'] took 706ms
10:54:28:Response rec'd from License Plate Reader command 'alpr' (...5423c1) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1151ms
10:54:28:Response rec'd from License Plate Reader command 'alpr' (...de7e64) ['No plates found'] took 789ms
10:54:28:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...2a72c1) ['Found DayPlate'] took 358ms
10:54:28:Response rec'd from License Plate Reader command 'alpr' (...236a5d) ['Found Plate: 8FTEXXX'] took 693ms
10:54:28:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...29bdfc) ['Found DayPlate, DayPlate'] took 257ms
10:54:29:Response rec'd from License Plate Reader command 'alpr' (...be6198) ['Found Plate: 680MXXX, Plate: SFTEXXX'] took 571ms
10:54:29:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...7821b3) ['Found DayPlate, DayPlate'] took 222ms
10:54:29:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...eabd13) ['Found DayPlate, DayPlate'] took 402ms
10:54:29:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...58a282) ['Found DayPlate, DayPlate'] took 362ms
10:54:29:Response rec'd from License Plate Reader command 'alpr' (...a15139) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 479ms
10:54:30:Response rec'd from License Plate Reader command 'alpr' (...576bcf) ['Found Plate: 680MXXX, Plate: 8FTEXXX'] took 991ms
10:54:30:Response rec'd from License Plate Reader command 'alpr' (...24dfe7) ['Found Plate: 8FTEXXX, Plate: 680MXXX'] took 656ms
10:54:30:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...5c6677) ['Found DayPlate, DayPlate'] took 227ms
10:54:30:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...007af7) ['Found DayPlate, DayPlate'] took 408ms
10:54:30:Response rec'd from License Plate Reader command 'alpr' (...f259f9) ['Found Plate: 8FTEXXX, Plate: 6B0MXXX'] took 800ms
10:54:30:Response rec'd from License Plate Reader command 'alpr' (...6603e3) ['Found Plate: SFTEXXX, Plate: 6B0MXXX'] took 601ms
10:54:31:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...73d5bf) ['Found DayPlate, DayPlate'] took 228ms
10:54:31:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...d3444b) ['Found DayPlate, DayPlate'] took 411ms
10:54:31:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...0440a9) ['Found DayPlate, DayPlate'] took 595ms
10:54:31:Response rec'd from License Plate Reader command 'alpr' (...47a7c3) ['Found Plate: 680MXXX, Plate: 8FTEXXX'] took 526ms
10:54:32:Response rec'd from License Plate Reader command 'alpr' (...bae5eb) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 857ms
10:54:32:Response rec'd from License Plate Reader command 'alpr' (...56ae1a) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1117ms
10:54:32:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...6088a5) ['Found DayPlate, DayPlate'] took 229ms
10:54:32:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...edaa59) ['Found DayPlate, DayPlate'] took 416ms
10:54:32:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...f96767) ['Found DayPlate, DayPlate'] took 597ms
10:54:32:Response rec'd from License Plate Reader command 'alpr' (...9ba119) ['Found Plate: 680MXXX, Plate: 8FTEXXX'] took 496ms
10:54:33:Response rec'd from License Plate Reader command 'alpr' (...bf2347) ['Found Plate: 680MXXX, Plate: 8FTEXXX'] took 866ms
10:54:33:Response rec'd from License Plate Reader command 'alpr' (...b2e632) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1088ms
10:54:33:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...be5727) ['Found DayPlate, DayPlate'] took 235ms
10:54:33:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...8d9ebf) ['Found DayPlate, DayPlate'] took 414ms
10:54:33:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...fc4160) ['Found DayPlate, DayPlate'] took 593ms
10:54:34:Response rec'd from License Plate Reader command 'alpr' (...7da08e) ['Found Plate: 680MXXX, Plate: 8FTEXXX'] took 504ms
10:54:34:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...bccb8d) ['Found DayPlate, DayPlate'] took 704ms
10:54:34:Response rec'd from License Plate Reader command 'alpr' (...4f88fb) ['Found Plate: 680MXXX, Plate: 8FTEXXX'] took 841ms
10:54:34:Response rec'd from License Plate Reader command 'alpr' (...174009) ['Found Plate: 680MXXX, Plate: 8FTEXXX'] took 1418ms
10:54:34:Response rec'd from License Plate Reader command 'alpr' (...fcc094) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1546ms
10:54:35:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...7c01f7) ['Found DayPlate, DayPlate'] took 228ms
10:54:35:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...bfef58) ['Found DayPlate, DayPlate'] took 410ms
10:54:35:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...9a73e0) ['Found DayPlate, DayPlate'] took 590ms
10:54:35:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...aad7d0) ['Found DayPlate, DayPlate'] took 767ms
10:54:35:Response rec'd from License Plate Reader command 'alpr' (...4145da) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 624ms
10:54:36:Response rec'd from License Plate Reader command 'alpr' (...c93590) ['Found Plate: 680MXXX, Plate: 8FTEXXX'] took 871ms
10:54:36:Response rec'd from License Plate Reader command 'alpr' (...f1fb1c) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1074ms
10:54:36:Response rec'd from License Plate Reader command 'alpr' (...acc206) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1240ms
10:54:36:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...2184cd) ['Found DayPlate, DayPlate'] took 225ms
10:54:36:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...4c7158) ['Found DayPlate, DayPlate'] took 411ms
10:54:37:Response rec'd from License Plate Reader command 'alpr' (...2c9e58) ['Found Plate: 6R0MXXX, Plate: 8FTEXXX'] took 543ms
10:54:37:Response rec'd from License Plate Reader command 'alpr' (...9b55a6) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1184msIs this because I'm calling the Web Request for both the Trigger and for the Alert?
So now I'm partway there, but the ALPR database still isn't populating:
MikeLud1
IPCT Contributor
TheWaterbug
Getting comfortable
Thanks! I now have roughly half the traffic per trigger:
Code:
12:08:16:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...f5989c) ['Found DayPlate, DayPlate'] took 406ms
12:08:16:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...f5fdee) ['Found DayPlate, DayPlate'] took 566ms
12:08:16:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...c36aa6) ['Found DayPlate, DayPlate'] took 663ms
12:08:17:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...ba0e7a) ['Found DayPlate, DayPlate'] took 817ms
12:08:18:Response rec'd from License Plate Reader command 'alpr' (...237f06) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1927ms
12:08:18:Response rec'd from License Plate Reader command 'alpr' (...d1ddf8) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 2201ms
12:08:18:Response rec'd from License Plate Reader command 'alpr' (...9765e6) ['Found Plate: 6BOMXXX, Plate: 8FTEXXX'] took 2353ms
12:08:18:Response rec'd from License Plate Reader command 'alpr' (...53de32) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 2533ms
12:08:19:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...f0e1aa) ['Found DayPlate, DayPlate'] took 250ms
12:08:19:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...950e7e) ['Found DayPlate, DayPlate'] took 432ms
12:08:19:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...6f2b4d) ['Found DayPlate, DayPlate'] took 617ms
12:08:19:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...2354cd) ['Found DayPlate, DayPlate'] took 803ms
12:08:20:Response rec'd from License Plate Reader command 'alpr' (...b017aa) ['Found Plate: 6BOMXXX, Plate: 8FTEXXX'] took 1720ms
12:08:20:Response rec'd from License Plate Reader command 'alpr' (...424922) ['Found Plate: 6BOMXXX, Plate: 8FTEXXX'] took 1500ms
12:08:20:Response rec'd from License Plate Reader command 'alpr' (...3480df) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1273ms
12:08:20:Response rec'd from License Plate Reader command 'alpr' (...735399) ['Found Plate: 6BOMXXX, Plate: 8FTEXXX'] took 1738ms
12:08:20:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...efcc4d) ['Found DayPlate, DayPlate'] took 222ms
12:08:21:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...158324) ['Found DayPlate, DayPlate'] took 406ms
12:08:21:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...4a2622) ['Found DayPlate, DayPlate'] took 583ms
12:08:21:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...bd5a82) ['Found DayPlate, DayPlate'] took 747ms
12:08:21:Response rec'd from License Plate Reader command 'alpr' (...9096a4) ['Found Plate: 8FTEXXX, Plate: 6B0MXXX'] took 610ms
12:08:21:Response rec'd from License Plate Reader command 'alpr' (...b948b4) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 910ms
12:08:22:Response rec'd from License Plate Reader command 'alpr' (...c9b1ff) ['Found Plate: 6R0MXXX, Plate: 8FTEXXX'] took 2005ms
12:08:22:Response rec'd from License Plate Reader command 'alpr' (...b4aeb7) ['Found Plate: 8FTEXXX, Plate: 6B0MXXX'] took 1387ms
12:08:22:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...b29aa6) ['Found DayPlate, DayPlate'] took 229ms
12:08:22:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...303e9d) ['Found DayPlate, DayPlate'] took 413ms
12:08:22:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...ff8b70) ['Found DayPlate, DayPlate'] took 585ms
12:08:22:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...c81b70) ['Found DayPlate, DayPlate'] took 764ms
12:08:23:Response rec'd from License Plate Reader command 'alpr' (...c3964a) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 616ms
12:08:23:Response rec'd from License Plate Reader command 'alpr' (...483bbf) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 967ms
12:08:23:Response rec'd from License Plate Reader command 'alpr' (...953cb1) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1963ms
12:08:23:Response rec'd from License Plate Reader command 'alpr' (...47045d) ['Found Plate: 6B0MXXX'] took 1970ms
12:08:23:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...c44d4e) ['Found DayPlate, DayPlate'] took 221ms
12:08:23:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...203b4f) ['Found DayPlate, DayPlate'] took 401ms
12:08:24:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...471d2d) ['Found DayPlate, DayPlate'] took 584ms
12:08:24:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...78cf0d) ['Found DayPlate, DayPlate'] took 760ms
12:08:24:Response rec'd from License Plate Reader command 'alpr' (...b75867) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 513ms
12:08:24:Response rec'd from License Plate Reader command 'alpr' (...d43acb) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1069ms
12:08:24:Response rec'd from License Plate Reader command 'alpr' (...137201) ['Found Plate: 8FTEXXX, Plate: 6B0MXXX'] took 1500ms
12:08:24:Response rec'd from License Plate Reader command 'alpr' (...1b94c4) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1835ms
12:08:24:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...601cc2) ['Found DayPlate, DayPlate'] took 222ms
12:08:25:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...78a9f4) ['Found DayPlate, DayPlate'] took 399ms
12:08:25:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...03eb8c) ['Found DayPlate, DayPlate'] took 586ms
12:08:25:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...a66510) ['Found DayPlate, DayPlate'] took 754ms
12:08:25:Response rec'd from License Plate Reader command 'alpr' (...314c28) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 941ms
12:08:25:Response rec'd from License Plate Reader command 'alpr' (...ec62f6) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 807ms
12:08:26:Response rec'd from License Plate Reader command 'alpr' (...a00f70) ['Found Plate: 8FTEXXX, Plate: 6B0MXXX'] took 1796ms
12:08:26:Response rec'd from License Plate Reader command 'alpr' (...626135) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1301ms
12:08:26:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...648fd6) ['Found DayPlate, DayPlate'] took 238ms
12:08:26:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...86d0f5) ['Found DayPlate, DayPlate'] took 418ms
12:08:26:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...a203f5) ['Found DayPlate, DayPlate'] took 594ms
12:08:26:Response rec'd from Object Detection (YOLOv5 .NET) command 'custom' (...f13e14) ['Found DayPlate, DayPlate'] took 775ms
12:08:27:Response rec'd from License Plate Reader command 'alpr' (...f3858f) ['Found Plate: 6BOMXXX, Plate: 8FTEXXX'] took 901ms
12:08:27:Response rec'd from License Plate Reader command 'alpr' (...658183) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1624ms
12:08:27:Response rec'd from License Plate Reader command 'alpr' (...e1ce6f) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 2149ms
12:08:27:Response rec'd from License Plate Reader command 'alpr' (...4019e8) ['Found Plate: 6B0MXXX, Plate: 8FTEXXX'] took 1814msTheWaterbug
Getting comfortable
Ah, on my machine it's ctrl-double-left-click, but that may be because I'm RDPing in from a Mac. That took a long time to figure out! But now I have AI details:
That's my car! That's my plate! 98%!!
But my ALPR dashboard is still showing 0 records, and its /storage/ directory is empty. I must have botched something with the setup or config.
TheWaterbug
Getting comfortable
I tore down the containers, re-pulled, and re-composed them, and I'm still not seeing anything on my ALPR Dashboard nor in /storage/. I took a peek at the Docker Container Details, and I see some errors:
alpr-db-1 has a lot of errors like
2025-01-31 21:47:52.072 GMT [175] ERROR: relation "plate_reads" does not exist at character 150 and
2025-01-31 21:48:19.982 GMT [205] ERROR: relation "plate_notifications" does not exist at character 20algertc/alpr-dashboard:latest has messages like:
Code:
2025-01-31 13:48:22 Received plate read data: {
2025-01-31 13:48:22 plate_number: '8FTE129',
2025-01-31 13:48:22 Image: <bunch of stuff>
2025-01-31 13:48:22 camera: 'WDrSouth',
2025-01-31 13:48:22 timestamp: '2025-01-31T21:48:08.617Z'
2025-01-31 13:48:22 }
2025-01-31 13:48:22 Database connection establishedbut also:
Code:
Error processing request: error: relation "plate_notifications" does not exist
2025-01-31 13:48:22 at <unknown> (/app/node_modules/pg-pool/index.js:45:11)
2025-01-31 13:48:22 at async N (/app/.next/server/chunks/460.js:160:12)
2025-01-31 13:48:22 at async p (/app/.next/server/app/api/plate-reads/route.js:1:3760)
2025-01-31 13:48:22 at async te.do (/app/node_modules/next/dist/compiled/next-server/app-route.runtime.prod.js:18:17826)
2025-01-31 13:48:22 at async te.handle (/app/node_modules/next/dist/compiled/next-server/app-route.runtime.prod.js:18:22492)
2025-01-31 13:48:22 at async doRender (/app/node_modules/next/dist/server/base-server.js:1455:42)
2025-01-31 13:48:22 at async responseGenerator (/app/node_modules/next/dist/server/base-server.js:1814:28)
2025-01-31 13:48:22 at async NextNodeServer.renderToResponseWithComponentsImpl (/app/node_modules/next/dist/server/base-server.js:1824:28)
2025-01-31 13:48:22 at async NextNodeServer.renderPageComponent (/app/node_modules/next/dist/server/base-server.js:2240:24) {
2025-01-31 13:48:22 length: 118,
2025-01-31 13:48:22 severity: 'ERROR',
2025-01-31 13:48:22 code: '42P01',
2025-01-31 13:48:22 detail: undefined,
2025-01-31 13:48:22 hint: undefined,
2025-01-31 13:48:22 position: '20',
2025-01-31 13:48:22 internalPosition: undefined,
2025-01-31 13:48:22 internalQuery: undefined,
2025-01-31 13:48:22 where: undefined,
2025-01-31 13:48:22 schema: undefined,
2025-01-31 13:48:22 table: undefined,
2025-01-31 13:48:22 column: undefined,
2025-01-31 13:48:22 dataType: undefined,
2025-01-31 13:48:22 constraint: undefined,
2025-01-31 13:48:22 file: 'parse_relation.c',
2025-01-31 13:48:22 line: '1373',
2025-01-31 13:48:22 routine: 'parserOpenTable'
2025-01-31 13:48:22 }So it looks like it's talking to the database, with data, but something is not populating.
MikeLud1
IPCT Contributor
TheWaterbug
Getting comfortable
Yes, but I'm an idiot.
My schema.sql file was the HTML of this page, not the actual schema.sql file.
I replaced that with the actual schema.sql file, and redid the down/pull/up sequence. But curiously, if I look at the new container's logs, I see in the early part:
2025-01-31 14:13:34 PostgreSQL Database directory appears to contain a database; Skipping initializationand then after a trigger I still see:
2025-01-31 14:22:10 2025-01-31 22:22:10.709 GMT [493] ERROR: relation "plate_reads" does not exist at character 150Is the PostgreSQL Database directory appears to contain a database message expected? Does the pulled image already contain a db? I would have thought tearing down the container would have deleted any existing database(s).
TheWaterbug
Getting comfortable
Here's my one positive contribution to this thread. Future users may want to add restart: unless-stopped between image and environment to the db section of their docker-compose.yml, e.g.:
Otherwise the postgres database doesn't automatically start on a reboot.
Code:
db:
image: postgres:13
restart: unless-stopped
environment:Otherwise the postgres database doesn't automatically start on a reboot.
Vettester
Getting comfortable
- Feb 5, 2017
- 893
- 868
The existing database remains intact unless you deleted the alpr_db-data volume.
MikeLud1
IPCT Contributor
The docker-compose.yml does have restart: unless-stopped. Make sure you changed the highlighted passwords
ALPR-Database/docker-compose.yml at main · algertc/ALPR-Database
Fully-Featured Automated License Plate Recognition Database for Blue Iris + CodeProject AI Server - algertc/ALPR-Database
github.com
TheWaterbug
Getting comfortable
Ah, I was reading off the copy embedded in the ReadMe.MD file, which is out of sync, and probably has other changes as well.The docker-compose.yml does have restart: unless-stopped. Make sure you changed the highlighted passwords
ALPR-Database/docker-compose.yml at main · algertc/ALPR-Database
Fully-Featured Automated License Plate Recognition Database for Blue Iris + CodeProject AI Server - algertc/ALPR-Database
Downloading the current version . . .
TheWaterbug
Getting comfortable
TheWaterbug
Getting comfortable
Where does this live? I searched my C: drive and my V: drive, and I haven't found this. Does it live inside Docker's virtual infrastructure somehow?
I'm still not getting records into my database, nor images into /images or /thumbnails, despite seeing traffic in the containers, so I think I probably need to rebuild the database from scratch.