Full ALPR Database System for Blue Iris!

[wpiman]

There were a couple of early versions of BI6 where Ken changed the JSON format, but he has changed it back so if you are up to date it should be working.

I am on 6.0.3.8

 

[VideoDad]

I was just looking at my and realized the database hasn't update in a month. I'll take a look at it... I think the format from Blue Iris might have changed? There messages are still going in but it is complaining about the key I think

Check the API key didn't accidentally get reset. Can you give us the exact error message from the ALPR DB logs?

 

[wpiman]

Check the API key didn't accidentally get reset. Can you give us the exact error message from the ALPR DB logs?

 

[wpiman]

Error processing request: SyntaxError: Unexpected token ',', ...""ai_dump":, "Image":"... is not valid JSON
Error processing request: SyntaxError: Unexpected token ',', ...""ai_dump":, "Image":"... is not valid JSON
Error processing request: SyntaxError: Unexpected token ',', ...""ai_dump":, "Image":"... is not valid JSON

 

[wpiman]

So I ran the database command listed above...

Still didn't work.

I ended up having to change my Blue Iris HTTP alert POST body from:

{"ai_dump":&JSON, "Image":"&ALERT_JPEG", "camera":"&CAM", "timestamp":"&ALERT_TIME"}

To:

{"plate_number":"&PLATE", "Image":"&ALERT_JPEG", "camera":"&CAM", "timestamp":"&ALERT_TIME"}

Not quite sure what is up. At some point I moved Codeproject to CUDA and maybe Mike's ALPR 11...

 

[TheWaterbug]

So I ran the database command listed above...

Still didn't work.

I ended up having to change my Blue Iris HTTP alert POST body from:

{"ai_dump":&JSON, "Image":"&ALERT_JPEG", "camera":"&CAM", "timestamp":"&ALERT_TIME"}

To:

{"plate_number":"&PLATE", "Image":"&ALERT_JPEG", "camera":"&CAM", "timestamp":"&ALERT_TIME"}

I'm using:

{ "ai_dump":&JSON, "Image":"&ALERT_JPEG", "camera":"&CAM", "ALERT_PATH": "&ALERT_PATH", "ALERT_CLIP": "&ALERT_CLIP", "timestamp":"&ALERT_TIME" }

and it's been working fine through the 5.x to 6.x transition, once I checked all the other required boxes.

 

[wpiman]

I'm using:

{ "ai_dump":&JSON, "Image":"&ALERT_JPEG", "camera":"&CAM", "ALERT_PATH": "&ALERT_PATH", "ALERT_CLIP": "&ALERT_CLIP", "timestamp":"&ALERT_TIME" }

and it's been working fine through the 5.x to 6.x transition, once I checked all the other required boxes.

Yeah, I am not sure why the ai_dump stopped working for me. I cloned a camera and one is working with Codeproject and the second ALPR one is working with working with the Blue Iris AI. Both are showing up with that change.

 

[PeteJ]

Yeah, I am not sure why the ai_dump stopped working for me. I cloned a camera and one is working with Codeproject and the second ALPR one is working with working with the Blue Iris AI. Both are showing up with that change.

You can try expanding the macro in BI and see what it does.

P

Post in thread 'Full ALPR Database System for Blue Iris!'

Oct 16, 2025

You can expand any or all of your macros and save it to a text file on BI. To do this, go to your camera's On Alert tab and create a new action. Select write-to-file as the method. This should show what BI is sending to the ALPR database.

• PeteJ

• 
• 

 

[iwanttosee]

Yeah, I am not sure why the ai_dump stopped working for me. I cloned a camera and one is working with Codeproject and the second ALPR one is working with working with the Blue Iris AI. Both are showing up with that change.

Run
sudo docker ps -a

To get the Container:ID of postgres:13

Then
sudo docker exec -it Container:ID bash

Then Try below commands.

T

Post in thread 'Full ALPR Database System for Blue Iris!'

Dec 30, 2025

Here is the fix I applied
I ran this in the console section of portainer. I was in container alpr_database-db-1

#to get into PostgresSQL

psql -U postgres

#Then I applied this fix. Just copy and paste it


-- Create a sequence for the id column
CREATE SEQUENCE IF NOT EXISTS plate_reads_id_seq;

-- Attach the sequence to plate_reads.id
ALTER TABLE plate_reads
ALTER COLUMN id SET DEFAULT nextval('plate_reads_id_seq');

-- Ensure proper ownership
ALTER SEQUENCE plate_reads_id_seq
OWNED BY plate_reads.id;

-- Sync the sequence with existing rows
SELECT setval(
'plate_reads_id_seq'...

• tmushy

• 
• 

 

[wpiman]

Those are the post gres commands I wrote. Everything appears to be working with my new command-- just not sure when things got derailed... I like the idea of saving the file. I'll add that and wait for a car.