[resolved] Install from scrash didn t finish after 2 hours

Installation Issues
1

Checklist
[x] I have read intro post: about-the-installation-issues-category/12
i found : unknown-column-emailqueue-to-in-field-list/577 but on my case it s a new install
[x] I have read the tutorials, help and searched for similar issues
https://help.passbolt.com/hosting/install/ce/debian-9-stretch.html
[x] I provide relevant information about my server (component names and versions, etc.)
=> debian :
=>cat /etc/debian_version
9.8
=> remote mariadb
ii mariadb-client-core-10.1 1:10.1.37-3 amd64 MariaDB database core client binaries
ii mariadb-server-10.1 1:10.1.37-3 amd64 MariaDB database server binaries
ii mariadb-server-core-10.1 1:10.1.37-3 amd64 MariaDB database core server files

=> using : passbolt_ce_debian_installer.sh script for the install
script install all componant without error (php, nginx,…) except mariadb server (using a remote server) on my LAN no connection issue

=> passbolt version : 2.7.1

[x] I provide a copy of my logs and healthcheck
=>su -c “bin/cake passbolt healthcheck” www-data

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

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

Open source password manager for teams

Healthcheck shell

Environment

[PASS] PHP version 7.0.33-0+deb9u1.
[PASS] PCRE compiled with unicode support.
[PASS] The temporary directory and its content are writable.
[PASS] The public image directory and its content are writable.
[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://vault.pra.rip
[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] 18 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 /home/www-data/.gnupg.
[PASS] The directory /home/www-data/.gnupg containing the keyring is writable by the webserver user.
[PASS] The server gpg 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 is in the keyring.
[FAIL] The server key does not have a valid email id.
[HELP] Edit or generate another key with a valid email id.
[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 (2.7.1).
[PASS] Passbolt is configured to force SSL use.
[PASS] App.fullBaseUrl is set to HTTPS.
[PASS] Selenium API endpoints are disabled.
[PASS] Search engine robots are told not to index content.
[WARN] Registration is open to everyone.
[HELP] Make sure this instance is not publicly available on the internet.
[HELP] Or set passbolt.registration.public to false in config/passbolt.php.
[PASS] Serving the compiled version of the javascript app
[PASS] All email notifications will be sent.

1 error(s) found. Hang in there!
[x] I describe the steps I have taken to trouble shoot the problem
install still running :

S%C3%A9lection_380
Sélection_380.png1284×530 24.6 KB
from several hours
in my mailbox for cron i have :
Cron www-data@vault /var/www/passbolt/bin/cake EmailQueue.sender
with the error :
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]

the install done with an empty db , the application didn t create the db (create database vault)

my db :
MariaDB [vault]> show tables;
±-----------------------------+
| Tables_in_vault |
±-----------------------------+
| authentication_tokens |
| burzum_file_storage_phinxlog |
| comments |
| email_queue |
| email_queue_phinxlog |
| favorites |
| file_storage |
| gpgkeys |
| groups |
| groups_users |
| permissions |
| phinxlog |
| profiles |
| resources |
| roles |
| secrets |
| user_agents |
| users |
±-----------------------------+

MariaDB [vault]> describe email_queue;
±--------------±-------------±-----±----±--------±---------------+
| Field | Type | Null | Key | Default | Extra |
±--------------±-------------±-----±----±--------±---------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| email | varchar(129) | NO | | NULL | |
| from_name | varchar(255) | YES | | NULL | |
| from_email | varchar(255) | YES | | NULL | |
| subject | varchar(255) | NO | | NULL | |
| config | varchar(30) | NO | | NULL | |
| template | varchar(50) | NO | | NULL | |
| layout | varchar(50) | NO | | NULL | |
| theme | varchar(50) | NO | | NULL | |
| format | varchar(5) | NO | | NULL | |
| template_vars | text | NO | | NULL | |
| headers | text | YES | | NULL | |
| sent | tinyint(1) | NO | | 0 | |
| locked | tinyint(1) | NO | | 0 | |
| send_tries | int(2) | NO | | 0 | |
| send_at | datetime | YES | | NULL | |
| created | datetime | NO | | NULL | |
| modified | datetime | YES | | NULL | |
| attachments | text | YES | | NULL | |
±--------------±-------------±-----±----±--------±---------------+
19 rows in set (0.00 sec)

MariaDB [vault]> describe email_queue_phinxlog;
±---------------±-------------±-----±----±--------±------+
| Field | Type | Null | Key | Default | Extra |
±---------------±-------------±-----±----±--------±------+
| version | bigint(20) | NO | PRI | NULL | |
| migration_name | varchar(100) | YES | | NULL | |
| start_time | timestamp | YES | | NULL | |
| end_time | timestamp | YES | | NULL | |
| breakpoint | tinyint(1) | NO | | 0 | |
±---------------±-------------±-----±----±--------±------+
5 rows in set (0.00 sec)

MariaDB [vault]> describe phinxlog;
±---------------±-------------±-----±----±--------±------+
| Field | Type | Null | Key | Default | Extra |
±---------------±-------------±-----±----±--------±------+
| version | bigint(20) | NO | PRI | NULL | |
| migration_name | varchar(100) | YES | | NULL | |
| start_time | timestamp | YES | | NULL | |
| end_time | timestamp | YES | | NULL | |
| breakpoint | tinyint(1) | NO | | 0 | |
±---------------±-------------±-----±----±--------±------+
5 rows in set (0.00 sec)

MariaDB [vault]> describe users;
±---------±-------------±-----±----±--------±------+
| Field | Type | Null | Key | Default | Extra |
±---------±-------------±-----±----±--------±------+
| id | char(36) | NO | PRI | NULL | |
| role_id | char(36) | NO | | NULL | |
| username | varchar(255) | NO | | NULL | |
| active | tinyint(1) | NO | | 0 | |
| deleted | tinyint(1) | NO | MUL | 0 | |
| created | datetime | NO | | NULL | |
| modified | datetime | NO | | NULL | |
±---------±-------------±-----±----±--------±------+
7 rows in set (0.01 sec)

MariaDB [vault]> describe roles;
±------------±-------------±-----±----±--------±------+
| Field | Type | Null | Key | Default | Extra |
±------------±-------------±-----±----±--------±------+
| id | char(36) | NO | PRI | NULL | |
| name | varchar(50) | NO | UNI | NULL | |
| description | varchar(255) | YES | | NULL | |
| created | datetime | NO | | NULL | |
| modified | datetime | NO | | NULL | |
±------------±-------------±-----±----±--------±------+
5 rows in set (0.00 sec)

MariaDB [vault]> select * from users;
±-------------------------------------±-------------------------------------±------------------±-------±--------±--------------------±--------------------+
| id | role_id | username | active | deleted | created | modified |
±-------------------------------------±-------------------------------------±------------------±-------±--------±--------------------±--------------------+
| c53c7a43-5760-4490-958a-a69c1c65e3e6 | 89b2ef69-455f-40c2-af46-9ef1a6858745 | pra+vault@pra.rip | 0 | 0 | 2019-02-23 19:50:03 | 2019-02-23 19:50:03 |
±-------------------------------------±-------------------------------------±------------------±-------±--------±--------------------±--------------------+
1 row in set (0.00 sec)

MariaDB [vault]> select * from roles;
±-------------------------------------±------±---------------------------±--------------------±--------------------+
| id | name | description | created | modified |
±-------------------------------------±------±---------------------------±--------------------±--------------------+
| 0cd52d1d-3a95-4c2e-985f-f763f53bd6c8 | user | Logged in user | 2012-07-04 13:39:25 | 2012-07-04 13:39:25 |
| 89b2ef69-455f-40c2-af46-9ef1a6858745 | admin | Organization administrator | 2012-07-04 13:39:25 | 2012-07-04 13:39:25 |
| 9a0cba79-cc93-491f-9ec3-fd28538ccbc4 | root | Super Administrator | 2012-07-04 13:39:25 | 2012-07-04 13:39:25 |
| afab5d88-e410-4960-9a9c-af6fa05bf1be | guest | Non logged in user | 2012-07-04 13:39:25 | 2012-07-04 13:39:25 |
±-------------------------------------±------±---------------------------±--------------------±--------------------+
4 rows in set (0.00 sec)

MariaDB [vault]> select * from email_queue;
Empty set (0.00 sec)
MariaDB [vault]> select * from email_queue_phinxlog;
±---------------±---------------------------±--------------------±--------------------±-----------+
| version | migration_name | start_time | end_time | breakpoint |
±---------------±---------------------------±--------------------±--------------------±-----------+
| 20160324054602 | Initial | 2019-02-23 19:49:20 | 2019-02-23 19:49:21 | 0 |
| 20160810121455 | AddAttachmentsToEmailQueue | 2019-02-23 19:49:21 | 2019-02-23 19:49:23 | 0 |
±---------------±---------------------------±--------------------±--------------------±-----------+
2 rows in set (0.00 sec)

MariaDB [vault]> select * from phinxlog;
±---------------±-----------------------------------±--------------------±--------------------±-----------+
| version | migration_name | start_time | end_time | breakpoint |
±---------------±-----------------------------------±--------------------±--------------------±-----------+
| 20170830064410 | V162InitialMigration | 2019-02-23 19:47:12 | 2019-02-23 19:47:30 | 0 |
| 20170830065037 | V200ActiveMustBeBoolean | 2019-02-23 19:47:30 | 2019-02-23 19:47:35 | 0 |
| 20170830065038 | V200DropUnusedProfileFields | 2019-02-23 19:47:35 | 2019-02-23 19:47:41 | 0 |
| 20170830065039 | V200IncreaseEmailSize | 2019-02-23 19:47:42 | 2019-02-23 19:47:43 | 0 |
| 20170830065040 | V200DropUnusedCreatedBy | 2019-02-23 19:47:43 | 2019-02-23 19:47:59 | 0 |
| 20170830065041 | V200MigrateUUID | 2019-02-23 19:47:59 | 2019-02-23 19:49:15 | 0 |
| 20170830065042 | V200MigrateKeyField | 2019-02-23 19:49:15 | 2019-02-23 19:49:15 | 0 |
| 20171002061834 | V200DropUnusedResourceFields | 2019-02-23 19:49:15 | 2019-02-23 19:49:17 | 0 |
| 20171006141922 | V200AddFavoriteModifiedField | 2019-02-23 19:49:17 | 2019-02-23 19:49:18 | 0 |
| 20171009093000 | V200DropUnusedPermissionTypesTable | 2019-02-23 19:49:18 | 2019-02-23 19:49:19 | 0 |
| 20171009093001 | V200MigrateEmailsTable | 2019-02-23 19:49:19 | 2019-02-23 19:49:23 | 0 |
| 20171009093002 | V200MigrateFileStorageTable | 2019-02-23 19:49:24 | 2019-02-23 19:49:28 | 0 |
| 20171025154754 | V200AddCommentsUserIdField | 2019-02-23 19:49:28 | 2019-02-23 19:49:29 | 0 |
| 20180102065042 | V200MigrateForeignIdField | 2019-02-23 19:49:29 | 2019-02-23 19:49:30 | 0 |
| 20180102180000 | V200DropUnusedTables | 2019-02-23 19:49:30 | 2019-02-23 19:49:31 | 0 |
| 20180102221500 | V200AddMissingTablesIndexes | 2019-02-23 19:49:31 | 2019-02-23 19:49:31 | 0 |
| 20180413171600 | V202ForceColumnsCharset | 2019-02-23 19:49:31 | 2019-02-23 19:49:54 | 0 |
| 20180930151500 | V240AddAuthenticationTokenType | 2019-02-23 19:49:55 | 2019-02-23 19:49:57 | 0 |
| 20181210170000 | V270AddMissingIndexes | 2019-02-23 19:49:57 | 2019-02-23 19:50:02 | 0 |
±---------------±-----------------------------------±--------------------±--------------------±-----------+
19 rows in set (0.00 sec)

[x] I describe the steps on how to reproduce the issue
running the install script

2

i try to add to column varchar(129) but now i have in cron :
Exception: Call to a member function subject() on array in [/var/www/passbolt/vendor/lorenzo/cakephp-email-queue/src/Shell/SenderShell.php, line 92]

MariaDB [vault]> describe email_queue;
±--------------±-------------±-----±----±--------±---------------+
| Field | Type | Null | Key | Default | Extra |
±--------------±-------------±-----±----±--------±---------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| email | varchar(129) | NO | | NULL | |
| from_name | varchar(255) | YES | | NULL | |
| from_email | varchar(255) | YES | | NULL | |
| subject | varchar(255) | NO | | NULL | |
| config | varchar(30) | NO | | NULL | |
| template | varchar(50) | NO | | NULL | |
| layout | varchar(50) | NO | | NULL | |
| theme | varchar(50) | NO | | NULL | |
| format | varchar(5) | NO | | NULL | |
| template_vars | text | NO | | NULL | |
| headers | text | YES | | NULL | |
| sent | tinyint(1) | NO | | 0 | |
| locked | tinyint(1) | NO | | 0 | |
| send_tries | int(2) | NO | | 0 | |
| send_at | datetime | YES | | NULL | |
| created | datetime | NO | | NULL | |
| modified | datetime | YES | | NULL | |
| attachments | text | YES | | NULL | |
| to | varchar(129) | YES | | NULL | |
±--------------±-------------±-----±----±--------±---------------+
20 rows in set (0.00 sec)

3

after some ‘bidouille’ it s working what i done :
=> remove the /var/www/passbolt directory
in debian the nginx user is in /home/www-data thus gpg key preserved
i retry the install ./passbolt_ce_debian_installer.sh with db installed
the to column i added still here but with NULL :
MariaDB [vault]> select email,email_queue.to from email_queue;
±------------------±-----+
| email | to |
±------------------±-----+
| | NULL |
| | NULL |
| pra@pra.rip | NULL |
| pra+vault@pra.rip | NULL |
±------------------±-----+
4 rows in set (0.01 sec)

4

Hi @pra,
Glad to hear that it’s now working with the ‘bidouille’ ;). We have heard of this in the past and it was mostly due to a composer cache issue. Is there any chance that you had before a passbolt v1 installed on the same machine?

5

hello @kevin

it s not possible , the vm is empty, and it s the first time i install this soft
i use xen for the virtualization oh debian buster
i am boring to heard my wife saying “j’en ai marre de tout ces mot de passe, je m’en rappelle jamais”

regards,

pra

6

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.