Stuck at Server Check during Moodle 3.3 installation

Stuck at Server Check during Moodle 3.3 installation

by Abhishek Mukherjee -
Number of replies: 8

Hi,

Please guide me how i can solve the issue faced during Moodle 3.3 installation. I am stuck at Server Check screen with following errors below:


Information Report Plugin Status
mysql_full_unicode_support#File_format

Your database has tables using Antelope as the file format. Full UTF-8 support in MySQL and MariaDB requires the Barracuda file format. Please convert the tables to the Barracuda file format. See the documentation Administration via command line for details of a tool for converting InnoDB tables to Barracuda.
Check
mysql_full_unicode_support#File_per_table

For full support of UTF-8 both MySQL and MariaDB require you to change your MySQL setting 'innodb_file_per_table' to 'ON'. See the documentation for further details.
Check
mysql_full_unicode_support#Large_prefix

For full support of UTF-8 both MySQL and MariaDB require you to change your MySQL setting 'innodb_large_prefix' to 'ON'. See the documentation for further details.
Check


The link to fix these errors are : https://docs.moodle.org/33/en/MySQL_full_unicode_support#Steps_to_upgrade


I have created the MySql database with utf8mb4_unicode_ci collation which i used during installation.




But i don't have any knowledge how to run access CLI and how to run these commands.

I have full access to the web hosting, server, database, ssh access.

Please guide me how to solve these issues.  I can't proceed with the installation.

Thanks.




Average of ratings: -
In reply to Abhishek Mukherjee

Re: Stuck at Server Check during Moodle 3.3 installation

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

Did you follow the links on those points? They give extra information.

I am not unsympathetic... there's a lot of people having problems with these database settings. If you are hosted you may well have to ask your host's support for advice. They may not even be able to provide these modes unfortunately. 

If you are running (probably Linux) with full command line access then you need to spend a bit of time getting familiar with basic command line usage. We could say, "type this", "type that", but I honestly don't think it's helping you. There are lots of resources on basic Linux use from the command line and it will save you a lot of time in the end. 

Average of ratings: -
In reply to Howard Miller

Re: Stuck at Server Check during Moodle 3.3 installation

by Abhishek Mukherjee -

Hi Howard,

Thanks for your prompt reply.

Yes, I have Linux hosting. Plesk Onyx. It's a dedicated server.

Version Plesk Onyx v17.5.3_build1705170317.16 os_Ubuntu 14.04

OS Ubuntu 14.04.5 LTS


I have followed that link and read it.

But my question is that how could i access CLI? from where do i access it?

I first need to open CLI to run the commands.


I am using a Windows desktop. Will Putty help?

Average of ratings: -
In reply to Abhishek Mukherjee

Re: Stuck at Server Check during Moodle 3.3 installation

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

Yep - you use PuTTY and then log in using ssh.

You should have been given instructions.

Average of ratings: -
In reply to Howard Miller

Re: Stuck at Server Check during Moodle 3.3 installation

by Abhishek Mukherjee -

Can i change the Mysql database settings required by moodle like : innodb_large_prtefix, file_per_table, etc through phpmyadmin ?


Average of ratings: -
In reply to Abhishek Mukherjee

Re: Stuck at Server Check during Moodle 3.3 installation

by Emma Richardson -
Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Plugin developers

Yes, you can mysql commands through phpmyadmin and through ssh.

Average of ratings: -
In reply to Emma Richardson

Re: Stuck at Server Check during Moodle 3.3 installation

by Abhishek Mukherjee -

please can you guide me how to run the commands through phpmyadmin, and what are the commands?

it will be really helpful.

Average of ratings: -
In reply to Abhishek Mukherjee

Re: Stuck at Server Check during Moodle 3.3 installation

by Rahul Rai -

Hi Joydeep

You need to put below code in your my.cnf file 


[client]
default-character-set = utf8mb4

[mysqld]
innodb_file_format = Barracuda
innodb_file_per_table = 1
innodb_large_prefix

character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
skip-character-set-client-handshake

[mysql]
default-character-set = utf8mb4
  • Restart your  server.

Average of ratings: -
In reply to Rahul Rai

Re: Stuck at Server Check during Moodle 3.3 installation

by Natacsha Ordones natacsha -

Commands on prompt


SET GLOBAL --innodb_file_format = barracada

SET GLOBAL --innodb_file_per_table = 1

Average of ratings: -