Checklist
[+] I have read intro post: About the Installation Issues category
[+] I have read the tutorials, help and searched for similar issues
[+] I provide relevant information about my server (component names and versions, etc.)
[+] I provide a copy of my logs and healthcheck
[+] I describe the steps I have taken to trouble shoot the problem
[+] I describe the steps on how to reproduce the issue
I’m trying to install Passbolt on a new Ubuntu 20.04.3 VM created especially for this task.
I followed all the steps from this tutorial Passbolt Help | Install Passbolt CE on Ubuntu 20.04. The first odd thing is that at the end of the installation process, no progress bar is displayed. Instead, I only saw a circular indicator and text banners showing randomly above it. I waited 15 minutes and opened the site from another tab in my browser. The login form is displayed. I enter my admin email address and check the “accept terms” checkbox. The form says it is sending me a confirmation email, but my mailbox is empty.
I’ve repeated installation process twice, with same results.
Here is details:
root@passbolt:~# sudo su -s /bin/bash -c "/usr/share/php/passbolt/bin/cake passbolt healthcheck" www-data
____ __ ____
/ __ \____ _____ ____/ /_ ____ / / /_
/ /_/ / __ `/ ___/ ___/ __ \/ __ \/ / __/
/ ____/ /_/ (__ |__ ) /_/ / /_/ / / /
/_/ \__,_/____/____/_.___/\____/_/\__/
Open source password manager for teams
-------------------------------------------------------------------------------
Healthcheck shell
-------------------------------------------------------------------------------
Environment
[PASS] PHP version 7.4.3.
[PASS] PCRE compiled with unicode support.
[PASS] The temporary directory and its content are writable and not executable.
[PASS] The logs directory and its content are writable.
[PASS] GD or Imagick extension is installed.
[PASS] Intl extension is installed.
[PASS] Mbstring extension is installed.
Config files
[PASS] The application config file is present
[PASS] The passbolt config file is present
Core config
[PASS] Debug mode is off.
[PASS] Cache is working.
[PASS] Unique value set for security.salt
[PASS] Full base url is set to http://td-pb.xxxxx.ru
[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
Database
[PASS] The application is able to connect to the database
[PASS] 26 tables found
[PASS] Some default content is present
[PASS] The database schema up to date.
GPG Configuration
[PASS] PHP GPG Module is installed and loaded.
[PASS] The environment variable GNUPGHOME is set to /var/lib/passbolt/.gnupg.
[PASS] The directory /var/lib/passbolt/.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 config/passbolt.php and readable.
[PASS] The private key file is defined in config/passbolt.php and readable.
[PASS] The server key fingerprint matches the one defined in config/passbolt.php.
[PASS] The server public key defined in the 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.
Application configuration
[PASS] Using latest passbolt version (3.3.0).
[FAIL] Passbolt is not configured to force SSL use.
[HELP] Set passbolt.ssl.force to true in config/passbolt.php.
[FAIL] App.fullBaseUrl is not set to HTTPS.
[HELP] Check App.fullBaseUrl url scheme in config/passbolt.php.
[PASS] Selenium API endpoints are disabled.
[PASS] Search engine robots are told not to index content.
[PASS] Registration is closed, only administrators can add users.
[PASS] Serving the compiled version of the javascript app
[PASS] All email notifications will be sent.
JWT Authentication
[PASS] The JWT Authentication plugin is enabled
[PASS] The /etc/passbolt/jwt/ directory is not writable.
[PASS] A valid JWT key pair was found
[FAIL] 2 error(s) found. Hang in there!
root@passbolt:~# sudo su -s /bin/bash -c "/usr/share/php/passbolt/bin/cake EmailQueue.sender" www-data
Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'EmailQueue.to' in 'field list'
In [/usr/share/php/passbolt/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php, line 39]
root@passbolt:~# sudo -H -u www-data bash -c "/usr/share/php/passbolt/bin/cake passbolt send_test_email --recipient=radomanov@teleserv.ru"
____ __ ____
/ __ \____ _____ ____/ /_ ____ / / /_
/ /_/ / __ `/ ___/ ___/ __ \/ __ \/ / __/
/ ____/ /_/ (__ |__ ) /_/ / /_/ / / /
/_/ \__,_/____/____/_.___/\____/_/\__/
Open source password manager for teams
-------------------------------------------------------------------------------
Debug email shell
-------------------------------------------------------------------------------
Email configuration
-------------------------------------------------------------------------------
Host: ssl://smtp.yandex.ru
Port: 465
Username: xxxx@xxxx.ru
Password: *********
TLS: false
Sending email from: Passbolt Teleserv <td-passbolt@xxxx.ru>
Sending email to: xxxx@xxx.ru
-------------------------------------------------------------------------------
Trace
[220] myt6-9bdf92ffd111.qloud-c.yandex.net SMTP
> EHLO localhost
[250] myt6-9bdf92ffd111.qloud-c.yandex.net
[250] 8BITMIME
[250] PIPELINING
[250] SIZE 42991616
[250] STARTTLS
[250] AUTH LOGIN PLAIN XOAUTH2
[250] DSN
[250] ENHANCEDSTATUSCODES
> AUTH PLAIN AGFuZHJleUByYWRvbWFub3Yucn*****
[235] 2.7.0 Authentication successful. 1637682863-HcT4u5YPUF-sNwC9XBB
> MAIL FROM:<td-passbolt@xxxxxx.ru>
[250] Ok
> RCPT TO:<xxxxx@xxxx.ru>
[250] Recipient ok
> DATA
[354] Start mail input, end with <CRLF>.<CRLF>
> From: Passbolt Teleserv <td-passbolt@xxxx.ru>
To: xxx@xxxx.ru
Date: Tue, 23 Nov 2021 15:54:23 +0000
Message-ID: <8260023f10d74fc3af33e893d7938eca@passbolt>
Subject: Passbolt test email
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Congratulations!
If you receive this email, it means that your passbolt smtp configuration is working fine.
.
[250] 2.0.0 Ok: queued on myt6-9bdf92ffd111.qloud-c.yandex.net as 1637682863-HcT4u5YPUF-sNwCuH45
> QUIT
The message has been successfully sent!
This test email was recieved successfully.
What do I need to complete the installation process?