[debian-mysql] help fixing cacti to work with MariaDB

[Paul Gevers]

Hi all,
[Please CC me, I am not subscribed].

Recently I started to look into how to fix bug 813422¹ "cacti can't be
installed on MariaDB server". It seems that I can work-around/fix the
issue "Specified key was too long; max key length is 1000 bytes" by
changing the sql template for the database by adding a "collate
ascii_general_ci" in three places (see attached patch).

Now I expect that this is the result of defaults for collation being
different on MariaDB than they were (and are?) on MySQL. Before I start
bugging upstream I like to know if I am correct in this understanding
and if this is something Debian specific or MariaDB specific.

Does the fix/work-around sound remotely sane?

Thanks for your time and effort.

Paul

¹ https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=813422
-------------- next part --------------
A non-text attachment was scrubbed...
Name: enable_MariaDB.patch
Type: text/x-patch
Size: 1453 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20160225/d6df4a6c/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 473 bytes
Desc: OpenPGP digital signature
URL: <http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20160225/d6df4a6c/attachment.sig>