Errors during a fresh new installation

[pierrehaderer]

Environment :
Fresh new Debian 12.12
Additional packages required (installed with apt-get command) :

• git : to clone the code
• docker docker-compose cargo : to execute the command from the readme file

Problem :

1. 2. Missing prerequisites
2. Error during deployment, same as issue 37 : migration is broken because of sqlx compile time query checking #37

Workaround :

• Install missing dependencies
• Create database structure in advance

Details :
I trace here the difficulties I met during installation. In case it helps future users.

During the execution of the "cargo run" command, I met the following errors :

1. Error on pkg-config
   Command "pkg-config" not found
   I solved it by installing the package :
   pkg-config

2. Error on open-ssl

error: failed to run custom build command for `openssl-sys v0.9.66`
Caused by:
  process didn't exit successfully: `***/nettu-scheduler/scheduler/target/debug/build/openssl-sys-cfd43adaf687c59f/build-script-main` (exit status: 101)

I solved it by installing the packages :
openssl libssl-dev

3. Finally, Error on missing database elements :

Compiling nettu_scheduler_infra v0.1.0 (/home/pierre/projets/nettu-scheduler/scheduler/crates/infra)
error: error returned from database: relation "accounts" does not exist
  --> crates/infra/src/repos/account/postgres.rs:42:9

I solved it by installing the following package
postgresql-client-15

I then connected to the postgres database with the identifiers found in the configuration files.
I then selected the database with the postgres command "\c nettuscheduler"
And I ran both sql scripts found with the shell command find . -name "*.sql"

Hopefully, it wil help others to use the project.