Re: [I] Pgbouncer not set properly upon using data.metadataSecretName [airflow]
github-actions[bot] commented on issue #33924: URL: https://github.com/apache/airflow/issues/33924#issuecomment-2869543310 This issue has been closed because it has not received response from the issue author. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
Re: [I] Pgbouncer not set properly upon using data.metadataSecretName [airflow]
github-actions[bot] closed issue #33924: Pgbouncer not set properly upon using data.metadataSecretName URL: https://github.com/apache/airflow/issues/33924 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
Re: [I] Pgbouncer not set properly upon using data.metadataSecretName [airflow]
github-actions[bot] commented on issue #33924: URL: https://github.com/apache/airflow/issues/33924#issuecomment-2791753223 This issue has been automatically marked as stale because it has been open for 365 days without any activity. There has been several Airflow releases since last activity on this issue. Kindly asking to recheck the report against latest Airflow version and let us know if the issue is reproducible. The issue will be closed in next 30 days if no further activity occurs from the issue author. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
Re: [I] Pgbouncer not set properly upon using data.metadataSecretName [airflow]
potiuk commented on issue #33924: URL: https://github.com/apache/airflow/issues/33924#issuecomment-2041578066 I think coming with an idea is part of the solution. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
Re: [I] Pgbouncer not set properly upon using data.metadataSecretName [airflow]
VladimirYushkevich commented on issue #33924: URL: https://github.com/apache/airflow/issues/33924#issuecomment-2027324190 We experienced a similar issue. I don't mind fixing it, but I need to clarify a few things first: * `data.metadataSecretName` is not for `pgbouncer`; it is for other workloads to connect to the DB directly. * `data.metadataConnection` details can be used for connection to `pgbouncer`. In this case storing credentials in values IMO is still secure, as the actual connection to DB is handled by `pgbouncer`. * as mentioned above `pgbouncer` uses another [credentials](https://github.com/apache/airflow/blob/ae6fec927c8f717d2a8481a6c3afc85a171652c6/chart/templates/_helpers.yaml#L443). As far as I can see, there is only one way to set it up, via `data.metadataConnection` values (not secure). In our case we created a k8s secret with the encrypted content of `pgbouncer.ini`, as mentioned [here](https://github.com/apache/airflow/blob/ae6fec927c8f717d2a8481a6c3afc85a171652c6/chart/values.yaml#L1970) and referenced it in `configSecretName`. But I don't see an easy way to populate the content of `pgbouncer.ini` from another k8s secret. Any ideas? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
Re: [I] Pgbouncer not set properly upon using data.metadataSecretName [airflow]
potiuk commented on issue #33924: URL: https://github.com/apache/airflow/issues/33924#issuecomment-1974767878 I think it's best if somoeone finally implements it :). this is how things work in open-source - there is no update until somoene takes on the task and fixes it - maybe one of you @adilblanco @ubaldvdm @cdallaire81 @hakuno @flogue - would like to take a stab and attempt to fix it in a PR? That's the fastest way to get it fixed - otherwise I marked it as good first issue and it will have to wait for someone, to well, fix it. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
Re: [I] Pgbouncer not set properly upon using data.metadataSecretName [airflow]
adilblanco commented on issue #33924: URL: https://github.com/apache/airflow/issues/33924#issuecomment-1974012692 Facing the same roadblock. Any progress or updates on this ? Thanks ! -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
Re: [I] Pgbouncer not set properly upon using data.metadataSecretName [airflow]
ubaldvdm commented on issue #33924: URL: https://github.com/apache/airflow/issues/33924#issuecomment-1969903508 We are also having this issue, is there a solution ? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
Re: [I] Pgbouncer not set properly upon using data.metadataSecretName [airflow]
cdallaire81 commented on issue #33924: URL: https://github.com/apache/airflow/issues/33924#issuecomment-1896615681 I'm also stuck on this problem, any updates? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
Re: [I] Pgbouncer not set properly upon using data.metadataSecretName [airflow]
hakuno commented on issue #33924: URL: https://github.com/apache/airflow/issues/33924#issuecomment-1793314349 PgBouncer relies on `pgbouncer.ini` configuration file. So, at moment, I guess the `metadataSecretName` is being ignored on `pgbouncer_config` template. Moreover, the template isn't able to parse a full **connection string** from am existing Kubernetes Secret into `host`, `dbname`, `port`, `user`, `pass` etc. Maybe it explains why it isn't facing the pool by using `metadataSecretName`. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
Re: [I] Pgbouncer not set properly upon using data.metadataSecretName [airflow]
hakuno commented on issue #33924: URL: https://github.com/apache/airflow/issues/33924#issuecomment-1791268201 @eladkal Actually I'll be away this and next week (on vacation). But I think it needs a fix. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
Re: [I] Pgbouncer not set properly upon using data.metadataSecretName [airflow]
eladkal commented on issue #33924: URL: https://github.com/apache/airflow/issues/33924#issuecomment-178729 @hakuno if you have the time to look into this issue? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
