Step 1 — Installing Nginx on CentOS 7
Since Nginx is not available in default CentOS repositories, we will install EPEL repository by running this command:
yum install epel-release -y
Install nginx
yum install nginx -y
After installation completes, enable nginx start on boot and run it:
systemctl start nginx
systemctl enable nginx
Step 2 — Installing MySQL (MariaDB)
yum install mariadb-server mariadb -y
After finishing the installation, enable and start the service:
systemctl start mariadb
systemctl enable mariadb
Lastly, run initial setup script which will remove some of the default settings:
mysql_secure_installation
Step 3 — Installing PHP v7.0
yum install https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
yum install http://rpms.remirepo.net/enterprise/remi-release-7.rpm
Enable php70 repository:
yum install yum-utils -y
yum-config-manager --enable remi-php70
Secondly, install PHP package:
yum --enablerepo=remi,remi-php70 install php-fpm php-common
Install common modules:
yum --enablerepo=remi,remi-php70 install php-opcache php-pecl-apcu php-cli php-pear php-pdo php-mysqlnd php-pecl-memcache php-pecl-memcached php-gd php-mbstring php-mcrypt php-xml
Step 4 — Configuring Nginx to work with PHP 7
Create a new nginx configuration file:
vim /etc/nginx/conf.d/default.conf
Input this code:
server {
listen 80;
server_name your_server_ip;
# note that these lines are originally from the "location /" block
root /usr/share/nginx/html;
index index.php index.html index.htm;
location / {
try_files $uri $uri/ =404;
}
error_page 404 /404.html;
error_page 500 502 503 504 /50x.html;
location = /50x.html {
root /usr/share/nginx/html;
}
location ~ \.php$ {
try_files $uri =404;
fastcgi_pass unix:/var/run/php-fpm/php-fpm.sock;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
include fastcgi_params;
}
}
IMPORTANT! Replace your_server_ip with your actual server IP.
Save the file and restart nginx for change to take effect:
systemctl restart nginx
Now, open PHP-FPM configuration:
vim /etc/php-fpm.d/www.conf
Find and replace these lines:
user = apache to user = nginx
group = apache to group = nginx
listen.owner = nobody to listen.owner = nginx
listen.group = nobody to listen.group = nginx
And, lastly, under ;listen = 127.0.0.1:9000 add this line:
listen = /var/run/php-fpm/php-fpm.sock
Save the file again and finally, start php-fpm and enable it on boot:
systemctl start php-fpm.service
systemctl enable php-fpm.service
Create the database
CREATE DATABASE moodle DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
Create a user for moodle
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE TEMPORARY TABLES,DROP,INDEX,ALTER ON moodle.* TO 'moodleuser'@'localhost' IDENTIFIED BY 'yourpassword';
Create an empty directory to hold Moodle files. It must not be in the area served by the web server and must have permissions so that the web server user can write to it. Other than that it can be located anywhere. Typically, either make it owned by the web server user or give it write permissions for 'everyone'. If it is on a shared/NFS drive then read Caching - Moodle caches to this disk area by default and a slow share will mean terrible performance.
If you downloaded the zip or tgz file earlier, then unzip / untar / move / copy the Moodle code (obtained above) so that it will be served by your web server (e.g. on Debian based Linux, move to /var/www/html/moodle) Check the permissions and make sure that the web server does not have permissions to write to any of the files in the Moodle code directories (a very common root cause of sites being hacked). If you need to, configure your web server to serve the Moodle site with your chosen URL.
In the Moodle code directory, find the file config-dist.php and copy it to a new file called config.php (but read next step, 'Install Moodle', first). Edit config.php with your favourite editor and change the appropriate settings to point to your site, directories and database. Note: the Moodle install script will create config.php for you if it does not exist but make sure you (re-)set permissions appropriately afterwards
Go to the URL for your moodle site in a browser (installation will complete automatically) or run the command line version at (requires cli version of PHP):
/usr/bin/php /path/to/moodle/admin/cli/install.php
The CLI creates the config.php for you and will not run if you created one in the previous step.
After completing the install make sure your file permissions are ok for the Moodle program files (not writeable by web server) and the Moodle data files (writeable by web server).
You will need a cron job to run periodically. It is recommended that the cron is run every minute, as required for asynchronous activity deletion when using the recycle bin. A typical Unix cron entry will be as follows:
* * * * * /usr/bin/php /path/to/moodle/admin/cli/cron.php >/dev/null
Your site will not work properly unless cron is running regularly. It is very important you do not skip this step.
MariaDB [(none)]> SHOW variables LIKE "%innodb_file%";
+--------------------------+----------+
| Variable_name | Value |
+--------------------------+----------+
| innodb_file_format | Antelope |
| innodb_file_format_check | ON |
| innodb_file_format_max | Antelope |
| innodb_file_per_table | OFF |
+--------------------------+----------+
4 rows in set (0.00 sec)
MariaDB [(none)]> SET global innodb_file_format = barracuda;
Query OK, 0 rows affected (0.01 sec)
MariaDB [(none)]> SHOW variables LIKE "%innodb_file%";
+--------------------------+-----------+
| Variable_name | Value |
+--------------------------+-----------+
| innodb_file_format | Barracuda |
| innodb_file_format_check | ON |
| innodb_file_format_max | Antelope |
| innodb_file_per_table | OFF |
+--------------------------+-----------+
4 rows in set (0.00 sec)
MariaDB [(none)]> SET global innodb_file_format_max = barracuda;
Query OK, 0 rows affected (0.75 sec)
MariaDB [(none)]> SHOW variables LIKE "%innodb_file%";
+--------------------------+-----------+
| Variable_name | Value |
+--------------------------+-----------+
| innodb_file_format | Barracuda |
| innodb_file_format_check | ON |
| innodb_file_format_max | Barracuda |
| innodb_file_per_table | OFF |
+--------------------------+-----------+
4 rows in set (0.00 sec)
MariaDB [(none)]> SET global innodb_file_per_table = on;
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> SHOW variables LIKE "%innodb_file%";
+--------------------------+-----------+
| Variable_name | Value |
+--------------------------+-----------+
| innodb_file_format | Barracuda |
| innodb_file_format_check | ON |
| innodb_file_format_max | Barracuda |
| innodb_file_per_table | ON |
+--------------------------+-----------+
4 rows in set (0.00 sec)
MariaDB [(none)]> SHOW variables LIKE "%innodb_large%";
+---------------------+-------+
| Variable_name | Value |
+---------------------+-------+
| innodb_large_prefix | OFF |
+---------------------+-------+
1 row in set (0.00 sec)
MariaDB [(none)]> SET global innodb_large_prefix = on;
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> SHOW variables LIKE "%innodb_large%";
+---------------------+-------+
| Variable_name | Value |
+---------------------+-------+
| innodb_large_prefix | ON |
+---------------------+-------+
1 row in set (0.00 sec)
nginx.conf location:
location ~ [^/]\.php(/|$) {
root /var/www/html;
fastcgi_split_path_info ^(.+\.php)(/.+)$;
fastcgi_index index.php;
fastcgi_pass 127.0.0.1:9000; # or your php-fpm socket
include fastcgi_params;
fastcgi_param PATH_INFO $fastcgi_path_info;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
}
firewall-cmd --zone=public --add-port=80/tcp --permanent
firewall-cmd --reload
Click on calendar event caused
Error code: dmlreadexception
Fix:
calendar/lib.php line 3799
change
FROM {course}
to
FROM {course} c
e.g.
$sql = "SELECT
c.id, c.visible, {$ctxfields}
FROM {course} c
JOIN {context} ctx ON (ctx.instanceid = c.id AND ctx.contextlevel = :contextlevel)";
the "location ~ .php$" wont work, there's something after ".php": https://docs.moodle.org/37/en/Nginx