doesn't support encrypted database connections

[fcevado]

Describe the bug

if you start MySQL with --ssl mode enabled writefreely won't connect to the database.

Steps to reproduce (if necessary)

Steps to reproduce the behavior:

1. start MySQL with --ssl mode.
2. run writefreely --config and set the proper database credentials
3. writefreely will error try to connect to the databse with this authentication plugin is not supported

Expected behavior

What should've happened?
During the config I'd expect it to ask if it will require ssl mode or not and be able to work properly with it.

Application configuration

• Single mode or Multi-user mode? Multi-user mode
• Database? [mysql/sqlite] MySQL
• Open registration? [yes/no] no
• Federation enabled? [yes/no] yes

Version or last commit:
0.11.2

[thebaer]

Thanks for reporting this! A simple fix will probably involve:

• Adding a new DatabaseCfg flag that enables TLS / SSL
• If that flag is true, include &tls=true in the database connection string: https://github.com/writeas/writefreely/blob/e51e58386ebd7299f5f18de1ab6aee6c057f968c/app.go#L751
  • (Really, you can include &tls=true or &tls=false, where true / false is the value of the config flag)

This is a pretty straightforward fix, so please feel free to submit a pull request for it!