php icon indicating copy to clipboard operation
php copied to clipboard

Postgres connection error - "SCRAM authentication requires libpq version 10 or above"

Open SchramlTim opened this issue 3 years ago • 2 comments

Bug happend in

  • Version: 0.3.2 -> 0.5.2

Description

This error happend if i try to connect to my supabase postgres database: "SCRAM authentication requires libpq version 10 or above". Is there an option to solve this error?

SchramlTim avatar Sep 16 '22 13:09 SchramlTim

Same problem here, if you have any solution I'll take it !

MaksOuw avatar Sep 20 '22 21:09 MaksOuw

Same problem here.

snuggneighborhood avatar Sep 25 '22 07:09 snuggneighborhood

up, same problem

irfanhkm avatar Oct 23 '22 17:10 irfanhkm

Linked to:

  • https://github.com/scram-sasl/info/issues/1

Neustradamus avatar Oct 23 '22 17:10 Neustradamus

Hi folks! I am not sure if there is any way to upgrade libpq to newer version, because lambdas are using Amazon Linux 2 under the hood. But, I will try to take a look deeper.

f3l1x avatar Oct 24 '22 07:10 f3l1x

Will this fix work? https://stackoverflow.com/a/72703748

I've been using Planetscale instead as my database temporarily and that works for now but would love to get Postgres working.

tao avatar Nov 07 '22 07:11 tao

is there an update?

SchramlTim avatar Mar 22 '23 22:03 SchramlTim

I have an update: Found time to work my way into the platform and found a fix for it. The problem needs to be fixed in libphp. I will put a PR there and hope that @f3l1x will release a new package version for everyone in time :)

SchramlTim avatar Mar 24 '23 14:03 SchramlTim

@SchramlTim: Where is the PR? Maybe good to specify ;)

And please reopen this ticket, currently it is not solved.

Neustradamus avatar Mar 24 '23 20:03 Neustradamus

Ofcouse

https://github.com/juicyfx/libphp/pull/376

SchramlTim avatar Mar 24 '23 20:03 SchramlTim

Same problem too @SchramlTim i tried to connect using PDO method with php-vercel function: https://github.com/vercel-community/php

how do i use libphp in my project ?

i need create this architecture in my project just ?

├── dist // │ └── *.js └── native // ├── lib // │ └── * (shared libs) // └── php // ├── modules // │ └── *.so (php modules) // ├── composer // ├── php.ini // ├── php // ├── php-cgi // ├── php-fpm // └── php-fpm.ini

HugoBarjot avatar Mar 26 '23 20:03 HugoBarjot

I am working on it. I need to release new version.

f3l1x avatar Mar 27 '23 06:03 f3l1x

Hi, can you folks try new versions?

[email protected] - PHP 8.2.x (https://example-php-8-2.vercel.app/) [email protected] - PHP 8.1.x (https://example-php-8-1.vercel.app/) [email protected] - PHP 8.0.x (https://example-php-8-0.vercel.app/) [email protected] - PHP 7.4.x (https://example-php-7-4.vercel.app/)

f3l1x avatar Mar 27 '23 12:03 f3l1x

@SchramlTim, @MaksOuw, @snuggneighborhood, @irfanhkm, @tao, @HugoBarjot: Can you try the new versions specified by @f3l1x?

Neustradamus avatar Mar 27 '23 19:03 Neustradamus

Connection work for me with this 0.6.0 version

HugoBarjot avatar Mar 27 '23 19:03 HugoBarjot

Tested it too. PHP 8.2 works for me fine.

SchramlTim avatar Mar 28 '23 05:03 SchramlTim

Awesome. Thank you guys for waiting and @SchramlTim for code updates.

f3l1x avatar Mar 28 '23 05:03 f3l1x

Awesome. Thank you guys for waiting and @SchramlTim for code updates.

f3l1x avatar Mar 28 '23 05:03 f3l1x