Test Emails are working, but others emails are not coming through

Hello,

I have passbolt installed on my server and smtp is configured. I am able to send the test emails, but other emails are not coming through whether its a login email or any other.

Health Check command says error about “Passbolt is not configured to force SSL use”. Could it be the reason why emails are not coming through.

I am using Brevo smtp setup

------------------Below is the result of the HealthCheck command-----------------------------------------

 ____                  __          ____
/ __ \____  _____ ____/ /_  ____  / / /_

/ // / __ `/ / / __ / __ / / _/
/ / // ( |
) /
/ / /
/ / / /
/
/ _
,
/
//./_//__/

Open source password manager for teams

Healthcheck shell

Environment

[PASS] PHP version 8.1.2-1ubuntu2.18.
[PASS] PHP version is 8.1 or above.
[PASS] PCRE compiled with unicode support.
[PASS] Mbstring extension is installed.
[PASS] Intl extension is installed.
[PASS] GD or Imagick extension is installed.
[PASS] The temporary directory and its content are writable and not executable.
[PASS] The logs directory and its content are writable.

Config files

[PASS] The application config file is present
[PASS] The passbolt config file is present

Core config

[PASS] Cache is working.
[PASS] Debug mode is off.
[PASS] Unique value set for security.salt
[PASS] Full base url is set to https://access.academyofmusicandarts.org
[PASS] App.fullBaseUrl validation OK.
[PASS] /healthcheck/status is reachable.

SSL Certificate

[PASS] SSL peer certificate validates.
[PASS] Hostname is matching in SSL certificate.
[PASS] Not using a self-signed certificate.

SMTP settings

[PASS] The SMTP Settings plugin is enabled.
[PASS] SMTP Settings coherent. You may send a test email to validate them.
[PASS] The SMTP Settings source is: database.
[WARN] The SMTP Settings plugin endpoints are enabled.
[HELP] It is recommended to disable the plugin endpoints.
[HELP] Set the PASSBOLT_SECURITY_SMTP_SETTINGS_ENDPOINTS_DISABLED environment variable to true.
[HELP] Or set passbolt.security.smtpSettings.endpointsDisabled to true in /var/www/passbolt/config/passbolt.php.
[PASS] No custom SSL configuration for SMTP server.

JWT Authentication

[PASS] The JWT Authentication plugin is enabled.
[PASS] The /var/www/passbolt/config/jwt/ directory is not writable.
[PASS] A valid JWT key pair was found.

GPG Configuration

[PASS] PHP GPG Module is installed and loaded.
[PASS] The environment variable GNUPGHOME is set to /var/www/.gnupg.
[PASS] The directory /var/www/.gnupg containing the keyring is writable by the webserver user.
[PASS] The server OpenPGP key is not the default one.
[PASS] The public key file is defined in /var/www/passbolt/config/passbolt.php and readable.
[PASS] The private key file is defined in /var/www/passbolt/config/passbolt.php and readable.
[PASS] The server key fingerprint matches the one defined in /var/www/passbolt/config/passbolt.php.
[PASS] The server public key defined in the /var/www/passbolt/config/passbolt.php (or environment variables) is in the keyring.
[PASS] There is a valid email id defined for the server key.
[PASS] The public key can be used to encrypt a message.
[PASS] The private key can be used to sign a message.
[PASS] The public and private keys can be used to encrypt and sign a message.
[PASS] The private key can be used to decrypt a message.
[PASS] The private key can be used to decrypt and verify a message.
[PASS] The public key can be used to verify a signature.
[PASS] The server public key format is Gopengpg compatible.
[PASS] The server private key format is Gopengpg compatible.

Application configuration

[PASS] Using latest passbolt version (4.9.0).
[FAIL] Passbolt is not configured to force SSL use.
[HELP] Set passbolt.ssl.force to true in /var/www/passbolt/config/passbolt.php.
[PASS] App.fullBaseUrl is set to HTTPS.
[PASS] Selenium API endpoints are disabled.
[PASS] Search engine robots are told not to index content.
[INFO] The Self Registration plugin is enabled.
[INFO] Registration is closed, only administrators can add users.
[PASS] The deprecated self registration public setting was not found in /var/www/passbolt/config/passbolt.php.
[WARN] Host availability checking is disabled.
[HELP] Make sure this instance is not publicly available on the internet.
[HELP] Or set the PASSBOLT_EMAIL_VALIDATE_MX environment variable to true.
[HELP] Or set passbolt.email.validate.mx to true in /var/www/passbolt/config/passbolt.php.
[PASS] Serving the compiled version of the javascript app.
[WARN] Some email notifications are disabled by the administrator.
[PASS] The database schema is up to date.

Database

[PASS] The application is able to connect to the database
[PASS] 31 tables found.
[PASS] Some default content is present.

[FAIL] 1 error(s) found. Hang in there!

-------------------Result of the show queued email command---------------------------------------------

 ____                  __          ____
/ __ \____  _____ ____/ /_  ____  / / /_

/ // / __ `/ / / __ / __ / / _/
/ / // ( |
) /
/ / /
/ / / /
/
/ _
,
/
//./_//__/

Open source password manager for teams

List of queued emails:
No records found.

------------------------Result of Database Query for queued email------------------------------------------

mysql> select * from email_queue;
Empty set (0.00 sec)

mysql>

--------------------------------------Result of Cron command-----------------------------------------------------

● cron.service - Regular background program processing daemon
Loaded: loaded (/lib/systemd/system/cron.service; enabled; vendor preset: enabled)
Active: active (running) since Mon 2024-08-05 10:08:50 UTC; 1 day 21h ago
Docs: man:cron(8)
Main PID: 577 (cron)
Tasks: 1 (limit: 2188)
Memory: 1.5M
CPU: 5min 46.303s
CGroup: /system.slice/cron.service
└─577 /usr/sbin/cron -f -P

Aug 07 07:17:01 ubuntu CRON[58735]: pam_unix(cron:session): session closed for user www-data
Aug 07 07:18:01 ubuntu CRON[58756]: pam_unix(cron:session): session opened for user www-data(uid=33) by (uid=0)
Aug 07 07:18:01 ubuntu CRON[58757]: (www-data) CMD (/var/www/passbolt/bin/cron >> /var/log/passbolt.log)
Aug 07 07:18:02 ubuntu CRON[58756]: pam_unix(cron:session): session closed for user www-data
Aug 07 07:19:01 ubuntu CRON[58776]: pam_unix(cron:session): session opened for user www-data(uid=33) by (uid=0)
Aug 07 07:19:01 ubuntu CRON[58777]: (www-data) CMD (/var/www/passbolt/bin/cron >> /var/log/passbolt.log)
Aug 07 07:19:01 ubuntu CRON[58776]: pam_unix(cron:session): session closed for user www-data
Aug 07 07:20:01 ubuntu CRON[58793]: pam_unix(cron:session): session opened for user www-data(uid=33) by (uid=0)
Aug 07 07:20:01 ubuntu CRON[58794]: (www-data) CMD (/var/www/passbolt/bin/cron >> /var/log/passbolt.log)
Aug 07 07:20:01 ubuntu CRON[58793]: pam_unix(cron:session): session closed for user www-data

===============================================================

I have gone through every possible solution, but nothing seems to work now. Any guidance and help would be appreciated.
Let me know if you need any further details or any kind of logs.

Thanks!!

Hello @Testime1410, welcome to our community :slight_smile:

Could you try to clear the cache?

sudo -H -u www-data bash -c "/usr/share/php/passbolt/bin/cake cache clear_all"

Hii @antony , thanks for your reply, I already did that please see the below result. Also I have to modify the path of the command in order to run the command.

sudo -H -u www-data bash -c “/usr/share/php/passbolt/bin/cake cache clear_all”
bash: line 1: /usr/share/php/passbolt/bin/cake: No such file or directory
root@ubuntu:~# sudo -H -u www-data bash -c “/var/www/passbolt/bin/cake cache clear_all”
Clearing default
Cleared default cache
Clearing cake_core
Cleared cake_core cache
Clearing cake_model
Cleared cake_model cache

Still not able to receive any emails. I also setup the gmail smtp server and used that configuration in passbolt, but only test mail comes through.

Hello Everyone,

Can anyone help me in this, I am still not able to figure out what’s the issue.

Hey @Testime1410,

Can you try performing few actions like password edit, add new users, share password with another user, etc.? After performing these actions can you check email_queue table again (with the same query you mentioned)?

Also, what’s in the error logs? You can check logs using below command for debian related distros:

sudo su -s /bin/bash -c "tail -200 /var/log/passbolt/error.log" www-data

This would give us some insight on where things might be wrong.

Hello Ishan, Thanks for your replay,

I have performed the following actions

  1. First I ran the command in cli to generate the login link(since login email are not coming through).
  2. Used that link to login into my account
  3. Added new user(Normal user)
  4. Resent the invitation link to the user.

After the above task I ran the database query to show the email queue result. It only consists the two entries which was manually added by my(just for the testing purpose). Nothing new was entered inside the table.

Here is the result :

mysql> select * from email_queue;
±—±-----------------------±------------±--------------------±-------------------±--------±---------±--------±--------±-------±---------------------------------±--------±-----±-------±-----------±--------±--------------------±---------±------------±------+
| id | email | from_name | from_email | subject | config | template | layout | theme | format | template_vars | headers | sent | locked | send_tries | send_at | created | modified | attachments | error |
±—±-----------------------±------------±--------------------±-------------------±--------±---------±--------±--------±-------±---------------------------------±--------±-----±-------±-----------±--------±--------------------±---------±------------±------+
| 1 | testtime1410@gmail.com | Sender Name | test91172@gmail.com | Test Email Subject | default | default | default | default | both | {“content”:“Test email content”} | | 0 | 0 | 0 | NULL | 2024-08-08 07:07:50 | NULL | NULL | NULL |
| 1 | testtime1410@gmail.com | Sender Name | test91172@gmail.com | Test Email Subject | default | default | default | default | both | {“content”:“Test email content”} | | 0 | 0 | 0 | NULL | 2024-08-08 08:25:25 | NULL | NULL | NULL |
±—±-----------------------±------------±--------------------±-------------------±--------±---------±--------±--------±-------±---------------------------------±--------±-----±-------±-----------±--------±--------------------±---------±------------±------+
2 rows in set (0.00 sec)

Also I ran the this command "sudo -H -u www-data bash -c “/var/www/passbolt/bin/cake EmailQueue.sender” as well.

But the queue does not gets empty. Even the action which you mentioned to perform, does not generate the new entries in the table.

Also I ran your log command as well, but it does not work due the path issue, so I have to modify your command. Please see the result below :

root@ubuntu:~# sudo su -s /bin/bash -c “tail -200 /var/log/passbolt/error.log” www-data
tail: cannot open ‘/var/log/passbolt/error.log’ for reading: No such file or directory
root@ubuntu:~# sudo su -s /bin/bash -c “tail -200 /var/www/passbolt/logs/error.log” www-data
Request URL: /assets/index.esm.6e77cd8e.js
Client IP: 172.69.34.191
2024-08-05 05:27:07 error: [Cake\Routing\Exception\MissingRouteException] A route matching “/assets/content.4badd4fd.js” could not be found. in /var/www/passbolt/vendor/cakephp/cakephp/src/Routing/RouteCollection.php on line 248
Request URL: /assets/content.4badd4fd.js
Client IP: 162.158.186.182
2024-08-05 05:27:07 error: [Cake\Routing\Exception\MissingRouteException] A route matching “/assets/index.esm.6e77cd8e.js” could not be found. in /var/www/passbolt/vendor/cakephp/cakephp/src/Routing/RouteCollection.php on line 248
Request URL: /assets/index.esm.6e77cd8e.js
Client IP: 172.69.34.192
2024-08-05 05:27:07 error: [Cake\Routing\Exception\MissingRouteException] A route matching “/assets/storage.94f96ed3.js” could not be found. in /var/www/passbolt/vendor/cakephp/cakephp/src/Routing/RouteCollection.php on line 248
Request URL: /assets/storage.94f96ed3.js
Client IP: 172.70.211.215
2024-08-05 05:28:01 error: [Cake\Routing\Exception\MissingRouteException] A route matching “/assets/content.4badd4fd.js” could not be found. in /var/www/passbolt/vendor/cakephp/cakephp/src/Routing/RouteCollection.php on line 248
Request URL: /assets/content.4badd4fd.js
Client IP: 162.158.186.182
2024-08-05 05:28:01 error: [Cake\Routing\Exception\MissingRouteException] A route matching “/assets/index.esm.6e77cd8e.js” could not be found. in /var/www/passbolt/vendor/cakephp/cakephp/src/Routing/RouteCollection.php on line 248
Request URL: /assets/index.esm.6e77cd8e.js
Client IP: 172.69.34.191
2024-08-05 05:28:01 error: [Cake\Routing\Exception\MissingRouteException] A route matching “/assets/storage.94f96ed3.js” could not be found. in /var/www/passbolt/vendor/cakephp/cakephp/src/Routing/RouteCollection.php on line 248
Request URL: /assets/storage.94f96ed3.js
Client IP: 172.70.211.216
2024-08-05 05:28:57 error: [Cake\Http\Exception\NotFoundException] The resource does not exist. in /var/www/passbolt/src/Controller/Resources/ResourcesViewController.php on line 75
Request URL: /resources/cf163b74-6e14-40a2-aa02-fc85578b8582.json?api-version=v2&contain%5Bcreator%5D=1&contain%5Bmodifier%5D=1
Client IP: 172.70.207.100
2024-08-05 06:40:46 error: [LogicException] The “scriptTop” block was left open. Blocks are not allowed to cross files. in /var/www/passbolt/vendor/cakephp/cakephp/src/View/View.php on line 1197
Request URL: /auth/login?redirect=%2F&locale=en-UK
Client IP: 162.158.107.15
2024-08-06 05:28:08 error: [Cake\Http\Exception\ForbiddenException] Access restricted to administrators. in /var/www/passbolt/src/Controller/Component/UserComponent.php on line 242
Request URL: /healthcheck
Client IP: 172.71.81.169
2024-08-06 10:23:14 error: [Cake\Http\Exception\ForbiddenException] Access restricted to administrators. in /var/www/passbolt/src/Controller/Component/UserComponent.php on line 242
Request URL: /healthcheck
Client IP: 172.71.81.254
2024-08-06 10:27:37 error: [Cake\Http\Exception\NotFoundException] This user does not exist or has been deleted. Please contact your administrator. in /var/www/passbolt/src/Service/Users/UserRecoverService.php on line 203
Request URL: /users/recover.json?api-version=v2
Referer URL: Passbolt | Open source password manager for teams
Client IP: 172.71.124.228
2024-08-06 10:27:38 error: [Cake\Http\Exception\ForbiddenException] The self registration is disabled. in /var/www/passbolt/plugins/PassboltCe/SelfRegistration/src/Service/DryRun/SelfRegistrationEmailDomainsDryRunService.php on line 65
Request URL: /self-registration/dry-run.json?api-version=v2
Referer URL: Passbolt | Open source password manager for teams
Client IP: 172.71.124.228
2024-08-06 11:58:23 error: [Cake\Http\Exception\ForbiddenException] Only guests are allowed to proceed with account recovery. in /var/www/passbolt/src/Controller/Setup/RecoverStartController.php on line 59
Request URL: /setup/recover/36950443-f83b-41d1-88ce-16700f52f2a5/a95e03c4-e672-46bf-8f43-fd36a4b9276f.json?api-version=v2
Referer URL: Passbolt | Open source password manager for teams
Client IP: 162.158.148.154
2024-08-06 11:58:24 error: [Cake\Http\Exception\ForbiddenException] Only guests are allowed to proceed with account recovery. in /var/www/passbolt/src/Controller/Setup/RecoverStartController.php on line 59
Request URL: /setup/recover/start/36950443-f83b-41d1-88ce-16700f52f2a5/a95e03c4-e672-46bf-8f43-fd36a4b9276f.json?api-version=v2
Client IP: 172.71.134.95
2024-08-07 04:16:31 error: [Cake\Routing\Exception\MissingRouteException] A route matching “/assets/content.4badd4fd.js” could not be found. in /var/www/passbolt/vendor/cakephp/cakephp/src/Routing/RouteCollection.php on line 248
Request URL: /assets/content.4badd4fd.js
Client IP: 162.158.186.183
2024-08-07 04:16:31 error: [Cake\Routing\Exception\MissingRouteException] A route matching “/assets/index.esm.6e77cd8e.js” could not be found. in /var/www/passbolt/vendor/cakephp/cakephp/src/Routing/RouteCollection.php on line 248
Request URL: /assets/index.esm.6e77cd8e.js
Client IP: 172.69.34.192
2024-08-07 04:16:31 error: [Cake\Routing\Exception\MissingRouteException] A route matching “/assets/storage.94f96ed3.js” could not be found. in /var/www/passbolt/vendor/cakephp/cakephp/src/Routing/RouteCollection.php on line 248
Request URL: /assets/storage.94f96ed3.js
Client IP: 172.70.211.216
2024-08-07 08:15:26 error: [Cake\Routing\Exception\MissingRouteException] A route matching “/robots.txt” could not be found. in /var/www/passbolt/vendor/cakephp/cakephp/src/Routing/RouteCollection.php on line 248
Request URL: /robots.txt
Client IP: 172.71.190.22
2024-08-08 04:19:20 error: [Cake\Http\Exception\ForbiddenException] SMTP settings endpoints disabled. in /var/www/passbolt/plugins/PassboltCe/SmtpSettings/src/Middleware/SmtpSettingsSecurityMiddleware.php on line 41
Request URL: /smtp/settings.json?api-version=v2
Referer URL: Passbolt | Open source password manager for teams
Client IP: 162.158.106.165
2024-08-08 04:19:40 error: [Cake\Http\Exception\ForbiddenException] SMTP settings endpoints disabled. in /var/www/passbolt/plugins/PassboltCe/SmtpSettings/src/Middleware/SmtpSettingsSecurityMiddleware.php on line 41
Request URL: /smtp/settings.json?api-version=v2
Referer URL: Passbolt | Open source password manager for teams
Client IP: 162.158.106.164
2024-08-08 04:20:28 error: [Cake\Http\Exception\ForbiddenException] SMTP settings endpoints disabled. in /var/www/passbolt/plugins/PassboltCe/SmtpSettings/src/Middleware/SmtpSettingsSecurityMiddleware.php on line 41
Request URL: /smtp/settings.json?api-version=v2
Referer URL: Passbolt | Open source password manager for teams
Client IP: 162.158.106.165
2024-08-08 04:28:13 error: [Cake\Http\Exception\ForbiddenException] SMTP settings endpoints disabled. in /var/www/passbolt/plugins/PassboltCe/SmtpSettings/src/Middleware/SmtpSettingsSecurityMiddleware.php on line 41
Request URL: /smtp/settings.json?api-version=v2
Referer URL: Passbolt | Open source password manager for teams
Client IP: 162.158.106.165
2024-08-08 04:28:52 error: [Cake\Http\Exception\ForbiddenException] SMTP settings endpoints disabled. in /var/www/passbolt/plugins/PassboltCe/SmtpSettings/src/Middleware/SmtpSettingsSecurityMiddleware.php on line 41
Request URL: /smtp/settings.json?api-version=v2
Referer URL: Passbolt | Open source password manager for teams
Client IP: 162.158.106.165
2024-08-08 06:41:22 error: [PDOException] SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘to’ in ‘field list’ in /var/www/passbolt/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php on line 39
Request URL: /auth/login?redirect=%2F
Client IP: 172.70.189.83
2024-08-08 06:44:10 error: [PDOException] SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘to’ in ‘field list’ in /var/www/passbolt/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php on line 39
Request URL: /auth/login?redirect=%2F
Client IP: 172.70.189.83
2024-08-08 06:53:02 error: [PDOException] SQLSTATE[HY000]: General error: 1364 Field ‘id’ doesn’t have a default value in /var/www/passbolt/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php on line 39
Request URL: /auth/login?redirect=%2F
Client IP: 172.70.143.130
2024-08-08 06:53:55 error: [ParseError] syntax error, unexpected single-quoted string “email”, expecting “]” in /var/www/passbolt/src/Controller/Auth/AuthLoginController.php on line 66
Request URL: /auth/login?redirect=%2F
Client IP: 172.68.242.23
2024-08-08 06:55:22 error: [ParseError] syntax error, unexpected single-quoted string “email”, expecting “]” in /var/www/passbolt/src/Controller/Auth/AuthLoginController.php on line 66
Request URL: /auth/login
Referer URL: Passbolt | Open source password manager for teams
Client IP: 172.71.124.27
2024-08-08 06:56:01 error: [ParseError] syntax error, unexpected single-quoted string “email”, expecting “]” in /var/www/passbolt/src/Controller/Auth/AuthLoginController.php on line 66
Request URL: /auth/login
Referer URL: Passbolt | Open source password manager for teams
Client IP: 162.158.107.4
2024-08-08 06:56:06 error: [ParseError] syntax error, unexpected single-quoted string “email”, expecting “]” in /var/www/passbolt/src/Controller/Auth/AuthLoginController.php on line 61
Request URL: /auth/login
Referer URL: Passbolt | Open source password manager for teams
Client IP: 162.158.107.3
2024-08-08 06:56:13 error: [ParseError] syntax error, unexpected single-quoted string “email”, expecting “]” in /var/www/passbolt/src/Controller/Auth/AuthLoginController.php on line 61
Request URL: /auth/login?redirect=%2F
Referer URL: Passbolt | Open source password manager for teams
Client IP: 162.158.107.4
2024-08-08 06:57:00 error: [ParseError] syntax error, unexpected single-quoted string “email”, expecting “]” in /var/www/passbolt/src/Controller/Auth/AuthLoginController.php on line 66
Request URL: /auth/login?redirect=%2F
Client IP: 172.70.143.251
2024-08-08 06:57:03 error: [ParseError] syntax error, unexpected single-quoted string “email”, expecting “]” in /var/www/passbolt/src/Controller/Auth/AuthLoginController.php on line 66
Request URL: /auth/login?redirect=%2F
Client IP: 172.70.143.251
2024-08-08 06:57:04 error: [ParseError] syntax error, unexpected single-quoted string “email”, expecting “]” in /var/www/passbolt/src/Controller/Auth/AuthLoginController.php on line 66
Request URL: /auth/login?redirect=%2F
Client IP: 172.70.143.251
2024-08-08 07:02:38 error: [PDOException] SQLSTATE[HY000]: General error: 1364 Field ‘config’ doesn’t have a default value in /var/www/passbolt/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php on line 39
Request URL: /auth/login?redirect=%2F
Client IP: 172.70.92.190
2024-08-08 07:02:51 error: [PDOException] SQLSTATE[HY000]: General error: 1364 Field ‘config’ doesn’t have a default value in /var/www/passbolt/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php on line 39
Request URL: /auth/login?redirect=%2F
Client IP: 108.162.227.107
2024-08-08 07:03:26 error: [PDOException] SQLSTATE[HY000]: General error: 1364 Field ‘config’ doesn’t have a default value in /var/www/passbolt/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php on line 39
Request URL: /auth/login?redirect=%2F
Client IP: 172.70.147.64
2024-08-08 07:06:30 error: [PDOException] SQLSTATE[HY000]: General error: 1364 Field ‘id’ doesn’t have a default value in /var/www/passbolt/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php on line 39
Request URL: /auth/login?redirect=%2F
Client IP: 162.158.189.81
2024-08-08 09:44:25 error: [Error] Call to undefined method Cake\Mailer\Message::setTemplate() in /var/www/passbolt/vendor/cakephp/cakephp/src/Mailer/Email.php on line 158
Request URL: /auth/login?redirect=%2F
Client IP: 172.70.189.27
2024-08-08 09:46:57 error: [Cake\View\Exception\MissingTemplateException] Template file email/html/default.php could not be found.

The following paths were searched:

  • /var/www/passbolt/templates/email/html/default.php
  • /var/www/passbolt/vendor/cakephp/cakephp/templates/email/html/default.php
    in /var/www/passbolt/vendor/cakephp/cakephp/src/View/View.php on line 1419
    Exception Attributes: array (
    ‘file’ => ‘email/html/default.php’,
    ‘paths’ =>
    array (
    0 => ‘/var/www/passbolt/templates/’,
    1 => ‘/var/www/passbolt/vendor/cakephp/cakephp/templates/’,
    ),
    )
    Request URL: /auth/login?redirect=%2F
    Client IP: 172.70.142.35
    2024-08-08 09:52:57 error: [Cake\View\Exception\MissingTemplateException] Template file email/html/default.php could not be found.

The following paths were searched:

  • /var/www/passbolt/templates/email/html/default.php
  • /var/www/passbolt/vendor/cakephp/cakephp/templates/email/html/default.php
    in /var/www/passbolt/vendor/cakephp/cakephp/src/View/View.php on line 1419
    Exception Attributes: array (
    ‘file’ => ‘email/html/default.php’,
    ‘paths’ =>
    array (
    0 => ‘/var/www/passbolt/templates/’,
    1 => ‘/var/www/passbolt/vendor/cakephp/cakephp/templates/’,
    ),
    )
    Request URL: /auth/login?redirect=%2F
    Client IP: 172.71.82.83
    2024-08-08 09:53:46 warning: Undefined variable $title
    Request URL: /auth/login?redirect=%2F
    Client IP: 162.158.189.58
    2024-08-08 09:53:46 error: [BadMethodCallException] Transport was not defined. You must set on using setTransport() or set transport option in your mailer profile. in /var/www/passbolt/vendor/cakephp/cakephp/src/Mailer/Mailer.php on line 520
    Request URL: /auth/login?redirect=%2F
    Client IP: 162.158.189.58
    2024-08-08 09:55:10 warning: Undefined variable $title
    Request URL: /auth/login?redirect=%2F
    Client IP: 162.158.163.218
    2024-08-08 09:56:30 warning: Undefined variable $title
    Request URL: /auth/login?redirect=%2F&locale=en-UK
    Client IP: 172.71.124.229
    2024-08-08 20:20:08 error: [Cake\Routing\Exception\MissingRouteException] A route matching “/.well-known/acme-challenge/oB5_Si1zJW3Ex3s2P5oi8m2tzLb_bMZ-mZhgtBSzRPE” could not be found. in /var/www/passbolt/vendor/cakephp/cakephp/src/Routing/RouteCollection.php on line 248
    Request URL: /.well-known/acme-challenge/oB5_Si1zJW3Ex3s2P5oi8m2tzLb_bMZ-mZhgtBSzRPE
    Client IP: 162.158.244.147
    2024-08-08 20:27:50 error: [Cake\Routing\Exception\MissingRouteException] A route matching “/robots.txt” could not be found. in /var/www/passbolt/vendor/cakephp/cakephp/src/Routing/RouteCollection.php on line 248
    Request URL: /robots.txt
    Client IP: 172.71.81.184
    2024-08-08 23:13:51 error: [Cake\Routing\Exception\MissingRouteException] A route matching “/robots.txt” could not be found. in /var/www/passbolt/vendor/cakephp/cakephp/src/Routing/RouteCollection.php on line 248
    Request URL: /robots.txt
    Client IP: 108.162.227.119
    2024-08-09 01:44:41 error: [Cake\Routing\Exception\MissingRouteException] A route matching “/robots.txt” could not be found. in /var/www/passbolt/vendor/cakephp/cakephp/src/Routing/RouteCollection.php on line 248
    Request URL: /robots.txt
    Client IP: 162.158.189.172
    2024-08-09 04:13:12 error: [Cake\Routing\Exception\MissingRouteException] A route matching “/robots.txt” could not be found. in /var/www/passbolt/vendor/cakephp/cakephp/src/Routing/RouteCollection.php on line 248
    Request URL: /robots.txt
    Client IP: 172.70.188.59
    2024-08-09 10:24:27 error: [Cake\Database\Exception\NestedTransactionRollbackException] Cannot commit transaction - rollback() has been already called in the nested transaction in /var/www/passbolt/vendor/cakephp/cakephp/src/Database/Connection.php on line 768
    Request URL: /resources.json?api-version=v2&contain%5Bpermission%5D=1&contain%5Bfavorite%5D=1
    Client IP: 172.70.147.99
    2024-08-09 10:24:27 error: Cannot commit transaction - rollback() has been already called in the nested transaction
    2024-08-09 10:24:42 error: [Cake\Database\Exception\NestedTransactionRollbackException] Cannot commit transaction - rollback() has been already called in the nested transaction in /var/www/passbolt/vendor/cakephp/cakephp/src/Database/Connection.php on line 768
    Request URL: /resources.json?api-version=v2&contain%5Bpermission%5D=1&contain%5Bfavorite%5D=1
    Client IP: 172.70.147.98
    2024-08-09 10:24:42 error: Cannot commit transaction - rollback() has been already called in the nested transaction

Thanks

Wow, lots of errors!

Did you installed passbolt from source? If yes, I suggest you look at Update Passbolt from source | Passbolt documentation. link to update your passbolt instance. You have to make sure you don’t skip any steps otherwise it can be problematic.

did you set env var EMAIL_TRANSPORT_DEFAULT_CLIENT? It solved my similar issue

Hello @ishan ,

Thanks for your reply.
If I reinstall the passbolt on my server, Will it resolve the issue?

Hello @mmospanenko

I have not set the configuration through the .env file. The email configurations are stored in the database and also through an important file which is “passbolt.php”

How did you installed it right now? Is it from the source or some other way?

Also, if you reinstall you have to make sure you take a backup of your existing data, etc. Steps to migrate to new instance can vary depending on how you installed right now and where (i.e. debina, ubuntu, etc.) you want to install the new one? Refer to this Migrate to the package | Passbolt documentation. migration guide.

If you have small amount of passwords then it’s good to start fresh and create passwords manually on new passbolt instance.