Checklist
I have read intro post: About the Installation Issues category
I have read the tutorials, help and searched for similar issues
I provide relevant information about my server (component names and versions, etc.)
I provide a copy of my logs and healthcheck
I describe the steps I have taken to trouble shoot the problem
I describe the steps on how to reproduce the issue
Old Passbolt CE instance:
AWS EC2 AMI Passbolt CE
[ami-0540253430a561106]
Passbolt v.4.0.0
New Passbolt CE instance:
AWS EC2 AMI Passbolt CE
[ami-00d3d5d9ae8804ef4]
Passbolt v.4.9.1
Issue:
The freshly created backup.sql created on the old instance does not contain recent passwords and seems to about 1 month old if imported to the new instance.
Steps taken:
I followed this guides for the migration
Alltough there is no dedicated guide for the AMI Instances on AWS so the following command was not working.
sudo su -s /bin/bash -c "/usr/share/php/passbolt/bin/cake passbolt mysql_export" www-data
returns:
Saving backup file: /var/lib/passbolt/tmp/cache/database/backup_1728382950.sql
sh: 1: cannot create /var/lib/passbolt/tmp/cache/database/backup_1728382950.sql: Permission denied
There was an error running the dump.
Please ensure on MySQL that the user has PROCESS privileges.
Database old_instance_db_name
User old_instance_db_user
Something went wrong!
So the command that worked was the following with user “admin”:
sudo su -s /bin/bash -c "/usr/share/php/passbolt/bin/cake passbolt mysql_export" admin
returns:
Saving backup file: /var/lib/passbolt/tmp/cache/database/backup_1728381696.sql
Success: the database was saved on file!
On the new Instance i tried to load the database with the command stated in the documentation
mysql -u new_instance_db_user -p new_instance_db_name < backup_1728381696.sql
returns:
ERROR at line 1: Unknown command '\-'.
So i tried to import it manually which worked but not all password seems to be imported or the backup file does not include recent passwords newer than 1 month
sudo mysql -u root
mysql> USE new_instance_db_name;
mysql> SOURCE backup_1728381696.sql