[request-tracker-maintainers] Bug#986707: rt4-db-mysql: should declare an incompatibility with mysql 8

[Andrew Ruthven]

Hey,

Good news, we don't need to worry about trying to backport the fix or adjust
the dependencies. 4.4.7beta1 adds support for MySQL 8.

I'm updating the RT5 packages currently for 5.0.5beta1, and will work on
updating the RT4 packages for 4.4.7beta1 in the next few days.

Cheers,
Andrew

On Sun, 2023-08-20 at 00:16 +0200, Ángel wrote:
> On 2023-08-19 at 15:52 +1200, Andrew Ruthven wrote:
> > Perhaps we should explicitly depend on the mariadb packages. Thinking
> > about this is a bit further, this does seem the best option.
> 
> I was initially thinking on changing the dependency from virtual-mysql-
> server to mariadb-server | mysql-server << 8.0, but the mysql package name
> is versioned (mysql-server-8.0), so that would be equivalent to what you
> mention.
> 
> However, this won't work, since this is a suggests, not a depends. With
> good reason, since the database server doesn't need to (and on
> production systems it usually won't) be in the same machine as the web
> server.
> 
> Which also means the remote db server may get upgraded to MySQL 8
> despite a conflicts.
> 
> I think the proper solution would be to backport
> https://github.com/bestpractical/rt/commit/573f3353394ea3a8b90493a249a8ab8
> e15af5bb1
> 
> it appears somewhat big (16 files changed, 84 insertions, 31
> deletions), but it's just a bunch of trivial changes to ensure the name
> of the table Groups gets quoted in MySQL 8 (MySQL 8 made Groups a
> reserved keyword).
> 
> The patch applies cleanly on top of rt-4.4.6 and it should just work™
> 
> Regards
> 
> 
> 
> _______________________________________________
> pkg-request-tracker-maintainers mailing list
> pkg-request-tracker-maintainers at alioth-lists.debian.net
> https://alioth-lists.debian.net/cgi-bin/mailman/listinfo/pkg-request-
> tracker-maintainers

-- 
Andrew Ruthven, Wellington, New Zealand
andrew at etc.gen.nz         |
Catalyst Cloud:           | This space intentionally left blank
 https://catalystcloud.nz |