I have this problem. When I configure Passbolt, it sends the verification email with test email option in web configuration, but then it doesn´t send the email when you loggin the first time to verify the email. I don´t know what It could be.
I have this in error.log but I don understand because I fill all the gaps in the form to configure it.
2022-04-07 06:58:19 Error: [Cake\Routing\Exception\MissingRouteException] A route matching “/auth” could not be found. in /usr/share/php/passbolt/vendor/cakephp/cakephp/src/Routing/RouteCollection.php on line 199
Request URL: /auth
Client IP: 192.168.x.x
2022-04-07 07:16:55 Error: [Cake\Http\Exception\NotFoundException] This user does not exist or has been deleted. Please contact your administrator. in /usr/share/php/passbolt/src/Service/Users//UserRecoverService.php on line 144
Request URL: /users/recover.json?api-version=v2
Referer URL: https://passbolt.krack360.com/auth/login?redirect=%2F&locale=en-UK
Client IP: 192.168.x.x
Provide your system information:
– Server operating system name and version
– Web server name and version
– Database server name and version
– Php version
– Passbolt version
I am using Ubuntu 20.04. Web Server is Nginx version 1.18. Database is MySQL version 8.0.28. Php version is php/focal,focal,now 2:7.4+75 all [instalado] and passbotl version is 3.5.0-1
4.
Comands on these step doesn’t work on my terminal.
`root@passbolt:/etc/passbolt/gpg# sudo su -s /bin/bash -c “./bin/cake passbolt install” www-data
bash: ./bin/cake: No existe el archivo o el directorio
root@passbolt:/etc/passbolt/gpg# sudo su -s /bin/bash -c “./bin/cake passbolt healthcheck” www-data
bash: ./bin/cake: No existe el archivo o el directorio
root@passbolt:/etc/passbolt/gpg# sudo /usr/share/php/passbolt/bin/status-report
____ __ ____
/ __ \____ _____ ____/ /_ ____ / / /_
/ /_/ / __ `/ ___/ ___/ __ \/ __ \/ / __/
/ ____/ /_/ (__ |__ ) /_/ / /_/ / / /
/_/ \__,_/____/____/_.___/\____/_/\__/
Open source password manager for teams
-------------------------------------------------------------------------------
Passbolt CE 3.5.0
Cakephp 4.2.9
Linux passbolt 5.13.0-39-generic #44~20.04.1-Ubuntu SMP Thu Mar 24 16:43:35 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux
PHP 7.4.3 (cli) (built: Mar 2 2022 15:36:52) ( NTS )
mysql Ver 8.0.28-0ubuntu0.20.04.3 for Linux on x86_64 ((Ubuntu))
gpg (GnuPG) 2.2.19
libgcrypt 1.8.5
ERROR: /usr/share/php/passbolt/bin/utils.sh: línea 64: composer: orden no encontrada
____ __ ____
/ __ \____ _____ ____/ /_ ____ / / /_
/ /_/ / __ `/ ___/ ___/ __ \/ __ \/ / __/
/ ____/ /_/ (__ |__ ) /_/ / /_/ / / /
/_/ \__,_/____/____/_.___/\____/_/\__/
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 https://passbolt.krack360.com
[PASS] App.fullBaseUrl validation OK.
[PASS] /healthcheck/status is reachable.
SSL Certificate
[PASS] SSL peer certificate validates
[PASS] Hostname is matching in SSL certificate.
[WARN] Using a self-signed certificate
[HELP] Check https://help.passbolt.com/faq/hosting/troubleshoot-ssl
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.
[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 (3.5.0).
[FAIL] Passbolt is not configured to force SSL use.
[HELP] Set passbolt.ssl.force to true in 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.
[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] 1 error(s) found. Hang in there!
____ __ ____
/ __ \____ _____ ____/ /_ ____ / / /_
/ /_/ / __ `/ ___/ ___/ __ \/ __ \/ / __/
/ ____/ /_/ (__ |__ ) /_/ / /_/ / / /
/_/ \__,_/____/____/_.___/\____/_/\__/
Open source password manager for teams
-------------------------------------------------------------------------------
Cleanup shell (dry-run)
-------------------------------------------------------------------------------
No issue found, data looks squeaky clean!
____ __ ____
/ __ \____ _____ ____/ /_ ____ / / /_
/ /_/ / __ `/ ___/ ___/ __ \/ __ \/ / __/
/ ____/ /_/ (__ |__ ) /_/ / /_/ / / /
/_/ \__,_/____/____/_.___/\____/_/\__/
Open source password manager for teams
-------------------------------------------------------------------------------
Data check shell
[PASS] Data integrity for AuthenticationTokens.
[PASS] Can validate: 3/3
[PASS] Data integrity for Comments.
[PASS] Can validate: 0/0
[PASS] Data integrity for Favorites.
[PASS] Can validate: 0/0
[PASS] Data integrity for Gpgkeys.
[PASS] Can encrypt: 0/0
[PASS] Can validate: 0/0
[PASS] Is not expired: 0/0
[PASS] Is armored key format valid: 0/0
[PASS] Is email unique: 0/0
[PASS] Data integrity for Groups.
[PASS] Can validate: 0/0
[PASS] Data integrity for Profiles.
[PASS] Can validate: 1/1
[PASS] Data integrity for Resources.
[PASS] Can validate: 0/0
[PASS] Data integrity for Secrets.
[PASS] Can validate: 0/0
[PASS] Data integrity for Users.
[PASS] Can validate: 1/1
2022-04-05 09:17:37 Warning: Warning (2): file_get_contents(/etc/passbolt/gpg/serverkey.asc): failed to open stream: No such file or directory in [/usr/share/php/passbolt/src/Utility/Healthchecks/GpgHealthchecks.php, line 457]
2022-04-05 09:17:37 Warning: Warning (2): file_get_contents(/etc/passbolt/gpg/serverkey_private.asc): failed to open stream: No such file or directory in [/usr/share/php/passbolt/src/Utility/Healthchecks/GpgHealthchecks.php, line 459]
2022-04-05 09:26:28 Warning: Warning (2): file_get_contents(/etc/passbolt/gpg/serverkey.asc): failed to open stream: No such file or directory in [/usr/share/php/passbolt/src/Utility/Healthchecks/GpgHealthchecks.php, line 457]
2022-04-05 09:26:28 Warning: Warning (2): file_get_contents(/etc/passbolt/gpg/serverkey_private.asc): failed to open stream: No such file or directory in [/usr/share/php/passbolt/src/Utility/Healthchecks/GpgHealthchecks.php, line 459]
2022-04-05 09:28:49 Warning: Warning (2): file_get_contents(/etc/passbolt/gpg/serverkey.asc): failed to open stream: No such file or directory in [/usr/share/php/passbolt/src/Utility/Healthchecks/GpgHealthchecks.php, line 457]
2022-04-05 09:28:49 Warning: Warning (2): file_get_contents(/etc/passbolt/gpg/serverkey_private.asc): failed to open stream: No such file or directory in [/usr/share/php/passbolt/src/Utility/Healthchecks/GpgHealthchecks.php, line 459]
2022-04-05 10:23:08 Warning: Warning (2): file_get_contents(/etc/passbolt/gpg/serverkey.asc): failed to open stream: No such file or directory in [/usr/share/php/passbolt/src/Utility/Healthchecks/GpgHealthchecks.php, line 457]
2022-04-05 10:23:08 Warning: Warning (2): file_get_contents(/etc/passbolt/gpg/serverkey_private.asc): failed to open stream: No such file or directory in [/usr/share/php/passbolt/src/Utility/Healthchecks/GpgHealthchecks.php, line 459]
2022-04-05 10:23:42 Warning: Warning (2): file_get_contents(/etc/passbolt/gpg/serverkey.asc): failed to open stream: No such file or directory in [/usr/share/php/passbolt/src/Utility/Healthchecks/GpgHealthchecks.php, line 457]
2022-04-05 10:23:42 Warning: Warning (2): file_get_contents(/etc/passbolt/gpg/serverkey_private.asc): failed to open stream: No such file or directory in [/usr/share/php/passbolt/src/Utility/Healthchecks/GpgHealthchecks.php, line 459]
2022-04-05 11:23:58 Warning: Warning (2): file_get_contents(/etc/passbolt/gpg/serverkey.asc): failed to open stream: No such file or directory in [/usr/share/php/passbolt/src/Utility/Healthchecks/GpgHealthchecks.php, line 457]
2022-04-05 11:23:58 Warning: Warning (2): file_get_contents(/etc/passbolt/gpg/serverkey_private.asc): failed to open stream: No such file or directory in [/usr/share/php/passbolt/src/Utility/Healthchecks/GpgHealthchecks.php, line 459]
2022-04-05 11:25:10 Warning: Warning (2): file_get_contents(/etc/passbolt/gpg/serverkey.asc): failed to open stream: No such file or directory in [/usr/share/php/passbolt/src/Utility/Healthchecks/GpgHealthchecks.php, line 457]
2022-04-05 11:25:10 Warning: Warning (2): file_get_contents(/etc/passbolt/gpg/serverkey_private.asc): failed to open stream: No such file or directory in [/usr/share/php/passbolt/src/Utility/Healthchecks/GpgHealthchecks.php, line 459]
2022-04-08 06:26:13 Warning: Warning (2): file_get_contents(/etc/passbolt/gpg/serverkey.asc): failed to open stream: No such file or directory in [/usr/share/php/passbolt/src/Utility/Healthchecks/GpgHealthchecks.php, line 457]
2022-04-08 06:26:13 Warning: Warning (2): file_get_contents(/etc/passbolt/gpg/serverkey_private.asc): failed to open stream: No such file or directory in [/usr/share/php/passbolt/src/Utility/Healthchecks/GpgHealthchecks.php, line 459]
2022-04-08 06:31:43 Error: [Cake\Routing\Exception\MissingRouteException] A route matching "/img/controls/chevron-down_blue.svg" could not be found. in /usr/share/php/passbolt/vendor/cakephp/cakephp/src/Routing/RouteCollection.php on line 199
Request URL: /img/controls/chevron-down_blue.svg
Referer URL: https://passbolt.krack360.com/css/themes/default/api_webinstaller.min.css?v=3.5.0
Client IP: 192.168.0.157
2022-04-08 06:39:00 Warning: Warning (2): chmod(): Operation not permitted in [/usr/share/php/passbolt/plugins/Passbolt/WebInstaller/src/Utility/WebInstaller.php, line 290]
2022-04-08 06:39:00 Warning: Warning (2): chmod(): Operation not permitted in [/usr/share/php/passbolt/plugins/Passbolt/WebInstaller/src/Utility/WebInstaller.php, line 290]
2022-04-08 06:39:00 Warning: Warning (2): chmod(): Operation not permitted in [/usr/share/php/passbolt/plugins/Passbolt/WebInstaller/src/Utility/WebInstaller.php, line 290]
2022-04-08 06:39:00 Warning: Warning (2): chmod(): Operation not permitted in [/usr/share/php/passbolt/plugins/Passbolt/WebInstaller/src/Utility/WebInstaller.php, line 290]
2022-04-08 06:39:00 Warning: Warning (2): chmod(): Operation not permitted in [/usr/share/php/passbolt/plugins/Passbolt/WebInstaller/src/Utility/WebInstaller.php, line 290]
2022-04-08 06:39:37 Error: [Cake\Routing\Exception\MissingRouteException] A route matching "/auth" could not be found. in /usr/share/php/passbolt/vendor/cakephp/cakephp/src/Routing/RouteCollection.php on line 199
Request URL: /auth
Client IP: 192.168.0.157
I think I have some problems in cron and in /etc/passbolt/gpg rights because I don´t have the same as your´s. This is the result of these comands you mentioned.
root@passbolt:~# journalctl -fu cron
-- Logs begin at Tue 2022-04-05 10:48:55 CEST. --
abr 08 10:23:02 passbolt CRON[110874]: (CRON) info (No MTA installed, discarding output)
abr 08 10:23:02 passbolt CRON[110874]: pam_unix(cron:session): session closed for user www-data
abr 08 10:24:01 passbolt CRON[110903]: pam_unix(cron:session): session opened for user www-data by (uid=0)
abr 08 10:24:01 passbolt CRON[110904]: (www-data) CMD ($PASSBOLT_BASE_DIR/bin/cron)
abr 08 10:24:01 passbolt CRON[110903]: (CRON) info (No MTA installed, discarding output)
abr 08 10:24:01 passbolt CRON[110903]: pam_unix(cron:session): session closed for user www-data
abr 08 10:25:01 passbolt CRON[111004]: pam_unix(cron:session): session opened for user www-data by (uid=0)
abr 08 10:25:01 passbolt CRON[111005]: (www-data) CMD ($PASSBOLT_BASE_DIR/bin/cron)
abr 08 10:25:01 passbolt CRON[111004]: (CRON) info (No MTA installed, discarding output)
abr 08 10:25:01 passbolt CRON[111004]: pam_unix(cron:session): session closed for user www-data
abr 08 10:26:01 passbolt CRON[111034]: pam_unix(cron:session): session opened for user www-data by (uid=0)
abr 08 10:26:01 passbolt CRON[111035]: (www-data) CMD ($PASSBOLT_BASE_DIR/bin/cron)
abr 08 10:26:02 passbolt CRON[111034]: (CRON) info (No MTA installed, discarding output)
abr 08 10:26:02 passbolt CRON[111034]: pam_unix(cron:session): session closed for user www-data
abr 08 10:27:01 passbolt CRON[111064]: pam_unix(cron:session): session opened for user www-data by (uid=0)
abr 08 10:27:01 passbolt CRON[111065]: (www-data) CMD ($PASSBOLT_BASE_DIR/bin/cron)
abr 08 10:27:01 passbolt CRON[111064]: (CRON) info (No MTA installed, discarding output)
abr 08 10:27:01 passbolt CRON[111064]: pam_unix(cron:session): session closed for user www-data
^C
root@passbolt:/etc/passbolt/gpg# ls -lisa
total 16
1582673 4 drwxrwx--- 2 root www-data 4096 abr 8 08:35 .
1582607 4 drwxrwx--- 7 root www-data 4096 abr 8 09:34 ..
1583111 4 -rw-rw---- 1 root www-data 1783 abr 8 08:35 serverkey.asc
1583125 4 -rw-rw---- 1 root www-data 3579 abr 8 08:35 serverkey_private.asc
root@passbolt:/etc/passbolt/gpg# sudo -H -u www-data bash -c "/usr/share/php/passbolt/bin/cake passbolt send_test_email --recipient=adrian.freijeiro@krack.es"
____ __ ____
/ __ \____ _____ ____/ /_ ____ / / /_
/ /_/ / __ `/ ___/ ___/ __ \/ __ \/ / __/
/ ____/ /_/ (__ |__ ) /_/ / /_/ / / /
/_/ \__,_/____/____/_.___/\____/_/\__/
Open source password manager for teams
-------------------------------------------------------------------------------
Debug email shell
-------------------------------------------------------------------------------
Email configuration
-------------------------------------------------------------------------------
Host: smtp.office365.com
Port: 587
Username: adrian.freijeiro@krack.es
Password: *********
TLS: true
Sending email from: Passbolt Administrator <adrian.freijeiro@krack.es>
Sending email to: adrian.freijeiro@krack.es
-------------------------------------------------------------------------------
Trace
[220] LO4P265CA0078.outlook.office365.com Microsoft ESMTP MAIL Service ready at Fri, 8 Apr 2022 08:26:51 +0000
> EHLO localhost
[250] LO4P265CA0078.outlook.office365.com Hello [212.170.195.6]
[250] SIZE 157286400
[250] PIPELINING
[250] DSN
[250] ENHANCEDSTATUSCODES
[250] STARTTLS
[250] 8BITMIME
[250] BINARYMIME
[250] CHUNKING
[250] SMTPUTF8
> STARTTLS
[220] 2.0.0 SMTP server ready
> EHLO localhost
[250] LO4P265CA0078.outlook.office365.com Hello [212.170.195.6]
[250] SIZE 157286400
[250] PIPELINING
[250] DSN
[250] ENHANCEDSTATUSCODES
[250] AUTH LOGIN XOAUTH2
[250] 8BITMIME
[250] BINARYMIME
[250] CHUNKING
[250] SMTPUTF8
> AUTH PLAIN AGFkcmlhbi5mcmVpamVpcm9Aa3JhY2suZXMA*****
[504] 5.7.4 Unrecognized authentication type [LO4P265CA0078.GBRP265.PROD.OUTLOOK.COM]
> AUTH LOGIN
[334] VXNlcm5hbWU6
> *****
[334] UGFzc3dvcmQ6
> *****
[235] 2.7.0 Authentication successful
> MAIL FROM:<*****>
[250] 2.1.0 Sender OK
> RCPT TO:<*****>
[250] 2.1.5 Recipient OK
> DATA
[354] Start mail input; end with <CRLF>.<CRLF>
> From: Passbolt Administrator <*****>
To: *****
Date: Fri, 08 Apr 2022 08:26:58 +0000
Message-ID: <397e5a51b1214ff181be92432e629a2f@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 <397e5a51b1214ff181be92432e629a2f@passbolt> [Hostname=AM7P190MB0680.EURP190.PROD.OUTLOOK.COM]
> QUIT
The message has been successfully sent!
root@passbolt:/etc/passbolt/gpg# sudo -H -u www-data bash -c "/usr/share/php/passbolt/bin/cron"
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]
My problem isn´t with test email because It arrives. It is on the final verification email. And I don´t know so much from Linux. Could you tell me the comands to change directory permissions on /Etc/passbolt/gpg ?. Thank you
Hi I was editing /etc/passbolt/passbolt.php and I only changed this email, and now it doesn’t send the email verification to the new users I add. Must I have to do something special When I edit that file ? Because I can’t do systemctl restart passbolt and that comand of cache doesn’t fix the problem
'Email' => [
'default' => [
// Defines the default name and email of the sender of the emails.
'from' => ['admin@passbolt.com' => 'Passbolt Administrator']
],
],
I have another query to answer. I have 1 group on my passbolt server. But I can´t do SELECT * FROM groups; on MySQL.
It takes an error. Howeever from my SQL editor I can see the information about these table. I don´t Know Which is the problem