CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 2.1 Release Testing »
  • Multi language error
Pages: [1]

Author Topic: Multi language error  (Read 3205 times)

Neil Adair

  • I post occasionally
  • **
  • Posts: 78
  • Karma: 4
  • CiviCRM version: 4.5.8
  • CMS version: Drupal 7
  • MySQL version: MariaDB 10
  • PHP version: 5.5 FPM
Multi language error
August 21, 2008, 09:04:56 am
CiviCRM 2.1 a4 Drupal 6.4

After enabling Multiple Languages in civicrm/admin/setting/localization with no problem if I try to enable a second language I get a back trace and error.

Database Error Code: Access denied; you need the SUPER privilege for this operation, 1227

[debug_info] => DROP TRIGGER IF EXISTS civicrm_custom_group_i18n [nativecode=1227 ** Access denied; you need the SUPER privilege for this operation]

I'm guessing that the mysql user for the civicrm db needs "SUPER" privilege. I usually GRANT "ALL" privileges, is SUPER not included?

Can I just GRANT that user SUPER privilege in addition?

Thanks

Neil

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Multi language error
August 21, 2008, 10:45:36 am
Neil - Based on the help text on the Localization settings form, I'm pretty sure you'll need to add the privilege:

"In order to use this functionality, the installation's database user must have privileges to create triggers (in MySQL 5.0 this means the SUPER privilege)."

Evidently the create triggers privilege assignment is different for different MySQL versions (and I think will be part of ALL in 5.1). Piotr is a bit more up to speed on this - or you can probably verify from the MySQL docs.
Protect your investment in CiviCRM by  becoming a Member!

Piotr Szotkowski

  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Multi language error
August 22, 2008, 03:27:33 am
Quote from: Neil Adair on August 21, 2008, 09:04:56 am
After enabling Multiple Languages in civicrm/admin/setting/localization with no problem if I try to enable a second language I get a back trace and error.

Database Error Code: Access denied; you need the SUPER privilege for this operation, 1227

As Dave pointed out, MySQL 5.0 requires the SUPER privilege to create triggers. This is fixed in MySQL 5.1 (with the introduction of the TRIGGER privilege), and recoding the triggres on the PHP side would be tons of work which really belongs to the database.

I’ll try to code some checks for the SUPER privilege so that you can’t actually enable multi-lang support without it (rather than ending up with this error and, most probably, a non-working database).
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

Neil Adair

  • I post occasionally
  • **
  • Posts: 78
  • Karma: 4
  • CiviCRM version: 4.5.8
  • CMS version: Drupal 7
  • MySQL version: MariaDB 10
  • PHP version: 5.5 FPM
Re: Multi language error
August 22, 2008, 09:16:59 am
I finally got this to work after a lot of MySQL syntax errors. It turns out the SUPER privilege can't be granted at the database level, only globally. At least, that is how I got MySQL to accept the command. SUPER also gives a syntax error if PRIVILEGES is included in the command, go figure! So:

GRANT SUPER ON *.* TO 'database_user'@'localhost' IDENTIFIED BY 'password';

worked for MySQL 5.03

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 2.1 Release Testing »
  • Multi language error

This forum was archived on 2017-11-26.