Installation - Moodle 3.10.8+ (Build: 20211203)

Installation - Moodle 3.10.8+ (Build: 20211203)

Andrzej Kuzel -
回帖数：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





平均分： -
回复Andrzej Kuzel

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

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
平均分： -
回复Andrzej Kuzel

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

Leon Stringer -
Core developers的头像 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.

平均分：Useful (2)
回复Andrzej Kuzel

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

Sergio Rabellino -
Particularly helpful Moodlers的头像 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.
平均分： -
回复Sergio Rabellino

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

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
平均分： -
回复Sergio Rabellino

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

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)
平均分： -