Welcome, Guest
Username: Password: Remember me

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

What MySQL user privileges are required LimeSurvey to run? 1 year 8 months ago #91795

  • Sweden
  • Sweden's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 64
  • Thank you received: 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
Last Edit: 1 year 8 months ago by c_schmitz.
The administrator has disabled public write access.

Re: What MySQL user privileges are required by the limesurvey to run? 1 year 8 months ago #91800

  • c_schmitz
  • c_schmitz's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 789
  • Thank you received: 113
  • Karma: 92
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!
The administrator has disabled public write access.
The following user(s) said Thank You: Sweden

Re: What MySQL user privileges are required by the limesurvey to run? 1 year 8 months ago #91814

  • Sweden
  • Sweden's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 64
  • Thank you received: 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.
Last Edit: 1 year 8 months ago by Sweden.
The administrator has disabled public write access.

Re: What MySQL user privileges are required by the limesurvey to run? 1 year 8 months ago #91822

  • Sweden
  • Sweden's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 64
  • Thank you received: 1
  • Karma: 2
c_schmitz wrote:
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
Last Edit: 1 year 8 months ago by Sweden.
The administrator has disabled public write access.

Re: What MySQL user privileges are required by the limesurvey to run? 1 year 7 months ago #92077

  • c_schmitz
  • c_schmitz's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 789
  • Thank you received: 113
  • Karma: 92
Add 'Select', too.
Support us, too. Donate to the LimeSurvey project and help keep us going!
The administrator has disabled public write access.

Re: What MySQL user privileges are required by the limesurvey to run? 1 year 7 months ago #92089

  • Sweden
  • Sweden's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 64
  • Thank you received: 1
  • Karma: 2
Thanks - That seems to work :)
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.113 seconds
Donation Image