Huge SQL Backup file

Installation Issues
1

Checklist
I have read intro post: https://community.passbolt.com/t/about-the-installation-issues-category/12
I have read the tutorials, help and searched for similar issues
I provide relevant information about my server (component names and versions, etc.)

* Debian 12 Installation - no Docker
* Native Installation as descripbed in Howto above
* less than 100 Passwords stored

[-] I provide a copy of my logs and healthcheck

I describe the steps I have taken to trouble shoot the problem
Run of following command, produces huge MySQL Backup File

/var/opt/passbolt/backup.sh

I describe the steps on how to reproduce the issue
MySQL Backup File is huge

/var/opt/passbolt/backup/backup-2024-11-18--07-48-51/backup_1731912531.sql

What can be the reason for such a huge mysql file?
We connected Passbolt to kubernetes? Are there maybe Logs written?

Thank you for your Answers!
BR

2

Seems to be tons of action logs!
In one day we got 5310385 logs to purge?

$ sudo su -s /bin/bash -c "/usr/share/php/passbolt/bin/cake passbolt action_logs_purge --dry-run -r 1" www-data

     ____                  __          ____  
    / __ \____  _____ ____/ /_  ____  / / /_ 
   / /_/ / __ `/ ___/ ___/ __ \/ __ \/ / __/ 
  / ____/ /_/ (__  |__  ) /_/ / /_/ / / /    
 /_/    \__,_/____/____/_.___/\____/_/\__/   

 Open source password manager for teams
-------------------------------------------------------------------------------
+------------------------------------+---------+
| Action                             | Count   |
+------------------------------------+---------+
| ResourcesView.view                 | 2282843 |
| ResourceTypesView.view             | 2281099 |
| UsersView.view                     | 683438  |
| ResourcesIndex.index               | 58007   |
| SettingsIndex.index                | 3105    |
| GroupsIndex.index                  | 364     |
| FoldersIndex.index                 | 315     |
| AccountSettingsIndex.index         | 239     |
| UsersIndex.index                   | 200     |
| Home.apiExtApp                     | 165     |
| FoldersView.view                   | 163     |
| GpgkeysIndex.index                 | 54      |
| RolesIndex.index                   | 54      |
| Home.apiApp                        | 52      |
| Share.dryRun                       | 46      |
| PermissionsView.viewAcoPermissions | 44      |
| ResourceTypesIndex.index           | 44      |
| MfaOrgSettingsGet.get              | 40      |
| CommentsView.view                  | 20      |
| ShareSearch.searchArosToShareWith  | 19      |
| AuthVerify.verifyGet               | 15      |
| TotpVerifyGet.get                  | 12      |
| NotificationOrgSettingsGet.get     | 12      |
| HealthcheckIndex.index             | 11      |
| MfaSetupSelectProvider.get         | 9       |
| ThemesIndex.index                  | 9       |
| MfaVerifyAjaxError.get             | 3       |
| TotpSetupGet.get                   | 3       |
| Total                              | 5310385 |
+------------------------------------+---------+

Seems no debug is activated:

'debug' => filter_var(env('DEBUG', false), FILTER_VALIDATE_BOOLEAN),
'debugKit' => false,
3

Hey @cadirol, you can use action_logs_purge command to delete unnecessary action logs.

See: https://www.passbolt.com/docs/hosting/troubleshooting/purge-action-logs/

4

Hy @ishan
Thank you very much to get in touch with me!
i did the cleanup with action_logs_purge, but i discovered 5310385 in 4 Days! See my last post
I think the solution must be, to reduce the log amount.
What can be done, to get less Logs?

5

Hey @cadirol,

Could you please contact support at support@passbolt.com? We would like to investigate the issue with you. Ask for Cédric.

1 Like
7

Good day Cédric
Thank you very much for your Time and Support!
We found the reason for the Huge amount of Logs in the 3rd Party Plugin [1]
In the Documentation, the refresh Interval is set to 15s - which produces tons of Logs if you have a couple of connecting Pods running!

After set refreshInterval: "0" the passwords are only synced on a manual way. No POST Requests on the passbolt API are made anymore.

Thanks again for this outstanding Community Support!
Best regards
Adrian

[1] https://external-secrets.io/latest/provider/passbolt/

2 Likes