Symfony2 Doctrine PDO MySQL 连接与 LOAD DATA LOCAL INFILE-php问题

Symfony2 Doctrine PDO MySQL Connection with LOAD DATA LOCAL INFILE(Symfony2 Doctrine PDO MySQL 连接与 LOAD DATA LOCAL INFILE)

本文介绍了Symfony2 Doctrine PDO MySQL 连接与 LOAD DATA LOCAL INFILE的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

为什么我有这个问题?

Warning: PDO::query(): LOAD DATA LOCAL INFILE forbidden in /srv/www/project/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php on line 742

这是我的配置.

#app/config/config.yml
doctrine:
    dbal:
        driver:   %database_driver%
        host:     %database_host%
        port:     %database_port%
        dbname:   %database_name%
        user:     %database_user%
        password: %database_password%
        charset:  UTF8
        options:
            "PDO::MYSQL_ATTR_LOCAL_INFILE": true

    orm:
        auto_generate_proxy_classes: %kernel.debug%
        auto_mapping: true

我尝试了没有引导的选项.

I tried the options without leading .

如果我使用它，效果很好！

AND if i use this, it works great!

/* @var DoctrineDBALConnection $connection */
$dbhost = $this->getContainer()->getParameter('database_host');
$dbuser = $this->getContainer()->getParameter('database_user');
$dbpass = $this->getContainer()->getParameter('database_password');
$dbname = $this->getContainer()->getParameter('database_name');

$connection = new PDO('mysql:host=' . $dbhost . ';dbname=' . $dbname, $dbuser, $dbpass, array(PDO::MYSQL_ATTR_LOCAL_INFILE => true));

我如何使用来自 symfony2 的学说而不是自己的新 PDO $connection.

我不知道为什么学说会忽略选项......或者说教义不能将选项转换为常量/整数?

I dont know why doctrine ignore the options... Or cant Doctrine convert the options to the Constant/Integer?

推荐答案

尝试并解决.

#app/config/config.yml
doctrine:
    dbal:
        driver:   %database_driver%
        host:     %database_host%
        port:     %database_port%
        dbname:   %database_name%
        user:     %database_user%
        password: %database_password%
        charset:  UTF8
        options:
            1001: true

    orm:
        auto_generate_proxy_classes: %kernel.debug%
        auto_mapping: true

教义选项不应该是一个常数^^

使用 1001 代替 "PDO::MYSQL_ATTR_LOCAL_INFILE" 解决了问题.

Use 1001 instead "PDO::MYSQL_ATTR_LOCAL_INFILE" fixed the problem.

这篇关于Symfony2 Doctrine PDO MySQL 连接与 LOAD DATA LOCAL INFILE的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！