sympa: offer mysql variants

[ryandesign (Ryan Carsten Schmidt)]

sympa depends on mysql5, which does not build on current OS X and will not be fixed. Newer versions of mysql exist in other ports and ports like sympa that use mysql should offer variants for choosing amongst them.

Does sympa even use mysql directly, or does it only use it indirectly via p5-dbd-mysql? If the latter, remove the mysql dependency entirely and let p5-dbd-mysql take care of it.

[dbevans (David B. Evans)]

Replying to ryandesign@…:

sympa depends on mysql5, which does not build on current OS X and will not be fixed. Newer versions of mysql exist in other ports and ports like sympa that use mysql should offer variants for choosing amongst them.

Does sympa even use mysql directly, or does it only use it indirectly via p5-dbd-mysql? If the latter, remove the mysql dependency entirely and let p5-dbd-mysql take care of it.

sympa uses indirect access via p5-dbi, the database being selected by the backend module although the documentation largely describes mysql. So your suggestion to depend on just p5-dbd-mysql makes sense except that it's default variant is also currently +mysql5.

I propose changing the p5-dbd-mysql default to +mysql56 (+mariadb, +percona?) and adding variants to sympa to allow p5-dbd-sqlite or p5-dbd-pg instead of p5-dbd-mysql if desired, all of which are supported. This should allow it to build on Yosemite.

Is +mysql56 the preferred default for ports that want to use mysql5 or perhaps +mariadb or +percona. Seems to be a mixture of these with other current ports.

[dbevans (David B. Evans)]

p5-dbd-mysql default variant changed to +mysql56 in r129343.
add variants +sqlite +postgresql and drop direct dependency on mysql5 in r129347.
default database is MySQL if no variants selected.
p5-dbd-mysql default variant determines MySQL version in this case.