I love the new drag and drop capability in moodle 2.3, very nice. My co-worker reported problems trying to restore courses on our newly minted moodle servers. She reported an error while trying to restore a course, the specific error from mysql was "DDL sql execution error". My co-worker noted a detail in the error log about how the error could occur if the user does not have adequate privileges.
I had changed the user in config.php that moodle is using to connect to the db the day before. I granted a minimum set of privileges to the new user, for security reasons. I logged into each of the servers using phpMyAdmin and edited the user account granting Structure rights to create, alter, index, drop and create temporary tables. When I tried restoring a course again, I was in business.
Moral of the story? When you create new users to connect to MySql with, ensure they have the privileges necessary to perform restores!
No comments:
Post a Comment