Modifying my.cnf

Modifying my.cnf

by Chat Kras -
Number of replies: 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!

Average of ratings: -
In reply to Chat Kras

Re: Modifying my.cnf

by Mathieu Petit-Clair -
Picture of Core developers Picture of Moodle HQ Picture of MoodleCloud team Picture of Plugin developers Picture of 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

In reply to Mathieu Petit-Clair

Re: Modifying my.cnf

by 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.


In reply to Chat Kras

Re: Modifying my.cnf

by Mathieu Petit-Clair -
Picture of Core developers Picture of Moodle HQ Picture of MoodleCloud team Picture of Plugin developers Picture of 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

In reply to Mathieu Petit-Clair

Re: Modifying my.cnf

by 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 ...