问Symfony 3.3.12从亚马逊网络服务/ RDS Maria DB 10.0迁移失败: DBALException
EN

Stack Overflow用户

提问于 2018-06-23 18:54:04

回答 1查看 581关注 0票数 0

我正在尝试使用基于MariaDb MariaDB 10.0.24的Amazon RDS数据库迁移安装在亚马逊网络服务上的Symfony 3.3.12制作的API

在我的日志中获取以下内容：

[2018-06-23 18:22:52] request.INFO: Matched route "api_login_check". {"route":"api_login_check","route_parameters":{"_route":"api_login_check"},"request_uri":"https://api.excellenting.com/api/login_check","method":"POST"} []
[2018-06-23 18:22:54] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occured while establishing a connection to figure out your platform version. You can circumvent this by setting a 'server_version' configuration value  For further information have a look at: https://github.com/doctrine/DoctrineBundle/issues/673" at /home/ubuntu/symfony_backend/vendor/doctrine/doctrine-bundle/ConnectionFactory.php line 96 {"exception":"[object] (Doctrine\\DBAL\\DBALException(code: 0): An exception occured while establishing a connection to figure out your platform version.\nYou can circumvent this by setting a 'server_version' configuration value\n\nFor further information have a look at:\nhttps://github.com/doctrine/DoctrineBundle/issues/673 at /home/ubuntu/symfony_backend/vendor/doctrine/doctrine-bundle/ConnectionFactory.php:96, Doctrine\\DBAL\\Exception\\ConnectionException(code: 0): An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused at /home/ubuntu/symfony_backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:108, Doctrine\\DBAL\\Driver\\PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /home/ubuntu/symfony_backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:47, PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /home/ubuntu/symfony_backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43)"} []
[2018-06-23 18:53:39] request.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "No route found for "HEAD /"" at /home/ubuntu/symfony_backend/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/EventListener/RouterListener.php line 123 {"exception":"[object] (Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException(code: 0): No route found for \"HEAD /\" at /home/ubuntu/symfony_backend/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/EventListener/RouterListener.php:123, Symfony\\Component\\Routing\\Exception\\ResourceNotFoundException(code: 0):  at /home/ubuntu/symfony_backend/var/cache/prod/appProdProjectContainerUrlMatcher.php:1585)"} []

嗯，我没有看到或者我不理解关于这方面的相关信息。

但我正在调查，我看到一个Syfony 3.3 Doctrine manual谈到了这个问题，进一步的搜索显示MariaDB 10.2.7和更高版本的问题。

好吧，我在原来的API上将MariaDb降级到相同的版本：

好吧，我已经编辑了app/config/config.yml尝试5.6a5.2(这是用mysql -Version返回的逻辑值

# Doctrine Configuration
doctrine:
    dbal:
        driver:   pdo_mysql
        host:     "%database_host%"
        port:     "%database_port%"
        dbname:   "%database_name%"
        user:     "%database_user%"
        password: "%database_password%"
        server_version: 5.6
        charset:  UTF8

壳

mysql -Version
mysql  Ver 15.1 Distrib 10.0.35-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

配置上的凭据是正确的，请尝试使用端口3306、主机到本地主机的不同版本...

parameters:
    database_host: 127.0.0.1
    database_port: null
    database_name: c1farid
    database_user: c1fariduser
    database_password: CorrectPassWorD

symfony

doctrine

dbal

在线客服搭建方案

搭建集AI机器人、在线客服、智能外呼等多功能服务的客服系统，支持快速接入及自搭建客服系统，从而让顾客快速得到解答

回答 1

Stack Overflow用户

发布于 2018-06-25 14:00:44

更简单。

bin/console cache:clear --env=prod
// Clearing the cache for the prod environment with debug false


[OK] Cache for the "prod" environment (debug=false) was successfully cleared.