以上都不适合我。我打开了关于这个主题的多个新问题,只是为了让它们作为这个问题的副本被迅速关闭(这真的不是同一个问题,因为我的问题更多是关于对等身份验证):How to make Symfony authenticate to PostgreSQL using peer authentication without a username and password 和 {{3 }} 主要是反复试验,找到了一个无证但并不可怕的解决方案。
我们知道 PHP 和 Doctrine 都能够使用 Unix 套接字和对等身份验证进行连接,因为以下两者都有效。
$pdo = new PDO("pgsql:dbname=testing");
$pdo = EntityManager::create(['driver' => 'pdo_pgsql','dbname' => 'testing'],Setup::createAnnotationMetadataConfiguration([__DIR__."/../src"],true,null,false))->getConnection();
因此,人们可能认为以下 config/packages/doctrine.yaml
会起作用:
doctrine:
dbal:
driver: pdo_pgsql
dbname: testing
server_version: 13
但没那么幸运:
[2021-07-25T22:15:57.675268+00:00] console.CRITICAL: Error thrown while running command "doctrine:schema:validate". Message: "An exception occurred in driver: SQLSTATE[08006] [7] fe_sendauth: no password supplied" {"exception":"[object] (Doctrine\\DBAL\\Exception\\ConnectionException(code: 0): An exception occurred in driver: SQLSTATE[08006] [7] fe_sendauth: no password supplied at /var/www/software-requirements/api/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php:88)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 7): SQLSTATE[08006] [7] fe_sendauth: no password supplied at /var/www/software-requirements/api/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18)\n[previous exception] [object] (PDOException(code: 7): SQLSTATE[08006] [7] fe_sendauth: no password supplied at /var/www/software-requirements/api/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:39)","command":"doctrine:schema:validate","message":"An exception occurred in driver: SQLSTATE[08006] [7] fe_sendauth: no password supplied"} []
然后我查看了赋予 \Doctrine\DBAL\Driver\__construct
的内容,发现原生 Doctrine 方法将 user
和 host
都保留为 null
,但 Symfony 不恰当地将它们设置为root
和 localhost
分别。解决方案是稍微修改 config/packages/doctrine.yaml
并将 user
和 host
设置为 null。虽然未显示,但显然您可以并且应该在 .env
中定义变量。
doctrine:
dbal:
driver: pdo_pgsql
dbname: testing
server_version: 13
user: null
host: null
,
调试Doctrine的驱动程序后的解决方案我创建的解决方案不是那么优雅,但是目前它可以正常工作并且可以改进。我不喜欢驱动程序本身中的环境变量,但这可能可以改进。
doctrine.yaml
doctrine:
dbal:
#driver: %database_driver%
driver_class: App\Infrastructure\Common\Service\PostgreSQLDoctrineDriver
host: %database_host%
port: %database_port%
dbname: %database_name%
user: %database_user%
password: %database_password%
#charset: UTF8
orm:
auto_generate_proxy_classes: %kernel.debug%
auto_mapping: true
PostgreSQLDoctrineDriver.php
<?php declare(strict_types=1);
namespace App\Infrastructure\Common\Service;
use Doctrine\DBAL\DBALException;
use Doctrine\DBAL\Driver\PDOConnection;
use Doctrine\DBAL\Driver\PDOPgSql\Driver;
use \PDO;
use \PDOException;
use function defined;
/**
* Driver that connects through pdo_pgsql
*
* Forked original PostgreSQL driver,extended to have a possibility to pass raw PDO DSN to be
* able to connect via Unix socket
*/
class PostgreSQLDoctrineDriver extends Driver
{
/**
* {@inheritdoc}
*/
public function connect(array $params,$username = null,$password = null,array $driverOptions = [])
{
try {
$pdo = new PDOConnection(
$_SERVER['POSTGRES_DB_PDO_DSN'] ?? '',$username,$password,$driverOptions
);
if (defined('PDO::PGSQL_ATTR_DISABLE_PREPARES')
&& (! isset($driverOptions[PDO::PGSQL_ATTR_DISABLE_PREPARES])
|| $driverOptions[PDO::PGSQL_ATTR_DISABLE_PREPARES] === true
)
) {
$pdo->setAttribute(PDO::PGSQL_ATTR_DISABLE_PREPARES,true);
}
/* defining client_encoding via SET NAMES to avoid inconsistent DSN support
* - the 'client_encoding' connection param only works with postgres >= 9.1
* - passing client_encoding via the 'options' param breaks pgbouncer support
*/
if (isset($params['charset'])) {
$pdo->exec('SET NAMES \'' . $params['charset'] . '\'');
}
return $pdo;
} catch (PDOException $e) {
throw DBALException::driverException($this,$e);
}
}
/**
* {@inheritdoc}
*/
public function getName()
{
return 'pdo_pgsql';
}
}
,
您可以通过unix_socket
配置选项来配置套接字,该选项自一段时间以来似乎已经可用:https://symfony.com/doc/current/reference/configuration/doctrine.html
,
您可以将套接字路径作为主机,例如:
doctrine:
dbal:
host: /var/pgsql_socket
本文链接:https://www.f2er.com/3146896.html