cadirol
November 18, 2024, 6:57am
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
cadirol
November 18, 2024, 7:31am
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,
ishan
November 18, 2024, 8:33am
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/
cadirol
November 18, 2024, 10:09am
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?
cedric
November 18, 2024, 10:37am
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
cadirol
November 27, 2024, 7:38am
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