Full ALPR Database System for Blue Iris!

Im running ALPR on a Linux Mint VM in Unraid and managed to tank my VM as well as my VM backup. I lost all my plates data. Oh well.

Ive got VM snapshot now which should make it easier to restore things.

Was wondering if there is an easy way to backup the ALPR database to another location and have option to restore.
 
Gimmons said:
Try running the following commands in the db container (per janhaus):

Code:
psql -d postgres -U postgres -f /docker-entrypoint-initdb.d/schema.sql

Code:
psql -d postgres -U postgres -f /docker-entrypoint-initdb.d/migrations.sql

If you get an error because there was no schema or migration file in the container, but you can see the file listed in the files tab for the container, see if there is a note with the word "mount." If so it means the container is accessing the file externally. If you copy the latest version of the file into your container and run the command again, it should work.
Click to expand...

I get the no migration file error. It does say mount. How can I copy the latest version into the container? Using command prompt I always get "Error response from daemon: unlinkat /migrations.sql: device or resource busy". Even if the containers are stopped
 
Also, is anyone able to access the server remotely?

I can get the login page, but when putting in my password it just refreshes the page.

Blue iris and codeproject have no problems with accessing via local IP
 
silvertonesx24 said:
What is mean is that locally, when I try and log in using the local ip address, I get the login page, prompting for a password, but it won't log me in.
Click to expand...
It sounds like a firewall issue. You need to create an inbound and outbound rule allowing the port you setup for the app (typically 3000).

Here's an example of mine. I'm using port 3001.

Screen Shot 2025-06-10 at 10.15.57 PM.png
 
Vettester said:
It sounds like a firewall issue. You need to create an inbound and outbound rule allowing the port you setup for the app (typically 3000).

Here's an example of mine. I'm using port 3001.
Click to expand...
I tried and still no go

Logging into the ALPR database only works on the local machine it is running on.

Here is my error log, **** replacing session IDs

6/11/2025, 8:55:50 AM [WARN] No whitelisted IPs configured
6/11/2025, 8:55:50 AM [INFO] No session or IP not whitelisted, redirecting to /login.
6/11/2025, 8:55:50 AM [INFO] GET /login
6/11/2025, 8:55:51 AM [INFO] Middleware checking path: /login, Session ID from cookie: null
6/11/2025, 8:55:59 AM [INFO] GET /
6/11/2025, 8:55:59 AM [INFO] Middleware checking path: /, Session ID from cookie: null
6/11/2025, 8:55:59 AM [INFO] No session ID found in cookie. Checking IP whitelist or redirecting to login.
6/11/2025, 8:55:59 AM [INFO] POST /api/verify-whitelist
6/11/2025, 8:55:59 AM [INFO] Checking IP: 172.18.0.1
6/11/2025, 8:56:03 AM [INFO] Attempting login...
6/11/2025, 8:56:03 AM [INFO] Session limit reached. Removing oldest session: ****************
6/11/2025, 8:56:03 AM [INFO] Created session ID: ****************
6/11/2025, 8:56:04 AM [ERROR] Login error: Error: NEXT_REDIRECT
 
You must log in or register to reply here.
Top Bottom