Bug 57714 - Make pool parameters configurable for sql db connection
Summary: Make pool parameters configurable for sql db connection
Status: CLOSED FIXED
Alias: None
Product: UCS
Classification: Unclassified
Component: UMC (Generic)
Version: UCS 5.0
Hardware: Other Linux
: P5 normal
Target Milestone: UCS 5.0-9-errata
Assignee: Iván.Delgado
QA Contact: Felix Botner
URL: https://git.knut.univention.de/univen...
Keywords:
Depends on:
Blocks:
 
Reported: 2024-11-01 12:12 CET by Felix Botner
Modified: 2024-11-07 09:28 CET (History)
2 users (show)

See Also:
What kind of report is it?: Development Internal
What type of bug is this?: ---
Who will be affected by this bug?: ---
How will those affected feel about the bug?: ---
User Pain:
Enterprise Customer affected?:
School Customer affected?:
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:
Bug group (optional):
Customer ID:
Max CVSS v3 score:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Felix Botner univentionstaff 2024-11-01 12:12:12 CET
Make
* pool_size
* max_overflow
* pool_timeout 
* pool_recycle
configurable for create_engine in UMC
Comment 1 Iván.Delgado univentionstaff 2024-11-04 12:54:23 CET
Package: univention-management-console
Version: 12.0.35-9
Branch: 5.0-0
Scope: errata5.0-9

univention-management-console.yaml
572ea6c920d6 | Bug #57714: univention-management-console.yaml

univention-management-console (12.0.35-9)
497d61c4638c | feat(oidc): Make the connection pool configurable via umc settings/data

8c0eeca10ba0 | doc(login): how to change the connection values for the connection pool via umc settings/data
Comment 2 Iván.Delgado univentionstaff 2024-11-04 13:06:14 CET
Successful build
Package: univention-management-console
Version: 13.0.29
Branch: 5.1-0

univention-management-console (13.0.29)
89f30ecb906e | feat(oidc): Make the connection pool configurable via umc settings/data


Successful build
Package: univention-management-console
Version: 14.0.40
Branch: 5.2-0


univention-management-console (14.0.40)
70295d136787 | feat(oidc): Make the connection pool configurable via umc settings/data
Comment 3 Felix Botner univentionstaff 2024-11-04 14:28:55 CET
- OK univention-management-console setting connection pool options
- OK docs
- OK yaml
- OK 5.0-9, 5.1 and 5.2
Comment 5 Daniel Tröder univentionstaff 2024-11-07 09:28:50 CET
> feat(oidc): Make the connection pool configurable via umc settings/data

I thought "This is not good for a static configuration like used in Nubus for Kubnernetes." and had to look at the source code to find out it also support setting the configuration via environment.

Please mention all interfaces a feature supports next time.