A248 / LibertyBans

The be-all, end-all of discipline.
https://ci.hahota.net:8443/job/LibertyBans/
GNU Affero General Public License v3.0
165 stars 40 forks source link

add ssl support #269

Open Playsus1234 opened 3 months ago

Playsus1234 commented 3 months ago

I have confirmed that ...

Description

add ssl support

KoxSosen commented 2 months ago

Hello! LibertyBans already supports SSL, however it is not enabled by default. To enable it, you'll have to enable it both on the server, and on the side of LibertyBans. Here is how you do it in LibertyBans: Start by editing the sql.yml file. Look for the key that has the same name as the database as you are using, either mariadb or postgresl currently. Under any of these keys, please look for the connection-properties configuration list. Here, you may add any options specified by the JDBC connector used for the database.

For as an example, for MariaDB the connection properties are specified here, for PostgreSQL here.

To change the behavior of SSL for MariaDB, consider looking at the sslMode option. For PostgreSQL, this would be ssl. Of course these options alone aren't enough to configure a proper connection, please see the documentation for each option.

Additionally, please see the guides to enable ssl for MariaDB, and for PostgreSQL respectively.

KoxSosen commented 2 months ago

I forgot to mention that the connection properties list configuration under postgresl applies to CockroachDB too, as per the comment in the configuration.

A248 commented 1 month ago

As Simon mentioned, we give you the ability to change almost any connection property, including SSL settings. If you have more questions, feel free to post them. I'm going to close this issue for now -- you can still post if needed.