SSL configs for database

[pleegor]

Hi,

I am working on configuring connection to database over SSL and I will appreciate if somebody will help me to understand some config flags.

1. What does DB_SSL_IS_PAAS mean? PAAS-like service RDS from AWS or CloudSQL from GCP?
2. Is there is a specific format in which files used for DB_SSL_KEY_PATH, DB_SSL_CERT_PATH, and DB_SSL_CA_PATH should be stored in?

[stale[bot]]

Is this still relevant? We haven't heard from anyone in a bit. If so, please comment with any updates or additional detail.
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Don't take it personally, we just need to keep a handle on things. Thank you for your contributions!

[chksome]

Hey @pleegor Did you ever get this figured out? I'm having a very similar problem and wondering if a solution was ever found.

[stale[bot]]

Okay, it looks like this issue or feature request might still be important. We'll re-open it for now. Thank you for letting us know!

[pleegor]

I have not figured it out yet; instead I decided google cloud sql auth proxy but ill appreciate if someone could assist with this configuration.

[Ajedi32]

The code says those options are only relevant if you're using a MySQL database. DB_SSL_IS_PAAS doesn't seem to do anything other than stop all DB_SSL_* options from being passed aside from DB_SSL_CA_PATH:

https://github.com/snipe/snipe-it/blob/9a5d9eafebb80f1992ea2c38cd36d2256445475f/config/database.php#L93-L100

The other options all seem to get passed to PDO MySQL, though even the docs for that aren't particularly clear about what format the files need to be in: https://www.php.net/manual/en/ref.pdo-mysql.php

PHP: MySQL (PDO) - Manual