SQLSTATE[08006] [7]无法将主机名“dbname=”转换为地址。

Question

我正在使用Symfony/Silex SecurityServiceProvider来登录用户网站。

http://silex.sensiolabs.org/doc/providers/security.html

我按照指南一步一步操作，但当我提交登录表单时，出现了PostgreSQL错误。

SQLSTATE[08006] [7] could not translate host name "dbname=" to address

无论我设置什么dbname，我仍然得到错误。即使是正确的远程服务器IP。但是我的设置是好的，因为我使用相同的类来连接和请求服务器，并且它总是工作的。

错误只出现在提交登录表单时！

我的登录类：

<?php

namespace Model;

use Silex\Application;

abstract class Entity {

    private $app;
    private $host;
    private $base;
    private $port;
    private $user;
    private $pass;
    private $charset;

    public function __construct(Application $app)
    {
        $this->app = $app;

        $this->host    = $app['config']['database']['host'];
        $this->base    = $app['config']['database']['base'];
        $this->port    = $app['config']['database']['port'];
        $this->user    = $app['config']['database']['user'];
        $this->pass    = $app['config']['database']['pass'];
        $this->charset = $app['config']['database']['charset'];
    }

    protected function connectBDD()
    {
        $connect = new \PDO("pgsql:host=$this->host;dbname=$this->base", $this->user, $this->pass);
        $connect->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
        $connect->query("SET NAMES '$this->charset'");

        return $connect;
    }
}
}

感谢您的帮助。

- Macbernie

Answer 1

您的配置值为空。 $app['config']['database']['host'] 为空，连接看起来像这样 $connect = new \PDO("pgsql:host=;dbname=", ...);
尝试转储配置以查看值

public function __construct(Application $app)
{
    dump($app['config']['database']);
    ...
}

- Max P.