Installing the mysql2 gem on ubuntu 20.04

[axos88]

There seems to be an openssl incompatibility between chef and the system, which used to be solved by the mysql2_chef_gem cookbook, but that hasn't been updated in a while. Is there a better way to install the mysql2 gem to be used by chef?

[ramereth]

@axos88 AFAIK this cookbook no longer uses the mysql2 so this shouldn't be a problem anymore. We removed it exactly for this reason.

[axos88]

That's great, but as far as I see the cookbook does not provide a way to run SQL queries against the server either (to create and grant privileges to users and databases AND to initialize the db schema). I was looking to do that using the database cookbook, but this means that's not an option either.

Is there something i overlooked?

[ramereth]

@axos88 this was actually just added in #655