Problem after installation

lunahod · May 4, 2022, 9:52am

I did a clean install of a new version of passbolt with data transfer from the old one. Installed according to the instructions

After installation, the server did not start. For a fraction of a second, a server error 500 appeared, and then just a white screen.
After running the passbolt test with the command
sudo -H -u www-data /bin/bash -c "/usr/share/php/passbolt/bin/cake passbolt healthcheck"
The following problems were found (screenshot below).

OS - Ubuntu 20.04
PHP - 7.4.3 (cli)
Web server - Nginx 1.14.0
Passbolt - latest

_jc · May 4, 2022, 10:20am

Hi @lunahod ,

Is your MySQL server located on another server ? It seems your new server is not able to reach your MySQL server:

You will find database hostname and credentials on /etc/passbolt/passbolt.php, as explained here: Passbolt Help | Update my database credentials

Best,

lunahod · May 4, 2022, 10:30am

Oh right, thanks. I did not notice that the database server was specified differently.
I ported passbolt from docker to ubuntu

_jc · May 4, 2022, 11:28am

So, problem resolved ?

lunahod · May 4, 2022, 1:10pm

How to transfer passbolt from docker to ubuntu? Where to get the file passbolt.php? Because I have the wrong fingerprint in this file.

_jc · May 4, 2022, 2:15pm

If you followed Passbolt Help | Migrate an existing Passbolt CE to a new Ubuntu server you should have a /etc/passbolt/passbolt.php file, with bad fingerprint, as you noticed.

To get the correct fingerprint, you can extract your gpg server keys from the backup archive and execute this command to get the fingerprint:

gpg --show-keys serverkey.asc

It will display something like:

pub   rsa2048 2022-01-20 [SC]
      43F978AFF88B53F5ABBD12C87D5E40A4C43926ED
uid                      Passbolt default user <passbolt@yourdomain.com>
sub   rsa2048 2022-01-20 [E]

Where 43F978AFF88B53F5ABBD12C87D5E40A4C43926ED is the fingerprint in the above output. You can then put your fingerprint in /etc/passbolt/passbolt.php file, in the fingerprint parameter.

Best,

lunahod · May 11, 2022, 3:08pm

After install new one version of passbolt and transfer all data from old one, passbolt is running. But after entering email I recieve endlessly loading. In console of Google Chrome I recieve an error
POST https://url_of_my_server/users/recover.json?api-version=v2 500 (Internal Server Error) api-triage.js?v=3.5.0:2

_jc · May 11, 2022, 3:36pm

Hi,

You got a 500 (Internal Server Error)in your logs. Can you check your /var/log/passbolt/error.log file ?

Best,

lunahod · May 11, 2022, 3:56pm

It seems to swear at the avatars.

2022-05-11 15:48:38 Error: [Cake\Database\Exception\DatabaseException] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'passbolt.avatars' 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 'passbolt.avatars' doesn't exist in /usr/share/php/passbolt/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php on line 39
Request URL: /users/recover.json?api-version=v2
Referer URL: https://url_of_my_server/users/recover?locale=en-UK
Client IP: my_IP

And I have some another error

2022-05-11 13:46:56 Error: [Cake\Routing\Exception\MissingRouteException] A route matching "/" could not be found. in /usr/share/php/passbolt/vendor/cakephp/cakephp/src/Routing/RouteCollection.php on line 199
Request URL: /
Client IP: IP

_jc · May 11, 2022, 4:16pm

It seems you missed the step 5 of the documentation.

Did you ran the migrate command ?

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

If you still have other errors, can you post the full output of the status-report command ?

sudo /usr/share/php/passbolt/bin/status-report

Cheers,

lunahod · May 11, 2022, 4:26pm

No, I didn’t. This command is not listed in the instructions, so I did not enter it.

sudo -H -u www-data /bin/bash -c "/usr/share/php/passbolt/bin/cake passbolt migrate"
After entering this command, it seems to work. I will test now.

lunahod · May 11, 2022, 4:29pm

One more question. Where is the right place to move avatar files? I’m moving to a server with a version of Passbolt above 3.0 from version 2.8.3. In this version, the avatars are in files in the program folder, not in the database.

_jc · May 12, 2022, 7:45am

From the documentation, you must execute these steps in this order, and restoring avatar before the database import:

There is a database migration who will migrate the avatar files from disk to the database.

Best,