mirror of
https://github.com/php/php-src.git
synced 2026-04-25 17:08:14 +02:00
KentarouTakeda
88 lines
2.8 KiB
PHP
88 lines
2.8 KiB
PHP
--TEST--
|
|
GitHub #12424 (Fix GH-12423: [pdo_pgsql] Changed to prioritize DSN authentication information over arguments.)
|
|
--EXTENSIONS--
|
|
pdo_pgsql
|
|
--SKIPIF--
|
|
<?php
|
|
require __DIR__ . '/../../../ext/pdo/tests/pdo_test.inc';
|
|
require __DIR__ . '/config.inc';
|
|
if (strpos($config['ENV']['PDOTEST_DSN'], 'password=') === false && !isset($config['ENV']['PDOTEST_PASS'])) {
|
|
die('skip no password');
|
|
}
|
|
PDOTest::skip();
|
|
?>
|
|
--FILE--
|
|
<?php
|
|
require __DIR__ . '/config.inc';
|
|
|
|
$dsnWithCredentials = $config['ENV']['PDOTEST_DSN'];
|
|
$user = $config['ENV']['PDOTEST_USER'] ?? null;
|
|
$password = $config['ENV']['PDOTEST_PASS'] ?? null;
|
|
if (!$user) {
|
|
preg_match('/user=([^ ]*)/', $dsnWithCredentials, $match);
|
|
$user = $match[1] ?? '';
|
|
}
|
|
if (!$password) {
|
|
preg_match('/password=([^ ]*)/', $dsnWithCredentials, $match);
|
|
$password = $match[1] ?? '';
|
|
}
|
|
$dsn = str_replace("user={$user}", '', $dsnWithCredentials);
|
|
$dsn = str_replace("password={$password}", '', $dsn);
|
|
$dsn = rtrim($dsn);
|
|
|
|
echo "dsn without credentials / correct user / correct password".PHP_EOL;
|
|
try {
|
|
$db = new PDO($dsn, $user, $password, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
|
|
echo "Connected.".PHP_EOL.PHP_EOL;
|
|
} catch (PDOException $e) {
|
|
echo $e->getMessage().PHP_EOL;
|
|
}
|
|
|
|
echo "dsn with credentials / no user / no password".PHP_EOL;
|
|
try {
|
|
$db = new PDO("{$dsn} user={$user} password={$password}", null, null, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
|
|
echo "Connected.".PHP_EOL.PHP_EOL;
|
|
} catch (PDOException $e) {
|
|
echo $e->getMessage().PHP_EOL;
|
|
}
|
|
|
|
echo "dsn with correct user / incorrect user / correct password".PHP_EOL;
|
|
try {
|
|
$db = new PDO("{$dsn} user={$user}", 'hoge', $password, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
|
|
echo "Connected.".PHP_EOL.PHP_EOL;
|
|
} catch (PDOException $e) {
|
|
echo $e->getMessage().PHP_EOL;
|
|
}
|
|
|
|
echo "dsn with correct password / correct user / incorrect password".PHP_EOL;
|
|
try {
|
|
$db = new PDO("{$dsn} password={$password}", $user, 'fuga', [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
|
|
echo "Connected.".PHP_EOL.PHP_EOL;
|
|
} catch (PDOException $e) {
|
|
echo $e->getMessage().PHP_EOL;
|
|
}
|
|
|
|
echo "dsn with correct credentials / incorrect user / incorrect password".PHP_EOL;
|
|
try {
|
|
$db = new PDO("{$dsn} user={$user} password={$password}", 'hoge', 'fuga', [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
|
|
echo "Connected.".PHP_EOL;
|
|
} catch (PDOException $e) {
|
|
echo $e->getMessage().PHP_EOL;
|
|
}
|
|
?>
|
|
--EXPECT--
|
|
dsn without credentials / correct user / correct password
|
|
Connected.
|
|
|
|
dsn with credentials / no user / no password
|
|
Connected.
|
|
|
|
dsn with correct user / incorrect user / correct password
|
|
Connected.
|
|
|
|
dsn with correct password / correct user / incorrect password
|
|
Connected.
|
|
|
|
dsn with correct credentials / incorrect user / incorrect password
|
|
Connected.
|