Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

PostgreSQL option gssencmode=disable isn't configurable #6319

Closed
hacfi opened this issue Mar 1, 2024 · 4 comments
Closed

PostgreSQL option gssencmode=disable isn't configurable #6319

hacfi opened this issue Mar 1, 2024 · 4 comments

Comments

@hacfi
Copy link
Contributor

hacfi commented Mar 1, 2024

Bug Report

Q A
Version 3.8.2

Summary

On macOS there is an issue with PostgreSQL which can only be fixed by setting gssencmode=disable on the PDO connect. This isn't supported currently.

Current behaviour

No way to configure gssencmode=disable.

How to reproduce

On a refresh macOS installation install php and postgresql@16 via homebrew. Set up php-fpm and try to connect to PostgreSQL. Results in a segfault.

Expected behaviour

I can configure gssencmode=disable and connect to PostgreSQL.

@derrabus
Copy link
Member

derrabus commented Mar 1, 2024

Is this option part of the PDO DSN? I'm asking because it's not documented here. But I can find it in the Postgres documentation.

I assume this also affects the pgsql driver?

Please send a PR that adds the option to both drivers.

@hacfi
Copy link
Contributor Author

hacfi commented Mar 1, 2024

Not sure about this but will try to figure it out. I found the solution in this PHP issue: php/php-src#13339 (comment)

Not sure yet if pgsql driver is also affected but will try to reproduce this when I find some time. After having lost 3 days at work I need to catch up on some tasks first.

@hacfi
Copy link
Contributor Author

hacfi commented Mar 2, 2024

I checked and the pgsql driver is also affected. I noticed pgsql isn't easily configurable with the Doctrine bundle so I created an issue for that (doctrine/DoctrineBundle#1763).

Create the PR #6320 to add this.

derrabus pushed a commit that referenced this issue Mar 3, 2024
…er (#6320)

<!-- Fill in the relevant information below to help triage your pull
request. -->

|      Q       |   A
|------------- | -----------
| Type         | improvement
| Fixed issues | #6319 

#### Summary

This adds the `gssencmode` option for PostgreSQL connections for both
the PgSQL and PDO PgSQL driver.
@derrabus derrabus closed this as completed Mar 3, 2024
Copy link

github-actions bot commented Apr 8, 2024

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.

@github-actions github-actions bot locked as resolved and limited conversation to collaborators Apr 8, 2024
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

2 participants