Bug: [Postgre] Unable to connect to the database

[warcooft]

PHP Version

8.3

CodeIgniter4 Version

4.5.0

CodeIgniter4 Installation Method

Composer (using codeigniter4/appstarter)

Which operating systems have you tested for this bug?

macOS

Which server did you use?

cli-server (PHP built-in webserver)

Database

PostgreSQL 15.4

What happened?

I have followed the documentation regarding database configuration. https://codeigniter.com/user_guide/datab...tion.html#

here my db config:

public array $default = [
        'DSN'          => 'Postgre://username:password@hostname:5432/database?charset=utf8&connect_timeout=5&sslmode=1',
        'hostname'     => 'localhost',
        'username'     => 'postgres',
        'password'     => '123456',
        'database'     => 'playground_db',
        'DBDriver'     => 'Postgre',
        'DBPrefix'     => '',
        'pConnect'     => false,
        'DBDebug'      => true,
        'charset'      => 'utf8mb4',
        'DBCollat'     => 'utf8mb4_general_ci',
        'swapPre'      => '',
        'encrypt'      => false,
        'compress'     => false,
        'strictOn'     => false,
        'failover'     => [],
        'port'         => 5432,
        'numberNative' => false,
        'dateFormat'   => [
            'date'     => 'Y-m-d',
            'datetime' => 'Y-m-d H:i:s',
            'time'     => 'H:i:s',
        ],
    ];

and then i got this error:

Unable to connect to the database. Main connection [Postgre]: pg_connect(): Unable to connect to PostgreSQL server: invalid sslmode value: "1"

Here details:
https://postimg.cc/bGf6Kmfw

Steps to Reproduce

I have applied the above configuration to the .env file in Codeigniter 4.4.8 and it works fine, but why doesn't it work in Codeigniter 4.5.0? Previously I tried to apply it in .env exactly with version 4.4.8 but it didn't work. Lastly, I configured it in the Config\Database.php file and it also didn't work.

Expected Output

Anything else?

No response

[kenjis]

The values accepted by pg_connect's sslmode argument are: disable, allow, prefer, require
https://www.php.net/manual/ja/function.pg-connect.php#51767

https://www.postgresql.org/docs/8.4/libpq-connect.html#LIBPQ-CONNECT-SSLMODE

[kenjis]

I have applied the above configuration to the .env file in Codeigniter 4.4.8 and it works fine

Previously I tried to apply it in .env exactly with version 4.4.8 but it didn't work.

In v4.4.8, the configuration worked or not?

[warcooft]

I have applied the above configuration to the .env file in Codeigniter 4.4.8 and it works fine

Previously I tried to apply it in .env exactly with version 4.4.8 but it didn't work.

In v4.4.8, the configuration worked or not?

Worked

[warcooft]

I try sample database connection for Postgre in Database file config and now worked, Thanks @kenjis

[kenjis]

Yes, now we have "Sample database connection for Postgre":

CodeIgniter4/app/Config/Database.php

Lines 74 to 99 in 04394c6

	// /**
	// * Sample database connection for Postgre.
	// *
	// * @var array<string, mixed>
	// */
	// public array $default = [
	// 'DSN' => '',
	// 'hostname' => 'localhost',
	// 'username' => 'root',
	// 'password' => 'root',
	// 'database' => 'ci4',
	// 'schema' => 'public',
	// 'DBDriver' => 'Postgre',
	// 'DBPrefix' => '',
	// 'pConnect' => false,
	// 'DBDebug' => true,
	// 'charset' => 'utf8',
	// 'swapPre' => '',
	// 'failover' => [],
	// 'port' => 5432,
	// 'dateFormat' => [
	// 'date' => 'Y-m-d',
	// 'datetime' => 'Y-m-d H:i:s',
	// 'time' => 'H:i:s',
	// ],
	// ];