Hi @Bettelstab,

Thanks for your report.
@eternoendless, @PrestaShop/prestashop-core-developers what do you think of this issue?

Best regards, Khouloud

@Bettelstab For the moment you can try to change doctrine configuration in your config.yml file and add these options (do not remove the current configuration).

# Doctrine Configuration
doctrine:
  dbal:
    options:
      MYSQL_ATTR_SSL_CA : %ca_cert%
      MYSQL_ATTR_SSL_KEY : %private_key%
      MYSQL_ATTR_SSL_CERT : %public_cert%

@PierreRambaud
Thanks! I tried that, but it didn't seem to work. I didn't put too much effort there, though, since I had to do it in a hacky way anyway, so I didn't debug it properly. Even if it works, there are still cases where doctrine is not used and it throws an error then without the change I described above.

I was struggling for two days to connect prestashop to my ssl secured remote database. I added PDO::MYSQL_ATTR_SSL_KEY, PDO::MYSQL_ATTR_SSL_CERT and MYSQL_ATTR_SSL_CA as suggested in opening post and it works now. Thanks @Bettelstab !

So it could be great if this can be configured in config files without hacking prestashop core.

Edit: Solution from @PierreRambaud doesn't work here either. I tried to add the config to default connection options too, without success. I tried with const names and values (1009, 1008, 1007) without luck.

Hi,

Any findings? @maxtorete , you when you said it Works, you mean the website but not the /admin site, true? any findings?

Regards,

Hi,

Any findings? @maxtorete , you when you said it Works, you mean the website but not the /admin site, true? any findings?

Regards,

I finished that project long time ago, and finally as we didn't want to hack with PrestaShop core we moved to local database.

So I'm sorry but I can't remember if /admin was working or not, but I far as I can remember, I think both were working fine with @Bettelstab hack. I think I didn't make any changes to /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php, only /classes/db/DbPDO.php was hacked.

Regards,
Juan

I see, thanks @maxtorete for your reply.
I've finally managed to make it work (there's a bug on prestashop's code).

@evmimagina Could you tell us more about the PrestaShop bug? :)

Hello,
Since we had no news from you for more than 30 days, I'll close this ticket to avoid cluttering up the backlog. Please note that you can always create a new one if further information pops up.

Thank you

@PierreRambaud do you have a guide on how to connect to DB with SSL ?

@florine2623 why is this closed ?

@thbl it's written:

Since we had no news from you for more than 30 days, I'll close this ticket to avoid cluttering up the backlog. Please note that you can always create a new one if further information pops up.

No news for more than 30 days -> ticket is closed. Here there was no news for 6 months. We cannot keep open tickets where author does not provide informations.

I renamed this issue for a better title, this is a request for improvement.

We have no guide on how to connect to DB with SSL.

If you find that this improvement is critical for you, and it's important to have it built ASAP, then you can invest into having it done. PrestaShop is an open source, community project. You can hire a developer or sysadmin to find how to do this, or if you are a developer yourself, you can try doing it on your own.

The most important thing is to share that fix with everyone by submitting a Pull Request to devdocs or an improvement to the codebase -- that's what the open source spirit is all about.