Builds on MySQL are broken on Xenial

[abias]

Travis has changed their default OS version from Trusty to Xenial which does not start mysql anymore by default - see https://blog.travis-ci.com/2019-04-15-xenial-default-build-environment

According to https://docs.travis-ci.com/user/database-setup/#mysql, you have now to add

services:
  - mysql

to your .travis.yml.

As an alternative, you could also

dist: trusty

but this seems not to make much sense to me as Trusty has reached its end of life.

[luukverhoeven]

The same issue occurs with postgres
https://travis-ci.org/MFreakNL/moodle-block-user_favorites/jobs/550213985

services:
- postgresql

Starting service postgresql doesn't solves this issue. Any clues?

[abias]

Interesting. We do not have problems with postgres builds.
But we have postgres configured to use 9.4, not 9.3 as you have on https://github.com/MFreakNL/moodle-block-user_favorites/blob/MOODLE_35_STABLE/.travis.yml#L9. This aligns with .travis.dist.yml on https://github.com/blackboard-open-source/moodle-plugin-ci/blob/master/.travis.dist.yml#L7.

You might want to try to raise the postgres version, perhaps this solves your problem

[luukverhoeven]

Interesting. We do not have problems with postgres builds.
But we have postgres configured to use 9.4, not 9.3 as you have on https://github.com/MFreakNL/moodle-block-user_favorites/blob/MOODLE_35_STABLE/.travis.yml#L9. This aligns with .travis.dist.yml on https://github.com/blackboard-open-source/moodle-plugin-ci/blob/master/.travis.dist.yml#L7.

You might want to try to raise the postgres version, perhaps this solves your problem

Thanks, that solves the postgresql issue!

[mudrd8mz]

Many thanks @abias for this suggestion which I found working well in my own plugin. +1'ed