New install sql errors

[mark1million]

Hi I have a brand new install in windows, and im getting the following errors regarding the database with no data at all.

Issues Identified from Logs:
PostgreSQL Failing to Start Initially

The error /var/run/postgresql:5432 - no response suggests that PostgreSQL wasn't responding initially.
Later logs confirm that the database eventually started, but it may have required multiple restart attempts.
Relation "devmgmt" Does Not Exist

ERROR: relation "devmgmt" does not exist at character 13
This suggests that a table named devmgmt is missing but is referenced in SQL queries.
It appears that the migration scripts assume the table exists but it was either not created or deleted.
Role "root" Does Not Exist

FATAL: role "root" does not exist
The database is likely expecting a root user that has not been created.
PostgreSQL typically does not use root; it uses postgres by default.
If your application is trying to connect as root, update the credentials or create the user:

Column Value Too Long

ERROR: value too long for type character varying(10)
The error suggests that a value being inserted into a VARCHAR(10) column is longer than 10 characters.
The affected column is plate_number in the plates table.

Any help in resolving these issues would be appreciated.

Regards,
Mark.

[algertc]

Did you use the included install script? This looks like you're either missing the schema or migrations file.

[mark1million]

Hi, yes i followed the windows installer post from the repo.

Windows
Create a new directory wherever you would like to store your ALPR data. Open PowerShell with administrator priveleges and cd into your new install directory.

Paste in the below commands. After that, everything will be set up automatically!

Set-ExecutionPolicy RemoteSigned
irm https://raw.githubusercontent.com/algertc/ALPR-Database/main/install.ps1 | iex

[algertc]

Ok, please open your file explorer and check that all the files are there. That error is suggesting that either the schema.sql or migrations.sql (or both) are missing. These are the files that tell the database how to format itself so that the application can interact with it. The error saying that the "relation does not exist" means that one of both of these files did not exist when the code attempted to use them to set up your database. The install script usually works without issue. I, and others, have tested it on multiple operating systems.

My first recommendation, after checking to see if the files did not download properly, would be to delete your original install directory and try it again. You can also open the schema and migrations files in a text editor and make sure they look like SQL and not a web page. Sometimes users mistakenly curl a whole HTML web page instead of the raw file. The install script shouldn't have this issue though.

If that still does not work, I would try the manual install instructions.

I am going to create updated installation guide videos soon for both windows and linux. If you do happen to try the manual install (which shouldn't be necessary), here is an old install guide from an earlier release of the project before the install and update scripts existed.

[mark1million]

Thank you, I will have a look at this tomrrow.

This is a great addition for BI, thank you for your support and time developing this.

[mark1million]

I must be doing something wrong somewhere. Im still having problems getting the database working, I have tried installing on ubuntu22.04 and also a full reinstall in windows, both installs are the same issues.

I have images going in to the storage directories but the ui is completley blank.

I have removed docker and removed the database to pull a fresh, but still the same blank dashboard.

Im now stuck, any help would be greatly appreciated.

Kind regards,
Mark.