Sakai and newer versions of mysql

[Mateu Llas Rubio]

Hi.

Recently some discussion has been initiated about to which version of
mysql or mariadb should Sakai evolve:
https://www.dr-chuck.com/csev-blog/2021/03/should-sakai-evolve-towards-mysql-8-0-or-maria-db-10/

In our local instances that we use in UdL for test purposes we have
downloaded 21.x and master code.
We compile and deploy this code in our local machines against a mysql.
Recently we have updated our machines and mysql has been automatically
updated to 8 version and, for that reason, we have initiated our Sakai
21.x and master instances against mysql 8 and we have detected an issue.

Running with auto.ddl = true to generate the tables in databases generated
an error with table TASKS. It seems that in Mysql 8 version, SYSTEM is a
reserved keyword and can't be used as column name. For this reason, we
suggest to avoid this column name if Mysql 8 is chosen for the evolution.

We have changed to MariaDB version 10.3.25-MariaDB and apparently
instances run well against this database.

Hope this can help,

Mateu Llas

[Mark Lobjoit]

In the past I have had issues with mysql and both sakai and MDID.

It is always worth checking the mysql version release readme and googling issues and many can be avoided by changing parameters/switches in the install scripts.

I have not seen this particular problem you are facing but just pointing out that there may be workarounds if you look for them...

My apologies if I am teaching Grandma to suck eggs ;-)

--
You received this message because you are subscribed to the Google Groups "Sakai Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sakai-dev+...@apereo.org.
To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/sakai-dev/994cab4f983ab69e4af103aba2a46f17.squirrel%40correusquirrel.udl.cat.

[Miguel Pellicer]

Hi Mateu,

I installed Sakai Master after more than a year and found the same issue, reported in https://jira.sakaiproject.org/browse/SAK-45512and resolved it here https://github.com/sakaiproject/sakai/pull/9264

Regards

To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/sakai-dev/CADzbQVXqa22kE%2Bt%2B02aMOEE7recWn14OqiCWHNkvTco9tUKFeA%40mail.gmail.com.

-- 
-----------------------------------------------
Miguel Pellicer
CTO at EDF

Website: https://www.edf.global
LinkedIn: https://www.linkedin.com/in/mpellicer-edf
Office Phone: +34 - 96 381 35 75
Request a meeting here: https://calendly.com/mpellicer
-----------------------------------------------

[Miguel Pellicer]

https://jira.sakaiproject.org/browse/SAK-45512

[Mateu Llas Rubio]

Thanks for the patch, Miguel.

Our workaround was to use MariaDB version 10.3.25, Mark, with that
database there was no issue but I think the correct option is Miguel's
patch to avoid problems in future database upgrades.

Regards,
Mateu

>>> <mailto:sakai-dev%2Bunsu...@apereo.org>.

>>> To view this discussion on the web visit
>>> https://groups.google.com/a/apereo.org/d/msgid/sakai-dev/994cab4f983ab69e4af103aba2a46f17.squirrel%40correusquirrel.udl.cat

>>> <https://groups.google.com/a/apereo.org/d/msgid/sakai-dev/994cab4f983ab69e4af103aba2a46f17.squirrel%40correusquirrel.udl.cat>.

>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Sakai Development" group.
>>> To unsubscribe from this group and stop receiving emails from it,
>>> send an email to sakai-dev+...@apereo.org

>>> <mailto:sakai-dev+...@apereo.org>.

>>> To view this discussion on the web visit

>>> https://groups.google.com/a/apereo.org/d/msgid/sakai-dev/CADzbQVXqa22kE%2Bt%2B02aMOEE7recWn14OqiCWHNkvTco9tUKFeA%40mail.gmail.com
>>> <https://groups.google.com/a/apereo.org/d/msgid/sakai-dev/CADzbQVXqa22kE%2Bt%2B02aMOEE7recWn14OqiCWHNkvTco9tUKFeA%40mail.gmail.com?utm_medium=email&utm_source=footer>.

[Miguel Pellicer]

Hi Mateu,

The patch was approved and merged but I'm not sure it's final, it may
suffer changes. Since it will be in the nightly instances tomorrow I'd
like to test it in MySQL and Oracle.

Regards Miguel

[Mark Lobjoit]

Agreed. A patch is always better :-)

[Charles Severance]

This is cool - both the workaround and the patch.  It does emphasize the need to get a nightly mariadb - which is in the works.

/Chuck