Automated/unattended install

[Keeper-of-the-Keys]

Hey Ante,

I'm working on automating the installation of Viesti-Reports with ansible, but have some questions:

1. Can I just generate a random string for APP_SECRET in .env.local or is more happening under the hood?
2. Initial user creation I can probably just handle as an insert query in users

Additionally (and if you prefer I re-open this as a separate issue I totally understand!) - it seems that doctrine:migrations is ignoring the fact that I am using mariadb and tries to run the sqlite migrations and thus fails, this applies both to web ui and command line.

This is the relevant variable from .env.local (generated through the webui):
DATABASE_URL="mysql://vtest:REDACTED@localhost:3306/vtest?serverVersion=10.11.6-MariaDB-0+deb12u1"

This is the command I have tried to run:
php bin/console doctrine:migrations:migrate -q

Hoe dan ook heel erg bedankt voor dit mooie project.

[Keeper-of-the-Keys]

Another note - in the webui when migrations fail there is no feedback to the user, it just goes back to the same screen.

I checked out main it could be that I am not on a "stable" version as a result.

// Edit - nvm:

smtp-test:~/test/Viesti-Reports$ git status
HEAD detached at v1.22.4

[Keeper-of-the-Keys]

I was able to "work around" this issue by removing migrations/sqlite and creating a symlink sqlite > mysql, I'm not so familiar with symfony so I'm not sure where to look but it seems that there is something wrong in the db migrations selection logic.

[Keeper-of-the-Keys]

I did some more digging today -
First I found that it seems that if I run update.sh again after the setup creates .env.local migrations succeed.

After more digging what I found is that php bin/console cache:clear needs to be run first.

I'll submit a PR with an updated README.md

[Keeper-of-the-Keys]

I hope you don't mind me going all over the place like this -

Since DATABASE_URL in .env.local also contains the database version is there any mechanism that manages/updates that when the OS of the underlying server is updated? How important is it?

[antedebaas]

I don’t mind at all :)

In the end it’s a symfony caching issue. The whole setup has been a bit of a hack anyway.
So I’m gonna think on how to fix this :)