Installing issue: passbolt-ce-server E: Sub-process /usr/bin/dpkg returned an error code (1)

Installation Issues
21

Hi @pimzwagerMCS,

Can you share your passbolt.php (after cleaning db and mail credentials of course)?

Cheers,
Max

22 
<?php
/**
 * Passbolt ~ Open source password manager for teams
 * Copyright (c) Passbolt SA (https://www.passbolt.com)
 *
 * Licensed under GNU Affero General Public License version 3 of the or any later version.
 * For full copyright and license information, please see the LICENSE.txt
 * Redistributions of files must retain the above copyright notice.
 *
 * @copyright     Copyright (c) Passbolt SA (https://www.passbolt.com)
 * @license       https://opensource.org/licenses/AGPL-3.0 AGPL License
 * @link          https://www.passbolt.com Passbolt(tm)
 * @since         2.0.0
 */
/**
 * 2. set the variables in the App section
 * 3. set the variables in the passbolt section
 *
 */
return [

    /**
     */
    'App' => [
        'fullBaseUrl' => 'cleanedupURL',
    ],

    // Database configuration.
    'Datasources' => [
        'default' => [
            'host' => 'localhost',
            //'port' => 'non_standard_port_number',
            'username' => 'passboltadmin',
            'password' => 'cleaneduppassword',
            'database' => 'passbolt',
        ],
    ],
    // Email configuration.
    'EmailTransport' => [
        'default' => [
            'host' => 'localhost',
            'port' => 25,
            'username' => 'user',
            'password' => 'secret',
            // Is this a secure connection? true if yes, null if no.
            'tls' => null,
            //'timeout' => 30,
            //'client' => null,
            //'url' => null,
        ],
    ],
    'Email' => [
        'default' => [
            // Defines the default name and email of the sender of the emails.
            'from' => ['p.zwager@mcs-nl.com' => 'Passbolt'],
            //'charset' => 'utf-8',
            //'headerCharset' => 'utf-8',
        ],
    ],

    /**
     * DEFAULT PASSBOLT CONFIGURATION
     *
     * This is the default configuration.
     * It enforces the use of ssl, and does not provide a default OpenPGP key.
     * If your objective is to try passbolt quickly for evaluation purpose, and security is not important
     * you can use the demo config example provided in the next section below.
     */
    'passbolt' => [
        // GPG Configuration.
        // The keyring must to be owned and accessible by the webserver user.
        // Example: www-data user on Debian
        'gpg' => [
            // Tell GPG where to find the keyring.
            // If putenv is set to false, gnupg will use the default path ~/.gnupg.
            // For example :
            // - Apache on Centos it would be in '/usr/share/httpd/.gnupg'
            // - Apache on Debian it would be in '/var/www/.gnupg'
            // - Nginx on Centos it would be in '/var/lib/nginx/.gnupg'
            // - etc.
            //'keyring' => getenv("HOME") . DS . '.gnupg',
            //
            // Replace GNUPGHOME with above value even if it is set.
            //'putenv' => false,

            // Main server key.
            'serverKey' => [
                // Server private key fingerprint.
                'fingerprint' => '',
                //'public' => CONFIG . 'gpg' . DS . 'serverkey.asc',
                //'private' => CONFIG . 'gpg' . DS . 'serverkey_private.asc',
            ],
        ],
    ],

];
23

in the errorlog:

2021-09-17 08:11:46 Error: [Cake\Database\Exception\MissingConnectionException] Connection to Mysql could not be established: SQLSTATE[HY000] [1044] Access denied for user 'passboltadmin'@'localhost' to database 'passbolt' in /usr/share/php/passbolt/vendor/cakephp/cakephp/src/Database/Driver.php on line 140
Caused by: [PDOException] SQLSTATE[HY000] [1044] Access denied for user 'passboltadmin'@'localhost' to database 'passbolt' in /usr/share/php/passbolt/vendor/cakephp/cakephp/src/Database/Driver.php on line 132
Request URL: /auth/login?redirect=%2F
Referer URL: https://pb.mcs-nl.com/auth/login?redirect=%2F
Client IP: cleaned up
24

Can you use the code tag to format it to see where are the comment please :sweat_smile:

25

I edited my first posts with code

26

So I checked MySQL, and I am able to log in with the user and password in the config file, but the passboltdb table is empty. Is this filled in a later stage?

27

I found a mistake in the database name in passbolt.php, changed it and now in the errorlog:

2021-09-17 08:30:16 Error: [Cake\Database\Exception\DatabaseException] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'passboltdb.actions' doesn't exist in /usr/share/php/passbolt/vendor/cakephp/cakephp/src/Database/Schema/Collection.php on line 142
Caused by: [PDOException] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'passboltdb.actions' doesn't exist in /usr/share/php/passbolt/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php on line 39
Request URL: /auth/login?redirect=%2F
28

Can I find the default tables somewhere to import them?

29

Hi @pimzwagerMCS,

Following Passbolt Help | Install Passbolt CE on Debian 10, at the step 2, you should see a wizard for the setup of Passbolt. It is this wizard who will create the database and the /etc/passbolt/passbolt.php configuration file.

You can safely delete the /etc/passbolt/passbolt.php file on your server, and the configuration wizard will be available again. It will populate the database.

Best,

30

YES! this seems to have fixed the issue. I am niow configuring the server! Thank you all so much!

31

Great :hugs: don’t hesitate to get in touch if you have some other questions :slight_smile: