Foreman » Installer

Fixes #22940 - Ensure the PG root cert is installed

When a remote database is used the postgres server is not managed. This
meant that the certificate was not placed. It's moved to the config
since it's a client config that always needs to happen.

Fixes #20079 - SSL secured and verified PGSQL connection

To setup DB with SSL and verification use params:
db_sslmode => 'verify-full',
db_root_cert => 'ca_bundle.pem'

Default DB sslmode is 'prefer' - non-verified SSL with fallback to
non-SSL. To use SSL secured connection with CA verification sslmode...

Rely on puppetlabs-postgresql for Role -> Database relation

https://github.com/puppetlabs/puppetlabs-postgresql/commit/a246e586be016c99d521a8796c24f8fe7ca5c4e2
added the relation Role -> Database.

don't use qualified call to defined resource type

- resource names are not limited by scope.
- it is considered a bad practice in Puppet 3
- it isn't tolerated anymore in Puppet 4.

closes GH-386

Refs #11681 - Explicitly use UTF-8 as postgres database encoding

Use absolute variables

Fix support for mysql by removing inclusion of mysql class which was removed by puppetlabs/mysql in version 3.0.0

Partial puppet-lint fixes

Work with puppetlabs-postgresql version 3+

This drops support for puppet 2.6.

Fixed order of user, database and role creation