Opened 10 years ago
Last modified 11 days ago
#43431 new enhancement
Ports with mysql4 or mysql5 variants and/or dependencies should switch to using mysql57+ or mariadb.
Description (last modified by davidnich (David Nichols))
The following ports have variants and/or dependencies on mysql5:
==== Ports which require maintainer approval ==== - apr-util (geeklair.net:dluke): - libdbi-drivers (umich.edu:mta): - libgda (landonf): - lighttpd (ryandesign): - mysql-connector-odbc (pixilla): - mysql5 (ryandesign,pixilla): - mysql55-lib_mysqludf_json (pixilla): - mysqlxx (genetikayos.com:kayos): - php (ryandesign): - php4 (ryandesign): - php52 (ryandesign): - radlib (mbclark): - rb-mysql (freebsd.org:roberto): - restund (db.org:aeh): - vpopmail (yahoo.com:compconsultant): ==== Ports with openmaintainer ==== - dovecot (jberry,openmaintainer): - dspam (pixilla,openmaintainer): - libgda4 (devans,openmaintainer): - libgda5 (jwa,devans,openmaintainer): - mnogosearch (gmail.com:dbraband,openmaintainer): - mysql55-connector-cpp (pixilla,openmaintainer): - neko (ryandesign,openmaintainer): - ocaml-mysql (mww,openmaintainer): - pure-ftpd (pixilla,openmaintainer): - qt3-mac (blair,openmaintainer): - qt4-mac-mysql55-plugin (michaelld,pixilla,openmaintainer): - soci (rmh.de:g.lorenz,openmaintainer): - zabbix2 (eborisch,openmaintainer): ==== Ports with nomaintainer ==== - bugzilla (nomaintainer): - exim (nomaintainer): - flow-tools (nomaintainer): - freeradius (nomaintainer): - gdal (nomaintainer): - grass (nomaintainer): - hydra (nomaintainer): - mediatomb (): - nagios-plugins (nomaintainer): - pennmush (nomaintainer): - php5-mysql (nomaintainer): - py-oursql (nomaintainer): - rb19-mysql (nomaintainer): - snort (nomaintainer): - sphinx (nomaintainer): - vtk-devel (nomaintainer): - zabbix (nomaintainer):
Ports where mysql5 has been removed:
- akonadi - amarok-devel (port obsolete) - dbslayer - dovecot2 (pixilla,openmaintainer): Port removed - drupal5: Port removed - drupal6: Port removed - libzdb-mysql55 - lighttpd-devel (ryandesign): Port removed - p5-dbd-mysql (nomaintainer): See #44484. - postfix - proftpd (nomaintainer): - py-mysql - qore-mysql-module (davidnichols): - redland (pixilla,openmaintainer): - wikkawiki (wikkawiki.org:brian):
Attachments (2)
Change History (84)
comment:1 Changed 10 years ago by pixilla (Bradley Giesbrecht)
Description: | modified (diff) |
---|
comment:2 follow-ups: 3 4 Changed 10 years ago by danielluke (Daniel J. Luke)
comment:3 follow-up: 5 Changed 10 years ago by pixilla (Bradley Giesbrecht)
Replying to dluke@…:
apr-util has other mysql variants - are we removing mysql5 variants now? Is there a standard way we're deprecating them?
One goal should be to have mysql5 replaced_by mysql51 so for ports that cannot use a more modern mysql they would have their dependencies changed from mysql5 to mysql51.
That said, mysql51 is the same version (5.1.72) as mysql5 and pretty ancient. I believe we should settle on a MacPorts "default" mysql port and encourage subports and/or variants when other mysql versions are desired. I appears to me that many distros are choosing mariadb as their default. If we choose mariadb as our default perhaps we should rename mariadb to mariadb55 before we modify all these mysql5 dependent ports. I would am fine with and might prefer mariadb (the founder of mysql is behind mariadb) as the "default" MacPorts mysql port.
A standard way for variants might be:
# Removing mysql5 variant # variant mysql5 {} variant mysql51 {...} variant mysql55 {...} variant mysql56 {...} variant mariadb55 {...} variant percona56 {...} if {[variant_isset mysql5]} { default_variants.append mariadb55 }
comment:4 Changed 10 years ago by ryandesign (Ryan Carsten Schmidt)
Replying to dluke@…:
apr-util has other mysql variants - are we removing mysql5 variants now? Is there a standard way we're deprecating them?
- mysql56 variants should be added where missing.
- mariadb and percona ports and variants should be renamed to be versioned.
- mysql5 variants should be auto-upgraded to mysql51 variants ("
variant mysql5 requires mysql51 description {Legacy compatibility variant} {}
"), this way users using mysql5 databases only need to move their database to a different directory to be able to continue using mysql51 (or, if just checking if the variant is set, without defining the variant, correctly upgrades users in that manner, then that's fine) - mysql56 (or mariadb (or mariadb55 if we rename it)) should be the default variant (which would apply for new installations, not upgrades)
- Alternately we could auto-upgrade mysql5 to mysql56 or mariadb (or mariadb55 if we rename it), but then the user might have to do additional steps other than just moving the files (e.g. running upgrade scripts). The whole reason why we have versioned MySQL (and PostgreSQL and BerkeleyDB) ports is so that users can decide when to upgrade to newer versions that require such extra steps.
comment:5 Changed 10 years ago by ryandesign (Ryan Carsten Schmidt)
Replying to pixilla@…:
I appears to me that many distros are choosing mariadb as their default.
MariaDB (whatever the variant for the latest version thereof is called) would be my first choice for default.
comment:9 Changed 10 years ago by NicosPavlov
Description: | modified (diff) |
---|
comment:14 Changed 10 years ago by pixilla (Bradley Giesbrecht)
Description: | modified (diff) |
---|
comment:15 Changed 10 years ago by mf2k (Frank Schima)
Cc: | markd@… removed |
---|---|
Version: | 2.2.1 |
comment:16 Changed 10 years ago by mf2k (Frank Schima)
Description: | modified (diff) |
---|---|
Port: | amarok-devel apr-util bugzilla dovecot dovecot2 drupal5 drupal6 dspam exim flow-tools freeradius gdal grass hydra libdbi-drivers libgda libgda4 libgda5 lighttpd lighttpd-devel mediatomb mnogosearch mysql-connector-odbc mysql5 mysql55-connector-cpp mysql55-lib_mysqludf_json mysqlxx nagios-plugins neko ocaml-mysql p5-dbd-mysql pennmush pficommon php php4 php5-mysql php52 postfix proftpd pure-ftpd py-oursql qore-mysql-module qt3-mac qt4-mac-mysql55-plugin radlib rb-mysql rb19-mysql redland restund snort soci sphinx vpopmail vtk-devel wikkawiki zabbix zabbix2 added |
comment:17 follow-up: 25 Changed 10 years ago by humem (humem)
Cc: | hum@… removed |
---|---|
Description: | modified (diff) |
Port: | pficommon removed |
comment:21 Changed 10 years ago by mf2k (Frank Schima)
Description: | modified (diff) |
---|
comment:22 Changed 10 years ago by petrrr
Cc: | vince@… added |
---|
Vincent, I add you here to CC as maintainer of gdal.
comment:23 Changed 10 years ago by NicosPavlov
Description: | modified (diff) |
---|
Moving amarok-devel which is obsolete (amarok has default variant on mariadb55).
comment:25 follow-up: 27 Changed 9 years ago by pokui@…
comment:26 Changed 9 years ago by pixilla (Bradley Giesbrecht)
Summary: | Ports with a mysql5 variants and/or dependencies should switch to using mysql56 or possibly mariadb. → Ports with a mysql4 or mysql5 variants and/or dependencies should switch to using mysql56 or possibly mariadb. |
---|
comment:27 Changed 9 years ago by pixilla (Bradley Giesbrecht)
comment:28 Changed 9 years ago by mojca (Mojca Miklavec)
Can someone please provide an example of how the dependencies and variants should be implemented in an ideal case?
How exactly should we modify ports that depend on mysql5
? Should we support automated migration? (I see that monarch
is missing in the list of ports.)
comment:30 Changed 6 years ago by BjarneDMat
Cc: | BjarneDMat added |
---|
comment:31 Changed 6 years ago by pmetzger (Perry E. Metzger)
Ryan, would you be able to provide an example (as per Mojca's question above)? Then volunteers could go through and fix all the related ports.
comment:32 follow-up: 33 Changed 6 years ago by ryandesign (Ryan Carsten Schmidt)
It would be great if the names of the variants were consistent in all ports. Until the introduction of the mariadb-10.0 port, that was easy: we just made the variant name the same as the name of the port that the variant depended on (e.g. "mysql5" or "mysql57"). But we can't name a variant "mariadb-10.0" because "-" and "+" are illegal characters in variant names, because MacPorts uses "-" and "+" to indicate disabling and enabling variants, respectively.
"." was an illegal character in variant names too, but we couldn't figure out a reason why, so as of MacPorts 2.4.4 that's no longer illegal. See #46807.
So we need to make a decision on what the variant names should be. For ports like mariadb-10.0, the obvious variant name choices are "mariadb10.0" and "mariadb100". The former avoids ambiguity and is probably the better choice. Avoiding ambiguity is probably why Bradley chose to name the port "mariadb-10.0" instead of "mariadb100". I think using the dot in the variant name is what we wanted to do awhile back, but couldn't do until the unnecessary variant name restriction in base was relaxed.
We might also ask whether anything should be done about the older ports mariadb, mysql51, mysql55, mysql56, mysql57. Should they be renamed to mariadb-5.5, mysql-5.1, mysql-5.5, mysql-5.6, mysql-5.7, or left alone? Should variants that use those ports be renamed to mariadb5.5, mysql5.1, mysql5.5, mysql5.6, mysql5.7, or left alone? It would be good to make that decision before adding variants to a lot of ports, so that we don't have to rename them all again later. Renaming them would be good for consistency, but might be a lot of work, especially if we want to add automatic upgrade paths that keep the old variant names around for awhile.
Existing variants for other versioned ports—like gcc, clang, php, python, perl, ruby—don't use a dot in the variant name. But none of them have reached a major version number of 10 or greater yet. gcc is close, since they're developing version 9 now, but back in version 5 they changed their version numbering scheme so that the major version was only the first number of the version, not the first two numbers. So we used to have variants gcc48 and gcc49, but now we have variants gcc5 and gcc6. Even when gcc reaches version 10, we'll just name the variant gcc10; no need for a dot. PostgreSQL made the same version numbering change when they release version 10. MySQL has skipped from version 5.7 to version 8; not sure what their versioning strategy is going forward. Percona seems to express their version number is a modifier of the MySQL version number, so I don't know if we should be offering separate Percona ports for each MySQL version.
Once we decide variant names, we can propose code that creates those variants. So far, most of the mysql variants I've seen have been manually created. This can become inconvenient when each variant has to duplicate similar code that varies only by version number or include paths. Python variants are often created programmatically, using a loop, so that the code unique to the port that tells the build system where MySQL is doesn't have to be duplicated. We can probably adapt the Python-variant-generating code for MySQL.
Changed 6 years ago by ryandesign (Ryan Carsten Schmidt)
Attachment: | bacula.diff added |
---|
example of proposed general purpose mysql/postgresql/sqlite variant generating code
comment:33 Changed 6 years ago by ryandesign (Ryan Carsten Schmidt)
Replying to ryandesign:
We can probably adapt the Python-variant-generating code for MySQL.
But we would probably have to make such code accommodate multiple database systems—at least MySQL, PostgreSQL and SQLite. Consider the bacula port, which has variants client_only mysql51 mysql55 postgresql83 postgresql84 sqlite3, all of which conflict with one another. (The client_only variant is probably evidence of a missed opportunity to offer separate client and server subports.)
See bacula.diff for proposed code that accommodates this.
Changed 6 years ago by ryandesign (Ryan Carsten Schmidt)
Attachment: | py-oursql.diff added |
---|
a simpler example of the proposed db-variant-generation code
comment:34 Changed 6 years ago by mf2k (Frank Schima)
Cc: | mf2k added |
---|
comment:36 Changed 6 years ago by chrstphrchvz (Christopher Chavez)
Cc: | chrstphrchvz added |
---|
comment:37 Changed 6 years ago by mf2k (Frank Schima)
Description: | modified (diff) |
---|
comment:38 Changed 6 years ago by mf2k (Frank Schima)
Description: | modified (diff) |
---|
comment:39 Changed 5 years ago by chrstphrchvz (Christopher Chavez)
drupal5
and drupal6
were deleted: [a744fe1c98/macports-ports] [5ce3c6b5ff/macports-ports]
comment:40 Changed 5 years ago by chrstphrchvz (Christopher Chavez)
Cc: | chrstphrchvz removed |
---|
comment:41 Changed 5 years ago by chrstphrchvz (Christopher Chavez)
Cc: | chrstphrchvz added |
---|
comment:42 Changed 5 years ago by MarcusCalhoun-Lopez (Marcus Calhoun-Lopez)
Cc: | seanasy@… removed |
---|
comment:43 Changed 5 years ago by mf2k (Frank Schima)
Description: | modified (diff) |
---|
comment:44 Changed 5 years ago by mf2k (Frank Schima)
Cc: | yattenator@… removed |
---|---|
Description: | modified (diff) |
See #58254.
comment:45 Changed 5 years ago by chrstphrchvz (Christopher Chavez)
comment:46 Changed 5 years ago by chrstphrchvz (Christopher Chavez)
Note that MySQL 5.6 has ended support for macOS early (2018-10-19).
comment:47 Changed 5 years ago by mf2k (Frank Schima)
Summary: | Ports with a mysql4 or mysql5 variants and/or dependencies should switch to using mysql56 or possibly mariadb. → Ports with mysql4 or mysql5 variants and/or dependencies should switch to using mysql57+ or mariadb. |
---|
comment:48 Changed 5 years ago by chrstphrchvz (Christopher Chavez)
comment:49 Changed 5 years ago by chrstphrchvz (Christopher Chavez)
comment:50 Changed 5 years ago by petrrr
Cc: | petrrr removed |
---|
comment:51 Changed 5 years ago by chrstphrchvz (Christopher Chavez)
comment:52 Changed 5 years ago by chrstphrchvz (Christopher Chavez)
comment:53 Changed 4 years ago by jmroot (Joshua Root)
Cc: | jmroot removed |
---|---|
Description: | modified (diff) |
Port: | postfix removed |
Postfix's mysql5 variant was removed in [4b7e410e15c6c15a2e2173317c28e2447b6e6291/macports-ports].
comment:54 Changed 4 years ago by iEFdev
comment:55 Changed 4 years ago by chrstphrchvz (Christopher Chavez)
comment:56 Changed 4 years ago by chrstphrchvz (Christopher Chavez)
comment:57 Changed 4 years ago by iefdev (Eric F)
Cc: | iefdev added |
---|
comment:58 Changed 4 years ago by mf2k (Frank Schima)
dovecot2 deleted in changeset:a6b5be761983a1aa33f715140b4e1e976aa95b80/macports-ports
comment:59 Changed 4 years ago by mf2k (Frank Schima)
Description: | modified (diff) |
---|
comment:60 Changed 4 years ago by bakoontz (Brian Koontz)
The wikkawiki port (and parent project) is no longer being maintained, so it can be removed from macports. Reference: https://github.com/bakoontz/WikkaWiki
comment:61 Changed 4 years ago by chrstphrchvz (Christopher Chavez)
wikkawiki
was already switched to mysql57
: [319283d339/macports-ports]
comment:62 Changed 4 years ago by mf2k (Frank Schima)
Description: | modified (diff) |
---|
comment:63 Changed 3 years ago by chrstphrchvz (Christopher Chavez)
Note that as of 2020-10-19 MySQL 8 is the only version supported upstream on macOS (and only for 10.14 and later): https://www.mysql.com/support/eol-notice.html
comment:64 Changed 3 years ago by chrstphrchvz (Christopher Chavez)
comment:65 Changed 2 years ago by chrstphrchvz (Christopher Chavez)
vtk-devel was deleted: [d6fb15727681/macports-ports]
comment:66 Changed 18 months ago by nilason (Nicklas Larsson)
In https://trac.macports.org/changeset/7996592e8516814dceff4e21b362acd07fcca00c/macports-ports
grass: obsolete, replaced by grass7
mysql5 variant was removed.
comment:67 Changed 17 months ago by nilason <n_larsson@…>
comment:68 Changed 13 months ago by petrrr
Cc: | petrrr added |
---|
comment:69 Changed 12 months ago by chrstphrchvz (Christopher Chavez)
comment:70 Changed 12 months ago by chrstphrchvz (Christopher Chavez)
comment:71 follow-up: 73 Changed 12 months ago by bakoontz (Brian Koontz)
WikkaWiki is no longer maintained and can be removed from MacPorts.
comment:72 Changed 10 months ago by Schamschula (Marius Schamschula)
Port: | gdal grass removed |
---|
comment:73 Changed 5 months ago by ryandesign (Ryan Carsten Schmidt)
Cc: | brian@… removed |
---|---|
Port: | pure-ftpd wikkawiki removed |
Replying to bakoontz:
WikkaWiki is no longer maintained and can be removed from MacPorts.
comment:74 Changed 5 months ago by ryandesign (Ryan Carsten Schmidt)
comment:75 Changed 5 months ago by ryandesign (Ryan Carsten Schmidt)
comment:76 Changed 5 months ago by ryandesign (Ryan Carsten Schmidt)
comment:77 Changed 5 months ago by ryandesign (Ryan Carsten Schmidt)
comment:78 Changed 5 months ago by ryandesign (Ryan Carsten Schmidt)
comment:79 Changed 5 months ago by ryandesign (Ryan Carsten Schmidt)
comment:80 Changed 5 months ago by ryandesign (Ryan Carsten Schmidt)
comment:81 Changed 5 months ago by davidnich (David Nichols)
Description: | modified (diff) |
---|
comment:82 Changed 11 days ago by mf2k (Frank Schima)
Cc: | mf2k removed |
---|
apr-util has other mysql variants - are we removing mysql5 variants now? Is there a standard way we're deprecating them?