PHPJasper / phpjasper

A PHP report generator
MIT License
463 stars 162 forks source link

JDBC Drive Postgresql New #321

Open elvispdosreis opened 2 years ago

elvispdosreis commented 2 years ago

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

dbarrerap commented 1 year ago

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') ]