Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:

THEMA: What MySQL user privileges are required LimeSurvey to run?

What MySQL user privileges are required LimeSurvey to run? 1 Jahr 7 Monate her #91795

  • Sweden
  • Swedens Avatar
  • OFFLINE
  • Senior Lime
  • Beiträge: 64
  • Dank erhalten: 1
  • Karma: 2
Hi,

I want to increase security and only give specific privileges to my limesurvey MySQL user. Right now it is set to "GRANT ALL PRIVILEGES ON" - I would like to change that, if possible.
What privileges are required as a minimum by the limesurvey to run without problems?

Thanks
Letzte Änderung: 1 Jahr 7 Monate her von c_schmitz.
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: What MySQL user privileges are required by the limesurvey to run? 1 Jahr 7 Monate her #91800

  • c_schmitz
  • c_schmitzs Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 755
  • Dank erhalten: 104
  • Karma: 88
Insert/update/delete/create/alter/drop/index should be the minimum permissions.
Support us, too. Donate to the LimeSurvey project and help keep us going!
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Folgende Benutzer bedankten sich: Sweden

Re: What MySQL user privileges are required by the limesurvey to run? 1 Jahr 7 Monate her #91814

  • Sweden
  • Swedens Avatar
  • OFFLINE
  • Senior Lime
  • Beiträge: 64
  • Dank erhalten: 1
  • Karma: 2
Thanks - I try that. Perhaps you know the answer to my other question found in this thread (link) - that issue seems to be a rather big security risk if left unfixed and may affect all old and new installations of LimeSurvey.
Letzte Änderung: 1 Jahr 7 Monate her von Sweden.
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: What MySQL user privileges are required by the limesurvey to run? 1 Jahr 7 Monate her #91822

  • Sweden
  • Swedens Avatar
  • OFFLINE
  • Senior Lime
  • Beiträge: 64
  • Dank erhalten: 1
  • Karma: 2
c_schmitz schrieb:
Insert/update/delete/create/alter/drop/index should be the minimum permissions.

Hmmm.... it doesn't work. Now I get an "Internal Server Error" when I try to log into admin panel. Something about settings_global that can't be found...
I tried to revert to "all privileges", and then it works again but that isn't a solution.

What else do I need to choose? Here are all the options:

ALTER, CREATE ROUTINE, CREATE VIEW, DROP, INDEX, LOCK TABLES, SELECT, TRIGGER, CREATE, CREATE TEMPORARY TABLES, DELETE, EXECUTE, INSERT, REFERENCES, SHOW VIEW, UPDATE
Letzte Änderung: 1 Jahr 7 Monate her von Sweden.
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: What MySQL user privileges are required by the limesurvey to run? 1 Jahr 6 Monate her #92077

  • c_schmitz
  • c_schmitzs Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 755
  • Dank erhalten: 104
  • Karma: 88
Add 'Select', too.
Support us, too. Donate to the LimeSurvey project and help keep us going!
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: What MySQL user privileges are required by the limesurvey to run? 1 Jahr 6 Monate her #92089

  • Sweden
  • Swedens Avatar
  • OFFLINE
  • Senior Lime
  • Beiträge: 64
  • Dank erhalten: 1
  • Karma: 2
Thanks - That seems to work :)
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Moderatoren: ITEd
Ladezeit der Seite: 0.129 Sekunden
Donation Image