No sending mail (send_tries = 0)

[jeanphilippe]

Hello,

I installed passbolt 2.4.0 on a Debian 9 with the installation script. Everything works except sending mail.

The mail test works:
/var/www/passbolt/bin/cake passbolt send_test_email --recipient=XXX@toto.com
“The message has been successfully sent!”

But the mails are not sent :

MariaDB [passbolt]> SELECT id,subject,sent,send_tries FROM email_queue;
±—±-----------------------------------------±-----±-----------+
| id | subject | sent | send_tries |
±—±-----------------------------------------±-----±-----------+
| 1 | Welcome to passbolt, YYYY! | 0 | 0 |
| 2 | You added the password XXXX | 0 | 0 |
| 3 | Welcome to passbolt, XXXX! | 0 | 0 |

I have an error :

root@toto:/var/www/passbolt# /var/www/passbolt/bin/cake EmailQueue.sender
Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘EmailQueue.to’ in ‘field list’ in [/var/www/passbolt/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php, line 39]

How can i debug this ?

[remy]

Did you install from scratch or did you update from v1?
There was a similar issue a few months back, where the solution was:

• clear your composer cache
  composer clear-cache
• clear cakephp cache
  ./bin/cake cache clear_all
• delete the content of /vendor
  rm -rf vendor
• run composer install again
  composer install

[jeanphilippe]

Thank you it works.

It’s an install from scratch but during the install, there was a rule forbidding access to the SMTP server and I think that’s why there was a problem.