mahara-contributors team mailing list archive

[Ghada El-Zoghbi <ghada@xxxxxxxxxxxxxxx>]

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

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1237198

Title:
  Make Elasticsearch plugin work with MySQL

Status in Mahara ePortfolio:
  In Progress

Bug description:
  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.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1237198/+subscriptions