I know this sounds super basic but I'm trying to figure out how these services work together. I've watched both series on forge and envoyer - they've really helped alot.
Wish there was a bridge video series that shows how to use them both. Envoyer is now at all green lights which is great (just fantastic).
Do we have to install the git repository on Forge? Or is it Envoyer that pushes this? (this is where the lines of which service does what is not clear to me)
I've run into this issue when trying to install the repo on Forge:
SQLSTATE[HY000]  Access denied for user 'forge'@'localhost' (using password: NO) (SQL: select * from information_schema.tables where table_schema = forge and table_name = permissions and table_type = 'BASE TABLE')
What's strange is the .env in Envoyer should deploy the variables. The server status shows green and when refreshed stays that way. This seems like all public keys, etc are in good working condition...
In order to get this to work in CI I used these scripts:
mysql $DB_DATABASE < database/insert_roles.sql mysql $DB_DATABASE < database/insert_permissions.sql mysql $DB_DATABASE < database/insert_permission_role.sql mysql $DB_DATABASE < database/insert_role_user.sql
Should these be a recipe on Forge or a Deployment Hook on Envoyer?
Or is there some other reason the code deployed from Envoyer has not made it to the server?
Thank you `