Can't open a basic connection to postgres

[yaldamahmoodi]

The basic example in README.md isn't working in my case. I got the below error message when I wanted to connect to the database:

Uncaught Exception: Bad connection: Unhandled authentication message: 10 in /home/yalda/PhpstormProjects/testing-voryxPgAsyncLib/vendor/voryx/pgasync/src/PgAsync/Connection.php:514

Also, I double-checked that I set up the user & database correctly in psql and recheck all of it with a classic example of pure PHP code which is worked very well but when I use your library it is not even connect.

OS: Ubuntu 22.04
Postgres Version: 14.7

This is the basic example which throws the exception:

require "vendor/autoload.php";

$client = new PgAsync\Client([
    "host" => "127.0.0.1",
    "port" => "5432",
    "user" => "yalda",
    "database" => "yalda",
    "password" => "****"
]);

$client->query('select * from accounts')->subscribe(
    function ($row) {
        var_dump($row);
    },
    function ($e) {
        echo "Failed.\n";
    },
    function () {
        echo "Complete.\n";
    }
);

[hasanparasteh]

I think currently PgAsync only supports md5 and plaintext (password) authentication methods and this is the root cause of your problem. For now you can try and change authentication method to md5 if you want!

SET password_encryption = 'md5';
ALTER USER <USERNAME> WITH PASSWORD <PASSWORD>;

[hasanparasteh]

@mbonneau What's your idea about supporting scram-sha-256 authentication method in PgAsync?