Full ALPR Database System for Blue Iris!

[Janhaus]

Wow so I figured it out what the issue was, thanks so much @PeteJ and everybody else who helped debug this. Originally, I was on 5.9.9.19 and the settings shown in post 933 did NOT work for me.
I then UPGRADED TO 5.9.9.44, adjusted my settings to post980, and it started working. So I downgraded back to 5.9.9.19 (last version available to my lifetime license, SMH), using these settings, same as post980 and it still works!

So, full set of instructions to my brethren struggling with this in this thread. Install the docker container via the website instructions, make sure you update the API key in the web interface.
You can run an MD5 check on the migrations.sql and schema.sql if you wish, mine matched the repository exactly but still gave me errors.

If you get this error
5/1/2025, 1:21:28 PM [ERROR] Error processing request: error: there is no unique or exclusion constraint matching the ON CONFLICT specification

Then run these commands in your docker (the db one, not the app one):
psql -d postgres -U postgres -f /docker-entrypoint-initdb.d/schema.sql
psql -d postgres -U postgres -f /docker-entrypoint-initdb.d/migrations.sql
which may then result in logs like these:
5/1/2025, 3:00:12 PM [ERROR] Error processing request: error: null value in column "plate_number" of relation "plate_reads" violates not-null constraint

Then make sure your AI Configuration, under AI settings in BlueIris are set to this, and it worked for me! Whew...

 

[PeteJ]

Now the fun begins--you need to tune your camera and BI to capture plates in day and night conditions.

 

[Vettester]

Why the *:30 in the "To confirm" field?

 

[PeteJ]

Why the *:30 in the "To confirm" field?

It sets the min confidence to 30, which overrides whatever it is set in the GUI in BI. I left it in while I was trouble shooting some issues where CPAI would return values that fall below the threshold (in my case it's 70% in CPAI) and it should have been rejected by BI, but BI sends it to ALPR. As odd as it sounds, having this value reduced the issue by a lot. No, I don't know why. I asked on this thread if anyone else was seeing this, and no one replied, so I guess it's just me

 

[Vettester]

It sets the min confidence to 30, which overrides whatever it is set in the GUI in BI.

I understand how it works, but it's supposed to be used when you want different confidence levels for detecting multiple object. In the case of an LPR camera, where you are only detecting a license plate, it doesn't make sense.