HELP - Can't get email to working

MWAzone · February 1, 2024, 12:01am

I’m fighting a little bit with getting everything working now that the new year has entered and i have been calling many of my clients (more then would be normal) to remind them to pay us for the last years services or we will close there services -only for them all telling us that they have never received any invoice from us to pay… Then debugging on this I’m now at a point where I’m stuck and don’t know what to look for now or missing.

I’m running v5.8.20-W151 with docker-compose and have set the following ENV in the docker-compose:

MAIL_MAILER=log
MAIL_HOST=domain-tld.mail.protection.outlook.com
MAIL_PORT=25
MAIL_USERNAME=
MAIL_PASSWORD=
MAIL_ENCRYPTION=tls
[email protected]
[email protected]

FYI: the above SMTP details in the config works (both from our copier/scanners and other containers on the same docker environment).

In the REACT and Flutter is just gives me an success messages with sent/queued but there is not getting anything in the mail-trace when I’m looking on my tenant at Microsoft365 nor is there anything in the laravel.log or invoiceninja.log and my “Systems Log” on the dashboard is empty.

What can I do here ??? cron and queue is not something i need to run in the docker-compose as I’m understanding in the documentation and notes in the compose mentioning that it’s only for v4 the cron service. Or am I’m missing something here?

hillel · February 1, 2024, 6:04am

Hi,

Are there any errors in the system_log table?

MWAzone · February 1, 2024, 8:13am

Nope only 1 payment gateway failure with GoCardLess that I have made testing that service.

hillel · February 1, 2024, 8:15am

What is QUEUE_CONNECTION set to? It may help to try setting it to sync to disabled the queue.

MWAzone · February 1, 2024, 8:29am

Hi it’s done all as per the github docker-compose and env file (but added the needed service keys).

github.com

invoiceninja/dockerfiles/blob/master/env

# IN application vars
APP_URL=http://in.localhost:8003
APP_KEY=<insert your generated key in here>
APP_DEBUG=true
REQUIRE_HTTPS=false
PHANTOMJS_PDF_GENERATION=false
PDF_GENERATOR=snappdf
TRUSTED_PROXIES='*'


QUEUE_CONNECTION=database

# DB connection
DB_HOST=db
DB_PORT=3306
DB_DATABASE=ninja
DB_USERNAME=ninja
DB_PASSWORD=ninja

# Create initial user

This file has been truncated. show original

but it’s: QUEUE_CONNECTION=database

hillel · February 1, 2024, 8:32am

Are there any pending jobs in the jobs table or errors in the failed_jobs table?

Also, I suggest testing with sync.

MWAzone · February 1, 2024, 8:44am

Not sure what i see here in the Jobs table but yes there is 742 records in it.

Before testing with sync will it send 700+ mails or do I need to delete the jobs table or how do this work?

hillel · February 1, 2024, 8:49am

It looks like the queue isn’t running, this should work out of the box with the official dockerfile. Changing to sync will correct this but will cause a delay in the app since it will wait to send.

MWAzone · February 1, 2024, 8:52am

Okay, where is the jobs database table executed from within the database image/service or the ninja image/service of the docker-compose?

Also before changing to sync what will that do (do i need to delete all in the jobs table) because I have resent a lot and don’t what to spam clients

hillel · February 1, 2024, 9:02am

@david can you please advise?

MWAzone · February 15, 2024, 4:36pm

I’m not sure I’m getting where is the service/script/code that is responsible for the job queue in the database?

Would really like to get this fixed as it’s verry slow to use the sync… But also need clients to get there invoices - to get paid…

hillel · February 15, 2024, 4:45pm

I believe this is where it’s defined

github.com

invoiceninja/dockerfiles/blob/master/examples/v5/supervisor/supervisord.conf#L23


      
          stderr_logfile_maxbytes=0
          command=php-fpm
          
          
[program:scheduler]
          stdout_logfile=/dev/stdout
          stdout_logfile_maxbytes=0
          stderr_logfile=/dev/stderr
          stderr_logfile_maxbytes=0
          command=php artisan schedule:work
          
          
[program:queue-worker]
          stdout_logfile=/dev/stdout
          stdout_logfile_maxbytes=0
          stderr_logfile=/dev/stderr
          stderr_logfile_maxbytes=0
          numprocs=2
          command=php artisan queue:work --sleep=3 --tries=1 --memory=1024 --timeout=3600 --daemon

MWAzone · February 15, 2024, 4:53pm

Hmm okay that was also the files i was look at, is it correct that they are contained/running within the Invoiceninja “app” service of the compose?

Because I can’t seam to get it to execute the queue… have tried to exec into the service and run the following command from the cronjob_v5.sh manual without any lock.

I’m using Maria10.4 and not MySQL8 don’t know it that really should give this issue.

also all jobs have 1 attempt so and no error/failed log - so where to see the result of the 1 init attempt

hillel · February 15, 2024, 5:03pm

If the job is failing there should be more info in the failed_jobs table.

MWAzone · February 16, 2024, 7:36am

Only have 2 “old” jobs in failed_jobs regarding the ziptax so not related.

MWAzone · March 30, 2024, 2:44pm

Deleted smtp settings from .env and setup the smtp withing settings in the Invoiceninja app and then all worked as it should.

sone · June 14, 2024, 6:10am

Can anyone confirm where is the correct place to put the SMTP values? The email settings UI or the .env file?

MWAzone · June 14, 2024, 6:40am

Hi there @sone
I believe to have read somewhere (GH or here) that ENV are legacy / EOL and that UI Settings will be the correct way in the future.
But personally running with docker-compose, I still have settings in the ENV of the compose, and in the UI - But I had some problems when it first was implemented in the UI with settings from ENV not working - and today I have configured both.

UPDATE: as @hillel says below

hillel · June 14, 2024, 6:40am

Hi,

You can configure your SMTP credentials on Settings > Email Settings.

.env is the old method, settings is the new method.

sone · June 14, 2024, 7:52am

So I commented out the mail settings in the .env files and already had the settings in the UI. The test email feature now works but trying to send an email from an invoice still does not despite the notice saying its been queue to be sent. I see nothing in the jobs table and nothing in the system_logs table.

What else can I check to find the problem?

Also can someone outline how the whole process works so I can try and figure this out?

When we try and send an email from an invoice does this happen?

PDF is generated and attached to email
Email is sent to job table?
Cron picks this up? Is this the php artisan schedule:run command?