Failed to authenticate on SMTP server with username using 2 possible authenticators

[danielloader]

So no matter how I try to set up SMTP with invoice ninja it causes the application to error and SQL database seems to disconnect, only reconnecting on stopping and restarting the docker-compose stack.

So having set up mailgun and tested SMTP via the terminal outlined below:

As far as I can tell sending email via SMTP works in this setup.

http://127.0.0.1/setup

Initial setup page filled in with correct details

Basic test invoice setup to send

Error given when you click send email

http://127.0.0.1/settings/system_settings

Database connection still shows successful.

Email settings missing 'From Name' and 'Password' field is empty despite database connection settings showing the dots.

Re enter the correct SMTP settings and click save.

http://127.0.0.1/update_setup

Error shown

http://127.0.0.1/setup

Trying to navigate to any page redirects to initial setup page indicating the database connection is denied (same reported in stdout from docker-compose attached)

Obviously it should using user rootand password mdp but for some reason it resets.

docker-compose up.txt

Filling in the setup yields nothing even though the database connection shows success if you change the credentials back. At this point I'm stuck and can't do anything with invoiceninja.

[hillelcoren]

It looks like there may be a bug with the system settings page.

I'll look into it but for now I'd suggest manually changing the settings in the .env file.

[danielloader]

Yeah guess I'll have to volume mount ./.env:/var/www/app/.env then? It'll break the entry point script that inserts

echo "DB_USERNAME=$DB_USERNAME" >> .env
echo "DB_PASSWORD=$DB_PASSWORD" >> .env

Edit: It injects them fine if it's mounted rw not ro though it injects repeatedly into the same .env if you keep bringing docker-compose down and up again as you'd expect.

On the bright side...

It both sent an email to invoice@domain declaring it'd been issued and sent it to my personal gmail to issue the invoice.

So I imagine it's a entrypoint.sh issue or the setup php itself writing the config since normally the .env is inside the docker container completely isolated from the user.