Moodle Migration Error: Database connection failed - During Upgrade

chrisj 2020-10-02 15:07:33 UTC #1

Keywords: Moodle - AWS - Technical issue - Upgrade
bnsupport ID: 87da74a4-4150-1435-f781-badfcd83f158
Description:
Hello, and thanks in advance! I'm attempting to upgrade Moodle from ~3.6 to 3.9.2. I believe I'm near the end, and have ran into some issues with the database. I believe this is due to the different databases being used, the old being sqli and the new being mariadb, or perhaps something else within the config.php file. I have began looking at my apache logs (I've pasted the last few rows at the bottom) and various guides and other submitted questions which I will also link below. I have ran the support tool and am including the ID at the end.

Any questions, please let me know! Also, FYI, old stack is Approach B and new stack is Approach A.

User question I looked at

Bitnami Tool ID: 87da74a4-4150-1435-f781-badfcd83f158

chrisj 2020-10-02 15:46:44 UTC #2

Also I'd like to add that I am able to login via phpmyadmin.

chrisj 2020-10-02 18:16:01 UTC #3

I am able to access phpmyadmin using the root user. Must the credentials within the config.php file be of the user 'bn_moodle'?

jota 2020-10-05 08:32:28 UTC #4

Hi @chrisj,

Just to confirm, you are following the migration guide to move your site from one instance to another one, right?

https://docs.bitnami.com/aws/how-to/migrate-moodle/

We will work on reproducing the issue and will update this ticket and the documentation if necessary.

chrisj 2020-10-05 14:11:01 UTC #5

Hi jota,

Yes, following exactly that documentation you linked. Please let me know if you need anything else from me.

Chris

jota 2020-10-06 09:29:44 UTC #6

Hi @chrisj,

I got an error with the configuration when following the migration steps. That was due to some differences in the config.php file (the dataroot folder is different in the new version and you need to keep that change). In order to solve the problem, I copied the config.php file before removing the moodle and moodledata folders in the step 3

sudo cp /bitnami/moodle/config.php ~/

You will later need to copy the config.php file back to the moodle folder and configure the permissions. After finishing with the process, the application showed the test course I created in the previous deployment

chrisj 2020-10-06 18:25:55 UTC #7

That worked! Thank you very much @jota .

chrisj 2020-10-06 19:10:11 UTC #8

So, appears that all course information is there, and I've verified the mdl_user table contains the previous users. But I'm not able to get logged in using any account. Any idea?

chrisj 2020-10-06 19:44:58 UTC #9

Forgive me for multiple posts, but after further research I am convinced it has to do with us using the Adaptable theme and something regarding the login token not being present on the theme? I have checked the theme versions, and it appears both are up to date at version 2.2.X. On the new instance, it appears the Adaptable theme is NOT being applied.

jota 2020-10-07 09:19:52 UTC #10

Hi @chrisj,

I followed the migration process again and everything went fine. I could also login to the application using the "old" user's credentials and confirmed that the information is in the mdl_user table as well.

I suggest you take a look at the Apache's log to see if there is any error there that helps you debug the issue.

https://docs.bitnami.com/aws/apps/moodle/troubleshooting/debug-errors-apache/

If not, I'd contact the Moodle's developers to know if there is any extra step you need to perform to complete the migration of your data.

https://moodle.org/mod/forum/

chrisj 2020-10-07 18:02:07 UTC #11

Solved! I'm rather embarrassed to say that it appears a setting that allowed us to login via email was disabled, which is what I had been used to. So upon, using the username instead... I was able to get in. Thanks again for your speedy resolution.

jota 2020-10-08 09:33:34 UTC #12

I'm really happy to hear that!

Enjoy!

system 2020-10-22 09:33:38 UTC #13

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.

vikram-bitnami 2020-12-16 09:45:30 UTC #14

Thanks for pointing this out. We have updated the guide to clarify this point: https://docs.bitnami.com/aws/how-to/migrate-moodle/

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!