Full ALPR Database System for Blue Iris!
- Thread starter algertc
- Start date
Sorry I am a complete newb when it comes to docker. I just followed the instructions on the github to install on the BI pc. What is an auth directory?
Take a look at your docker compose file, you should have lines in there that look like this:
volumes:
- app-auth:/app/auth
- app-config:/app/config
- app-plate_images:/app/storage
volumes:
db-data:
app-auth:
driver: local
driver_opts:
type: none
o: bind
device: ./auth
Check if this directory exists and has the correct permissions.
Manual Installation
Fully-Featured Automated License Plate Recognition Database Platform for Blue Iris + CodeProject AI Server - algertc/ALPR-Database
github.com
... it's step 3 if you were installing manually:
Quick Start:
- Ensure you have Docker and Docker compose installed on your system.
- In a new directory, create a file named docker-compose.yml and paste in the content below, changing the variables to the passwords you would like to use.
- Create three new directories / folders in this directory called "config", "storage", and "auth". These will ensure that your data is saved separately and not lost during updates.
OK thank you. I verified all of those directories exist, and have 'admin' permissions (which is administrator for the PC)... same user I installed docker and the alprdb script with. The dockercompose.yaml matches what the manual install instructions say... with the correct passwords. What worked for me is stopping the container, deleting it (from docker desktop), deleting all folders in the alprdb directory, and rerunning the script. That seems to have gotten everything working as expected.
Thanks again to all the selfless work between devs and forum members... I very much appreciate your help!
Thanks again to all the selfless work between devs and forum members... I very much appreciate your help!
Quick question, how do I ensure docker and the container will it restart after a reboot?
I saw in docker desktop settings a checkbox for "start docker desktop when user logs in", but that didn't sound like 'starting as a service' so not sure if it would work.
I saw in docker desktop settings a checkbox for "start docker desktop when user logs in", but that didn't sound like 'starting as a service' so not sure if it would work.
I am not sure how Windows does it, but in your docker compose file, you need to have the restart line:
services:
app:
restart: unless-stopped
I do have "unless-stopped" in my compose file. Not sure if that has to be "always", and I need to somehow get docker desktop started as a service.
On another note, I got some recognized plates with it running, but they aren't going into the database and the logs show the error:
'[ERROR]Error processing request: error: null value in column "id" of relation "plate_reads" violates not-null constraint'
Not sure what's going on there. I am using the blueiris rest macro as shown in the guide.
...edit: I just ran the update script after reading the troubleshooting section in the docs. Hopefully that gets the plates flowing to the database... nope still alerts still not going to the database. There are more logs that may help with troubleshooting:
On another note, I got some recognized plates with it running, but they aren't going into the database and the logs show the error:
'[ERROR]Error processing request: error: null value in column "id" of relation "plate_reads" violates not-null constraint'
Not sure what's going on there. I am using the blueiris rest macro as shown in the guide.
...edit: I just ran the update script after reading the troubleshooting section in the docs. Hopefully that gets the plates flowing to the database... nope still alerts still not going to the database. There are more logs that may help with troubleshooting:
Code:
[INFO]POST /api/plate-reads
9/10/2025, 1:00:19 PM
[INFO]Received plate read data: [object Object]
9/10/2025, 1:00:19 PM
[INFO]Database connection established
9/10/2025, 1:00:19 PM
[INFO][FileStorage] Successfully saved image
9/10/2025, 1:00:19 PM
[ERROR]Error processing request: error: null value in column "id" of relation "plate_reads" violates not-null constraint
9/10/2025, 1:00:19 PM
Last edited:
You might be having the same issue as this user.
Weird, my issue was slightly different, as I did see successful db connection in the logs. I got it actually fully working now after several attempts to remove and reinstall the container. Some observations I made along the way...
1) The first issue I ran in to, the admin password not working... I'm fairly certain was due to using a '$' in the password during the setup script. To get past this, I had to use a very basic password, then after logging in to the alprdb webui, changing the password to a proper password (containing the $). Then it works as expected. Twice in a row when using the complex pw in the script, I got the same result. Must be some issue with passing a "$" as password with that script.
2) The "[ERROR]Error processing request: error: null value in column "id" of relation "plate_reads" violates not-null constraint" happens every time after finishing the install script, and BI sends an alert. Running the ALPRdb update.ps1 script (and selecting "release version") whilst it was installed in a directory located in 'my documents' didn't seem to fix it. After a complete wipe of the container, volumes, and files, then reinstalling alprdb in a root folder "c:\alprdb\", the same error came up. Then this time, running the update.ps1 script, this time using "latest development release", and this the db to start working as expected.
So now everything seems to be working, but when I reboot the pc it doesn't restart itself. Circling back to the subject of 'running aplrdb as a service'... any tips/reading are greatly appreciated (in context to using docker desktop on windows... ie a newb install).
1) The first issue I ran in to, the admin password not working... I'm fairly certain was due to using a '$' in the password during the setup script. To get past this, I had to use a very basic password, then after logging in to the alprdb webui, changing the password to a proper password (containing the $). Then it works as expected. Twice in a row when using the complex pw in the script, I got the same result. Must be some issue with passing a "$" as password with that script.
2) The "[ERROR]Error processing request: error: null value in column "id" of relation "plate_reads" violates not-null constraint" happens every time after finishing the install script, and BI sends an alert. Running the ALPRdb update.ps1 script (and selecting "release version") whilst it was installed in a directory located in 'my documents' didn't seem to fix it. After a complete wipe of the container, volumes, and files, then reinstalling alprdb in a root folder "c:\alprdb\", the same error came up. Then this time, running the update.ps1 script, this time using "latest development release", and this the db to start working as expected.
So now everything seems to be working, but when I reboot the pc it doesn't restart itself. Circling back to the subject of 'running aplrdb as a service'... any tips/reading are greatly appreciated (in context to using docker desktop on windows... ie a newb install).
Last edited:
I asked about running docker as a service in Windows awhile ago, but wasn't able to find a solution. If you figure something out, let me know.
Roger that. I tried using the manual install method, and it works, but same issue with it starting as a service. I randomly tried enabling the 'docker desktop service' with autostart in windows services, but that didn't work either. Since my BI pc is headless, alprdb becomes pretty much useless to me without being able to start it as a service.
Man.. it's 2025 and this is still an issue? (former MCSE from the 90s).
I do have linux boxes on my lan that could run this, but I'd rather keep it all on the same PC. My HA rpi seems inappropriate for this (especially running hassos), my NAS is off limits for this sort of thing, which leaves the pi5 I use only for ham radio operation stuff... if I put alprdb on that then it stops working if I bring that pi for a park activation or similar.
I was hoping for a way to tweak this to work in windows. I tried a bunch of really hacky stuff, but nothing working so far. Seems it should be doable with a batch script no?
I was hoping for a way to tweak this to work in windows. I tried a bunch of really hacky stuff, but nothing working so far. Seems it should be doable with a batch script no?
Vettester
Getting comfortable
- Feb 5, 2017
- 989
- 971
There's a "Start Docker Desktop when you log in" option in the Docker Desktop settings that works well.
Last edited:
As I found, that doesn't seem to work until a user is manually logged in. So I have to RDP to the BI machine which logs in as a user, and then starts the docker engine.
Again if anyone knows of a way to do this automatically in Windows (short of disabling user credentials) several of us would appreciate it.
Again if anyone knows of a way to do this automatically in Windows (short of disabling user credentials) several of us would appreciate it.
Vettester
Getting comfortable
- Feb 5, 2017
- 989
- 971
Well I'll be dipped in skittles... Vettester that right there worked a treat! Thank you very much for the idea. I just did some quick regedit and now my alprdb is surviving reboots no problem!
Thanks @Vettester !
Thanks @Vettester !