Full ALPR Database System for Blue Iris!

djangel said:
This might help.

github.com

Received plate read data: [object Object] in Log · Issue #57 · algertc/ALPR-Database

Very much appreciate this project!!! Trying to get it working for the first time. BI is showing plates and the log appears to be showing data coming over, but plate count shows zero. ALPR-Database ...
github.com github.com
Click to expand...
I am stuck at the first steps..

postgres@blizzard:~$ psql -d postgres -U postgres -f /docker-entrypoint-initdb.d/schema.sql
psql: error: /docker-entrypoint-initdb.d/schema.sql: No such file or directory


sorry i am somewhat stupid on debian 12
 
Howdy all. Just a quick one

CodeprojectAL installed rocking away fine with plates

Due sql database conflicts I used port 5423, this caused a refuses connection error.
I looked through to many files with my old eyes and going crosseyed LOL

Can I change the port in the ALPR to use port 5423, if yes where can I do it.?

Ubuntu_20.04, Docker Desktop, codeprojectai and alpr on same machine for now

Thank you :)
ALPR_error2.JPG
ALPR_error.JPG
 
Last edited:
SoCal said:
Howdy all. Just a quick one

CodeprojectAL installed rocking away fine with plates

Due sql database conflicts I used port 5423, this caused a refuses connection error.
I looked through to many files with my old eyes and going crosseyed LOL

Can I change the port in the ALPR to use port 5423, if yes where can I do it.?

Ubuntu_20.04, Docker Desktop, codeprojectai and alpr on same machine for now

Thank you :)View attachment 224503View attachment 224488
Click to expand...
J

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

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...

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
 
  • Like
Reactions: SoCal
You must log in or register to reply here.
Top Bottom