Modifying my.cnf

Modifying my.cnf

- Chat Kras の投稿
返信数: 4

Hello,

Is there a mean to modify this file for moodle cloud sites either directly or through the support team?

I have an error involving the database during the course restore process. This seems to be connected to the max_allowed_packet parameter defined in my.cnf according to forum posts:

https://moodle.org/mod/forum/discuss.php?d=353233

https://moodle.org/mod/forum/discuss.php?d=230681

Any help would be really welcomed!

Chat Kras への返信

Re: Modifying my.cnf

- Mathieu Petit-Clair の投稿
画像 Core developers 画像 Moodle HQ 画像 MoodleCloud team 画像 Plugin developers 画像 Testers

Hi Chat,

MoodleCloud does not run on MySQL, so this is not the issue you are having.

Are you possibly trying to restore a single activity backup as a course? This would need to be restored inside a course instead.

Can you give us more details about the course restore failure that happened? Please include the size of the backup file, which Moodle version created that course backup, along with the date/time when it happened (so we can look at the logs on our side) and if possible a list of the plugins that backup might contain data for.

Mathieu

Mathieu Petit-Clair への返信

Re: Modifying my.cnf

- Chat Kras の投稿

Hi Mathieu,

In fact I could not restore any of the courses I saved (from another moodle site) except one. But even when I suppressed this one and tried to restore it again, it failed!

Then I tried to restore courses partially (without participant data) and this time it succeeded for every courses so far. 

In the meanwhile, I have detected another problem, reported there: https://moodle.org/mod/forum/discuss.php?d=358319#p1475610

I suspect this 'Invalid user' error to be involved in the full restore of courses.


Chat Kras への返信

Re: Modifying my.cnf

- Mathieu Petit-Clair の投稿
画像 Core developers 画像 Moodle HQ 画像 MoodleCloud team 画像 Plugin developers 画像 Testers

Hi Chat,

How many users are present in that course backup? If there were more than the number allowed to your MoodleCloud site (50 for a free site), it would indeed break.

Mathieu

Mathieu Petit-Clair への返信

Re: Modifying my.cnf

- Chat Kras の投稿

Hi Mathieu,

We have the MoodleCloud for school mini pack with 100 users. In the courses we want to restore, 46 users are present at most.

The first restore was ok (and it has populated the user database) but after that it failed for each other courses. And when we have deleted the restored course we could not restore it again.
I suppose that each course restoration attempts to add again participants as users. 

When I restore courses without user data it is ok but I think I have a problem with the user database anyway. At least one account cannot be deleted ...