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
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,
Oh right, thanks. I did not notice that the database server was specified differently.
I ported passbolt from docker to ubuntu
How to transfer passbolt from docker to ubuntu? Where to get the file passbolt.php? Because I have the wrong fingerprint in this file.
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,
1 Like
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
Hi,
You got a 500 (Internal Server Error)in your logs. Can you check your /var/log/passbolt/error.log file ?
Best,
1 Like
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
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,
1 Like
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.
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.
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,
1 Like
How to transfer avatars? I have an Avatars folder, it has a lot of subfolders, in which there is another subfolder and there are already pictures in it. Do I need to move only images to /usr/share/php/passbolt/webroot/img/public/ or all folders with subfolders?
Hi,
You must move all folders with subfolders in /usr/share/php/passbolt/webroot/img/public/ before running the sudo -H -u www-data /bin/bash -c "/usr/share/php/passbolt/bin/cake passbolt migrate" command.
Once the command has been ran, I don’t think you can transfer avatars anymore.
Best,
1 Like
And I must set correct rights to all folders with subfolders?
Yes, rights must always be set to www-data on Debian/Ubuntu systems:
sudo chown -R www-data:www-data /usr/share/php/passbolt/webroot/img/public/
1 Like
2022-05-27 16:33:22 error: The avatar with file Avatar/3c/87/05/d3c4ab04168f4756885d29f450a3b636/d3c4ab04168f4756885d29f450a3b636.jpg could not be saved.
Something go wrong
