ILIAS-7-Install-Tutorial for Ubuntu 20.04

Configure MariaDB

  • MySQL or MariaDB?I used MySQL so far but switched now to MariaDB. So the new config path is: ย /etc/mysql/mariadb.conf.d
  • nano /etc/mysql/mariadb.conf.d/50-ilias.cnf
  • Add these lines and exit:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
[Service]
LimitMEMLOCK=infinity
LimitNOFILE=524288
TimeoutStartSec=600
ExecStartPre=/bin/sync
ExecStartPre=/sbin/sysctl -q -w vm.drop_caches=3
 
innodb_strict_mode=OFF
log_error = /var/log/mysql/error.log
slow_query_log_file    = /var/log/mysql/mariadb-slow.log
long_query_time        = 0.5
log_slow_rate_limit    = 1000
log_slow_verbosity     = query_plan,explain
default_storage_engine  = InnoDB
sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
 
[mysqld]
max_allowed_packet=1024M
  • systemctl restart mysql
  • systemctl restart apache2

Take a look at some parameters

  • mysql
  • SHOW VARIABLES;
    • Filter for some:
      • SHOW SESSION VARIABLES LIKE 'max_allowed_packet';
      • SHOW SESSION VARIABLES LIKE 'connect_timeout';
  • exit
  • Example output:


Information Message
No comment has been posted yet.