Make Elasticsearch plugin work with MySQL

[Aaron Wells]

The Elasticsearch plugin currently only works in Postgres. The reason, is that it's dependent upon a series of triggers which were non-trivial to port to MySQL, and the organizations funding the development of the plugin were only using Postgres.

However, it should be a relatively easy job for someone familiar with MySQL triggers to port it over.

[Ghada El-Zoghbi (ghada-z)]

Have committed the changes for review:

https://reviews.mahara.org/#/c/2593/

[Ghada El-Zoghbi (ghada-z)]

Have submitted fixes after code review and testing:

https://reviews.mahara.org/#/c/2593/

[Ghada El-Zoghbi (ghada-z)]

Developer Note:

MySql triggers -

An INSERT BEFORE triggers will not pass the autoincrement ID in the NEW row (i.e. ID is an autoincrement column).

Use an INSERT AFTER trigger to get the value of NEW.ID.

[Son Nguyen (ngson2000)]

Hi Ghada;

Are you aiming for MySQL 5.0.10+?

[Ghada El-Zoghbi (ghada-z)]

Hi Son,

I've only tested it on 5.5.22 (ubuntu) and 5.5.33a-MariaDB.

But, support for 5.0 has ended:
http://dev.mysql.com/doc/refman/5.0/en/index.html

Is there a requirement to support 5.0.10?

[Aaron Wells (u-aaronw)]

Hi Ghada,

The 1.8 release documents only claim to support MySQL 5.1 and later. And I've added an item to the next dev meeting ( https://wiki.mahara.org/index.php/Developer_Area/Developer_Meetings/29 ) to discuss raising that to 5.5 at the next dev meeting.

Cheers,
Aaron

[Ghada El-Zoghbi (ghada-z)]

Hi Aaron,

Good plan!

Cheers,
Ghada

[Ghada El-Zoghbi (ghada-z)]

Aaron,

For MySql 5.5, SUPER privilege is not enough to create/drop triggers. The user must have 'TRIGGER' permissions or 'ALL PRIVELEGE'.

Before MySql 5.1.6, the 'TRIGGER' permission did not exist and the user had to have 'SUPER' permissions.

Do we want to make MySql 5.1.6 the minumum supported version?

Ghada