phpjasper
phpjasper copied to clipboard
JDBC Drive Postgresql New
Please add PostgreSQL JDBC 4.2 Driver, 42.4.0
drive old "Unable to connect to database: O tipo de autenticação 10 não é suportado. Verifique se você configurou o arquivo pg_hba.conf incluindo a subrede ou endereço IP do cliente, e se está utilizando o esquema de autenticação suportado pelo driver."
JDBC Drive
https://jdbc.postgresql.org/download.html
Replaced the driver with PostgreSQL JDBC driver, but still showing this message:
Unable to connect to database: The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or subnet, and that it is using an authentication scheme supported by the driver.
pg_hba.conf has this config:
host all all 127.0.0.1/32 scram-sha-256
The db_connection params I'm using are the folowing:
'db_connection' => [ 'driver' => 'postgres', 'username' => env('PG_USERNAME'), 'password' => env('PG_PASSWORD'), 'host' => env('PG_HOST', '127.0.0.1'), 'database' => env('PG_DATABASE'), 'port' => env('PG_PORT', '5432') ]