unRAID Deployment

[olympia]

Hi Charlie,

I installed and set this up on unRAID (without docker compose) a couple of days ago.
I don't have lots of data yet, but looking absolutely amazing. Thank you very much for creating this!

Would it be possible to have a selector at the top plates to chose from last 24 hours, last week, last month, last year or maybe custom dates?

...and I am wondering about vehicle description on the live feed: is this configurable somewhere, or is this a dead leftover from some initial plan? :)

Many thanks again!

[prsmith777]

olympia:
I have tried to set up on unRAID using docker compose and its not working correctly. Was wondering if you could give me a quick overview on setting up without compose. thanks

[olympia]

@prsmith777 the docker-compose.yml file provides the overview, but what you need to do:

1. Create a postgres13 directory in your unRAID appdata, then create a data and a schema subdir in that
2. Copy the schema.sql referenced in the readme somewhere to schema subdir
3. Install postgres13 from unRAID Community Applications where you set the database storage path to the data subdir you created and create a new path where the container path is /docker-entrypoint-initdb.d/ and the host path is the schema subdir you created and have the schema.sql in it. Also set password to any. user and db to postgres.
4. create an alpr_dashboard directory in your unRAID appdata, then create am auth subdir in that
5. add a new container manually from docker tab by referencing algertc/alpr-dashboard:latest
6. add the following paths to alpr-dashboard: docker:
   • container path: /app/auth | host path to your auth subdir
   • container path: /app/config | host path to the alpr_dashboard directory
7. add the following variables:
   • key: NODE_ENV | value: production
   • key: ADMIN_PASSWORD | value: to your password
   • key: DB_PASSWORD | value: to your password
8. add a tcp port: 3000
9. that's it, you should be able to access the alpr database dasboard now
10. set database settings accordingly in the settings,

[prsmith777]

@olympia

Awesome thank you. Got it going

EDIT:

Not connecting to database.... getting this error:

Database connection test failed: Error: getaddrinfo ENOTFOUND db
at (/app/node_modules/pg-pool/index.js:45:11)
at async l (/app/.next/server/chunks/79.js:1:979)
at async A (/app/.next/server/chunks/79.js:288:45)
at async d (/app/.next/server/app/api/plate-reads/route.js:1:1926)
at async te.do (/app/node_modules/next/dist/compiled/next-server/app-route.runtime.prod.js:18:17826)
at async te.handle (/app/node_modules/next/dist/compiled/next-server/app-route.runtime.prod.js:18:22492)
at async doRender (/app/node_modules/next/dist/server/base-server.js:1455:42)
at async responseGenerator (/app/node_modules/next/dist/server/base-server.js:1814:28)
at async NextNodeServer.renderToResponseWithComponentsImpl (/app/node_modules/next/dist/server/base-server.js:1824:28) {
errno: -3008,
code: 'ENOTFOUND',
syscall: 'getaddrinfo',
hostname: 'db'

[algertc]

Would it be possible to have a selector at the top plates to chose from last 24 hours, last week, last month, last year or maybe custom dates?

...and I am wondering about vehicle description on the live feed: is this configurable somewhere, or is this a dead leftover from some initial plan? :)

I'll add some more configuration ability to the dashboard for things like date filtering.

The vehicle description is a bit of a leftover because the AI doesn't have a great way to do this currently, but I do plan to allow the user to manually enter these details. For now, you could just put it in the notes if you needed to. The other addition that I am prioritizing is the ability to correct plate recognitions in the live feed page. This will allow you to prevent your plate database from having 5 different variations of the same plate as a result of OCR misreads.

Thank you for sharing your Unraid instructions. I was going to make a docs directory to link to other more specific guides like this. If you would like credit, please make a pull request and put it in /docs/unraid.md.

I can also do it myself if you prefer.

[algertc]

@olympia

Awesome thank you. Got it going

EDIT:

Not connecting to database.... getting this error:

Database connection test failed: Error: getaddrinfo ENOTFOUND db at (/app/node_modules/pg-pool/index.js:45:11) at async l (/app/.next/server/chunks/79.js:1:979) at async A (/app/.next/server/chunks/79.js:288:45) at async d (/app/.next/server/app/api/plate-reads/route.js:1:1926) at async te.do (/app/node_modules/next/dist/compiled/next-server/app-route.runtime.prod.js:18:17826) at async te.handle (/app/node_modules/next/dist/compiled/next-server/app-route.runtime.prod.js:18:22492) at async doRender (/app/node_modules/next/dist/server/base-server.js:1455:42) at async responseGenerator (/app/node_modules/next/dist/server/base-server.js:1814:28) at async NextNodeServer.renderToResponseWithComponentsImpl (/app/node_modules/next/dist/server/base-server.js:1824:28) { errno: -3008, code: 'ENOTFOUND', syscall: 'getaddrinfo', hostname: 'db'

There are a few things you can check here.

• Since these containers are now separate and not in a stack together, you may need to set the db host as the IP address of your unraid machine + the port you exposed. The fact that it is saying hostname db not found leads me to believe that this is the cause. Using db only works if the containers are in the same docker network. So if your unraid machine is 1.2.3.4 and you exposed port 4000, you would want to set the database address as 1.2.3.4:4000 instead of db:4000.

• Make sure the postgres container is running and hasn't exited. If unraid is already running a database on port 5432, you will need to use a different port.

• In the app, go to the settings page and ensure that the database configuration is correct.

[olympia]

I'll add some more configuration ability to the dashboard for things like date filtering.
The vehicle description is a bit of a leftover because the AI doesn't have a great way to do this currently, but I do plan to allow the user to manually enter these details. For now, you could just put it in the notes if you needed to. The other addition that I am prioritizing is the ability to correct plate recognitions in the live feed page. This will allow you to prevent your plate database from having 5 different variations of the same plate as a result of OCR misreads.

Super, many thanks for all these!

Thank you for sharing your Unraid instructions. I was going to make a docs directory to link to other more specific guides like this. If you would like credit, please make a pull request and put it in /docs/unraid.md.

OK, but let's wait first if the instructions can get the first one go :)

@prsmith777 Did you follow the order of the instructions for postgres installation? If you started postgres docker without configuring the schema path first, then the alpr database hasn't got generated.

Also, how did you set the network for the dockers? Did you configure "bridge' networks or you set specific IP addresses for your dockers?

[prsmith777]

Thanks for both your help.

I added DBHOST: 192.168.0.250:3000 and still no luck

I did the configuration in order as stated.

I set network to bridge

There are no conflicts using port 5432

Here is postgres log:

2024-11-25 14:26:40.025 MST [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2024-11-25 14:26:40.025 MST [1] LOG: listening on IPv6 address "::", port 5432
2024-11-25 14:26:40.032 MST [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-11-25 14:26:40.040 MST [27] LOG: database system was shut down at 2024-11-25 14:26:36 MST
2024-11-25 14:26:40.048 MST [1] LOG: database system is ready to accept connections
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/lib/postgresql/data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... America/Denver
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

Success. You can now start the database server using:

pg_ctl -D /var/lib/postgresql/data -l logfile start

waiting for server to start....2024-11-25 14:07:36.418 MST [49] LOG: starting PostgreSQL 13.18 (Debian 13.18-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-11-25 14:07:36.422 MST [49] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-11-25 14:07:36.434 MST [50] LOG: database system was shut down at 2024-11-25 14:07:34 MST
2024-11-25 14:07:36.442 MST [49] LOG: database system is ready to accept connections
done
server started

/usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/

2024-11-25 14:07:36.544 MST [49] LOG: received fast shutdown request
waiting for server to shut down....2024-11-25 14:07:36.547 MST [49] LOG: aborting any active transactions
2024-11-25 14:07:36.549 MST [49] LOG: background worker "logical replication launcher" (PID 56) exited with exit code 1
2024-11-25 14:07:36.549 MST [51] LOG: shutting down
2024-11-25 14:07:36.572 MST [49] LOG: database system is shut down
done
server stopped

PostgreSQL init process complete; ready for start up.

PostgreSQL Database directory appears to contain a database; Skipping initialization

PostgreSQL Database directory appears to contain a database; Skipping initialization

[olympia]

It's not possible to tell from the log if the alpr database has created successfully or not.

go to postgres docker console and type:

1. psql -d postgres -U postgres -W
2. enter password
3. type: \dt

What do you get there?

[prsmith777]

psql -d postgres -U postgres -W

Password:
psql (13.18 (Debian 13.18-1.pgdg120+1))
Type "help" for help.

postgres=# \dt
Did not find any relations.
postgres=#

[olympia]

That's not OK. ALPR database is not there.

1. Stop postgres docker
2. delete everything from the data subdirectory of your postgres appdata directory.
3. start the docker again
4. try and post the result of the previous command in the console again.

[prsmith777]

followed those steps and getting same result:

postgres=# \dt
Did not find any relations.

[olympia]

Then probably something is not OK with your docker config, particularly the reference the the schema.sql.
Can you post a screenshot of the docker config?

[prsmith777]

[algertc]

3000 is not the right port. Notice that it says the database is listening on 5432. 3000 is for the app itself. You will want to set the database host to :5432 or if you exposed a different outside port for the database set it to that.

[prsmith777]

Changed the port.
Does this look right?

Still not working