Installation - Moodle 3.10.8+ (Build: 20211203)

Installation - Moodle 3.10.8+ (Build: 20211203)

by Andrzej Kuzel -
Number of replies: 6
hello,
Installation - Moodle 3.10.8+ (Build: 20211203)

Moodle 3.10.8+ (Build: 20211203)

For information about this version of Moodle, please see the online Release Notes

Server checks

Name Information Report Plugin Status
unicode

OK
database mariadb (5.5.5-10.6.5-MariaDB)
OK
php

OK
pcreunicode

OK
php_extension iconv
OK
php_extension mbstring
OK
php_extension curl
OK
php_extension openssl
OK
php_extension tokenizer
OK
php_extension xmlrpc
OK
php_extension soap
OK
php_extension ctype
OK
php_extension zip
OK
php_extension zlib
OK
php_extension gd
OK
php_extension simplexml
OK
php_extension spl
OK
php_extension pcre
OK
php_extension dom
OK
php_extension xml
OK
php_extension xmlreader
OK
php_extension intl
OK
php_extension json
OK
php_extension hash
OK
php_extension fileinfo
OK
php_setting memory_limit
OK
php_setting file_uploads
OK
php_setting opcache.enable
OK
Your server environment meets all minimum requirements.

Went I  click "continue" - i have this issue"


System

DDL sql execution error

More information about this error

It is usually not possible to recover from errors triggered during installation, you may need to create a new database or use a different database prefix if you want to retry the installation.

.

.

.

Stack trace:

line 492 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrownline 1098 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()line 77 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()line 427 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()line 372 of /lib/ddl/database_manager.php: call to database_manager->install_from_xmldb_structure()line 1795 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()line 276 of /admin/index.php: call to install_core()
---------

this is a new installation, i created a new base and still the same problem
please help





Average of ratings: -
In reply to Andrzej Kuzel

Odp: Installation - Moodle 3.10.8+ (Build: 20211203)

by Andrzej Kuzel -
cat /etc/redhat-release
Rocky Linux release 8.5 (Green Obsidian)

chmod 775 -R /var/www/html/moodle
chown apache:apache -R /var/www/html/moodle

chmod 770 -R /var/www/html/moodledata
chown apache:apache -R /var/www/html/moodledata
Average of ratings: -
In reply to Andrzej Kuzel

Re: Odp: Installation - Moodle 3.10.8+ (Build: 20211203)

by Leon Stringer -
Picture of Core developers Picture of Particularly helpful Moodlers

If you have MariaDB 10.6.x then this could be MDL-72131. Try adding innodb_read_only_compressed=OFF to the MariaDB configuration file (possibly /etc/my.cnf) and restarting MariaDB. Or run SET GLOBAL innodb_read_only_compressed=OFF to change it on the fly.

Average of ratings: Useful (2)
In reply to Leon Stringer

Odp: Re: Odp: Installation - Moodle 3.10.8+ (Build: 20211203)

by Andrzej Kuzel -
it's works smile
Thank you very much for your help
Average of ratings: -
In reply to Andrzej Kuzel

Ri: Installation - Moodle 3.10.8+ (Build: 20211203)

by Sergio Rabellino -
Picture of Particularly helpful Moodlers Picture of Plugin developers
The most probable cause is about missing grants for the database user.
Please check that the dbuser has the rights permissions to create/alter tables in moodle's database.
Average of ratings: -
In reply to Sergio Rabellino

Odp: Ri: Installation - Moodle 3.10.8+ (Build: 20211203)

by Andrzej Kuzel -
I use this:
MariaDB [(none)]> CREATE DATABASE moodledb;
MariaDB [(none)]> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE TEMPORARY TABLES,DROP,INDEX,ALTER ON moodledb.* TO 'moodleadmin'@'localhost' IDENTIFIED BY 'Your-PassWD';
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> exit
Average of ratings: -
In reply to Sergio Rabellino

Odp: Ri: Installation - Moodle 3.10.8+ (Build: 20211203)

by Andrzej Kuzel -
MariaDB [(none)]> SHOW GRANTS FOR 'moodleuser'@'localhost';
+---------------------------------------------------------------------------------------------------------------------------------------+
| Grants for moodleuser@localhost |
+---------------------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO `moodleuser`@`localhost` IDENTIFIED BY PASSWORD '*----------------------------------------------------------------------------------------------' |
| GRANT ALL PRIVILEGES ON `moodle`.* TO `moodleuser`@`localhost` WITH GRANT OPTION |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES ON `moodledb`.* TO `moodleuser`@`localhost` |
+---------------------------------------------------------------------------------------------------------------------------------------+
3 rows in set (0.000 sec)
Average of ratings: -