I think I understand what you are saying, but how do I add the ssl cert and how do I check what MYSQL_ATTR_SSL_CA evaluates to?
On Thu, Jun 27, 2019 at 6:59 PM Benjamin Eberlei <[email protected]> wrote: > You need to add the AWS SSL certificates to the PDO connection to make it > work. > > In symfon ythis means this configuration for DBAL Connection. you need to > check what this translates to when creating via > DriverManager::getConnection() > > options: > MYSQL_ATTR_SSL_CA: > "%kernel.root_dir%/config/rds-combined-ca-bundle.pem" > > > On Thu, Jun 27, 2019 at 9:28 PM Nathaniel Goodwin <[email protected]> > wrote: > >> This is within the Symfony Doctrine framework. Database connection has to >> be initiated through the configuration. I will test manually connecting and >> let you know what the result is! >> >> >> On Thu, Jun 27, 2019 at 3:26 PM Marco Pivetta <[email protected]> wrote: >> >>> $pdo = new PDO(/* parameters */); >>> >>> var_dump($pdo->query('SELECT 1')->fetch()); >>> >>> Marco Pivetta >>> >>> http://twitter.com/Ocramius >>> >>> http://ocramius.github.com/ >>> >>> >>> On Thu, Jun 27, 2019 at 9:22 PM Nathaniel Goodwin <[email protected]> >>> wrote: >>> >>>> I am able to connect via the ubuntu bsh command line and I am able to >>>> connect via a previous version of my API which uses Symfony 3.x and >>>> previous versions of doctrine. >>>> It is only from Symfony 4.2 and updated doctrine (my new API) that the >>>> connection issue arises. >>>> >>>> What do you mean by connect via plain PDO? >>>> >>>> >>>> >>>> On Thursday, June 27, 2019 at 3:12:32 PM UTC-4, Marco Pivetta wrote: >>>>> >>>>> Are you able to connect with plain PDO? >>>>> >>>>> Marco Pivetta >>>>> >>>>> http://twitter.com/Ocramius >>>>> >>>>> http://ocramius.github.com/ >>>>> >>>>> >>>>> On Thu, Jun 27, 2019 at 9:03 PM Nathaniel Goodwin <[email protected]> >>>>> wrote: >>>>> >>>>>> Using >>>>>> >>>>>> ``` >>>>>> "php": "^7.1.3", >>>>>> "doctrine/doctrine-bundle": "^1.11", >>>>>> "doctrine/doctrine-fixtures-bundle": "^3.1", >>>>>> "doctrine/doctrine-migrations-bundle": "^2.0", >>>>>> "doctrine/orm": "^2.6", >>>>>> "friendsofsymfony/oauth-server-bundle": "^1.6", >>>>>> "friendsofsymfony/rest-bundle": "^2.5", >>>>>> "friendsofsymfony/user-bundle": "^2.1", >>>>>> "jms/serializer-bundle": "^3.3", >>>>>> "symfony/asset": "4.2.*", >>>>>> "symfony/yaml": "4.2.*" >>>>>> ``` >>>>>> >>>>>> I cannot seem to get my configuration correct to connect my Symfony >>>>>> Doctrine PHP API to my MySQL database on AWS DB instance. I am running >>>>>> Ubuntu 16+ on all my instances. I am able to connect my local API to my >>>>>> local MySQL without any problems, and I am able to connect my testing >>>>>> server in the same way, but when I move to my production server on AWS, >>>>>> and >>>>>> I try to run the following: >>>>>> >>>>>> ``` >>>>>> php bin/console doctrine:schema:update --force --env=prod --complete >>>>>> ``` >>>>>> >>>>>> I get the following error: >>>>>> >>>>>> ``` >>>>>> In AbstractMySQLDriver.php line 93: An exception occurred in driver: >>>>>> SQLSTATE[HY000] [2002] No such file or directory >>>>>> ``` >>>>>> >>>>>> I have tried multiple configuration settings and many searches, but >>>>>> in almost all cases the issues were with settings using localhost versus >>>>>> 127.0.0.1, and that is not my issue as I am trying to connect from an AWS >>>>>> EC2 (hosting my API) to an AWS DB instance. >>>>>> >>>>>> I have checked multiple times and my username, database, password, >>>>>> and path configurations are correct, I have tested them via manual login >>>>>> to >>>>>> the DB instance. >>>>>> >>>>>> Here is the config in my config/packages/doctrine.yaml >>>>>> >>>>>> ``` >>>>>> >>>>>> doctrine: >>>>>> dbal: >>>>>> # configure these for your database server >>>>>> driver: 'pdo_mysql' >>>>>> server_version: '5.7' >>>>>> charset: utf8 >>>>>> default_table_options: >>>>>> charset: utf8 >>>>>> collate: utf8_unicode_ci >>>>>> host: ' >>>>>> api-database.XXXXXXXXXXX.ca-central-1.rds.amazonaws.com' >>>>>> port: '3306' >>>>>> dbname: 'XXXXXXX' >>>>>> user: 'XXXXX' >>>>>> password: 'XXXXXXXXXXXXXXXXXXXXXXX' >>>>>> orm: >>>>>> auto_generate_proxy_classes: true >>>>>> naming_strategy: doctrine.orm.naming_strategy.underscore >>>>>> auto_mapping: true >>>>>> mappings: >>>>>> App: >>>>>> is_bundle: false >>>>>> type: annotation >>>>>> dir: '%kernel.project_dir%/src/Entity' >>>>>> prefix: 'App\Entity' >>>>>> alias: App >>>>>> monolog: >>>>>> handlers: >>>>>> main: >>>>>> type: stream >>>>>> path: '%kernel.logs_dir%/%kernel.environment%.log' >>>>>> level: debug >>>>>> channels: ['!event'] >>>>>> >>>>>> ``` >>>>>> >>>>>> -- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "doctrine-user" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>> send an email to [email protected]. >>>>>> To post to this group, send email to [email protected]. >>>>>> Visit this group at https://groups.google.com/group/doctrine-user. >>>>>> To view this discussion on the web visit >>>>>> https://groups.google.com/d/msgid/doctrine-user/4d8b86ce-61e5-4c8c-a685-83c68eea8c91%40googlegroups.com >>>>>> <https://groups.google.com/d/msgid/doctrine-user/4d8b86ce-61e5-4c8c-a685-83c68eea8c91%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>> . >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "doctrine-user" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> To post to this group, send email to [email protected]. >>>> Visit this group at https://groups.google.com/group/doctrine-user. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/doctrine-user/a388a9a7-98d5-469a-ae4a-782d72ee9010%40googlegroups.com >>>> <https://groups.google.com/d/msgid/doctrine-user/a388a9a7-98d5-469a-ae4a-782d72ee9010%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "doctrine-user" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at https://groups.google.com/group/doctrine-user. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/doctrine-user/CADyq6s%2BamcDPWOBmy%3DmW-OrT8Af85_x8cYZqXXBRj%3D2cUN-LQg%40mail.gmail.com >>> <https://groups.google.com/d/msgid/doctrine-user/CADyq6s%2BamcDPWOBmy%3DmW-OrT8Af85_x8cYZqXXBRj%3D2cUN-LQg%40mail.gmail.com?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> -- >> Nathaniel Goodwin >> Fitchek | Lead Developer >> 28 Deakin Street, Suite 202, Ottawa ON Canada >> [email protected] | fitchek.com >> Office: 613.627.4364 >> >> -- >> You received this message because you are subscribed to the Google Groups >> "doctrine-user" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at https://groups.google.com/group/doctrine-user. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/doctrine-user/CAOfeQDBwu8ugqYvYecLftXV6B8C1zzgWKb1QV5DGrWn83L4raA%40mail.gmail.com >> <https://groups.google.com/d/msgid/doctrine-user/CAOfeQDBwu8ugqYvYecLftXV6B8C1zzgWKb1QV5DGrWn83L4raA%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> For more options, visit https://groups.google.com/d/optout. >> > -- > You received this message because you are subscribed to the Google Groups > "doctrine-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/doctrine-user. > To view this discussion on the web visit > https://groups.google.com/d/msgid/doctrine-user/CAEPJdukLa%3DKkHGcNRa-k0oqSbh%2B%2BRzo4tjVj1pFKci_dK_PJFg%40mail.gmail.com > <https://groups.google.com/d/msgid/doctrine-user/CAEPJdukLa%3DKkHGcNRa-k0oqSbh%2B%2BRzo4tjVj1pFKci_dK_PJFg%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Nathaniel Goodwin Fitchek | Lead Developer 28 Deakin Street, Suite 202, Ottawa ON Canada [email protected] | fitchek.com Office: 613.627.4364 -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/doctrine-user. To view this discussion on the web visit https://groups.google.com/d/msgid/doctrine-user/CAOfeQDBUYFFjJgaGWmFb9rjmFCgEX9QOHWPvwCnfszLMJc2%2BVg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
